[Home] [Help]
PACKAGE: APPS.PA_SCH_EXCEPT_HIST_PKG
Source
1 PACKAGE PA_SCH_EXCEPT_HIST_PKG AUTHID CURRENT_USER as
2 /* $Header: PARGHISS.pls 120.1 2005/08/19 16:53:09 mwasowic noship $ */
3
4
5 PROCEDURE insert_rows (
6 p_sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,
7 p_change_id IN PA_SCHEDULE_EXCEPT_HISTORY.change_id%type,
8 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
10 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
11
12 --
13 -- Procedure : Insert_rows
14 -- Purpose : Create Rows in PA_SCHEDULE_EXCEPT_HISTORY in
15 -- array processing. This overloaded function.
16 -- Parameters :
17 -- p_sch_record_tab - Table of schedule details Records
18
19 PROCEDURE insert_rows
20 ( p_schedule_exception_id IN Number ,
21 p_calendar_id IN Number DEFAULT NULL ,
22 p_assignment_id IN Number DEFAULT NULL ,
23 p_project_id IN Number DEFAULT NULL ,
24 p_schedule_type_code IN varchar2 ,
25 p_assignment_status_code IN varchar2 DEFAULT NULL ,
26 p_exception_type_code IN varchar2 ,
27 p_start_date IN date ,
28 p_end_date IN date ,
29 p_resource_calendar_percent IN Number ,
30 p_non_working_day_flag IN varchar2 ,
31 p_change_hours_type_code IN varchar2 ,
32 p_monday_hours IN Number DEFAULT NULL ,
33 p_tuesday_hours IN Number DEFAULT NULL ,
34 p_wednesday_hours IN Number DEFAULT NULL ,
35 p_thursday_hours IN Number DEFAULT NULL ,
36 p_friday_hours IN Number DEFAULT NULL ,
37 p_saturday_hours IN Number DEFAULT NULL ,
38 p_sunday_hours IN Number DEFAULT NULL ,
39 p_change_id IN PA_SCHEDULE_EXCEPT_HISTORY.change_id%type ,
40 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
41 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
42 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
43
44 --
45 -- Procedure : Insert_rows
46 -- Purpose : Create Rows in PA_SCHEDULE_EXCEPT_HISTORY with scalar data types.
47 -- This overloaded function.
48 -- Parameters :
49 -- p_sch_record_tab - Table of schedule details Records
50
51
52 END PA_SCH_EXCEPT_HIST_PKG;