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 297: FROM HZ_MERGE_PARTIES mp, hz_parties p

293:
294: -----Cursor for grouping parties based on distinct merge_to party-----
295: CURSOR c_pre_merge(cp_batch_id NUMBER) IS
296: SELECT DISTINCT(to_party_id)
297: FROM HZ_MERGE_PARTIES mp, hz_parties p
298: WHERE batch_id = cp_batch_id
299: AND p.party_id = mp.from_party_id
300: AND p.party_type <> 'PARTY_RELATIONSHIP';
301:

Line 304: FROM HZ_MERGE_PARTIES mp, hz_parties p

300: AND p.party_type <> 'PARTY_RELATIONSHIP';
301:
302: CURSOR c_pre_merge_type(cp_batch_id NUMBER, cp_to_party_id NUMBER) IS
303: SELECT mp.merge_type
304: FROM HZ_MERGE_PARTIES mp, hz_parties p
305: WHERE mp.batch_id = cp_batch_id
306: AND mp.to_party_id = cp_to_party_id
307: AND p.party_id = mp.to_party_id
308: AND p.party_type <> 'PARTY_RELATIONSHIP'

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

311:
312: -----Cursor to get merge from-merge to pair parties and the type-----
313: CURSOR c_batch_details(cp_batch_id NUMBER,cp_to_party_id IN NUMBER) IS
314: SELECT batch_party_id, merge_type, from_party_id, to_party_id, merge_status,party_type, decode(op.actual_content_source, 'DNB', 'DNB', NULL)
315: FROM HZ_MERGE_PARTIES mp, HZ_PARTIES pt, hz_organization_profiles op
316: WHERE batch_id = cp_batch_id
317: AND pt.party_id = mp.from_party_id
318: AND op.party_id(+) = pt.party_id
319: AND op.actual_content_source(+) = 'DNB'

Line 383: from hz_merge_parties

379: Select application_short_name from fnd_application where application_id=app_id;
380:
381: cursor get_batch_party_id_csr is
382: select batch_party_id
383: from hz_merge_parties
384: where batch_id = p_batch_id
385: and rownum=1;
386:
387: --start bug 4634891

Line 399: from HZ_MERGE_PARTIES mp

395: group by procedure_name);
396:
397: CURSOR merge_to_parties IS
398: select DISTINCT(to_party_id)
399: from HZ_MERGE_PARTIES mp
400: where batch_id = p_batch_id
401: and merge_status = 'DONE';
402:
403:

Line 410: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;

406:
407: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
408: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
409: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
410: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
411:
412: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
413: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
414:

Line 415: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;

411:
412: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
413: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
414:
415: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
416: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
417:
418: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
419: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;

Line 416: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;

412: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
413: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
414:
415: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
416: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
417:
418: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
419: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
420:

Line 418: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;

414:
415: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
416: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
417:
418: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
419: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
420:
421: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
422: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;

Line 419: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;

415: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
416: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
417:
418: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
419: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
420:
421: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
422: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
423:

Line 421: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;

417:
418: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
419: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
420:
421: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
422: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
423:
424: l_from_site_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
425: l_to_site_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;

Line 422: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;

418: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
419: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
420:
421: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
422: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
423:
424: l_from_site_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
425: l_to_site_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
426:

Line 424: l_from_site_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;

420:
421: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
422: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
423:
424: l_from_site_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
425: l_to_site_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
426:
427: l_from_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
428: l_to_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;

Line 425: l_to_site_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;

421: l_from_party_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
422: l_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
423:
424: l_from_site_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
425: l_to_site_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
426:
427: l_from_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
428: l_to_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
429:

Line 472: l_batch_pid HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;

468: l_data_type VARCHAR2(255);
469: l_app_name VARCHAR2(100);
470: l_dss_orig_prof_val varchar2(30);
471: l_dss_update_flag varchar2(1);
472: l_batch_pid HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
473: --4230396
474: l_key VARCHAR2(240);
475: l_list WF_PARAMETER_LIST_T;
476: --4230396

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

