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 2441: -- entity is HZ_CONTACT_PREFERENCES

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

Line 2671: -- entites are HZ_PARTY_SITE_USES, HZ_CONTACT_PREFERENCES

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

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

2675: p_bus_object.child_bo_code(i) IS NULL) THEN
2676: CASE
2677: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_SITE_USES' THEN
2678: l_psu := TRUE;
2679: WHEN p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES' THEN
2680: l_cpref := TRUE;
2681: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_SITES_EXT_VL' THEN
2682: l_ps_ext := TRUE;
2683: END CASE;

Line 2852: -- HZ_CONTACT_PREFERENCES

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

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

2872: WHEN p_bus_object.entity_name(i) = 'HZ_CERTIFICATIONS' THEN
2873: l_cert := TRUE;
2874: WHEN p_bus_object.entity_name(i) = 'HZ_FINANCIAL_PROFILE' THEN
2875: l_fin_prof := TRUE;
2876: WHEN p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES' THEN
2877: l_cpref := TRUE;
2878: WHEN p_bus_object.entity_name(i) = 'HZ_PER_PROFILES_EXT_VL' THEN
2879: l_ext := TRUE;
2880: END CASE;

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

3119: p_bus_object.business_object_code(i) = 'ORG_CONTACT' AND
3120: p_bus_object.child_bo_code(i) IS NULL) THEN
3121: IF(p_bus_object.entity_name(i) = 'HZ_ORG_CONTACT_ROLES') THEN
3122: l_ocr := TRUE;
3123: ELSIF(p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES') THEN
3124: l_cpref := TRUE;
3125: END IF;
3126: -- Get contact point business object
3127: ELSIF(p_bus_object.child_bo_code(i) IS NOT NULL AND

Line 3292: -- HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE, HZ_CONTACT_PREFERENCES

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

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

3306: WHEN p_bus_object.entity_name(i) = 'HZ_CERTIFICATIONS' THEN
3307: l_cert := TRUE;
3308: WHEN p_bus_object.entity_name(i) = 'HZ_FINANCIAL_PROFILE' THEN
3309: l_fin_prof := TRUE;
3310: WHEN p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES' THEN
3311: l_cpref := TRUE;
3312: WHEN p_bus_object.entity_name(i) = 'HZ_ORG_PROFILES_EXT_VL' THEN
3313: l_ext := TRUE;
3314: END CASE;