APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CODE_ASSIGNMENTS

Line 1412: FROM HZ_CODE_ASSIGNMENTS

1408: x_object_version_number OUT NOCOPY NUMBER
1409: ) IS
1410: CURSOR is_code_assign_id_exist(l_code_assignment_id NUMBER)IS
1411: SELECT nvl(object_version_number,1), owner_table_name, owner_table_id
1412: FROM HZ_CODE_ASSIGNMENTS
1413: WHERE code_assignment_id = l_code_assignment_id
1414: AND rownum = 1;
1415:
1416: CURSOR is_code_assign_exist(l_owner_table_name VARCHAR2, l_owner_table_id NUMBER,

Line 1419: FROM HZ_CODE_ASSIGNMENTS

1415:
1416: CURSOR is_code_assign_exist(l_owner_table_name VARCHAR2, l_owner_table_id NUMBER,
1417: l_class_category VARCHAR2, l_class_code VARCHAR2)IS
1418: SELECT nvl(object_version_number,1), code_assignment_id
1419: FROM HZ_CODE_ASSIGNMENTS
1420: WHERE owner_table_name = l_owner_table_name
1421: AND owner_table_id = l_owner_table_id
1422: AND class_category = l_class_category
1423: AND class_code = l_class_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 2867: WHEN p_bus_object.entity_name(i) = 'HZ_CODE_ASSIGNMENTS' THEN

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
2868: l_class := TRUE;
2869: WHEN p_bus_object.entity_name(i) = 'HZ_PERSON_LANGUAGE' THEN
2870: l_lang := TRUE;
2871: WHEN p_bus_object.entity_name(i) = 'HZ_EDUCATION' THEN

Line 3296: -- HZ_CODE_ASSIGNMENTS, HZ_FINANCIAL_REPORTS, HZ_FINANCIAL_NUMBERS,

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
3300: p_bus_object.business_object_code(i) = 'ORG' AND

Line 3309: WHEN p_bus_object.entity_name(i) = 'HZ_CODE_ASSIGNMENTS' THEN

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
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