651: --Bug No: 3267877
652: SAVEPOINT batch_merge;
653: l_batch_merge_spt:=TRUE;
654:
655: -- Lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS records
656: log ('.... Locking batch for execution');
657: lock_batch(p_batch_id, l_return_status);
658: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
659: ROLLBACK to batch_merge;

Line 897: FROM HZ_MERGE_PARTIES

893: l_to_rel_party_id IS NOT NULL AND
894: l_from_rel_party_id<>l_to_rel_party_id THEN
895: BEGIN
896: SELECT 1 INTO l_tmp
897: FROM HZ_MERGE_PARTIES
898: WHERE batch_id = l_batch_id
899: AND from_party_id = l_from_rel_party_id
900: AND to_party_id = l_to_rel_party_id
901: AND merge_status = 'DONE';

Line 957: UPDATE HZ_MERGE_PARTIES

953: IF g_merge_delete_flag = 'Y' THEN
954: delete_merged_records(l_batch_party_id, l_return_status);
955: END IF;
956:
957: UPDATE HZ_MERGE_PARTIES
958: SET MERGE_STATUS = 'DONE',
959: last_update_date = hz_utility_v2pub.last_update_date,
960: last_updated_by = hz_utility_v2pub.last_updated_by,
961: last_update_login = hz_utility_v2pub.last_update_login

Line 994: FROM HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_DETAILS md

990:
991: /* Merge all to records that are getting merged into the transferred from records */
992: FOR TO_RECORDS IN (
993: SELECT mp.batch_party_id, merge_from_entity_id, merge_to_entity_id, ENTITY_NAME
994: FROM HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_DETAILS md
995: WHERE mp.batch_party_id=md.batch_party_id
996: AND mp.to_party_id = l_pre_merge_to_party_id
997: AND mp.batch_id = l_batch_id
998: AND md.mandatory_merge = 'T') LOOP

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

1153: -- the set batch status to PART_COMPLETE if any of the merged parties
1154: -- is succesfully complete
1155: IF p_preview <> 'Y' THEN
1156:
1157: SELECT count(*) INTO l_num_merged FROM HZ_MERGE_PARTIES
1158: WHERE batch_id = p_batch_id
1159: AND merge_status = 'DONE';
1160:
1161: IF l_num_merged > 0 THEN

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

