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:
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:
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,
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);
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);
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);