APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_RELATIONSHIPS

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

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
1985: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
1986: WHERE oc.org_contact_id = l_org_contact_id
1987: AND oc.party_relationship_id = r.relationship_id
1988: AND r.object_type = 'ORGANIZATION'
1989: AND r.subject_type = 'PERSON'

Line 2854: -- HZ_PARTY_PREFERENCES, HZ_RELATIONSHIPS, HZ_CODE_ASSIGNMENTS,

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

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

2861: p_bus_object.child_bo_code(i) IS NULL) THEN
2862: CASE
2863: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_PREFERENCES' THEN
2864: l_pref := TRUE;
2865: WHEN p_bus_object.entity_name(i) = 'HZ_RELATIONSHIPS' THEN
2866: l_rel := TRUE;
2867: WHEN p_bus_object.entity_name(i) = 'HZ_CODE_ASSIGNMENTS' THEN
2868: l_class := TRUE;
2869: WHEN p_bus_object.entity_name(i) = 'HZ_PERSON_LANGUAGE' THEN

Line 3295: -- HZ_PARTY_PREFERENCES, HZ_CREDIT_RATINGS, HZ_RELATIONSHIPS,

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

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

3303: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_PREFERENCES' THEN
3304: l_pref := TRUE;
3305: WHEN p_bus_object.entity_name(i) = 'HZ_CREDIT_RATINGS' THEN
3306: l_credit := TRUE;
3307: WHEN p_bus_object.entity_name(i) = 'HZ_RELATIONSHIPS' THEN
3308: l_rel := TRUE;
3309: WHEN p_bus_object.entity_name(i) = 'HZ_CODE_ASSIGNMENTS' THEN
3310: l_class := TRUE;
3311: WHEN p_bus_object.entity_name(i) = 'HZ_CERTIFICATIONS' THEN