2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: END do_merge;
2034:
2035: /*------------------------------------------------------------------------------
2036: | Procedure to lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS
2037: | for a given batch
2038: |-------------------------------------------------------------------------------*/
2039:
2040: PROCEDURE lock_batch(

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

2044: BEGIN
2045: -- Lock merge party details
2046: EXECUTE IMMEDIATE 'SELECT batch_party_id from HZ_MERGE_PARTY_DETAILS ' ||
2047: 'WHERE batch_party_id IN ' ||
2048: ' (SELECT batch_party_id from HZ_MERGE_PARTIES '||
2049: ' WHERE batch_id = :batchid ) FOR UPDATE NOWAIT' USING p_batch_id;
2050:
2051: -- Lock merge parties
2052: EXECUTE IMMEDIATE 'SELECT batch_party_id from HZ_MERGE_PARTIES ' ||

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

2048: ' (SELECT batch_party_id from HZ_MERGE_PARTIES '||
2049: ' WHERE batch_id = :batchid ) FOR UPDATE NOWAIT' USING p_batch_id;
2050:
2051: -- Lock merge parties
2052: EXECUTE IMMEDIATE 'SELECT batch_party_id from HZ_MERGE_PARTIES ' ||
2053: 'WHERE batch_id = :batchid FOR UPDATE NOWAIT' USING p_batch_id;
2054:
2055: -- Lock batch
2056: EXECUTE IMMEDIATE 'SELECT batch_id from HZ_MERGE_BATCH ' ||

Line 2577: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,

2573: | Procedure to store merge history record
2574: |------------------------------------------------------------------------*/
2575:
2576: PROCEDURE store_merge_history(
2577: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2578: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2579: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2580: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2581: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

Line 2578: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,

2574: |------------------------------------------------------------------------*/
2575:
2576: PROCEDURE store_merge_history(
2577: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2578: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2579: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2580: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2581: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2582: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,

Line 2579: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

2575:
2576: PROCEDURE store_merge_history(
2577: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2578: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2579: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2580: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2581: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2582: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2583: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,

Line 2580: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

2576: PROCEDURE store_merge_history(
2577: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2578: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2579: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2580: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2581: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2582: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2583: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2584: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,

Line 2581: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

2577: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2578: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2579: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2580: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2581: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2582: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2583: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2584: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2585: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,

Line 2681: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,

2677: | be commited irrespective of the merge mode or result
2678: |---------------------------------------------------------------------------*/
2679:
2680: PROCEDURE store_merge_log(
2681: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2682: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2683: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2684: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2685: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

Line 2682: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,

2678: |---------------------------------------------------------------------------*/
2679:
2680: PROCEDURE store_merge_log(
2681: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2682: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2683: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2684: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2685: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2686: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,

Line 2683: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

2679:
2680: PROCEDURE store_merge_log(
2681: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2682: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2683: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2684: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2685: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2686: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2687: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,

Line 2684: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

2680: PROCEDURE store_merge_log(
2681: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2682: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2683: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2684: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2685: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2686: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2687: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2688: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,

Line 2685: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,

2681: p_batch_party_id IN HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE,
2682: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2683: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2684: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2685: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2686: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2687: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2688: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2689: p_op_type IN HZ_MERGE_PARTY_LOG.OPERATION_TYPE%TYPE,

Line 2846: from hz_merge_party_details d1, hz_merge_parties p

2842:
2843:
2844: CURSOR party_sites_for_pre_merge(cp_to_party_id IN NUMBER, cp_batch_id IN NUMBER) IS
2845: select merge_to_entity_id, p.from_party_id, p.batch_party_id
2846: from hz_merge_party_details d1, hz_merge_parties p
2847: where entity_name = 'HZ_PARTY_SITES'
2848: and p.batch_party_id = d1.batch_party_id
2849: and d1.batch_party_id IN ( select batch_party_id
2850: from hz_merge_parties

Line 2850: from hz_merge_parties

2846: from hz_merge_party_details d1, hz_merge_parties p
2847: where entity_name = 'HZ_PARTY_SITES'
2848: and p.batch_party_id = d1.batch_party_id
2849: and d1.batch_party_id IN ( select batch_party_id
2850: from hz_merge_parties
2851: where to_party_id = cp_to_party_id
2852: and to_party_id<>from_party_id
2853: and batch_id = cp_batch_id)
2854: and merge_from_entity_id = merge_to_entity_id --transfer operation

Line 2861: from hz_merge_parties

2857: from hz_merge_party_details d2
2858: where d2.merge_to_entity_id = d1.merge_from_entity_id
2859: and d2.entity_name = 'HZ_PARTY_SITES'
2860: and batch_party_id IN ( select batch_party_id
2861: from hz_merge_parties
2862: where to_party_id = cp_to_party_id
2863: and to_party_id<>from_party_id
2864: and batch_id = cp_batch_id)
2865: and d2.merge_from_entity_id <> d1.merge_to_entity_id );

Line 2869: from hz_merge_party_details d1, hz_merge_parties p

2865: and d2.merge_from_entity_id <> d1.merge_to_entity_id );
2866:
2867: CURSOR rel_for_pre_merge(cp_to_party_id IN NUMBER, cp_batch_id IN NUMBER) IS
2868: select merge_to_entity_id, p.from_party_id, p.batch_party_id
2869: from hz_merge_party_details d1, hz_merge_parties p
2870: where entity_name = 'HZ_PARTY_RELATIONSHIPS'
2871: and p.batch_party_id = d1.batch_party_id
2872: and d1.batch_party_id IN ( select batch_party_id
2873: from hz_merge_parties

Line 2873: from hz_merge_parties

2869: from hz_merge_party_details d1, hz_merge_parties p
2870: where entity_name = 'HZ_PARTY_RELATIONSHIPS'
2871: and p.batch_party_id = d1.batch_party_id
2872: and d1.batch_party_id IN ( select batch_party_id
2873: from hz_merge_parties
2874: where to_party_id = cp_to_party_id
2875: and to_party_id<>from_party_id
2876: and batch_id = cp_batch_id)
2877: and merge_from_entity_id = merge_to_entity_id --transfer operation

Line 2885: from hz_merge_parties

2881: where d2.merge_to_entity_id = d1.merge_from_entity_id
2882: and d2.entity_name = 'HZ_PARTY_RELATIONSHIPS'
2883: and batch_party_id IN (
2884: select batch_party_id
2885: from hz_merge_parties
2886: where to_party_id = cp_to_party_id
2887: and to_party_id<>from_party_id
2888: and batch_id = cp_batch_id)
2889: and d2.merge_from_entity_id <> d1.merge_to_entity_id );

Line 2894: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;

2890:
2891: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
2892: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
2893: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
2894: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
2895:
2896: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
2897: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
2898:

Line 2899: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;

2895:
2896: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
2897: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
2898:
2899: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
2900: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
2901: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;
2902: l_new_party_site_id hz_party_sites.party_site_id%type;
2903: l_proc_name hz_merge_dictionary.procedure_name%type;

Line 2900: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;

2896: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
2897: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
2898:
2899: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
2900: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
2901: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;
2902: l_new_party_site_id hz_party_sites.party_site_id%type;
2903: l_proc_name hz_merge_dictionary.procedure_name%type;
2904: l_subject_id HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;

Line 2999: where batch_party_id IN (select batch_party_id from hz_merge_parties

2995:
2996:
2997: UPDATE hz_merge_party_details
2998: set merge_to_entity_id = l_new_party_site_id
2999: where batch_party_id IN (select batch_party_id from hz_merge_parties
3000: where batch_id = p_batch_id)
3001: and merge_to_entity_id = l_merge_to_entity_id
3002: and entity_name = 'HZ_PARTY_SITES';
3003:

Line 3006: where batch_party_id IN (select batch_party_id from hz_merge_parties

3002: and entity_name = 'HZ_PARTY_SITES';
3003:
3004: UPDATE hz_merge_party_details
3005: set mandatory_merge = 'C'
3006: where batch_party_id IN (select batch_party_id from hz_merge_parties
3007: where batch_id = p_batch_id)
3008: and merge_from_entity_id = l_merge_to_entity_id
3009: and merge_to_entity_id = l_new_party_site_id
3010: and entity_name = 'HZ_PARTY_SITES';

Line 3316: FROM HZ_MERGE_PARTIES p, HZ_MERGE_BATCH b

3312: ) IS
3313:
3314: CURSOR c_merge_batch IS
3315: SELECT b.batch_id, b.batch_name, b.created_by, b.creation_date
3316: FROM HZ_MERGE_PARTIES p, HZ_MERGE_BATCH b
3317: WHERE b.batch_id = p.batch_id
3318: AND b.batch_status <> 'COMPLETE'
3319: AND (p.from_party_id = p_party_id
3320: OR p.to_party_id = p_party_id);

Line 3451: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = x_to_id AND merge_status='PENDING' )) --bug 4867151

3447: WHERE object_id = x_to_id
3448: AND actual_content_source = 'USER_ENTERED'
3449: AND subject_id = from_subject_id
3450: AND subject_id NOT IN
3451: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = x_to_id AND merge_status='PENDING' )) --bug 4867151
3452: AND subject_id NOT IN
3453: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = x_to_id AND merge_status='PENDING' )) --bug 4867151
3454: AND relationship_code = from_rel_code
3455: AND DIRECTIONAL_FLAG = from_directional_flag

Line 3453: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = x_to_id AND merge_status='PENDING' )) --bug 4867151

3449: AND subject_id = from_subject_id
3450: AND subject_id NOT IN
3451: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = x_to_id AND merge_status='PENDING' )) --bug 4867151
3452: AND subject_id NOT IN
3453: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = x_to_id AND merge_status='PENDING' )) --bug 4867151
3454: AND relationship_code = from_rel_code
3455: AND DIRECTIONAL_FLAG = from_directional_flag
3456: AND ((start_date between from_start_date and from_end_date)
3457: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)

