DBA Data[Home] [Help]

APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CSM_ITEM_INSTANCES_ACC_S

Line 16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';

12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
20: g_pub_item CONSTANT VARCHAR2(30) := 'CSF_M_ITEM_INSTANCES';

Line 370: SELECT CSM_ITEM_INSTANCES_ACC_S.NEXTVAL as access_id,

366:
367: -- get all the trackable items that exists in the csm_mtl_onhand_acc table
368: CURSOR l_ins_item_instances_csr
369: IS
370: SELECT CSM_ITEM_INSTANCES_ACC_S.NEXTVAL as access_id,
371: cqa.user_id,
372: cii.instance_id,
373: civ.version_label,
374: CIR.OBJECT_ID