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_PARTY_MERGE dependencies on HZ_MERGE_PARTIES

Line 316: FROM HZ_MERGE_PARTIES mp, hz_parties p

312:
313: -----Cursor for grouping parties based on distinct merge_to party-----
314: CURSOR c_pre_merge(cp_batch_id NUMBER) IS
315: SELECT DISTINCT(to_party_id)
316: FROM HZ_MERGE_PARTIES mp, hz_parties p
317: WHERE batch_id = cp_batch_id
318: AND p.party_id = mp.from_party_id
319: AND p.party_type <> 'PARTY_RELATIONSHIP';
320:

Line 323: FROM HZ_MERGE_PARTIES mp, hz_parties p

319: AND p.party_type <> 'PARTY_RELATIONSHIP';
320:
321: CURSOR c_pre_merge_type(cp_batch_id NUMBER, cp_to_party_id NUMBER) IS
322: SELECT mp.merge_type
323: FROM HZ_MERGE_PARTIES mp, hz_parties p
324: WHERE mp.batch_id = cp_batch_id
325: AND mp.to_party_id = cp_to_party_id
326: AND p.party_id = mp.to_party_id
327: AND p.party_type <> 'PARTY_RELATIONSHIP'

Line 335: FROM HZ_MERGE_PARTIES mp, HZ_PARTIES pt, hz_organization_profiles op

331: -----Cursor to get merge from-merge to pair parties and the type-----
332: CURSOR c_batch_details(cp_batch_id NUMBER,cp_to_party_id IN NUMBER) IS
333: SELECT batch_party_id, merge_type, from_party_id, to_party_id, merge_status,party_type,
334: decode(op.actual_content_source, 'DNB', 'DNB', NULL), merge_reason_code
335: FROM HZ_MERGE_PARTIES mp, HZ_PARTIES pt, hz_organization_profiles op
336: WHERE batch_id = cp_batch_id
337: AND pt.party_id = mp.from_party_id
338: AND op.party_id(+) = pt.party_id
339: AND op.actual_content_source(+) = 'DNB'

Line 347: FROM hz_merge_parties

343: AND exists (
344: select 1 FROM HZ_RELATIONSHIPS r
345: WHERE (r.party_id = mp.to_party_id or r.party_id = mp.from_party_id)
346: AND r.OBJECT_ID IN (SELECT from_party_id
347: FROM hz_merge_parties
348: WHERE batch_id = cp_batch_id AND to_party_id = cp_to_party_id))) )
349: ORDER BY decode(pt.party_type, 'PARTY_RELATIONSHIP',1,
350: decode(mp.merge_type, 'PARTY_MERGE',2,
351: 'SAME_PARTY_MERGE',3,4)), 7, op.last_update_date desc; --5000614

Line 406: from hz_merge_parties

402: Select application_short_name from fnd_application where application_id=app_id;
403:
404: cursor get_batch_party_id_csr is
405: select batch_party_id
406: from hz_merge_parties
407: where batch_id = p_batch_id
408: and rownum=1;
409:
410: --start bug 4634891

Line 422: from HZ_MERGE_PARTIES mp

418: group by procedure_name);
419:
420: CURSOR merge_to_parties IS
421: select DISTINCT(to_party_id)
422: from HZ_MERGE_PARTIES mp
423: where batch_id = p_batch_id
424: and merge_status = 'DONE';
425:
426:

Line 433: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;

429:
430: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
431: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
432: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
433: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
434:
435: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
436: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
437:

Line 438: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;

434:
435: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
436: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
437:
438: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
439: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
440:
441: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
442: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;

Line 439: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;

435: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
436: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
437:
438: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
439: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
440:
441: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
442: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
443:

Line 441: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;

437:
438: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
439: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
440:
441: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
442: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
443:
444: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
445: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;

Line 442: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;

438: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
439: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
440:
441: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
442: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
443:
444: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
445: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
446:

Line 444: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;

440:
441: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
442: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
443:
444: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
445: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
446:
447: l_from_site_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
448: l_to_site_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;

Line 445: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;

441: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
442: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
443:
444: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
445: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
446:
447: l_from_site_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
448: l_to_site_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
449:

Line 447: l_from_site_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;

443:
444: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
445: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
446:
447: l_from_site_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
448: l_to_site_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
449:
450: l_from_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
451: l_to_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;

Line 448: l_to_site_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;

444: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
445: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
446:
447: l_from_site_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
448: l_to_site_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
449:
450: l_from_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
451: l_to_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
452:

Line 495: l_batch_pid HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;

491: l_data_type VARCHAR2(255);
492: l_app_name VARCHAR2(100);
493: l_dss_orig_prof_val varchar2(30);
494: l_dss_update_flag varchar2(1);
495: l_batch_pid HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
496: --4230396
497: l_key VARCHAR2(240);
498: l_list WF_PARAMETER_LIST_T;
499: --4230396

Line 678: -- Lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS records

674: --Bug No: 3267877
675: SAVEPOINT batch_merge;
676: l_batch_merge_spt:=TRUE;
677:
678: -- Lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS records
679: log ('.... Locking batch for execution');
680: lock_batch(p_batch_id, l_return_status);
681: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
682: ROLLBACK to batch_merge;

Line 934: FROM HZ_MERGE_PARTIES

930: l_to_rel_party_id IS NOT NULL AND
931: l_from_rel_party_id<>l_to_rel_party_id THEN
932: BEGIN
933: SELECT 1 INTO l_tmp
934: FROM HZ_MERGE_PARTIES
935: WHERE batch_id = l_batch_id
936: AND from_party_id = l_from_rel_party_id
937: AND to_party_id = l_to_rel_party_id
938: AND merge_status = 'DONE';

Line 994: UPDATE HZ_MERGE_PARTIES

990: IF g_merge_delete_flag = 'Y' THEN
991: delete_merged_records(l_batch_party_id, l_return_status);
992: END IF;
993:
994: UPDATE HZ_MERGE_PARTIES
995: SET MERGE_STATUS = 'DONE',
996: last_update_date = hz_utility_v2pub.last_update_date,
997: last_updated_by = hz_utility_v2pub.last_updated_by,
998: last_update_login = hz_utility_v2pub.last_update_login

Line 1031: FROM HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_DETAILS md

1027:
1028: /* Merge all to records that are getting merged into the transferred from records */
1029: FOR TO_RECORDS IN (
1030: SELECT mp.batch_party_id, merge_from_entity_id, merge_to_entity_id, ENTITY_NAME
1031: FROM HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_DETAILS md
1032: WHERE mp.batch_party_id=md.batch_party_id
1033: AND mp.to_party_id = l_pre_merge_to_party_id
1034: AND mp.batch_id = l_batch_id
1035: AND md.mandatory_merge = 'T') LOOP

Line 1194: SELECT count(*) INTO l_num_merged FROM HZ_MERGE_PARTIES

1190: -- the set batch status to PART_COMPLETE if any of the merged parties
1191: -- is succesfully complete
1192: IF p_preview <> 'Y' THEN
1193:
1194: SELECT count(*) INTO l_num_merged FROM HZ_MERGE_PARTIES
1195: WHERE batch_id = p_batch_id
1196: AND merge_status = 'DONE';
1197:
1198: IF l_num_merged > 0 THEN

Line 2076: | Procedure to lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS

