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.

[Home] [Help]

APPS.PA_SCHEDULE_PUB dependencies on FND_API

Line 149: ,p_mass_update_flag IN VARCHAR2 := FND_API.G_FALSE

145: -- It can accept either one assignment ID or an assignment ID array.
146: --
147: PROCEDURE update_schedule
148: ( p_project_id IN NUMBER
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

Line 185: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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
189: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 186: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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
189: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
190: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 198: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE

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
202: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL

Line 208: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE

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
206: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
207: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
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

Line 209: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE

205: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
206: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
207: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
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 );

Line 220: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE

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
224: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL

Line 230: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE

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
228: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
229: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
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

Line 231: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE

227: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
228: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
229: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
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

Line 274: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

270: ,p_duration_shift_type_code IN VARCHAR2 := NULL
271: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
272: ,p_number_of_shift IN NUMBER := NULL
273: ,p_last_row_flag IN VARCHAR2 := 'Y'
274: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
275: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
276: ,p_called_by_proj_party IN VARCHAR2 := 'N' -- Added for Bug 6631033
277: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
278: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 275: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

271: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
272: ,p_number_of_shift IN NUMBER := NULL
273: ,p_last_row_flag IN VARCHAR2 := 'Y'
274: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
275: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
276: ,p_called_by_proj_party IN VARCHAR2 := 'N' -- Added for Bug 6631033
277: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
278: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
279: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

310: ,p_change_calendar_id IN NUMBER := NULL
311: ,p_duration_shift_type_code IN VARCHAR2 := NULL
312: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
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

Line 315: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

311: ,p_duration_shift_type_code IN VARCHAR2 := NULL
312: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
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

Line 316: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

312: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
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

Line 344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

340: p_asgn_end_date IN DATE := NULL,
341: p_duration_shift_type_code IN Varchar2 := NULL,
342: p_duration_shift_unit_code IN VARCHAR2 := NULL,
343: p_number_of_shift IN Varchar2 := NULL,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345: p_generate_timeline_flag IN VARCHAR2 := 'Y', --Unilog
346: p_called_by_proj_party IN VARCHAR2 := 'N', -- Added for Bug 6631033
347: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
348: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 376: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

372: -- p_change_calendar_name IN VARCHAR2 ,
373: p_change_calendar_id IN VARCHAR2 ,
374: p_asgn_start_date IN DATE ,
375: p_asgn_end_date IN DATE ,
376: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
377: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
378: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
379: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
380:

Line 405: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

401: p_saturday_hours IN Number := NULL,
402: p_sunday_hours IN Number := NULL,
403: p_asgn_start_date IN DATE ,
404: p_asgn_end_date IN DATE ,
405: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
406: p_remove_conflict_flag IN VARCHAR2 := 'N',
407: p_last_row_flag IN VARCHAR2 := 'Y',
408: p_generate_timeline_flag IN VARCHAR2 := 'Y', --Unilog
409: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 432: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

428: p_end_date IN date ,
429: p_assignment_status_code IN Varchar2 ,
430: p_asgn_start_date IN DATE ,
431: p_asgn_end_date IN DATE ,
432: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
433: p_save_to_hist IN VARCHAR2 := FND_API.G_TRUE,
434: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
435: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
436: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 433: p_save_to_hist IN VARCHAR2 := FND_API.G_TRUE,

429: p_assignment_status_code IN Varchar2 ,
430: p_asgn_start_date IN DATE ,
431: p_asgn_end_date IN DATE ,
432: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
433: p_save_to_hist IN VARCHAR2 := FND_API.G_TRUE,
434: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
435: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
436: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
437:

Line 475: p_save_to_hist IN VARCHAR2 := FND_API.G_TRUE,

471: p_record_version_number IN Number,
472: p_assignment_id IN NUMBER,
473: p_project_id IN NUMBER,
474: p_exception_id IN NUMBER,
475: p_save_to_hist IN VARCHAR2 := FND_API.G_TRUE,
476: p_remove_conflict_flag IN VARCHAR2 := 'N',
477: p_generate_timeline_flag IN VARCHAR2 := 'Y', --Unilog
478: p_called_by_proj_party IN VARCHAR2 := 'N', -- Added for Bug 6631033
479: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895