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_BATCHES_ALL

Line 19: (batch_id fun_net_batches_all.batch_id%TYPE,

15:
16:
17: --Declare all required global variables
18: TYPE batch_rec IS RECORD
19: (batch_id fun_net_batches_all.batch_id%TYPE,
20: agreement_id fun_net_agreements_all.agreement_id%TYPE,
21: currency gl_ledgers.currency_code%TYPE);
22:
23: TYPE batch_table IS TABLE OF batch_rec INDEX BY BINARY_INTEGER;

Line 25: SUBTYPE batch_details_rec IS fun_net_batches_all%ROWTYPE;

21: currency gl_ledgers.currency_code%TYPE);
22:
23: TYPE batch_table IS TABLE OF batch_rec INDEX BY BINARY_INTEGER;
24:
25: SUBTYPE batch_details_rec IS fun_net_batches_all%ROWTYPE;
26:
27: g_batch_details batch_details_rec;
28: g_batch_list batch_table;
29: g_idx BINARY_INTEGER;

Line 74: g_batch_id fun_net_batches_all.batch_id%TYPE;

70: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
71: org_id fun_net_batches.org_id%TYPE
72: );
73:
74: g_batch_id fun_net_batches_all.batch_id%TYPE;
75: g_net_currency_rule fun_net_agreements_all.net_currency_rule_code%TYPE;
76: g_net_order_rule fun_net_agreements_all.net_order_rule_code%TYPE;
77: g_net_balance_rule fun_net_agreements_all.net_balance_rule_code%TYPE;
78: g_net_currency fun_net_agreements_all.net_currency_code%TYPE;

Line 157: FROM fun_net_batches_all

153: attribute18,
154: attribute19,
155: attribute20,
156: checkrun_id
157: FROM fun_net_batches_all
158: WHERE batch_id = g_batch_id;
159:
160: BEGIN
161:

Line 162: --Get all the batch details into global variables from the table fun_net_batches_all

158: WHERE batch_id = g_batch_id;
159:
160: BEGIN
161:
162: --Get all the batch details into global variables from the table fun_net_batches_all
163: OPEN c_get_batch_details;
164: FETCH c_get_batch_details
165: INTO g_batch_details.batch_id,
166: g_batch_details.object_version_number,

Line 367: fun_net_batches_all fnba

363: AND arm.payment_type_code = ''CREDIT_CARD'')
364: AND NOT EXISTS
365: (SELECT ''X''
366: FROM fun_net_ar_txns_all fnar,
367: fun_net_batches_all fnba
368: WHERE Fnar.customer_trx_id = rct.customer_trx_id
369: AND fnar.batch_id = fnba.batch_id
370: AND fnba.batch_status_code <> ''CANCELLED''
371: AND fnba.batch_status_code <> ''COMPLETE''

Line 577: fun_net_batches_all fnba

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''
581: AND fnba.batch_status_code <> ''COMPLETE''

Line 753: from FUN_NET_BATCHES_ALL

749: END IF;
750:
751: select checkrun_id
752: INTO l_checkrun_id
753: from FUN_NET_BATCHES_ALL
754: WHERE batch_id = p_batch_id;
755: -- Bug:8234111.
756: -- Update AP Payment Schedules with the Checkrun id
757: FOR i in 1..p_schd_tab.COUNT LOOP

Line 785: TYPE amt_type IS TABLE OF fun_net_batches_all.total_netted_amt%TYPE INDEX BY BINARY_INTEGER;

781:
782: TYPE InvCurTyp IS REF CURSOR;
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;

Line 848: from FUN_NET_BATCHES_ALL

844: END IF ;
845:
846: select checkrun_id
847: INTO l_checkrun_id
848: from FUN_NET_BATCHES_ALL
849: WHERE batch_id = g_batch_id;
850:
851: IF l_checkrun_id is NULL THEN
852: SELECT ap_inv_selection_criteria_s.nextval

Line 859: UPDATE FUN_NET_BATCHES_ALL

855: fun_net_util.Log_String(g_state_level,l_path,'l_checkrun_id :'||l_checkrun_id);
856:
857: -- Update Netting Batch with the Checkrun id
858:
859: UPDATE FUN_NET_BATCHES_ALL
860: SET checkrun_id = l_checkrun_id
861: WHERE batch_id = g_batch_id;
862: fun_net_util.Log_String(g_state_level,l_path,'Batch updated');
863: END IF;

Line 1144: l_amt_to_net fun_net_batches_all.total_netted_amt%TYPE;

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);
1147: l_path varchar2(100);
1148: BEGIN

Line 1179: /*UPDATE fun_net_batches_all

1175: update_net_balances(l_sql_stmt,l_amt_to_net,'AR');
1176: END IF;
1177:
1178: fun_net_util.Log_String(g_state_level,l_path,'Total Netted Amount :'||l_amt_to_net);
1179: /*UPDATE fun_net_batches_all
1180: SET total_netted_amt = l_amt_to_net
1181: WHERE batch_id = g_batch_id; */
1182: p_amt_to_net := l_amt_to_net;
1183: p_status_flag := FND_API.G_TRUE;

