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_CUST_ITEM_CUM_KEYS

Line 102: FROM RLM_CUST_ITEM_CUM_KEYS ck,

98: SELECT ck.cum_key_id,
99: ck.cum_note_text,
100: m.duplicate_address_id,
101: m.customer_address_id
102: FROM RLM_CUST_ITEM_CUM_KEYS ck,
103: RA_CUSTOMER_MERGES m
104: WHERE m.process_flag = 'N'
105: AND m.request_id = req_id
106: AND m.set_number = set_num

Line 126: setARMessageLockTable('RLM_CUST_ITEM_CUM_KEYS');

122: arp_message.set_line('RLM_CUST_MERGE.Cust_Item_Cum_Keys()+' || getTimeStamp );
123: --
124: IF (process_mode = 'LOCK') THEN
125: --
126: setARMessageLockTable('RLM_CUST_ITEM_CUM_KEYS');
127: --
128: open cust_merge_cur;
129: close cust_merge_cur;
130: --

Line 163: RLM_CUST_ITEM_CUM_KEYS_LOG (

159: --
160: END LOOP;
161: --
162: /*2447493*/
163: RLM_CUST_ITEM_CUM_KEYS_LOG (
164: req_id => req_id,
165: set_num=>set_num,
166: process_mode=>process_mode) ;
167: /*2447493*/

Line 169: setARMessageUpdateTable('RLM_CUST_ITEM_CUM_KEYS');

165: set_num=>set_num,
166: process_mode=>process_mode) ;
167: /*2447493*/
168: --
169: setARMessageUpdateTable('RLM_CUST_ITEM_CUM_KEYS');
170: --
171: FORALL i IN l_cumKeyIdTab.FIRST..l_cumKeyIdTab.LAST
172: --
173: UPDATE RLM_CUST_ITEM_CUM_KEYS

Line 173: UPDATE RLM_CUST_ITEM_CUM_KEYS

