[Home] [Help]
PACKAGE: APPS.PA_CALENDAR_UTILS
Source
1 PACKAGE PA_CALENDAR_UTILS AUTHID CURRENT_USER as
2 /* $Header: PARGCALS.pls 120.1 2005/08/19 16:52:53 mwasowic noship $ */
3
4 /* Added nocopy for this variable for bug#2674619 */
5 PROCEDURE get_calendar_shifts ( p_calendar_id IN NUMBER,
6 x_cal_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.CalendarTabTyp,
7 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
9 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
10
11 --
12 -- Procedure : Get_calendar_shifts
13 -- Purpose : Getting the shifts which are assigned to a passing calendar in
14 -- array processing.
15 -- Parameters :
16 -- x_cal_record_tab - Table of Calendar details Records
17
18 /* Added nocopy for this variable for bug#2674619 */
19 PROCEDURE get_calendar_except ( p_calendar_id IN NUMBER,
20 x_cal_except_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.CalExceptionTabTyp,
21 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
22 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
24
25 --
26 -- Procedure : Get_calendar_except
27 -- Purpose : Getting the exceptions which are assigned to a passing calendar in
28 -- array processing.
29 -- Parameters :
30 -- x_cal_except_record_tab - Table of Exception details Records
31
32 /* Added nocopy for this variable for bug#2674619 */
33 PROCEDURE gen_calendar_sch ( p_calendar_id IN NUMBER,
34 p_cal_record_tab IN PA_SCHEDULE_GLOB.CalendarTabTyp,
35 x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
36 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
37 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
38 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
39
40 --
41 -- Procedure : Gen_calendar_sch
42 -- Purpose : Generating calendar schedule based on the calendar shift details in
43 -- array processing.
44 -- Parameters :
45 -- p_cal_record_tab - Table of Calendar details Records
46 -- x_sch_record_tab - Table of Schedule details Records
47
48 /* Added nocopy for this variable for bug#2674619 */
49 PROCEDURE apply_calendar_except ( p_calendar_id IN NUMBER,
50 p_cal_except_record_tab IN PA_SCHEDULE_GLOB.CalExceptionTabTyp,
51 p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
52 x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
53 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
54 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
55 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
56
57 --
58 -- Procedure : Apply_calendar_except
59 -- Purpose : Applying calendar exceptions on the calendar schedule in
60 -- array processing.
61 -- Parameters :
62 -- p_cal_except_record_tab - Table of Exception details Records
63 -- p_sch_record_tab - Table of Schedule details Records
64 -- x_sch_record_tab - Table of Schedule details Records
65
66 PROCEDURE Check_Calendar_Name_Or_Id
67 ( p_calendar_id IN JTF_CALENDARS_VL.calendar_id%TYPE
68 ,p_calendar_name IN JTF_CALENDARS_VL.calendar_name%TYPE
69 ,p_check_id_flag IN VARCHAR2 := 'A'
70 ,x_calendar_id OUT NOCOPY JTF_CALENDARS_VL.calendar_id%TYPE --File.Sql.39 bug 4440895
71 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72 ,x_error_message_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
73
74 --
75 -- Procedure : Check_Name_Or_Id
76 -- Purpose : This procedure validate the calendar Id or Calendar name against the JTF_CALENDARS_VL table
77 --
78 -- Parameters :
79 --
80
81 END PA_CALENDAR_UTILS;