DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PUB dependencies on FND_API

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

138: -- It can accept either one assignment ID or an assignment ID array.
139: --
140: PROCEDURE update_schedule
141: ( p_project_id IN NUMBER
142: ,p_mass_update_flag IN VARCHAR2 := FND_API.G_FALSE
143: ,p_exception_type_code IN VARCHAR2
144: ,p_record_version_number IN NUMBER := NULL
145: ,p_assignment_id IN NUMBER := NULL
146: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

174: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
175: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
176: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
177: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
180: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
181: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
182: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

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

175: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
176: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
177: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
180: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
181: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
182: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
183:

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

211: ,p_duration_shift_type_code IN VARCHAR2 := NULL
212: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
213: ,p_number_of_shift IN NUMBER := NULL
214: ,p_last_row_flag IN VARCHAR2 := 'Y'
215: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
216: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
217: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
218: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
219: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

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

212: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
213: ,p_number_of_shift IN NUMBER := NULL
214: ,p_last_row_flag IN VARCHAR2 := 'Y'
215: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
216: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
217: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
218: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
219: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
220:

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

250: ,p_change_calendar_id IN NUMBER := NULL
251: ,p_duration_shift_type_code IN VARCHAR2 := NULL
252: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
253: ,p_number_of_shift IN NUMBER := NULL
254: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
255: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
256: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
257: ,x_success_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Added NOCOPY for bug#2674619 */
258: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

251: ,p_duration_shift_type_code IN VARCHAR2 := NULL
252: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
253: ,p_number_of_shift IN NUMBER := NULL
254: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
255: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
256: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
257: ,x_success_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Added NOCOPY for bug#2674619 */
258: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
259: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

252: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
253: ,p_number_of_shift IN NUMBER := NULL
254: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
255: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
256: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
257: ,x_success_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Added NOCOPY for bug#2674619 */
258: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
259: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
260: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

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

280: p_asgn_end_date IN DATE := NULL,
281: p_duration_shift_type_code IN Varchar2 := NULL,
282: p_duration_shift_unit_code IN VARCHAR2 := NULL,
283: p_number_of_shift IN Varchar2 := NULL,
284: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285: p_generate_timeline_flag IN VARCHAR2 := 'Y', --Unilog
286: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
287: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
288: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

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

311: -- p_change_calendar_name IN VARCHAR2 ,
312: p_change_calendar_id IN VARCHAR2 ,
313: p_asgn_start_date IN DATE ,
314: p_asgn_end_date IN DATE ,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
317: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
318: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
319:

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

340: p_saturday_hours IN Number := NULL,
341: p_sunday_hours IN Number := NULL,
342: p_asgn_start_date IN DATE ,
343: p_asgn_end_date IN DATE ,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345: p_remove_conflict_flag IN VARCHAR2 := 'N',
346: p_last_row_flag IN VARCHAR2 := 'Y',
347: p_generate_timeline_flag IN VARCHAR2 := 'Y', --Unilog
348: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

367: p_end_date IN date ,
368: p_assignment_status_code IN Varchar2 ,
369: p_asgn_start_date IN DATE ,
370: p_asgn_end_date IN DATE ,
371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
372: p_save_to_hist IN VARCHAR2 := FND_API.G_TRUE,
373: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
374: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
375: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

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

368: p_assignment_status_code IN Varchar2 ,
369: p_asgn_start_date IN DATE ,
370: p_asgn_end_date IN DATE ,
371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
372: p_save_to_hist IN VARCHAR2 := FND_API.G_TRUE,
373: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
374: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
375: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
376:

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

410: p_record_version_number IN Number,
411: p_assignment_id IN NUMBER,
412: p_project_id IN NUMBER,
413: p_exception_id IN NUMBER,
414: p_save_to_hist IN VARCHAR2 := FND_API.G_TRUE,
415: p_remove_conflict_flag IN VARCHAR2 := 'N',
416: p_generate_timeline_flag IN VARCHAR2 := 'Y', --Unilog
417: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
418: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895