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 1994: FROM HZ_CUST_ACCT_SITES_ALL

1990: WHERE cust_account_id = l_cust_acct_id;
1991:
1992: CURSOR is_cust_acct_site_exist(l_cust_acct_site_id NUMBER) IS
1993: SELECT cust_account_id
1994: FROM HZ_CUST_ACCT_SITES_ALL
1995: WHERE cust_acct_site_id = l_cust_acct_site_id;
1996:
1997: CURSOR is_cust_site_use_exist(l_site_use_id NUMBER) IS
1998: SELECT cust_acct_site_id

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

2078: FND_MSG_PUB.ADD;
2079: RETURN 'E';
2080: END IF;
2081: l_dummy := 'X';
2082: ELSIF(p_entity_type = 'HZ_CUST_ACCT_SITES_ALL') THEN
2083: OPEN is_cust_acct_site_exist(p_entity_id);
2084: FETCH is_cust_acct_site_exist INTO l_parent_id;
2085: CLOSE is_cust_acct_site_exist;
2086: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN

Line 2295: RETURN 'HZ_CUST_ACCT_SITES_ALL';

2291: RETURN 'HZ_CUST_ACCOUNTS';
2292: ELSIF(p_obj_type = 'CUST_ACCT_CONTACT') THEN
2293: RETURN 'HZ_CUST_ACCOUNT_ROLES';
2294: ELSIF(p_obj_type = 'CUST_ACCT_SITE') THEN
2295: RETURN 'HZ_CUST_ACCT_SITES_ALL';
2296: ELSIF(p_obj_type in ('PHONE', 'EMAIL', 'TLX', 'WEB', 'EDI', 'EFT', 'SMS')) THEN
2297: RETURN 'HZ_CONTACT_POINTS';
2298: ELSIF(p_obj_type = 'LOCATION') THEN
2299: RETURN 'HZ_LOCATIONS';

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

2368: RETURN 'CUST_ACCT';
2369: END IF;
2370: ELSIF(p_parent_table_name = 'HZ_CUST_ACCOUNT_ROLES') THEN
2371: RETURN 'CUST_ACCT_CONTACT';
2372: ELSIF(p_parent_table_name = 'HZ_CUST_ACCT_SITES_ALL') THEN
2373: RETURN 'CUST_ACCT_SITE';
2374: END IF;
2375: RETURN NULL;
2376: END get_parent_object_type;