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 1180: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p

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

Line 1191: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p

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

Line 1975: FROM HZ_PARTIES

1971: WHERE location_id = l_loc_id;
1972:
1973: CURSOR is_party_exist(l_party_id NUMBER) IS
1974: SELECT 'X'
1975: FROM HZ_PARTIES
1976: WHERE party_id = l_party_id;
1977:
1978: CURSOR is_org_contact_exist(l_org_contact_id NUMBER) IS
1979: SELECT r.object_id

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

2054: ELSIF(p_entity_type = 'HZ_LOCATIONS') THEN
2055: OPEN is_location_exist(p_entity_id);
2056: FETCH is_location_exist INTO l_dummy;
2057: CLOSE is_location_exist;
2058: ELSIF(p_entity_type = 'HZ_PARTIES') THEN
2059: OPEN is_party_exist(p_entity_id);
2060: FETCH is_party_exist INTO l_dummy;
2061: CLOSE is_party_exist;
2062: ELSIF(p_entity_type = 'HZ_ORG_CONTACTS') THEN

Line 2289: RETURN 'HZ_PARTIES';

2285: -- Base on HZ_BUSINESS_OBJECTS lookup code
2286: IF(p_obj_type = 'PARTY_SITE') THEN
2287: RETURN 'HZ_PARTY_SITES';
2288: ELSIF((p_obj_type = 'ORG') OR (p_obj_type = 'PERSON') OR (p_obj_type = 'ORG_CONTACT')) THEN
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';

Line 2331: SELECT party_type FROM hz_parties

2327:
2328: l_party_type VARCHAR2(30) := null;
2329:
2330: CURSOR c1 IS
2331: SELECT party_type FROM hz_parties
2332: WHERE party_id = p_parent_id;
2333:
2334: CURSOR c2 IS
2335: SELECT party_type

Line 2336: FROM hz_parties p, hz_cust_accounts ca

2332: WHERE party_id = p_parent_id;
2333:
2334: CURSOR c2 IS
2335: SELECT party_type
2336: FROM hz_parties p, hz_cust_accounts ca
2337: WHERE p.party_id = ca.party_id
2338: AND ca.cust_account_id = p_parent_id;
2339:
2340: BEGIN

Line 2342: IF p_parent_table_name = 'HZ_PARTIES' THEN

2338: AND ca.cust_account_id = p_parent_id;
2339:
2340: BEGIN
2341: -- Base on owner_table_name to return HZ_BUSINESS_OBJECTS lookup code
2342: IF p_parent_table_name = 'HZ_PARTIES' THEN
2343: OPEN c1;
2344: FETCH c1 INTO l_party_type;
2345: CLOSE c1;
2346: ELSIF p_parent_table_name = 'HZ_CUST_ACCOUNTS' THEN

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

2350: END IF;
2351:
2352: IF(p_parent_table_name = 'HZ_PARTY_SITES') THEN
2353: RETURN 'PARTY_SITE';
2354: ELSIF(p_parent_table_name = 'HZ_PARTIES') THEN
2355: IF(l_party_type = 'ORGANIZATION') THEN
2356: RETURN 'ORG';
2357: ELSIF(l_party_type = 'PERSON') THEN
2358: RETURN 'PERSON';