APPS.FUN_NET_ARAP_PKG dependencies on AP_INVOICES_ALL

Line 33: (invoice_id ap_invoices_all.invoice_id%TYPE,

29: g_idx BINARY_INTEGER;
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;

Line 542: ' FROM ap_invoices_all api,

538: fun_net_util.Log_String(g_state_level,l_path,'SELECT : '||l_inv_select_clause);
539:
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:

Line 789: TYPE exchange_rate IS TABLE OF ap_invoices_all.exchange_rate%TYPE INDEX BY BINARY_INTEGER;

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;
792: --l_invoice_amt fun_net_ap_invs_all.invoice_amt%TYPE;
793: --l_open_amt fun_net_ap_invs_all.open_amt%TYPE;

Line 1397: FROM ap_invoices_all api, fun_net_ap_invs_all fnapi

1393: PROCEDURE validate_exch_rate (p_status_flag OUT NOCOPY VARCHAR2) IS
1394:
1395: CURSOR trx_curr_cur IS
1396: SELECT INVOICE_CURRENCY_CODE
1397: FROM ap_invoices_all api, fun_net_ap_invs_all fnapi
1398: WHERE api.invoice_id = fnapi.invoice_id
1399: AND fnapi.batch_id = g_batch_id
1400: UNION
1401: SELECT INVOICE_CURRENCY_CODE

Line 1531: FROM ap_invoices_all api, fnd_currencies fc

1527:
1528:
1529: SELECT fc.currency_code,fc.precision
1530: INTO l_inv_currency,l_precision
1531: FROM ap_invoices_all api, fnd_currencies fc
1532: WHERE api.invoice_id = l_trx_id(i)
1533: AND api.invoice_currency_code = fc.currency_code;
1534:
1535: l_exc_rate := Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);

Line 2592: TYPE party_type IS TABLE OF ap_invoices_all.party_id%TYPE INDEX BY BINARY_INTEGER;

2588: TYPE vendor_site_type IS TABLE OF po_vendor_sites_all.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;
2589: TYPE currency_type IS TABLE OF fnd_currencies.currency_code%TYPE INDEX BY BINARY_INTEGER;
2590: TYPE ap_check_amt_type IS TABLE OF ap_checks.amount%TYPE INDEX BY BINARY_INTEGER;
2591: TYPE ap_invoice_type IS TABLE OF ap_invoices.invoice_id%TYPE INDEX BY BINARY_INTEGER;
2592: TYPE party_type IS TABLE OF ap_invoices_all.party_id%TYPE INDEX BY BINARY_INTEGER;
2593: TYPE party_site_type IS TABLE OF ap_invoices_all.party_site_id%TYPE INDEX BY BINARY_INTEGER;
2594:
2595: ap_check_amt_list ap_check_amt_type;
2596: ap_check_base_amt_list ap_check_amt_type;

Line 2593: TYPE party_site_type IS TABLE OF ap_invoices_all.party_site_id%TYPE INDEX BY BINARY_INTEGER;

2589: TYPE currency_type IS TABLE OF fnd_currencies.currency_code%TYPE INDEX BY BINARY_INTEGER;
2590: TYPE ap_check_amt_type IS TABLE OF ap_checks.amount%TYPE INDEX BY BINARY_INTEGER;
2591: TYPE ap_invoice_type IS TABLE OF ap_invoices.invoice_id%TYPE INDEX BY BINARY_INTEGER;
2592: TYPE party_type IS TABLE OF ap_invoices_all.party_id%TYPE INDEX BY BINARY_INTEGER;
2593: TYPE party_site_type IS TABLE OF ap_invoices_all.party_site_id%TYPE INDEX BY BINARY_INTEGER;
2594:
2595: ap_check_amt_list ap_check_amt_type;
2596: ap_check_base_amt_list ap_check_amt_type;
2597: vendor_list vendor_type;