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 923: | p_db_object_name VARCHAR2 e.g. HZ_PARTIES

Line 1536: FROM hz_parties p, hz_dss_criteria dc

1532: p_party_id NUMBER,
1533: p_dss_group_code VARCHAR2
1534: ) IS
1535: SELECT 1
1536: FROM hz_parties p, hz_dss_criteria dc
1537: WHERE p.party_id = p_party_id
1538: AND p.created_by_module IN (
1539: SELECT owner_table_id2
1540: FROM hz_dss_criteria

Line 1622: WHERE owner_table_name = 'HZ_PARTIES'

1618: p_class_code VARCHAR2
1619: ) IS
1620: SELECT 1
1621: FROM hz_code_assignments
1622: WHERE owner_table_name = 'HZ_PARTIES'
1623: AND owner_table_id = p_party_id
1624: AND class_category = p_class_category
1625: AND class_code = p_class_code
1626: AND SYSDATE BETWEEN

Line 1821: rel.subject_table_name = 'HZ_PARTIES'

1817: -- SELECT 1
1818: SELECT rel.relationship_type -- changed so that it is easy to debug
1819: FROM hz_relationships rel
1820: WHERE rel.subject_id = p_party_id AND
1821: rel.subject_table_name = 'HZ_PARTIES'
1822: AND rel.relationship_id = p_relationship_id -- added for Bug 5687869
1823: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
1824: SELECT relationship_type, forward_rel_code,
1825: subject_type, object_type

Line 2043: FROM hz_parties

2039: CURSOR c_party (
2040: p_party_id NUMBER
2041: ) IS
2042: SELECT party_type
2043: FROM hz_parties
2044: WHERE party_id = p_party_id;
2045:
2046: CURSOR c_relationship_party (
2047: p_party_id NUMBER

Line 2120: FROM hz_parties

2116: CURSOR c_party (
2117: p_party_id NUMBER
2118: ) IS
2119: SELECT party_id, party_type
2120: FROM hz_parties
2121: WHERE party_id = p_party_id;
2122:
2123: CURSOR c_party_site (
2124: p_party_site_id NUMBER

Line 2127: FROM hz_party_sites ps, hz_parties p

2123: CURSOR c_party_site (
2124: p_party_site_id NUMBER
2125: ) IS
2126: SELECT p.party_id, p.party_type
2127: FROM hz_party_sites ps, hz_parties p
2128: WHERE party_site_id = p_party_site_id
2129: AND ps.party_id = p.party_id;
2130:
2131: CURSOR c_location (

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

2131: CURSOR c_location (
2132: p_location_id NUMBER
2133: ) IS
2134: SELECT p.party_id, p.party_type
2135: FROM hz_locations loc, hz_party_sites ps, hz_parties p
2136: WHERE loc.location_id = p_location_id
2137: AND loc.location_id = ps.location_id
2138: AND ps.party_id = p.party_id;
2139:

Line 2144: FROM hz_code_assignments, hz_parties p

2140: CURSOR c_code_assignment (
2141: p_code_assignment_id NUMBER
2142: ) IS
2143: SELECT p.party_id, p.party_type
2144: FROM hz_code_assignments, hz_parties p
2145: WHERE code_assignment_id = p_code_assignment_id
2146: AND owner_table_name = 'HZ_PARTIES'
2147: AND owner_table_id = p.party_id;
2148:

Line 2146: AND owner_table_name = 'HZ_PARTIES'

2142: ) IS
2143: SELECT p.party_id, p.party_type
2144: FROM hz_code_assignments, hz_parties p
2145: WHERE code_assignment_id = p_code_assignment_id
2146: AND owner_table_name = 'HZ_PARTIES'
2147: AND owner_table_id = p.party_id;
2148:
2149: CURSOR c_relationship (
2150: p_relationship_id NUMBER,

Line 2158: AND (subject_table_name = 'HZ_PARTIES' OR

2154: object_id, object_table_name, object_type
2155: FROM hz_relationships
2156: WHERE relationship_id = p_relationship_id
2157: AND directional_flag = p_directional_flag
2158: AND (subject_table_name = 'HZ_PARTIES' OR
2159: object_table_name = 'HZ_PARTIES');
2160:
2161: CURSOR c_contact_point (
2162: p_contact_point_id NUMBER

Line 2159: object_table_name = 'HZ_PARTIES');

2155: FROM hz_relationships
2156: WHERE relationship_id = p_relationship_id
2157: AND directional_flag = p_directional_flag
2158: AND (subject_table_name = 'HZ_PARTIES' OR
2159: object_table_name = 'HZ_PARTIES');
2160:
2161: CURSOR c_contact_point (
2162: p_contact_point_id NUMBER
2163: ) IS

Line 2165: FROM hz_contact_points, hz_parties p

2161: CURSOR c_contact_point (
2162: p_contact_point_id NUMBER
2163: ) IS
2164: SELECT p.party_id, p.party_type
2165: FROM hz_contact_points, hz_parties p
2166: WHERE contact_point_id = p_contact_point_id
2167: AND owner_table_name = 'HZ_PARTIES'
2168: AND owner_table_id = p.party_id;
2169:

Line 2167: AND owner_table_name = 'HZ_PARTIES'

2163: ) IS
2164: SELECT p.party_id, p.party_type
2165: FROM hz_contact_points, hz_parties p
2166: WHERE contact_point_id = p_contact_point_id
2167: AND owner_table_name = 'HZ_PARTIES'
2168: AND owner_table_id = p.party_id;
2169:
2170: CURSOR c_contact_point_ps (
2171: p_contact_point_id NUMBER

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

2170: CURSOR c_contact_point_ps (
2171: p_contact_point_id NUMBER
2172: ) IS
2173: SELECT p.party_id, p.party_type
2174: FROM hz_contact_points cp, hz_party_sites ps, hz_parties p
2175: WHERE contact_point_id = p_contact_point_id
2176: AND owner_table_name = 'HZ_PARTY_SITES'
2177: AND owner_table_id = ps.party_site_id
2178: AND ps.party_id = p.party_id;

Line 2190: IF p_db_object_name = 'HZ_PARTIES' THEN

2186: l_object_type VARCHAR2(30);
2187:
2188: BEGIN
2189:
2190: IF p_db_object_name = 'HZ_PARTIES' THEN
2191: OPEN c_party(TO_NUMBER(p_object_pk1));
2192: FETCH c_party BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2193: CLOSE c_party;
2194:

Line 2218: IF l_subject_table_name = 'HZ_PARTIES' THEN

2214: l_object_id, l_object_table_name, l_object_type;
2215: CLOSE c_relationship;
2216:
2217: i := 1;
2218: IF l_subject_table_name = 'HZ_PARTIES' THEN
2219: x_party_id_tbl(i) := l_subject_id;
2220: x_party_type_tbl(i) := l_subject_type;
2221: i := i+1;
2222: END IF;

Line 2223: IF l_object_table_name = 'HZ_PARTIES' THEN

2219: x_party_id_tbl(i) := l_subject_id;
2220: x_party_type_tbl(i) := l_subject_type;
2221: i := i+1;
2222: END IF;
2223: IF l_object_table_name = 'HZ_PARTIES' THEN
2224: x_party_id_tbl(i) := l_object_id;
2225: x_party_type_tbl(i) := l_object_type;
2226: i := i+1;
2227: END IF;