APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_PARTY_SITES

Line 129: from HZ_PARTY_SITES

125: and party_type = l_party_type;
126:
127: CURSOR is_ps_parent_valid(l_party_site_id NUMBER) IS
128: select 'Y'
129: from HZ_PARTY_SITES
130: where party_site_id = l_party_site_id;
131:
132: CURSOR is_acct_parent_valid(l_acct_id NUMBER) IS
133: select 'Y'

Line 181: ELSIF(l_owner_table_name = 'HZ_PARTY_SITES') THEN

177: END IF;
178: OPEN is_p_parent_valid(px_parent_id, l_party_type);
179: FETCH is_p_parent_valid INTO l_valid_parent;
180: CLOSE is_p_parent_valid;
181: ELSIF(l_owner_table_name = 'HZ_PARTY_SITES') THEN
182: OPEN is_ps_parent_valid(px_parent_id);
183: FETCH is_ps_parent_valid INTO l_valid_parent;
184: CLOSE is_ps_parent_valid;
185: ELSIF(l_owner_table_name = 'HZ_CUST_ACCOUNTS') THEN

Line 377: FROM HZ_PARTY_SITES

373: AND status in ('A', 'I');
374:
375: CURSOR is_ps_valid(l_ps_id NUMBER) IS
376: SELECT 'X'
377: FROM HZ_PARTY_SITES
378: WHERE party_site_id = l_ps_id;
379:
380: CURSOR is_loc_valid(l_loc_id NUMBER) IS
381: SELECT 'X'

Line 458: ELSIF(p_obj_type = 'HZ_PARTY_SITES') THEN

454: ELSIF(p_obj_type = 'HZ_LOCATIONS') THEN
455: OPEN is_loc_valid(px_id);
456: FETCH is_loc_valid INTO l_valid_id;
457: CLOSE is_loc_valid;
458: ELSIF(p_obj_type = 'HZ_PARTY_SITES') THEN
459: OPEN is_ps_valid(px_id);
460: FETCH is_ps_valid INTO l_valid_id;
461: CLOSE is_ps_valid;
462: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNTS') THEN

Line 1965: FROM HZ_PARTY_SITES

1961: AND contact_point_type = l_contact_point_type;
1962:
1963: CURSOR is_party_site_exist(l_ps_id NUMBER) IS
1964: SELECT party_id
1965: FROM HZ_PARTY_SITES
1966: WHERE party_site_id = l_ps_id;
1967:
1968: CURSOR is_location_exist(l_loc_id NUMBER) IS
1969: SELECT 'X'

Line 2044: ELSIF(p_entity_type = 'HZ_PARTY_SITES') THEN

2040: FND_MSG_PUB.ADD;
2041: RETURN 'E';
2042: END IF;
2043: l_dummy := 'X';
2044: ELSIF(p_entity_type = 'HZ_PARTY_SITES') THEN
2045: OPEN is_party_site_exist(p_entity_id);
2046: FETCH is_party_site_exist INTO l_parent_id;
2047: CLOSE is_party_site_exist;
2048: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN

Line 2287: RETURN 'HZ_PARTY_SITES';

2283: ) RETURN VARCHAR2 IS
2284: BEGIN
2285: -- Base on HZ_BUSINESS_OBJECTS lookup code
2286: IF(p_obj_type = 'PARTY_SITE') THEN
2287: RETURN 'HZ_PARTY_SITES';
2288: ELSIF((p_obj_type = 'ORG') OR (p_obj_type = 'PERSON') OR (p_obj_type = 'ORG_CONTACT')) THEN
2289: RETURN 'HZ_PARTIES';
2290: ELSIF((p_obj_type = 'ORG_CUST') OR (p_obj_type = 'PERSON_CUST') OR (p_obj_type = 'CUST_ACCT')) THEN
2291: RETURN 'HZ_CUST_ACCOUNTS';

Line 2352: IF(p_parent_table_name = 'HZ_PARTY_SITES') THEN

2348: FETCH c2 INTO l_party_type;
2349: CLOSE c2;
2350: END IF;
2351:
2352: IF(p_parent_table_name = 'HZ_PARTY_SITES') THEN
2353: RETURN 'PARTY_SITE';
2354: ELSIF(p_parent_table_name = 'HZ_PARTIES') THEN
2355: IF(l_party_type = 'ORGANIZATION') THEN
2356: RETURN 'ORG';

Line 2681: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_SITES_EXT_VL' THEN

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
2682: l_ps_ext := TRUE;
2683: END CASE;
2684: -- Get contact point business object
2685: ELSIF(p_bus_object.child_bo_code(i) IS NOT NULL AND