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.PNP_CMERGE dependencies on HZ_ACCT_MERGE_UTIL

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

354: NULL;
355: ELSE
356: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
357: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_LEASES',FALSE);
358: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
359: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
360:
361: OPEN merged_records;
362:

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

376: exit;
377: END IF;
378:
379: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
380: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
381: END LOOP;
382:
383: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
384: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

517: NULL;
518: ELSE
519: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
520: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TENANCIES',FALSE);
521: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
522: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
523:
524: OPEN merged_records;
525:

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

540: EXIT;
541: END IF;
542:
543: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
544: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
545: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
546: END LOOP;
547:
548: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

541: END IF;
542:
543: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
544: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
545: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
546: END LOOP;
547:
548: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
549: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

688: NULL;
689: ELSE
690: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
691: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TENANCIES_HISTORY',FALSE);
692: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
693: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
694:
695: OPEN merged_records;
696:

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

711: EXIT;
712: END IF;
713:
714: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
715: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
716: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
717: END LOOP;
718:
719: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

712: END IF;
713:
714: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
715: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
716: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
717: END LOOP;
718:
719: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
720: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

867: NULL;
868: ELSE
869: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
870: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TERM_TEMPLATES',FALSE);
871: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
872: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
873:
874: OPEN merged_records;
875:

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

890: EXIT;
891: END IF;
892:
893: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
894: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
895: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
896: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
897: END LOOP;
898:

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

891: END IF;
892:
893: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
894: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
895: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
896: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
897: END LOOP;
898:
899: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

892:
893: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
894: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
895: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
896: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
897: END LOOP;
898:
899: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
900: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

1054: NULL;
1055: ELSE
1056: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1057: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_PAYMENT_TERMS',FALSE);
1058: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1059: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1060:
1061: OPEN merged_records;
1062:

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

1077: EXIT;
1078: END IF;
1079:
1080: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1081: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1082: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1083: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1084: END LOOP;
1085:

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

1078: END IF;
1079:
1080: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1081: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1082: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1083: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1084: END LOOP;
1085:
1086: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

1079:
1080: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1081: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1082: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1083: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1084: END LOOP;
1085:
1086: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1087: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

1239: NULL;
1240: ELSE
1241: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1242: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_PAYMENT_ITEMS',FALSE);
1243: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1244: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1245:
1246: OPEN merged_records;
1247:

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

1263: EXIT;
1264: END IF;
1265:
1266: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1267: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1268: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1269: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1270: END LOOP;
1271:

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

1264: END IF;
1265:
1266: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1267: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1268: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1269: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1270: END LOOP;
1271:
1272: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

1265:
1266: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1267: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1268: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1269: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1270: END LOOP;
1271:
1272: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1273: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

1414: NULL;
1415: ELSE
1416: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1417: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_AGREEMENTS',FALSE);
1418: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1419: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1420:
1421: OPEN merged_records;
1422:

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

1436: EXIT;
1437: END IF;
1438:
1439: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1440: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1441: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1442: END LOOP;
1443:
1444: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

1437: END IF;
1438:
1439: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1440: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1441: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1442: END LOOP;
1443:
1444: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1445: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT

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

1573: NULL;
1574: ELSE
1575: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1576: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_ARCL_DTLLN',FALSE);
1577: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1578: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1579:
1580: OPEN merged_records;
1581:

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

1595: EXIT;
1596: END IF;
1597:
1598: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1599: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1600: END LOOP;
1601:
1602: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1603: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

1724: NULL;
1725: ELSE
1726: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1727: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_EXPCL_DTLLN',FALSE);
1728: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1729: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1730:
1731: OPEN merged_records;
1732:

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

1746: EXIT;
1747: END IF;
1748:
1749: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1750: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1751: END LOOP;
1752:
1753: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1754: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

1874: NULL;
1875: ELSE
1876: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1877: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_PERIOD_LINES',FALSE);
1878: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1879: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1880:
1881: OPEN merged_records;
1882:

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

1895: EXIT;
1896: END IF;
1897:
1898: FOR I IN 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1899: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1900: END LOOP;
1901:
1902: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1903: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT

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

2035: NULL;
2036: ELSE
2037: arp_message.set_name('AR','AR_UPDATING_TABLE');
2038: arp_message.set_token('TABLE_NAME','PN_SPACE_ASSIGN_CUST',FALSE);
2039: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2040: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2041:
2042: OPEN merged_records;
2043:

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

2058: EXIT;
2059: END IF;
2060:
2061: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2062: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2063: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
2064: END LOOP;
2065:
2066: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

2059: END IF;
2060:
2061: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2062: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2063: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
2064: END LOOP;
2065:
2066: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2067: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT