1 package FND_CONC_RELEASE_CLASS_UTILS AUTHID CURRENT_USER as
2 /* $Header: AFCPCRCS.pls 115.6 2003/10/16 11:24:20 nkagrawa noship $ */
3
4
5 -- Name
6 -- calc_specific_startdate
7 -- Purpose
8 -- Given a requested start date and the class info for a Specific schedule,
9 -- return the next date that a request should run according to this schedule.
10 -- May return null if no valid date found.
11 --
12 function calc_specific_startdate(req_sdate in date,
13 class_info in varchar2) return date;
14
15
16 -- Name
17 -- parse_named_periodic_schedule
18 -- Purpose
19 -- Given an application name and a Periodic schedule name,
20 -- return the interval, interval unit, interval type, start_date and end date
21 -- for this schedule.
22 -- Values will be null if the schedule is not found or an error occurs.
23 --
24 procedure parse_named_periodic_schedule(p_application in varchar2,
25 p_class_name in varchar2,
26 p_repeat_interval out nocopy number,
27 p_repeat_interval_unit out nocopy varchar2,
28 p_repeat_interval_type out nocopy varchar2,
29 p_start_date out nocopy date,
30 p_repeat_end out nocopy date);
31
32
33 -- Name
34 -- parse_periodic_schedule
35 -- Purpose
36 -- Given an application id and a Periodic schedule id,
37 -- return the interval, interval unit, interval type, start_date and end date
38 -- for this schedule.
39 -- Values will be null if the schedule is not found or an error occurs.
40 --
41 procedure parse_periodic_schedule(p_rel_class_app_id in number,
42 p_rel_class_id in number,
43 p_repeat_interval out nocopy number,
44 p_repeat_interval_unit out nocopy varchar2,
45 p_repeat_interval_type out nocopy varchar2,
46 p_start_date out nocopy date,
47 p_repeat_end out nocopy date);
48
49
50 -- Name
51 -- assign_specific_sch
52 -- Purpose
53 -- this function assigns specific schedule to a request
54 -- return true if successful
55 -- May return false if unsuccessful
56 --
57 function assign_specific_sch (req_id in number,
58 class_info in varchar2,
59 start_date in date,
60 end_date in date) return boolean;
61
62
63 end FND_CONC_RELEASE_CLASS_UTILS;
64