APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_RELATIONSHIPS

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 1980: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r

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
1980: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
1981: WHERE oc.org_contact_id = l_org_contact_id
1982: AND oc.party_relationship_id = r.relationship_id
1983: AND r.object_type = 'ORGANIZATION'
1984: AND r.subject_type = 'PERSON'

Line 2849: -- HZ_PARTY_PREFERENCES, HZ_RELATIONSHIPS, HZ_CODE_ASSIGNMENTS,

2845: l_ext := FALSE;
2846:
2847: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
2848: -- get all entities of person, for person, the possible entites are
2849: -- HZ_PARTY_PREFERENCES, HZ_RELATIONSHIPS, HZ_CODE_ASSIGNMENTS,
2850: -- HZ_PERSON_LANGUAGE, HZ_EDUCATION, HZ_CITIZENSHIP, HZ_EMPLOYMENT_HISTORY
2851: -- HZ_PERSON_INTEREST, HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE,
2852: -- HZ_CONTACT_PREFERENCES
2853: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND

Line 2860: WHEN p_bus_object.entity_name(i) = 'HZ_RELATIONSHIPS' THEN

2856: p_bus_object.child_bo_code(i) IS NULL) THEN
2857: CASE
2858: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_PREFERENCES' THEN
2859: l_pref := TRUE;
2860: WHEN p_bus_object.entity_name(i) = 'HZ_RELATIONSHIPS' THEN
2861: l_rel := TRUE;
2862: WHEN p_bus_object.entity_name(i) = 'HZ_CODE_ASSIGNMENTS' THEN
2863: l_class := TRUE;
2864: WHEN p_bus_object.entity_name(i) = 'HZ_PERSON_LANGUAGE' THEN

Line 3290: -- HZ_PARTY_PREFERENCES, HZ_CREDIT_RATINGS, HZ_RELATIONSHIPS,

3286: l_ext := FALSE;
3287:
3288: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3289: -- get all entities of org, for org, the possible entites are
3290: -- HZ_PARTY_PREFERENCES, HZ_CREDIT_RATINGS, HZ_RELATIONSHIPS,
3291: -- HZ_CODE_ASSIGNMENTS, HZ_FINANCIAL_REPORTS, HZ_FINANCIAL_NUMBERS,
3292: -- HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE, HZ_CONTACT_PREFERENCES
3293: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
3294: p_bus_object.user_mandated_flag(i) = 'Y' AND

Line 3302: WHEN p_bus_object.entity_name(i) = 'HZ_RELATIONSHIPS' THEN

3298: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_PREFERENCES' THEN
3299: l_pref := TRUE;
3300: WHEN p_bus_object.entity_name(i) = 'HZ_CREDIT_RATINGS' THEN
3301: l_credit := TRUE;
3302: WHEN p_bus_object.entity_name(i) = 'HZ_RELATIONSHIPS' THEN
3303: l_rel := TRUE;
3304: WHEN p_bus_object.entity_name(i) = 'HZ_CODE_ASSIGNMENTS' THEN
3305: l_class := TRUE;
3306: WHEN p_bus_object.entity_name(i) = 'HZ_CERTIFICATIONS' THEN