--新增
INV_ITEM_REVISION_PUB.Create_Item_Revision
(
p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
, p_commit IN VARCHAR2 := FND_API.G_FALSE
, p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
, p_process_control IN VARCHAR2 := NULL
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_Item_Revision_rec IN OUT NOCOPY Item_Revision_rec_type
)
--更新
INV_ITEM_REVISION_PUB.Update_Item_Revision
(
p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
, p_commit IN VARCHAR2 := FND_API.g_FALSE
, p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
, p_process_control IN VARCHAR2 := NULL
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_Item_Revision_rec IN OUT NOCOPY Item_Revision_rec_type
)
--删除
INV_ITEM_REVISION_PUB.Delete_Item_Revision
(
p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
, p_commit IN VARCHAR2 := FND_API.g_FALSE
, p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_inventory_item_id IN NUMBER
, p_organization_id IN NUMBER
, p_revision IN VARCHAR2
, p_object_version_number IN NUMBER
)
--锁定
INV_ITEM_REVISION_PUB.Lock_Item_Revision
(
p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_inventory_item_id IN NUMBER
, p_organization_id IN NUMBER
, p_revision IN VARCHAR2
, p_object_version_number IN NUMBER
)
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步