DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on PO_VENDORS

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

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

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

11167: p_external_party_role IN VARCHAR2) RETURN VARCHAR2 IS
11168:
11169: CURSOR get_vendor_name IS
11170: SELECT vendor_name
11171: from po_vendors
11172: where vendor_id = p_external_party_id;
11173:
11174: CURSOR get_party_name IS
11175: SELECT party_name