DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on PA_SCHEDULE_GLOB

Line 38: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

34: PROCEDURE get_existing_schedule ( p_calendar_id IN NUMBER,
35: p_assignment_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_difference_days IN NUMBER,
40: x_shift_unit_code IN VARCHAR2,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,

Line 48: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

44:
45: PROCEDURE get_calendar_schedule ( p_calendar_id IN NUMBER,
46: p_start_date IN DATE,
47: p_end_date IN DATE,
48: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
49: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
50: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
51: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
52:

Line 63: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

59:
60: PROCEDURE get_assignment_schedule ( p_assignment_id IN NUMBER,
61: p_start_date IN DATE,
62: p_end_date IN DATE,
63: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
64: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
65: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
66: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
67:

Line 76: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

72: --
73:
74:
75: PROCEDURE get_assignment_schedule ( p_assignment_id IN NUMBER,
76: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
77: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
78: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
79: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
80:

Line 91: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

87: PROCEDURE get_resource_schedule ( p_source_id IN NUMBER,
88: p_source_type IN VARCHAR2,
89: p_start_date IN DATE,
90: p_end_date IN DATE,
91: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
92: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
93: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
94: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
95: --

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

97: -- Purpose : Gets schedule details for project resource.
98: -- Parameters :
99: --
100:
101: PROCEDURE apply_schedule_change( p_chg_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
102: p_del_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
103: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
104: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
105: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 102: p_del_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

98: -- Parameters :
99: --
100:
101: PROCEDURE apply_schedule_change( p_chg_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
102: p_del_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
103: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
104: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
105: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
106:

Line 115: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

111: -- Parameters :
112: --
113:
114: PROCEDURE create_new_schedule(
115: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
116: p_sch_record IN pa_schedule_glob.ScheduleRecord,
117: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
118: x_difference_days IN NUMBER, /* Added for 7663765 */
119: x_shift_unit_code IN VARCHAR2, /* Added for 7663765 */

Line 116: p_sch_record IN pa_schedule_glob.ScheduleRecord,

112: --
113:
114: PROCEDURE create_new_schedule(
115: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
116: p_sch_record IN pa_schedule_glob.ScheduleRecord,
117: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
118: x_difference_days IN NUMBER, /* Added for 7663765 */
119: x_shift_unit_code IN VARCHAR2, /* Added for 7663765 */
120: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 117: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

113:
114: PROCEDURE create_new_schedule(
115: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
116: p_sch_record IN pa_schedule_glob.ScheduleRecord,
117: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
118: x_difference_days IN NUMBER, /* Added for 7663765 */
119: x_shift_unit_code IN VARCHAR2, /* Added for 7663765 */
120: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
121: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 131: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

127: -- Parameters :
128: --
129:
130: PROCEDURE create_new_calendar(
131: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
132: p_sch_record IN pa_schedule_glob.ScheduleRecord,
133: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
134: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
135: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 132: p_sch_record IN pa_schedule_glob.ScheduleRecord,

128: --
129:
130: PROCEDURE create_new_calendar(
131: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
132: p_sch_record IN pa_schedule_glob.ScheduleRecord,
133: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
134: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
135: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
136: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 133: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

129:
130: PROCEDURE create_new_calendar(
131: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
132: p_sch_record IN pa_schedule_glob.ScheduleRecord,
133: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
134: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
135: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
136: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
137: );

Line 147: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

143: --
144:
145:
146: PROCEDURE create_new_hours(
147: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
148: p_sch_record IN pa_schedule_glob.ScheduleRecord,
149: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
150: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
151: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 148: p_sch_record IN pa_schedule_glob.ScheduleRecord,

144:
145:
146: PROCEDURE create_new_hours(
147: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
148: p_sch_record IN pa_schedule_glob.ScheduleRecord,
149: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
150: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
151: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
152: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 149: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

145:
146: PROCEDURE create_new_hours(
147: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
148: p_sch_record IN pa_schedule_glob.ScheduleRecord,
149: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
150: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
151: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
152: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
153: );

Line 163: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

159: --
160:
161:
162: PROCEDURE create_new_duration(
163: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
164: p_sch_record IN pa_schedule_glob.ScheduleRecord,
165: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
166: x_difference_days IN NUMBER, /* Added for 7663765 */
167: x_shift_unit_code IN VARCHAR2, /* Added for 7663765 */

Line 164: p_sch_record IN pa_schedule_glob.ScheduleRecord,

160:
161:
162: PROCEDURE create_new_duration(
163: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
164: p_sch_record IN pa_schedule_glob.ScheduleRecord,
165: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
166: x_difference_days IN NUMBER, /* Added for 7663765 */
167: x_shift_unit_code IN VARCHAR2, /* Added for 7663765 */
168: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 165: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

161:
162: PROCEDURE create_new_duration(
163: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
164: p_sch_record IN pa_schedule_glob.ScheduleRecord,
165: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
166: x_difference_days IN NUMBER, /* Added for 7663765 */
167: x_shift_unit_code IN VARCHAR2, /* Added for 7663765 */
168: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
169: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 180: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

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

Line 181: p_sch_record IN pa_schedule_glob.ScheduleRecord,

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

Line 182: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

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

Line 195: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

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

Line 196: p_sch_record IN pa_schedule_glob.ScheduleRecord,

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

Line 197: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

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

Line 210: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,

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

Line 211: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

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

Line 212: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

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

Line 223: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,

219: -- Parameters :
220: --
221:
222: PROCEDURE apply_other_changes (
223: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
224: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
225: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
226: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
227: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 224: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

220: --
221:
222: PROCEDURE apply_other_changes (
223: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
224: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
225: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
226: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
227: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
228: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 225: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

221:
222: PROCEDURE apply_other_changes (
223: p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
224: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
225: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
226: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
227: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
228: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
229: --

Line 237: chg_tr_sch_rec_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

233: --
234:
235: PROCEDURE apply_assignment_change (
236: p_record_version_number IN NUMBER,
237: chg_tr_sch_rec_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
238: sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,
239: p_called_by_proj_party IN VARCHAR2 := 'N', -- Added for Bug 6631033
240: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
241: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 238: sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,

234:
235: PROCEDURE apply_assignment_change (
236: p_record_version_number IN NUMBER,
237: chg_tr_sch_rec_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
238: sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,
239: p_called_by_proj_party IN VARCHAR2 := 'N', -- Added for Bug 6631033
240: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
241: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
242: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 595: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,

591: --Bug 5126919: Added parameter x_total_hours which will contain the total hours for which the x_schedule_tbl
592: --will be prepared.
593: PROCEDURE sum_task_assignments (
594: p_task_assignments_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
595: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,
596: p_start_date IN DATE ,
597: p_end_date IN DATE ,
598: x_total_hours OUT NOCOPY NUMBER , -- Bug 5126919
599: x_schedule_tbl OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp , --File.Sql.39 bug 4440895

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

595: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,
596: p_start_date IN DATE ,
597: p_end_date IN DATE ,
598: x_total_hours OUT NOCOPY NUMBER , -- Bug 5126919
599: x_schedule_tbl OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp , --File.Sql.39 bug 4440895
600: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
601: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
602: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
603: );

Line 609: p_schedule_record IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleRecord ,

605: -- Procedure : set_hours_by_day_of_wee
606: -- Purpose : sets the number of hours in a given schedule record for a particular
607: -- day of the week
608: PROCEDURE set_hours_by_day_of_week (
609: p_schedule_record IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleRecord ,
610: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType ,
611: p_hours IN NUMBER);
612:
613: -- Function : Get_changed_item_name_text

Line 715: p_schedule_record IN PA_SCHEDULE_GLOB.ScheduleRecord ,

711: -- Function : check_self_conflict_exist
712: -- Purpose : Returns the number of hours in a given schedule record for a
713: -- particular day of the week
714: FUNCTION get_hours_by_day_of_week (
715: p_schedule_record IN PA_SCHEDULE_GLOB.ScheduleRecord ,
716: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType )
717: RETURN NUMBER;
718:
719: END PA_SCHEDULE_PVT;