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.JA_CN_CFSSE_CALCULATE_PKG dependencies on GL_PERIODS

Line 25: --TYPE G_PERIOD_NAME_TBL IS TABLE OF gl_periods.period_name%TYPE INDEX BY BINARY_INTEGER;

21: --| 22/09/2008 Chaoqun Wu Updated for CNAO Enhancement |
22: --| 14/10/2008 Chaoqun Wu Fix bug# 7481478
23: --+======================================================================*/
24:
25: --TYPE G_PERIOD_NAME_TBL IS TABLE OF gl_periods.period_name%TYPE INDEX BY BINARY_INTEGER;
26:
27: --==== Golbal Variables ============
28: g_module_name VARCHAR2(30) := 'JA_CN_CFSSE_CALCULATE_PKG';
29: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

Line 58: l_period_set_name gl_periods.period_set_name%TYPE;

54: ,x_period_names OUT NOCOPY JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL) IS
55:
56: l_procedure_name VARCHAR2(30) := 'Populate_LastYear_Period_Names';
57: l_ledger_id gl_ledgers.ledger_id %TYPE := p_ledger_id;--updated by lyb
58: l_period_set_name gl_periods.period_set_name%TYPE;
59: l_period_type gl_periods.period_type%TYPE;
60: l_period_name gl_periods.period_name%TYPE := p_period_name;
61: l_cur_period_year gl_periods.period_year%TYPE;
62: l_last_period_year gl_periods.period_year%TYPE;

Line 59: l_period_type gl_periods.period_type%TYPE;

55:
56: l_procedure_name VARCHAR2(30) := 'Populate_LastYear_Period_Names';
57: l_ledger_id gl_ledgers.ledger_id %TYPE := p_ledger_id;--updated by lyb
58: l_period_set_name gl_periods.period_set_name%TYPE;
59: l_period_type gl_periods.period_type%TYPE;
60: l_period_name gl_periods.period_name%TYPE := p_period_name;
61: l_cur_period_year gl_periods.period_year%TYPE;
62: l_last_period_year gl_periods.period_year%TYPE;
63: l_lastyear_period_name gl_periods.period_name%TYPE;

Line 60: l_period_name gl_periods.period_name%TYPE := p_period_name;

56: l_procedure_name VARCHAR2(30) := 'Populate_LastYear_Period_Names';
57: l_ledger_id gl_ledgers.ledger_id %TYPE := p_ledger_id;--updated by lyb
58: l_period_set_name gl_periods.period_set_name%TYPE;
59: l_period_type gl_periods.period_type%TYPE;
60: l_period_name gl_periods.period_name%TYPE := p_period_name;
61: l_cur_period_year gl_periods.period_year%TYPE;
62: l_last_period_year gl_periods.period_year%TYPE;
63: l_lastyear_period_name gl_periods.period_name%TYPE;
64:

Line 61: l_cur_period_year gl_periods.period_year%TYPE;

57: l_ledger_id gl_ledgers.ledger_id %TYPE := p_ledger_id;--updated by lyb
58: l_period_set_name gl_periods.period_set_name%TYPE;
59: l_period_type gl_periods.period_type%TYPE;
60: l_period_name gl_periods.period_name%TYPE := p_period_name;
61: l_cur_period_year gl_periods.period_year%TYPE;
62: l_last_period_year gl_periods.period_year%TYPE;
63: l_lastyear_period_name gl_periods.period_name%TYPE;
64:
65: l_period_idx NUMBER;

Line 62: l_last_period_year gl_periods.period_year%TYPE;

58: l_period_set_name gl_periods.period_set_name%TYPE;
59: l_period_type gl_periods.period_type%TYPE;
60: l_period_name gl_periods.period_name%TYPE := p_period_name;
61: l_cur_period_year gl_periods.period_year%TYPE;
62: l_last_period_year gl_periods.period_year%TYPE;
63: l_lastyear_period_name gl_periods.period_name%TYPE;
64:
65: l_period_idx NUMBER;
66: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;

Line 63: l_lastyear_period_name gl_periods.period_name%TYPE;

59: l_period_type gl_periods.period_type%TYPE;
60: l_period_name gl_periods.period_name%TYPE := p_period_name;
61: l_cur_period_year gl_periods.period_year%TYPE;
62: l_last_period_year gl_periods.period_year%TYPE;
63: l_lastyear_period_name gl_periods.period_name%TYPE;
64:
65: l_period_idx NUMBER;
66: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;
67:

Line 81: FROM gl_periods

77:
78: -- this cursor is
79: CURSOR c_cur_period_year IS
80: SELECT period_year
81: FROM gl_periods
82: WHERE period_set_name = l_period_set_name
83: AND period_name = l_period_name;
84:
85: -- this cursor is

Line 88: FROM gl_periods

84:
85: -- this cursor is
86: CURSOR c_lastyear_period_names IS
87: SELECT period_name
88: FROM gl_periods
89: WHERE period_set_name = l_period_set_name
90: AND period_year = l_last_period_year
91: AND period_type = l_period_type;
92:

Line 200: l_period_name gl_periods.period_name%TYPE := p_period_name;

196: l_legal_entity_id NUMBER := p_legal_entity_id;
197: -- l_set_of_bks_id gl_sets_of_books.set_of_books_id%TYPE := p_set_of_bks_id;
198: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
199: l_func_currency_code fnd_currencies.currency_code%TYPE;
200: l_period_name gl_periods.period_name%TYPE := p_period_name;
201: l_axis_set_id rg_report_axis_sets.axis_set_id%TYPE := p_axis_set_id;
202: l_rounding_option VARCHAR2(50) := p_rounding_option;
203: l_balance_type VARCHAR2(50) := p_balance_type;
204: --l_internal_trx_flag VARCHAR2(1) := p_internal_trx_flag;