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 JTF_CAL_SHIFT_ASSIGN

Line 23: l_t_shift_id JTF_CAL_SHIFT_ASSIGN.shift_id%TYPE;-- assigning the variable to store the shift id

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
24: -- for getting the shifts
25: l_I NUMBER;
26:
27: -- This cursor will select the shifts assign to the calendar and the effective period

Line 29: FROM JTF_CAL_SHIFT_ASSIGN

25: l_I NUMBER;
26:
27: -- This cursor will select the shifts assign to the calendar and the effective period
28: CURSOR C1 IS SELECT shift_sequence_number,shift_id,(shift_end_date - shift_start_date ) duration
29: FROM JTF_CAL_SHIFT_ASSIGN
30: WHERE calendar_id = p_calendar_id;
31:
32: -- This cursor will select the work patern of the assigning shift to the calendar
33: -- Bug 2181241: Modified the rounding to be two decimals.