APPS.PA_SCH_EXCEPT_HIST_PKG dependencies on PA_SCHEDULE_EXCEPT_HISTORY

Line 6: -- This procedure will insert the record in pa_schedule_except_history

2: /* $Header: PARGHISB.pls 120.1 2005/08/19 16:53:04 mwasowic noship $*/
3:
4: l_empty_tab_record EXCEPTION; -- Variable to raise the exception if the passing table of records is empty
5:
6: -- This procedure will insert the record in pa_schedule_except_history
7: -- Input parameters
8: -- Parameters Type Required Description
9: -- P_Sch_Except_Record_Tab SchExceptTabTyp YES It contains the exception record
10: --

Line 14: p_change_id IN PA_SCHEDULE_EXCEPT_HISTORY.change_id%type,

10: --
11:
12: PROCEDURE insert_rows (
13: p_sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,
14: p_change_id IN PA_SCHEDULE_EXCEPT_HISTORY.change_id%type,
15: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
16: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
17: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
18: IS

Line 80: INSERT INTO PA_SCHEDULE_EXCEPT_HISTORY

76: END LOOP;
77:
78:
79: FORALL l_J IN p_sch_except_record_tab.first..p_sch_except_record_tab.last
80: INSERT INTO PA_SCHEDULE_EXCEPT_HISTORY
81: ( schedule_exception_id ,
82: calendar_id ,
83: assignment_id ,
84: project_id ,

Line 148: -- This procedure will insert the record in pa_schedule_except_history

144: raise;
145:
146: END insert_rows;
147:
148: -- This procedure will insert the record in pa_schedule_except_history
149: -- Input parameters
150: -- Parameters Type Required Description
151: -- P_Schedule_Exception_Id NUMBER YES Id for the exception record in schedule
152: -- P_Calendar_Id NUMBER YES Id for that calendar which is associated to this assignment

Line 194: p_change_id IN PA_SCHEDULE_EXCEPT_HISTORY.change_id%type ,

190: p_thursday_hours IN Number DEFAULT NULL ,
191: p_friday_hours IN Number DEFAULT NULL ,
192: p_saturday_hours IN Number DEFAULT NULL ,
193: p_sunday_hours IN Number DEFAULT NULL ,
194: p_change_id IN PA_SCHEDULE_EXCEPT_HISTORY.change_id%type ,
195: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
196: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
197: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
198: IS

Line 204: INSERT INTO PA_SCHEDULE_EXCEPT_HISTORY

200: BEGIN
201:
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204: INSERT INTO PA_SCHEDULE_EXCEPT_HISTORY
205: ( schedule_exception_id ,
206: calendar_id ,
207: assignment_id ,
208: project_id ,