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 1124: FROM HZ_PARTY_SITE_USES

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 (SELECT object_version_number, party_site_use_id,
1123: RANK() OVER (ORDER BY status asc ) rank
1124: FROM HZ_PARTY_SITE_USES
1125: WHERE party_site_id = l_party_site_id
1126: AND site_use_type = l_site_use_type )
1127: where rank = 1
1128: AND ROWNUM = 1;

Line 2676: -- entites are HZ_PARTY_SITE_USES, HZ_CONTACT_PREFERENCES

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

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

2678: p_bus_object.user_mandated_flag(i) = 'Y' AND
2679: p_bus_object.business_object_code(i) = 'PARTY_SITE' AND
2680: p_bus_object.child_bo_code(i) IS NULL) THEN
2681: CASE
2682: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_SITE_USES' THEN
2683: l_psu := TRUE;
2684: WHEN p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES' THEN
2685: l_cpref := TRUE;
2686: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_SITES_EXT_VL' THEN