APPS.CSL_PARTY_CONTACTS_ACC_PKG dependencies on HZ_RELATIONSHIPS

Line 96: l_table_name CONSTANT VARCHAR2(30) := 'HZ_RELATIONSHIPS';

92: */
93: PROCEDURE INSERT_HZ_RELATIONSHIP( p_party_id IN NUMBER
94: , p_resource_id IN NUMBER )
95: IS
96: l_table_name CONSTANT VARCHAR2(30) := 'HZ_RELATIONSHIPS';
97: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_RELATIONSHIPS_ACC';
98: l_pk1_name CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
99: l_pk2_name CONSTANT VARCHAR2(30) := 'DIRECTIONAL_FLAG';
100: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

Line 97: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_RELATIONSHIPS_ACC';

93: PROCEDURE INSERT_HZ_RELATIONSHIP( p_party_id IN NUMBER
94: , p_resource_id IN NUMBER )
95: IS
96: l_table_name CONSTANT VARCHAR2(30) := 'HZ_RELATIONSHIPS';
97: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_RELATIONSHIPS_ACC';
98: l_pk1_name CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
99: l_pk2_name CONSTANT VARCHAR2(30) := 'DIRECTIONAL_FLAG';
100: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
101: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_RELATIONSHIPS');

Line 101: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_RELATIONSHIPS');

97: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_RELATIONSHIPS_ACC';
98: l_pk1_name CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
99: l_pk2_name CONSTANT VARCHAR2(30) := 'DIRECTIONAL_FLAG';
100: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
101: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_RELATIONSHIPS');
102:
103:
104: CURSOR c_relationship( b_party_id NUMBER )
105: IS

Line 107: FROM HZ_RELATIONSHIPS

103:
104: CURSOR c_relationship( b_party_id NUMBER )
105: IS
106: SELECT *
107: FROM HZ_RELATIONSHIPS
108: WHERE PARTY_ID = b_party_id
109: AND DIRECTIONAL_FLAG = 'F';
110:
111: r_relationship c_relationship%ROWTYPE;

Line 177: l_table_name CONSTANT VARCHAR2(30) := 'HZ_RELATIONSHIPS';

173: */
174: PROCEDURE DELETE_HZ_RELATIONSHIP( p_party_id IN NUMBER
175: , p_resource_id IN NUMBER )
176: IS
177: l_table_name CONSTANT VARCHAR2(30) := 'HZ_RELATIONSHIPS';
178: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_RELATIONSHIPS_ACC';
179: l_pk1_name CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
180: l_pk2_name CONSTANT VARCHAR2(30) := 'DIRECTIONAL_FLAG';
181: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

Line 178: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_RELATIONSHIPS_ACC';

174: PROCEDURE DELETE_HZ_RELATIONSHIP( p_party_id IN NUMBER
175: , p_resource_id IN NUMBER )
176: IS
177: l_table_name CONSTANT VARCHAR2(30) := 'HZ_RELATIONSHIPS';
178: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_RELATIONSHIPS_ACC';
179: l_pk1_name CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
180: l_pk2_name CONSTANT VARCHAR2(30) := 'DIRECTIONAL_FLAG';
181: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
182: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_RELATIONSHIPS');

Line 182: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_RELATIONSHIPS');

178: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_RELATIONSHIPS_ACC';
179: l_pk1_name CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
180: l_pk2_name CONSTANT VARCHAR2(30) := 'DIRECTIONAL_FLAG';
181: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
182: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_RELATIONSHIPS');
183:
184: CURSOR c_relationship( b_party_id NUMBER )
185: IS
186: SELECT *

Line 187: FROM HZ_RELATIONSHIPS

183:
184: CURSOR c_relationship( b_party_id NUMBER )
185: IS
186: SELECT *
187: FROM HZ_RELATIONSHIPS
188: WHERE PARTY_ID = b_party_id
189: AND DIRECTIONAL_FLAG = 'F';
190:
191: r_relationship c_relationship%ROWTYPE;