• 物料REVISION控制


    --新增
    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
    )
    
    

  • 相关阅读:
    亚马逊云IoT平台接入开发记录
    pip下载速度慢更换清华源试试
    gitlab回归上一次提交
    uos桌面壁纸存放路径
    python中json中的dump和dumps
    Python中的类中__dict__方法
    C++ | 数组反转的三种方法
    《C++Primer Plus》 | 复合类型
    pwn 中的函数 | 持续更新
    七月安恒DASCTF | 复现
  • 原文地址:https://www.cnblogs.com/wanghang/p/6299497.html
Copyright © 2020-2023  润新知