DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PKG dependencies on PA_SCHEDULE_GLOB

Line 32: PROCEDURE insert_rows ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

28: --
29: --Bug 5126919: Added parameter p_total_hours. This will contain the total hours for
30: --which the schedule should be created. This will be used to make sure that schedule is created
31: --correctly (for the whole p_total_hours) even after rounding.
32: PROCEDURE insert_rows ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
33: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
34: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
35: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
36: p_total_hours IN NUMBER DEFAULT NULL) --Bug 5126919

Line 75: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;

71: l_temp_date DATE;
72: l_temp_day VARCHAR2(10);
73:
74: --Added for bug Bug 5684828
75: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
76: l_out_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
77: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;
78:
79: --Added for bug 5856987

Line 76: l_out_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

72: l_temp_day VARCHAR2(10);
73:
74: --Added for bug Bug 5684828
75: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
76: l_out_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
77: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;
78:
79: --Added for bug 5856987
80: K NUMBER;

Line 709: PROCEDURE update_rows ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

705: -- Parameters Type Required Description
706: -- P_Sch_Record_Tab ScheduleTabTyp YES It contains the schedule record
707: --
708:
709: PROCEDURE update_rows ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
710: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
711: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
712: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
713: IS

Line 956: PROCEDURE delete_rows ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

952: -- Parameters Type Required Description
953: -- P_Sch_Record_Tab ScheduleTabTyp YES It contains the schedule record
954: --
955:
956: PROCEDURE delete_rows ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
957: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
958: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
959: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
960: IS