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 20: agreement_id fun_net_agreements_all.agreement_id%TYPE,

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;
24:

Line 67: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,

63: receipt_date ar_cash_receipts.receipt_date%TYPE,
64: gl_date ar_cash_receipts.receipt_date%TYPE,
65: customer_id hz_cust_accounts.cust_account_id%TYPE,
66: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
67: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,
68: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
69: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE ,
70: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
71: org_id fun_net_batches.org_id%TYPE

Line 75: g_net_currency_rule fun_net_agreements_all.net_currency_rule_code%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;
79: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;

Line 76: g_net_order_rule fun_net_agreements_all.net_order_rule_code%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;
79: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
80: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;

Line 77: g_net_balance_rule fun_net_agreements_all.net_balance_rule_code%TYPE;

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;
79: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
80: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
81: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;

Line 78: g_net_currency fun_net_agreements_all.net_currency_code%TYPE;

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;
79: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
80: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
81: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
82: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;

Line 79: g_bank_account_id fun_net_agreements_all.bank_account_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;
79: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
80: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
81: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
82: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
83: g_func_currency gl_ledgers.currency_code%TYPE;

Line 80: g_agreement_id fun_net_agreements_all.agreement_id%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;
79: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
80: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
81: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
82: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
83: g_func_currency gl_ledgers.currency_code%TYPE;
84: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;

Line 81: g_agr_start_date fun_net_agreements_all.agreement_start_date%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;
79: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
80: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
81: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
82: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
83: g_func_currency gl_ledgers.currency_code%TYPE;
84: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;
85: g_days_past_due fun_net_agreements_all.days_past_due%TYPE;

Line 82: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;

78: g_net_currency fun_net_agreements_all.net_currency_code%TYPE;
79: g_bank_account_id fun_net_agreements_all.bank_account_id%TYPE;
80: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
81: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
82: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
83: g_func_currency gl_ledgers.currency_code%TYPE;
84: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;
85: g_days_past_due fun_net_agreements_all.days_past_due%TYPE;
86: g_sel_past_due_flag fun_net_agreements_all.sel_rec_past_due_txns_flag%TYPE;

Line 84: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;

80: g_agreement_id fun_net_agreements_all.agreement_id%TYPE;
81: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
82: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
83: g_func_currency gl_ledgers.currency_code%TYPE;
84: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;
85: g_days_past_due fun_net_agreements_all.days_past_due%TYPE;
86: g_sel_past_due_flag fun_net_agreements_all.sel_rec_past_due_txns_flag%TYPE;
87:
88: g_agreement_count NUMBER;

Line 85: g_days_past_due fun_net_agreements_all.days_past_due%TYPE;

81: g_agr_start_date fun_net_agreements_all.agreement_start_date%TYPE;
82: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
83: g_func_currency gl_ledgers.currency_code%TYPE;
84: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;
85: g_days_past_due fun_net_agreements_all.days_past_due%TYPE;
86: g_sel_past_due_flag fun_net_agreements_all.sel_rec_past_due_txns_flag%TYPE;
87:
88: g_agreement_count NUMBER;
89: g_currency_count NUMBER;

Line 86: g_sel_past_due_flag fun_net_agreements_all.sel_rec_past_due_txns_flag%TYPE;

82: g_agr_end_date fun_net_agreements_all.agreement_end_date%TYPE;
83: g_func_currency gl_ledgers.currency_code%TYPE;
84: g_shikyu_rule fun_net_agreements_all.shikyu_rule_code%TYPE;
85: g_days_past_due fun_net_agreements_all.days_past_due%TYPE;
86: g_sel_past_due_flag fun_net_agreements_all.sel_rec_past_due_txns_flag%TYPE;
87:
88: g_agreement_count NUMBER;
89: g_currency_count NUMBER;
90:

Line 234: FROM fun_net_agreements

230: agreement_start_date,
231: agreement_end_date,
232: nvl(days_past_due,0),
233: sel_rec_past_due_txns_flag
234: FROM fun_net_agreements
235: WHERE agreement_id = g_agreement_id;
236:
237: BEGIN
238:

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

235: WHERE agreement_id = g_agreement_id;
236:
237: BEGIN
238:
239: -- Get all the agreement details like netting_currency_rule, netting_order_rule, --etc, into global variables from the table fun_net_agreements_all
240: OPEN c_get_agreement_details;
241: FETCH c_get_agreement_details
242: INTO g_net_currency_rule,
243: g_net_order_rule,

