APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 387: FROM HZ_CUST_ACCOUNT_ROLES

383: WHERE location_id = l_loc_id;
384:
385: CURSOR is_cr_valid(l_cr_id NUMBER) IS
386: SELECT 'X'
387: FROM HZ_CUST_ACCOUNT_ROLES
388: WHERE cust_account_role_id = l_cr_id;
389:
390: CURSOR is_ca_valid(l_ca_id NUMBER) IS
391: SELECT 'X'

Line 450: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNT_ROLES') THEN

446: ELSIF(p_obj_type in ('PERSON','ORGANIZATION','PARTY_RELATIONSHIP')) THEN
447: OPEN is_pty_valid(px_id, p_obj_type);
448: FETCH is_pty_valid INTO l_valid_id;
449: CLOSE is_pty_valid;
450: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNT_ROLES') THEN
451: OPEN is_cr_valid(px_id);
452: FETCH is_cr_valid INTO l_valid_id;
453: CLOSE is_cr_valid;
454: ELSIF(p_obj_type = 'HZ_LOCATIONS') THEN

Line 2004: FROM HZ_CUST_ACCOUNT_ROLES

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)
2004: FROM HZ_CUST_ACCOUNT_ROLES
2005: WHERE cust_account_role_id = l_cust_acct_role_id;
2006:
2007: l_create_update_flag VARCHAR2(1);
2008: l_dummy VARCHAR2(1);

Line 2102: ELSIF(p_entity_type = 'HZ_CUST_ACCOUNT_ROLES') THEN

2098: FND_MSG_PUB.ADD;
2099: RETURN 'E';
2100: END IF;
2101: l_dummy := 'X';
2102: ELSIF(p_entity_type = 'HZ_CUST_ACCOUNT_ROLES') THEN
2103: OPEN is_cust_acct_role_exist(p_entity_id);
2104: FETCH is_cust_acct_role_exist INTO l_parent_id, l_acct_site_id;
2105: CLOSE is_cust_acct_role_exist;
2106: IF(p_parent_obj_type = 'CUST_ACCT_SITE') THEN

Line 2293: RETURN 'HZ_CUST_ACCOUNT_ROLES';

2289: RETURN 'HZ_PARTIES';
2290: ELSIF((p_obj_type = 'ORG_CUST') OR (p_obj_type = 'PERSON_CUST') OR (p_obj_type = 'CUST_ACCT')) THEN
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';

Line 2370: ELSIF(p_parent_table_name = 'HZ_CUST_ACCOUNT_ROLES') THEN

2366: RETURN 'PERSON_CUST';
2367: ELSIF(l_party_type IS NULL) 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;