APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_FINANCIAL_PROFILE

Line 1357: FROM HZ_FINANCIAL_PROFILE

1353: x_return_status OUT NOCOPY VARCHAR2
1354: ) IS
1355: CURSOR is_fin_exist(l_fin_prof_id NUMBER) IS
1356: SELECT last_update_date, party_id
1357: FROM HZ_FINANCIAL_PROFILE
1358: WHERE financial_profile_id = l_fin_prof_id
1359: AND rownum = 1;
1360:
1361: l_party_id NUMBER;

Line 2851: -- HZ_PERSON_INTEREST, HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE,

2847: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
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

Line 2874: WHEN p_bus_object.entity_name(i) = 'HZ_FINANCIAL_PROFILE' THEN

2870: WHEN p_bus_object.entity_name(i) = 'HZ_PERSON_INTEREST' THEN
2871: l_int := TRUE;
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

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 3308: WHEN p_bus_object.entity_name(i) = 'HZ_FINANCIAL_PROFILE' THEN

3304: WHEN p_bus_object.entity_name(i) = 'HZ_CODE_ASSIGNMENTS' THEN
3305: l_class := TRUE;
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