Line 1646: FROM fun_net_agreements

1642: agreement_end_date,
1643: shikyu_rule_code,
1644: days_past_due,
1645: sel_rec_past_due_txns_flag
1646: FROM fun_net_agreements
1647: WHERE org_id = g_batch_details.org_id
1648: AND TRUNC(agreement_start_date) <= TRUNC(g_batch_details.settlement_date)
1649: AND TRUNC(nvl(agreement_end_date,sysdate)) >= TRUNC(sysdate)
1650: AND agreement_id = nvl(g_agreement_id,agreement_id);

Line 1952: l_TP_approver fun_net_agreements_all.approver_name%TYPE;

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);
1954: l_msg_count NUMBER;
1955: l_msg_data VARCHAR2(2000);
1956: l_batch_status fun_net_batches_all.settlement_date%TYPE;

Line 1963: FROM FUN_NET_AGREEMENTS

1959:
1960:
1961: CURSOR c_TP_approver IS
1962: SELECT approver_name
1963: FROM FUN_NET_AGREEMENTS
1964: WHERE agreement_id = g_agreement_id;
1965: l_path VARCHAR2(100);
1966: BEGIN
1967: l_path := g_path||'submit_net_batch';

Line 2148: l_non_response_action fun_net_agreements_all.non_response_action_code%TYPE;

2144: p_batch_id IN NUMBER,
2145: p_net_settle_date IN DATE,
2146: p_response_date IN DATE) RETURN VARCHAR2 IS
2147:
2148: l_non_response_action fun_net_agreements_all.non_response_action_code%TYPE;
2149: l_path varchar2(200);
2150: CURSOR c_non_response_action IS
2151: SELECT non_response_action_code
2152: FROM FUN_NET_AGREEMENTS

Line 2152: FROM FUN_NET_AGREEMENTS

2148: l_non_response_action fun_net_agreements_all.non_response_action_code%TYPE;
2149: l_path varchar2(200);
2150: CURSOR c_non_response_action IS
2151: SELECT non_response_action_code
2152: FROM FUN_NET_AGREEMENTS
2153: WHERE agreement_id = g_agreement_id;
2154:
2155: BEGIN
2156:

Line 2270: x_agreement_id IN fun_net_agreements.agreement_id%TYPE,

2266: END Validate_Netting_Dates;
2267:
2268: PROCEDURE Set_Agreement_Status(
2269: x_batch_id IN fun_net_batches.batch_id%TYPE,
2270: x_agreement_id IN fun_net_agreements.agreement_id%TYPE,
2271: x_mode IN VARCHAR2,
2272: x_return_status OUT NOCOPY VARCHAR2)
2273: IS
2274: l_agreement_id fun_net_agreements.agreement_id%TYPE;

Line 2274: l_agreement_id fun_net_agreements.agreement_id%TYPE;

2270: x_agreement_id IN fun_net_agreements.agreement_id%TYPE,
2271: x_mode IN VARCHAR2,
2272: x_return_status OUT NOCOPY VARCHAR2)
2273: IS
2274: l_agreement_id fun_net_agreements.agreement_id%TYPE;
2275: BEGIN
2276: x_return_status := FND_API.G_TRUE;
2277: IF x_agreement_id IS NOT NULL THEN
2278:

Line 2301: FUN_NET_AGREEMENTS_PKG.Update_Row(

2297:
2298: WHEN NO_DATA_FOUND THEN
2299: IF x_mode = 'SET' THEN
2300:
2301: FUN_NET_AGREEMENTS_PKG.Update_Row(
2302: x_agreement_id => x_agreement_id,
2303: x_in_process_flag => 'Y');
2304: ELSIF x_mode = 'UNSET' THEN
2305: FUN_NET_AGREEMENTS_PKG.Update_Row(

Line 2305: FUN_NET_AGREEMENTS_PKG.Update_Row(

2301: FUN_NET_AGREEMENTS_PKG.Update_Row(
2302: x_agreement_id => x_agreement_id,
2303: x_in_process_flag => 'Y');
2304: ELSIF x_mode = 'UNSET' THEN
2305: FUN_NET_AGREEMENTS_PKG.Update_Row(
2306: x_agreement_id => x_agreement_id,
2307: x_in_process_flag => 'N');
2308: END IF;
2309: