APPS.AP_DBI_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 43: IF p_table_name = 'AP_INVOICE_DISTRIBUTIONS' THEN

39: l_debug_info := 'element exists';
40: --loop through all invoice distribution ids
41: FOR uniq_values IN 1..p_key_value_list.count LOOP
42:
43: IF p_table_name = 'AP_INVOICE_DISTRIBUTIONS' THEN
44: --Occasionaly, the invoice_id cannot be determined in
45: --the transaction code.
46: l_debug_info := 'looping through elements';
47: IF p_key_value1 IS NULL then

Line 50: FROM ap_invoice_distributions

46: l_debug_info := 'looping through elements';
47: IF p_key_value1 IS NULL then
48: SELECT invoice_id
49: INTO l_key_value1
50: FROM ap_invoice_distributions
51: WHERE invoice_distribution_id =
52: p_key_value_list(uniq_values);
53: END IF;
54:

Line 202: IF p_table_name ='AP_INVOICE_DISTRIBUTIONS' THEN

198:
199: ELSE -- no values in list for all other situations
200:
201: IF p_key_value1 IS NULL then
202: IF p_table_name ='AP_INVOICE_DISTRIBUTIONS' THEN
203: SELECT invoice_id
204: INTO l_key_value1
205: FROM ap_invoice_distributions
206: WHERE invoice_distribution_id =

Line 205: FROM ap_invoice_distributions

201: IF p_key_value1 IS NULL then
202: IF p_table_name ='AP_INVOICE_DISTRIBUTIONS' THEN
203: SELECT invoice_id
204: INTO l_key_value1
205: FROM ap_invoice_distributions
206: WHERE invoice_distribution_id =
207: p_key_value2;
208: END IF;
209: END IF;

Line 304: ap_invoice_distributions aid

300:
301: CURSOR invoice_dist_cur IS
302: SELECT aid.invoice_distribution_id, aid.invoice_id
303: FROM ap_selected_invoices interest,
304: ap_invoice_distributions aid
305: WHERE interest.original_invoice_id is NOT NULL --Bug3293887
306: AND interest.checkrun_name = p_checkrun_name
307: AND aid.invoice_id = interest.invoice_id;
308:

Line 363: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

359: INTO l_invoice_dist_id,l_invoice_id;
360: EXIT WHEN invoice_dist_cur%NOTFOUND;
361:
362: AP_DBI_PKG.Maintain_DBI_Summary
363: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
364: p_operation => 'I',
365: p_key_value1 => l_invoice_id,
366: p_key_value2 => l_invoice_dist_id,
367: p_calling_sequence => l_curr_calling_sequence);