Line 1231: /*UPDATE fun_net_batches_all

1227: IF nvl(p_ap_bal,0) = 0 OR nvl(p_ar_bal,0) = 0 THEN
1228:
1229: /* Error out the Batch to say netting cannot continue and set the Batch to Error and put message in the log*/
1230: --ERROR MESSAGE : 'Netting cannot be performed as the Outstanding balance is zero'
1231: /*UPDATE fun_net_batches_all
1232: SET batch_status_code = 'ERROR'
1233: WHERE batch_id = g_batch_id; */
1234:
1235: p_status_flag := FND_API.G_FALSE;

Line 1254: l_batch_id fun_net_batches_all.batch_id%TYPE;

1250: END validate_AP_AR_balances;
1251:
1252:
1253: PROCEDURE insert_batch_record(p_currency_code VARCHAR2) IS
1254: l_batch_id fun_net_batches_all.batch_id%TYPE;
1255: l_path varchar2(200);
1256: BEGIN
1257:
1258: l_path := g_path||'insert_batch_record';

Line 1264: INSERT INTO FUN_NET_BATCHES_ALL

1260: SELECT fun_net_batches_s.NEXTVAL
1261: INTO g_batch_id
1262: FROM DUAL;
1263:
1264: INSERT INTO FUN_NET_BATCHES_ALL
1265: (batch_id,
1266: object_version_number,
1267: agreement_id,
1268: batch_name,

Line 1408: l_conv_rate fun_net_batches_all.exchange_rate_type%TYPE;

1404: AND fnart.batch_id = g_batch_id;
1405:
1406: l_count NUMBER;
1407: l_exc_rate NUMBER;
1408: l_conv_rate fun_net_batches_all.exchange_rate_type%TYPE;
1409: l_path VARCHAR2(100);
1410: l_msg_count NUMBER;
1411: l_msg_data VARCHAR2(2000);
1412:

Line 1483: TYPE amt_type IS TABLE OF fun_net_batches_all.total_netted_amt%TYPE;

1479: PROCEDURE update_net_balances(p_sql_stmt VARCHAR2,
1480: p_amt_to_net NUMBER,
1481: p_appln VARCHAR2) IS
1482:
1483: TYPE amt_type IS TABLE OF fun_net_batches_all.total_netted_amt%TYPE;
1484: TYPE trx_type IS TABLE OF fun_net_ar_txns_all.customer_trx_id%TYPE;
1485: l_open_amt amt_type;
1486: l_exc_rate NUMBER;
1487: l_net_amt amt_type;

Line 1491: l_amt_to_net fun_net_batches_all.total_netted_amt%TYPE;

1487: l_net_amt amt_type;
1488: l_trx_id trx_type;
1489: l_inv_curr_open_amt amt_type;
1490: l_inv_curr_net_amt amt_type;
1491: l_amt_to_net fun_net_batches_all.total_netted_amt%TYPE;
1492: l_inv_currency fnd_currencies.currency_code%TYPE;
1493: l_precision fnd_currencies.precision%TYPE;
1494:
1495: TYPE tnxCurTyp IS REF CURSOR;

Line 1630: l_amt_to_net fun_net_batches_all.total_netted_amt%TYPE;

1626: l_return_status VARCHAR2(1);
1627: l_msg_count NUMBER;
1628: l_msg_data VARCHAR2(2000);
1629: l_path VARCHAR2(100);
1630: l_amt_to_net fun_net_batches_all.total_netted_amt%TYPE;
1631: l_status_flag VARCHAR2(1);
1632: batch_status_flag BOOLEAN;
1633:
1634: CURSOR c_agreement_cur IS

Line 1789: UPDATE fun_net_batches_all

1785: calculate_AP_AR_balances(l_amt_to_net,l_status_flag);
1786:
1787: /* Set the status of the Batch to Selected */
1788: IF l_status_flag = FND_API.G_TRUE THEN
1789: UPDATE fun_net_batches_all
1790: SET batch_status_code = 'SELECTED',
1791: batch_currency = g_batch_list(i).currency,
1792: agreement_id = g_batch_list(i).agreement_id,
1793: total_netted_amt = l_amt_to_net

Line 1797: UPDATE fun_net_batches_all

1793: total_netted_amt = l_amt_to_net
1794: WHERE batch_id = g_batch_id;
1795: g_batch_details.batch_status_code := 'SELECTED';
1796: ELSE
1797: UPDATE fun_net_batches_all
1798: SET batch_status_code = 'ERROR',
1799: batch_currency = g_batch_list(i).currency,
1800: agreement_id = g_batch_list(i).agreement_id,
1801: total_netted_amt = l_amt_to_net

Line 1875: l_batch_currency fun_net_batches_all.batch_currency%type;

1871:
1872: PROCEDURE Validate_multi_currency_flag IS
1873: l_count number(3);
1874: l_flag varchar2(3);
1875: l_batch_currency fun_net_batches_all.batch_currency%type;
1876:
1877:
1878: BEGIN
1879: l_count:=0;

Line 1887: from fun_net_batches_all

1883:
1884: if(g_net_currency_rule='SINGLE_CURRENCY') then
1885: begin
1886: select batch_currency into l_batch_currency
1887: from fun_net_batches_all
1888: where batch_id = g_batch_id;
1889: exception
1890: when others then
1891: RAISE FND_API.G_EXC_ERROR;

Line 1956: l_batch_status fun_net_batches_all.settlement_date%TYPE;

1952: l_TP_approver fun_net_agreements_all.approver_name%TYPE;
1953: l_return_status VARCHAR2(1);
1954: l_msg_count NUMBER;
1955: l_msg_data VARCHAR2(2000);
1956: l_batch_status fun_net_batches_all.settlement_date%TYPE;
1957: l_Request_id fnd_concurrent_requests.request_id%TYPE;
1958: l_batch_status_flag BOOLEAN;
1959:
1960:

Line 2425: FROM fun_net_batches_all

2421: -- Netting Batch
2422:
2423: SELECT checkrun_id , org_id
2424: INTO l_checkrun_id , l_org_id
2425: FROM fun_net_batches_all
2426: WHERE batch_id = p_batch_id ;
2427:
2428:
2429: UPDATE AP_PAYMENT_SCHEDULES_ALL

Line 2442: UPDATE FUN_NET_BATCHES_ALL

2438: RETURN;
2439: END IF;
2440:
2441:
2442: UPDATE FUN_NET_BATCHES_ALL
2443: SET checkrun_id = NULL
2444: WHERE batch_id = p_batch_id ;
2445: IF SQL%FOUND THEN
2446: COMMIT;

Line 2467: x_exchange_rate fun_net_batches_all.exchange_rate%TYPE;

2463: FUNCTION Derive_Net_Exchg_Rate(x_from_currency IN VARCHAR2,
2464: x_to_currency IN VARCHAR2)
2465: RETURN NUMBER
2466: IS
2467: x_exchange_rate fun_net_batches_all.exchange_rate%TYPE;
2468: l_exchange_rate_type fun_net_batches_all.exchange_rate_type%TYPE;
2469:
2470: l_path varchar2(100);
2471: BEGIN

Line 2468: l_exchange_rate_type fun_net_batches_all.exchange_rate_type%TYPE;

2464: x_to_currency IN VARCHAR2)
2465: RETURN NUMBER
2466: IS
2467: x_exchange_rate fun_net_batches_all.exchange_rate%TYPE;
2468: l_exchange_rate_type fun_net_batches_all.exchange_rate_type%TYPE;
2469:
2470: l_path varchar2(100);
2471: BEGIN
2472: l_path := g_path || 'Derive net exchange';

