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

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

1888: NULL;
1889: ELSE
1890: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1891: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_CUST_ITEM_CUM_KEYS',FALSE);
1892: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1893:
1894: open merged_records;
1895: LOOP
1896: FETCH merged_records BULK COLLECT INTO

Line 1913: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));

1909: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1910: exit;
1911: END IF;
1912: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1913: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
1914:
1915: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
1916:
1917: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));

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

1911: END IF;
1912: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1913: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
1914:
1915: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
1916:
1917: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
1918:
1919: VCHAR_COL1_NEW_LIST(I) := VCHAR_COL1_ORIG_LIST(I);

Line 1917: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));

1913: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
1914:
1915: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
1916:
1917: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
1918:
1919: VCHAR_COL1_NEW_LIST(I) := VCHAR_COL1_ORIG_LIST(I);
1920: VCHAR_COL2_NEW_LIST(I) := VCHAR_COL2_ORIG_LIST(I);
1921: END LOOP;

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

2040: NULL;
2041: ELSE
2042: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2043: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_INTERFACE_HEADERS',FALSE);
2044: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2045:
2046: open merged_records;
2047: LOOP
2048: FETCH merged_records BULK COLLECT INTO

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

2060: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
2061: exit;
2062: END IF;
2063: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2064: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2065: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2066:
2067: select distinct customer_name into cust_name
2068: from ra_customer_merges

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

2061: exit;
2062: END IF;
2063: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2064: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2065: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2066:
2067: select distinct customer_name into cust_name
2068: from ra_customer_merges
2069: where customer_id = NUM_COL1_NEW_LIST(I)

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

2212: NULL;
2213: ELSE
2214: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2215: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_INTERFACE_LINES',FALSE);
2216: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2217:
2218: open merged_records;
2219: LOOP
2220: FETCH merged_records BULK COLLECT INTO

Line 2239: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));

2235: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
2236: exit;
2237: END IF;
2238: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2239: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
2240:
2241: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2242:
2243: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));

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

2237: END IF;
2238: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2239: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
2240:
2241: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2242:
2243: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
2244:
2245: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));

Line 2243: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));

2239: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
2240:
2241: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2242:
2243: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
2244:
2245: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
2246:
2247: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL5_ORIG_LIST(I));

Line 2245: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));

2241: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2242:
2243: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
2244:
2245: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
2246:
2247: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL5_ORIG_LIST(I));
2248:
2249: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));

Line 2247: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL5_ORIG_LIST(I));

2243: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
2244:
2245: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
2246:
2247: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL5_ORIG_LIST(I));
2248:
2249: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));
2250:
2251: VCHAR_COL1_NEW_LIST(I) := VCHAR_COL1_ORIG_LIST(I);

Line 2249: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));

2245: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
2246:
2247: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL5_ORIG_LIST(I));
2248:
2249: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));
2250:
2251: VCHAR_COL1_NEW_LIST(I) := VCHAR_COL1_ORIG_LIST(I);
2252: END LOOP;
2253: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

2379: NULL;
2380: ELSE
2381: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2382: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_SCHEDULE_HEADERS',FALSE);
2383: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2384:
2385: open merged_records;
2386: LOOP
2387: FETCH merged_records BULK COLLECT INTO

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

2399: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
2400: exit;
2401: END IF;
2402: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2403: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2404: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2405:
2406: select distinct customer_name into cust_name
2407: from ra_customer_merges

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

2400: exit;
2401: END IF;
2402: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2403: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2404: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2405:
2406: select distinct customer_name into cust_name
2407: from ra_customer_merges
2408: where customer_id = NUM_COL1_NEW_LIST(I)

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

2552: NULL;
2553: ELSE
2554: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2555: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_SCHEDULE_LINES',FALSE);
2556: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2557:
2558: open merged_records;
2559: LOOP
2560: FETCH merged_records BULK COLLECT INTO

Line 2579: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));

2575: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
2576: exit;
2577: END IF;
2578: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2579: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
2580:
2581: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2582:
2583: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));

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

2577: END IF;
2578: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
2579: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
2580:
2581: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2582:
2583: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
2584:
2585: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));

Line 2583: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));

2579: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
2580:
2581: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2582:
2583: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
2584:
2585: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
2586:
2587: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL5_ORIG_LIST(I));

Line 2585: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));

2581: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2582:
2583: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
2584:
2585: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
2586:
2587: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL5_ORIG_LIST(I));
2588:
2589: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));

Line 2587: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL5_ORIG_LIST(I));

2583: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
2584:
2585: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
2586:
2587: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL5_ORIG_LIST(I));
2588:
2589: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));
2590:
2591: VCHAR_COL1_NEW_LIST(I) := VCHAR_COL1_ORIG_LIST(I);

Line 2589: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));

2585: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
2586:
2587: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL5_ORIG_LIST(I));
2588:
2589: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));
2590:
2591: VCHAR_COL1_NEW_LIST(I) := VCHAR_COL1_ORIG_LIST(I);
2592: END LOOP;
2593: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN