APPS.OKC_PARTY_MERGE_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 98: -- Merge Procedure for OKC_K_PARTY_ROLES_B

94: -- that its merged to
95: -- x_return_status VARCHAR2 - Return the status of the procedure
96:
97: --
98: -- Merge Procedure for OKC_K_PARTY_ROLES_B
99: --
100: PROCEDURE OKC_CPL_MERGE_PARTY (
101: p_entity_name IN VARCHAR2,
102: p_from_id IN NUMBER,

Line 121: from okc_k_party_roles_b role1,okc_k_party_roles_b role2

117:
118: --npalepu added on 10-feb-2006 for bug # 5005475
119: cursor l_get_cpl_ids_csr is
120: select role1.id from_cpl_id, role2.id to_cpl_id
121: from okc_k_party_roles_b role1,okc_k_party_roles_b role2
122: where role1.cle_id = role2.cle_id
123: and role1.rle_code = role2.rle_code
124: and role1.jtot_object1_code = role2.jtot_object1_code
125: and role1.jtot_object1_code IN (SELECT ojt.object_code

Line 133: TYPE l_CPL_ID IS TABLE OF okc_k_party_roles_b.id%TYPE INDEX BY BINARY_INTEGER;

129: AND oue.object_user_code = l_object_user_code)
130: and role1.object1_id1 = p_from_fk_id
131: and role2.object1_id1 = p_to_fk_id;
132:
133: TYPE l_CPL_ID IS TABLE OF okc_k_party_roles_b.id%TYPE INDEX BY BINARY_INTEGER;
134: l_from_cpl_id l_CPL_ID;
135: l_to_cpl_id l_CPL_ID;
136: --end npalepu
137:

Line 199: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_party_roles_b');

195: begin
196:
197: arp_message.set_name('AR','AR_UPDATING_TABLE');
198: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES',FALSE);
199: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_party_roles_b');
200: --
201: --
202: -- Fix for bug 4105272 Insert into okc_k_vers_numbers_h
203: INSERT INTO OKC_K_VERS_NUMBERS_H(

Line 225: from okc_k_party_roles_b kpr

221: last_update_date,
222: last_update_login
223: FROM OKC_K_VERS_NUMBERS
224: WHERE chr_id IN (select dnz_chr_id
225: from okc_k_party_roles_b kpr
226: where kpr.object1_id1 = to_char(p_from_fk_id)
227: AND kpr.jtot_object1_code IN
228: (SELECT ojt.object_code
229: FROM jtf_objects_b ojt

Line 241: from okc_k_party_roles_b kpr

237: ,ver.last_update_date = SYSDATE
238: ,ver.last_updated_by = arp_standard.profile.user_id
239: ,ver.last_update_login = arp_standard.profile.last_update_login
240: WHERE chr_id IN (select dnz_chr_id
241: from okc_k_party_roles_b kpr
242: where kpr.object1_id1 = to_char(p_from_fk_id) -- added for Bug 3611998
243: AND kpr.jtot_object1_code IN (SELECT ojt.object_code
244: FROM jtf_objects_b ojt
245: ,jtf_object_usages oue

Line 294: DELETE FROM okc_k_party_roles_B role1

290: fnd_file.put_line(fnd_file.log, 'Deleting Table OKC_K_PARTY_ROLES');
291: -- Delete party_roles table to handle related party merge Bug # 4529376
292:
293: FORALL i IN l_from_cpl_id.FIRST .. l_from_cpl_id.LAST
294: DELETE FROM okc_k_party_roles_B role1
295: WHERE role1.id = l_from_cpl_id(i);
296:
297: l_count := sql%rowcount;
298: fnd_file.put_line(fnd_file.log, 'No of Rows Deleted : '||l_count);

Line 312: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_party_roles_b');

308: CLOSE l_get_cpl_ids_csr;
309: --end npalepu
310: --
311: --
312: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_party_roles_b');
313: UPDATE okc_k_party_roles_b kpr
314: SET kpr.object1_id1 = p_to_fk_id
315: ,kpr.object_version_number = kpr.object_version_number + 1
316: ,kpr.last_update_date = SYSDATE

Line 313: UPDATE okc_k_party_roles_b kpr

309: --end npalepu
310: --
311: --
312: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_party_roles_b');
313: UPDATE okc_k_party_roles_b kpr
314: SET kpr.object1_id1 = p_to_fk_id
315: ,kpr.object_version_number = kpr.object_version_number + 1
316: ,kpr.last_update_date = SYSDATE
317: ,kpr.last_updated_by = arp_standard.profile.user_id