DBA Data[Home] [Help]

APPS.AP_DBI_PKG dependencies on AP_INVOICE_PAYMENTS

Line 324: FROM ap_invoice_payments aip,

320: /*Bug#8964576 Fixed the cursor */
321:
322: CURSOR invoice_payments_cur IS
323: SELECT aip.invoice_payment_id
324: FROM ap_invoice_payments aip,
325: ap_checks ac
326: WHERE aip.check_id = ac.check_id
327: AND ac.checkrun_name = p_checkrun_name;
328:

Line 390: ELSIF (p_key_table = 'AP_INVOICE_PAYMENTS_ALL') THEN

386: p_calling_sequence => l_curr_calling_sequence);
387: END LOOP;
388: CLOSE sched_cur;
389:
390: ELSIF (p_key_table = 'AP_INVOICE_PAYMENTS_ALL') THEN
391:
392: OPEN invoice_payments_cur;
393: LOOP
394: FETCH invoice_payments_cur

Line 399: (p_table_name => 'AP_INVOICE_PAYMENTS',

395: INTO l_invoice_pay_id;
396: EXIT WHEN invoice_payments_cur%NOTFOUND;
397:
398: AP_DBI_PKG.Maintain_DBI_Summary
399: (p_table_name => 'AP_INVOICE_PAYMENTS',
400: p_operation => 'I',
401: p_key_value1 => l_invoice_pay_id,
402: p_calling_sequence => l_curr_calling_sequence);
403: END LOOP;