[Home] [Help]
PACKAGE: APPS.PA_SCH_EXCEPT_PKG
Source
1 PACKAGE PA_SCH_EXCEPT_PKG AUTHID CURRENT_USER as
2 /* $Header: PARGEXPS.pls 120.1 2005/08/19 16:53:00 mwasowic noship $ */
3
4
5 PROCEDURE insert_rows ( p_sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,
6 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
8 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
9
10 --
11 -- Procedure : Insert_rows
12 -- Purpose : Create Rows in PA_SCHEDULE_EXCEPTIONS in
13 -- array processing. This overloaded function.
14 -- Parameters :
15 -- p_sch_record_tab - Table of schedule details Records
16 PROCEDURE insert_rows
17 ( p_calendar_id IN Number DEFAULT NULL ,
18 p_assignment_id IN Number DEFAULT NULL ,
19 p_project_id IN Number DEFAULT NULL ,
20 p_schedule_type_code IN varchar2 ,
21 p_assignment_status_code IN varchar2 DEFAULT NULL ,
22 p_exception_type_code IN varchar2 ,
23 p_duration_shift_type_code IN varchar2 DEFAULT NULL ,
24 p_duration_shift_unit_code IN varchar2 DEFAULT NULL ,
25 p_number_of_shift IN number DEFAULT NULL ,
26 p_start_date IN date ,
27 p_end_date IN date ,
28 p_resource_calendar_percent IN Number DEFAULT NULL ,
29 p_non_working_day_flag IN varchar2 DEFAULT NULL ,
30 p_change_hours_type_code IN varchar2 DEFAULT NULL ,
31 p_change_calendar_type_code IN varchar2 DEFAULT NULL ,
32 -- p_change_calendar_name IN varchar2 DEFAULT NULL ,
33 p_change_calendar_id IN number DEFAULT NULL ,
34 p_monday_hours IN Number DEFAULT NULL ,
35 p_tuesday_hours IN Number DEFAULT NULL ,
36 p_wednesday_hours IN Number DEFAULT NULL ,
37 p_thursday_hours IN Number DEFAULT NULL ,
38 p_friday_hours IN Number DEFAULT NULL ,
39 p_saturday_hours IN Number DEFAULT NULL ,
40 p_sunday_hours IN Number DEFAULT NULL ,
41 x_exception_id OUT NOCOPY Number , --File.Sql.39 bug 4440895
42 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
43 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
44 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
45 --
46 -- Procedure : Insert_rows
47 -- Purpose : Create Rows in PA_SCHEDULE_EXCEPTIONS with scalar data types.
48 -- This overloaded function.
49 -- Parameters :
50 -- p_sch_record_tab - Table of schedule details Records
51
52
53 PROCEDURE update_rows ( p_sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,
54 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
55 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
56 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
57
58 --
59 -- Procedure : update_rows
60 -- Purpose : Create Rows in PA_SCHEDULE_EXCEPTIONS in
61 -- array processing. This overloaded function.
62 -- Parameters :
63 -- p_sch_record_tab - Table of schedule details Records
64 PROCEDURE update_rows
65 ( p_exceptrowid IN rowid ,
66 p_schedule_exception_id IN NUMBER,
67 p_calendar_id IN Number DEFAULT NULL ,
68 p_assignment_id IN Number DEFAULT NULL ,
69 p_project_id IN Number DEFAULT NULL ,
70 p_schedule_type_code IN varchar2 ,
71 p_assignment_status_code IN varchar2 DEFAULT NULL ,
72 p_exception_type_code IN varchar2 ,
73 p_duration_shift_type_code IN varchar2 DEFAULT NULL ,
74 p_duration_shift_unit_code IN varchar2 DEFAULT NULL ,
75 p_number_of_shift IN number DEFAULT NULL ,
76 p_start_date IN date ,
77 p_end_date IN date ,
78 p_resource_calendar_percent IN Number DEFAULT NULL ,
79 p_non_working_day_flag IN varchar2 DEFAULT NULL ,
80 p_change_hours_type_code IN varchar2 DEFAULT NULL ,
81 p_change_calendar_type_code IN varchar2 DEFAULT NULL ,
82 -- p_change_calendar_name IN varchar2 DEFAULT NULL ,
83 p_change_calendar_id IN number DEFAULT NULL ,
84 p_monday_hours IN Number DEFAULT NULL ,
85 p_tuesday_hours IN Number DEFAULT NULL ,
86 p_wednesday_hours IN Number DEFAULT NULL ,
87 p_thursday_hours IN Number DEFAULT NULL ,
88 p_friday_hours IN Number DEFAULT NULL ,
89 p_saturday_hours IN Number DEFAULT NULL ,
90 p_sunday_hours IN Number DEFAULT NULL ,
91 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
92 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
93 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
94 --
95 -- Procedure : update_rows
96 -- Purpose : Create Rows in PA_SCHEDULE_EXCEPTIONS with scalar data types.
97 -- This overloaded function.
98 -- Parameters :
99 -- p_sch_record_tab - Table of schedule details Records
100 PROCEDURE update_rows
101 ( p_schedule_exception_id IN NUMBER ,
102 p_calendar_id IN Number DEFAULT NULL ,
103 p_assignment_id IN Number DEFAULT NULL ,
104 p_project_id IN Number DEFAULT NULL ,
105 p_schedule_type_code IN varchar2 ,
106 p_assignment_status_code IN varchar2 DEFAULT NULL ,
107 p_exception_type_code IN varchar2 ,
108 p_duration_shift_type_code IN varchar2 DEFAULT NULL ,
109 p_duration_shift_unit_code IN varchar2 DEFAULT NULL ,
110 p_number_of_shift IN number DEFAULT NULL ,
111 p_start_date IN date ,
112 p_end_date IN date ,
113 p_resource_calendar_percent IN Number DEFAULT NULL ,
114 p_non_working_day_flag IN varchar2 DEFAULT NULL ,
115 p_change_hours_type_code IN varchar2 DEFAULT NULL ,
116 p_change_calendar_type_code IN varchar2 DEFAULT NULL ,
117 -- p_change_calendar_name IN varchar2 DEFAULT NULL ,
118 p_change_calendar_id IN number DEFAULT NULL ,
119 p_monday_hours IN Number DEFAULT NULL ,
120 p_tuesday_hours IN Number DEFAULT NULL ,
121 p_wednesday_hours IN Number DEFAULT NULL ,
122 p_thursday_hours IN Number DEFAULT NULL ,
123 p_friday_hours IN Number DEFAULT NULL ,
124 p_saturday_hours IN Number DEFAULT NULL ,
125 p_sunday_hours IN Number DEFAULT NULL ,
126 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
127 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
128 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
129 --
130 -- Procedure : update_rows
131 -- Purpose : Create Rows in PA_SCHEDULE_EXCEPTIONS with scalar data types.
132 -- This overloaded function.
133 -- Parameters :
134 -- p_sch_record_tab - Table of schedule details Records
135
136 PROCEDURE delete_rows ( p_sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,
137 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
138 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
139 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
140
141 --
142 -- Procedure : delete_rows
143 -- Purpose : deletes Rows in PA_SCHEDULES in
144 -- array processing. This overloaded function.
145 -- Parameters :
146 -- p_sch_record_tab - Table of schedule details Records
147
148 PROCEDURE delete_rows
149 ( p_schedule_exception_id IN Number ,
150 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
151 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
152 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
153
154 PROCEDURE delete_rows
155 ( p_exceptrowid IN rowid,
156 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
157 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
158 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
159 END PA_SCH_EXCEPT_PKG;