DBA Data[Home] [Help]

APPS.PA_SCHEDULE_UTILS dependencies on PA_SCHEDULE_GLOB

Line 18: PROCEDURE copy_schedule_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

14: -- In Out parameters
15: -- X_Sch_Record_Tab ScheduleTabTyp YES It stores the copied scheduled records
16: --
17:
18: PROCEDURE copy_schedule_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
19: p_start_id IN NUMBER,
20: p_end_id IN NUMBER,
21: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
22: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 21: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

17:
18: PROCEDURE copy_schedule_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
19: p_start_id IN NUMBER,
20: p_end_id IN NUMBER,
21: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
22: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
23: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
24: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
25: IS

Line 96: PROCEDURE add_schedule_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

92: -- In Out parameters
93: -- PX_Sch_Record_Tab ScheduleTabTyp YES It stores the added scheduled records
94: --
95:
96: PROCEDURE add_schedule_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
97: p_start_id IN NUMBER,
98: p_end_id IN NUMBER,
99: px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
100: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 99: px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

95:
96: PROCEDURE add_schedule_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
97: p_start_id IN NUMBER,
98: p_end_id IN NUMBER,
99: px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
100: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
101: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
102: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
103: IS

Line 174: px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

170: --
171:
172: PROCEDURE mark_del_sch_rec_tab ( p_start_id IN NUMBER,
173: p_end_id IN NUMBER,
174: px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
175: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
176: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
177: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
178: IS

Line 219: PROCEDURE sep_del_sch_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

215: -- X_Sch_Record_Tab ScheduleTabTyp YES It stores scheduled records whic are marked for insertion
216: -- and updation
217: --
218:
219: PROCEDURE sep_del_sch_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
220: x_del_sch_rec_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
221: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
222: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
223: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 220: x_del_sch_rec_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

216: -- and updation
217: --
218:
219: PROCEDURE sep_del_sch_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
220: x_del_sch_rec_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
221: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
222: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
223: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
224: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 221: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

217: --
218:
219: PROCEDURE sep_del_sch_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
220: x_del_sch_rec_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
221: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
222: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
223: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
224: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
225: IS

Line 341: PROCEDURE update_sch_rec_tab ( px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

337: -- In Out parameters
338: -- PX_Sch_Record_Tab ScheduleTabTyp YES It stores the updated scheduled records
339: --
340:
341: PROCEDURE update_sch_rec_tab ( px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
342: p_project_id IN NUMBER DEFAULT NULL,
343: p_calendar_id IN NUMBER DEFAULT NULL,
344: p_assignment_id IN NUMBER DEFAULT NULL,
345: p_schedule_type_code IN VARCHAR2 DEFAULT NULL,

Line 422: PROCEDURE apply_percentage ( px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

418: -- P_Percentage NUMBER YES It is percentage
419: -- In Out parameters
420: -- PX_Sch_Record_Tab ScheduleTabTyp YES It stores the updated scheduled records
421: --
422: PROCEDURE apply_percentage ( px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
423: p_percentage IN NUMBER ,
424: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
425: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
426: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 480: PROCEDURE copy_except_record ( p_except_record IN PA_SCHEDULE_GLOB.SchExceptRecord,

476: -- Out Parameters
477: -- X_Except_Record SchExceptRecord YES It stores the copied exception records
478: --
479:
480: PROCEDURE copy_except_record ( p_except_record IN PA_SCHEDULE_GLOB.SchExceptRecord,
481: x_except_record OUT NOCOPY PA_SCHEDULE_GLOB.SchExceptRecord,
482: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
483: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
484: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 481: x_except_record OUT NOCOPY PA_SCHEDULE_GLOB.SchExceptRecord,

477: -- X_Except_Record SchExceptRecord YES It stores the copied exception records
478: --
479:
480: PROCEDURE copy_except_record ( p_except_record IN PA_SCHEDULE_GLOB.SchExceptRecord,
481: x_except_record OUT NOCOPY PA_SCHEDULE_GLOB.SchExceptRecord,
482: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
483: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
484: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
485: IS

Line 556: PROCEDURE update_except_record( px_except_record IN OUT NOCOPY PA_SCHEDULE_GLOB.SchExceptRecord,

552: -- P_Sunday_Hours NUMBER YES No. of hours of this day
553: -- In Out parameters
554: -- PX_Except_Record SchExceptRecord YES It stores the updated exception records
555: --
556: PROCEDURE update_except_record( px_except_record IN OUT NOCOPY PA_SCHEDULE_GLOB.SchExceptRecord,
557: p_project_id IN NUMBER DEFAULT NULL,
558: p_calendar_id IN NUMBER DEFAULT NULL,
559: p_assignment_id IN NUMBER DEFAULT NULL,
560: p_schedule_type_code IN VARCHAR2 DEFAULT NULL,

Line 678: wr_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp)

674: --
675:
676: PROCEDURE log_message( level1 IN NUMBER,
677: msg1 IN VARCHAR2,
678: wr_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp)
679:
680: IS
681: BEGIN
682: null;