DBA Data[Home] [Help]

APPS.PA_SCH_EXCEPT_HIST_PKG dependencies on PA_SCHEDULE_EXCEPT_HISTORY

Line 7: p_change_id IN PA_SCHEDULE_EXCEPT_HISTORY.change_id%type,

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:

Line 14: -- Purpose : Create Rows in PA_SCHEDULE_EXCEPT_HISTORY in

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:

Line 39: p_change_id IN PA_SCHEDULE_EXCEPT_HISTORY.change_id%type ,

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:

Line 46: -- Purpose : Create Rows in PA_SCHEDULE_EXCEPT_HISTORY with scalar data types.

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: