APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_PARTY_PREFERENCES

Line 1478: FROM HZ_PARTY_PREFERENCES

1474: ) IS
1475: CURSOR is_party_pref_exist(l_party_id NUMBER, l_module VARCHAR2,
1476: l_category VARCHAR2, l_preference_code VARCHAR2) IS
1477: SELECT nvl(object_version_number,1)
1478: FROM HZ_PARTY_PREFERENCES
1479: WHERE party_id = l_party_id
1480: AND module = l_module
1481: AND category = l_category
1482: AND preference_code = l_preference_code

Line 2854: -- HZ_PARTY_PREFERENCES, HZ_RELATIONSHIPS, HZ_CODE_ASSIGNMENTS,

2850: l_ext := FALSE;
2851:
2852: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
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

Line 2863: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_PREFERENCES' THEN

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
2862: CASE
2863: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_PREFERENCES' THEN
2864: l_pref := TRUE;
2865: WHEN p_bus_object.entity_name(i) = 'HZ_RELATIONSHIPS' THEN
2866: l_rel := TRUE;
2867: WHEN p_bus_object.entity_name(i) = 'HZ_CODE_ASSIGNMENTS' THEN

Line 3295: -- HZ_PARTY_PREFERENCES, HZ_CREDIT_RATINGS, HZ_RELATIONSHIPS,

3291: l_ext := FALSE;
3292:
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

Line 3303: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_PREFERENCES' THEN

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
3302: CASE
3303: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_PREFERENCES' THEN
3304: l_pref := TRUE;
3305: WHEN p_bus_object.entity_name(i) = 'HZ_CREDIT_RATINGS' THEN
3306: l_credit := TRUE;
3307: WHEN p_bus_object.entity_name(i) = 'HZ_RELATIONSHIPS' THEN