APPS.FV_IPAC_AUTOPAYMENTS_PKG dependencies on AP_INVOICES

Line 176: FROM Ap_Invoices

172: l_module_name VARCHAR2(200) := g_module_name || 'Validate_Invoices';
173:
174: CURSOR get_invoice_csr IS
175: SELECT invoice_id,invoice_num,invoice_date
176: FROM Ap_Invoices
177: WHERE set_of_books_id = g_sob_id
178: AND source = 'IPAC'
179: AND batch_id = g_batch_id
180: ORDER BY invoice_num;

Line 185: FROM Fv_Ipac_Recurring_Inv fv, Ap_Invoices ap

181:
182: CURSOR get_recinv_csr(inv_action VARCHAR2) IS
183: SELECT fv.invoice_id, ap.invoice_num,
184: fv.accomplish_date, ap.payment_method_lookup_code
185: FROM Fv_Ipac_Recurring_Inv fv, Ap_Invoices ap
186: WHERE fv.invoice_id = ap.invoice_id
187: AND fv.batch_name = g_batch_name
188: AND fv.invoice_action = inv_action
189: ORDER BY ap.invoice_num;

Line 191: l_invoice_num Ap_Invoices_All.invoice_num%TYPE;

187: AND fv.batch_name = g_batch_name
188: AND fv.invoice_action = inv_action
189: ORDER BY ap.invoice_num;
190:
191: l_invoice_num Ap_Invoices_All.invoice_num%TYPE;
192: l_inv_action Fv_Ipac_Recurring_Inv.invoice_action%TYPE;
193: l_validate_flag VARCHAR2(1);
194:
195: BEGIN

Line 326: x_paygroup Ap_Invoices.pay_group_lookup_code%TYPE;

322: l_module_name VARCHAR2(200) := g_module_name || 'Call_Approval_Api';
323: l_holds_count NUMBER;
324: l_approval_status VARCHAR2(25);
325: l_mesg VARCHAR(2000);
326: x_paygroup Ap_Invoices.pay_group_lookup_code%TYPE;
327: l_funds_return_code VARCHAR2(15);
328:
329: BEGIN
330: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 517: l_vendor_id Ap_Invoices.vendor_id%TYPE;

513: PROCEDURE Insert_IA_Txns(p_invoice_id NUMBER,
514: p_invoice_num VARCHAR2,
515: x_paygroup OUT NOCOPY VARCHAR2) IS
516: l_module_name VARCHAR2(200) := g_module_name || 'Insert_IA_Txns';
517: l_vendor_id Ap_Invoices.vendor_id%TYPE;
518: l_vendor_name Po_Vendors.vendor_name%TYPE;
519: l_date Ap_Invoices.creation_date%TYPE;
520: l_count NUMBER := 0;
521: BEGIN

Line 519: l_date Ap_Invoices.creation_date%TYPE;

515: x_paygroup OUT NOCOPY VARCHAR2) IS
516: l_module_name VARCHAR2(200) := g_module_name || 'Insert_IA_Txns';
517: l_vendor_id Ap_Invoices.vendor_id%TYPE;
518: l_vendor_name Po_Vendors.vendor_name%TYPE;
519: l_date Ap_Invoices.creation_date%TYPE;
520: l_count NUMBER := 0;
521: BEGIN
522: -- Check if the paygroup matches with the paygroup in Federal options.
523: BEGIN

Line 526: FROM Fv_Operating_Units fo,Ap_Invoices ai

522: -- Check if the paygroup matches with the paygroup in Federal options.
523: BEGIN
524: SELECT COUNT(*)
525: INTO l_count
526: FROM Fv_Operating_Units fo,Ap_Invoices ai
527: WHERE ai.invoice_id = p_invoice_id
528: AND fo.set_of_books_id = g_sob_id
529: AND fo.payables_ia_paygroup = ai.pay_group_lookup_code;
530: EXCEPTION

Line 548: FROM Ap_Invoices ai, Po_Vendors pv

544:
545: BEGIN
546: SELECT ai.vendor_id, pv.vendor_name, ai.creation_date
547: INTO l_vendor_id, l_vendor_name, l_date
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

Line 585: FROM Ap_Invoices

581: ' has not been inserted '|| 'into the interagency table.');
582: BEGIN
583: SELECT pay_group_lookup_code
584: INTO x_paygroup
585: FROM Ap_Invoices
586: WHERE invoice_id = p_invoice_id;
587:
588: EXCEPTION
589: WHEN OTHERS THEN

Line 649: UPDATE Ap_Invoices

645: -- ------------------------------------------------------------------
646: PROCEDURE Update_WfStatus(p_invoice_id NUMBER) IS
647: l_module_name VARCHAR2(200) := g_module_name || 'Update_WfStatus';
648: BEGIN
649: UPDATE Ap_Invoices
650: SET wfapproval_status = 'NOT REQUIRED'
651: WHERE invoice_id = p_invoice_id;
652: EXCEPTION
653: WHEN OTHERS THEN