238: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314
239: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314
240:
241: --Bug 2840203 DBI logging
242: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
243: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
244: l_dbi_key_value_list3 ap_dbi_pkg.r_dbi_key_value_arr;
245:
246: l_payment_id NUMBER;
239: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314
240:
241: --Bug 2840203 DBI logging
242: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
243: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
244: l_dbi_key_value_list3 ap_dbi_pkg.r_dbi_key_value_arr;
245:
246: l_payment_id NUMBER;
247: l_return_status VARCHAR2(10);
240:
241: --Bug 2840203 DBI logging
242: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
243: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
244: l_dbi_key_value_list3 ap_dbi_pkg.r_dbi_key_value_arr;
245:
246: l_payment_id NUMBER;
247: l_return_status VARCHAR2(10);
248: l_msg_count NUMBER;
391: RAISE INTERRUPT_VOID;
392: END IF;
393:
394: --Bug 4539462 DBI logging
395: AP_DBI_PKG.Maintain_DBI_Summary
396: (p_table_name => 'AP_PAYMENT_SCHEDULES',
397: p_operation => 'U',
398: p_key_value_list => l_dbi_key_value_list2,
399: p_calling_sequence => l_curr_calling_sequence);
421: RAISE INTERRUPT_VOID;
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);
570: Interest_Inv_Cur.type_1099,
571: Interest_Inv_Cur.income_tax_region);
572:
573: --Bug 4539462 DBI logging
574: AP_DBI_PKG.Maintain_DBI_Summary
575: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
576: p_operation => 'I',
577: p_key_value1 => Interest_Inv_Cur.invoice_id,
578: p_key_value2 => Interest_Inv_Cur.invoice_distribution_id,
841: END LOOP;
842:
843: /* bug 5169128 */
844: --Bug 4539462 DBI logging
845: AP_DBI_PKG.Maintain_DBI_Summary
846: (p_table_name => 'AP_HOLDS',
847: p_operation => 'I',
848: p_key_value_list => l_dbi_key_value_list3,
849: p_calling_sequence => l_curr_calling_sequence);