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 540: FROM ap_payment_schedules_all

536: PROCEDURE Update_Payment_Schedules (x_invoice_id IN ap_invoices.invoice_id%type) AS
537:
538: CURSOR c_payment_schedules (c_invoice_id IN ap_invoices.invoice_id%type) IS
539: SELECT *
540: FROM ap_payment_schedules_all
541: WHERE invoice_id = c_invoice_id
542: FOR UPDATE OF amount_remaining;
543:
544: TYPE payNum IS TABLE OF ap_payment_schedules_all.payment_num%type INDEX BY PLS_INTEGER;

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

540: FROM ap_payment_schedules_all
541: WHERE invoice_id = c_invoice_id
542: FOR UPDATE OF amount_remaining;
543:
544: TYPE payNum IS TABLE OF ap_payment_schedules_all.payment_num%type INDEX BY PLS_INTEGER;
545: TYPE paySchedUpd IS TABLE OF ap_payment_schedules_all%rowtype INDEX BY PLS_INTEGER;
546:
547: pay_num_tab payNum;
548: pay_sched_upd_tab paySchedUpd;

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

541: WHERE invoice_id = c_invoice_id
542: FOR UPDATE OF amount_remaining;
543:
544: TYPE payNum IS TABLE OF ap_payment_schedules_all.payment_num%type INDEX BY PLS_INTEGER;
545: TYPE paySchedUpd IS TABLE OF ap_payment_schedules_all%rowtype INDEX BY PLS_INTEGER;
546:
547: pay_num_tab payNum;
548: pay_sched_upd_tab paySchedUpd;
549:

Line 550: l_inv_curr_gross_amount ap_payment_schedules_all.inv_curr_gross_amount%type;

546:
547: pay_num_tab payNum;
548: pay_sched_upd_tab paySchedUpd;
549:
550: l_inv_curr_gross_amount ap_payment_schedules_all.inv_curr_gross_amount%type;
551: l_invoice_amount ap_invoices_all.invoice_amount%type
552: := g_invoice_info.invoice_amount;
553: l_retained_amount ap_invoice_lines_all.retained_amount%type
554: := g_invoice_info.retained_amount;

Line 693: UPDATE ap_payment_schedules_all

689: -----------------------------------------------------------------
690:
691: FORALL i in pay_sched_upd_tab.first .. pay_sched_upd_tab.last
692:
693: UPDATE ap_payment_schedules_all
694: SET ROW = pay_sched_upd_tab(i)
695: WHERE invoice_id = x_invoice_id
696: AND payment_num = pay_num_tab(i);
697: