DBA Data[Home] [Help]

APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CSM_II_RELATIONSHIPS_ACC_S

Line 24: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_II_RELATIONSHIPS_ACC_S';

20: g_pub_item CONSTANT VARCHAR2(30) := 'CSF_M_ITEM_INSTANCES';
21:
22: g_table_name2 CONSTANT VARCHAR2(30) := 'CSI_II_RELATIONSHIPS';
23: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_II_RELATIONSHIPS_ACC';
24: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_II_RELATIONSHIPS_ACC_S';
25: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
26: CSM_ACC_PKG.t_publication_item_list('CSF_M_II_RELATIONSHIPS');
27: g_pk1_name2 CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
28: g_pub_item2 CONSTANT VARCHAR2(30) := 'CSF_M_II_RELATIONSHIPS';

Line 791: SELECT CSM_II_RELATIONSHIPS_ACC_S.NEXTVAL

787: IF l_rel_id_lst.COUNT >0 THEN
788:
789: FOR J IN 1..l_rel_id_lst.COUNT
790: LOOP
791: SELECT CSM_II_RELATIONSHIPS_ACC_S.NEXTVAL
792: INTO l_acc_id_lst(J)
793: FROM dual;
794: l_user_id_lst(J):=l_user_id_lst_bkp(I);
795: END LOOP;