APPS.CSM_CNTR_RELATION_EVENT_PKG dependencies on CSI_COUNTER_RELATIONSHIPS

Line 14: g_cst_accnt_table_name CONSTANT VARCHAR2(30) := 'CSI_COUNTER_RELATIONSHIPS';

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';
18: g_accnt_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 29: l_relationship_id CSI_COUNTER_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;

25: --variable declarations
26: l_sqlerrno VARCHAR2(20);
27: l_sqlerrmsg varchar2(2000);
28: l_mark_dirty boolean;
29: l_relationship_id CSI_COUNTER_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
30: --Cursor Declarations
31: --Insert Cursor
32: CURSOR csr_cntr_rel_ins(l_counter_id NUMBER,l_user_id NUMBER)
33: IS

Line 35: FROM csi_counter_relationships b

31: --Insert Cursor
32: CURSOR csr_cntr_rel_ins(l_counter_id NUMBER,l_user_id NUMBER)
33: IS
34: SELECT b.relationship_id
35: FROM csi_counter_relationships b
36: WHERE source_counter_id = l_counter_id
37: AND NOT EXISTS
38: (
39: SELECT 1

Line 83: l_relationship_id CSI_COUNTER_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;

79: --variable declarations
80: l_sqlerrno VARCHAR2(20);
81: l_sqlerrmsg varchar2(2000);
82: l_mark_dirty boolean;
83: l_relationship_id CSI_COUNTER_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
84: --Cursor Declarations
85: --Insert Cursor
86: --delete the relationship for the counter only if the counter access table does not contain
87: --the counter id that is corresponding to the mapping(source_counter_id)

Line 91: FROM csi_counter_relationships b,

87: --the counter id that is corresponding to the mapping(source_counter_id)
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