APPS.AP_VOID_PKG dependencies on AP_INVOICES

Line 124: ap_invoices AI

120: AIP.global_attribute20,
121: AIP.global_attribute_category,
122: AIP.org_id /* Bug 4759178, added org_id */
123: FROM ap_invoice_payments AIP,
124: ap_invoices AI
125: WHERE AIP.check_id = P_Check_Id
126: AND AIP.invoice_id = AI.invoice_id
127: AND nvl(AIP.reversal_flag, 'N') <> 'Y';
128:

Line 201: FROM ap_invoices AI

197: WHERE AH.invoice_id = AIP.invoice_id
198: AND AH.hold_lookup_code = P_Hold_Code
199: AND AH.release_lookup_code IS NULL)
200: AND NOT EXISTS (SELECT 'Invoice is an Interest Invoice' -- 3240962
201: FROM ap_invoices AI
202: WHERE AI.invoice_id = AIP.invoice_id
203: AND AI.invoice_type_lookup_code = 'INTEREST');
204:
205: l_hold_tab hold_tab_type;

Line 289: -- Cause: The payment_status_flag in ap_invoices table was not being

285: -- Fix for bug 893626:
286: -- Problem: After voiding a payment, the form field inv_curr_amount_paid
287: -- was incorrectly showing the invoice amount instead of the amount paid
288: -- for that invoice.
289: -- Cause: The payment_status_flag in ap_invoices table was not being
290: -- set to 'N' after voiding the payment for an invoice.
291: -- Fix: By executing the ap_pay_update_payment_schedule procedure call
292: -- before the ap_pay_update_ap_invoices, the payment_status_flag that was
293: -- set in ap_payment_schedule is populated in ap_invoices.

Line 292: -- before the ap_pay_update_ap_invoices, the payment_status_flag that was

288: -- for that invoice.
289: -- Cause: The payment_status_flag in ap_invoices table was not being
290: -- set to 'N' after voiding the payment for an invoice.
291: -- Fix: By executing the ap_pay_update_payment_schedule procedure call
292: -- before the ap_pay_update_ap_invoices, the payment_status_flag that was
293: -- set in ap_payment_schedule is populated in ap_invoices.
294: ---------------------------------------------------------------------
295:
296: l_debug_info := 'Open c_payment_schedules cursor';

Line 293: -- set in ap_payment_schedule is populated in ap_invoices.

289: -- Cause: The payment_status_flag in ap_invoices table was not being
290: -- set to 'N' after voiding the payment for an invoice.
291: -- Fix: By executing the ap_pay_update_payment_schedule procedure call
292: -- before the ap_pay_update_ap_invoices, the payment_status_flag that was
293: -- set in ap_payment_schedule is populated in ap_invoices.
294: ---------------------------------------------------------------------
295:
296: l_debug_info := 'Open c_payment_schedules cursor';
297:

Line 341: -- Update AP_INVOICES paid by P_Check_Id

337: FETCH c_invoices INTO l_invoice_id;
338: EXIT WHEN c_invoices%NOTFOUND;
339:
340: -----------------------------------------------------------------
341: -- Update AP_INVOICES paid by P_Check_Id
342: -----------------------------------------------------------------
343:
344: AP_PAY_INVOICE_PKG.AP_PAY_UPDATE_AP_INVOICES (
345: l_invoice_id,

Line 344: AP_PAY_INVOICE_PKG.AP_PAY_UPDATE_AP_INVOICES (

340: -----------------------------------------------------------------
341: -- Update AP_INVOICES paid by P_Check_Id
342: -----------------------------------------------------------------
343:
344: AP_PAY_INVOICE_PKG.AP_PAY_UPDATE_AP_INVOICES (
345: l_invoice_id,
346: P_Check_Id,
347: NULL,
348: NULL,

Line 401: l_debug_info := 'Update ap_invoices for Interest invoice';

397: p_operation => 'U',
398: p_key_value_list => l_dbi_key_value_list2,
399: p_calling_sequence => l_curr_calling_sequence);
400:
401: l_debug_info := 'Update ap_invoices for Interest invoice';
402:
403: UPDATE ap_invoices_all AI
404: SET AI.description = 'VOID '||AI.description,
405: AI.invoice_amount = 0,

Line 403: UPDATE ap_invoices_all AI

399: p_calling_sequence => l_curr_calling_sequence);
400:
401: l_debug_info := 'Update ap_invoices for Interest invoice';
402:
403: UPDATE ap_invoices_all AI
404: SET AI.description = 'VOID '||AI.description,
405: AI.invoice_amount = 0,
406: AI.amount_paid = 0,
407: AI.invoice_distribution_total = 0,

Line 426: (p_table_name => 'AP_INVOICES',

422: END IF;
423:
424: --Bug 4539462 DBI logging
425: AP_DBI_PKG.Maintain_DBI_Summary
426: (p_table_name => 'AP_INVOICES',
427: p_operation => 'U',
428: p_key_value_list => l_dbi_key_value_list1,
429: p_calling_sequence => l_curr_calling_sequence);
430:

Line 788: FROM ap_invoices AI

784: WHERE AH.invoice_id = AIP.invoice_id
785: AND AH.hold_lookup_code = P_Hold_Code
786: AND AH.release_lookup_code IS NULL)
787: AND NOT EXISTS (SELECT 'Invoice is an Interest Invoice'
788: FROM ap_invoices AI
789: WHERE AI.invoice_id = AIP.invoice_id
790: AND AI.invoice_type_lookup_code = 'INTEREST');
791:
792: /* Bug 5169128 */