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.GL_SCHEDULER_PKG dependencies on FNDCP_SCH

Line 57: IF FNDCP_SCH.Class_Exists( 'SQLGL', sched_name ) = TRUE

53: -- if it exists, exit with error.
54: -- if create_flag is FALSE, then don't register the class.
55:
56: IF create_flag = TRUE THEN
57: IF FNDCP_SCH.Class_Exists( 'SQLGL', sched_name ) = TRUE
58: THEN
59: RETURN (-1);
60: -- -1 = a schedule by this name already exists
61: ELSE

Line 62: FNDCP_SCH.Class( 'SQLGL', sched_name, sched_name,

58: THEN
59: RETURN (-1);
60: -- -1 = a schedule by this name already exists
61: ELSE
62: FNDCP_SCH.Class( 'SQLGL', sched_name, sched_name,
63: msgbuf, lang_code );
64: FNDCP_SCH.Set_Class_Resub( 'SQLGL', sched_name, 1, 'SMART',
65: 'START');
66: -- Set_Class_Resub sets the resubmission parameters for the

Line 64: FNDCP_SCH.Set_Class_Resub( 'SQLGL', sched_name, 1, 'SMART',

60: -- -1 = a schedule by this name already exists
61: ELSE
62: FNDCP_SCH.Class( 'SQLGL', sched_name, sched_name,
63: msgbuf, lang_code );
64: FNDCP_SCH.Set_Class_Resub( 'SQLGL', sched_name, 1, 'SMART',
65: 'START');
66: -- Set_Class_Resub sets the resubmission parameters for the
67: -- schedule. When it is called with the 'SMART' mode, the
68: -- scheduler detects the start time of the next period and

Line 103: IF FNDCP_SCH.Period_Exists( 'SQLGL', conc_period ) = TRUE THEN

99: FROM SYS.dual;
100:
101: -- register new concurrent release period
102: conc_period := CONCAT( curr_seq_val, '_P' );
103: IF FNDCP_SCH.Period_Exists( 'SQLGL', conc_period ) = TRUE THEN
104: CLOSE period_cursor;
105: RETURN( -2 );
106: -- -2 : period already exists
107: ELSE

Line 108: FNDCP_SCH.Period( 'SQLGL', conc_period, conc_period,

104: CLOSE period_cursor;
105: RETURN( -2 );
106: -- -2 : period already exists
107: ELSE
108: FNDCP_SCH.Period( 'SQLGL', conc_period, conc_period,
109: msgbuf, 'M',
110: 999,
111: aol_start_date,
112: aol_end_date,

Line 119: IF FNDCP_SCH.Disjunction_Exists( 'SQLGL', conc_disj ) = TRUE THEN

115:
116: -- register new concurrent release disjunction
117: conc_disj := CONCAT( curr_seq_val, '_D' );
118:
119: IF FNDCP_SCH.Disjunction_Exists( 'SQLGL', conc_disj ) = TRUE THEN
120: CLOSE period_cursor;
121: RETURN( -3 );
122: -- -3 : disjunction already exists
123: ELSE

Line 124: FNDCP_SCH.Disjunction( 'SQLGL', conc_disj, conc_disj,

120: CLOSE period_cursor;
121: RETURN( -3 );
122: -- -3 : disjunction already exists
123: ELSE
124: FNDCP_SCH.Disjunction( 'SQLGL', conc_disj, conc_disj,
125: msgbuf,
126: lang_code );
127: END IF;
128:

Line 130: IF FNDCP_SCH.Disj_Member_Exists( 'SQLGL', conc_disj,

126: lang_code );
127: END IF;
128:
129: -- add newly created period to newly created disjunction
130: IF FNDCP_SCH.Disj_Member_Exists( 'SQLGL', conc_disj,
131: 'SQLGL', conc_period,
132: 'P' ) = TRUE THEN
133: CLOSE period_cursor;
134: RETURN( -4 );

Line 137: FNDCP_SCH.Disj_Member_P( 'SQLGL', conc_disj,

133: CLOSE period_cursor;
134: RETURN( -4 );
135: -- -4 : period already exists in disjunction
136: ELSE
137: FNDCP_SCH.Disj_Member_P( 'SQLGL', conc_disj,
138: 'SQLGL', conc_period,
139: 'N' );
140: END IF;
141:

Line 143: IF FNDCP_SCH.Class_Member_Exists( 'SQLGL', sched_name,

139: 'N' );
140: END IF;
141:
142: -- add newly created disjunction to the class
143: IF FNDCP_SCH.Class_Member_Exists( 'SQLGL', sched_name,
144: 'SQLGL', conc_disj ) = TRUE
145: THEN
146: CLOSE period_cursor;
147: RETURN( -5 );

Line 150: FNDCP_SCH.Class_Member( 'SQLGL', sched_name,

146: CLOSE period_cursor;
147: RETURN( -5 );
148: -- -5 : disjunction already exists in class
149: ELSE
150: FNDCP_SCH.Class_Member( 'SQLGL', sched_name,
151: 'SQLGL', conc_disj );
152: END IF;
153:
154: END LOOP;

Line 156: FNDCP_SCH.Commit_Changes;

152: END IF;
153:
154: END LOOP;
155: CLOSE period_cursor;
156: FNDCP_SCH.Commit_Changes;
157: RETURN( 0 );
158:
159: EXCEPTION
160:

Line 236: FNDCP_SCH.Disj_Dismember( 'SQLGL', disj_name,

232: FETCH period_cursor INTO per_name, my_rowid2;
233: EXIT WHEN period_cursor%NOTFOUND;
234:
235: -- remove member period from the disjunction
236: FNDCP_SCH.Disj_Dismember( 'SQLGL', disj_name,
237: 'SQLGL', per_name, 'P' );
238:
239: -- disable member period of the disjunction
240: -- UPDATE fnd_conc_release_periods PER

Line 254: FNDCP_SCH.Class_Dismember( 'SQLGL', sched_name,

250: END LOOP;
251: CLOSE period_cursor;
252:
253: -- remove member disjunction from the class
254: FNDCP_SCH.Class_Dismember( 'SQLGL', sched_name,
255: 'SQLGL', disj_name );
256:
257: -- disable member disjunction of the class
258: -- UPDATE fnd_conc_release_disjs DIS

Line 270: FNDCP_SCH.Commit_Changes;

266: -- END IF;
267:
268: END LOOP;
269: CLOSE disj_cursor;
270: FNDCP_SCH.Commit_Changes;
271: RETURN ( return_code );
272:
273: EXCEPTION
274: WHEN NO_DATA_FOUND THEN

Line 319: FNDCP_SCH.Class_Disable( 'SQLGL', l_sched_name );

315: SET SCH.enabled_flag = 'N'
316: WHERE SCH.schedule_name = l_sched_name;
317:
318: -- ** Call FND API to disable schedule here ** --
319: FNDCP_SCH.Class_Disable( 'SQLGL', l_sched_name );
320: FNDCP_SCH.Commit_Changes;
321:
322: CLOSE schedule_cursor;
323: RETURN( -1 );

Line 320: FNDCP_SCH.Commit_Changes;

316: WHERE SCH.schedule_name = l_sched_name;
317:
318: -- ** Call FND API to disable schedule here ** --
319: FNDCP_SCH.Class_Disable( 'SQLGL', l_sched_name );
320: FNDCP_SCH.Commit_Changes;
321:
322: CLOSE schedule_cursor;
323: RETURN( -1 );
324: END IF;

Line 341: FNDCP_SCH.Class_Disable( 'SQLGL', l_sched_name );

337: SET SCH.enabled_flag = 'N'
338: WHERE SCH.schedule_name = l_sched_name;
339:
340: -- ** Call FND API to disable schedule here ** --
341: FNDCP_SCH.Class_Disable( 'SQLGL', l_sched_name );
342: FNDCP_SCH.Commit_Changes;
343:
344: CLOSE schedule_cursor;
345: RETURN( -2 );

Line 342: FNDCP_SCH.Commit_Changes;

338: WHERE SCH.schedule_name = l_sched_name;
339:
340: -- ** Call FND API to disable schedule here ** --
341: FNDCP_SCH.Class_Disable( 'SQLGL', l_sched_name );
342: FNDCP_SCH.Commit_Changes;
343:
344: CLOSE schedule_cursor;
345: RETURN( -2 );
346: END IF;

Line 349: FNDCP_SCH.Commit_Changes;

345: RETURN( -2 );
346: END IF;
347: END LOOP;
348: CLOSE schedule_cursor;
349: FNDCP_SCH.Commit_Changes;
350: RETURN( 0 );
351: END update_schedules;
352:
353: END gl_scheduler_pkg;