DBA Data[Home] [Help]

APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CODE_ASSIGNMENTS

Line 1409: FROM HZ_CODE_ASSIGNMENTS

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

Line 1416: FROM HZ_CODE_ASSIGNMENTS

1412:
1413: CURSOR is_code_assign_exist(l_owner_table_name VARCHAR2, l_owner_table_id NUMBER,
1414: l_class_category VARCHAR2, l_class_code VARCHAR2)IS
1415: SELECT nvl(object_version_number,1), code_assignment_id
1416: FROM HZ_CODE_ASSIGNMENTS
1417: WHERE owner_table_name = l_owner_table_name
1418: AND owner_table_id = l_owner_table_id
1419: AND class_category = l_class_category
1420: AND class_code = l_class_code

Line 2849: -- HZ_PARTY_PREFERENCES, HZ_RELATIONSHIPS, HZ_CODE_ASSIGNMENTS,

2845: l_ext := FALSE;
2846:
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

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

2858: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_PREFERENCES' THEN
2859: l_pref := TRUE;
2860: WHEN p_bus_object.entity_name(i) = 'HZ_RELATIONSHIPS' THEN
2861: l_rel := TRUE;
2862: WHEN p_bus_object.entity_name(i) = 'HZ_CODE_ASSIGNMENTS' THEN
2863: l_class := TRUE;
2864: WHEN p_bus_object.entity_name(i) = 'HZ_PERSON_LANGUAGE' THEN
2865: l_lang := TRUE;
2866: WHEN p_bus_object.entity_name(i) = 'HZ_EDUCATION' THEN

Line 3291: -- HZ_CODE_ASSIGNMENTS, HZ_FINANCIAL_REPORTS, HZ_FINANCIAL_NUMBERS,

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

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

3300: WHEN p_bus_object.entity_name(i) = 'HZ_CREDIT_RATINGS' THEN
3301: l_credit := TRUE;
3302: WHEN p_bus_object.entity_name(i) = 'HZ_RELATIONSHIPS' THEN
3303: l_rel := TRUE;
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