APPS.GL_SCHEDULER_PKG dependencies on GL_CONCURRENT_SCHEDULES

Line 97: SELECT TO_CHAR( gl_concurrent_schedules_s.NEXTVAL )

93: aol_end_date := aol_start_date + 0.5;
94:
95: -- select unique number from sequence to name the new period and
96: -- the disjunction associated with it
97: SELECT TO_CHAR( gl_concurrent_schedules_s.NEXTVAL )
98: INTO curr_seq_val
99: FROM SYS.dual;
100:
101: -- register new concurrent release period

Line 297: FROM gl_concurrent_schedules SCH

293: SELECT SCH.schedule_name,
294: SCH.period_type,
295: SCH.run_day,
296: TO_CHAR( SCH.run_time, 'HH24:MI:SS' )
297: FROM gl_concurrent_schedules SCH
298: WHERE SCH.period_set_name = p_period_set_name;
299:
300: BEGIN
301:

Line 314: UPDATE gl_concurrent_schedules SCH

310: -- call cleanup_schedule( ) to prepare the schedule for update
311: ret_code := gl_scheduler_pkg.cleanup_schedule( l_sched_name );
312: IF ( ret_code <> 0 ) THEN
313: fnd_message.set_name( 'SQLGL', 'GL_SCH_INT_ERROR' );
314: UPDATE gl_concurrent_schedules SCH
315: SET SCH.enabled_flag = 'N'
316: WHERE SCH.schedule_name = l_sched_name;
317:
318: -- ** Call FND API to disable schedule here ** --

Line 336: UPDATE gl_concurrent_schedules SCH

332: l_run_time,
333: FALSE );
334: IF ( ret_code <> 0 ) THEN
335: fnd_message.set_name( 'SQLGL', 'GL_SCH_INT_ERROR' );
336: UPDATE gl_concurrent_schedules SCH
337: SET SCH.enabled_flag = 'N'
338: WHERE SCH.schedule_name = l_sched_name;
339:
340: -- ** Call FND API to disable schedule here ** --