[Home] [Help]
PACKAGE: APPS.FNDCP_SCH
Source
1 package FNDCP_SCH AUTHID CURRENT_USER as
2 /* $Header: AFCPSCHS.pls 115.2 99/07/16 23:15:23 porting ship $ */
3
4 -- Procedure
5 -- COMMIT_CHANGES
6 --
7 -- Purpose
8 -- Commits changes and sets 'dirty' flag for scheduler engine.
9 --
10 PROCEDURE COMMIT_CHANGES;
11
12 --
13 -- Procedure
14 -- SET_SESSION_MODE
15 --
16 -- Purpose
17 -- Sets the package mode for the current session.
18 --
19 -- Arguments:
20 -- session_mode - 'seed_data' if new data is for Datamerge.
21 -- 'customer_data' is the default.
22 --
23 PROCEDURE set_session_mode(session_mode IN VARCHAR2);
24
25
26 -- Function
27 -- MESSAGE
28 --
29 -- Purpose
30 -- Return an error message. Messages are set when
31 -- validation (program) errors occur.
32 --
33 FUNCTION message RETURN VARCHAR2;
34
35 --
36 -- Procedure
37 -- Class
38 --
39 -- Purpose
40 -- Register a Concurrent Release Class.
41 --
42 -- Arguments:
43 -- Application - Application Short Name
44 --
45 -- Class_Name - Class Name
46 --
47 -- User_Class_Name - User Class Name
48 --
49 -- Description - Description
50 --
51 PROCEDURE Class( Application IN Varchar2,
52 Class_Name IN Varchar2,
53 User_Class_Name IN Varchar2,
54 Description IN Varchar2 DEFAULT NULL,
55 Lang_CODE IN Varchar2);
56
57 --
58 -- Function
59 -- Class_Exists
60 --
61 -- Purpose
62 -- Determine Existence of Concurrent Release Class.
63 --
64 -- Arguments:
65 -- Application - Application Short Name
66 --
67 -- Class_Name - Class Name
68 --
69 FUNCTION Class_Exists ( Application IN Varchar2,
70 Class_Name IN Varchar2
71 ) Return Boolean;
72
73 --
74 -- Function
75 -- Class_Enable
76 --
77 -- Purpose
78 -- Set enabled flag for Concurrent Release Class.
79 --
80 -- Arguments:
81 -- Application - Application Short Name
82 --
83 -- Class_Name - Class Name
84 --
85 PROCEDURE Class_Enable( Application IN Varchar2,
86 Class_Name IN Varchar2
87 );
88
89 --
90 -- Function
91 -- Class_Disable
92 --
93 -- Purpose
94 -- Reset enabled flag for Concurrent Release Class.
95 --
96 -- Arguments:
97 -- Application - Application Short Name
98 --
99 -- Class_Name - Class Name
100 --
101 PROCEDURE Class_Disable(Application IN Varchar2,
102 Class_Name IN Varchar2
103 );
104
105 --
106 -- Function
107 -- Set_Class_Resub
108 --
109 -- Purpose
110 -- Reset enabled flag for Concurrent Release Class.
111 --
112 -- Arguments:
113 -- Application - Application Short Name
114 --
115 -- Class_Name - Class Name
116 --
117 -- Resub_Interval - How long of a delay for resubmission
118 --
119 -- Resub_Int_Unit_Code - Units for Resub_Interval
120 -- (MINUTES, HOURS, DAYS, MONTHS)
121 --
122 -- Resub_Int_Type_Code - Offset from start or end of request?
123 -- (START, END)
124 --
125 PROCEDURE Set_Class_Resub(Application IN Varchar2,
126 Class_Name IN Varchar2,
127 Resub_Interval IN Number,
128 Resub_Int_Unit_Code IN Varchar,
129 Resub_Int_Type_Code IN Varchar
130 );
131
132 -- Procedure
133 -- Class_Member
134 --
135 -- Purpose
136 -- Add Disjunction to a Concurrent Release Class.
137 --
138 -- Arguments:
139 -- Class Application - Application Short Name
140 --
141 -- Class_Name - Class Name
142 --
143 -- Disjunction_Application - Application Short Name
144 --
145 -- Disjunction_Name - Disjunction Name
146 --
147 PROCEDURE Class_Member( Class_Application IN Varchar2,
148 Class_Name IN Varchar2,
149 Disjunction_Application IN Varchar2,
150 Disjunction_Name IN Varchar2
151 );
152
153 -- Procedure
154 -- Class_DisMember
155 --
156 -- Purpose
157 -- Remove Disjunction from a Concurrent Release Class.
158 --
159 -- Arguments:
160 -- Class Application - Application Short Name
161 --
162 -- Class_Name - Class Name
163 --
164 -- Disjunction_Application - Application Short Name
165 --
166 -- Disjunction_Name - Disjunction Name
167 --
168 PROCEDURE Class_DisMember(Class_Application IN Varchar2,
169 Class_Name IN Varchar2,
170 Disjunction_Application IN Varchar2,
171 Disjunction_Name IN Varchar2
172 );
173
174 -- Function
175 -- Class_Member_Exists
176 --
177 -- Purpose
178 -- Check Membership in a Concurrent Release Class.
179 --
180 -- Arguments:
181 -- Class Application - Application Short Name
182 --
183 -- Class_Name - Class Name
184 --
185 -- Disjunction_Application - Application Short Name
186 --
187 -- Disjunction_Name - Disjunction Name
188 --
189 Function Class_Member_Exists(Class_Application IN Varchar2,
190 Class_Name IN Varchar2,
191 Disjunction_Application IN Varchar2,
192 Disjunction_Name IN Varchar2
193 )return Boolean;
194
195
196 -- Procedure
197 -- Disjunction
198 --
199 -- Purpose
200 -- Register a Concurrent Release Disjunction.
201 --
202 -- Arguments:
203 -- Application - Application Short Name
204 --
205 -- Disj_Name - Disjunction Name
206 --
207 -- User_Disj_Name - User Disjunction Name
208 --
209 -- Description - Description
210 --
211 PROCEDURE Disjunction( Application IN Varchar2,
212 Disj_Name IN Varchar2,
213 User_Disj_Name IN Varchar2,
214 Description IN Varchar2 DEFAULT NULL,
215 Lang_CODE IN Varchar2);
216 -- Function
217 -- Disjunction_Exists
218 --
219 -- Purpose
220 -- Determin Existence of a Concurrent Release Disjunction.
221 --
222 -- Arguments:
223 -- Application - Application Short Name
224 --
225 -- Disj_Name - Disjunction Name
226 --
227 FUNCTION Disjunction_Exists( Application IN Varchar2,
228 Disj_Name IN Varchar2
229 ) Return Boolean;
230
231 -- Procedure
232 -- Disj_Member_S
233 --
234 -- Purpose
235 -- Add State to a Concurrent Release Disjunction.
236 --
237 -- Arguments:
238 -- Disj Application - Application Short Name
239 --
240 -- Disj_Name - Disj Name
241 --
242 -- State_Application - Application Short Name
243 --
244 -- State_Name - State Name
245 --
246 -- State_Value - Value Name
247 --
248 -- Negation Flag - 'Y' or 'N'
249 --
250 PROCEDURE Disj_Member_S(Disj_Application IN Varchar2,
251 Disj_Name IN Varchar2,
252 State_Application IN Varchar2,
253 State_Name IN Varchar2,
254 State_Value IN Varchar2,
255 Negation_Flag IN Varchar2 DEFAULT 'N'
256 );
257
258 -- Procedure
259 -- Disj_Member_P
260 --
261 -- Purpose
262 -- Add Period to a Concurrent Release Disjunction.
263 --
264 -- Arguments:
265 -- Disj Application - Application Short Name
266 --
267 -- Disj_Name - Disj Name
268 --
269 -- Period_Application - Application Short Name
270 --
271 -- Period_Name - Period Name
272 --
273 -- Negation Flag - 'Y' or 'N'
274 --
275 PROCEDURE Disj_Member_P(Disj_Application IN Varchar2,
276 Disj_Name IN Varchar2,
277 Period_Application IN Varchar2,
278 Period_Name IN Varchar2,
279 Negation_Flag IN Varchar2 DEFAULT 'N'
280 );
281
282 -- Procedure
283 -- Disj_DisMember
284 --
285 -- Purpose
286 -- Remove State or Period from a Concurrent Release Disjunction.
287 --
288 -- Arguments:
289 -- Class Application - Application Short Name
290 --
291 -- Class_Name - Class Name
292 --
293 -- Member_Application - Application Short Name
294 --
295 -- Member_Name - Member Name
296 --
297 -- Member_Type - 'S' or 'P'
298 --
299 PROCEDURE Disj_DisMember(Disj_Application IN Varchar2,
300 Disj_Name IN Varchar2,
301 Member_Application IN Varchar2,
302 Member_Name IN Varchar2,
303 Member_Type IN Varchar2
304 );
305
306 -- Function
307 -- Disj_Member_Exists
308 --
309 -- Purpose
310 -- Check Membership in a Concurrent Release Disjunction.
311 --
312 -- Arguments:
313 -- Class Application - Application Short Name
314 --
315 -- Class_Name - Class Name
316 --
317 -- Member_Application - Application Short Name
318 --
319 -- Member_Name - Member Name
320 --
321 -- Member_Type - 'S' or 'P'
322 --
323 FUNCTION Disj_Member_Exists(Disj_Application IN Varchar2,
324 Disj_Name IN Varchar2,
325 Member_Application IN Varchar2,
326 Member_Name IN Varchar2,
327 Member_Type IN Varchar2
328 )return Boolean;
329
330
331 -- Function
332 -- Period_Exists
333 --
334 -- Purpose
335 -- Determine Existence of a Concurrent Release Period.
336 --
337 -- Arguments:
338 -- Application - Application Short Name
339 --
340 -- Period_Name - Period Name
341 --
342 FUNCTION Period_Exists ( Application IN Varchar2,
343 Period_Name IN Varchar2
344 ) return Boolean;
345
346 -- Procedure
347 -- Period
348 --
349 -- Purpose
350 -- Register a Concurrent Release Period.
351 --
352 -- Arguments:
353 -- Application - Application Short Name
354 --
355 -- Period_Name - Period Name
356 --
357 -- User_Period_Name - User Period Name
358 --
359 -- Description - Description
360 --
361 -- Period_Type - Day, Month, Year, or Reverse Month
362 --
363 -- Period_Length - Length of period in terms of Period_Type
364 --
365 -- Period_Start - Start point of a period
366 --
367 -- Period_Stop - Stop point of a period
368
369 PROCEDURE Period ( Application IN Varchar2,
370 Period_Name IN Varchar2,
371 User_Period_Name IN Varchar2,
372 Description IN Varchar2,
373 Period_Type IN Varchar2,
374 Period_Length IN Number,
375 Period_Start IN Date,
376 Period_Stop IN Date,
377 Lang_CODE IN Varchar2
378 );
379
380 -- Procedure
381 -- State_Value_Set
382 --
383 -- Purpose
384 -- Register a Concurrent Release State Value Set
385 --
386 -- Arguments:
387 -- Set_Name - SetName
388 --
389 -- User_Set_Name - User Set Name
390 --
391 -- Description - Description
392 --
393 PROCEDURE State_Value_Set(Set_Name IN Varchar2,
394 User_Set_Name IN Varchar2,
395 Description IN Varchar2 DEFAULT NULL,
396 Lang_CODE IN Varchar2
397 );
398
399 -- Procedure
400 -- State_Value
401 --
402 -- Purpose
403 -- Register a Concurrent Release State Value
404 --
405 -- Arguments:
406 -- Value_Name - Value Name
407 --
408 -- Value_Set_Name - Set Name
409 --
410 PROCEDURE State_Value( Value_Name IN Varchar2,
411 Value_Set_Name IN Varchar2,
412 DESCRIPTION IN VARCHAR2 DEFAULT NULL,
413 Lang_CODE IN Varchar2
414 );
415
416 -- Function
417 -- State_Value_Set_Exists
418 --
419 -- Purpose
420 -- Determine Existence of a Concurrent Release State Value Set
421 --
422 -- Arguments:
423 -- Set_Name - SetName
424 --
425 FUNCTION State_Value_Set_Exists(Set_Name IN Varchar2
426 ) return Boolean;
427
428 -- Function
429 -- State_Value_Exists
430 --
431 -- Purpose
435 -- Value_Name - Value Name
432 -- Determine Existence of a Concurrent Release State Value
433 --
434 -- Arguments:
436 --
437 -- Value_Set_Name - Set Name
438 --
439 FUNCTION State_Value_Exists( Value_Name IN Varchar2,
440 Value_Set_Name IN Varchar2
441 ) return Boolean;
442
443 -- Procedure
444 -- State
445 --
446 -- Purpose
447 -- Register a Concurrent Release State
448 --
449 -- Arguments:
450 -- Application - Application Short Name
451 --
452 -- State_Name - Period Name
453 --
454 -- User_State_Name - User Period Name
455 --
456 -- Description - Description
457 --
458 -- Value_Name - Value Name of initial value
459 --
460 -- Value_Set_Name - Set Name used by this state
461 --
462 PROCEDURE State( Application IN Varchar2,
463 State_Name IN Varchar2,
464 User_State_Name IN Varchar2,
465 Description IN Varchar2 DEFAULT NULL,
466 Value_Set_Name IN Varchar2,
467 Value_Name IN Varchar2,
468 Lang_CODE IN Varchar2
469 );
470
471 -- Function
472 -- State_Exists
473 --
474 -- Purpose
475 -- Determine Existence of a Concurrent Release State
476 --
477 -- Arguments:
478 -- Application - Application Short Name
479 --
480 -- State_Name - Period Name
481 --
482 FUNCTION State_Exists( Application IN Varchar2,
483 State_Name IN Varchar2
484 ) return Boolean;
485
486
487
488 end FNDCP_SCH;