DBA Data[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on AP_DBI_PKG

Line 6239: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;

6235: l_debug_loc VARCHAR2(30) := 'Update_Inv_Dists_To_Approved';
6236: l_curr_calling_sequence VARCHAR2(2000);
6237: l_debug_info VARCHAR2(1000);
6238:
6239: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
6240: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
6241:
6242: BEGIN
6243:

Line 6240: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;

6236: l_curr_calling_sequence VARCHAR2(2000);
6237: l_debug_info VARCHAR2(1000);
6238:
6239: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
6240: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
6241:
6242: BEGIN
6243:
6244:

Line 6296: AP_DBI_PKG.Maintain_DBI_Summary

6292: AND D.invoice_id = p_invoice_id;
6293: --Bug6963908
6294:
6295:
6296: AP_DBI_PKG.Maintain_DBI_Summary
6297: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
6298: p_operation => 'U',
6299: p_key_value1 => p_invoice_id,
6300: p_key_value_list => l_dbi_key_value_list1,

Line 6997: AP_DBI_PKG.Maintain_DBI_Summary

6993: initialize_invoice_holds
6994: (p_invoice_id => p_invoice_id,
6995: p_calling_sequence => l_curr_calling_sequence);
6996:
6997: AP_DBI_PKG.Maintain_DBI_Summary
6998: (p_table_name => 'AP_HOLDS',
6999: p_operation => 'U',
7000: p_key_value1 => p_invoice_id,
7001: p_calling_sequence => l_curr_calling_sequence);

Line 7188: AP_DBI_PKG.Maintain_DBI_Summary

7184: -------------------------------------------
7185:
7186: END IF;
7187:
7188: AP_DBI_PKG.Maintain_DBI_Summary
7189: (p_table_name => 'AP_HOLDS',
7190: p_operation => 'I',
7191: p_key_value1 => p_invoice_id,
7192: p_calling_sequence => l_curr_calling_sequence);

Line 8307: AP_DBI_PKG.Maintain_DBI_Summary

8303:
8304: CLOSE SCHEDULES;
8305:
8306: --Bug 4539462 DBI logging
8307: AP_DBI_PKG.Maintain_DBI_Summary
8308: (p_table_name => 'AP_INVOICES',
8309: p_operation => 'U',
8310: p_key_value1 => P_invoice_id,
8311: p_calling_sequence => l_current_calling_sequence);