APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CUST_ACCOUNTS

Line 134: from HZ_CUST_ACCOUNTS

130: where party_site_id = l_party_site_id;
131:
132: CURSOR is_acct_parent_valid(l_acct_id NUMBER) IS
133: select 'Y'
134: from HZ_CUST_ACCOUNTS
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'

Line 185: ELSIF(l_owner_table_name = 'HZ_CUST_ACCOUNTS') THEN

181: ELSIF(l_owner_table_name = 'HZ_PARTY_SITES') THEN
182: OPEN is_ps_parent_valid(px_parent_id);
183: FETCH is_ps_parent_valid INTO l_valid_parent;
184: CLOSE is_ps_parent_valid;
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

Line 392: FROM HZ_CUST_ACCOUNTS

388: WHERE cust_account_role_id = l_cr_id;
389:
390: CURSOR is_ca_valid(l_ca_id NUMBER) IS
391: SELECT 'X'
392: FROM HZ_CUST_ACCOUNTS
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'

Line 462: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNTS') THEN

458: ELSIF(p_obj_type = 'HZ_PARTY_SITES') THEN
459: OPEN is_ps_valid(px_id);
460: FETCH is_ps_valid INTO l_valid_id;
461: CLOSE is_ps_valid;
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

Line 1994: FROM HZ_CUST_ACCOUNTS

1990: AND rownum = 1;
1991:
1992: CURSOR is_cust_account_exist(l_cust_acct_id NUMBER) IS
1993: SELECT party_id
1994: FROM HZ_CUST_ACCOUNTS
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

Line 2077: ELSIF(p_entity_type = 'HZ_CUST_ACCOUNTS') THEN

2073: FND_MSG_PUB.ADD;
2074: RETURN 'E';
2075: END IF;
2076: l_dummy := 'X';
2077: ELSIF(p_entity_type = 'HZ_CUST_ACCOUNTS') THEN
2078: OPEN is_cust_account_exist(p_entity_id);
2079: FETCH is_cust_account_exist INTO l_parent_id;
2080: CLOSE is_cust_account_exist;
2081: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN

Line 2296: RETURN 'HZ_CUST_ACCOUNTS';

2292: RETURN 'HZ_PARTY_SITES';
2293: ELSIF((p_obj_type = 'ORG') OR (p_obj_type = 'PERSON') OR (p_obj_type = 'ORG_CONTACT')) THEN
2294: RETURN 'HZ_PARTIES';
2295: ELSIF((p_obj_type = 'ORG_CUST') OR (p_obj_type = 'PERSON_CUST') OR (p_obj_type = 'CUST_ACCT')) THEN
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';

Line 2341: FROM hz_parties p, hz_cust_accounts ca

2337: WHERE party_id = p_parent_id;
2338:
2339: CURSOR c2 IS
2340: SELECT party_type
2341: FROM hz_parties p, hz_cust_accounts ca
2342: WHERE p.party_id = ca.party_id
2343: AND ca.cust_account_id = p_parent_id;
2344:
2345: BEGIN

Line 2351: ELSIF p_parent_table_name = 'HZ_CUST_ACCOUNTS' THEN

2347: IF p_parent_table_name = 'HZ_PARTIES' THEN
2348: OPEN c1;
2349: FETCH c1 INTO l_party_type;
2350: CLOSE c1;
2351: ELSIF p_parent_table_name = 'HZ_CUST_ACCOUNTS' THEN
2352: OPEN c2;
2353: FETCH c2 INTO l_party_type;
2354: CLOSE c2;
2355: END IF;

Line 2367: ELSIF(p_parent_table_name = 'HZ_CUST_ACCOUNTS') THEN

2363: RETURN 'PERSON';
2364: ELSIF(l_party_type = 'PARTY_RELATIONSHIP') THEN
2365: RETURN 'ORG_CONTACT';
2366: END IF;
2367: ELSIF(p_parent_table_name = 'HZ_CUST_ACCOUNTS') THEN
2368: IF(l_party_type = 'ORGANIZATION') THEN
2369: RETURN 'ORG_CUST';
2370: ELSIF(l_party_type = 'PERSON') THEN
2371: RETURN 'PERSON_CUST';