[Home] [Help]
444: END;
445:
446: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
447: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' Inserting the transaction into the '||
448: 'Fv_Interagency_Funds Table.');
449: END IF;
450: -- Call Insert_IA_Txns Procedure
451: Insert_IA_Txns(p_invoice_id,p_invoice_num,x_paygroup);
452: Log_Mesg('O',RPAD(NVL(p_invoice_num,' '),50,' ')
485: -- ------------------------------------------------------------------
486: -- Procedure Insert_IA_Txns
487: -- ------------------------------------------------------------------
488: -- Insert_IA_Txns procedure is called from Call_Approval_Api procedure.
489: -- This procedure inserts a record in Fv_Interagency_Funds table
490: -- for all the IPAC txn's and recurring txn's.
491: -- Parameters:
492: -- p_invoice_id: Invoice Id that needs be inserted into the table.
493: --
536: FROM Ap_Invoices ai, Po_Vendors pv
537: WHERE ai.invoice_id = p_invoice_id
538: AND ai.vendor_id = pv.vendor_id
539: AND NOT EXISTS (SELECT 'X'
540: FROM Fv_Interagency_Funds
541: WHERE set_of_books_id = g_sob_id
542: AND invoice_id IS NOT NULL
543: AND invoice_id = ai.invoice_id);
544: EXCEPTION
584: RETURN;
585: END IF; -- count
586:
587: -- Inserting into the table.
588: INSERT INTO Fv_Interagency_Funds
589: (interagency_fund_id,
590: set_of_books_id,
591: processed_flag,
592: chargeback_flag,
599: invoice_id,
600: invoice_number,
601: org_id)
602: VALUES
603: (Fv_Interagency_Funds_S.NEXTVAL,
604: g_sob_id,
605: 'N',
606: 'N',
607: SYSDATE,