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.FUN_SECURITY dependencies on HZ_PARTIES

Line 90: FROM HZ_PARTIES HZP,

86: CURSOR c_get_ice_orgs
87: IS
88: select * from (SELECT hzp.party_id AS partyid,
89: DECODE(xfi.party_id,NULL,'REMOTE','LOCAL') AS local
90: FROM HZ_PARTIES HZP,
91: XLE_ENTITY_PROFILES XFI,
92: HZ_PARTY_USG_ASSIGNMENTS HUA
93: WHERE HZP.PARTY_TYPE='ORGANIZATION'
94: AND FUN_TCA_PKG.GET_LE_ID(HZP.PARTY_ID)=XFI.PARTY_ID

Line 100: and subject_table_name like 'HZ_PARTIES'

96: AND HUA.PARTY_USAGE_CODE ='INTERCOMPANY_ORG'
97: AND XFI.TRANSACTING_ENTITY_FLAG = 'Y') QRSLT
98: WHERE (PARTYID not in ( select object_id
99: from hz_relationships where subject_id = -999
100: and subject_table_name like 'HZ_PARTIES'
101: and relationship_code like 'CONTACT_OF'
102: and Directional_flag = 'F'
103: and start_date < sysdate and end_date > sysdate ));
104:

Line 430: l_tca_relationship_record.subject_table_name := 'HZ_PARTIES';

426:
427: BEGIN
428: l_tca_relationship_record.subject_id := p_person_id;
429: l_tca_relationship_record.subject_type := 'PERSON';
430: l_tca_relationship_record.subject_table_name := 'HZ_PARTIES';
431: l_tca_relationship_record.object_id := v_org_record.partyid;
432: l_tca_relationship_record.object_type := 'ORGANIZATION';
433: l_tca_relationship_record.object_table_name := 'HZ_PARTIES';
434: l_tca_relationship_record.relationship_code := 'CONTACT_OF';

Line 433: l_tca_relationship_record.object_table_name := 'HZ_PARTIES';

429: l_tca_relationship_record.subject_type := 'PERSON';
430: l_tca_relationship_record.subject_table_name := 'HZ_PARTIES';
431: l_tca_relationship_record.object_id := v_org_record.partyid;
432: l_tca_relationship_record.object_type := 'ORGANIZATION';
433: l_tca_relationship_record.object_table_name := 'HZ_PARTIES';
434: l_tca_relationship_record.relationship_code := 'CONTACT_OF';
435: l_tca_relationship_record.relationship_type := 'CONTACT';
436: l_tca_relationship_record.start_date := SYSDATE;
437: l_tca_relationship_record.created_by_module := 'FUN_AGIS';

Line 444: l_tca_contact_record.party_rel_rec.subject_table_name := 'HZ_PARTIES';

440:
441: l_tca_contact_record.created_by_module := 'FUN_AGIS';
442: l_tca_contact_record.party_rel_rec.subject_id := p_person_id;
443: l_tca_contact_record.party_rel_rec.subject_type := 'PERSON';
444: l_tca_contact_record.party_rel_rec.subject_table_name := 'HZ_PARTIES';
445: l_tca_contact_record.party_rel_rec.object_id := v_org_record.partyid;
446: l_tca_contact_record.party_rel_rec.object_type := 'ORGANIZATION';
447: l_tca_contact_record.party_rel_rec.object_table_name := 'HZ_PARTIES';
448: l_tca_contact_record.party_rel_rec.relationship_code := 'CONTACT_OF';

Line 447: l_tca_contact_record.party_rel_rec.object_table_name := 'HZ_PARTIES';

443: l_tca_contact_record.party_rel_rec.subject_type := 'PERSON';
444: l_tca_contact_record.party_rel_rec.subject_table_name := 'HZ_PARTIES';
445: l_tca_contact_record.party_rel_rec.object_id := v_org_record.partyid;
446: l_tca_contact_record.party_rel_rec.object_type := 'ORGANIZATION';
447: l_tca_contact_record.party_rel_rec.object_table_name := 'HZ_PARTIES';
448: l_tca_contact_record.party_rel_rec.relationship_code := 'CONTACT_OF';
449: l_tca_contact_record.party_rel_rec.relationship_type := 'CONTACT';
450: l_tca_contact_record.party_rel_rec.start_date := SYSDATE;
451: l_tca_contact_record.party_rel_rec.created_by_module := 'FUN_AGIS';

Line 672: l_tca_relationship_record.subject_table_name:= 'HZ_PARTIES';

668:
669: BEGIN
670: l_tca_relationship_record.subject_id := p_person_id;
671: l_tca_relationship_record.subject_type := 'PERSON';
672: l_tca_relationship_record.subject_table_name:= 'HZ_PARTIES';
673: l_tca_relationship_record.object_id := p_org_id;
674: l_tca_relationship_record.object_type := 'ORGANIZATION';
675: l_tca_relationship_record.object_table_name := 'HZ_PARTIES';
676: l_tca_relationship_record.relationship_code := 'CONTACT_OF';

Line 675: l_tca_relationship_record.object_table_name := 'HZ_PARTIES';

671: l_tca_relationship_record.subject_type := 'PERSON';
672: l_tca_relationship_record.subject_table_name:= 'HZ_PARTIES';
673: l_tca_relationship_record.object_id := p_org_id;
674: l_tca_relationship_record.object_type := 'ORGANIZATION';
675: l_tca_relationship_record.object_table_name := 'HZ_PARTIES';
676: l_tca_relationship_record.relationship_code := 'CONTACT_OF';
677: l_tca_relationship_record.relationship_type := 'CONTACT';
678: l_tca_relationship_record.start_date := SYSDATE;
679: l_tca_relationship_record.created_by_module := 'FUN_AGIS';

Line 687: l_tca_contact_record.party_rel_rec.subject_table_name := 'HZ_PARTIES';

683:
684: l_tca_contact_record.created_by_module := 'FUN_AGIS';
685: l_tca_contact_record.party_rel_rec.subject_id := p_person_id;
686: l_tca_contact_record.party_rel_rec.subject_type := 'PERSON';
687: l_tca_contact_record.party_rel_rec.subject_table_name := 'HZ_PARTIES';
688: l_tca_contact_record.party_rel_rec.object_id := p_org_id;
689: l_tca_contact_record.party_rel_rec.object_type := 'ORGANIZATION';
690: l_tca_contact_record.party_rel_rec.object_table_name := 'HZ_PARTIES';
691: l_tca_contact_record.party_rel_rec.relationship_code := 'CONTACT_OF';

Line 690: l_tca_contact_record.party_rel_rec.object_table_name := 'HZ_PARTIES';

686: l_tca_contact_record.party_rel_rec.subject_type := 'PERSON';
687: l_tca_contact_record.party_rel_rec.subject_table_name := 'HZ_PARTIES';
688: l_tca_contact_record.party_rel_rec.object_id := p_org_id;
689: l_tca_contact_record.party_rel_rec.object_type := 'ORGANIZATION';
690: l_tca_contact_record.party_rel_rec.object_table_name := 'HZ_PARTIES';
691: l_tca_contact_record.party_rel_rec.relationship_code := 'CONTACT_OF';
692: l_tca_contact_record.party_rel_rec.relationship_type := 'CONTACT';
693: l_tca_contact_record.party_rel_rec.start_date := SYSDATE;
694: l_tca_contact_record.party_rel_rec.created_by_module := 'FUN_AGIS';