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 122: from okc_k_party_roles_b role1,okc_k_party_roles_b role2

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

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

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

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

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

Line 226: from okc_k_party_roles_b kpr

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

Line 242: from okc_k_party_roles_b kpr

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

Line 295: DELETE FROM okc_k_party_roles_B role1

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

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

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

Line 314: UPDATE okc_k_party_roles_b kpr

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