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_AGREEMENTS

Line 15: agreement_id fun_net_agreements_all.agreement_id%TYPE,

11: --===========================FND_LOG.END=======================================
12: --Declare all required global variables
13: TYPE batch_rec IS RECORD
14: (batch_id fun_net_batches_all.batch_id%TYPE,
15: agreement_id fun_net_agreements_all.agreement_id%TYPE,
16: currency gl_ledgers.currency_code%TYPE);
17: TYPE batch_table IS TABLE OF batch_rec INDEX BY BINARY_INTEGER;
18: SUBTYPE batch_details_rec IS fun_net_batches_all%ROWTYPE;
19: g_batch_details batch_details_rec;

Line 55: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,

51: receipt_date ar_cash_receipts.receipt_date%TYPE,
52: gl_date ar_cash_receipts.receipt_date%TYPE,
53: customer_id hz_cust_accounts.cust_account_id%TYPE,
54: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
55: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,
56: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
57: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE ,
58: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
59: org_id fun_net_batches.org_id%TYPE

Line 62: g_net_currency_rule fun_net_agreements_all.net_currency_rule_code%TYPE;

58: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
59: org_id fun_net_batches.org_id%TYPE
60: );
61: g_batch_id fun_net_batches_all.batch_id%TYPE;
62: g_net_currency_rule fun_net_agreements_all.net_currency_rule_code%TYPE;
63: g_net_order_rule fun_net_agreements_all.net_order_rule_code%TYPE;
64: g_net_balance_rule fun_net_agreements_all.net_balance_rule_code%TYPE;
65: g_net_currency fun_net_agreements_all.net_currency_code%TYPE;
66: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;

Line 63: g_net_order_rule fun_net_agreements_all.net_order_rule_code%TYPE;

59: org_id fun_net_batches.org_id%TYPE
60: );
61: g_batch_id fun_net_batches_all.batch_id%TYPE;
62: g_net_currency_rule fun_net_agreements_all.net_currency_rule_code%TYPE;
63: g_net_order_rule fun_net_agreements_all.net_order_rule_code%TYPE;
64: g_net_balance_rule fun_net_agreements_all.net_balance_rule_code%TYPE;
65: g_net_currency fun_net_agreements_all.net_currency_code%TYPE;
66: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
67: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;

Line 64: g_net_balance_rule fun_net_agreements_all.net_balance_rule_code%TYPE;

60: );
61: g_batch_id fun_net_batches_all.batch_id%TYPE;
62: g_net_currency_rule fun_net_agreements_all.net_currency_rule_code%TYPE;
63: g_net_order_rule fun_net_agreements_all.net_order_rule_code%TYPE;
64: g_net_balance_rule fun_net_agreements_all.net_balance_rule_code%TYPE;
65: g_net_currency fun_net_agreements_all.net_currency_code%TYPE;
66: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
67: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
68: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;

Line 65: g_net_currency fun_net_agreements_all.net_currency_code%TYPE;

61: g_batch_id fun_net_batches_all.batch_id%TYPE;
62: g_net_currency_rule fun_net_agreements_all.net_currency_rule_code%TYPE;
63: g_net_order_rule fun_net_agreements_all.net_order_rule_code%TYPE;
64: g_net_balance_rule fun_net_agreements_all.net_balance_rule_code%TYPE;
65: g_net_currency fun_net_agreements_all.net_currency_code%TYPE;
66: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
67: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
68: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
69: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;

Line 66: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;

62: g_net_currency_rule fun_net_agreements_all.net_currency_rule_code%TYPE;
63: g_net_order_rule fun_net_agreements_all.net_order_rule_code%TYPE;
64: g_net_balance_rule fun_net_agreements_all.net_balance_rule_code%TYPE;
65: g_net_currency fun_net_agreements_all.net_currency_code%TYPE;
66: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
67: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
68: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
69: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
70: g_func_currency gl_ledgers.currency_code%TYPE;

Line 67: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;

63: g_net_order_rule fun_net_agreements_all.net_order_rule_code%TYPE;
64: g_net_balance_rule fun_net_agreements_all.net_balance_rule_code%TYPE;
65: g_net_currency fun_net_agreements_all.net_currency_code%TYPE;
66: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
67: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
68: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
69: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
70: g_func_currency gl_ledgers.currency_code%TYPE;
71: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;

Line 68: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;

64: g_net_balance_rule fun_net_agreements_all.net_balance_rule_code%TYPE;
65: g_net_currency fun_net_agreements_all.net_currency_code%TYPE;
66: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
67: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
68: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
69: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
70: g_func_currency gl_ledgers.currency_code%TYPE;
71: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;
72: g_days_past_due fun_net_agreements_all.days_past_due%TYPE;

