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_SCHEDULE_HEADERS

Line 556: FROM RLM_SCHEDULE_HEADERS sh,

552: m.customer_id,
553: m.duplicate_address_id,
554: m.customer_address_id,
555: m.customer_name
556: FROM RLM_SCHEDULE_HEADERS sh,
557: RA_CUSTOMER_MERGES m
558: WHERE m.process_flag = 'N'
559: AND m.request_id = req_id
560: AND m.set_number = set_num

Line 579: setARMessageLockTable('RLM_SCHEDULE_HEADERS');

575: arp_message.set_line('RLM_CUST_MERGE.Schedule_Headers()+' || getTimeStamp);
576: --
577: IF (process_mode = 'LOCK') THEN
578: --
579: setARMessageLockTable('RLM_SCHEDULE_HEADERS');
580: open cust_merge_cur;
581: close cust_merge_cur;
582: --
583: ELSE

Line 616: RLM_SCHEDULE_HEADERS_LOG (

612: --
613: END LOOP;
614: --
615: /*2447493*/
616: RLM_SCHEDULE_HEADERS_LOG (
617: req_id=>req_id,
618: set_num=>set_num,
619: process_mode=>process_mode);
620: /*2447493*/

Line 621: setARMessageUpdateTable('RLM_SCHEDULE_HEADERS');

617: req_id=>req_id,
618: set_num=>set_num,
619: process_mode=>process_mode);
620: /*2447493*/
621: setARMessageUpdateTable('RLM_SCHEDULE_HEADERS');
622: --
623: FORALL i IN l_headerIdTab.FIRST..l_headerIdTab.LAST
624: --
625: UPDATE RLM_SCHEDULE_HEADERS

Line 625: UPDATE RLM_SCHEDULE_HEADERS

621: setARMessageUpdateTable('RLM_SCHEDULE_HEADERS');
622: --
623: FORALL i IN l_headerIdTab.FIRST..l_headerIdTab.LAST
624: --
625: UPDATE RLM_SCHEDULE_HEADERS
626: SET customer_id = DECODE(customer_id,
627: l_duplicateIdTab(i),
628: l_customerIdTab(i),
629: customer_id

Line 2321: PROCEDURE RLM_SCHEDULE_HEADERS_LOG (

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,
2324: process_mode VARCHAR2) IS
2325:

Line 2334: RLM_SCHEDULE_HEADERS.HEADER_ID%TYPE

2330: INDEX BY BINARY_INTEGER;
2331: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
2332:
2333: TYPE HEADER_ID_LIST_TYPE IS TABLE OF
2334: RLM_SCHEDULE_HEADERS.HEADER_ID%TYPE
2335: INDEX BY BINARY_INTEGER;
2336: PRIMARY_KEY_ID_LIST HEADER_ID_LIST_TYPE;
2337:
2338: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 2339: RLM_SCHEDULE_HEADERS.CUSTOMER_ID%TYPE

2335: INDEX BY BINARY_INTEGER;
2336: PRIMARY_KEY_ID_LIST HEADER_ID_LIST_TYPE;
2337:
2338: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
2339: RLM_SCHEDULE_HEADERS.CUSTOMER_ID%TYPE
2340: INDEX BY BINARY_INTEGER;
2341: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
2342: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
2343:

Line 2345: RLM_SCHEDULE_HEADERS.ECE_PRIMARY_ADDRESS_ID%TYPE

2341: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
2342: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
2343:
2344: TYPE ECE_PRIMARY_ADD_ID_LIST_TYPE IS TABLE OF
2345: RLM_SCHEDULE_HEADERS.ECE_PRIMARY_ADDRESS_ID%TYPE
2346: INDEX BY BINARY_INTEGER;
2347: NUM_COL2_ORIG_LIST ECE_PRIMARY_ADD_ID_LIST_TYPE;
2348: NUM_COL2_NEW_LIST ECE_PRIMARY_ADD_ID_LIST_TYPE;
2349:

Line 2351: RLM_SCHEDULE_HEADERS.CUST_NAME_EXT%TYPE

2347: NUM_COL2_ORIG_LIST ECE_PRIMARY_ADD_ID_LIST_TYPE;
2348: NUM_COL2_NEW_LIST ECE_PRIMARY_ADD_ID_LIST_TYPE;
2349:
2350: TYPE CUST_NAME_EXT_LIST_TYPE IS TABLE OF
2351: RLM_SCHEDULE_HEADERS.CUST_NAME_EXT%TYPE
2352: INDEX BY BINARY_INTEGER;
2353: VCHAR_COL1_ORIG_LIST CUST_NAME_EXT_LIST_TYPE;
2354: VCHAR_COL1_NEW_LIST CUST_NAME_EXT_LIST_TYPE;
2355:

Line 2357: RLM_SCHEDULE_HEADERS.HEADER_NOTE_TEXT%TYPE

2353: VCHAR_COL1_ORIG_LIST CUST_NAME_EXT_LIST_TYPE;
2354: VCHAR_COL1_NEW_LIST CUST_NAME_EXT_LIST_TYPE;
2355:
2356: TYPE HEADER_NOTE_TEXT_LIST_TYPE IS TABLE OF
2357: RLM_SCHEDULE_HEADERS.HEADER_NOTE_TEXT%TYPE
2358: INDEX BY BINARY_INTEGER;
2359: VCHAR_COL2_ORIG_LIST HEADER_NOTE_TEXT_LIST_TYPE;
2360: VCHAR_COL2_NEW_LIST HEADER_NOTE_TEXT_LIST_TYPE;
2361:

Line 2369: FROM RLM_SCHEDULE_HEADERS yt, ra_customer_merges m

2365: ,yt.CUSTOMER_ID
2366: ,ECE_PRIMARY_ADDRESS_ID
2367: ,CUST_NAME_EXT
2368: ,HEADER_NOTE_TEXT
2369: FROM RLM_SCHEDULE_HEADERS yt, ra_customer_merges m
2370: WHERE (
2371: yt.CUSTOMER_ID = m.DUPLICATE_ID
2372: OR yt.ECE_PRIMARY_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
2373: ) AND m.process_flag = 'N'

Line 2382: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_SCHEDULE_HEADERS',FALSE);

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

Line 2437: 'RLM_SCHEDULE_HEADERS',

2433: LAST_UPDATE_LOGIN,
2434: LAST_UPDATE_DATE,
2435: LAST_UPDATED_BY
2436: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
2437: 'RLM_SCHEDULE_HEADERS',
2438: MERGE_HEADER_ID_LIST(I),
2439: PRIMARY_KEY_ID_LIST(I),
2440: NUM_COL1_ORIG_LIST(I),
2441: NUM_COL1_NEW_LIST(I),

Line 2466: arp_message.set_line( 'RLM_SCHEDULE_HEADERS_LOG');

2462:
2463: END IF;
2464: EXCEPTION
2465: WHEN OTHERS THEN
2466: arp_message.set_line( 'RLM_SCHEDULE_HEADERS_LOG');
2467: RAISE;
2468: END RLM_SCHEDULE_HEADERS_LOG;
2469:
2470:

Line 2468: END RLM_SCHEDULE_HEADERS_LOG;

2464: EXCEPTION
2465: WHEN OTHERS THEN
2466: arp_message.set_line( 'RLM_SCHEDULE_HEADERS_LOG');
2467: RAISE;
2468: END RLM_SCHEDULE_HEADERS_LOG;
2469:
2470:
2471: PROCEDURE RLM_SCHEDULE_LINES_LOG (
2472: req_id NUMBER,