DBA Data[Home] [Help]

APPS.CSP_RELATED_ITEMS_PKG dependencies on INV_ITEM_GRP

Line 11: x_error_tbl INV_ITEM_GRP.Error_tbl_type;

7: p_disposition IN VARCHAR2,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_error_msg OUT NOCOPY VARCHAR2) Is
10:
11: x_error_tbl INV_ITEM_GRP.Error_tbl_type;
12: Begin
13: CSP_RELATED_ITEMS_PKG.UPDATE_ITEM (p_item_id => p_item_id,
14: p_org_id => p_org_id,
15: p_disposition => p_disposition,

Line 30: x_error_tbl OUT NOCOPY INV_ITEM_GRP.Error_tbl_type) Is

26: PROCEDURE UPDATE_ITEM (p_item_id IN NUMBER,
27: p_org_id IN NUMBER,
28: p_disposition IN VARCHAR2,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_error_tbl OUT NOCOPY INV_ITEM_GRP.Error_tbl_type) Is
31:
32: l_item_rec INV_ITEM_GRP.Item_rec_type;
33: x_item_rec INV_ITEM_GRP.Item_rec_type;
34:

Line 32: l_item_rec INV_ITEM_GRP.Item_rec_type;

28: p_disposition IN VARCHAR2,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_error_tbl OUT NOCOPY INV_ITEM_GRP.Error_tbl_type) Is
31:
32: l_item_rec INV_ITEM_GRP.Item_rec_type;
33: x_item_rec INV_ITEM_GRP.Item_rec_type;
34:
35: cursor c_organizations is
36: select decode(mia.control_level,1,mp.master_organization_id,mp.organization_id)

Line 33: x_item_rec INV_ITEM_GRP.Item_rec_type;

29: x_return_status OUT NOCOPY VARCHAR2,
30: x_error_tbl OUT NOCOPY INV_ITEM_GRP.Error_tbl_type) Is
31:
32: l_item_rec INV_ITEM_GRP.Item_rec_type;
33: x_item_rec INV_ITEM_GRP.Item_rec_type;
34:
35: cursor c_organizations is
36: select decode(mia.control_level,1,mp.master_organization_id,mp.organization_id)
37: organization_id

Line 53: Inv_item_grp.Update_Item

49: l_item_rec.mtl_transactions_enabled_flag := p_disposition;
50:
51: for cr in c_organizations loop
52: l_item_rec.organization_id := cr.organization_id;
53: Inv_item_grp.Update_Item
54: (
55: p_commit => fnd_api.g_FALSE
56: , p_lock_rows => fnd_api.g_TRUE
57: , p_validation_level => fnd_api.g_VALID_LEVEL_FULL