DBA Data[Home] [Help]

APPS.PON_BID_VALIDATIONS_PKG dependencies on PO_VENDOR_SITES_ALL

Line 7088: l_vendor_site_code PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;

7084:
7085: END validate_spreadsheet_upload;
7086:
7087: FUNCTION GET_VENDOR_SITE_CODE(p_vendor_site_id IN NUMBER) RETURN VARCHAR2 IS
7088: l_vendor_site_code PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
7089: BEGIN
7090: IF (p_vendor_site_id = -1) THEN
7091: RETURN '';
7092: ELSE

Line 7096: FROM PO_VENDOR_SITES_ALL

7092: ELSE
7093: BEGIN
7094: SELECT vendor_site_code
7095: INTO l_vendor_site_code
7096: FROM PO_VENDOR_SITES_ALL
7097: WHERE vendor_site_id = p_vendor_site_id;
7098: EXCEPTION
7099: WHEN NO_DATA_FOUND THEN
7100: l_vendor_site_code := '';