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