eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_DSS_UTIL_PUB dependencies on HZ_PARTIES

Line 99: * e.g.HZ_PARTIES

95: *
96: * ARGUMENTS : IN:
97: * p_operation_code VARCHAR2 e.g SELECT,INSERT etc.
98: * p_db_object_name VARCHAR2 Object_name in fnd_objects
99: * e.g.HZ_PARTIES
100: * p_instance_pk1_value VARCHAR2 e.g Party_id = 1000
101: * p_user VARCHAR2 e.g JDOE
102: *
103: * OUT: T/F

Line 467: * p_db_object_name VARCHAR2 e.g HZ_PARTIES

463: *
464: * EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
465: *
466: * ARGUMENTS : IN:
467: * p_db_object_name VARCHAR2 e.g HZ_PARTIES
468: * p_object_pk1 VARCHAR2 e.g Party_id 1000
469: *
470: * OUT: Data Sharing group VARCHAR2
471: * IN/ OUT:

Line 620: IF p_db_object_name = 'HZ_PARTIES' THEN

616: --
617: -- checking relationship party will be redirected to
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';

Line 922: | p_db_object_name VARCHAR2 e.g. HZ_PARTIES

Line 1541: FROM hz_parties p, hz_dss_criteria dc

1537: p_party_id NUMBER,
1538: p_dss_group_code VARCHAR2
1539: ) IS
1540: SELECT 1
1541: FROM hz_parties p, hz_dss_criteria dc
1542: WHERE p.party_id = p_party_id
1543: AND p.created_by_module IN (
1544: SELECT owner_table_id2
1545: FROM hz_dss_criteria

Line 1630: WHERE owner_table_name = 'HZ_PARTIES'

1626: p_class_code VARCHAR2
1627: ) IS
1628: SELECT 1
1629: FROM hz_code_assignments
1630: WHERE owner_table_name = 'HZ_PARTIES'
1631: AND owner_table_id = p_party_id
1632: AND class_category = p_class_category
1633: AND class_code = p_class_code
1634: AND SYSDATE BETWEEN