Line 3862: SELECT BATCH_ID FROM HZ_MERGE_PARTIES

3858: IF FROM_REL.PARTY_ID IS NOT NULL AND
3859: l_rel_to_party_id IS NOT NULL AND
3860: l_rel_to_party_id<>FROM_REL.PARTY_ID THEN
3861: FOR BATCH IN (
3862: SELECT BATCH_ID FROM HZ_MERGE_PARTIES
3863: WHERE BATCH_PARTY_ID = p_batch_party_id) LOOP
3864: l_batch_id := BATCH.BATCH_ID;
3865: END LOOP;
3866: l_batch_party_id:=null;

Line 3867: HZ_MERGE_PARTIES_PKG.Insert_Row(

3863: WHERE BATCH_PARTY_ID = p_batch_party_id) LOOP
3864: l_batch_id := BATCH.BATCH_ID;
3865: END LOOP;
3866: l_batch_party_id:=null;
3867: HZ_MERGE_PARTIES_PKG.Insert_Row(
3868: l_batch_party_id,
3869: l_BATCH_ID,
3870: 'PARTY_MERGE',
3871: l_rel_to_party_id,

Line 3918: SELECT BATCH_ID FROM HZ_MERGE_PARTIES

3914: IF FROM_REL.PARTY_ID IS NOT NULL AND
3915: l_rel_to_party_id IS NOT NULL AND
3916: l_rel_to_party_id<>FROM_REL.PARTY_ID THEN
3917: FOR BATCH IN (
3918: SELECT BATCH_ID FROM HZ_MERGE_PARTIES
3919: WHERE BATCH_PARTY_ID = p_batch_party_id) LOOP
3920: l_batch_id := BATCH.BATCH_ID;
3921: END LOOP;
3922: l_batch_party_id:=null;

Line 3923: HZ_MERGE_PARTIES_PKG.Insert_Row(

3919: WHERE BATCH_PARTY_ID = p_batch_party_id) LOOP
3920: l_batch_id := BATCH.BATCH_ID;
3921: END LOOP;
3922: l_batch_party_id:=null;
3923: HZ_MERGE_PARTIES_PKG.Insert_Row(
3924: l_batch_party_id,
3925: l_BATCH_ID,
3926: 'PARTY_MERGE',
3927: FROM_REL.PARTY_ID,

Line 4059: FROM HZ_MERGE_PARTIES

4055: FETCH c_check_duplicates INTO l_to,l_rel_to_party_id;
4056: IF c_check_duplicates%FOUND THEN
4057: l_batch_party_id:=null;
4058: SELECT batch_id INTO l_batch_id
4059: FROM HZ_MERGE_PARTIES
4060: WHERE batch_party_id = p_batch_party_id;
4061:
4062: HZ_MERGE_PARTIES_PKG.Insert_Row(
4063: l_batch_party_id,

Line 4062: HZ_MERGE_PARTIES_PKG.Insert_Row(

4058: SELECT batch_id INTO l_batch_id
4059: FROM HZ_MERGE_PARTIES
4060: WHERE batch_party_id = p_batch_party_id;
4061:
4062: HZ_MERGE_PARTIES_PKG.Insert_Row(
4063: l_batch_party_id,
4064: l_BATCH_ID,
4065: 'PARTY_MERGE',
4066: FROM_REL.PARTY_ID,

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

4678:
4679: cursor org_c(l_dup_set_id in NUMBER)
4680: is
4681: select nvl(orgpf.internal_flag, 'N') internal_flag , hp.party_name
4682: from HZ_merge_parties dup, hz_parties hp, hz_organization_profiles orgpf
4683: where dup.batch_id = l_dup_set_id
4684: and (hp.party_id = dup.from_party_id or hp.party_id = dup.to_party_id)
4685: and hp.party_type = 'ORGANIZATION'
4686: and hp.party_id = orgpf.party_id(+)

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

4700:
4701: cursor person_c(l_dup_set_id in NUMBER)
4702: is
4703: select nvl(orgpf.internal_flag, 'N') internal_flag , hp.party_name
4704: from HZ_merge_parties dup, hz_parties hp, hz_person_profiles orgpf
4705: where dup.batch_id = l_dup_set_id
4706: and (hp.party_id = dup.from_party_id or hp.party_id = dup.to_party_id)
4707: and hp.party_type = 'PERSON'
4708: and hp.party_id = orgpf.party_id(+)