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_HEADERS

Line 246: FROM RLM_INTERFACE_HEADERS ih,

242: m.duplicate_address_id,
243: m.customer_address_id,
244: --bug 2171856
245: m.customer_name
246: FROM RLM_INTERFACE_HEADERS ih,
247: RA_CUSTOMER_MERGES m
248: WHERE m.process_flag = 'N'
249: AND m.request_id = req_id
250: AND m.set_number = set_num

Line 271: setARMessageLockTable('RLM_INTERFACE_HEADERS');

267: --
268:
269: IF (process_mode = 'LOCK') THEN
270: --
271: setARMessageLockTable('RLM_INTERFACE_HEADERS');
272: --
273: open cust_merge_cur;
274: close cust_merge_cur;
275: --

Line 309: RLM_INTERFACE_HEADERS_LOG (

305: --
306: END LOOP;
307: --
308: /*2447493*/
309: RLM_INTERFACE_HEADERS_LOG (
310: req_id=>req_id,
311: set_num=>set_num,
312: process_mode=>process_mode);
313: /*2447493*/

Line 314: setARMessageUpdateTable('RLM_INTERFACE_HEADERS');

310: req_id=>req_id,
311: set_num=>set_num,
312: process_mode=>process_mode);
313: /*2447493*/
314: setARMessageUpdateTable('RLM_INTERFACE_HEADERS');
315: --
316: FORALL i IN l_headerIdTab.FIRST..l_headerIdTab.LAST
317: --
318: UPDATE RLM_INTERFACE_HEADERS

Line 318: UPDATE RLM_INTERFACE_HEADERS

