[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_rows (
p_sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,
p_change_id IN PA_SCHEDULE_EXCEPT_HISTORY.change_id%type,
x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS
l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
INSERT INTO PA_SCHEDULE_EXCEPT_HISTORY
( schedule_exception_id ,
calendar_id ,
assignment_id ,
project_id ,
schedule_type_code ,
status_code ,
exception_type_code ,
start_date ,
end_date ,
resource_calendar_percent ,
non_working_day_flag ,
change_hours_type_code ,
change_calendar_type_code,
change_calendar_id ,
monday_hours ,
tuesday_hours ,
wednesday_hours ,
thursday_hours ,
friday_hours ,
saturday_hours ,
sunday_hours ,
change_id ,
creation_date ,
created_by ,
last_update_date ,
last_update_by ,
last_update_login )
VALUES
( l_schedule_exception_id(l_J) ,
l_calendar_id(l_J) ,
l_assignment_id(l_J) ,
l_project_id(l_J) ,
l_schedule_type_code(l_J) ,
l_assignment_status_code(l_J) ,
l_exception_type_code(l_J) ,
l_start_date(l_J) ,
l_end_date(l_J) ,
l_resource_calendar_percent(l_J) ,
l_non_working_day_flag(l_J) ,
l_change_hours_type_code(l_J) ,
l_change_calendar_type_code(l_J),
l_change_calendar_id(l_J) ,
l_monday_hours(l_J) ,
l_tuesday_hours(l_J) ,
l_wednesday_hours(l_J) ,
l_thursday_hours(l_J) ,
l_friday_hours(l_J) ,
l_saturday_hours(l_J) ,
l_sunday_hours(l_J) ,
p_change_id ,
sysdate ,
fnd_global.user_id ,
sysdate ,
fnd_global.user_id ,
fnd_global.login_id );
p_procedure_name => 'insert_rows');
END insert_rows;
PROCEDURE insert_rows
(p_schedule_exception_id IN Number ,
p_calendar_id IN Number DEFAULT NULL ,
p_assignment_id IN Number DEFAULT NULL ,
p_project_id IN Number DEFAULT NULL ,
p_schedule_type_code IN varchar2 ,
p_assignment_status_code IN varchar2 DEFAULT NULL ,
p_exception_type_code IN varchar2 ,
p_start_date IN date ,
p_end_date IN date ,
p_resource_calendar_percent IN Number ,
p_non_working_day_flag IN varchar2 ,
p_change_hours_type_code IN varchar2 ,
p_monday_hours IN Number DEFAULT NULL ,
p_tuesday_hours IN Number DEFAULT NULL ,
p_wednesday_hours IN Number DEFAULT NULL ,
p_thursday_hours IN Number DEFAULT NULL ,
p_friday_hours IN Number DEFAULT NULL ,
p_saturday_hours IN Number DEFAULT NULL ,
p_sunday_hours IN Number DEFAULT NULL ,
p_change_id IN PA_SCHEDULE_EXCEPT_HISTORY.change_id%type ,
x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS
BEGIN
x_return_status := FND_API.G_RET_STS_SUCCESS;
INSERT INTO PA_SCHEDULE_EXCEPT_HISTORY
( schedule_exception_id ,
calendar_id ,
assignment_id ,
project_id ,
schedule_type_code ,
status_code ,
exception_type_code ,
start_date ,
end_date ,
resource_calendar_percent ,
non_working_day_flag ,
change_hours_type_code ,
monday_hours ,
tuesday_hours ,
wednesday_hours ,
thursday_hours ,
friday_hours ,
saturday_hours ,
sunday_hours ,
change_id ,
creation_date ,
created_by ,
last_update_date ,
last_update_by ,
last_update_login )
VALUES(p_schedule_exception_id ,
p_calendar_id ,
p_assignment_id ,
p_project_id ,
p_schedule_type_code ,
p_assignment_status_code ,
p_exception_type_code ,
p_start_date ,
p_end_date ,
p_resource_calendar_percent ,
p_non_working_day_flag ,
p_change_hours_type_code ,
p_monday_hours ,
p_tuesday_hours ,
p_wednesday_hours ,
p_thursday_hours ,
p_friday_hours ,
p_saturday_hours ,
p_sunday_hours ,
p_change_id ,
sysdate ,
fnd_global.user_id ,
sysdate ,
fnd_global.user_id ,
fnd_global.login_id);
p_procedure_name => 'insert_rows');
END insert_rows;