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 FUN_NET_AP_INVS

Line 576: FROM fun_net_ap_invs_all fnap,

572: AND TRUNC(aps.due_date) BETWEEN TRUNC(:v_agr_start_date)
573: AND TRUNC(:v_agr_end_date)
574: AND NOT EXISTS
575: (SELECT ''X''
576: FROM fun_net_ap_invs_all fnap,
577: fun_net_batches_all fnba
578: WHERE fnap.invoice_id = api.invoice_id
579: AND fnap.batch_id = fnba.batch_id
580: AND fnba.batch_status_code <> ''CANCELLED''

Line 788: TYPE inv_rank IS TABLE OF fun_net_ap_invs_all.ap_txn_rank%TYPE INDEX BY BINARY_INTEGER;

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

Line 791: --l_invoice_id fun_net_ap_invs_all.invoice_id%TYPE;

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;
794: --l_inv_curr_open_amt fun_net_ap_invs_all.inv_curr_open_amt%TYPE;
795: l_invoice_id trx_type;

Line 792: --l_invoice_amt fun_net_ap_invs_all.invoice_amt%TYPE;

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;
794: --l_inv_curr_open_amt fun_net_ap_invs_all.inv_curr_open_amt%TYPE;
795: l_invoice_id trx_type;
796: l_invoice_amt amt_type;

Line 793: --l_open_amt fun_net_ap_invs_all.open_amt%TYPE;

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;
794: --l_inv_curr_open_amt fun_net_ap_invs_all.inv_curr_open_amt%TYPE;
795: l_invoice_id trx_type;
796: l_invoice_amt amt_type;
797: l_open_amt amt_type;

Line 794: --l_inv_curr_open_amt fun_net_ap_invs_all.inv_curr_open_amt%TYPE;

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;
794: --l_inv_curr_open_amt fun_net_ap_invs_all.inv_curr_open_amt%TYPE;
795: l_invoice_id trx_type;
796: l_invoice_amt amt_type;
797: l_open_amt amt_type;
798: l_inv_curr_open_amt amt_type;

Line 903: INSERT INTO fun_net_ap_invs_all

899: --EXIT WHEN inv_rec%NOTFOUND;
900: --l_inv_rank(i) := i;
901: --fun_net_util.Log_String(g_state_level,l_path,'Invoice ID:'||l_invoice_id);
902:
903: INSERT INTO fun_net_ap_invs_all
904: (batch_id,
905: invoice_id,
906: object_version_number,
907: ap_txn_rank,

Line 974: INSERT INTO fun_net_ap_invs_all

970: --EXIT WHEN inv_rec%NOTFOUND;
971: --l_inv_rank := l_inv_rank + 1;
972: --fun_net_util.Log_String(g_state_level,l_path,'Invoice ID:'||l_invoice_id);
973:
974: INSERT INTO fun_net_ap_invs_all
975: (batch_id,
976: invoice_id,
977: object_version_number,
978: ap_txn_rank,

Line 1142: l_ap_bal fun_net_ap_invs_all.open_amt%TYPE;

1138: END insert_transactions;
1139:
1140: PROCEDURE calculate_AP_AR_balances(p_amt_to_net OUT NOCOPY NUMBER,
1141: p_status_flag OUT NOCOPY VARCHAR2) IS
1142: l_ap_bal fun_net_ap_invs_all.open_amt%TYPE;
1143: l_ar_bal fun_net_ar_txns_all.open_amt%TYPE;
1144: l_amt_to_net fun_net_batches_all.total_netted_amt%TYPE;
1145: l_status_flag VARCHAR2(1);
1146: l_sql_stmt VARCHAR2(2000);

Line 1163: l_sql_stmt := 'SELECT open_amt,invoice_id,0,inv_curr_open_amt,0 FROM fun_net_ap_invs_all WHERE batch_id = :v_batch_id ORDER BY ap_txn_rank';

1159: txn_curr_net_amt = txn_curr_open_amt
1160: WHERE batch_id = g_batch_id;
1161:
1162: /*Order the transactions by rank as the tnxs with a higher rank should be netted first */
1163: l_sql_stmt := 'SELECT open_amt,invoice_id,0,inv_curr_open_amt,0 FROM fun_net_ap_invs_all WHERE batch_id = :v_batch_id ORDER BY ap_txn_rank';
1164: update_net_balances(l_sql_stmt,l_amt_to_net,'AP');
1165: ELSIF l_ar_bal > l_ap_bal THEN
1166: fun_net_util.Log_String(g_state_level,l_path,'AR Balance > AP Balance');
1167: l_amt_to_net := l_ap_bal;

Line 1169: UPDATE fun_net_ap_invs_all

1165: ELSIF l_ar_bal > l_ap_bal THEN
1166: fun_net_util.Log_String(g_state_level,l_path,'AR Balance > AP Balance');
1167: l_amt_to_net := l_ap_bal;
1168: /* As the AP Bal = Total Net amount , update the net amount for each AP tnx with the open balance of that tnx */
1169: UPDATE fun_net_ap_invs_all
1170: SET netted_amt = open_amt,
1171: inv_curr_net_amt = inv_curr_open_amt
1172: WHERE batch_id = g_batch_id;
1173:

Line 1208: FROM fun_net_ap_invs_all

1204: WHERE batch_id = g_batch_id;
1205:
1206: CURSOR c_get_ap_open_amount IS
1207: SELECT SUM (open_amt)
1208: FROM fun_net_ap_invs_all
1209: WHERE batch_id = g_batch_id;
1210:
1211: l_path varchar2(100);
1212: BEGIN

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 1570: UPDATE fun_net_ap_invs_all

1566: END LOOP;
1567:
1568: IF p_appln = 'AP' THEN
1569: FORALL i IN 1..l_trx_id.COUNT
1570: UPDATE fun_net_ap_invs_all
1571: SET netted_amt = l_net_amt(i),
1572: inv_curr_net_amt = l_inv_curr_net_amt(i)
1573: WHERE batch_id = g_batch_id
1574: AND invoice_id = l_trx_id(i);

Line 1949: l_ap_bal fun_net_ap_invs_all.open_amt%TYPE;

1945: x_msg_data OUT NOCOPY VARCHAR2,
1946: -- ***** Netting batch input parameters *****
1947: p_batch_id IN NUMBER) IS
1948:
1949: l_ap_bal fun_net_ap_invs_all.open_amt%TYPE;
1950: l_ar_bal fun_net_ar_txns_all.open_amt%TYPE;
1951: l_status_flag VARCHAR2(1);
1952: l_TP_approver fun_net_agreements_all.approver_name%TYPE;
1953: l_return_status VARCHAR2(1);

Line 2632: FROM fun_net_ap_invs finv,

2628: vendor_site_list,
2629: party_list,
2630: party_site_list,
2631: currency_list
2632: FROM fun_net_ap_invs finv,
2633: ap_invoices inv
2634: WHERE inv.invoice_id = finv.invoice_id
2635: AND finv.batch_id = g_batch_details.batch_id
2636: AND finv.inv_curr_net_amt <> 0

Line 2755: fun_net_ap_invs finv,

2751: BULK COLLECT INTO
2752: ap_payment_info_tab
2753: FROM
2754: ap_invoices inv,
2755: fun_net_ap_invs finv,
2756: ap_payment_schedules apps
2757: WHERE finv.invoice_id = inv.invoice_id
2758: AND apps.invoice_id = inv.invoice_id
2759: AND apps.checkrun_id = g_batch_details.checkrun_id

Line 2870: /* Update FUN_NET_AP_INVS all with the check Id */

2866: RETURN;
2867: END IF;
2868:
2869:
2870: /* Update FUN_NET_AP_INVS all with the check Id */
2871:
2872: BEGIN
2873: FORALL k IN ap_invoice.FIRST..ap_invoice.LAST
2874:

Line 2875: UPDATE FUN_NET_AP_INVS

2871:
2872: BEGIN
2873: FORALL k IN ap_invoice.FIRST..ap_invoice.LAST
2874:
2875: UPDATE FUN_NET_AP_INVS
2876: SET check_id = l_check_id
2877: WHERE batch_id = g_batch_id
2878: AND inv_curr_net_amt <> 0
2879: AND invoice_id = ap_invoice(k);