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 7034: -- 4145213 changed hz_parties select to synch up with ExternalPartyContact LOV query

7030: ,p_contact_id IN NUMBER
7031: ) RETURN VARCHAR2 IS
7032:
7033:
7034: -- 4145213 changed hz_parties select to synch up with ExternalPartyContact LOV query
7035: -- 4208420 changed hz_parties select to synch up with ExternalPartyContact LOV query
7036:
7037: CURSOR contact_cur IS
7038: select 'X'

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

7031: ) RETURN VARCHAR2 IS
7032:
7033:
7034: -- 4145213 changed hz_parties select to synch up with ExternalPartyContact LOV query
7035: -- 4208420 changed hz_parties select to synch up with ExternalPartyContact LOV query
7036:
7037: CURSOR contact_cur IS
7038: select 'X'
7039: from

Line 7046: FROM hz_parties contact,

7042: and po_vendor_id = p_party_id
7043: and 'SUPPLIER_ORG' = p_party_role
7044: UNION
7045: SELECT 'X'
7046: FROM hz_parties contact,
7047: hz_relationships hr
7048: WHERE hr.subject_id = contact.party_id
7049: AND 'SUPPLIER_ORG' <> p_party_role
7050: And hr.object_id = p_party_id

Line 7056: and hr.subject_table_name ='HZ_PARTIES'

7052: AND hr.relationship_type = 'CONTACT'
7053: AND hr.relationship_code = 'CONTACT_OF'
7054: and hr.subject_type = 'PERSON'
7055: and hr.object_type = 'ORGANIZATION'
7056: and hr.subject_table_name ='HZ_PARTIES'
7057: and hr.object_table_name ='HZ_PARTIES'
7058: AND hr.status = 'A'
7059: AND hr.start_date <= sysdate
7060: AND nvl(hr.end_date, sysdate + 1) > sysdate;

Line 7057: and hr.object_table_name ='HZ_PARTIES'

7053: AND hr.relationship_code = 'CONTACT_OF'
7054: and hr.subject_type = 'PERSON'
7055: and hr.object_type = 'ORGANIZATION'
7056: and hr.subject_table_name ='HZ_PARTIES'
7057: and hr.object_table_name ='HZ_PARTIES'
7058: AND hr.status = 'A'
7059: AND hr.start_date <= sysdate
7060: AND nvl(hr.end_date, sysdate + 1) > sysdate;
7061:

Line 11159: PARTY_ID from HZ_PARTIES

11155: /***
11156: Function get_party_name
11157: This API will be invoked by the Create/Update/ViewOnly Deliverable pages to display the
11158: name for an External Party. The External Party could be VENDOR_ID from PO_VENDORS or
11159: PARTY_ID from HZ_PARTIES
11160: Parameter Details:
11161: p_external_party_id: Unique Identifier from PO_VENDORS or HZ_PARTIES
11162: p_external_party_role: Resp_Party_Code from OKC_RESP_PARTIES
11163: 24-FEB-2005 pnayani -- bug#4201738 updated get_party_name to return null

Line 11161: p_external_party_id: Unique Identifier from PO_VENDORS or HZ_PARTIES

11157: This API will be invoked by the Create/Update/ViewOnly Deliverable pages to display the
11158: name for an External Party. The External Party could be VENDOR_ID from PO_VENDORS or
11159: PARTY_ID from HZ_PARTIES
11160: Parameter Details:
11161: p_external_party_id: Unique Identifier from PO_VENDORS or HZ_PARTIES
11162: p_external_party_role: Resp_Party_Code from OKC_RESP_PARTIES
11163: 24-FEB-2005 pnayani -- bug#4201738 updated get_party_name to return null
11164: ***/
11165: FUNCTION get_party_name(

Line 11176: from hz_parties

11172: where vendor_id = p_external_party_id;
11173:
11174: CURSOR get_party_name IS
11175: SELECT party_name
11176: from hz_parties
11177: where party_id = p_external_party_id;
11178:
11179: l_api_name CONSTANT VARCHAR2(30) := 'get_party_name';
11180: l_party_name VARCHAR2(360);