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_ALL

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 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 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 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 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 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