[Home] [Help]
618: -- check relationship.
619: --
620: IF p_db_object_name = 'HZ_PARTIES' THEN
621: IF is_relationship_party(TO_NUMBER(p_object_pk1), l_relationship_id) = 'Y' THEN
622: l_db_object_name := 'HZ_RELATIONSHIPS';
623: l_object_pk1 := l_relationship_id;
624: l_object_pk2 := 'F';
625: END IF;
626: END IF;
1838: --,p_relationship_id NUMBER -- Bug 5687869 (Nishant)
1839: ) IS
1840: -- SELECT 1
1841: /*SELECT rel.relationship_type -- changed so that it is easy to debug
1842: FROM hz_relationships rel
1843: WHERE rel.subject_id = p_party_id AND
1844: rel.subject_table_name = 'HZ_PARTIES'
1845: AND rel.relationship_id = p_relationship_id -- added for Bug 5687869
1846: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
1854: AND ROWNUM = 1;
1855: */
1856: --Changes for bug 8837776/8797990
1857: SELECT rel.relationship_code -- changed so that it is easy to debug
1858: FROM hz_relationships rel
1859: WHERE p_party_id IN (rel.subject_id, rel.object_id)
1860: AND rel.subject_table_name = 'HZ_PARTIES'
1861: AND rel.object_table_name = 'HZ_PARTIES'
1862: AND rel.directional_flag = 'F'
1982: -- since relationship_party cannot have additional relationships
1983: -- we do not anticipate multiple records to be present for relationship
1984: -- party_id
1985: SELECT subject_id, object_id
1986: FROM hz_relationships rel
1987: WHERE rel.party_id = p_party_id
1988: AND rel.directional_flag = 'F'
1989: AND SYSDATE BETWEEN
1990: NVL(rel.start_date, SYSDATE) AND NVL(rel.end_date, SYSDATE)
1996: p_dss_group_code VARCHAR2
1997: ) IS
1998: -- SELECT 1 (Bug 5687869)
1999: SELECT rel.relationship_type
2000: FROM hz_relationships rel
2001: WHERE rel.party_id = p_party_id
2002: AND rel.relationship_id = p_object_pk1 --(Bug 5687869)
2003: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2004: SELECT relationship_type, forward_rel_code,
2020: p_obj_id NUMBER,
2021: p_dss_group_code VARCHAR2
2022: ) IS
2023: SELECT rel.relationship_code -- changed so that it is easy to debug
2024: FROM hz_relationships rel
2025: WHERE p_subj_id IN (rel.subject_id, rel.object_id)
2026: AND rel.subject_table_name = 'HZ_PARTIES'
2027: AND rel.object_table_name = 'HZ_PARTIES'
2028: AND rel.directional_flag = 'F'
2039: AND rel.status = 'A'
2040: AND ROWNUM = 1
2041: UNION
2042: SELECT rel.relationship_code -- changed so that it is easy to debug
2043: FROM hz_relationships rel
2044: WHERE p_obj_id IN (rel.subject_id, rel.object_id)
2045: AND rel.subject_table_name = 'HZ_PARTIES'
2046: AND rel.object_table_name = 'HZ_PARTIES'
2047: AND rel.directional_flag = 'F'
2186: CURSOR c_relationship_party (
2187: p_party_id NUMBER
2188: ) IS
2189: SELECT relationship_id
2190: FROM hz_relationships
2191: WHERE party_id = p_party_id
2192: AND directional_flag = 'F';
2193:
2194: l_party_type VARCHAR2(30);
2291: p_directional_flag VARCHAR2
2292: ) IS
2293: SELECT subject_id, subject_table_name, subject_type,
2294: object_id, object_table_name, object_type
2295: FROM hz_relationships
2296: WHERE relationship_id = p_relationship_id
2297: AND directional_flag = p_directional_flag
2298: AND (subject_table_name = 'HZ_PARTIES' OR
2299: object_table_name = 'HZ_PARTIES');
2346: OPEN c_code_assignment(TO_NUMBER(p_object_pk1));
2347: FETCH c_code_assignment BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2348: CLOSE c_code_assignment;
2349:
2350: ELSIF p_db_object_name = 'HZ_RELATIONSHIPS' THEN
2351: OPEN c_relationship(TO_NUMBER(p_object_pk1), p_object_pk2);
2352: FETCH c_relationship INTO
2353: l_subject_id, l_subject_table_name, l_subject_type,
2354: l_object_id, l_object_table_name, l_object_type;