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.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_INT_DEDUP_RESULTS

Line 197: TYPE L_DUP_RECORD_OSList is TABLE OF HZ_IMP_INT_DEDUP_RESULTS.dup_record_os%TYPE;

193: p_action_on_entity IN VARCHAR2
194: ) IS
195:
196:
197: TYPE L_DUP_RECORD_OSList is TABLE OF HZ_IMP_INT_DEDUP_RESULTS.dup_record_os%TYPE;
198: l_dup_record_os L_DUP_RECORD_OSList;
199: l_winner_record_os L_DUP_RECORD_OSList;
200: l_record_os L_DUP_RECORD_OSList;
201: TYPE L_DUP_RECORD_OSRList is TABLE OF HZ_IMP_INT_DEDUP_RESULTS.dup_record_osr%TYPE;

Line 201: TYPE L_DUP_RECORD_OSRList is TABLE OF HZ_IMP_INT_DEDUP_RESULTS.dup_record_osr%TYPE;

197: TYPE L_DUP_RECORD_OSList is TABLE OF HZ_IMP_INT_DEDUP_RESULTS.dup_record_os%TYPE;
198: l_dup_record_os L_DUP_RECORD_OSList;
199: l_winner_record_os L_DUP_RECORD_OSList;
200: l_record_os L_DUP_RECORD_OSList;
201: TYPE L_DUP_RECORD_OSRList is TABLE OF HZ_IMP_INT_DEDUP_RESULTS.dup_record_osr%TYPE;
202: l_dup_record_osr L_DUP_RECORD_OSRList ;
203: l_winner_record_osr L_DUP_RECORD_OSRList;
204: l_record_osr L_DUP_RECORD_OSRList;
205:

Line 206: l_rec_os HZ_IMP_INT_DEDUP_RESULTS.dup_record_os%TYPE;

202: l_dup_record_osr L_DUP_RECORD_OSRList ;
203: l_winner_record_osr L_DUP_RECORD_OSRList;
204: l_record_osr L_DUP_RECORD_OSRList;
205:
206: l_rec_os HZ_IMP_INT_DEDUP_RESULTS.dup_record_os%TYPE;
207: l_rec_osr HZ_IMP_INT_DEDUP_RESULTS.dup_record_osr%TYPE;
208:
209: CURSOR tobe_removed_rec( p_batch_id IN NUMBER, p_entity IN VARCHAR2) IS
210: SELECT dup_record_os, dup_record_osr

Line 207: l_rec_osr HZ_IMP_INT_DEDUP_RESULTS.dup_record_osr%TYPE;

203: l_winner_record_osr L_DUP_RECORD_OSRList;
204: l_record_osr L_DUP_RECORD_OSRList;
205:
206: l_rec_os HZ_IMP_INT_DEDUP_RESULTS.dup_record_os%TYPE;
207: l_rec_osr HZ_IMP_INT_DEDUP_RESULTS.dup_record_osr%TYPE;
208:
209: CURSOR tobe_removed_rec( p_batch_id IN NUMBER, p_entity IN VARCHAR2) IS
210: SELECT dup_record_os, dup_record_osr
211: FROM HZ_IMP_INT_DEDUP_RESULTS

Line 211: FROM HZ_IMP_INT_DEDUP_RESULTS

207: l_rec_osr HZ_IMP_INT_DEDUP_RESULTS.dup_record_osr%TYPE;
208:
209: CURSOR tobe_removed_rec( p_batch_id IN NUMBER, p_entity IN VARCHAR2) IS
210: SELECT dup_record_os, dup_record_osr
211: FROM HZ_IMP_INT_DEDUP_RESULTS
212: WHERE batch_id = p_batch_id
213: AND entity = p_entity ;
214:
215: CURSOR sel_dup_set (p_batch_id IN NUMBER, p_entity IN VARCHAR2 ) IS

Line 217: from hz_imp_int_dedup_results

213: AND entity = p_entity ;
214:
215: CURSOR sel_dup_set (p_batch_id IN NUMBER, p_entity IN VARCHAR2 ) IS
216: select distinct winner_record_os, winner_record_osr
217: from hz_imp_int_dedup_results
218: where batch_id = p_batch_id
219: and entity = p_entity
220: group by winner_record_os,winner_record_osr;
221:

Line 225: FROM HZ_IMP_INT_DEDUP_RESULTS

