eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_RETAINAGE_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 510: FROM ap_payment_schedules_all

506: PROCEDURE Update_Payment_Schedules (x_invoice_id IN ap_invoices.invoice_id%type) AS
507:
508: CURSOR c_payment_schedules (c_invoice_id IN ap_invoices.invoice_id%type) IS
509: SELECT *
510: FROM ap_payment_schedules_all
511: WHERE invoice_id = c_invoice_id
512: FOR UPDATE OF amount_remaining;
513:
514: TYPE payNum IS TABLE OF ap_payment_schedules_all.payment_num%type INDEX BY PLS_INTEGER;

Line 514: TYPE payNum IS TABLE OF ap_payment_schedules_all.payment_num%type INDEX BY PLS_INTEGER;

510: FROM ap_payment_schedules_all
511: WHERE invoice_id = c_invoice_id
512: FOR UPDATE OF amount_remaining;
513:
514: TYPE payNum IS TABLE OF ap_payment_schedules_all.payment_num%type INDEX BY PLS_INTEGER;
515: TYPE paySchedUpd IS TABLE OF ap_payment_schedules_all%rowtype INDEX BY PLS_INTEGER;
516:
517: pay_num_tab payNum;
518: pay_sched_upd_tab paySchedUpd;

Line 515: TYPE paySchedUpd IS TABLE OF ap_payment_schedules_all%rowtype INDEX BY PLS_INTEGER;

511: WHERE invoice_id = c_invoice_id
512: FOR UPDATE OF amount_remaining;
513:
514: TYPE payNum IS TABLE OF ap_payment_schedules_all.payment_num%type INDEX BY PLS_INTEGER;
515: TYPE paySchedUpd IS TABLE OF ap_payment_schedules_all%rowtype INDEX BY PLS_INTEGER;
516:
517: pay_num_tab payNum;
518: pay_sched_upd_tab paySchedUpd;
519:

Line 520: l_inv_curr_gross_amount ap_payment_schedules_all.inv_curr_gross_amount%type;

516:
517: pay_num_tab payNum;
518: pay_sched_upd_tab paySchedUpd;
519:
520: l_inv_curr_gross_amount ap_payment_schedules_all.inv_curr_gross_amount%type;
521: l_invoice_amount ap_invoices_all.invoice_amount%type
522: := g_invoice_info.invoice_amount;
523: l_retained_amount ap_invoice_lines_all.retained_amount%type
524: := g_invoice_info.retained_amount;

Line 648: UPDATE ap_payment_schedules_all

644: -----------------------------------------------------------------
645:
646: FORALL i in pay_sched_upd_tab.first .. pay_sched_upd_tab.last
647:
648: UPDATE ap_payment_schedules_all
649: SET ROW = pay_sched_upd_tab(i)
650: WHERE invoice_id = x_invoice_id
651: AND payment_num = pay_num_tab(i);
652: