[Home] [Help]
8: IS
9: l_nextval NUMBER;
10: BEGIN
11:
12: SELECT pa_schedules_s.nextval
13: INTO l_nextval
14: FROM SYS.DUAL;
15:
16: RETURN(l_nextval);
20: THEN
21: RAISE;
22: END get_nextval;
23:
24: -- This procedure will insert the record in pa_schedules table
25: -- Input parameters
26: -- Parameters Type Required Description
27: -- P_Sch_Record_Tab ScheduleTabTyp YES It contains the schedule record
28: --
518: END IF;--IF p_total_hours > l_rounded_total THEN
519:
520: --FORALL J IN p_sch_record_tab.first..p_sch_record_tab.last -- Commented for Bug 5126919
521: FORALL J IN l_schedule_id.first..l_schedule_id.last -- Added for Bug 5126919
522: INSERT INTO PA_SCHEDULES
523: ( schedule_id ,
524: calendar_id ,
525: assignment_id ,
526: project_id ,
589:
590: PA_SCHEDULE_UTILS.log_message(1,'ERROR ....'||sqlerrm);
591: END insert_rows;
592:
593: -- This procedure will insert the record in pa_schedules table
594: -- Input parameters
595: -- Parameters Type Required Description
596: -- P_Calendar_Id NUMBER YES Id for that calendar which is associated to this assignment
597: -- P_Assignment_Id NUMBER YES Assignment id of the schedule records
634: -- l_t_schedule_id := get_nextval;
635:
636: x_return_status := FND_API.G_RET_STS_SUCCESS;
637:
638: INSERT INTO PA_SCHEDULES
639: ( schedule_id ,
640: calendar_id ,
641: assignment_id ,
642: project_id ,
663: program_id ,
664: program_update_date )
665: VALUES
666: -- ( l_t_schedule_id ,
667: (pa_schedules_s.nextval,
668: p_calendar_id ,
669: p_assignment_id ,
670: p_project_id ,
671: p_schedule_type_code ,
699: raise;
700:
701: END insert_rows;
702:
703: -- This procedure will update the record in pa_schedules table
704: -- Input parameters
705: -- Parameters Type Required Description
706: -- P_Sch_Record_Tab ScheduleTabTyp YES It contains the schedule record
707: --
761: PA_SCHEDULE_UTILS.log_message(1,' J '||to_char(J)||' l_sch_id '||to_char(l_schedule_id(J))||'start_date '|| to_char(l_start_date(J)));
762: END LOOP;
763:
764: FORALL J IN p_sch_record_tab.first..p_sch_record_tab.last
765: UPDATE PA_SCHEDULES
766: SET
767: calendar_id = l_calendar_id(J),
768: assignment_id = l_assignment_id(J),
769: project_id = l_project_id(J),
797:
798: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update row '||sqlerrm);
799: END update_rows;
800:
801: -- This procedure will update the record in pa_schedules table
802: -- Input parameters
803: -- Parameters Type Required Description
804: -- P_Schedule_Id NUMBER YES Id for the corresponding schedule
805: -- P_Calendar_Id NUMBER YES Id for that calendar which is associated to this assignmen
840: IS
841: BEGIN
842:
843: x_return_status := FND_API.G_RET_STS_SUCCESS;
844: UPDATE PA_SCHEDULES
845: SET
846: calendar_id = p_calendar_id,
847: assignment_id = p_assignment_id,
848: project_id = p_project_id,
871: raise;
872:
873: END update_rows;
874:
875: -- This procedure will update the record in pa_schedules table
876: -- Input parameters
877: -- Parameters Type Required Description
878: -- P_Schrowid ROWID YES Row id for the corresponding schedule row
879: -- P_Calendar_Id NUMBER YES Id for that calendar which is associated to this assignmen
915: IS
916: BEGIN
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918:
919: UPDATE PA_SCHEDULES
920: SET
921: calendar_id = p_calendar_id,
922: assignment_id = p_assignment_id,
923: project_id = p_project_id,
946: raise;
947:
948: END update_rows;
949:
950: -- This procedure will delete the record in pa_schedules table
951: -- Input parameters
952: -- Parameters Type Required Description
953: -- P_Sch_Record_Tab ScheduleTabTyp YES It contains the schedule record
954: --
975:
976: END LOOP;
977:
978: FORALL J IN l_schedule_id.first..l_schedule_id.last
979: DELETE FROM PA_SCHEDULES WHERE schedule_id = l_schedule_id(J);
980:
981: PA_SCHEDULE_UTILS.log_message(1,'end of the delete row ..... ');
982: EXCEPTION
983: WHEN l_empty_tab_record THEN
990:
991: PA_SCHEDULE_UTILS.log_message(1,'ERROR in the delete row ..... '||sqlerrm);
992: END delete_rows;
993:
994: -- This procedure will delete the record in pa_schedules table
995: -- Input parameters
996: -- Parameters Type Required Description
997: -- P_Schedule_Id NUMBER YES Schedule id for deletion
998: --
1006: BEGIN
1007: x_return_status := FND_API.G_RET_STS_SUCCESS;
1008:
1009: DELETE
1010: FROM PA_SCHEDULES
1011: WHERE schedule_id = p_schedule_id;
1012:
1013: EXCEPTION
1014: WHEN OTHERS THEN
1018: raise;
1019:
1020: END delete_rows;
1021:
1022: -- This procedure will delete the record in pa_schedules table
1023: -- Input parameters
1024: -- Parameters Type Required Description
1025: -- P_Schrowid ROWID YES rowid of the schedule record for deletion
1026: --
1034: BEGIN
1035: x_return_status := FND_API.G_RET_STS_SUCCESS;
1036:
1037: DELETE
1038: FROM PA_SCHEDULES
1039: WHERE rowid = p_schrowid ;
1040:
1041: EXCEPTION
1042: WHEN OTHERS THEN