DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on PO_VENDORS

Line 12177: name for an External Party. The External Party could be VENDOR_ID from PO_VENDORS or

12173:
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

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 12190: from po_vendors

12186: p_external_party_role IN VARCHAR2) RETURN VARCHAR2 IS
12187:
12188: CURSOR get_vendor_name IS
12189: SELECT vendor_name
12190: from po_vendors
12191: where vendor_id = p_external_party_id;
12192:
12193: CURSOR get_party_name IS
12194: SELECT party_name