DBA Data[Home] [Help]

APPS.AP_CANCEL_PKG dependencies on AP_DBI_PKG

Line 621: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;

617: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
618: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
619: Tax_Exception EXCEPTION;
620: --Bug 4539462 DBI logging
621: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
622:
623: -- Bug 6669048
624: l_tax_lines_count NUMBER := 0;
625: l_self_assess_tax_count NUMBER := 0 ; -- Bug 6694536

Line 718: AP_DBI_PKG.Maintain_DBI_Summary

714: ,inv_curr_gross_amount =0 --Bug5446999
715: WHERE invoice_id = P_invoice_id;
716:
717: --Bug 4539462 DBI logging
718: AP_DBI_PKG.Maintain_DBI_Summary
719: (p_table_name => 'AP_PAYMENT_SCHEDULES',
720: p_operation => 'U',
721: p_key_value1 => P_invoice_id,
722: p_calling_sequence => l_curr_calling_sequence);

Line 921: AP_DBI_PKG.Maintain_DBI_Summary

917: WHERE invoice_id = P_invoice_id
918: AND NVL(discarded_flag, 'N' ) <> 'Y';
919:
920: --Bug 4539462 DBI logginG
921: AP_DBI_PKG.Maintain_DBI_Summary
922: (p_table_name => 'AP_INVOICES',
923: p_operation => 'U',
924: p_key_value1 => P_Invoice_Id,
925: p_calling_sequence => l_curr_calling_sequence);

Line 1169: AP_DBI_PKG.Maintain_DBI_Summary

1165:
1166: l_success := TRUE;
1167:
1168: --Bug 4539462 DBI logging
1169: AP_DBI_PKG.Maintain_DBI_Summary
1170: (p_table_name => 'AP_INVOICES',
1171: p_operation => 'U',
1172: p_key_value1 => P_Invoice_id,
1173: p_calling_sequence => l_curr_calling_sequence);

Line 1175: AP_DBI_PKG.Maintain_DBI_Summary

1171: p_operation => 'U',
1172: p_key_value1 => P_Invoice_id,
1173: p_calling_sequence => l_curr_calling_sequence);
1174:
1175: AP_DBI_PKG.Maintain_DBI_Summary
1176: (p_table_name => 'AP_HOLDS',
1177: p_operation => 'U',
1178: p_key_value1 => P_Invoice_id,
1179: p_calling_sequence => l_curr_calling_sequence);