2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073: END do_merge;
2074:
2075: /*------------------------------------------------------------------------------
2076: | Procedure to lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS
2077: | for a given batch
2078: |-------------------------------------------------------------------------------*/
2079:
2080: PROCEDURE lock_batch(

Line 2088: ' (SELECT batch_party_id from HZ_MERGE_PARTIES '||

2084: BEGIN
2085: -- Lock merge party details
2086: EXECUTE IMMEDIATE 'SELECT batch_party_id from HZ_MERGE_PARTY_DETAILS ' ||
2087: 'WHERE batch_party_id IN ' ||
2088: ' (SELECT batch_party_id from HZ_MERGE_PARTIES '||
2089: ' WHERE batch_id = :batchid ) FOR UPDATE NOWAIT' USING p_batch_id;
2090:
2091: -- Lock merge parties
2092: EXECUTE IMMEDIATE 'SELECT batch_party_id from HZ_MERGE_PARTIES ' ||

Line 2092: EXECUTE IMMEDIATE 'SELECT batch_party_id from HZ_MERGE_PARTIES ' ||

2088: ' (SELECT batch_party_id from HZ_MERGE_PARTIES '||
2089: ' WHERE batch_id = :batchid ) FOR UPDATE NOWAIT' USING p_batch_id;
2090:
2091: -- Lock merge parties
2092: EXECUTE IMMEDIATE 'SELECT batch_party_id from HZ_MERGE_PARTIES ' ||
2093: 'WHERE batch_id = :batchid FOR UPDATE NOWAIT' USING p_batch_id;
2094:
2095: -- Lock batch
2096: EXECUTE IMMEDIATE 'SELECT batch_id from HZ_MERGE_BATCH ' ||

Line 2617: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,

2613: | Procedure to store merge history record
2614: |------------------------------------------------------------------------*/
2615:
2616: PROCEDURE store_merge_history(
2617: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2618: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2619: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2620: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2621: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

Line 2618: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,

2614: |------------------------------------------------------------------------*/
2615:
2616: PROCEDURE store_merge_history(
2617: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2618: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2619: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2620: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2621: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2622: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,

Line 2619: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

2615:
2616: PROCEDURE store_merge_history(
2617: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2618: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2619: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2620: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2621: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2622: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2623: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,

Line 2620: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

2616: PROCEDURE store_merge_history(
2617: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2618: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2619: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2620: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2621: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2622: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2623: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2624: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,

Line 2621: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

2617: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2618: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2619: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2620: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2621: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2622: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2623: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2624: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2625: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,

Line 2721: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,

2717: | be commited irrespective of the merge mode or result
2718: |---------------------------------------------------------------------------*/
2719:
2720: PROCEDURE store_merge_log(
2721: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2722: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2723: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2724: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2725: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

Line 2722: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,

2718: |---------------------------------------------------------------------------*/
2719:
2720: PROCEDURE store_merge_log(
2721: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2722: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2723: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2724: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2725: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2726: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,

Line 2723: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

2719:
2720: PROCEDURE store_merge_log(
2721: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2722: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2723: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2724: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2725: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2726: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2727: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,

Line 2724: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

2720: PROCEDURE store_merge_log(
2721: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2722: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2723: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2724: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2725: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2726: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2727: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2728: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,

Line 2725: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

2721: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2722: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2723: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2724: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2725: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2726: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2727: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2728: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2729: p_op_type IN HZ_MERGE_PARTY_LOG.OPERATION_TYPE%TYPE,

Line 2886: from hz_merge_party_details d1, hz_merge_parties p

2882:
2883:
2884: CURSOR party_sites_for_pre_merge(cp_to_party_id IN NUMBER, cp_batch_id IN NUMBER) IS
2885: select merge_to_entity_id, p.from_party_id, p.batch_party_id
2886: from hz_merge_party_details d1, hz_merge_parties p
2887: where entity_name = 'HZ_PARTY_SITES'
2888: and p.batch_party_id = d1.batch_party_id
2889: and d1.batch_party_id IN ( select batch_party_id
2890: from hz_merge_parties

Line 2890: from hz_merge_parties

2886: from hz_merge_party_details d1, hz_merge_parties p
2887: where entity_name = 'HZ_PARTY_SITES'
2888: and p.batch_party_id = d1.batch_party_id
2889: and d1.batch_party_id IN ( select batch_party_id
2890: from hz_merge_parties
2891: where to_party_id = cp_to_party_id
2892: and to_party_id<>from_party_id
2893: and batch_id = cp_batch_id)
2894: and merge_from_entity_id = merge_to_entity_id --transfer operation

Line 2901: from hz_merge_parties

2897: from hz_merge_party_details d2
2898: where d2.merge_to_entity_id = d1.merge_from_entity_id
2899: and d2.entity_name = 'HZ_PARTY_SITES'
2900: and batch_party_id IN ( select batch_party_id
2901: from hz_merge_parties
2902: where to_party_id = cp_to_party_id
2903: and to_party_id<>from_party_id
2904: and batch_id = cp_batch_id)
2905: and d2.merge_from_entity_id <> d1.merge_to_entity_id );

Line 2909: from hz_merge_party_details d1, hz_merge_parties p

2905: and d2.merge_from_entity_id <> d1.merge_to_entity_id );
2906:
2907: CURSOR rel_for_pre_merge(cp_to_party_id IN NUMBER, cp_batch_id IN NUMBER) IS
2908: select merge_to_entity_id, p.from_party_id, p.batch_party_id
2909: from hz_merge_party_details d1, hz_merge_parties p
2910: where entity_name = 'HZ_PARTY_RELATIONSHIPS'
2911: and p.batch_party_id = d1.batch_party_id
2912: and d1.batch_party_id IN ( select batch_party_id
2913: from hz_merge_parties

Line 2913: from hz_merge_parties

2909: from hz_merge_party_details d1, hz_merge_parties p
2910: where entity_name = 'HZ_PARTY_RELATIONSHIPS'
2911: and p.batch_party_id = d1.batch_party_id
2912: and d1.batch_party_id IN ( select batch_party_id
2913: from hz_merge_parties
2914: where to_party_id = cp_to_party_id
2915: and to_party_id<>from_party_id
2916: and batch_id = cp_batch_id)
2917: and merge_from_entity_id = merge_to_entity_id --transfer operation

Line 2925: from hz_merge_parties

2921: where d2.merge_to_entity_id = d1.merge_from_entity_id
2922: and d2.entity_name = 'HZ_PARTY_RELATIONSHIPS'
2923: and batch_party_id IN (
2924: select batch_party_id
2925: from hz_merge_parties
2926: where to_party_id = cp_to_party_id
2927: and to_party_id<>from_party_id
2928: and batch_id = cp_batch_id)
2929: and d2.merge_from_entity_id <> d1.merge_to_entity_id );

Line 2934: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;

2930:
2931: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
2932: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
2933: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
2934: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
2935:
2936: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
2937: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
2938:

Line 2939: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;

2935:
2936: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
2937: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
2938:
2939: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
2940: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
2941: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;
2942: l_new_party_site_id hz_party_sites.party_site_id%type;
2943: l_proc_name hz_merge_dictionary.procedure_name%type;

Line 2940: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;

2936: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
2937: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
2938:
2939: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
2940: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
2941: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;
2942: l_new_party_site_id hz_party_sites.party_site_id%type;
2943: l_proc_name hz_merge_dictionary.procedure_name%type;
2944: l_subject_id HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;

Line 3039: where batch_party_id IN (select batch_party_id from hz_merge_parties

3035:
3036:
3037: UPDATE hz_merge_party_details
3038: set merge_to_entity_id = l_new_party_site_id
3039: where batch_party_id IN (select batch_party_id from hz_merge_parties
3040: where batch_id = p_batch_id)
3041: and merge_to_entity_id = l_merge_to_entity_id
3042: and entity_name = 'HZ_PARTY_SITES';
3043:

Line 3046: where batch_party_id IN (select batch_party_id from hz_merge_parties

3042: and entity_name = 'HZ_PARTY_SITES';
3043:
3044: UPDATE hz_merge_party_details
3045: set mandatory_merge = 'C'
3046: where batch_party_id IN (select batch_party_id from hz_merge_parties
3047: where batch_id = p_batch_id)
3048: and merge_from_entity_id = l_merge_to_entity_id
3049: and merge_to_entity_id = l_new_party_site_id
3050: and entity_name = 'HZ_PARTY_SITES';

Line 3356: FROM HZ_MERGE_PARTIES p, HZ_MERGE_BATCH b

3352: ) IS
3353:
3354: CURSOR c_merge_batch IS
3355: SELECT b.batch_id, b.batch_name, b.created_by, b.creation_date
3356: FROM HZ_MERGE_PARTIES p, HZ_MERGE_BATCH b
3357: WHERE b.batch_id = p.batch_id
3358: AND b.batch_status <> 'COMPLETE'
3359: AND (p.from_party_id = p_party_id
3360: OR p.to_party_id = p_party_id);

Line 4280: from HZ_merge_parties dup, hz_parties hp, hz_organization_profiles orgpf

4276:
4277: cursor org_c(l_dup_set_id in NUMBER)
4278: is
4279: select nvl(orgpf.internal_flag, 'N') internal_flag , hp.party_name
4280: from HZ_merge_parties dup, hz_parties hp, hz_organization_profiles orgpf
4281: where dup.batch_id = l_dup_set_id
4282: and (hp.party_id = dup.from_party_id or hp.party_id = dup.to_party_id)
4283: and hp.party_type = 'ORGANIZATION'
4284: and hp.party_id = orgpf.party_id(+)

Line 4302: from HZ_merge_parties dup, hz_parties hp, hz_person_profiles orgpf

4298:
4299: cursor person_c(l_dup_set_id in NUMBER)
4300: is
4301: select nvl(orgpf.internal_flag, 'N') internal_flag , hp.party_name
4302: from HZ_merge_parties dup, hz_parties hp, hz_person_profiles orgpf
4303: where dup.batch_id = l_dup_set_id
4304: and (hp.party_id = dup.from_party_id or hp.party_id = dup.to_party_id)
4305: and hp.party_type = 'PERSON'
4306: and hp.party_id = orgpf.party_id(+)