221:
222: --//Choose the latest updated record
223: CURSOR max_last_date ( p_batch_id in NUMBER , p_entity in VARCHAR2,p_winner_record_os IN VARCHAR2, p_winner_record_osr IN VARCHAR2) IS
224: SELECT DUP_RECORD_OS, DUP_RECORD_OSR
225: FROM HZ_IMP_INT_DEDUP_RESULTS
226: WHERE batch_id = p_batch_id
227: AND entity = p_entity
228: AND nvl(dup_last_update_date,sysdate) = ( SELECT MAX( nvl(DUP_LAST_UPDATE_DATE,sysdate))
229: FROM HZ_IMP_INT_DEDUP_RESULTS

Line 229: FROM HZ_IMP_INT_DEDUP_RESULTS

225: FROM HZ_IMP_INT_DEDUP_RESULTS
226: WHERE batch_id = p_batch_id
227: AND entity = p_entity
228: AND nvl(dup_last_update_date,sysdate) = ( SELECT MAX( nvl(DUP_LAST_UPDATE_DATE,sysdate))
229: FROM HZ_IMP_INT_DEDUP_RESULTS
230: WHERE batch_id =p_batch_id
231: and entity = p_entity
232: AND winner_record_os = p_winner_record_os
233: AND winner_record_osr = p_winner_record_osr )

Line 241: FROM HZ_IMP_INT_DEDUP_RESULTS

237:
238: --//Choose the latest created record
239: CURSOR max_created_date ( p_batch_id in NUMBER , p_entity in VARCHAR2,p_winner_record_os IN VARCHAR2, p_winner_record_osr IN VARCHAR2) IS
240: SELECT DUP_RECORD_OS, DUP_RECORD_OSR
241: FROM HZ_IMP_INT_DEDUP_RESULTS
242: WHERE batch_id = p_batch_id
243: AND entity = p_entity
244: AND nvl(dup_creation_date,sysdate) = ( SELECT MAX( nvl(DUP_CREATION_DATE,sysdate))
245: FROM HZ_IMP_INT_DEDUP_RESULTS

Line 245: FROM HZ_IMP_INT_DEDUP_RESULTS

241: FROM HZ_IMP_INT_DEDUP_RESULTS
242: WHERE batch_id = p_batch_id
243: AND entity = p_entity
244: AND nvl(dup_creation_date,sysdate) = ( SELECT MAX( nvl(DUP_CREATION_DATE,sysdate))
245: FROM HZ_IMP_INT_DEDUP_RESULTS
246: WHERE batch_id =p_batch_id
247: and entity = p_entity
248: AND winner_record_os = p_winner_record_os
249: AND winner_record_osr = p_winner_record_osr )

Line 257: FROM HZ_IMP_INT_DEDUP_RESULTS

253:
254: --//Choose the earliest created record
255: CURSOR min_created_date ( p_batch_id in NUMBER , p_entity in VARCHAR2,p_winner_record_os IN VARCHAR2, p_winner_record_osr IN VARCHAR2) IS
256: SELECT DUP_RECORD_OS, DUP_RECORD_OSR
257: FROM HZ_IMP_INT_DEDUP_RESULTS
258: WHERE batch_id = p_batch_id
259: AND entity = p_entity
260: AND nvl(dup_creation_date,sysdate) = ( SELECT MIN( nvl(DUP_CREATION_DATE,sysdate))
261: FROM HZ_IMP_INT_DEDUP_RESULTS

Line 261: FROM HZ_IMP_INT_DEDUP_RESULTS

257: FROM HZ_IMP_INT_DEDUP_RESULTS
258: WHERE batch_id = p_batch_id
259: AND entity = p_entity
260: AND nvl(dup_creation_date,sysdate) = ( SELECT MIN( nvl(DUP_CREATION_DATE,sysdate))
261: FROM HZ_IMP_INT_DEDUP_RESULTS
262: WHERE batch_id =p_batch_id
263: and entity = p_entity
264: AND winner_record_os = p_winner_record_os
265: AND winner_record_osr = p_winner_record_osr )

Line 321: FROM HZ_IMP_INT_DEDUP_RESULTS result

317: SET interface_status = 'R'
318: WHERE batch_id = p_batch_id
319: AND( party_orig_system, party_orig_system_reference ) in
320: ( select dup_record_os, dup_record_osr
321: FROM HZ_IMP_INT_DEDUP_RESULTS result
322: WHERE result.batch_id = p_batch_id
323: --AND result.dup_record_os = result.winner_record_os --Bug3339642.
324: --AND result.dup_record_osr <> result.winner_record_osr --Bug3339642.
325: AND result.entity = 'PARTY');

Line 334: FROM HZ_IMP_INT_DEDUP_RESULTS result

330: SET interface_status = 'R'
331: WHERE batch_id = p_batch_id
332: AND( site_orig_system, site_orig_system_reference ) in
333: ( select dup_record_os, dup_record_osr
334: FROM HZ_IMP_INT_DEDUP_RESULTS result
335: WHERE result.batch_id = p_batch_id
336: --AND result.dup_record_os = result.winner_record_os --Bug3339642.
337: --AND result.dup_record_osr <> result.winner_record_osr --Bug3339642.
338: AND result.entity = 'PARTY_SITES');

Line 347: FROM HZ_IMP_INT_DEDUP_RESULTS result

343: SET interface_status = 'R'
344: WHERE batch_id = p_batch_id
345: AND( contact_orig_system,contact_orig_system_reference) in
346: ( select dup_record_os, dup_record_osr
347: FROM HZ_IMP_INT_DEDUP_RESULTS result
348: WHERE result.batch_id = p_batch_id
349: --AND result.dup_record_os = result.winner_record_os --Bug3339642.
350: --AND result.dup_record_osr <> result.winner_record_osr --Bug3339642.
351: AND result.entity = 'CONTACTS');

Line 360: FROM HZ_IMP_INT_DEDUP_RESULTS result

356: SET interface_status = 'R'
357: WHERE batch_id = p_batch_id
358: AND(cp_orig_system ,cp_orig_system_reference) in
359: ( select dup_record_os, dup_record_osr
360: FROM HZ_IMP_INT_DEDUP_RESULTS result
361: WHERE result.batch_id = p_batch_id
362: --AND result.dup_record_os = result.winner_record_os --Bug3339642.
363: --AND result.dup_record_osr <> result.winner_record_osr --Bug3339642.
364: AND result.entity = 'CONTACT_POINTS');

Line 418: UPDATE HZ_IMP_INT_DEDUP_RESULTS

414: END IF;
415:
416: --Set the winner record
417:
418: UPDATE HZ_IMP_INT_DEDUP_RESULTS
419: SET WINNER_RECORD_OS = l_rec_os ,WINNER_RECORD_OSR = l_rec_osr
420: WHERE batch_id = p_batch_id
421: AND entity = p_entity
422: AND WINNER_RECORD_OS = l_winner_record_os(i)

Line 434: FROM HZ_IMP_INT_DEDUP_RESULTS result

430: SET INTERFACE_STATUS = 'R'
431: WHERE batch_id = p_batch_id
432: AND( party_orig_system, party_orig_system_reference ) in
433: ( select dup_record_os, dup_record_osr
434: FROM HZ_IMP_INT_DEDUP_RESULTS result
435: WHERE result.batch_id = p_batch_id
436: AND result.entity = 'PARTY'
437: AND result.dup_record_osr <> l_rec_osr
438: AND WINNER_RECORD_OS = l_rec_os

Line 447: FROM HZ_IMP_INT_DEDUP_RESULTS result

443: SET INTERFACE_STATUS = 'R'
444: WHERE batch_id = p_batch_id
445: AND( site_orig_system, site_orig_system_reference ) in
446: ( select dup_record_os, dup_record_osr
447: FROM HZ_IMP_INT_DEDUP_RESULTS result
448: WHERE result.batch_id = p_batch_id
449: AND result.entity = 'PARTY_SITES'
450: AND result.dup_record_osr <> l_rec_osr
451: AND WINNER_RECORD_OS = l_rec_os

Line 460: FROM HZ_IMP_INT_DEDUP_RESULTS result

456: SET interface_status = 'R'
457: WHERE batch_id = p_batch_id
458: AND ( contact_orig_system,contact_orig_system_reference ) in
459: ( select dup_record_os, dup_record_osr
460: FROM HZ_IMP_INT_DEDUP_RESULTS result
461: WHERE result.batch_id = p_batch_id
462: AND result.entity = 'CONTACTS'
463: AND result.dup_record_osr <> l_rec_osr
464: AND WINNER_RECORD_OS = l_rec_os

Line 473: FROM HZ_IMP_INT_DEDUP_RESULTS result

469: SET interface_status = 'R'
470: WHERE batch_id = p_batch_id
471: AND ( cp_orig_system, cp_orig_system_reference ) in
472: ( select dup_record_os, dup_record_osr
473: FROM HZ_IMP_INT_DEDUP_RESULTS result
474: WHERE result.batch_id = p_batch_id
475: AND result.entity = 'CONTACT_POINTS'
476: AND result.dup_record_osr <> l_rec_osr
477: AND WINNER_RECORD_OS = l_rec_os

Line 1622: FROM HZ_IMP_INT_DEDUP_RESULTS

1618: x_return_status OUT NOCOPY VARCHAR2
1619: ) IS
1620: Cursor select_party_rec(p_batch_id IN NUMBER ,p_entity IN VARCHAR2 ) is
1621: select dup_record_os,dup_record_osr
1622: FROM HZ_IMP_INT_DEDUP_RESULTS
1623: WHERE batch_id = p_batch_id
1624: AND ENTITY = p_entity
1625: UNION
1626: SELECT party_osr,party_os

Line 1633: FROM HZ_IMP_INT_DEDUP_RESULTS

1629: ;
1630:
1631: Cursor select_detail_rec(p_batch_id IN NUMBER ,p_entity IN VARCHAR2 ) is
1632: select dup_record_os,dup_record_osr
1633: FROM HZ_IMP_INT_DEDUP_RESULTS
1634: WHERE batch_id = p_batch_id
1635: AND ENTITY = p_entity
1636: UNION
1637: SELECT record_os,record_osr

Line 2200: FROM HZ_IMP_INT_DEDUP_RESULTS

2196: IS
2197: --//Choose the latest updated record
2198: CURSOR max_last_date IS
2199: SELECT DUP_RECORD_OS, DUP_RECORD_OSR
2200: FROM HZ_IMP_INT_DEDUP_RESULTS
2201: WHERE batch_id = p_batch_id
2202: AND entity = p_entity
2203: AND nvl(dup_last_update_date,sysdate) = ( SELECT MAX( nvl(DUP_LAST_UPDATE_DATE,sysdate))
2204: FROM HZ_IMP_INT_DEDUP_RESULTS

Line 2204: FROM HZ_IMP_INT_DEDUP_RESULTS

2200: FROM HZ_IMP_INT_DEDUP_RESULTS
2201: WHERE batch_id = p_batch_id
2202: AND entity = p_entity
2203: AND nvl(dup_last_update_date,sysdate) = ( SELECT MAX( nvl(DUP_LAST_UPDATE_DATE,sysdate))
2204: FROM HZ_IMP_INT_DEDUP_RESULTS
2205: WHERE batch_id =p_batch_id
2206: and entity = p_entity
2207: AND winner_record_os = p_winner_record_os
2208: AND winner_record_osr = p_winner_record_osr)

Line 2216: FROM HZ_IMP_INT_DEDUP_RESULTS

2212:
2213: --//Choose the latest created record
2214: CURSOR max_created_date IS
2215: SELECT DUP_RECORD_OS, DUP_RECORD_OSR
2216: FROM HZ_IMP_INT_DEDUP_RESULTS
2217: WHERE batch_id = p_batch_id
2218: AND entity = p_entity
2219: AND nvl(dup_creation_date,sysdate) = ( SELECT MAX( nvl(DUP_CREATION_DATE,sysdate))
2220: FROM HZ_IMP_INT_DEDUP_RESULTS

Line 2220: FROM HZ_IMP_INT_DEDUP_RESULTS

2216: FROM HZ_IMP_INT_DEDUP_RESULTS
2217: WHERE batch_id = p_batch_id
2218: AND entity = p_entity
2219: AND nvl(dup_creation_date,sysdate) = ( SELECT MAX( nvl(DUP_CREATION_DATE,sysdate))
2220: FROM HZ_IMP_INT_DEDUP_RESULTS
2221: WHERE batch_id =p_batch_id
2222: AND entity = p_entity
2223: AND winner_record_os = p_winner_record_os
2224: AND winner_record_osr = p_winner_record_osr)

Line 2232: FROM HZ_IMP_INT_DEDUP_RESULTS

2228:
2229: --//Choose the earliest created record
2230: CURSOR min_created_date IS
2231: SELECT DUP_RECORD_OS, DUP_RECORD_OSR
2232: FROM HZ_IMP_INT_DEDUP_RESULTS
2233: WHERE batch_id = p_batch_id
2234: AND entity = p_entity
2235: AND nvl(dup_creation_date,sysdate) = ( SELECT MIN( nvl(DUP_CREATION_DATE,sysdate))
2236: FROM HZ_IMP_INT_DEDUP_RESULTS

Line 2236: FROM HZ_IMP_INT_DEDUP_RESULTS

2232: FROM HZ_IMP_INT_DEDUP_RESULTS
2233: WHERE batch_id = p_batch_id
2234: AND entity = p_entity
2235: AND nvl(dup_creation_date,sysdate) = ( SELECT MIN( nvl(DUP_CREATION_DATE,sysdate))
2236: FROM HZ_IMP_INT_DEDUP_RESULTS
2237: WHERE batch_id =p_batch_id
2238: AND entity = p_entity
2239: AND winner_record_os = p_winner_record_os
2240: AND winner_record_osr = p_winner_record_osr)