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_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CONTACT_PREFERENCES

Line 672: FROM HZ_CONTACT_PREFERENCES

668: x_object_version_number OUT NOCOPY NUMBER
669: ) IS
670: CURSOR is_contact_pref_id_exist(l_contact_pref_id NUMBER)IS
671: SELECT nvl(object_version_number,1), contact_level_table_id, contact_level_table
672: FROM HZ_CONTACT_PREFERENCES
673: WHERE contact_preference_id = l_contact_pref_id
674: AND rownum = 1;
675:
676: CURSOR is_contact_pref_exist(l_contact_level_table_id NUMBER,

Line 682: FROM HZ_CONTACT_PREFERENCES

678: l_contact_type VARCHAR2,
679: l_preference_code VARCHAR2, l_preference_start_date DATE,
680: l_preference_end_date DATE)IS
681: SELECT nvl(object_version_number,1), contact_preference_id
682: FROM HZ_CONTACT_PREFERENCES
683: WHERE contact_level_table_id = l_contact_level_table_id
684: AND contact_level_table = l_contact_level_table
685: AND contact_type = l_contact_type
686: -- AND preference_code = l_preference_code

Line 2446: -- entity is HZ_CONTACT_PREFERENCES

2442: l_bus_object.entity_name := ent_tbl();
2443:
2444: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
2445: -- get all entity of contact point, for contact point, the only possible
2446: -- entity is HZ_CONTACT_PREFERENCES
2447: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
2448: p_bus_object.user_mandated_flag(i) = 'Y' AND
2449: p_bus_object.root_node_flag(i) = 'N') THEN
2450: CASE

Line 2676: -- entites are HZ_PARTY_SITE_USES, HZ_CONTACT_PREFERENCES

2672: END IF;
2673:
2674: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
2675: -- get all entities of party site, for party site, the only possible
2676: -- entites are HZ_PARTY_SITE_USES, HZ_CONTACT_PREFERENCES
2677: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
2678: p_bus_object.user_mandated_flag(i) = 'Y' AND
2679: p_bus_object.business_object_code(i) = 'PARTY_SITE' AND
2680: p_bus_object.child_bo_code(i) IS NULL) THEN

Line 2684: WHEN p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES' THEN

2680: p_bus_object.child_bo_code(i) IS NULL) THEN
2681: CASE
2682: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_SITE_USES' THEN
2683: l_psu := TRUE;
2684: WHEN p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES' THEN
2685: l_cpref := TRUE;
2686: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_SITES_EXT_VL' THEN
2687: l_ps_ext := TRUE;
2688: END CASE;

Line 2857: -- HZ_CONTACT_PREFERENCES

2853: -- get all entities of person, for person, the possible entites are
2854: -- HZ_PARTY_PREFERENCES, HZ_RELATIONSHIPS, HZ_CODE_ASSIGNMENTS,
2855: -- HZ_PERSON_LANGUAGE, HZ_EDUCATION, HZ_CITIZENSHIP, HZ_EMPLOYMENT_HISTORY
2856: -- HZ_PERSON_INTEREST, HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE,
2857: -- HZ_CONTACT_PREFERENCES
2858: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
2859: p_bus_object.user_mandated_flag(i) = 'Y' AND
2860: p_bus_object.business_object_code(i) = 'PERSON' AND
2861: p_bus_object.child_bo_code(i) IS NULL) THEN

Line 2881: WHEN p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES' THEN

2877: WHEN p_bus_object.entity_name(i) = 'HZ_CERTIFICATIONS' THEN
2878: l_cert := TRUE;
2879: WHEN p_bus_object.entity_name(i) = 'HZ_FINANCIAL_PROFILE' THEN
2880: l_fin_prof := TRUE;
2881: WHEN p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES' THEN
2882: l_cpref := TRUE;
2883: WHEN p_bus_object.entity_name(i) = 'HZ_PER_PROFILES_EXT_VL' THEN
2884: l_ext := TRUE;
2885: END CASE;

Line 3128: ELSIF(p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES') THEN

3124: p_bus_object.business_object_code(i) = 'ORG_CONTACT' AND
3125: p_bus_object.child_bo_code(i) IS NULL) THEN
3126: IF(p_bus_object.entity_name(i) = 'HZ_ORG_CONTACT_ROLES') THEN
3127: l_ocr := TRUE;
3128: ELSIF(p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES') THEN
3129: l_cpref := TRUE;
3130: END IF;
3131: -- Get contact point business object
3132: ELSIF(p_bus_object.child_bo_code(i) IS NOT NULL AND

Line 3297: -- HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE, HZ_CONTACT_PREFERENCES

3293: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3294: -- get all entities of org, for org, the possible entites are
3295: -- HZ_PARTY_PREFERENCES, HZ_CREDIT_RATINGS, HZ_RELATIONSHIPS,
3296: -- HZ_CODE_ASSIGNMENTS, HZ_FINANCIAL_REPORTS, HZ_FINANCIAL_NUMBERS,
3297: -- HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE, HZ_CONTACT_PREFERENCES
3298: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
3299: p_bus_object.user_mandated_flag(i) = 'Y' AND
3300: p_bus_object.business_object_code(i) = 'ORG' AND
3301: p_bus_object.child_bo_code(i) IS NULL) THEN

Line 3315: WHEN p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES' THEN

3311: WHEN p_bus_object.entity_name(i) = 'HZ_CERTIFICATIONS' THEN
3312: l_cert := TRUE;
3313: WHEN p_bus_object.entity_name(i) = 'HZ_FINANCIAL_PROFILE' THEN
3314: l_fin_prof := TRUE;
3315: WHEN p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES' THEN
3316: l_cpref := TRUE;
3317: WHEN p_bus_object.entity_name(i) = 'HZ_ORG_PROFILES_EXT_VL' THEN
3318: l_ext := TRUE;
3319: END CASE;