APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CUST_SITE_USES

Line 403: FROM HZ_CUST_SITE_USES

399: AND org_id = l_org_id;
400:
401: CURSOR is_casu_valid(l_casu_id NUMBER, l_org_id NUMBER) IS
402: SELECT 'X'
403: FROM HZ_CUST_SITE_USES
404: WHERE site_use_id = l_casu_id
405: AND org_id = l_org_id;
406:
407: l_owner_table_id NUMBER;

Line 470: ELSIF(p_obj_type = 'HZ_CUST_SITE_USES_ALL') THEN

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
471: OPEN is_casu_valid(px_id, p_org_id);
472: FETCH is_casu_valid INTO l_valid_id;
473: CLOSE is_casu_valid;
474: END IF;

Line 1999: FROM HZ_CUST_SITE_USES

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
1999: FROM HZ_CUST_SITE_USES
2000: WHERE site_use_id = l_site_use_id;
2001:
2002: CURSOR is_cust_acct_role_exist(l_cust_acct_role_id NUMBER) IS
2003: SELECT cust_account_id, nvl(cust_acct_site_id, -99)

Line 2092: ELSIF(p_entity_type = 'HZ_CUST_SITE_USES_ALL') THEN

2088: FND_MSG_PUB.ADD;
2089: RETURN 'E';
2090: END IF;
2091: l_dummy := 'X';
2092: ELSIF(p_entity_type = 'HZ_CUST_SITE_USES_ALL') THEN
2093: OPEN is_cust_site_use_exist(p_entity_id);
2094: FETCH is_cust_site_use_exist INTO l_parent_id;
2095: CLOSE is_cust_site_use_exist;
2096: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN

Line 2301: RETURN 'HZ_CUST_SITE_USES_ALL';

2297: RETURN 'HZ_CONTACT_POINTS';
2298: ELSIF(p_obj_type = 'LOCATION') THEN
2299: RETURN 'HZ_LOCATIONS';
2300: ELSIF(p_obj_type = 'CUST_ACCT_SITE_USE') THEN
2301: RETURN 'HZ_CUST_SITE_USES_ALL';
2302: END IF;
2303: RETURN NULL;
2304: END get_owner_table_name;
2305: