eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on PA_SCHEDULE_GLOB

Line 38: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

34:
35: PROCEDURE get_calendar_schedule ( p_calendar_id IN NUMBER,
36: p_start_date IN DATE,
37: p_end_date IN DATE,
38: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
39: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
40: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
41: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
42:

Line 53: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

49:
50: PROCEDURE get_assignment_schedule ( p_assignment_id IN NUMBER,
51: p_start_date IN DATE,
52: p_end_date IN DATE,
53: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
54: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
55: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
56: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
57:

Line 66: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

62: --
63:
64:
65: PROCEDURE get_assignment_schedule ( p_assignment_id IN NUMBER,
66: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
67: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
68: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
69: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
70:

Line 81: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

77: PROCEDURE get_resource_schedule ( p_source_id IN NUMBER,
78: p_source_type IN VARCHAR2,
79: p_start_date IN DATE,
80: p_end_date IN DATE,
81: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
82: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
83: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
84: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
85: --

Line 91: PROCEDURE apply_schedule_change( p_chg_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

87: -- Purpose : Gets schedule details for project resource.
88: -- Parameters :
89: --
90:
91: PROCEDURE apply_schedule_change( p_chg_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
92: p_del_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
93: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
94: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
95: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 92: p_del_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

88: -- Parameters :
89: --
90:
91: PROCEDURE apply_schedule_change( p_chg_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
92: p_del_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
93: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
94: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
95: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
96:

Line 105: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

101: -- Parameters :
102: --
103:
104: PROCEDURE create_new_schedule(
105: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
106: p_sch_record IN pa_schedule_glob.ScheduleRecord,
107: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
108: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
109: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 106: p_sch_record IN pa_schedule_glob.ScheduleRecord,

102: --
103:
104: PROCEDURE create_new_schedule(
105: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
106: p_sch_record IN pa_schedule_glob.ScheduleRecord,
107: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
108: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
109: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
110: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 107: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

103:
104: PROCEDURE create_new_schedule(
105: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
106: p_sch_record IN pa_schedule_glob.ScheduleRecord,
107: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
108: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
109: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
110: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
111: );

Line 119: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

115: -- Parameters :
116: --
117:
118: PROCEDURE create_new_calendar(
119: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
120: p_sch_record IN pa_schedule_glob.ScheduleRecord,
121: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
122: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
123: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 120: p_sch_record IN pa_schedule_glob.ScheduleRecord,

116: --
117:
118: PROCEDURE create_new_calendar(
119: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
120: p_sch_record IN pa_schedule_glob.ScheduleRecord,
121: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
122: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
123: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
124: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 121: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

117:
118: PROCEDURE create_new_calendar(
119: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
120: p_sch_record IN pa_schedule_glob.ScheduleRecord,
121: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
122: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
123: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
124: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
125: );

Line 135: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

131: --
132:
133:
134: PROCEDURE create_new_hours(
135: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
136: p_sch_record IN pa_schedule_glob.ScheduleRecord,
137: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
138: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
139: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 136: p_sch_record IN pa_schedule_glob.ScheduleRecord,

132:
133:
134: PROCEDURE create_new_hours(
135: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
136: p_sch_record IN pa_schedule_glob.ScheduleRecord,
137: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
138: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
139: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
140: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 137: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

133:
134: PROCEDURE create_new_hours(
135: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
136: p_sch_record IN pa_schedule_glob.ScheduleRecord,
137: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
138: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
139: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
140: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
141: );

Line 151: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

147: --
148:
149:
150: PROCEDURE create_new_duration(
151: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
152: p_sch_record IN pa_schedule_glob.ScheduleRecord,
153: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
154: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
155: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 152: p_sch_record IN pa_schedule_glob.ScheduleRecord,

148:
149:
150: PROCEDURE create_new_duration(
151: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
152: p_sch_record IN pa_schedule_glob.ScheduleRecord,
153: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
154: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
155: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
156: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 153: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

149:
150: PROCEDURE create_new_duration(
151: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
152: p_sch_record IN pa_schedule_glob.ScheduleRecord,
153: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
154: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
155: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
156: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
157: );

Line 166: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

162: -- Parameters :
163: --
164:
165: PROCEDURE create_new_pattern(
166: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
167: p_sch_record IN pa_schedule_glob.ScheduleRecord,
168: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
169: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
170: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 167: p_sch_record IN pa_schedule_glob.ScheduleRecord,

163: --
164:
165: PROCEDURE create_new_pattern(
166: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
167: p_sch_record IN pa_schedule_glob.ScheduleRecord,
168: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
169: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
170: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
171: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 168: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

164:
165: PROCEDURE create_new_pattern(
166: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
167: p_sch_record IN pa_schedule_glob.ScheduleRecord,
168: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
169: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
170: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
171: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
172: );

Line 181: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

177: -- Parameters :
178: --
179:
180: PROCEDURE create_new_status(
181: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
182: p_sch_record IN pa_schedule_glob.ScheduleRecord,
183: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
184: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
185: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 182: p_sch_record IN pa_schedule_glob.ScheduleRecord,

178: --
179:
180: PROCEDURE create_new_status(
181: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
182: p_sch_record IN pa_schedule_glob.ScheduleRecord,
183: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
184: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
185: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
186: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 183: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

179:
180: PROCEDURE create_new_status(
181: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
182: p_sch_record IN pa_schedule_glob.ScheduleRecord,
183: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
184: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
185: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
186: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
187: );

Line 196: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,

192: -- Parameters :
193: --
194:
195: PROCEDURE apply_change_duration (
196: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
197: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
198: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
199: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
200: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 197: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

193: --
194:
195: PROCEDURE apply_change_duration (
196: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
197: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
198: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
199: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
200: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
201: x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895

Line 198: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

194:
195: PROCEDURE apply_change_duration (
196: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
197: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
198: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
199: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
200: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
201: x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
202: --

Line 209: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,

205: -- Parameters :
206: --
207:
208: PROCEDURE apply_other_changes (
209: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
210: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
211: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
212: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
213: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 210: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

206: --
207:
208: PROCEDURE apply_other_changes (
209: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
210: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
211: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
212: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
213: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
214: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 211: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

207:
208: PROCEDURE apply_other_changes (
209: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
210: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
211: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
212: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
213: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
214: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
215: --

Line 223: chg_tr_sch_rec_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

219: --
220:
221: PROCEDURE apply_assignment_change (
222: p_record_version_number IN NUMBER,
223: chg_tr_sch_rec_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
224: sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,
225: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
226: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
227: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 224: sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,

220:
221: PROCEDURE apply_assignment_change (
222: p_record_version_number IN NUMBER,
223: chg_tr_sch_rec_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
224: sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,
225: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
226: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
227: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
228: --

Line 580: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,

576: --Bug 5126919: Added parameter x_total_hours which will contain the total hours for which the x_schedule_tbl
577: --will be prepared.
578: PROCEDURE sum_task_assignments (
579: p_task_assignments_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
580: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,
581: p_start_date IN DATE ,
582: p_end_date IN DATE ,
583: x_total_hours OUT NOCOPY NUMBER , -- Bug 5126919
584: x_schedule_tbl OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp , --File.Sql.39 bug 4440895

Line 584: x_schedule_tbl OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp , --File.Sql.39 bug 4440895

580: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,
581: p_start_date IN DATE ,
582: p_end_date IN DATE ,
583: x_total_hours OUT NOCOPY NUMBER , -- Bug 5126919
584: x_schedule_tbl OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp , --File.Sql.39 bug 4440895
585: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
586: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
587: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
588: );

Line 594: p_schedule_record IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleRecord ,

590: -- Procedure : set_hours_by_day_of_wee
591: -- Purpose : sets the number of hours in a given schedule record for a particular
592: -- day of the week
593: PROCEDURE set_hours_by_day_of_week (
594: p_schedule_record IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleRecord ,
595: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType ,
596: p_hours IN NUMBER);
597:
598: -- Function : Get_changed_item_name_text

Line 700: p_schedule_record IN PA_SCHEDULE_GLOB.ScheduleRecord ,

696: -- Function : check_self_conflict_exist
697: -- Purpose : Returns the number of hours in a given schedule record for a
698: -- particular day of the week
699: FUNCTION get_hours_by_day_of_week (
700: p_schedule_record IN PA_SCHEDULE_GLOB.ScheduleRecord ,
701: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType )
702: RETURN NUMBER;
703:
704: END PA_SCHEDULE_PVT;