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_MAP_PARTY_PUB dependencies on HZ_RELATIONSHIPS

Line 32: RELATIONSHIP_CODE hz_relationships.relationship_code%type,

28: PRIMARY_GEO_AREA hz_party_interface.HQ_PRIMARY_GEO_AREA%TYPE,
29: COUNTY hz_party_interface.HQ_COUNTY%TYPE,
30: POSTAL_CODE hz_party_interface.HQ_POSTAL_CODE%TYPE,
31: PHONE_NUMBER hz_party_interface.HQ_PHONE_NUMBER%TYPE,
32: RELATIONSHIP_CODE hz_relationships.relationship_code%type,
33: RELATIONSHIP_TYPE hz_relationships.relationship_type%type,
34: MAIN_PARTY_ID NUMBER,
35: MAIN_DUNS_NUMBER VARCHAR2(15),
36: CONTENT_SOURCE_TYPE VARCHAR2(30)

Line 33: RELATIONSHIP_TYPE hz_relationships.relationship_type%type,

29: COUNTY hz_party_interface.HQ_COUNTY%TYPE,
30: POSTAL_CODE hz_party_interface.HQ_POSTAL_CODE%TYPE,
31: PHONE_NUMBER hz_party_interface.HQ_PHONE_NUMBER%TYPE,
32: RELATIONSHIP_CODE hz_relationships.relationship_code%type,
33: RELATIONSHIP_TYPE hz_relationships.relationship_type%type,
34: MAIN_PARTY_ID NUMBER,
35: MAIN_DUNS_NUMBER VARCHAR2(15),
36: CONTENT_SOURCE_TYPE VARCHAR2(30)
37: );

Line 1018: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_RELATIONSHIPS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

1014: /* SSM SST Integration and Extension
1015: * Policy functions will not be added to non-profile entities as the concept of
1016: * select/de-select data sources for other entities is obsoleted.
1017:
1018: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_RELATIONSHIPS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1019: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_LOCATIONS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1020: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CONTACT_POINTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1021: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CREDIT_RATINGS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1022: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_REPORTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

Line 6385: FROM hz_relationships rel

6381: ) IS
6382:
6383: CURSOR c_old_party_rel IS
6384: SELECT rel.relationship_id, rel.subject_id
6385: FROM hz_relationships rel
6386: WHERE rel.object_id = p_party_rel_rec.object_id
6387: AND rel.relationship_code = p_party_rel_rec.relationship_code
6388: AND rel.relationship_type = p_party_rel_rec.relationship_type
6389: AND rel.actual_content_source = p_party_rel_rec.actual_content_source

Line 6407: TYPE l_old_rel_id_table IS TABLE OF hz_relationships.relationship_id%TYPE

6403: x_party_number hz_parties.party_number%TYPE;
6404:
6405: l_profile VARCHAR2(1);
6406:
6407: TYPE l_old_rel_id_table IS TABLE OF hz_relationships.relationship_id%TYPE
6408: INDEX BY BINARY_INTEGER;
6409:
6410: TYPE l_old_sub_id_table IS TABLE OF hz_relationships.subject_id%TYPE
6411: INDEX BY BINARY_INTEGER;

Line 6410: TYPE l_old_sub_id_table IS TABLE OF hz_relationships.subject_id%TYPE

6406:
6407: TYPE l_old_rel_id_table IS TABLE OF hz_relationships.relationship_id%TYPE
6408: INDEX BY BINARY_INTEGER;
6409:
6410: TYPE l_old_sub_id_table IS TABLE OF hz_relationships.subject_id%TYPE
6411: INDEX BY BINARY_INTEGER;
6412:
6413: l_old_rel_ids l_old_rel_id_table;
6414: l_old_sub_ids l_old_sub_id_table;

Line 6427: l_rel_type hz_relationships.relationship_type%TYPE;

6423: i NUMBER := 0;
6424:
6425: -- Bug 3020636 : Added Local variables and cursor
6426:
6427: l_rel_type hz_relationships.relationship_type%TYPE;
6428: l_rel_code hz_relationships.relationship_code%TYPE;
6429: l_rel_id hz_relationships.relationship_id%TYPE;
6430: l_obj_ver_no hz_relationships.object_version_number%TYPE;
6431:

Line 6428: l_rel_code hz_relationships.relationship_code%TYPE;

6424:
6425: -- Bug 3020636 : Added Local variables and cursor
6426:
6427: l_rel_type hz_relationships.relationship_type%TYPE;
6428: l_rel_code hz_relationships.relationship_code%TYPE;
6429: l_rel_id hz_relationships.relationship_id%TYPE;
6430: l_obj_ver_no hz_relationships.object_version_number%TYPE;
6431:
6432: CURSOR c_old_parent_hq IS

Line 6429: l_rel_id hz_relationships.relationship_id%TYPE;

6425: -- Bug 3020636 : Added Local variables and cursor
6426:
6427: l_rel_type hz_relationships.relationship_type%TYPE;
6428: l_rel_code hz_relationships.relationship_code%TYPE;
6429: l_rel_id hz_relationships.relationship_id%TYPE;
6430: l_obj_ver_no hz_relationships.object_version_number%TYPE;
6431:
6432: CURSOR c_old_parent_hq IS
6433: SELECT rel.relationship_id

Line 6430: l_obj_ver_no hz_relationships.object_version_number%TYPE;

6426:
6427: l_rel_type hz_relationships.relationship_type%TYPE;
6428: l_rel_code hz_relationships.relationship_code%TYPE;
6429: l_rel_id hz_relationships.relationship_id%TYPE;
6430: l_obj_ver_no hz_relationships.object_version_number%TYPE;
6431:
6432: CURSOR c_old_parent_hq IS
6433: SELECT rel.relationship_id
6434: FROM hz_relationships rel

Line 6434: FROM hz_relationships rel

6430: l_obj_ver_no hz_relationships.object_version_number%TYPE;
6431:
6432: CURSOR c_old_parent_hq IS
6433: SELECT rel.relationship_id
6434: FROM hz_relationships rel
6435: WHERE rel.object_id = p_party_rel_rec.object_id
6436: AND rel.relationship_code = l_rel_code
6437: AND rel.relationship_type = l_rel_type
6438: AND rel.actual_content_source = p_party_rel_rec.actual_content_source

Line 6473: FROM hz_relationships

6469: INTO l_rel_id;
6470: EXIT WHEN c_old_parent_hq%NOTFOUND;
6471:
6472: SELECT object_version_number INTO l_obj_ver_no
6473: FROM hz_relationships
6474: WHERE relationship_id = l_rel_id
6475: AND subject_table_name = 'HZ_PARTIES'
6476: AND object_table_name = 'HZ_PARTIES'
6477: AND DIRECTIONAL_FLAG = 'F';

Line 6548: FROM hz_relationships

6544:
6545: ELSE
6546: --End date old party rel.
6547: SELECT object_version_number INTO l_object_version_number1
6548: FROM hz_relationships
6549: WHERE relationship_id = l_old_rel_ids(i)
6550: AND subject_table_name = 'HZ_PARTIES'
6551: AND object_table_name = 'HZ_PARTIES'
6552: AND DIRECTIONAL_FLAG = 'F';