APPS.AP_APXWTGNR_XMLP_PKG dependencies on PO_VENDORS

Line 238: L_VENDOR_REALNAME_LOW PO_VENDORS.VENDOR_NAME%TYPE;

234:
235: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
236: BEGIN
237: DECLARE
238: L_VENDOR_REALNAME_LOW PO_VENDORS.VENDOR_NAME%TYPE;
239: L_VENDOR_REALNAME_HIGH PO_VENDORS.VENDOR_NAME%TYPE;
240: INIT_FAILURE EXCEPTION;
241: BEGIN
242: p_debug_switch:='Y';

Line 239: L_VENDOR_REALNAME_HIGH PO_VENDORS.VENDOR_NAME%TYPE;

235: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
236: BEGIN
237: DECLARE
238: L_VENDOR_REALNAME_LOW PO_VENDORS.VENDOR_NAME%TYPE;
239: L_VENDOR_REALNAME_HIGH PO_VENDORS.VENDOR_NAME%TYPE;
240: INIT_FAILURE EXCEPTION;
241: BEGIN
242: p_debug_switch:='Y';
243:

Line 253: PO_VENDORS V

249: SELECT
250: V.VENDOR_NAME
251: INTO L_VENDOR_REALNAME_LOW
252: FROM
253: PO_VENDORS V
254: WHERE V.VENDOR_ID = TO_NUMBER(P_SUPPLIER_FROM_V);
255: END IF;
256: IF (P_SUPPLIER_TO_V IS NOT NULL) THEN
257: SELECT

Line 261: PO_VENDORS V

257: SELECT
258: V.VENDOR_NAME
259: INTO L_VENDOR_REALNAME_HIGH
260: FROM
261: PO_VENDORS V
262: WHERE V.VENDOR_ID = TO_NUMBER(P_SUPPLIER_TO_V);
263: END IF;
264: P_SUPPLIER_FROM_V := L_VENDOR_REALNAME_LOW;
265: P_SUPPLIER_TO_V := L_VENDOR_REALNAME_HIGH;

Line 1298: RET_TEXT := ', po_vendors tax_auth' || '

1294: RET_TEXT VARCHAR2(1000);
1295: BEGIN
1296: RET_TEXT:=' ';
1297: IF (P_AWT_REPORT in ('AWT4','AWT5')) THEN
1298: RET_TEXT := ', po_vendors tax_auth' || '
1299: ' || ', po_vendor_sites tax_auth_site';
1300: END IF;
1301: RETURN (RET_TEXT);
1302: END FTAXAUTHORITYTABLES;