Line 69: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;

65: g_net_currency fun_net_agreements_all.net_currency_code%TYPE;
66: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
67: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
68: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
69: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
70: g_func_currency gl_ledgers.currency_code%TYPE;
71: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;
72: g_days_past_due fun_net_agreements_all.days_past_due%TYPE;
73: g_sel_past_due_flag fun_net_agreements_all.sel_rec_past_due_txns_flag%TYPE;

Line 71: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;

67: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
68: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
69: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
70: g_func_currency gl_ledgers.currency_code%TYPE;
71: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;
72: g_days_past_due fun_net_agreements_all.days_past_due%TYPE;
73: g_sel_past_due_flag fun_net_agreements_all.sel_rec_past_due_txns_flag%TYPE;
74: g_agreement_count NUMBER;
75: g_currency_count NUMBER;

Line 72: g_days_past_due fun_net_agreements_all.days_past_due%TYPE;

68: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
69: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
70: g_func_currency gl_ledgers.currency_code%TYPE;
71: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;
72: g_days_past_due fun_net_agreements_all.days_past_due%TYPE;
73: g_sel_past_due_flag fun_net_agreements_all.sel_rec_past_due_txns_flag%TYPE;
74: g_agreement_count NUMBER;
75: g_currency_count NUMBER;
76: g_user_id NUMBER;

Line 73: g_sel_past_due_flag fun_net_agreements_all.sel_rec_past_due_txns_flag%TYPE;

69: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
70: g_func_currency gl_ledgers.currency_code%TYPE;
71: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;
72: g_days_past_due fun_net_agreements_all.days_past_due%TYPE;
73: g_sel_past_due_flag fun_net_agreements_all.sel_rec_past_due_txns_flag%TYPE;
74: g_agreement_count NUMBER;
75: g_currency_count NUMBER;
76: g_user_id NUMBER;
77: g_login_id NUMBER;

Line 185: FUN_NET_AGREEMENTS_ALL FNA

181: fun_net_util.Log_String(g_state_level,l_path,'l_amt_to_net :'|| l_amt_to_net);
182: SELECT FNA.net_currency_rule_code, FNB.batch_currency, FNB.exchange_rate_type, FNB.settlement_date
183: INTO l_net_currency_rule_code, l_currency_code, l_exchange_rate_type, l_settlement_date
184: FROM FUN_NET_BATCHES_ALL FNB,
185: FUN_NET_AGREEMENTS_ALL FNA
186: where
187: FNB.BATCH_ID = p_batch_id
188: AND FNB.AGREEMENT_ID = FNA.AGREEMENT_ID;
189: fun_net_util.Log_String(g_state_level,l_path,'l_net_currency_rule_code:'|| l_net_currency_rule_code);

Line 254: FUN_NET_AGREEMENTS_ALL FNA

250: fun_net_util.Log_String(g_state_level,l_path,' p_amt_to_net :: '||p_amt_to_net);
251: SELECT FNA.net_currency_rule_code, FNB.batch_currency, FNB.exchange_rate_type, FNB.settlement_date
252: INTO l_net_currency_rule_code, l_currency_code, l_exchange_rate_type, l_settlement_date
253: FROM FUN_NET_BATCHES_ALL FNB,
254: FUN_NET_AGREEMENTS_ALL FNA
255: where
256: FNB.BATCH_ID = p_batch_id
257: AND FNB.AGREEMENT_ID = FNA.AGREEMENT_ID;
258: fun_net_util.Log_String(g_state_level,l_path,'l_net_currency_rule_code:'|| l_net_currency_rule_code);

Line 415: FROM fun_net_agreements

411: agreement_start_date,
412: agreement_end_date,
413: nvl(days_past_due,0),
414: sel_rec_past_due_txns_flag
415: FROM fun_net_agreements
416: WHERE agreement_id = g_agreement_id;
417: BEGIN
418: -- Get all the agreement details like netting_currency_rule, netting_order_rule, --etc, into global variables from the table fun_net_agreements_all
419: OPEN c_get_agreement_details;

Line 418: -- Get all the agreement details like netting_currency_rule, netting_order_rule, --etc, into global variables from the table fun_net_agreements_all

414: sel_rec_past_due_txns_flag
415: FROM fun_net_agreements
416: WHERE agreement_id = g_agreement_id;
417: BEGIN
418: -- Get all the agreement details like netting_currency_rule, netting_order_rule, --etc, into global variables from the table fun_net_agreements_all
419: OPEN c_get_agreement_details;
420: FETCH c_get_agreement_details
421: INTO g_net_currency_rule,
422: g_net_order_rule,

Line 485: SELECT ALLOW_DISC_FLAG into l_allow_disc_flag FROM FUN_NET_AGREEMENTS_all WHERE Agreement_id=g_agreement_id; -- ER