Line 1844: rel.subject_table_name = 'HZ_PARTIES'

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 (
1847: SELECT relationship_type, forward_rel_code,
1848: subject_type, object_type

Line 1860: AND rel.subject_table_name = 'HZ_PARTIES'

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'
1863: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
1864: SELECT relationship_type, forward_rel_code,

Line 1861: AND rel.object_table_name = 'HZ_PARTIES'

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'
1863: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
1864: SELECT relationship_type, forward_rel_code,
1865: subject_type, object_type

Line 2026: AND rel.subject_table_name = 'HZ_PARTIES'

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'
2029: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2030: SELECT relationship_type, forward_rel_code,

Line 2027: AND rel.object_table_name = 'HZ_PARTIES'

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'
2029: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2030: SELECT relationship_type, forward_rel_code,
2031: subject_type, object_type

Line 2045: AND rel.subject_table_name = 'HZ_PARTIES'

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'
2048: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2049: SELECT relationship_type, forward_rel_code,

Line 2046: AND rel.object_table_name = 'HZ_PARTIES'

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'
2048: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2049: SELECT relationship_type, forward_rel_code,
2050: subject_type, object_type

Line 2183: FROM hz_parties

2179: CURSOR c_party (
2180: p_party_id NUMBER
2181: ) IS
2182: SELECT party_type
2183: FROM hz_parties
2184: WHERE party_id = p_party_id;
2185:
2186: CURSOR c_relationship_party (
2187: p_party_id NUMBER

Line 2260: FROM hz_parties

2256: CURSOR c_party (
2257: p_party_id NUMBER
2258: ) IS
2259: SELECT party_id, party_type
2260: FROM hz_parties
2261: WHERE party_id = p_party_id;
2262:
2263: CURSOR c_party_site (
2264: p_party_site_id NUMBER

Line 2267: FROM hz_party_sites ps, hz_parties p

2263: CURSOR c_party_site (
2264: p_party_site_id NUMBER
2265: ) IS
2266: SELECT p.party_id, p.party_type
2267: FROM hz_party_sites ps, hz_parties p
2268: WHERE party_site_id = p_party_site_id
2269: AND ps.party_id = p.party_id;
2270:
2271: CURSOR c_location (

Line 2275: FROM hz_locations loc, hz_party_sites ps, hz_parties p

2271: CURSOR c_location (
2272: p_location_id NUMBER
2273: ) IS
2274: SELECT p.party_id, p.party_type
2275: FROM hz_locations loc, hz_party_sites ps, hz_parties p
2276: WHERE loc.location_id = p_location_id
2277: AND loc.location_id = ps.location_id
2278: AND ps.party_id = p.party_id;
2279:

Line 2284: FROM hz_code_assignments, hz_parties p

2280: CURSOR c_code_assignment (
2281: p_code_assignment_id NUMBER
2282: ) IS
2283: SELECT p.party_id, p.party_type
2284: FROM hz_code_assignments, hz_parties p
2285: WHERE code_assignment_id = p_code_assignment_id
2286: AND owner_table_name = 'HZ_PARTIES'
2287: AND owner_table_id = p.party_id;
2288:

Line 2286: AND owner_table_name = 'HZ_PARTIES'

2282: ) IS
2283: SELECT p.party_id, p.party_type
2284: FROM hz_code_assignments, hz_parties p
2285: WHERE code_assignment_id = p_code_assignment_id
2286: AND owner_table_name = 'HZ_PARTIES'
2287: AND owner_table_id = p.party_id;
2288:
2289: CURSOR c_relationship (
2290: p_relationship_id NUMBER,

Line 2298: AND (subject_table_name = 'HZ_PARTIES' OR

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');
2300:
2301: CURSOR c_contact_point (
2302: p_contact_point_id NUMBER

Line 2299: object_table_name = 'HZ_PARTIES');

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');
2300:
2301: CURSOR c_contact_point (
2302: p_contact_point_id NUMBER
2303: ) IS

Line 2305: FROM hz_contact_points, hz_parties p

2301: CURSOR c_contact_point (
2302: p_contact_point_id NUMBER
2303: ) IS
2304: SELECT p.party_id, p.party_type
2305: FROM hz_contact_points, hz_parties p
2306: WHERE contact_point_id = p_contact_point_id
2307: AND owner_table_name = 'HZ_PARTIES'
2308: AND owner_table_id = p.party_id;
2309:

Line 2307: AND owner_table_name = 'HZ_PARTIES'

2303: ) IS
2304: SELECT p.party_id, p.party_type
2305: FROM hz_contact_points, hz_parties p
2306: WHERE contact_point_id = p_contact_point_id
2307: AND owner_table_name = 'HZ_PARTIES'
2308: AND owner_table_id = p.party_id;
2309:
2310: CURSOR c_contact_point_ps (
2311: p_contact_point_id NUMBER

Line 2314: FROM hz_contact_points cp, hz_party_sites ps, hz_parties p

2310: CURSOR c_contact_point_ps (
2311: p_contact_point_id NUMBER
2312: ) IS
2313: SELECT p.party_id, p.party_type
2314: FROM hz_contact_points cp, hz_party_sites ps, hz_parties p
2315: WHERE contact_point_id = p_contact_point_id
2316: AND owner_table_name = 'HZ_PARTY_SITES'
2317: AND owner_table_id = ps.party_site_id
2318: AND ps.party_id = p.party_id;

Line 2330: IF p_db_object_name = 'HZ_PARTIES' THEN

2326: l_object_type VARCHAR2(30);
2327:
2328: BEGIN
2329:
2330: IF p_db_object_name = 'HZ_PARTIES' THEN
2331: OPEN c_party(TO_NUMBER(p_object_pk1));
2332: FETCH c_party BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2333: CLOSE c_party;
2334:

Line 2358: IF l_subject_table_name = 'HZ_PARTIES' THEN

2354: l_object_id, l_object_table_name, l_object_type;
2355: CLOSE c_relationship;
2356:
2357: i := 1;
2358: IF l_subject_table_name = 'HZ_PARTIES' THEN
2359: x_party_id_tbl(i) := l_subject_id;
2360: x_party_type_tbl(i) := l_subject_type;
2361: i := i+1;
2362: END IF;

Line 2363: IF l_object_table_name = 'HZ_PARTIES' THEN

2359: x_party_id_tbl(i) := l_subject_id;
2360: x_party_type_tbl(i) := l_subject_type;
2361: i := i+1;
2362: END IF;
2363: IF l_object_table_name = 'HZ_PARTIES' THEN
2364: x_party_id_tbl(i) := l_object_id;
2365: x_party_type_tbl(i) := l_object_type;
2366: i := i+1;
2367: END IF;