eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_SCHEDULE_PUB dependencies on PA_NUM_TBL_TYPE

Line 66: TYPE PA_NUM_TBL_TBL_TYPE IS TABLE OF SYSTEM.PA_NUM_TBL_TYPE INDEX BY BINARY_INTEGER;

62: INDEX BY BINARY_INTEGER;
63:
64: /* 7693634 start */
65: TYPE PA_DATE_TBL_TBL_TYPE IS TABLE OF SYSTEM.PA_DATE_TBL_TYPE INDEX BY BINARY_INTEGER;
66: TYPE PA_NUM_TBL_TBL_TYPE IS TABLE OF SYSTEM.PA_NUM_TBL_TYPE INDEX BY BINARY_INTEGER;
67: /* 7693634 end */
68:
69: G_update_schedule_bulk_call varchar2(1) := 'N'; -- Bug 8233045
70:

Line 107: p_hours_table IN SYSTEM.PA_NUM_TBL_TYPE ,

103: p_asgn_end_date IN DATE := NULL ,
104: p_start_date IN DATE := NULL ,
105: -- p_end_date IN DATE := NULL ,
106: p_assignment_status_code IN VARCHAR2 := NULL ,
107: p_hours_table IN SYSTEM.PA_NUM_TBL_TYPE ,
108: p_prev_call_timeline_st_date IN DATE ,
109: p_prev_call_timeline_end_date IN DATE ,
110: x_call_timeline_st_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
111: x_call_timeline_end_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895

Line 130: p_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,

126: -- Parameters :
127: --
128:
129: PROCEDURE populate_work_pattern_table(
130: p_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
131: p_assgn_range_start_date IN DATE := NULL ,
132: p_assgn_range_end_date IN DATE := NULL ,
133: p_display_start_date IN DATE ,
134: p_status_code IN VARCHAR2 := NULL ,

Line 153: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE := NULL

149: ,p_mass_update_flag IN VARCHAR2 := FND_API.G_FALSE
150: ,p_exception_type_code IN VARCHAR2
151: ,p_record_version_number IN NUMBER := NULL
152: ,p_assignment_id IN NUMBER := NULL
153: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE := NULL
154: ,p_change_start_date IN DATE := NULL
155: ,p_change_end_date IN DATE := NULL
156: ,p_requirement_status_code IN VARCHAR2 := NULL
157: ,p_assignment_status_code IN VARCHAR2 := NULL

Line 178: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

174: ,p_number_of_shift IN NUMBER := NULL
175: ,p_last_row_flag IN VARCHAR2 := 'Y'
176: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
177: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
178: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
179: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
180: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
181: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
182: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 179: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

175: ,p_last_row_flag IN VARCHAR2 := 'Y'
176: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
177: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
178: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
179: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
180: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
181: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
182: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
183: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 180: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

176: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
177: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
178: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
179: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
180: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
181: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
182: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
183: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
184: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 181: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

177: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
178: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
179: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
180: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
181: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
182: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
183: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
184: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 182: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

178: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
179: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
180: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
181: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
182: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
183: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
184: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 183: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

179: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
180: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
181: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
182: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
183: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
184: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
187: ,p_called_by_proj_party IN VARCHAR2 := 'N' -- Added for Bug 6631033

Line 184: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

180: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
181: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
182: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
183: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
184: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
187: ,p_called_by_proj_party IN VARCHAR2 := 'N' -- Added for Bug 6631033
188: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 197: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

193: -- procedure : update_schedule
194: -- Purpose : Same Procedure as above bu invoked in bulk mode
195: --
196: PROCEDURE update_schedule_bulk
197: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
198: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
199: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
200: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
201: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 200: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

196: PROCEDURE update_schedule_bulk
197: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
198: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
199: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
200: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
201: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
202: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
203: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
204: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

Line 201: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

197: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
198: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
199: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
200: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
201: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
202: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
203: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
204: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
205: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 212: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

208: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
209: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
210: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
211: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
212: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
213: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE );
214:
215:
216:

Line 219: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

215:
216:
217:
218: PROCEDURE update_new_schedule_bulk
219: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
220: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
221: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
222: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
223: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 222: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

218: PROCEDURE update_new_schedule_bulk
219: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
220: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
221: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
222: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
223: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
224: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
225: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
226: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

Line 223: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

219: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
220: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
221: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
222: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
223: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
224: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
225: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
226: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
227: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 234: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

230: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
231: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
232: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
233: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
234: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
235: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
236: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
237: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
238: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 235: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

231: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
232: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
233: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
234: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
235: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
236: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
237: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
238: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
239:

Line 237: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

233: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
234: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
235: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
236: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
237: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
238: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
239:
240:
241: );

Line 290: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE

286: --
287: PROCEDURE mass_update_schedule
288: ( p_project_id IN NUMBER
289: ,p_exception_type_code IN VARCHAR2
290: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE
291: ,p_change_start_date IN DATE := NULL
292: ,p_change_end_date IN DATE := NULL
293: ,p_change_rqmt_status_code IN VARCHAR2 := NULL
294: ,p_change_asgmt_status_code IN VARCHAR2 := NULL

Line 297: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

293: ,p_change_rqmt_status_code IN VARCHAR2 := NULL
294: ,p_change_asgmt_status_code IN VARCHAR2 := NULL
295: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
296: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
297: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
298: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
299: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
300: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
301: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 298: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

294: ,p_change_asgmt_status_code IN VARCHAR2 := NULL
295: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
296: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
297: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
298: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
299: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
300: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
301: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
302: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 299: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

295: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
296: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
297: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
298: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
299: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
300: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
301: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
302: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
303: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 300: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

296: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
297: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
298: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
299: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
300: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
301: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
302: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
303: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
304: ,p_non_working_day_flag IN VARCHAR2 := 'N'

Line 301: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

297: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
298: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
299: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
300: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
301: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
302: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
303: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
304: ,p_non_working_day_flag IN VARCHAR2 := 'N'
305: ,p_change_hours_type_code IN VARCHAR2 := NULL

Line 302: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

298: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
299: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
300: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
301: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
302: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
303: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
304: ,p_non_working_day_flag IN VARCHAR2 := 'N'
305: ,p_change_hours_type_code IN VARCHAR2 := NULL
306: ,p_hrs_per_day IN NUMBER := NULL

Line 303: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

299: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
300: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
301: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
302: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
303: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
304: ,p_non_working_day_flag IN VARCHAR2 := 'N'
305: ,p_change_hours_type_code IN VARCHAR2 := NULL
306: ,p_hrs_per_day IN NUMBER := NULL
307: ,p_calendar_percent IN NUMBER := NULL

Line 317: ,x_success_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Added NOCOPY for bug#2674619 */

313: ,p_number_of_shift IN NUMBER := NULL
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
316: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
317: ,x_success_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Added NOCOPY for bug#2674619 */
318: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
319: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
320: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
321: