APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_PARTY_SITES

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

95: close c2;
96: end if;
97:
98: -- Base on owner_table_name to return HZ_BUSINESS_OBJECTS lookup code
99: IF(p_parent_table_name = 'HZ_PARTY_SITES') THEN
100: RETURN 'PARTY_SITE';
101: ELSIF(p_parent_table_name = 'HZ_PARTIES') THEN
102: IF(l_party_type = 'ORGANIZATION') THEN
103: RETURN 'ORG';

Line 312: FROM HZ_PARTY_SITES

308: AND status in ('A', 'I');
309:
310: CURSOR is_ps_valid(l_ps_id NUMBER) IS
311: SELECT 'X'
312: FROM HZ_PARTY_SITES
313: WHERE party_site_id = l_ps_id;
314:
315: CURSOR is_loc_valid(l_loc_id NUMBER) IS
316: SELECT 'X'

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

380: ELSIF(p_obj_type = 'HZ_LOCATIONS') THEN
381: OPEN is_loc_valid(px_id);
382: FETCH is_loc_valid INTO l_valid_id;
383: CLOSE is_loc_valid;
384: ELSIF(p_obj_type = 'HZ_PARTY_SITES') THEN
385: OPEN is_ps_valid(px_id);
386: FETCH is_ps_valid INTO l_valid_id;
387: CLOSE is_ps_valid;
388: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNTS') THEN