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 2004: FROM HZ_CUST_SITE_USES

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
2004: FROM HZ_CUST_SITE_USES
2005: WHERE site_use_id = l_site_use_id;
2006:
2007: CURSOR is_cust_acct_role_exist(l_cust_acct_role_id NUMBER) IS
2008: SELECT cust_account_id, nvl(cust_acct_site_id, -99)

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

2093: FND_MSG_PUB.ADD;
2094: RETURN 'E';
2095: END IF;
2096: l_dummy := 'X';
2097: ELSIF(p_entity_type = 'HZ_CUST_SITE_USES_ALL') THEN
2098: OPEN is_cust_site_use_exist(p_entity_id);
2099: FETCH is_cust_site_use_exist INTO l_parent_id;
2100: CLOSE is_cust_site_use_exist;
2101: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN

Line 2306: RETURN 'HZ_CUST_SITE_USES_ALL';

2302: RETURN 'HZ_CONTACT_POINTS';
2303: ELSIF(p_obj_type = 'LOCATION') THEN
2304: RETURN 'HZ_LOCATIONS';
2305: ELSIF(p_obj_type = 'CUST_ACCT_SITE_USE') THEN
2306: RETURN 'HZ_CUST_SITE_USES_ALL';
2307: END IF;
2308: RETURN NULL;
2309: END get_owner_table_name;
2310: