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.

APPS.PA_CALENDAR_UTILS dependencies on PA_SCHEDULE_GLOB

Line 19: x_cal_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.CalendarTabTyp, x_return_status OUT VARCHAR2,

15:
16: /* Added nocopy for this variable for bug#2674619 */
17:
18: PROCEDURE get_calendar_shifts ( p_calendar_id IN NUMBER,
19: x_cal_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.CalendarTabTyp, x_return_status OUT VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
21: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
22: IS
23: l_t_shift_id JTF_CAL_SHIFT_ASSIGN.shift_id%TYPE;-- assigning the variable to store the shift id

Line 116: x_cal_except_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.CalExceptionTabTyp,

112: --
113:
114: /* Added nocopy for this variable for bug#2674619 */
115: PROCEDURE get_calendar_except ( p_calendar_id IN NUMBER,
116: x_cal_except_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.CalExceptionTabTyp,
117: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
118: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
119: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
120: IS

Line 169: p_cal_record_tab IN PA_SCHEDULE_GLOB.CalendarTabTyp,

165: --
166:
167: /* Added nocopy for this variable for bug#2674619 */
168: PROCEDURE gen_calendar_sch ( p_calendar_id IN NUMBER,
169: p_cal_record_tab IN PA_SCHEDULE_GLOB.CalendarTabTyp,
170: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
171: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
172: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
173: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 170: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

166:
167: /* Added nocopy for this variable for bug#2674619 */
168: PROCEDURE gen_calendar_sch ( p_calendar_id IN NUMBER,
169: p_cal_record_tab IN PA_SCHEDULE_GLOB.CalendarTabTyp,
170: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
171: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
172: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
173: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
174: IS

Line 301: p_cal_except_record_tab IN PA_SCHEDULE_GLOB.CalExceptionTabTyp,

297: --
298:
299: /* Added nocopy for this variable for bug#2674619 */
300: PROCEDURE apply_calendar_except ( p_calendar_id IN NUMBER,
301: p_cal_except_record_tab IN PA_SCHEDULE_GLOB.CalExceptionTabTyp,
302: p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
303: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
304: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
305: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 302: p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

298:
299: /* Added nocopy for this variable for bug#2674619 */
300: PROCEDURE apply_calendar_except ( p_calendar_id IN NUMBER,
301: p_cal_except_record_tab IN PA_SCHEDULE_GLOB.CalExceptionTabTyp,
302: p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
303: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
304: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
305: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
306: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 303: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

299: /* Added nocopy for this variable for bug#2674619 */
300: PROCEDURE apply_calendar_except ( p_calendar_id IN NUMBER,
301: p_cal_except_record_tab IN PA_SCHEDULE_GLOB.CalExceptionTabTyp,
302: p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
303: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
304: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
305: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
306: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
307: IS

Line 309: l_temp_exp_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- temporary variable

305: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
306: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
307: IS
308:
309: l_temp_exp_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- temporary variable
310: l_temp_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- temporary variable
311: l_out_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- temporary variable
312: l_I NUMBER;
313: l_J NUMBER;

Line 310: l_temp_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- temporary variable

306: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
307: IS
308:
309: l_temp_exp_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- temporary variable
310: l_temp_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- temporary variable
311: l_out_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- temporary variable
312: l_I NUMBER;
313: l_J NUMBER;
314: l_temp_first NUMBER; -- temporary variable

Line 311: l_out_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- temporary variable

307: IS
308:
309: l_temp_exp_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- temporary variable
310: l_temp_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- temporary variable
311: l_out_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- temporary variable
312: l_I NUMBER;
313: l_J NUMBER;
314: l_temp_first NUMBER; -- temporary variable
315: l_temp_last NUMBER; -- temporary variable