APPS.HZ_MIXNM_UTILITY dependencies on HZ_WIN_SOURCE_EXCEPS

Line 402: FROM hz_win_source_exceps

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

Line 423: FROM hz_win_source_exceps

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

Line 2509: UPDATE hz_win_source_exceps

2505: i := i+1;
2506: END LOOP;
2507:
2508: FORALL i IN 1..k
2509: UPDATE hz_win_source_exceps
2510: SET content_source_type = l_data_source_type,
2511: -- exception_type = i_exception_type(i),
2512: last_updated_by = hz_utility_v2pub.last_updated_by,
2513: last_update_login = hz_utility_v2pub.last_update_login,

Line 2521: INSERT INTO hz_win_source_exceps (

2517: -- AND content_source_type <> i_real_data_source(i)
2518: -- AND i_real_data_source(i) <> i_winner(i);
2519:
2520: FORALL i IN 1..j
2521: INSERT INTO hz_win_source_exceps (
2522: party_id,
2523: entity_attr_id,
2524: content_source_type,
2525: exception_type,

Line 2603: DELETE hz_win_source_exceps

2599: END LOOP;
2600: END IF;
2601:
2602: FORALL i IN 1..j
2603: DELETE hz_win_source_exceps
2604: WHERE party_id = p_party_id
2605: AND entity_attr_id = i_entity_attr_id(i)
2606: AND i_real_data_source(i) = i_winner(i)
2607: AND exception_type <> 'MRR';

Line 2621: UPDATE hz_win_source_exceps

2617:
2618: FOR i IN 1..j LOOP
2619: IF i_exception_type(i) = 'MRR' THEN
2620:
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 2631: UPDATE hz_win_source_exceps

2627: WHERE party_id = p_party_id
2628: AND entity_attr_id = i_entity_attr_id(i);
2629:
2630: ELSE
2631: UPDATE hz_win_source_exceps
2632: SET content_source_type = l_real_data_source,
2633: exception_type = i_exception_type(i),
2634: last_updated_by = hz_utility_v2pub.last_updated_by,
2635: last_update_login = hz_utility_v2pub.last_update_login,

Line 2656: INSERT INTO hz_win_source_exceps (

2652: END IF;
2653:
2654: FOR i IN 1..j LOOP
2655: IF i_real_data_source(i) <> i_winner(i) THEN
2656: INSERT INTO hz_win_source_exceps (
2657: party_id,
2658: entity_attr_id,
2659: content_source_type,
2660: exception_type,

Line 2679: FROM hz_win_source_exceps

2675: hz_utility_v2pub.last_updated_by
2676: FROM dual
2677: WHERE NOT EXISTS (
2678: SELECT 'Y'
2679: FROM hz_win_source_exceps
2680: WHERE party_id = p_party_id
2681: AND entity_attr_id = i_entity_attr_id(i)
2682: AND i_exception_type(i) <> 'MRN');
2683:

Line 2822: INSERT INTO hz_win_source_exceps (

2818: ELSIF third_party_rank = 1 THEN
2819: -- this third party is already the highest ranked.
2820: NULL;
2821: ELSIF third_party_rank = 0 THEN
2822: INSERT INTO hz_win_source_exceps (
2823: party_id,
2824: entity_attr_id,
2825: content_source_type,
2826: exception_type,

Line 2850: INSERT INTO hz_win_source_exceps (

2846: and content_source_type = 'USER_ENTERED'
2847: and entity_attr_id = l_entity_attr_id;
2848: ELSE
2849: -- this third party is a selected data source but is not the highest rank.
2850: INSERT INTO hz_win_source_exceps (
2851: party_id,
2852: entity_attr_id,
2853: content_source_type,
2854: exception_type,

Line 5173: DELETE hz_win_source_exceps

5169: END IF;
5170: -- Bug 4227865 : Delete exceptions type = MRR when an
5171: -- attribute is setup as rank
5172: IF l_process_org AND l_org_total <> 0 THEN
5173: DELETE hz_win_source_exceps
5174: WHERE entity_attr_id IN
5175: (SELECT e.entity_attr_id
5176: FROM hz_entity_attributes e, hz_select_data_sources s
5177: WHERE e.entity_name = 'HZ_ORGANIZATION_PROFILES'

Line 5185: DELETE hz_win_source_exceps

5181: )
5182: and exception_type='MRR';
5183: END IF;
5184: IF l_process_person AND l_per_total <> 0 THEN
5185: DELETE hz_win_source_exceps
5186: WHERE entity_attr_id IN
5187: (SELECT e.entity_attr_id
5188: FROM hz_entity_attributes e, hz_select_data_sources s
5189: WHERE e.entity_name = 'HZ_PERSON_PROFILES'

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

5400: NOT EXISTS(select 'Y' from hz_select_data_sources s1
5401: where s1.ranking = -1 and s1.content_source_type = p_data_source_type
5402: and s1.entity_attr_id = e.entity_attr_id)))
5403: -- Bug 4244112 : populate only if does not exist
5404: AND NOT EXISTS(select 'Y' from hz_win_source_exceps
5405: where party_id = p_party_id
5406: and entity_attr_id = e.entity_attr_id);
5407:
5408: TYPE ATTR_IDList IS TABLE OF hz_entity_attributes.entity_attr_id%TYPE;

Line 5421: INSERT INTO hz_win_source_exceps (

5417: I_ATTR_ID, I_SOURCE;
5418: CLOSE mmr_attributes;
5419:
5420: FORALL i IN 1..I_ATTR_ID.COUNT
5421: INSERT INTO hz_win_source_exceps (
5422: party_id,
5423: entity_attr_id,
5424: content_source_type,
5425: exception_type,