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 1970: FROM HZ_PARTY_SITES

1966: AND contact_point_type = l_contact_point_type;
1967:
1968: CURSOR is_party_site_exist(l_ps_id NUMBER) IS
1969: SELECT party_id
1970: FROM HZ_PARTY_SITES
1971: WHERE party_site_id = l_ps_id;
1972:
1973: CURSOR is_location_exist(l_loc_id NUMBER) IS
1974: SELECT 'X'

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

2045: FND_MSG_PUB.ADD;
2046: RETURN 'E';
2047: END IF;
2048: l_dummy := 'X';
2049: ELSIF(p_entity_type = 'HZ_PARTY_SITES') THEN
2050: OPEN is_party_site_exist(p_entity_id);
2051: FETCH is_party_site_exist INTO l_parent_id;
2052: CLOSE is_party_site_exist;
2053: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN

Line 2292: RETURN 'HZ_PARTY_SITES';

2288: ) RETURN VARCHAR2 IS
2289: BEGIN
2290: -- Base on HZ_BUSINESS_OBJECTS lookup code
2291: IF(p_obj_type = 'PARTY_SITE') THEN
2292: RETURN 'HZ_PARTY_SITES';
2293: ELSIF((p_obj_type = 'ORG') OR (p_obj_type = 'PERSON') OR (p_obj_type = 'ORG_CONTACT')) THEN
2294: RETURN 'HZ_PARTIES';
2295: ELSIF((p_obj_type = 'ORG_CUST') OR (p_obj_type = 'PERSON_CUST') OR (p_obj_type = 'CUST_ACCT')) THEN
2296: RETURN 'HZ_CUST_ACCOUNTS';

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

2353: FETCH c2 INTO l_party_type;
2354: CLOSE c2;
2355: END IF;
2356:
2357: IF(p_parent_table_name = 'HZ_PARTY_SITES') THEN
2358: RETURN 'PARTY_SITE';
2359: ELSIF(p_parent_table_name = 'HZ_PARTIES') THEN
2360: IF(l_party_type = 'ORGANIZATION') THEN
2361: RETURN 'ORG';

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

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
2687: l_ps_ext := TRUE;
2688: END CASE;
2689: -- Get contact point business object
2690: ELSIF(p_bus_object.child_bo_code(i) IS NOT NULL AND