DBA Data[Home] [Help]

APPS.FUN_NET_ARAP_PKG dependencies on GL_LEDGERS

Line 16: currency gl_ledgers.currency_code%TYPE);

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;
20: g_batch_list batch_table;

Line 70: g_func_currency gl_ledgers.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;
74: g_agreement_count NUMBER;

Line 81: l_ledger_id gl_ledgers.ledger_id%TYPE;

77: g_login_id NUMBER;
78: g_today DATE;
79: l_allow_disc_flag VARCHAR2(1); -- ER
80: PROCEDURE get_functional_currency IS
81: l_ledger_id gl_ledgers.ledger_id%TYPE;
82: l_ledger_name gl_ledgers.name%TYPE;
83: BEGIN
84: MO_Utils.Get_Ledger_Info(
85: g_batch_details.org_id,

Line 82: l_ledger_name gl_ledgers.name%TYPE;

78: g_today DATE;
79: l_allow_disc_flag VARCHAR2(1); -- ER
80: PROCEDURE get_functional_currency IS
81: l_ledger_id gl_ledgers.ledger_id%TYPE;
82: l_ledger_name gl_ledgers.name%TYPE;
83: BEGIN
84: MO_Utils.Get_Ledger_Info(
85: g_batch_details.org_id,
86: l_ledger_id,

Line 90: FROM gl_ledgers

86: l_ledger_id,
87: l_ledger_name);
88: SELECT currency_code
89: INTO g_func_currency
90: FROM gl_ledgers
91: WHERE ledger_id = l_ledger_id;
92: EXCEPTION
93: WHEN OTHERS THEN
94: NULL;

Line 3216: l_ledger_id gl_ledgers.ledger_id%TYPE;

3212: x_period_name OUT NOCOPY VARCHAR2,
3213: x_return_status OUT NOCOPY VARCHAR2,
3214: x_return_msg OUT NOCOPY VARCHAR2)
3215: IS
3216: l_ledger_id gl_ledgers.ledger_id%TYPE;
3217: x_closing_status gl_period_statuses.closing_status%TYPE;
3218: x_period_year gl_period_statuses.period_year%TYPE;
3219: x_period_num gl_period_statuses.period_num%TYPE;
3220: x_period_type gl_period_statuses.period_type%TYPE;