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.IEX_MERGE_PVT dependencies on IEX_SCORE_HISTORIES

Line 12: | Account merge procedure for the table, IEX_SCORE_HISTORIES

Line 33: IEX_SCORE_HISTORIES.SCORE_HISTORY_ID%TYPE

29: INDEX BY BINARY_INTEGER;
30: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
31:
32: TYPE SCORE_HISTORY_ID_LIST_TYPE IS TABLE OF
33: IEX_SCORE_HISTORIES.SCORE_HISTORY_ID%TYPE
34: INDEX BY BINARY_INTEGER;
35: PRIMARY_KEY_ID_LIST SCORE_HISTORY_ID_LIST_TYPE;
36:
37: TYPE SCORE_OBJECT_ID_LIST_TYPE IS TABLE OF

Line 38: IEX_SCORE_HISTORIES.SCORE_OBJECT_ID%TYPE

34: INDEX BY BINARY_INTEGER;
35: PRIMARY_KEY_ID_LIST SCORE_HISTORY_ID_LIST_TYPE;
36:
37: TYPE SCORE_OBJECT_ID_LIST_TYPE IS TABLE OF
38: IEX_SCORE_HISTORIES.SCORE_OBJECT_ID%TYPE
39: INDEX BY BINARY_INTEGER;
40: NUM_COL1_ORIG_LIST SCORE_OBJECT_ID_LIST_TYPE;
41: NUM_COL1_NEW_LIST SCORE_OBJECT_ID_LIST_TYPE;
42: NUM_COL2_ORIG_LIST SCORE_OBJECT_ID_LIST_TYPE;

Line 53: FROM IEX_SCORE_HISTORIES yt, ra_customer_merges m

49: CURSOR merged_records1 IS
50: SELECT distinct CUSTOMER_MERGE_HEADER_ID
51: ,SCORE_HISTORY_ID
52: ,SCORE_OBJECT_ID
53: FROM IEX_SCORE_HISTORIES yt, ra_customer_merges m
54: WHERE yt.SCORE_OBJECT_ID = m.DUPLICATE_ID AND
55: m.process_flag = 'N' AND
56: m.request_id = req_id AND
57: m.set_number = set_num AND

Line 64: FROM IEX_SCORE_HISTORIES yt, ra_customer_merges m

60: CURSOR merged_records2 IS
61: SELECT distinct CUSTOMER_MERGE_HEADER_ID
62: ,SCORE_HISTORY_ID
63: ,SCORE_OBJECT_ID
64: FROM IEX_SCORE_HISTORIES yt, ra_customer_merges m
65: WHERE yt.SCORE_OBJECT_ID = m.DUPLICATE_ADDRESS_ID AND
66: m.process_flag = 'N' AND
67: m.request_id = req_id AND
68: m.set_number = set_num AND

Line 75: FROM IEX_SCORE_HISTORIES yt, ra_customer_merges m

71: CURSOR merged_records3 IS
72: SELECT distinct CUSTOMER_MERGE_HEADER_ID
73: ,SCORE_HISTORY_ID
74: ,SCORE_OBJECT_ID
75: FROM IEX_SCORE_HISTORIES yt, ra_customer_merges m
76: WHERE yt.SCORE_OBJECT_ID = m.DUPLICATE_SITE_ID AND
77: m.process_flag = 'N' AND
78: m.request_id = req_id AND
79: m.set_number = set_num AND

Line 94: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_SCORE_HISTORIES',FALSE);

90: IF process_mode='LOCK' THEN
91: NULL;
92: ELSE
93: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
94: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_SCORE_HISTORIES',FALSE);
95: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
96: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
97:
98: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE='IEX_ACCOUNT' */

Line 98: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE='IEX_ACCOUNT' */

94: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_SCORE_HISTORIES',FALSE);
95: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
96: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
97:
98: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE='IEX_ACCOUNT' */
99: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
100: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_ACCOUNT');
101: END IF;
102: open merged_records1;

Line 100: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_ACCOUNT');

96: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
97:
98: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE='IEX_ACCOUNT' */
99: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
100: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_ACCOUNT');
101: END IF;
102: open merged_records1;
103: LOOP
104: FETCH merged_records1 BULK COLLECT INTO

Line 139: 'IEX_SCORE_HISTORIES',

135: LAST_UPDATE_LOGIN,
136: LAST_UPDATE_DATE,
137: LAST_UPDATED_BY) VALUES
138: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
139: 'IEX_SCORE_HISTORIES',
140: MERGE_HEADER_ID_LIST(I),
141: PRIMARY_KEY_ID_LIST(I),
142: NUM_COL1_ORIG_LIST(I),
143: NUM_COL1_NEW_LIST(I),

