APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CUST_ACCT_SITES

Line 139: from HZ_CUST_ACCT_SITES_ALL

135: where cust_account_id = l_acct_id;
136:
137: CURSOR is_acct_site_parent_valid(l_acct_site_id NUMBER) IS
138: select 'Y'
139: from HZ_CUST_ACCT_SITES_ALL
140: where cust_acct_site_id = l_acct_site_id;
141:
142: l_party_type VARCHAR2(30);
143: l_valid_parent VARCHAR2(1);

Line 189: ELSIF(l_owner_table_name = 'HZ_CUST_ACCT_SITES_ALL') THEN

185: ELSIF(l_owner_table_name = 'HZ_CUST_ACCOUNTS') THEN
186: OPEN is_acct_parent_valid(px_parent_id);
187: FETCH is_acct_parent_valid INTO l_valid_parent;
188: CLOSE is_acct_parent_valid;
189: ELSIF(l_owner_table_name = 'HZ_CUST_ACCT_SITES_ALL') THEN
190: OPEN is_acct_site_parent_valid(px_parent_id);
191: FETCH is_acct_site_parent_valid INTO l_valid_parent;
192: CLOSE is_acct_site_parent_valid;
193: END IF;

Line 397: FROM HZ_CUST_ACCT_SITES

393: WHERE cust_account_id = l_ca_id;
394:
395: CURSOR is_cas_valid(l_cas_id NUMBER, l_org_id NUMBER) IS
396: SELECT 'X'
397: FROM HZ_CUST_ACCT_SITES
398: WHERE cust_acct_site_id = l_cas_id
399: AND org_id = l_org_id;
400:
401: CURSOR is_casu_valid(l_casu_id NUMBER, l_org_id NUMBER) IS

Line 466: ELSIF(p_obj_type = 'HZ_CUST_ACCT_SITES_ALL') THEN

462: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNTS') THEN
463: OPEN is_ca_valid(px_id);
464: FETCH is_ca_valid INTO l_valid_id;
465: CLOSE is_ca_valid;
466: ELSIF(p_obj_type = 'HZ_CUST_ACCT_SITES_ALL') THEN
467: OPEN is_cas_valid(px_id, p_org_id);
468: FETCH is_cas_valid INTO l_valid_id;
469: CLOSE is_cas_valid;
470: ELSIF(p_obj_type = 'HZ_CUST_SITE_USES_ALL') THEN

Line 1999: FROM HZ_CUST_ACCT_SITES_ALL

1995: WHERE cust_account_id = l_cust_acct_id;
1996:
1997: CURSOR is_cust_acct_site_exist(l_cust_acct_site_id NUMBER) IS
1998: SELECT cust_account_id
1999: FROM HZ_CUST_ACCT_SITES_ALL
2000: WHERE cust_acct_site_id = l_cust_acct_site_id;
2001:
2002: CURSOR is_cust_site_use_exist(l_site_use_id NUMBER) IS
2003: SELECT cust_acct_site_id

Line 2087: ELSIF(p_entity_type = 'HZ_CUST_ACCT_SITES_ALL') THEN

2083: FND_MSG_PUB.ADD;
2084: RETURN 'E';
2085: END IF;
2086: l_dummy := 'X';
2087: ELSIF(p_entity_type = 'HZ_CUST_ACCT_SITES_ALL') THEN
2088: OPEN is_cust_acct_site_exist(p_entity_id);
2089: FETCH is_cust_acct_site_exist INTO l_parent_id;
2090: CLOSE is_cust_acct_site_exist;
2091: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN

Line 2300: RETURN 'HZ_CUST_ACCT_SITES_ALL';

2296: RETURN 'HZ_CUST_ACCOUNTS';
2297: ELSIF(p_obj_type = 'CUST_ACCT_CONTACT') THEN
2298: RETURN 'HZ_CUST_ACCOUNT_ROLES';
2299: ELSIF(p_obj_type = 'CUST_ACCT_SITE') THEN
2300: RETURN 'HZ_CUST_ACCT_SITES_ALL';
2301: ELSIF(p_obj_type in ('PHONE', 'EMAIL', 'TLX', 'WEB', 'EDI', 'EFT', 'SMS')) THEN
2302: RETURN 'HZ_CONTACT_POINTS';
2303: ELSIF(p_obj_type = 'LOCATION') THEN
2304: RETURN 'HZ_LOCATIONS';

Line 2377: ELSIF(p_parent_table_name = 'HZ_CUST_ACCT_SITES_ALL') THEN

2373: RETURN 'CUST_ACCT';
2374: END IF;
2375: ELSIF(p_parent_table_name = 'HZ_CUST_ACCOUNT_ROLES') THEN
2376: RETURN 'CUST_ACCT_CONTACT';
2377: ELSIF(p_parent_table_name = 'HZ_CUST_ACCT_SITES_ALL') THEN
2378: RETURN 'CUST_ACCT_SITE';
2379: END IF;
2380: RETURN NULL;
2381: END get_parent_object_type;