314: setARMessageUpdateTable('RLM_INTERFACE_HEADERS');
315: --
316: FORALL i IN l_headerIdTab.FIRST..l_headerIdTab.LAST
317: --
318: UPDATE RLM_INTERFACE_HEADERS
319: SET customer_id = DECODE(customer_id,
320: l_duplicateIdTab(i),
321: l_customerIdTab(i),
322: customer_id

Line 1982: PROCEDURE RLM_INTERFACE_HEADERS_LOG (

1978: arp_message.set_line( 'RLM_CUST_ITEM_CUM_KEYS_LOG');
1979: RAISE;
1980: END RLM_CUST_ITEM_CUM_KEYS_LOG;
1981:
1982: PROCEDURE RLM_INTERFACE_HEADERS_LOG (
1983: req_id NUMBER,
1984: set_num NUMBER,
1985: process_mode VARCHAR2) IS
1986:

Line 1995: RLM_INTERFACE_HEADERS.HEADER_ID%TYPE

1991: INDEX BY BINARY_INTEGER;
1992: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1993:
1994: TYPE HEADER_ID_LIST_TYPE IS TABLE OF
1995: RLM_INTERFACE_HEADERS.HEADER_ID%TYPE
1996: INDEX BY BINARY_INTEGER;
1997: PRIMARY_KEY_ID_LIST HEADER_ID_LIST_TYPE;
1998:
1999: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 2000: RLM_INTERFACE_HEADERS.CUSTOMER_ID%TYPE

1996: INDEX BY BINARY_INTEGER;
1997: PRIMARY_KEY_ID_LIST HEADER_ID_LIST_TYPE;
1998:
1999: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
2000: RLM_INTERFACE_HEADERS.CUSTOMER_ID%TYPE
2001: INDEX BY BINARY_INTEGER;
2002: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
2003: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
2004:

Line 2006: RLM_INTERFACE_HEADERS.ECE_PRIMARY_ADDRESS_ID%TYPE

2002: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
2003: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
2004:
2005: TYPE ECE_PRIMARY_ADD_ID_LIST_TYPE IS TABLE OF
2006: RLM_INTERFACE_HEADERS.ECE_PRIMARY_ADDRESS_ID%TYPE
2007: INDEX BY BINARY_INTEGER;
2008: NUM_COL2_ORIG_LIST ECE_PRIMARY_ADD_ID_LIST_TYPE;
2009: NUM_COL2_NEW_LIST ECE_PRIMARY_ADD_ID_LIST_TYPE;
2010:

Line 2012: RLM_INTERFACE_HEADERS.CUST_NAME_EXT%TYPE

2008: NUM_COL2_ORIG_LIST ECE_PRIMARY_ADD_ID_LIST_TYPE;
2009: NUM_COL2_NEW_LIST ECE_PRIMARY_ADD_ID_LIST_TYPE;
2010:
2011: TYPE CUST_NAME_EXT_LIST_TYPE IS TABLE OF
2012: RLM_INTERFACE_HEADERS.CUST_NAME_EXT%TYPE
2013: INDEX BY BINARY_INTEGER;
2014: VCHAR_COL1_ORIG_LIST CUST_NAME_EXT_LIST_TYPE;
2015: VCHAR_COL1_NEW_LIST CUST_NAME_EXT_LIST_TYPE;
2016:

Line 2018: RLM_INTERFACE_HEADERS.HEADER_NOTE_TEXT%TYPE

2014: VCHAR_COL1_ORIG_LIST CUST_NAME_EXT_LIST_TYPE;
2015: VCHAR_COL1_NEW_LIST CUST_NAME_EXT_LIST_TYPE;
2016:
2017: TYPE HEADER_NOTE_TEXT_LIST_TYPE IS TABLE OF
2018: RLM_INTERFACE_HEADERS.HEADER_NOTE_TEXT%TYPE
2019: INDEX BY BINARY_INTEGER;
2020: VCHAR_COL2_ORIG_LIST HEADER_NOTE_TEXT_LIST_TYPE;
2021: VCHAR_COL2_NEW_LIST HEADER_NOTE_TEXT_LIST_TYPE;
2022:

Line 2030: FROM RLM_INTERFACE_HEADERS yt, ra_customer_merges m

2026: ,yt.CUSTOMER_ID
2027: ,ECE_PRIMARY_ADDRESS_ID
2028: ,CUST_NAME_EXT
2029: ,HEADER_NOTE_TEXT
2030: FROM RLM_INTERFACE_HEADERS yt, ra_customer_merges m
2031: WHERE (
2032: yt.CUSTOMER_ID = m.DUPLICATE_ID
2033: OR yt.ECE_PRIMARY_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
2034: ) AND m.process_flag = 'N'

Line 2043: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_INTERFACE_HEADERS',FALSE);

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

Line 2098: 'RLM_INTERFACE_HEADERS',

2094: LAST_UPDATE_LOGIN,
2095: LAST_UPDATE_DATE,
2096: LAST_UPDATED_BY
2097: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
2098: 'RLM_INTERFACE_HEADERS',
2099: MERGE_HEADER_ID_LIST(I),
2100: PRIMARY_KEY_ID_LIST(I),
2101: NUM_COL1_ORIG_LIST(I),
2102: NUM_COL1_NEW_LIST(I),

Line 2126: arp_message.set_line( 'RLM_INTERFACE_HEADERS_LOG');

2122: END LOOP;
2123: END IF;
2124: EXCEPTION
2125: WHEN OTHERS THEN
2126: arp_message.set_line( 'RLM_INTERFACE_HEADERS_LOG');
2127: RAISE;
2128: END RLM_INTERFACE_HEADERS_LOG;
2129:
2130:

Line 2128: END RLM_INTERFACE_HEADERS_LOG;

2124: EXCEPTION
2125: WHEN OTHERS THEN
2126: arp_message.set_line( 'RLM_INTERFACE_HEADERS_LOG');
2127: RAISE;
2128: END RLM_INTERFACE_HEADERS_LOG;
2129:
2130:
2131: PROCEDURE RLM_INTERFACE_LINES_LOG (
2132: req_id NUMBER,