APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_PARTIES

Line 123: from HZ_PARTIES

119: x_msg_data OUT NOCOPY VARCHAR2
120: ) IS
121: CURSOR is_p_parent_valid(l_party_id NUMBER, l_party_type VARCHAR2) IS
122: select 'Y'
123: from HZ_PARTIES
124: where party_id = l_party_id
125: and party_type = l_party_type;
126:
127: CURSOR is_ps_parent_valid(l_party_site_id NUMBER) IS

Line 170: IF(l_owner_table_name = 'HZ_PARTIES') THEN

166: l_valid_parent := 'N';
167:
168: -- if px_parent_id is not null, check if px_parent_id is valid or not
169: IF(px_parent_id IS NOT NULL) THEN
170: IF(l_owner_table_name = 'HZ_PARTIES') THEN
171: IF(p_parent_obj_type = 'PERSON') THEN
172: l_party_type := 'PERSON';
173: ELSIF(p_parent_obj_type = 'ORG') THEN
174: l_party_type := 'ORGANIZATION';

Line 370: FROM HZ_PARTIES

366: WHERE org_contact_id = l_oc_id;
367:
368: CURSOR is_pty_valid(l_pty_id NUMBER, l_pty_type VARCHAR2) IS
369: SELECT 'X'
370: FROM HZ_PARTIES
371: WHERE party_id = l_pty_id
372: AND party_type = l_pty_type
373: AND status in ('A', 'I');
374:

Line 482: l_obj_type := 'HZ_PARTIES';

478: IF(l_ss_flag = 'Y')THEN
479: IF(p_obj_type in ('PHONE','TLX','EMAIL','WEB','EFT','EDI','SMS')) THEN
480: l_obj_type := 'HZ_CONTACT_POINTS';
481: ELSIF(p_obj_type in ('PERSON','ORGANIZATION','PARTY_RELATIONSHIP')) THEN
482: l_obj_type := 'HZ_PARTIES';
483: ELSE
484: l_obj_type := p_obj_type;
485: END IF;
486:

Line 1183: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p

1179: x_party_obj_version_number OUT NOCOPY NUMBER
1180: ) IS
1181: CURSOR is_relationship_id_exist(l_subject_id NUMBER, l_object_id NUMBER, l_rel_id NUMBER) IS
1182: SELECT rel.object_version_number, p.object_version_number
1183: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p
1184: WHERE rel.subject_id = l_subject_id
1185: AND rel.object_id = l_object_id
1186: AND rel.relationship_id = l_rel_id
1187: AND rel.party_id = p.party_id

Line 1194: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p

1190:
1191: CURSOR is_relationship_exist(l_subject_id NUMBER, l_object_id NUMBER,
1192: l_relationship_type VARCHAR2, l_relationship_code VARCHAR2)IS
1193: SELECT rel.object_version_number, p.object_version_number, rel.relationship_id
1194: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p
1195: WHERE rel.subject_id = l_subject_id
1196: AND rel.object_id = l_object_id
1197: AND rel.relationship_type = l_relationship_type
1198: AND rel.relationship_code = l_relationship_code

Line 1980: FROM HZ_PARTIES

1976: WHERE location_id = l_loc_id;
1977:
1978: CURSOR is_party_exist(l_party_id NUMBER) IS
1979: SELECT 'X'
1980: FROM HZ_PARTIES
1981: WHERE party_id = l_party_id;
1982:
1983: CURSOR is_org_contact_exist(l_org_contact_id NUMBER) IS
1984: SELECT r.object_id

Line 2063: ELSIF(p_entity_type = 'HZ_PARTIES') THEN

2059: ELSIF(p_entity_type = 'HZ_LOCATIONS') THEN
2060: OPEN is_location_exist(p_entity_id);
2061: FETCH is_location_exist INTO l_dummy;
2062: CLOSE is_location_exist;
2063: ELSIF(p_entity_type = 'HZ_PARTIES') THEN
2064: OPEN is_party_exist(p_entity_id);
2065: FETCH is_party_exist INTO l_dummy;
2066: CLOSE is_party_exist;
2067: ELSIF(p_entity_type = 'HZ_ORG_CONTACTS') THEN

Line 2294: RETURN 'HZ_PARTIES';

2290: -- Base on HZ_BUSINESS_OBJECTS lookup code
2291: IF(p_obj_type = 'PARTY_SITE') THEN
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';

Line 2336: SELECT party_type FROM hz_parties

2332:
2333: l_party_type VARCHAR2(30) := null;
2334:
2335: CURSOR c1 IS
2336: SELECT party_type FROM hz_parties
2337: WHERE party_id = p_parent_id;
2338:
2339: CURSOR c2 IS
2340: SELECT party_type

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 2347: IF p_parent_table_name = 'HZ_PARTIES' THEN

2343: AND ca.cust_account_id = p_parent_id;
2344:
2345: BEGIN
2346: -- Base on owner_table_name to return HZ_BUSINESS_OBJECTS lookup code
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

Line 2359: ELSIF(p_parent_table_name = 'HZ_PARTIES') THEN

2355: END IF;
2356:
2357: IF(p_parent_table_name = 'HZ_PARTY_SITES') THEN
2358: RETURN 'PARTY_SITE';
2359: ELSIF(p_parent_table_name = 'HZ_PARTIES') THEN
2360: IF(l_party_type = 'ORGANIZATION') THEN
2361: RETURN 'ORG';
2362: ELSIF(l_party_type = 'PERSON') THEN
2363: RETURN 'PERSON';