54: NULL;
55: ELSE
56: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
57: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_PDUE_F',FALSE);
58: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
59: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
60:
61: open merged_records;
62: LOOP
72: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
73: exit;
74: END IF;
75: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
76: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
77: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
78:
79: select party_id into l_new_party_id
80: from hz_cust_accounts
73: exit;
74: END IF;
75: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
76: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
77: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
78:
79: select party_id into l_new_party_id
80: from hz_cust_accounts
81: where cust_account_id = NUM_COL1_NEW_LIST(I);
192: NULL;
193: ELSE
194: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
195: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_PDUE2_F',FALSE);
196: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
197: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
198:
199: open merged_records;
200: LOOP
210: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
211: exit;
212: END IF;
213: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
214: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
215: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
216:
217: select party_id into l_new_party_id
218: from hz_cust_accounts
211: exit;
212: END IF;
213: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
214: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
215: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
216:
217: select party_id into l_new_party_id
218: from hz_cust_accounts
219: where cust_account_id = NUM_COL1_NEW_LIST(I);
330: NULL;
331: ELSE
332: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
333: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_BKORD_F',FALSE);
334: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
335: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
336:
337: open merged_records;
338: LOOP
348: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
349: exit;
350: END IF;
351: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
352: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
353: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
354:
355: select party_id into l_new_party_id
356: from hz_cust_accounts
349: exit;
350: END IF;
351: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
352: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
353: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
354:
355: select party_id into l_new_party_id
356: from hz_cust_accounts
357: where cust_account_id = NUM_COL1_NEW_LIST(I);