APPS.CSM_CNTR_RELATION_EVENT_PKG dependencies on CSM_CNTR_RELATIONSHIPS_ACC

Line 13: g_cst_accnt_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_CNTR_RELATIONSHIPS_ACC';

9: -- MODIFICATION HISTORY
10: -- Person Date Comments
11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13: g_cst_accnt_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_CNTR_RELATIONSHIPS_ACC';
14: g_cst_accnt_table_name CONSTANT VARCHAR2(30) := 'CSI_COUNTER_RELATIONSHIPS';
15: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_CNTR_RELATIONSHIPS_ACC_S' ;
16: g_cst_accnt_pk1_name CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
17: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_CNTR_RELATIONSHIPS';

Line 15: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_CNTR_RELATIONSHIPS_ACC_S' ;

11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13: g_cst_accnt_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_CNTR_RELATIONSHIPS_ACC';
14: g_cst_accnt_table_name CONSTANT VARCHAR2(30) := 'CSI_COUNTER_RELATIONSHIPS';
15: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_CNTR_RELATIONSHIPS_ACC_S' ;
16: g_cst_accnt_pk1_name CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
17: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_CNTR_RELATIONSHIPS';
18: g_accnt_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_CNTR_RELATIONSHIPS');

Line 40: FROM CSM_CNTR_RELATIONSHIPS_ACC acc

36: WHERE source_counter_id = l_counter_id
37: AND NOT EXISTS
38: (
39: SELECT 1
40: FROM CSM_CNTR_RELATIONSHIPS_ACC acc
41: WHERE acc.relationship_id = b.relationship_id
42: AND acc.user_id = l_user_id
43: );
44: BEGIN

Line 92: CSM_CNTR_RELATIONSHIPS_ACC acc

88: CURSOR csr_cntr_rel_del(l_counter_id NUMBER,l_user_id NUMBER)
89: IS
90: SELECT acc.relationship_id
91: FROM csi_counter_relationships b,
92: CSM_CNTR_RELATIONSHIPS_ACC acc
93: WHERE b.source_counter_id = l_counter_id
94: AND acc.user_id = l_user_id
95: AND acc.relationship_id = b.relationship_id
96: AND NOT EXISTS