APPS.CSM_MTL_SEC_INV_EVENT_PKG dependencies on CSM_MTL_SEC_INV_ACC_S

Line 17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC_S';

13: -- Enter procedure, function bodies as shown below
14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_SEC_INVENTORIES';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SEC_INVENTORIES');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY_NAME';
21: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 177: select CSM_MTL_SEC_INV_ACC_S.nextval as access_id,au.user_id , csi.organization_id,csi.secondary_inventory_name

173: AND csi.organization_id = acc.organization_id
174: AND csi.last_update_date >= p_last_upd_date;
175:
176: CURSOR c_ins_cur IS -- sub inventories of dest org
177: select CSM_MTL_SEC_INV_ACC_S.nextval as access_id,au.user_id , csi.organization_id,csi.secondary_inventory_name
178: from csp_sec_inventories csi,asg_user au
179: where au.enabled='Y' and au.multi_platform='Y'
180: --AND csi.CONDITION_TYPE='G'
181: AND EXISTS(SELECT 1 FROM mtl_secondary_inventories msi WHERE csi.organization_id=msi.organization_id AND csi.secondary_inventory_name=msi.secondary_inventory_name