169: setARMessageUpdateTable('RLM_CUST_ITEM_CUM_KEYS');
170: --
171: FORALL i IN l_cumKeyIdTab.FIRST..l_cumKeyIdTab.LAST
172: --
173: UPDATE RLM_CUST_ITEM_CUM_KEYS
174: SET intrmd_ship_to_id = DECODE(intrmd_ship_to_id,
175: l_duplicateAddressIdTab(i),
176: l_customerAddressIdTab(i),
177: intrmd_ship_to_id

Line 1823: PROCEDURE RLM_CUST_ITEM_CUM_KEYS_LOG (

1819: END IS_RLM_INSTALLED;
1820:
1821: /*2447493*/
1822:
1823: PROCEDURE RLM_CUST_ITEM_CUM_KEYS_LOG (
1824: req_id NUMBER,
1825: set_num NUMBER,
1826: process_mode VARCHAR2) IS
1827:

Line 1834: RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE

1830: INDEX BY BINARY_INTEGER;
1831: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1832:
1833: TYPE CUM_KEY_ID_LIST_TYPE IS TABLE OF
1834: RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE
1835: INDEX BY BINARY_INTEGER;
1836: PRIMARY_KEY_ID_LIST CUM_KEY_ID_LIST_TYPE;
1837:
1838: TYPE INTRMD_SHIP_TO_ID_LIST_TYPE IS TABLE OF

Line 1839: RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE

1835: INDEX BY BINARY_INTEGER;
1836: PRIMARY_KEY_ID_LIST CUM_KEY_ID_LIST_TYPE;
1837:
1838: TYPE INTRMD_SHIP_TO_ID_LIST_TYPE IS TABLE OF
1839: RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE
1840: INDEX BY BINARY_INTEGER;
1841: NUM_COL1_ORIG_LIST INTRMD_SHIP_TO_ID_LIST_TYPE;
1842: NUM_COL1_NEW_LIST INTRMD_SHIP_TO_ID_LIST_TYPE;
1843:

Line 1845: RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE

1841: NUM_COL1_ORIG_LIST INTRMD_SHIP_TO_ID_LIST_TYPE;
1842: NUM_COL1_NEW_LIST INTRMD_SHIP_TO_ID_LIST_TYPE;
1843:
1844: TYPE SHIP_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
1845: RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE
1846: INDEX BY BINARY_INTEGER;
1847: NUM_COL2_ORIG_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
1848: NUM_COL2_NEW_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
1849:

Line 1851: RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE

1847: NUM_COL2_ORIG_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
1848: NUM_COL2_NEW_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
1849:
1850: TYPE BILL_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
1851: RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE
1852: INDEX BY BINARY_INTEGER;
1853: NUM_COL3_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
1854: NUM_COL3_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
1855:

Line 1857: RLM_CUST_ITEM_CUM_KEYS.CUM_NOTE_TEXT%TYPE

1853: NUM_COL3_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
1854: NUM_COL3_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
1855:
1856: TYPE CUM_NOTE_TEXT_LIST_TYPE IS TABLE OF
1857: RLM_CUST_ITEM_CUM_KEYS.CUM_NOTE_TEXT%TYPE
1858: INDEX BY BINARY_INTEGER;
1859: VCHAR_COL1_ORIG_LIST CUM_NOTE_TEXT_LIST_TYPE;
1860: VCHAR_COL1_NEW_LIST CUM_NOTE_TEXT_LIST_TYPE;
1861:

Line 1863: RLM_CUST_ITEM_CUM_KEYS.INACTIVE_FLAG%TYPE

1859: VCHAR_COL1_ORIG_LIST CUM_NOTE_TEXT_LIST_TYPE;
1860: VCHAR_COL1_NEW_LIST CUM_NOTE_TEXT_LIST_TYPE;
1861:
1862: TYPE INACTIVE_FLAG_LIST_TYPE IS TABLE OF
1863: RLM_CUST_ITEM_CUM_KEYS.INACTIVE_FLAG%TYPE
1864: INDEX BY BINARY_INTEGER;
1865: VCHAR_COL2_ORIG_LIST INACTIVE_FLAG_LIST_TYPE;
1866: VCHAR_COL2_NEW_LIST INACTIVE_FLAG_LIST_TYPE;
1867:

Line 1876: FROM RLM_CUST_ITEM_CUM_KEYS yt, ra_customer_merges m

1872: ,SHIP_TO_ADDRESS_ID
1873: ,BILL_TO_ADDRESS_ID
1874: ,CUM_NOTE_TEXT
1875: ,INACTIVE_FLAG
1876: FROM RLM_CUST_ITEM_CUM_KEYS yt, ra_customer_merges m
1877: WHERE (
1878: yt.INTRMD_SHIP_TO_ID = m.DUPLICATE_ADDRESS_ID
1879: OR yt.SHIP_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
1880: OR yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID

Line 1891: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_CUST_ITEM_CUM_KEYS',FALSE);

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

Line 1947: 'RLM_CUST_ITEM_CUM_KEYS',

1943: LAST_UPDATE_LOGIN,
1944: LAST_UPDATE_DATE,
1945: LAST_UPDATED_BY
1946: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1947: 'RLM_CUST_ITEM_CUM_KEYS',
1948: MERGE_HEADER_ID_LIST(I),
1949: PRIMARY_KEY_ID_LIST(I),
1950: NUM_COL1_ORIG_LIST(I),
1951: NUM_COL1_NEW_LIST(I),

Line 1978: arp_message.set_line( 'RLM_CUST_ITEM_CUM_KEYS_LOG');

1974:
1975: END IF;
1976: EXCEPTION
1977: WHEN OTHERS THEN
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 (

Line 1980: END RLM_CUST_ITEM_CUM_KEYS_LOG;

1976: EXCEPTION
1977: WHEN OTHERS THEN
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,