APPS.HZ_MIXNM_UTILITY dependencies on HZ_WIN_SOURCE_EXCEPS

Line 399: FROM hz_win_source_exceps

395: hz_select_data_sources s1,
396: (SELECT entity_attr_id,
397: content_source_type,
398: exception_type
399: FROM hz_win_source_exceps
400: WHERE party_id = p_party_id ) exp
401: WHERE e.entity_name = p_entity_name
402: AND e.entity_attr_id = s1.entity_attr_id
403: AND (s1.ranking = 1 or (s1.ranking = -1 and exp.content_source_type = s1.content_source_type))

Line 420: FROM hz_win_source_exceps

416: FROM hz_entity_attributes e,
417: (SELECT entity_attr_id,
418: content_source_type,
419: exception_type
420: FROM hz_win_source_exceps
421: WHERE party_id = p_party_id ) exp
422: WHERE e.entity_name = p_entity_name
423: AND exp.entity_attr_id (+) = e.entity_attr_id
424: and exists (select 'Y' from hz_select_data_sources s1

Line 2499: UPDATE hz_win_source_exceps

2495: i := i+1;
2496: END LOOP;
2497:
2498: FORALL i IN 1..k
2499: UPDATE hz_win_source_exceps
2500: SET content_source_type = l_data_source_type,
2501: -- exception_type = i_exception_type(i),
2502: last_updated_by = hz_utility_v2pub.last_updated_by,
2503: last_update_login = hz_utility_v2pub.last_update_login,

Line 2511: INSERT INTO hz_win_source_exceps (

2507: -- AND content_source_type <> i_real_data_source(i)
2508: -- AND i_real_data_source(i) <> i_winner(i);
2509:
2510: FORALL i IN 1..j
2511: INSERT INTO hz_win_source_exceps (
2512: party_id,
2513: entity_attr_id,
2514: content_source_type,
2515: exception_type,

Line 2593: DELETE hz_win_source_exceps

2589: END LOOP;
2590: END IF;
2591:
2592: FORALL i IN 1..j
2593: DELETE hz_win_source_exceps
2594: WHERE party_id = p_party_id
2595: AND entity_attr_id = i_entity_attr_id(i)
2596: AND i_real_data_source(i) = i_winner(i)
2597: AND exception_type <> 'MRR';

Line 2611: UPDATE hz_win_source_exceps

2607:
2608: FOR i IN 1..j LOOP
2609: IF i_exception_type(i) = 'MRR' THEN
2610:
2611: UPDATE hz_win_source_exceps
2612: SET content_source_type = l_real_data_source,
2613: exception_type = i_exception_type(i),
2614: last_updated_by = hz_utility_v2pub.last_updated_by,
2615: last_update_login = hz_utility_v2pub.last_update_login,

Line 2621: UPDATE hz_win_source_exceps

2617: WHERE party_id = p_party_id
2618: AND entity_attr_id = i_entity_attr_id(i);
2619:
2620: ELSE
2621: UPDATE hz_win_source_exceps
2622: SET content_source_type = l_real_data_source,
2623: exception_type = i_exception_type(i),
2624: last_updated_by = hz_utility_v2pub.last_updated_by,
2625: last_update_login = hz_utility_v2pub.last_update_login,

Line 2646: INSERT INTO hz_win_source_exceps (

2642: END IF;
2643:
2644: FOR i IN 1..j LOOP
2645: IF i_real_data_source(i) <> i_winner(i) THEN
2646: INSERT INTO hz_win_source_exceps (
2647: party_id,
2648: entity_attr_id,
2649: content_source_type,
2650: exception_type,

Line 2669: FROM hz_win_source_exceps

2665: hz_utility_v2pub.last_updated_by
2666: FROM dual
2667: WHERE NOT EXISTS (
2668: SELECT 'Y'
2669: FROM hz_win_source_exceps
2670: WHERE party_id = p_party_id
2671: AND entity_attr_id = i_entity_attr_id(i)
2672: AND i_exception_type(i) <> 'MRN');
2673:

Line 2812: INSERT INTO hz_win_source_exceps (

2808: ELSIF third_party_rank = 1 THEN
2809: -- this third party is already the highest ranked.
2810: NULL;
2811: ELSIF third_party_rank = 0 THEN
2812: INSERT INTO hz_win_source_exceps (
2813: party_id,
2814: entity_attr_id,
2815: content_source_type,
2816: exception_type,

Line 2840: INSERT INTO hz_win_source_exceps (

2836: and content_source_type = 'USER_ENTERED'
2837: and entity_attr_id = l_entity_attr_id;
2838: ELSE
2839: -- this third party is a selected data source but is not the highest rank.
2840: INSERT INTO hz_win_source_exceps (
2841: party_id,
2842: entity_attr_id,
2843: content_source_type,
2844: exception_type,

Line 5143: DELETE hz_win_source_exceps

5139: END IF;
5140: -- Bug 4227865 : Delete exceptions type = MRR when an
5141: -- attribute is setup as rank
5142: IF l_process_org AND l_org_total <> 0 THEN
5143: DELETE hz_win_source_exceps
5144: WHERE entity_attr_id IN
5145: (SELECT e.entity_attr_id
5146: FROM hz_entity_attributes e, hz_select_data_sources s
5147: WHERE e.entity_name = 'HZ_ORGANIZATION_PROFILES'

Line 5155: DELETE hz_win_source_exceps

5151: )
5152: and exception_type='MRR';
5153: END IF;
5154: IF l_process_person AND l_per_total <> 0 THEN
5155: DELETE hz_win_source_exceps
5156: WHERE entity_attr_id IN
5157: (SELECT e.entity_attr_id
5158: FROM hz_entity_attributes e, hz_select_data_sources s
5159: WHERE e.entity_name = 'HZ_PERSON_PROFILES'

Line 5373: AND NOT EXISTS(select 'Y' from hz_win_source_exceps

5369: NOT EXISTS(select 'Y' from hz_select_data_sources s1
5370: where s1.ranking = -1 and s1.content_source_type = p_data_source_type
5371: and s1.entity_attr_id = e.entity_attr_id)))
5372: -- Bug 4244112 : populate only if does not exist
5373: AND NOT EXISTS(select 'Y' from hz_win_source_exceps
5374: where party_id = p_party_id
5375: and entity_attr_id = e.entity_attr_id);
5376:
5377: TYPE ATTR_IDList IS TABLE OF hz_entity_attributes.entity_attr_id%TYPE;

Line 5390: INSERT INTO hz_win_source_exceps (

5386: I_ATTR_ID, I_SOURCE;
5387: CLOSE mmr_attributes;
5388:
5389: FORALL i IN 1..I_ATTR_ID.COUNT
5390: INSERT INTO hz_win_source_exceps (
5391: party_id,
5392: entity_attr_id,
5393: content_source_type,
5394: exception_type,