APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_PARTY_SITE_USES

Line 1116: FROM HZ_PARTY_SITE_USES

1112: x_object_version_number OUT NOCOPY NUMBER
1113: ) IS
1114: CURSOR is_party_site_use_id_exist(l_site_use_id NUMBER)IS
1115: SELECT nvl(object_version_number,1), party_site_id
1116: FROM HZ_PARTY_SITE_USES
1117: WHERE party_site_use_id = l_site_use_id
1118: AND rownum = 1;
1119:
1120: CURSOR is_party_site_use_exist(l_party_site_id NUMBER, l_site_use_type VARCHAR2)IS

Line 1122: FROM HZ_PARTY_SITE_USES

1118: AND rownum = 1;
1119:
1120: CURSOR is_party_site_use_exist(l_party_site_id NUMBER, l_site_use_type VARCHAR2)IS
1121: SELECT nvl(object_version_number,1), party_site_use_id
1122: FROM HZ_PARTY_SITE_USES
1123: WHERE party_site_id = l_party_site_id
1124: AND site_use_type = l_site_use_type
1125: AND status in ('A','I')
1126: AND rownum = 1;

Line 2671: -- entites are HZ_PARTY_SITE_USES, HZ_CONTACT_PREFERENCES

2667: END IF;
2668:
2669: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
2670: -- get all entities of party site, for party site, the only possible
2671: -- entites are HZ_PARTY_SITE_USES, HZ_CONTACT_PREFERENCES
2672: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
2673: p_bus_object.user_mandated_flag(i) = 'Y' AND
2674: p_bus_object.business_object_code(i) = 'PARTY_SITE' AND
2675: p_bus_object.child_bo_code(i) IS NULL) THEN

Line 2677: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_SITE_USES' THEN

2673: p_bus_object.user_mandated_flag(i) = 'Y' AND
2674: p_bus_object.business_object_code(i) = 'PARTY_SITE' AND
2675: p_bus_object.child_bo_code(i) IS NULL) THEN
2676: CASE
2677: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_SITE_USES' THEN
2678: l_psu := TRUE;
2679: WHEN p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES' THEN
2680: l_cpref := TRUE;
2681: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_SITES_EXT_VL' THEN