APPS.FV_ECON_BENF_DISC_PVT dependencies on AP_INVOICES_ALL

Line 535: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;

531: x_discount_amount > 0;
532:
533: err_message varchar2(5000);
534: /* Fetch Variables for Cursor c1 */
535: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;

Line 536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

532:
533: err_message varchar2(5000);
534: /* Fetch Variables for Cursor c1 */
535: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
540: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;

Line 537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;

533: err_message varchar2(5000);
534: /* Fetch Variables for Cursor c1 */
535: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
540: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;
541: /*-------------Comments----------------------------------------------

Line 538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;

534: /* Fetch Variables for Cursor c1 */
535: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
540: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;
541: /*-------------Comments----------------------------------------------
542: X_Discount_Amount AP_PAYMENT_SCHEDULES.DISCOUNT_AMOUNT_AVAILABLE%TYPE;

Line 539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;

535: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
540: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;
541: /*-------------Comments----------------------------------------------
542: X_Discount_Amount AP_PAYMENT_SCHEDULES.DISCOUNT_AMOUNT_AVAILABLE%TYPE;
543: X_Discount_Date AP_PAYMENT_SCHEDULES.DISCOUNT_DATE%TYPE;

Line 540: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;

536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
540: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;
541: /*-------------Comments----------------------------------------------
542: X_Discount_Amount AP_PAYMENT_SCHEDULES.DISCOUNT_AMOUNT_AVAILABLE%TYPE;
543: X_Discount_Date AP_PAYMENT_SCHEDULES.DISCOUNT_DATE%TYPE;
544: --------------End of Comments---------------------------------------*/

Line 563: from ap_invoices_all

559: Begin
560:
561: select invoice_num
562: into X_Invoice_Num
563: from ap_invoices_all
564: where invoice_id = X_Invoice_id;
565:
566: --MOAC changes: Removed the org_id parameter in the call to FV_INSTALL.enabled
567: v_fv_enabled := fv_install.enabled; -- check if FV is enabled