APPS.AP_DBI_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 107: ELSIF p_table_name = 'AP_PAYMENT_SCHEDULES' THEN

103: -1,
104: sysdate,
105: mod(to_number(to_char(trunc(sysdate), 'J')), 32)
106: );
107: ELSIF p_table_name = 'AP_PAYMENT_SCHEDULES' THEN
108:
109: IF p_key_value1 IS NULL THEN
110: /*Have a list of invoices whose payment_nums change*/
111: INSERT INTO AP_DBI_LOG(Table_Name,

Line 134: FROM AP_PAYMENT_SCHEDULES

130: sysdate,
131: -1,
132: sysdate,
133: mod(to_number(to_char(trunc(sysdate), 'J')), 32)
134: FROM AP_PAYMENT_SCHEDULES
135: WHERE invoice_id =p_key_value_list(uniq_values);
136: ELSE /*we have a list of payment_nums for one inv_id*/
137: INSERT INTO AP_DBI_LOG(Table_Name,
138: Operation_Flag,

Line 160: FROM AP_PAYMENT_SCHEDULES

156: sysdate,
157: -1,
158: sysdate,
159: mod(to_number(to_char(trunc(sysdate), 'J')), 32)
160: FROM AP_PAYMENT_SCHEDULES
161: WHERE invoice_id =p_key_value_list(uniq_values);
162: END IF;
163:
164: End IF;

Line 169: ELSIF p_table_name = 'AP_PAYMENT_SCHEDULES' and

165: END LOOP;
166:
167: --payment num was not available in the transaction code
168: --but all the payment_nums associated with the invoice were affected*/
169: ELSIF p_table_name = 'AP_PAYMENT_SCHEDULES' and
170: p_key_value2 is null THEN
171:
172:
173: INSERT INTO AP_DBI_LOG(Table_Name,

Line 196: FROM AP_PAYMENT_SCHEDULES

192: sysdate,
193: -1,
194: sysdate,
195: mod(to_number(to_char(trunc(sysdate), 'J')), 32)
196: FROM AP_PAYMENT_SCHEDULES
197: WHERE invoice_id = p_key_value1;
198:
199: ELSE -- no values in list for all other situations
200:

Line 312: ap_payment_schedules aps

308:
309: CURSOR sched_cur IS
310: SELECT aps.invoice_id, aps.payment_num
311: FROM ap_selected_invoices interest,
312: ap_payment_schedules aps
313: WHERE interest.original_invoice_id is NOT NULL --Bug3293887
314: AND interest.checkrun_name = p_checkrun_name
315: AND aps.invoice_id = interest.invoice_id;
316:

Line 378: (p_table_name => 'AP_PAYMENT_SCHEDULES',

374: INTO l_invoice_id, l_payment_num;
375: EXIT WHEN sched_cur%NOTFOUND;
376:
377: AP_DBI_PKG.Maintain_DBI_Summary
378: (p_table_name => 'AP_PAYMENT_SCHEDULES',
379: p_operation => 'I',
380: p_key_value1 => l_invoice_id,
381: p_key_value2 => l_payment_num,
382: p_calling_sequence => l_curr_calling_sequence);