DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on PA_SCHEDULE_PKG

Line 1992: PA_SCHEDULE_PKG.Insert_Rows(l_ins_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);

1988:
1989:
1990: -- Applying the changes according to their status i.e. insert,update or delete
1991: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1992: PA_SCHEDULE_PKG.Insert_Rows(l_ins_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
1993: END IF;
1994:
1995: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1996: PA_SCHEDULE_PKG.Update_Rows(l_upd_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);

Line 1996: PA_SCHEDULE_PKG.Update_Rows(l_upd_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);

1992: PA_SCHEDULE_PKG.Insert_Rows(l_ins_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
1993: END IF;
1994:
1995: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1996: PA_SCHEDULE_PKG.Update_Rows(l_upd_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
1997: END IF;
1998:
1999: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2000: PA_SCHEDULE_PKG.Delete_Rows(p_del_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);

Line 2000: PA_SCHEDULE_PKG.Delete_Rows(p_del_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);

1996: PA_SCHEDULE_PKG.Update_Rows(l_upd_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
1997: END IF;
1998:
1999: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2000: PA_SCHEDULE_PKG.Delete_Rows(p_del_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
2001: END IF;
2002:
2003: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2004: PA_SCHEDULE_PVT.merge_work_pattern(p_chg_sch_record_tab(1).project_id,p_chg_sch_record_tab(1).assignment_id,l_x_return_status,x_msg_count,x_msg_data);

Line 2829: PA_SCHEDULE_PKG.Update_Rows(l_final_sch_rec_tab,l_x_return_status,x_msg_count,x_msg_data);

2825: l_final_sch_rec_tab(l_K).Sunday_hours := l_sunday_hours;
2826:
2827:
2828: IF (l_Merge_Flag = 'Y') THEN
2829: PA_SCHEDULE_PKG.Update_Rows(l_final_sch_rec_tab,l_x_return_status,x_msg_count,x_msg_data);
2830: PA_SCHEDULE_PKG.Delete_Rows(l_del_sch_rec_tab,l_x_return_status,x_msg_count,x_msg_data);
2831: ELSE
2832: PA_SCHEDULE_UTILS.log_message(1,'INFO: No Merging required.... ');
2833:

Line 2830: PA_SCHEDULE_PKG.Delete_Rows(l_del_sch_rec_tab,l_x_return_status,x_msg_count,x_msg_data);

2826:
2827:
2828: IF (l_Merge_Flag = 'Y') THEN
2829: PA_SCHEDULE_PKG.Update_Rows(l_final_sch_rec_tab,l_x_return_status,x_msg_count,x_msg_data);
2830: PA_SCHEDULE_PKG.Delete_Rows(l_del_sch_rec_tab,l_x_return_status,x_msg_count,x_msg_data);
2831: ELSE
2832: PA_SCHEDULE_UTILS.log_message(1,'INFO: No Merging required.... ');
2833:
2834: END IF;

Line 4168: PA_SCHEDULE_PKG.insert_rows(l_new_schedule_tab_rec,

4164: PA_SCHEDULE_UTILS.log_message(1,'SCH_REC',l_x_schedule_tab_rec);
4165:
4166: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
4167: -- Inserting the schedule in the PA_SCHEDULE table
4168: PA_SCHEDULE_PKG.insert_rows(l_new_schedule_tab_rec,
4169: l_x_return_status,
4170: x_msg_count,
4171: x_msg_data,
4172: l_total_hours -- Bug 5126919

Line 4322: PA_SCHEDULE_PKG.insert_rows(

4318: END LOOP;
4319:
4320: -- Bulk insert all the schedule records stored in l_x_sch_rec_tab.
4321: -- Inserting the schedule in the PA_SCHEDULE table
4322: PA_SCHEDULE_PKG.insert_rows(
4323: p_sch_record_tab => l_x_sch_rec_tab,
4324: x_return_status => l_x_return_status,
4325: x_msg_count => x_msg_count,
4326: x_msg_data => x_msg_data

Line 4410: PA_SCHEDULE_PKG.insert_rows(

4406: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API add_schedule_rec_tab .....');
4407: END LOOP;
4408:
4409: -- Bulk insert all the schedule records stored in l_x_sch_rec_tab.
4410: PA_SCHEDULE_PKG.insert_rows(
4411: p_sch_record_tab => l_x_sch_rec_tab,
4412: x_return_status => l_x_return_status,
4413: x_msg_count => x_msg_count,
4414: x_msg_data => x_msg_data

Line 4478: PA_SCHEDULE_PKG.insert_rows(

4474: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API add_schedule_rec_tab .....');
4475: END LOOP;
4476:
4477: -- Bulk insert all the schedule records stored in l_x_sch_rec_tab.
4478: PA_SCHEDULE_PKG.insert_rows(
4479: p_sch_record_tab => l_x_sch_rec_tab,
4480: x_return_status => l_x_return_status,
4481: x_msg_count => x_msg_count,
4482: x_msg_data => x_msg_data

Line 4744: PA_SCHEDULE_PKG.insert_rows(

4740: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API insert_rows ....');
4741:
4742: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
4743: -- Inserting the record in PA_SCHEDULES table
4744: PA_SCHEDULE_PKG.insert_rows(
4745: l_new_schedule_tab,
4746: l_x_return_status,
4747: x_msg_count,
4748: x_msg_data,

Line 5461: pa_schedule_pkg.insert_rows (

5457: x_msg_count => x_msg_count,
5458: x_msg_data => x_msg_data);
5459: end if;
5460: -- Insert row into PA_SCHEDULES
5461: pa_schedule_pkg.insert_rows (
5462: p_calendar_id => rec.calendar_id,
5463: p_assignment_id => rec.assignment_id ,
5464: p_project_id => rec.project_id ,
5465: p_schedule_type_code => rec.schedule_type_code,