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 RLM_INTERFACE_LINES

Line 391: FROM RLM_INTERFACE_LINES il,

387: m.duplicate_site_id,
388: m.customer_site_id,
389: m.duplicate_id,
390: m.customer_id
391: FROM RLM_INTERFACE_LINES il,
392: RA_CUSTOMER_MERGES m
393: WHERE m.process_flag = 'N'
394: AND m.request_id = req_id
395: AND m.set_number = set_num

Line 416: setARMessageLockTable('RLM_INTERFACE_LINES');

412: arp_message.set_line('RLM_CUST_MERGE.Interface_Lines()+' || getTimeStamp);
413: --
414: IF (process_mode = 'LOCK') THEN
415: --
416: setARMessageLockTable('RLM_INTERFACE_LINES');
417: --
418: open cust_merge_cur;
419: --
420: close cust_merge_cur;

Line 456: RLM_INTERFACE_LINES_LOG (

452: --
453: END LOOP;
454: --
455: /*2447493*/
456: RLM_INTERFACE_LINES_LOG (
457: req_id => req_id,
458: set_num=>set_num,
459: process_mode=>process_mode) ;
460: /*2447493*/

Line 461: setARMessageUpdateTable('RLM_INTERFACE_LINES');

457: req_id => req_id,
458: set_num=>set_num,
459: process_mode=>process_mode) ;
460: /*2447493*/
461: setARMessageUpdateTable('RLM_INTERFACE_LINES');
462: --
463: FORALL i IN l_lineIdTab.FIRST..l_lineIdTab.LAST
464: --
465: UPDATE RLM_INTERFACE_LINES

Line 465: UPDATE RLM_INTERFACE_LINES

