DBA Data[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on AP_DBI_PKG

Line 4716: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;

4712: l_debug_loc VARCHAR2(30) := 'Update_Inv_Dists_To_Approved';
4713: l_curr_calling_sequence VARCHAR2(2000);
4714: l_debug_info VARCHAR2(1000);
4715:
4716: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
4717: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
4718:
4719: BEGIN
4720:

Line 4717: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;

4713: l_curr_calling_sequence VARCHAR2(2000);
4714: l_debug_info VARCHAR2(1000);
4715:
4716: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
4717: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
4718:
4719: BEGIN
4720:
4721:

Line 4765: AP_DBI_PKG.Maintain_DBI_Summary

4761: AND D.invoice_id = p_invoice_id;
4762: --Bug6963908
4763:
4764:
4765: AP_DBI_PKG.Maintain_DBI_Summary
4766: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
4767: p_operation => 'U',
4768: p_key_value1 => p_invoice_id,
4769: p_key_value_list => l_dbi_key_value_list1,

Line 5208: AP_DBI_PKG.Maintain_DBI_Summary

5204: initialize_invoice_holds
5205: (p_invoice_id => p_invoice_id,
5206: p_calling_sequence => l_curr_calling_sequence);
5207:
5208: AP_DBI_PKG.Maintain_DBI_Summary
5209: (p_table_name => 'AP_HOLDS',
5210: p_operation => 'U',
5211: p_key_value1 => p_invoice_id,
5212: p_calling_sequence => l_curr_calling_sequence);

Line 5357: AP_DBI_PKG.Maintain_DBI_Summary

5353: -------------------------------------------
5354:
5355: END IF;
5356:
5357: AP_DBI_PKG.Maintain_DBI_Summary
5358: (p_table_name => 'AP_HOLDS',
5359: p_operation => 'I',
5360: p_key_value1 => p_invoice_id,
5361: p_calling_sequence => l_curr_calling_sequence);

Line 6330: AP_DBI_PKG.Maintain_DBI_Summary

6326:
6327: CLOSE SCHEDULES;
6328:
6329: --Bug 4539462 DBI logging
6330: AP_DBI_PKG.Maintain_DBI_Summary
6331: (p_table_name => 'AP_INVOICES',
6332: p_operation => 'U',
6333: p_key_value1 => P_invoice_id,
6334: p_calling_sequence => l_current_calling_sequence);