1 PACKAGE PA_SCHEDULE_PKG as
2 /* $Header: PARGSCHS.pls 120.2 2006/05/01 21:39:42 msachan noship $ */
3
4 --Bug 5126919: Added parameter p_total_hours. This will contain the total hours for
5 --which the schedule should be created. This will be used to make sure that schedule is created
6 --correctly (for the whole p_total_hours) even after rounding.
7 PROCEDURE insert_rows ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
8 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
10 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
11 p_total_hours IN NUMBER DEFAULT NULL); --Bug 5126919
12
13 --
14 -- Procedure : Insert_rows
15 -- Purpose : Create Rows in PA_SCHEDULES in
16 -- array processing. This overloaded function.
17 -- Parameters :
18 -- p_sch_record_tab - Table of schedule details Records
19
20 PROCEDURE insert_rows
21 ( p_calendar_id IN Number DEFAULT NULL ,
22 p_assignment_id IN Number DEFAULT NULL ,
23 p_project_id IN Number DEFAULT NULL ,
24 p_schedule_type_code IN varchar2 ,
25 p_assignment_status_code IN varchar2 DEFAULT NULL ,
26 p_start_date IN date ,
27 p_end_date IN date ,
28 p_monday_hours IN Number ,
29 p_tuesday_hours IN Number ,
30 p_wednesday_hours IN Number ,
31 p_thursday_hours IN Number ,
32 p_friday_hours IN Number ,
33 p_saturday_hours IN Number ,
34 p_sunday_hours IN Number ,
35 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
36 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
37 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
38
39 --
40 -- Procedure : Insert_rows
41 -- Purpose : Create Rows in PA_SCHEDULES with scalar data types.
42 -- This overloaded function.
43 -- Parameters :
44 -- p_sch_record_tab - Table of schedule details Records
45
46
47 PROCEDURE update_rows ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
48 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
49 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
50 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
51
52 --
53 -- Procedure : update_rows
54 -- Purpose : Create Rows in PA_SCHEDULES in
55 -- array processing. This overloaded function.
56 -- Parameters :
57 -- p_sch_record_tab - Table of schedule details Records
58
59 PROCEDURE update_rows
60 ( p_schrowid In rowid,
61 p_schedule_id IN Number ,
62 p_calendar_id IN Number DEFAULT NULL ,
63 p_assignment_id IN Number DEFAULT NULL ,
64 p_project_id IN Number DEFAULT NULL ,
65 p_schedule_type_code IN varchar2 DEFAULT NULL ,
66 p_assignment_status_code IN varchar2 DEFAULT NULL ,
67 p_start_date IN date DEFAULT NULL ,
68 p_end_date IN date DEFAULT NULL ,
69 p_monday_hours IN Number DEFAULT NULL ,
70 p_tuesday_hours IN Number DEFAULT NULL ,
71 p_wednesday_hours IN Number DEFAULT NULL ,
72 p_thursday_hours IN Number DEFAULT NULL ,
73 p_friday_hours IN Number DEFAULT NULL ,
74 p_saturday_hours IN Number DEFAULT NULL ,
75 p_sunday_hours IN Number DEFAULT NULL ,
76 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
77 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
78 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
79
80 PROCEDURE update_rows
81 ( p_schedule_id IN Number ,
82 p_calendar_id IN Number DEFAULT NULL ,
83 p_assignment_id IN Number DEFAULT NULL ,
84 p_project_id IN Number DEFAULT NULL ,
85 p_schedule_type_code IN varchar2 DEFAULT NULL ,
86 p_assignment_status_code IN varchar2 DEFAULT NULL ,
87 p_start_date IN date DEFAULT NULL ,
88 p_end_date IN date DEFAULT NULL ,
89 p_monday_hours IN Number DEFAULT NULL ,
90 p_tuesday_hours IN Number DEFAULT NULL ,
91 p_wednesday_hours IN Number DEFAULT NULL ,
92 p_thursday_hours IN Number DEFAULT NULL ,
93 p_friday_hours IN Number DEFAULT NULL ,
94 p_saturday_hours IN Number DEFAULT NULL ,
95 p_sunday_hours IN Number DEFAULT NULL ,
96 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
97 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
98 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
99
100 --
101 -- Procedure : update_rows
102 -- Purpose : Create Rows in PA_SCHEDULES with scalar data types.
103 -- This overloaded function.
104 -- Parameters :
105 -- p_sch_record_tab - Table of schedule details Records
106
107 PROCEDURE delete_rows ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
108 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
109 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
110 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
111
112 --
113 -- Procedure : delete_rows
114 -- Purpose : deletes Rows in PA_SCHEDULES in
115 -- array processing. This overloaded function.
116 -- Parameters :
117 -- p_sch_record_tab - Table of schedule details Records
118
119 PROCEDURE delete_rows
120 ( p_schedule_id IN Number ,
121 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
122 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
123 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
124
125 PROCEDURE delete_rows
126 ( p_schrowid IN rowid ,
127 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
128 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
129 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
130
131 END PA_SCHEDULE_PKG;