461: setARMessageUpdateTable('RLM_INTERFACE_LINES');
462: --
463: FORALL i IN l_lineIdTab.FIRST..l_lineIdTab.LAST
464: --
465: UPDATE RLM_INTERFACE_LINES
466: SET
467: ship_to_customer_id = DECODE(ship_to_customer_id,
468: l_duplicateIdTab(i),
469: l_ShiptoCustomerIdTab(i),

Line 2131: PROCEDURE RLM_INTERFACE_LINES_LOG (

2127: RAISE;
2128: END RLM_INTERFACE_HEADERS_LOG;
2129:
2130:
2131: PROCEDURE RLM_INTERFACE_LINES_LOG (
2132: req_id NUMBER,
2133: set_num NUMBER,
2134: process_mode VARCHAR2) IS
2135:

Line 2142: RLM_INTERFACE_LINES.LINE_ID%TYPE

2138: INDEX BY BINARY_INTEGER;
2139: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
2140:
2141: TYPE LINE_ID_LIST_TYPE IS TABLE OF
2142: RLM_INTERFACE_LINES.LINE_ID%TYPE
2143: INDEX BY BINARY_INTEGER;
2144: PRIMARY_KEY_ID_LIST LINE_ID_LIST_TYPE;
2145:
2146: TYPE INTRMD_SHIP_TO_ID_LIST_TYPE IS TABLE OF

Line 2147: RLM_INTERFACE_LINES.INTRMD_SHIP_TO_ID%TYPE

2143: INDEX BY BINARY_INTEGER;
2144: PRIMARY_KEY_ID_LIST LINE_ID_LIST_TYPE;
2145:
2146: TYPE INTRMD_SHIP_TO_ID_LIST_TYPE IS TABLE OF
2147: RLM_INTERFACE_LINES.INTRMD_SHIP_TO_ID%TYPE
2148: INDEX BY BINARY_INTEGER;
2149: NUM_COL1_ORIG_LIST INTRMD_SHIP_TO_ID_LIST_TYPE;
2150: NUM_COL1_NEW_LIST INTRMD_SHIP_TO_ID_LIST_TYPE;
2151:

Line 2153: RLM_INTERFACE_LINES.SHIP_TO_ADDRESS_ID%TYPE

2149: NUM_COL1_ORIG_LIST INTRMD_SHIP_TO_ID_LIST_TYPE;
2150: NUM_COL1_NEW_LIST INTRMD_SHIP_TO_ID_LIST_TYPE;
2151:
2152: TYPE SHIP_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
2153: RLM_INTERFACE_LINES.SHIP_TO_ADDRESS_ID%TYPE
2154: INDEX BY BINARY_INTEGER;
2155: NUM_COL2_ORIG_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
2156: NUM_COL2_NEW_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
2157:

Line 2159: RLM_INTERFACE_LINES.BILL_TO_ADDRESS_ID%TYPE

2155: NUM_COL2_ORIG_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
2156: NUM_COL2_NEW_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
2157:
2158: TYPE BILL_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
2159: RLM_INTERFACE_LINES.BILL_TO_ADDRESS_ID%TYPE
2160: INDEX BY BINARY_INTEGER;
2161: NUM_COL3_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
2162: NUM_COL3_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
2163:

Line 2165: RLM_INTERFACE_LINES.SHIP_TO_ORG_ID%TYPE

2161: NUM_COL3_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
2162: NUM_COL3_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
2163:
2164: TYPE SHIP_TO_ORG_ID_LIST_TYPE IS TABLE OF
2165: RLM_INTERFACE_LINES.SHIP_TO_ORG_ID%TYPE
2166: INDEX BY BINARY_INTEGER;
2167: NUM_COL4_ORIG_LIST SHIP_TO_ORG_ID_LIST_TYPE;
2168: NUM_COL4_NEW_LIST SHIP_TO_ORG_ID_LIST_TYPE;
2169:

Line 2171: RLM_INTERFACE_LINES.INVOICE_TO_ORG_ID%TYPE

2167: NUM_COL4_ORIG_LIST SHIP_TO_ORG_ID_LIST_TYPE;
2168: NUM_COL4_NEW_LIST SHIP_TO_ORG_ID_LIST_TYPE;
2169:
2170: TYPE INVOICE_TO_ORG_ID_LIST_TYPE IS TABLE OF
2171: RLM_INTERFACE_LINES.INVOICE_TO_ORG_ID%TYPE
2172: INDEX BY BINARY_INTEGER;
2173: NUM_COL5_ORIG_LIST INVOICE_TO_ORG_ID_LIST_TYPE;
2174: NUM_COL5_NEW_LIST INVOICE_TO_ORG_ID_LIST_TYPE;
2175:

Line 2177: RLM_INTERFACE_LINES.INTMED_SHIP_TO_ORG_ID%TYPE

2173: NUM_COL5_ORIG_LIST INVOICE_TO_ORG_ID_LIST_TYPE;
2174: NUM_COL5_NEW_LIST INVOICE_TO_ORG_ID_LIST_TYPE;
2175:
2176: TYPE INT_SHIP_TO_ORG_ID_LIST_TYPE IS TABLE OF
2177: RLM_INTERFACE_LINES.INTMED_SHIP_TO_ORG_ID%TYPE
2178: INDEX BY BINARY_INTEGER;
2179: NUM_COL6_ORIG_LIST INT_SHIP_TO_ORG_ID_LIST_TYPE;
2180: NUM_COL6_NEW_LIST INT_SHIP_TO_ORG_ID_LIST_TYPE;
2181:

Line 2183: RLM_INTERFACE_LINES.ITEM_NOTE_TEXT%TYPE

2179: NUM_COL6_ORIG_LIST INT_SHIP_TO_ORG_ID_LIST_TYPE;
2180: NUM_COL6_NEW_LIST INT_SHIP_TO_ORG_ID_LIST_TYPE;
2181:
2182: TYPE ITEM_NOTE_TEXT_LIST_TYPE IS TABLE OF
2183: RLM_INTERFACE_LINES.ITEM_NOTE_TEXT%TYPE
2184: INDEX BY BINARY_INTEGER;
2185: VCHAR_COL1_ORIG_LIST ITEM_NOTE_TEXT_LIST_TYPE;
2186: VCHAR_COL1_NEW_LIST ITEM_NOTE_TEXT_LIST_TYPE;
2187:

Line 2198: FROM RLM_INTERFACE_LINES yt, ra_customer_merges m

2194: ,SHIP_TO_ORG_ID
2195: ,INVOICE_TO_ORG_ID
2196: ,INTMED_SHIP_TO_ORG_ID
2197: ,ITEM_NOTE_TEXT
2198: FROM RLM_INTERFACE_LINES yt, ra_customer_merges m
2199: WHERE (
2200: yt.INTRMD_SHIP_TO_ID = m.DUPLICATE_ADDRESS_ID
2201: OR yt.SHIP_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
2202: OR yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID

Line 2215: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_INTERFACE_LINES',FALSE);

2211: IF process_mode='LOCK' THEN
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

Line 2282: 'RLM_INTERFACE_LINES',

2278: LAST_UPDATE_LOGIN,
2279: LAST_UPDATE_DATE,
2280: LAST_UPDATED_BY
2281: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
2282: 'RLM_INTERFACE_LINES',
2283: MERGE_HEADER_ID_LIST(I),
2284: PRIMARY_KEY_ID_LIST(I),
2285: NUM_COL1_ORIG_LIST(I),
2286: NUM_COL1_NEW_LIST(I),

Line 2317: arp_message.set_line( 'RLM_INTERFACE_LINES_LOG');

2313:
2314: END IF;
2315: EXCEPTION
2316: WHEN OTHERS THEN
2317: arp_message.set_line( 'RLM_INTERFACE_LINES_LOG');
2318: RAISE;
2319: END RLM_INTERFACE_LINES_LOG;
2320:
2321: PROCEDURE RLM_SCHEDULE_HEADERS_LOG (

Line 2319: END RLM_INTERFACE_LINES_LOG;

2315: EXCEPTION
2316: WHEN OTHERS THEN
2317: arp_message.set_line( 'RLM_INTERFACE_LINES_LOG');
2318: RAISE;
2319: END RLM_INTERFACE_LINES_LOG;
2320:
2321: PROCEDURE RLM_SCHEDULE_HEADERS_LOG (
2322: req_id NUMBER,
2323: set_num NUMBER,