APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_PERSON_INTEREST

Line 1051: FROM HZ_PERSON_INTEREST

1047: x_object_version_number OUT NOCOPY NUMBER
1048: ) IS
1049: CURSOR is_interest_id_exist(l_interest_id NUMBER)IS
1050: SELECT nvl(object_version_number,1), party_id
1051: FROM HZ_PERSON_INTEREST
1052: WHERE person_interest_id = l_interest_id
1053: AND rownum = 1;
1054:
1055: CURSOR is_interest_exist(l_party_id NUMBER, l_interest_type_code VARCHAR2,

Line 1059: FROM HZ_PERSON_INTEREST

1055: CURSOR is_interest_exist(l_party_id NUMBER, l_interest_type_code VARCHAR2,
1056: l_sub_interest_type_code VARCHAR2,
1057: l_interest_name VARCHAR2)IS
1058: SELECT nvl(object_version_number,1), person_interest_id
1059: FROM HZ_PERSON_INTEREST
1060: WHERE party_id = l_party_id
1061: AND (
1062: (nvl(INTEREST_TYPE_CODE,'X') = nvl(l_interest_type_code,'X') AND
1063: nvl(SUB_INTEREST_TYPE_CODE,'X') = nvl(l_sub_interest_type_code,'X'))

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

2866: WHEN p_bus_object.entity_name(i) = 'HZ_EDUCATION' THEN
2867: l_edu := TRUE;
2868: WHEN p_bus_object.entity_name(i) = 'HZ_CITIZENSHIP' THEN
2869: l_citiz := TRUE;
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