APPS.FV_ECON_BENF_DISC_PVT dependencies on AP_INVOICES_ALL

Line 519: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;

515: x_discount_amount > 0;
516:
517: err_message varchar2(5000);
518: /* Fetch Variables for Cursor c1 */
519: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
520: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
521: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
522: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
523: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;

Line 520: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

516:
517: err_message varchar2(5000);
518: /* Fetch Variables for Cursor c1 */
519: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
520: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
521: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
522: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
523: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
524: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;

Line 521: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;

517: err_message varchar2(5000);
518: /* Fetch Variables for Cursor c1 */
519: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
520: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
521: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
522: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
523: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
524: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;
525: /*-------------Comments----------------------------------------------

Line 522: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;

518: /* Fetch Variables for Cursor c1 */
519: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
520: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
521: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
522: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
523: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
524: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;
525: /*-------------Comments----------------------------------------------
526: X_Discount_Amount AP_PAYMENT_SCHEDULES.DISCOUNT_AMOUNT_AVAILABLE%TYPE;

Line 523: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;

519: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
520: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
521: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
522: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
523: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
524: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;
525: /*-------------Comments----------------------------------------------
526: X_Discount_Amount AP_PAYMENT_SCHEDULES.DISCOUNT_AMOUNT_AVAILABLE%TYPE;
527: X_Discount_Date AP_PAYMENT_SCHEDULES.DISCOUNT_DATE%TYPE;

Line 524: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;

520: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
521: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
522: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
523: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
524: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;
525: /*-------------Comments----------------------------------------------
526: X_Discount_Amount AP_PAYMENT_SCHEDULES.DISCOUNT_AMOUNT_AVAILABLE%TYPE;
527: X_Discount_Date AP_PAYMENT_SCHEDULES.DISCOUNT_DATE%TYPE;
528: --------------End of Comments---------------------------------------*/

Line 545: from ap_invoices_all

541: Begin
542:
543: select invoice_num
544: into X_Invoice_Num
545: from ap_invoices_all
546: where invoice_id = X_Invoice_id;
547:
548: --MOAC changes: Removed the org_id parameter in the call to FV_INSTALL.enabled
549: v_fv_enabled := fv_install.enabled; -- check if FV is enabled