APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CERTIFICATIONS

Line 1303: FROM HZ_CERTIFICATIONS

1299: x_return_status OUT NOCOPY VARCHAR2
1300: ) IS
1301: CURSOR is_cert_id_exist(l_cert_id NUMBER) IS
1302: SELECT last_update_date, party_id
1303: FROM HZ_CERTIFICATIONS
1304: WHERE certification_id = l_cert_id
1305: AND rownum = 1;
1306:
1307: CURSOR is_cert_exist(l_party_id NUMBER, l_cert_name VARCHAR2) IS

Line 1309: FROM HZ_CERTIFICATIONS

1305: AND rownum = 1;
1306:
1307: CURSOR is_cert_exist(l_party_id NUMBER, l_cert_name VARCHAR2) IS
1308: SELECT last_update_date, certification_id
1309: FROM HZ_CERTIFICATIONS
1310: WHERE party_id = l_party_id
1311: AND certification_name = l_cert_name
1312: AND status in ('A','I')
1313: AND rownum = 1;

Line 2856: -- HZ_PERSON_INTEREST, HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE,

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
2859: p_bus_object.user_mandated_flag(i) = 'Y' AND
2860: p_bus_object.business_object_code(i) = 'PERSON' AND

Line 2877: WHEN p_bus_object.entity_name(i) = 'HZ_CERTIFICATIONS' THEN

2873: WHEN p_bus_object.entity_name(i) = 'HZ_CITIZENSHIP' THEN
2874: l_citiz := TRUE;
2875: WHEN p_bus_object.entity_name(i) = 'HZ_PERSON_INTEREST' THEN
2876: l_int := TRUE;
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

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

3307: WHEN p_bus_object.entity_name(i) = 'HZ_RELATIONSHIPS' THEN
3308: l_rel := TRUE;
3309: WHEN p_bus_object.entity_name(i) = 'HZ_CODE_ASSIGNMENTS' THEN
3310: l_class := TRUE;
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