Line 159: UPDATE IEX_SCORE_HISTORIES yt SET

155: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
156: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
157: END IF;
158: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
159: UPDATE IEX_SCORE_HISTORIES yt SET
160: SCORE_OBJECT_ID = NUM_COL1_NEW_LIST(I)
161: , LAST_UPDATE_DATE = SYSDATE
162: , last_updated_by = arp_standard.profile.user_id
163: , last_update_login = arp_standard.profile.last_update_login

Line 179: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_ACCOUNT_SITE' */

175: arp_message.set_name('AR','AR_ROWS_UPDATED');
176: arp_message.set_token('NUM_ROWS',to_char(l_count));
177:
178: <>
179: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_ACCOUNT_SITE' */
180: MERGE_HEADER_ID_LIST.delete;
181: PRIMARY_KEY_ID_LIST.delete;
182: l_count := 0;
183: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 184: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_ACCOUNT_SITE');

180: MERGE_HEADER_ID_LIST.delete;
181: PRIMARY_KEY_ID_LIST.delete;
182: l_count := 0;
183: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
184: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_ACCOUNT_SITE');
185: END IF;
186: open merged_records2;
187: LOOP
188: FETCH merged_records2 BULK COLLECT INTO

Line 224: 'IEX_SCORE_HISTORIES',

220: LAST_UPDATE_LOGIN,
221: LAST_UPDATE_DATE,
222: LAST_UPDATED_BY) VALUES
223: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
224: 'IEX_SCORE_HISTORIES',
225: MERGE_HEADER_ID_LIST(I),
226: PRIMARY_KEY_ID_LIST(I),
227: NUM_COL1_ORIG_LIST(I),
228: NUM_COL1_NEW_LIST(I),

Line 244: UPDATE IEX_SCORE_HISTORIES yt SET

240: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
241: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
242: END IF;
243: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
244: UPDATE IEX_SCORE_HISTORIES yt SET
245: SCORE_OBJECT_ID = NUM_COL2_NEW_LIST(I)
246: , LAST_UPDATE_DATE = SYSDATE
247: , last_updated_by = arp_standard.profile.user_id
248: , last_update_login = arp_standard.profile.last_update_login

Line 261: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_BILLTO' */

257: END IF;
258: END LOOP;
259:
260: <>
261: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_BILLTO' */
262: MERGE_HEADER_ID_LIST.delete;
263: PRIMARY_KEY_ID_LIST.delete;
264: l_count := 0;
265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 266: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_BILLTO');

262: MERGE_HEADER_ID_LIST.delete;
263: PRIMARY_KEY_ID_LIST.delete;
264: l_count := 0;
265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
266: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_BILLTO');
267: END IF;
268: open merged_records3;
269: LOOP
270: FETCH merged_records1 BULK COLLECT INTO

Line 305: 'IEX_SCORE_HISTORIES',

301: LAST_UPDATE_LOGIN,
302: LAST_UPDATE_DATE,
303: LAST_UPDATED_BY) VALUES
304: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
305: 'IEX_SCORE_HISTORIES',
306: MERGE_HEADER_ID_LIST(I),
307: PRIMARY_KEY_ID_LIST(I),
308: NUM_COL3_ORIG_LIST(I),
309: NUM_COL3_NEW_LIST(I),

Line 325: UPDATE IEX_SCORE_HISTORIES yt SET

321: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
322: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
323: END IF;
324: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
325: UPDATE IEX_SCORE_HISTORIES yt SET
326: SCORE_OBJECT_ID = NUM_COL3_NEW_LIST(I)
327: , LAST_UPDATE_DATE = SYSDATE
328: , last_updated_by = arp_standard.profile.user_id
329: , last_update_login = arp_standard.profile.last_update_login

Line 1577: -- 02182002 add IEX_SCORE_HISTORIES

1573: iex_cases_all_b
1574: iex_writeoffs
1575: iex_bankruptcies
1576: iex_litigations
1577: -- 02182002 add IEX_SCORE_HISTORIES
1578: IEX_STRATEGIES
1579: */
1580: UPDATE IEX_STRATEGIES
1581: SET JTF_OBJECT_ID = p_To_FK_ID,

Line 1609: UPDATE IEX_SCORE_HISTORIES

1605: WHERE PARTY_ID = p_from_fk_id;
1606: -- End - 10/12/2005 - Andre Araujo - Need to update party_id also
1607:
1608:
1609: UPDATE IEX_SCORE_HISTORIES
1610: SET SCORE_OBJECT_ID = p_To_FK_ID,
1611: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1612: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1613: last_update_login = HZ_UTILITY_V2PUB.last_update_login,