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 714: SELECT CSM_II_RELATIONSHIPS_ACC_S.NEXTVAL INTO l_acc_id_lst(J) FROM dual;

710: EXIT WHEN l_user_id_lst.COUNT=0;
711:
712: FOR J IN 1..l_user_id_lst.COUNT
713: LOOP
714: SELECT CSM_II_RELATIONSHIPS_ACC_S.NEXTVAL INTO l_acc_id_lst(J) FROM dual;
715: END LOOP;
716:
717: FORALL i IN 1..l_rel_id_lst.COUNT
718: INSERT INTO CSM_II_RELATIONSHIPS_ACC (ACCESS_ID, USER_ID, RELATIONSHIP_ID,