34:
35: ELSIF p_period_type_id=64 THEN
36:
37: SELECT start_date INTO l_start_date
38: FROM ozf_time_ent_qtr
39: WHERE ent_qtr_id=p_time_id;
40:
41: ELSIF p_period_type_id=128 THEN
42:
81:
82: ELSIF p_period_type_id=64 THEN
83:
84: SELECT end_date INTO l_end_date
85: FROM ozf_time_ent_qtr
86: WHERE ent_qtr_id=p_time_id;
87:
88: ELSIF p_period_type_id=128 THEN
89:
129:
130: ELSIF p_period_type_id=64 THEN
131:
132: SELECT name INTO l_name
133: FROM ozf_time_ent_qtr
134: WHERE ent_qtr_id=p_time_id;
135:
136: ELSIF p_period_type_id=128 THEN
137:
167:
168: ELSIF p_period_type_id=64 THEN
169:
170: SELECT name INTO l_name
171: FROM ozf_time_ent_qtr
172: WHERE ent_qtr_id=l_time_id;
173:
174: ELSIF p_period_type_id=128 THEN
175:
211:
212: ELSIF p_period_type_id=64 THEN
213:
214: SELECT sequence, ent_year_id INTO l_curr_qtr, l_curr_year
215: FROM ozf_time_ent_qtr
216: WHERE ent_qtr_id=p_time_id;
217:
218: SELECT ent_qtr_id INTO l_time_id
219: FROM ozf_time_ent_qtr
215: FROM ozf_time_ent_qtr
216: WHERE ent_qtr_id=p_time_id;
217:
218: SELECT ent_qtr_id INTO l_time_id
219: FROM ozf_time_ent_qtr
220: WHERE sequence=l_curr_qtr
221: AND ent_year_id=l_curr_year-1;
222:
223: ELSIF p_period_type_id=128 THEN
253: Cursor get_qtr_ids_csr (l_start_date date,
254: l_end_date date) IS
255: SELECT
256: ent_qtr_id
257: FROM ozf_time_ent_qtr
258: WHERE start_date >= l_start_date
259: AND end_date <= l_end_date;
260:
261: Cursor get_month_ids_csr (l_start_date date,
343: Cursor is_qtr_present_csr (l_start_date date,
344: l_end_date date) IS
345: SELECT 'Y'
346: FROM DUAL
347: WHERE TRUNC(l_start_date) IN (SELECT DISTINCT START_DATE FROM OZF_TIME_ENT_QTR)
348: AND TRUNC(l_end_date) IN (SELECT DISTINCT END_DATE FROM OZF_TIME_ENT_QTR);
349:
350: l_return_value CHAR := 'N';
351:
344: l_end_date date) IS
345: SELECT 'Y'
346: FROM DUAL
347: WHERE TRUNC(l_start_date) IN (SELECT DISTINCT START_DATE FROM OZF_TIME_ENT_QTR)
348: AND TRUNC(l_end_date) IN (SELECT DISTINCT END_DATE FROM OZF_TIME_ENT_QTR);
349:
350: l_return_value CHAR := 'N';
351:
352: BEGIN