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.FUN_NET_ARAP_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 34: min_payment_num ap_payment_schedules_all.payment_num%TYPE,

30:
31: -- TYPE txnCurType IS REF CURSOR;
32: TYPE pymt_sch_rec IS RECORD
33: (invoice_id ap_invoices_all.invoice_id%TYPE,
34: min_payment_num ap_payment_schedules_all.payment_num%TYPE,
35: max_payment_num ap_payment_schedules_all.payment_num%TYPE);
36:
37: TYPE pymt_sch_tab IS TABLE OF pymt_sch_rec INDEX BY BINARY_INTEGER;
38:

Line 35: max_payment_num ap_payment_schedules_all.payment_num%TYPE);

31: -- TYPE txnCurType IS REF CURSOR;
32: TYPE pymt_sch_rec IS RECORD
33: (invoice_id ap_invoices_all.invoice_id%TYPE,
34: min_payment_num ap_payment_schedules_all.payment_num%TYPE,
35: max_payment_num ap_payment_schedules_all.payment_num%TYPE);
36:
37: TYPE pymt_sch_tab IS TABLE OF pymt_sch_rec INDEX BY BINARY_INTEGER;
38:
39: TYPE txnRecType IS RECORD

Line 544: ap_payment_schedules_all aps';

540: /* Build the from clause */
541: l_inv_from_clause :=
542: ' FROM ap_invoices_all api,
543: fun_net_suppliers_all fns,
544: ap_payment_schedules_all aps';
545: fun_net_util.Log_String(g_state_level,l_path,'FROM : '||l_inv_from_clause);
546:
547: /* Build where clause */
548: /* Do not select invoices that are on hold */

Line 787: TYPE payment_num IS TABLE OF ap_payment_schedules_all.payment_num%TYPE INDEX BY BINARY_INTEGER;

783: inv_rec InvCurTyp;
784:
785: TYPE amt_type IS TABLE OF fun_net_batches_all.total_netted_amt%TYPE INDEX BY BINARY_INTEGER;
786: TYPE trx_type IS TABLE OF fun_net_ar_txns_all.customer_trx_id%TYPE INDEX BY BINARY_INTEGER;
787: TYPE payment_num IS TABLE OF ap_payment_schedules_all.payment_num%TYPE INDEX BY BINARY_INTEGER;
788: TYPE inv_rank IS TABLE OF fun_net_ap_invs_all.ap_txn_rank%TYPE INDEX BY BINARY_INTEGER;
789: TYPE exchange_rate IS TABLE OF ap_invoices_all.exchange_rate%TYPE INDEX BY BINARY_INTEGER;
790: TYPE precision_tab IS TABLE OF fnd_currencies.precision%TYPE INDEX BY BINARY_INTEGER;
791: --l_invoice_id fun_net_ap_invs_all.invoice_id%TYPE;

Line 2429: UPDATE AP_PAYMENT_SCHEDULES_ALL

2425: FROM fun_net_batches_all
2426: WHERE batch_id = p_batch_id ;
2427:
2428:
2429: UPDATE AP_PAYMENT_SCHEDULES_ALL
2430: SET checkrun_id = NULL
2431: WHERE checkrun_id =l_checkrun_id
2432: AND org_id = l_org_id;
2433: IF SQL%FOUND THEN