DBA Data[Home] [Help]

APPS.AP_CANCEL_PKG dependencies on AP_DBI_PKG

Line 634: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;

630: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
631: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
632: Tax_Exception EXCEPTION;
633: --Bug 4539462 DBI logging
634: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
635:
636: -- Bug 6669048
637: l_tax_lines_count NUMBER := 0;
638: l_self_assess_tax_count NUMBER := 0 ; -- Bug 6694536

Line 789: AP_DBI_PKG.Maintain_DBI_Summary

785: ,inv_curr_gross_amount =0 --Bug5446999
786: WHERE invoice_id = P_invoice_id;
787:
788: --Bug 4539462 DBI logging
789: AP_DBI_PKG.Maintain_DBI_Summary
790: (p_table_name => 'AP_PAYMENT_SCHEDULES',
791: p_operation => 'U',
792: p_key_value1 => P_invoice_id,
793: p_calling_sequence => l_curr_calling_sequence);

Line 1098: AP_DBI_PKG.Maintain_DBI_Summary

1094: WHERE invoice_id = P_invoice_id
1095: AND NVL(discarded_flag, 'N' ) <> 'Y';
1096:
1097: --Bug 4539462 DBI logginG
1098: AP_DBI_PKG.Maintain_DBI_Summary
1099: (p_table_name => 'AP_INVOICES',
1100: p_operation => 'U',
1101: p_key_value1 => P_Invoice_Id,
1102: p_calling_sequence => l_curr_calling_sequence);

Line 1329: AP_DBI_PKG.Maintain_DBI_Summary

1325:
1326: l_success := TRUE;
1327:
1328: --Bug 4539462 DBI logging
1329: AP_DBI_PKG.Maintain_DBI_Summary
1330: (p_table_name => 'AP_INVOICES',
1331: p_operation => 'U',
1332: p_key_value1 => P_Invoice_id,
1333: p_calling_sequence => l_curr_calling_sequence);

Line 1335: AP_DBI_PKG.Maintain_DBI_Summary

1331: p_operation => 'U',
1332: p_key_value1 => P_Invoice_id,
1333: p_calling_sequence => l_curr_calling_sequence);
1334:
1335: AP_DBI_PKG.Maintain_DBI_Summary
1336: (p_table_name => 'AP_HOLDS',
1337: p_operation => 'U',
1338: p_key_value1 => P_Invoice_id,
1339: p_calling_sequence => l_curr_calling_sequence);