481: l_path VARCHAR2(100);
482: BEGIN
483: l_path := g_path || 'Prepare_AR_Transactions';
484: fun_net_util.Log_String(g_proc_level,l_path,'Preparing AR Transactions');
485: SELECT ALLOW_DISC_FLAG into l_allow_disc_flag FROM FUN_NET_AGREEMENTS_all WHERE Agreement_id=g_agreement_id; -- ER
486: IF l_allow_disc_flag='N' THEN -- FOR NON ESD AGREEMENTS
487: -- Build Select Clause --
488: l_trx_select_clause :=
489: 'SELECT rct.customer_trx_id,

Line 716: SELECT ALLOW_DISC_FLAG into l_allow_disc_flag FROM FUN_NET_AGREEMENTS_all WHERE Agreement_id=g_agreement_id;

712: l_path VARCHAR2(100);
713: BEGIN
714: l_path := g_path || 'Prepare_AP_Transactions';
715: fun_net_util.Log_String(g_proc_level,l_path,'Preparing AP Transactions');
716: SELECT ALLOW_DISC_FLAG into l_allow_disc_flag FROM FUN_NET_AGREEMENTS_all WHERE Agreement_id=g_agreement_id;
717: IF l_allow_disc_flag='N' THEN -- FOR NON ESD AGREEMENTS
718: /* Build the select clause */
719: l_inv_select_clause :=
720: -- Select all ap_invoices based on the batch id

Line 2363: FROM fun_net_agreements

2359: agreement_end_date,
2360: shikyu_rule_code,
2361: days_past_due,
2362: sel_rec_past_due_txns_flag
2363: FROM fun_net_agreements
2364: WHERE org_id = g_batch_details.org_id
2365: AND TRUNC(agreement_start_date) <= TRUNC(g_batch_details.settlement_date)
2366: AND TRUNC(nvl(agreement_end_date,sysdate)) >= TRUNC(sysdate)
2367: AND agreement_id = nvl(g_agreement_id,agreement_id);

Line 2666: l_TP_approver fun_net_agreements_all.approver_name%TYPE;

2662: p_batch_id IN NUMBER) IS
2663: l_ap_bal fun_net_ap_invs_all.open_amt%TYPE;
2664: l_ar_bal fun_net_ar_txns_all.open_amt%TYPE;
2665: l_status_flag VARCHAR2(1);
2666: l_TP_approver fun_net_agreements_all.approver_name%TYPE;
2667: l_return_status VARCHAR2(1);
2668: l_msg_count NUMBER;
2669: l_msg_data VARCHAR2(2000);
2670: l_batch_status fun_net_batches_all.settlement_date%TYPE;

Line 2676: FROM FUN_NET_AGREEMENTS

2672: l_batch_status_flag BOOLEAN;
2673: VALIDATE_SETTLEMENT_DATE_FAIL EXCEPTION;
2674: CURSOR c_TP_approver IS
2675: SELECT approver_name
2676: FROM FUN_NET_AGREEMENTS
2677: WHERE agreement_id = g_agreement_id;
2678: l_path VARCHAR2(100);
2679: -- l_msg_data VARCHAR2(2000);
2680: BEGIN

Line 2717: SELECT ALLOW_DISC_FLAG into l_allow_disc_flag FROM FUN_NET_AGREEMENTS_all WHERE Agreement_id=g_agreement_id; -- ADDED FOR ESD

2713: 'Error getting Agreement details');
2714: RAISE FND_API.G_EXC_ERROR;
2715: END IF;
2716: Validate_multi_currency_flag;
2717: SELECT ALLOW_DISC_FLAG into l_allow_disc_flag FROM FUN_NET_AGREEMENTS_all WHERE Agreement_id=g_agreement_id; -- ADDED FOR ESD
2718: IF l_allow_disc_flag='Y' THEN -- ADDED FOR ESD
2719: -- calculate_approx_netted_amount
2720: AP_AR_balances_with_approxdisc(l_ar_bal, l_ap_bal, l_status_flag);
2721: ELSE

Line 2742: FROM FUN_NET_AGREEMENTS_all

2738: END IF;
2739: IF l_status_flag = FND_API.G_TRUE then
2740: SELECT ALLOW_DISC_FLAG -- ADDED FOR ESD BY SRAMPURE
2741: INTO l_allow_disc_flag
2742: FROM FUN_NET_AGREEMENTS_all
2743: WHERE Agreement_id = g_agreement_id;
2744: IF l_allow_disc_flag = 'Y' AND TRUNC(g_batch_details.settlement_date) < TRUNC(SYSDATE) THEN
2745: fun_net_util.Log_String(g_event_level,l_path,
2746: 'Error Validating settlement date for ESD batch');

