[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:
497: -- ------------------------------------------------------------------
498: -- Procedure Insert_IA_Txns
499: -- ------------------------------------------------------------------
500: -- Insert_IA_Txns procedure is called from Call_Approval_Api procedure.
501: -- This procedure inserts a record in Fv_Interagency_Funds table
502: -- for all the IPAC txn's and recurring txn's.
503: -- Parameters:
504: -- p_invoice_id: Invoice Id that needs be inserted into the table.
505: --
548: FROM Ap_Invoices ai, Po_Vendors pv
549: WHERE ai.invoice_id = p_invoice_id
550: AND ai.vendor_id = pv.vendor_id
551: AND NOT EXISTS (SELECT 'X'
552: FROM Fv_Interagency_Funds
553: WHERE set_of_books_id = g_sob_id
554: AND invoice_id IS NOT NULL
555: AND invoice_id = ai.invoice_id);
556: EXCEPTION
596: RETURN;
597: END IF; -- count
598:
599: -- Inserting into the table.
600: INSERT INTO Fv_Interagency_Funds
601: (interagency_fund_id,
602: set_of_books_id,
603: processed_flag,
604: chargeback_flag,
611: invoice_id,
612: invoice_number,
613: org_id)
614: VALUES
615: (Fv_Interagency_Funds_S.NEXTVAL,
616: g_sob_id,
617: 'N',
618: 'N',
619: SYSDATE,