43:
44: CURSOR c_threshold_calendar
45: IS
46: SELECT 1
47: FROM dual
48: WHERE EXISTS(SELECT 1
49: FROM gl_periods_v
50: WHERE period_set_name = p_threshold_calendar);
51:
191: l_return_status VARCHAR2(30);
192:
193: CURSOR c_id IS
194: SELECT OZF_THRESHOLDS_s.NEXTVAL
195: FROM dual;
196:
197: CURSOR c_id_exists (l_id IN NUMBER) IS
198: SELECT 1 FROM dual
199: WHERE EXISTS (SELECT 1 FROM OZF_THRESHOLDS_ALL_B
194: SELECT OZF_THRESHOLDS_s.NEXTVAL
195: FROM dual;
196:
197: CURSOR c_id_exists (l_id IN NUMBER) IS
198: SELECT 1 FROM dual
199: WHERE EXISTS (SELECT 1 FROM OZF_THRESHOLDS_ALL_B
200: WHERE THRESHOLD_ID = l_id);
201:
202: BEGIN