APPS.JAI_ETCS_PKG dependencies on GL_PERIODS

Line 150: , cp_start_date OUT NOCOPY GL_PERIODS.START_DATE%TYPE

146: PROCEDURE get_start_end_date(
147: cp_attr_code IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE --TDS_CALENDAR / TCS_CALENDAR
148: , cp_rgm_code IN JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE --TDS / TCS
149: , cp_fin_year IN NUMBER
150: , cp_start_date OUT NOCOPY GL_PERIODS.START_DATE%TYPE
151: , cp_end_date OUT NOCOPY GL_PERIODS.END_DATE%TYPE
152: )
153: IS
154:

Line 151: , cp_end_date OUT NOCOPY GL_PERIODS.END_DATE%TYPE

147: cp_attr_code IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE --TDS_CALENDAR / TCS_CALENDAR
148: , cp_rgm_code IN JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE --TDS / TCS
149: , cp_fin_year IN NUMBER
150: , cp_start_date OUT NOCOPY GL_PERIODS.START_DATE%TYPE
151: , cp_end_date OUT NOCOPY GL_PERIODS.END_DATE%TYPE
152: )
153: IS
154:
155: cursor c_get_tcs_rgm_atrbt

Line 169: FROM GL_PERIODS a

165: ,cp_fin_year IN NUMBER)
166: IS
167: SELECT a.START_DATE
168: ,a.END_DATE
169: FROM GL_PERIODS a
170: , gl_period_sets b
171: WHERE a.PERIOD_SET_NAME = b.period_set_name
172: AND b.period_set_id = cp_calendar_id
173: AND a.PERIOD_YEAR = cp_fin_year;

Line 177: lv_fin_year GL_PERIODS.PERIOD_YEAR%TYPE;

173: AND a.PERIOD_YEAR = cp_fin_year;
174:
175:
176: lv_gl_calendar_id number;
177: lv_fin_year GL_PERIODS.PERIOD_YEAR%TYPE;
178:
179: BEGIN
180:
181: OPEN c_get_tcs_rgm_atrbt;

Line 2689: v_start_date GL_PERIODS.START_DATE%TYPE; --Added by Chong for DTC ER 2012/09/11 Get TCS calendar from regime

2685: /*--Commented by Chong for DTC ER 2012/09/11 Get TCS calendar from regime
2686: v_start_date JAI_AP_TDS_YEARS.start_date%type ;
2687: v_end_date JAI_AP_TDS_YEARS.end_date%type;
2688: */
2689: v_start_date GL_PERIODS.START_DATE%TYPE; --Added by Chong for DTC ER 2012/09/11 Get TCS calendar from regime
2690: v_end_date GL_PERIODS.END_DATE%TYPE; --Added by Chong for DTC ER 2012/09/11 Get TCS calendar from regime
2691: -- code ported from Bl12.1.3 on 15-MAR-2013 end.
2692:
2693: -- File Header variables

Line 2690: v_end_date GL_PERIODS.END_DATE%TYPE; --Added by Chong for DTC ER 2012/09/11 Get TCS calendar from regime

2686: v_start_date JAI_AP_TDS_YEARS.start_date%type ;
2687: v_end_date JAI_AP_TDS_YEARS.end_date%type;
2688: */
2689: v_start_date GL_PERIODS.START_DATE%TYPE; --Added by Chong for DTC ER 2012/09/11 Get TCS calendar from regime
2690: v_end_date GL_PERIODS.END_DATE%TYPE; --Added by Chong for DTC ER 2012/09/11 Get TCS calendar from regime
2691: -- code ported from Bl12.1.3 on 15-MAR-2013 end.
2692:
2693: -- File Header variables
2694: v_line_number NUMBER(9);