DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on PA_SCHEDULE_PKG

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

1818:
1819:
1820: -- Applying the changes according to their status i.e. insert,update or delete
1821: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1822: PA_SCHEDULE_PKG.Insert_Rows(l_ins_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
1823: END IF;
1824:
1825: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1826: PA_SCHEDULE_PKG.Update_Rows(l_upd_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);

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

1822: PA_SCHEDULE_PKG.Insert_Rows(l_ins_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
1823: END IF;
1824:
1825: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1826: PA_SCHEDULE_PKG.Update_Rows(l_upd_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
1827: END IF;
1828:
1829: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1830: PA_SCHEDULE_PKG.Delete_Rows(p_del_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);

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

1826: PA_SCHEDULE_PKG.Update_Rows(l_upd_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
1827: END IF;
1828:
1829: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1830: PA_SCHEDULE_PKG.Delete_Rows(p_del_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
1831: END IF;
1832:
1833: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1834: 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 2617: PA_SCHEDULE_PKG.Update_Rows(l_final_sch_rec_tab,l_x_return_status,x_msg_count,x_msg_data);

2613: l_final_sch_rec_tab(l_K).Sunday_hours := l_sunday_hours;
2614:
2615:
2616: IF (l_Merge_Flag = 'Y') THEN
2617: PA_SCHEDULE_PKG.Update_Rows(l_final_sch_rec_tab,l_x_return_status,x_msg_count,x_msg_data);
2618: PA_SCHEDULE_PKG.Delete_Rows(l_del_sch_rec_tab,l_x_return_status,x_msg_count,x_msg_data);
2619: ELSE
2620: PA_SCHEDULE_UTILS.log_message(1,'INFO: No Merging required.... ');
2621:

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

2614:
2615:
2616: IF (l_Merge_Flag = 'Y') THEN
2617: PA_SCHEDULE_PKG.Update_Rows(l_final_sch_rec_tab,l_x_return_status,x_msg_count,x_msg_data);
2618: PA_SCHEDULE_PKG.Delete_Rows(l_del_sch_rec_tab,l_x_return_status,x_msg_count,x_msg_data);
2619: ELSE
2620: PA_SCHEDULE_UTILS.log_message(1,'INFO: No Merging required.... ');
2621:
2622: END IF;

Line 3882: PA_SCHEDULE_PKG.insert_rows(l_new_schedule_tab_rec,

3878: PA_SCHEDULE_UTILS.log_message(1,'SCH_REC',l_x_schedule_tab_rec);
3879:
3880: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3881: -- Inserting the schedule in the PA_SCHEDULE table
3882: PA_SCHEDULE_PKG.insert_rows(l_new_schedule_tab_rec,
3883: l_x_return_status,
3884: x_msg_count,
3885: x_msg_data,
3886: l_total_hours -- Bug 5126919

Line 4036: PA_SCHEDULE_PKG.insert_rows(

4032: END LOOP;
4033:
4034: -- Bulk insert all the schedule records stored in l_x_sch_rec_tab.
4035: -- Inserting the schedule in the PA_SCHEDULE table
4036: PA_SCHEDULE_PKG.insert_rows(
4037: p_sch_record_tab => l_x_sch_rec_tab,
4038: x_return_status => l_x_return_status,
4039: x_msg_count => x_msg_count,
4040: x_msg_data => x_msg_data

Line 4124: PA_SCHEDULE_PKG.insert_rows(

4120: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API add_schedule_rec_tab .....');
4121: END LOOP;
4122:
4123: -- Bulk insert all the schedule records stored in l_x_sch_rec_tab.
4124: PA_SCHEDULE_PKG.insert_rows(
4125: p_sch_record_tab => l_x_sch_rec_tab,
4126: x_return_status => l_x_return_status,
4127: x_msg_count => x_msg_count,
4128: x_msg_data => x_msg_data

Line 4192: PA_SCHEDULE_PKG.insert_rows(

4188: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API add_schedule_rec_tab .....');
4189: END LOOP;
4190:
4191: -- Bulk insert all the schedule records stored in l_x_sch_rec_tab.
4192: PA_SCHEDULE_PKG.insert_rows(
4193: p_sch_record_tab => l_x_sch_rec_tab,
4194: x_return_status => l_x_return_status,
4195: x_msg_count => x_msg_count,
4196: x_msg_data => x_msg_data

Line 4458: PA_SCHEDULE_PKG.insert_rows(

4454: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API insert_rows ....');
4455:
4456: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
4457: -- Inserting the record in PA_SCHEDULES table
4458: PA_SCHEDULE_PKG.insert_rows(
4459: l_new_schedule_tab,
4460: l_x_return_status,
4461: x_msg_count,
4462: x_msg_data,

Line 5175: pa_schedule_pkg.insert_rows (

5171: x_msg_count => x_msg_count,
5172: x_msg_data => x_msg_data);
5173: end if;
5174: -- Insert row into PA_SCHEDULES
5175: pa_schedule_pkg.insert_rows (
5176: p_calendar_id => rec.calendar_id,
5177: p_assignment_id => rec.assignment_id ,
5178: p_project_id => rec.project_id ,
5179: p_schedule_type_code => rec.schedule_type_code,