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_CFS_CALCULATE_PKG dependencies on GL_PERIODS

Line 51: -- This procedure is to retrieve period names from gl_periods by the

47: -- Populate_Period_Names Public
48: --
49: -- DESCRIPTION:
50: --
51: -- This procedure is to retrieve period names from gl_periods by the
52: -- parameter 'p_parameter' and the parameter p_balance_type, alternative
53: -- value is 'YTD/QTD/PTD'
54: --
55: -- PARAMETERS:

Line 81: l_period_set_name gl_periods.period_set_name%TYPE;

77: ,x_period_names OUT NOCOPY JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL
78: )
79: IS
80: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
81: l_period_set_name gl_periods.period_set_name%TYPE;
82: l_accounted_period_type gl_periods.period_type%TYPE;
83: l_period_name gl_periods.period_name%TYPE :=p_period_name;
84: l_period_year gl_periods.period_year%TYPE;
85: l_period_num gl_periods.period_num%TYPE;

Line 82: l_accounted_period_type gl_periods.period_type%TYPE;

78: )
79: IS
80: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
81: l_period_set_name gl_periods.period_set_name%TYPE;
82: l_accounted_period_type gl_periods.period_type%TYPE;
83: l_period_name gl_periods.period_name%TYPE :=p_period_name;
84: l_period_year gl_periods.period_year%TYPE;
85: l_period_num gl_periods.period_num%TYPE;
86: l_quarter_num gl_periods.quarter_num%TYPE;

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

79: IS
80: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
81: l_period_set_name gl_periods.period_set_name%TYPE;
82: l_accounted_period_type gl_periods.period_type%TYPE;
83: l_period_name gl_periods.period_name%TYPE :=p_period_name;
84: l_period_year gl_periods.period_year%TYPE;
85: l_period_num gl_periods.period_num%TYPE;
86: l_quarter_num gl_periods.quarter_num%TYPE;
87:

Line 84: l_period_year gl_periods.period_year%TYPE;

80: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
81: l_period_set_name gl_periods.period_set_name%TYPE;
82: l_accounted_period_type gl_periods.period_type%TYPE;
83: l_period_name gl_periods.period_name%TYPE :=p_period_name;
84: l_period_year gl_periods.period_year%TYPE;
85: l_period_num gl_periods.period_num%TYPE;
86: l_quarter_num gl_periods.quarter_num%TYPE;
87:
88: CURSOR c_period_set_name

Line 85: l_period_num gl_periods.period_num%TYPE;

81: l_period_set_name gl_periods.period_set_name%TYPE;
82: l_accounted_period_type gl_periods.period_type%TYPE;
83: l_period_name gl_periods.period_name%TYPE :=p_period_name;
84: l_period_year gl_periods.period_year%TYPE;
85: l_period_num gl_periods.period_num%TYPE;
86: l_quarter_num gl_periods.quarter_num%TYPE;
87:
88: CURSOR c_period_set_name
89: IS

Line 86: l_quarter_num gl_periods.quarter_num%TYPE;

82: l_accounted_period_type gl_periods.period_type%TYPE;
83: l_period_name gl_periods.period_name%TYPE :=p_period_name;
84: l_period_year gl_periods.period_year%TYPE;
85: l_period_num gl_periods.period_num%TYPE;
86: l_quarter_num gl_periods.quarter_num%TYPE;
87:
88: CURSOR c_period_set_name
89: IS
90: SELECT

Line 104: gl_periods

100: period_year
101: ,period_num
102: ,quarter_num
103: FROM
104: gl_periods
105: WHERE period_set_name=l_period_set_name
106: AND period_type=l_accounted_period_type
107: AND period_name=l_period_name;
108:

Line 114: gl_periods

110: IS
111: SELECT
112: period_name
113: FROM
114: gl_periods
115: WHERE period_set_name=l_period_set_name
116: AND period_type=l_accounted_period_type
117: AND period_year=l_period_year
118: AND period_num<=l_period_num;

Line 125: gl_periods

121: IS
122: SELECT
123: period_name
124: FROM
125: gl_periods
126: WHERE period_set_name=l_period_set_name
127: AND period_type=l_accounted_period_type
128: AND period_year=l_period_year
129: AND quarter_num=l_quarter_num

Line 133: l_curr_period_name gl_periods.period_name%TYPE;

129: AND quarter_num=l_quarter_num
130: AND period_num<=l_period_num;
131:
132: l_period_idx NUMBER;
133: l_curr_period_name gl_periods.period_name%TYPE;
134: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;
135:
136: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
137: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

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

1792: l_final_display_format VARCHAR2(30);
1793: l_legal_entity_id NUMBER :=p_legal_entity_id;
1794: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
1795: l_func_currency_code fnd_currencies.currency_code%TYPE;
1796: l_period_name gl_periods.period_name%TYPE :=p_period_name;
1797: l_axis_set_id rg_report_axis_sets.axis_set_id%TYPE :=p_axis_set_id;
1798: l_rounding_option VARCHAR2(50) :=p_rounding_option;
1799: l_balance_type VARCHAR2(50) :=p_balance_type ;
1800: l_segment_override VARCHAR2(100) :=p_segment_override; --addded for CNAO Enhancement