Line 3352: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;

3348: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3349: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3350: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3351: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3352: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;
3353: l_original_amt ra_customer_trx_lines.extended_amount%TYPE;
3354: l_trans_to_func_rate fun_net_batches_all.exchange_rate%TYPE;
3355: l_func_to_trans_rate fun_net_batches_all.exchange_rate%TYPE;
3356: l_return_status VARCHAR2(1);

Line 3354: l_trans_to_func_rate fun_net_batches_all.exchange_rate%TYPE;

3350: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3351: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3352: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;
3353: l_original_amt ra_customer_trx_lines.extended_amount%TYPE;
3354: l_trans_to_func_rate fun_net_batches_all.exchange_rate%TYPE;
3355: l_func_to_trans_rate fun_net_batches_all.exchange_rate%TYPE;
3356: l_return_status VARCHAR2(1);
3357:
3358: l_exchange_rate_type varchar2(20);

Line 3355: l_func_to_trans_rate fun_net_batches_all.exchange_rate%TYPE;

3351: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3352: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;
3353: l_original_amt ra_customer_trx_lines.extended_amount%TYPE;
3354: l_trans_to_func_rate fun_net_batches_all.exchange_rate%TYPE;
3355: l_func_to_trans_rate fun_net_batches_all.exchange_rate%TYPE;
3356: l_return_status VARCHAR2(1);
3357:
3358: l_exchange_rate_type varchar2(20);
3359: l_exchange_rate_date fun_net_batches.settlement_date%TYPE;

Line 3958: l_batch_status fun_net_batches_all.settlement_date%TYPE;

3954:
3955: l_schd_tab pymt_sch_tab;
3956: l_status_flag VARCHAR2(1);
3957: l_return_status VARCHAR2(1);
3958: l_batch_status fun_net_batches_all.settlement_date%TYPE;
3959: l_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
3960: l_bank_acct_name ce_bank_accounts.bank_account_name%TYPE;
3961: l_bank_acct_num ce_bank_accounts.bank_account_num%TYPE;
3962: l_le_id xle_entity_profiles.legal_entity_id%TYPE;