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

Line 7435: -- 4145213 changed hz_parties select to synch up with ExternalPartyContact LOV query

7431: ,p_contact_id IN NUMBER
7432: ) RETURN VARCHAR2 IS
7433:
7434:
7435: -- 4145213 changed hz_parties select to synch up with ExternalPartyContact LOV query
7436: -- 4208420 changed hz_parties select to synch up with ExternalPartyContact LOV query
7437:
7438: CURSOR contact_cur IS
7439: select 'X'

Line 7436: -- 4208420 changed hz_parties select to synch up with ExternalPartyContact LOV query

7432: ) RETURN VARCHAR2 IS
7433:
7434:
7435: -- 4145213 changed hz_parties select to synch up with ExternalPartyContact LOV query
7436: -- 4208420 changed hz_parties select to synch up with ExternalPartyContact LOV query
7437:
7438: CURSOR contact_cur IS
7439: select 'X'
7440: from

Line 7447: FROM hz_parties contact,

7443: and po_vendor_id = p_party_id
7444: and 'SUPPLIER_ORG' = p_party_role
7445: UNION
7446: SELECT 'X'
7447: FROM hz_parties contact,
7448: hz_relationships hr
7449: WHERE hr.subject_id = contact.party_id
7450: AND 'SUPPLIER_ORG' <> p_party_role
7451: And hr.object_id = p_party_id

Line 7457: and hr.subject_table_name ='HZ_PARTIES'

7453: AND hr.relationship_type = 'CONTACT'
7454: AND hr.relationship_code = 'CONTACT_OF'
7455: and hr.subject_type = 'PERSON'
7456: and hr.object_type = 'ORGANIZATION'
7457: and hr.subject_table_name ='HZ_PARTIES'
7458: and hr.object_table_name ='HZ_PARTIES'
7459: AND hr.status = 'A'
7460: AND hr.start_date <= sysdate
7461: AND nvl(hr.end_date, sysdate + 1) > sysdate;

Line 7458: and hr.object_table_name ='HZ_PARTIES'

7454: AND hr.relationship_code = 'CONTACT_OF'
7455: and hr.subject_type = 'PERSON'
7456: and hr.object_type = 'ORGANIZATION'
7457: and hr.subject_table_name ='HZ_PARTIES'
7458: and hr.object_table_name ='HZ_PARTIES'
7459: AND hr.status = 'A'
7460: AND hr.start_date <= sysdate
7461: AND nvl(hr.end_date, sysdate + 1) > sysdate;
7462:

Line 12178: PARTY_ID from HZ_PARTIES

12174: /***
12175: Function get_party_name
12176: This API will be invoked by the Create/Update/ViewOnly Deliverable pages to display the
12177: name for an External Party. The External Party could be VENDOR_ID from PO_VENDORS or
12178: PARTY_ID from HZ_PARTIES
12179: Parameter Details:
12180: p_external_party_id: Unique Identifier from PO_VENDORS or HZ_PARTIES
12181: p_external_party_role: Resp_Party_Code from OKC_RESP_PARTIES
12182: 24-FEB-2005 pnayani -- bug#4201738 updated get_party_name to return null

Line 12180: p_external_party_id: Unique Identifier from PO_VENDORS or HZ_PARTIES

12176: This API will be invoked by the Create/Update/ViewOnly Deliverable pages to display the
12177: name for an External Party. The External Party could be VENDOR_ID from PO_VENDORS or
12178: PARTY_ID from HZ_PARTIES
12179: Parameter Details:
12180: p_external_party_id: Unique Identifier from PO_VENDORS or HZ_PARTIES
12181: p_external_party_role: Resp_Party_Code from OKC_RESP_PARTIES
12182: 24-FEB-2005 pnayani -- bug#4201738 updated get_party_name to return null
12183: ***/
12184: FUNCTION get_party_name(

Line 12195: from hz_parties

12191: where vendor_id = p_external_party_id;
12192:
12193: CURSOR get_party_name IS
12194: SELECT party_name
12195: from hz_parties
12196: where party_id = p_external_party_id;
12197:
12198: l_api_name CONSTANT VARCHAR2(30) := 'get_party_name';
12199: l_party_name VARCHAR2(360);