eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PARTY_MERGE_PUB dependencies on HZ_ACCT_MERGE_UTIL

Line 3487: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

3483: NULL;
3484: ELSE
3485: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3486: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_LEASE_OPPORTUNITIES_B',FALSE);
3487: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3488: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3489:
3490: OPEN merged_records;
3491: LOOP

Line 3505: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

3501: EXIT;
3502: END IF;
3503: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT
3504: LOOP
3505: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
3506: IF(NOT CHECK_IF_SAME_PARTY(NUM_COL1_ORIG_LIST(I), NUM_COL1_NEW_LIST(I)))
3507: THEN
3508: SELECT PARTY_ID INTO PROSPECT_ID_LIST(I)
3509: FROM HZ_CUST_ACCOUNTS_ALL

Line 4017: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

4013: NULL;
4014: ELSE
4015: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
4016: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_LEASE_APPLICATIONS_B',FALSE);
4017: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4018: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4019:
4020: OPEN merged_records;
4021: LOOP

Line 4035: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

4031: EXIT;
4032: END IF;
4033: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT
4034: LOOP
4035: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
4036: IF(NOT CHECK_IF_SAME_PARTY(NUM_COL1_ORIG_LIST(I), NUM_COL1_NEW_LIST(I)))
4037: THEN
4038: SELECT PARTY_ID INTO PROSPECT_ID_LIST(I)
4039: FROM HZ_CUST_ACCOUNTS_ALL

Line 4307: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

4303: NULL;
4304: ELSE
4305: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
4306: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_EXT_SELL_INVS_B',FALSE);
4307: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4308: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4309:
4310: open merged_records;
4311: LOOP

Line 4325: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

4321: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
4322: exit;
4323: END IF;
4324: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
4325: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
4326: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
4327:
4328: END LOOP;
4329: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

Line 4326: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));

4322: exit;
4323: END IF;
4324: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
4325: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
4326: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
4327:
4328: END LOOP;
4329: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4330: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 4512: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

4508: NULL;
4509: ELSE
4510: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
4511: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TAX_SOURCES_T',FALSE);
4512: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4513: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4514:
4515: open merged_records;
4516: LOOP

Line 4531: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

4527: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
4528: exit;
4529: END IF;
4530: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
4531: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
4532: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
4533: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
4534:
4535: OPEN tax_src_dtls_csr(PRIMARY_KEY_ID_LIST(I));

Line 4532: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));

4528: exit;
4529: END IF;
4530: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
4531: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
4532: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
4533: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
4534:
4535: OPEN tax_src_dtls_csr(PRIMARY_KEY_ID_LIST(I));
4536: FETCH tax_src_dtls_csr INTO

Line 4533: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));

4529: END IF;
4530: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
4531: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
4532: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
4533: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
4534:
4535: OPEN tax_src_dtls_csr(PRIMARY_KEY_ID_LIST(I));
4536: FETCH tax_src_dtls_csr INTO
4537: BT_PAR_ID_ORIG_LIST(I),

Line 4789: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

4785: NULL;
4786: ELSE
4787: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
4788: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TAX_SOURCES',FALSE);
4789: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4790: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4791:
4792: open merged_records;
4793: LOOP

Line 4808: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

4804: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
4805: exit;
4806: END IF;
4807: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
4808: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
4809: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
4810: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
4811:
4812: OPEN tax_src_dtls_csr(PRIMARY_KEY_ID_LIST(I));

Line 4809: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));

4805: exit;
4806: END IF;
4807: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
4808: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
4809: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
4810: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
4811:
4812: OPEN tax_src_dtls_csr(PRIMARY_KEY_ID_LIST(I));
4813: FETCH tax_src_dtls_csr INTO

Line 4810: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));

4806: END IF;
4807: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
4808: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
4809: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
4810: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
4811:
4812: OPEN tax_src_dtls_csr(PRIMARY_KEY_ID_LIST(I));
4813: FETCH tax_src_dtls_csr INTO
4814: BT_PAR_ID_ORIG_LIST(I),

Line 5004: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

5000: NULL;
5001: ELSE
5002: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5003: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TRX_AR_INVOICES_B',FALSE);
5004: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5005: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5006:
5007: open merged_records;
5008: LOOP

Line 5022: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));

5018: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
5019: exit;
5020: END IF;
5021: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
5022: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
5023: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
5024: END LOOP;
5025: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5026: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 5023: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));

5019: exit;
5020: END IF;
5021: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
5022: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
5023: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
5024: END LOOP;
5025: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5026: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5027: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 5138: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

5134: NULL;
5135: ELSE
5136: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5137: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TXL_RCPT_APPS_B',FALSE);
5138: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5139: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5140:
5141: open merged_records;
5142: LOOP

Line 5155: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

5151: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
5152: exit;
5153: END IF;
5154: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
5155: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
5156: END LOOP;
5157: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5158: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5159: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 5273: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

5269: NULL;
5270: ELSE
5271: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5272: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_CNSLD_AR_HDRS_B',FALSE);
5273: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5274: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5275:
5276: open merged_records;
5277: LOOP

Line 5291: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

5287: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
5288: exit;
5289: END IF;
5290: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
5291: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
5292: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
5293: END LOOP;
5294: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5295: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 5292: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));

5288: exit;
5289: END IF;
5290: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
5291: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
5292: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
5293: END LOOP;
5294: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5295: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5296: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 5407: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

5403: NULL;
5404: ELSE
5405: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5406: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_CNTR_LVLNG_GRPS_B',FALSE);
5407: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5408: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5409:
5410: open merged_records;
5411: LOOP

Line 5424: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

5420: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
5421: exit;
5422: END IF;
5423: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
5424: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
5425: END LOOP;
5426: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5427: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5428: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 5527: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

5523: NULL;
5524: ELSE
5525: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5526: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_ACCT_SOURCES',FALSE);
5527: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5528: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5529:
5530: open merged_records;
5531: LOOP

Line 5544: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));

5540: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
5541: exit;
5542: END IF;
5543: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
5544: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
5545: END LOOP;
5546: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5547: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5548: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 5650: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

5646: NULL;
5647: ELSE
5648: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5649: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_SUPP_INVOICE_DTLS',FALSE);
5650: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5651: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5652:
5653: open merged_records;
5654: LOOP

Line 5667: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));

5663: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
5664: exit;
5665: END IF;
5666: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
5667: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
5668: END LOOP;
5669: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5670: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5671: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 5770: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

5766: NULL;
5767: ELSE
5768: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5769: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_SUPP_INVOICE_DTLS_H',FALSE);
5770: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5771: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5772:
5773: open merged_records;
5774: LOOP

Line 5787: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));

5783: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
5784: exit;
5785: END IF;
5786: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
5787: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
5788: END LOOP;
5789: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5790: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5791: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 6314: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

6310: NULL;
6311: ELSE
6312: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
6313: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKC_RULES_B',FALSE);
6314: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6315: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6316:
6317: OPEN merged_records;
6318: LOOP

Line 6333: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

6329: exit;
6330: END IF;
6331: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT
6332: LOOP
6333: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
6334:
6335: -- get the party of the new customer account
6336: OPEN get_new_party(NUM_COL1_NEW_LIST(I));
6337: FETCH get_new_party INTO NUM_RUL_OBJ1_NEW_LIST(I);