Line 2860: l_non_response_action fun_net_agreements_all.non_response_action_code%TYPE;

2856: -- ***** Netting batch input parameters *****
2857: p_batch_id IN NUMBER,
2858: p_net_settle_date IN DATE,
2859: p_response_date IN DATE) RETURN VARCHAR2 IS
2860: l_non_response_action fun_net_agreements_all.non_response_action_code%TYPE;
2861: l_path varchar2(200);
2862: CURSOR c_non_response_action IS
2863: SELECT non_response_action_code
2864: FROM FUN_NET_AGREEMENTS

Line 2864: FROM FUN_NET_AGREEMENTS

2860: l_non_response_action fun_net_agreements_all.non_response_action_code%TYPE;
2861: l_path varchar2(200);
2862: CURSOR c_non_response_action IS
2863: SELECT non_response_action_code
2864: FROM FUN_NET_AGREEMENTS
2865: WHERE agreement_id = g_agreement_id;
2866: BEGIN
2867: l_path := g_path||'batch_exists';
2868: /* Initialize standard API parameters */

Line 2963: x_agreement_id IN fun_net_agreements.agreement_id%TYPE,

2959: p_data => x_msg_data );
2960: END Validate_Netting_Dates;
2961: PROCEDURE Set_Agreement_Status(
2962: x_batch_id IN fun_net_batches.batch_id%TYPE,
2963: x_agreement_id IN fun_net_agreements.agreement_id%TYPE,
2964: x_mode IN VARCHAR2,
2965: x_return_status OUT NOCOPY VARCHAR2)
2966: IS
2967: l_agreement_id fun_net_agreements.agreement_id%TYPE;

Line 2967: l_agreement_id fun_net_agreements.agreement_id%TYPE;

2963: x_agreement_id IN fun_net_agreements.agreement_id%TYPE,
2964: x_mode IN VARCHAR2,
2965: x_return_status OUT NOCOPY VARCHAR2)
2966: IS
2967: l_agreement_id fun_net_agreements.agreement_id%TYPE;
2968: BEGIN
2969: x_return_status := FND_API.G_TRUE;
2970: IF x_agreement_id IS NOT NULL THEN
2971: SELECT agreement_id

Line 2989: FUN_NET_AGREEMENTS_PKG.Update_Row(

2985: WHEN TOO_MANY_ROWS THEN
2986: null;
2987: WHEN NO_DATA_FOUND THEN
2988: IF x_mode = 'SET' THEN
2989: FUN_NET_AGREEMENTS_PKG.Update_Row(
2990: x_agreement_id => x_agreement_id,
2991: x_in_process_flag => 'Y');
2992: ELSIF x_mode = 'UNSET' THEN
2993: FUN_NET_AGREEMENTS_PKG.Update_Row(

Line 2993: FUN_NET_AGREEMENTS_PKG.Update_Row(

2989: FUN_NET_AGREEMENTS_PKG.Update_Row(
2990: x_agreement_id => x_agreement_id,
2991: x_in_process_flag => 'Y');
2992: ELSIF x_mode = 'UNSET' THEN
2993: FUN_NET_AGREEMENTS_PKG.Update_Row(
2994: x_agreement_id => x_agreement_id,
2995: x_in_process_flag => 'N');
2996: END IF;
2997: WHEN OTHERS THEN

Line 4698: SELECT ALLOW_DISC_FLAG into l_allow_disc_flag FROM FUN_NET_AGREEMENTS_all WHERE Agreement_id=g_agreement_id; -- ADDED FOR ESD

4694: RAISE FND_API.G_EXC_ERROR;
4695: END IF;
4696: -- Calculate Netting balances
4697: fun_net_util.Log_String(g_event_level,l_path,'Before Selecting' || g_agreement_id);
4698: SELECT ALLOW_DISC_FLAG into l_allow_disc_flag FROM FUN_NET_AGREEMENTS_all WHERE Agreement_id=g_agreement_id; -- ADDED FOR ESD
4699: IF l_allow_disc_flag='Y' THEN -- ADDED FOR ESD
4700: calculate_approx_netted_amount(l_amt_to_net,l_status_flag);
4701: ELSE
4702: calculate_AP_AR_balances(l_amt_to_net,l_status_flag);

Line 4897: fun_net_agreements_all fna

4893: BEGIN
4894: SELECT distinct allow_disc_flag
4895: INTO l_allow_disc_flag
4896: FROM fun_net_batches_all fnb,
4897: fun_net_agreements_all fna
4898: WHERE fnb.batch_id = p_batch_id
4899: and fna.agreement_id = fnb.agreement_id;
4900: RETURN l_allow_disc_flag;
4901: EXCEPTION