APPS.GMP_CALENDAR_API dependencies on GMP_CALENDAR_DETAIL_GTMP

Line 279: FROM gmp_calendar_detail_gtmp

275: CURSOR start_date_cur (c_calendar_code VARCHAR2,
276: c_start_date DATE) IS
277: SELECT shift_date, shift_num, from_time, to_time,
278: DECODE((to_time-from_time),0,86400,(to_time-from_time)) diff_shift, from_date, TO_DATE end_date
279: FROM gmp_calendar_detail_gtmp
280: WHERE shift_DATE >= trunc(c_start_date)
281: AND TO_DATE >= c_start_date
282: AND calendar_code = c_calendar_code
283: ORDER BY shift_date, from_date, TO_DATE ;

Line 289: FROM gmp_calendar_detail_gtmp

285: CURSOR end_date_cur (c_calendar_code VARCHAR2,
286: c_end_date DATE) IS
287: SELECT shift_date, shift_num, from_time, to_time,
288: DECODE((to_time-from_time),0,86400,(to_time-from_time)) diff_shift, from_date, TO_DATE end_date
289: FROM gmp_calendar_detail_gtmp
290: WHERE shift_DATE <= trunc(c_end_date)
291: AND FROM_DATE <= c_end_date
292: AND calendar_code = c_calendar_code
293: ORDER BY shift_date desc, TO_DATE desc, from_date ;

Line 1970: ins_stmt := 'INSERT INTO gmp_calendar_detail_gtmp'

1966:
1967: CLOSE cal_cur;
1968:
1969: wps_index := 1 ;
1970: ins_stmt := 'INSERT INTO gmp_calendar_detail_gtmp'
1971: ||' ( '
1972: ||' calendar_code, '
1973: ||' shift_num, '
1974: ||' shift_date, '

Line 1997: delete from gmp_calendar_detail_gtmp ;

1993: ||' VALUES '
1994: ||' ( :p1,:p2,:p3,:p4,:p5,:p6,:p7)';
1995: */
1996: -- log_message(n_calendar_code || '-GTMP-' || new_rec.COUNT);
1997: delete from gmp_calendar_detail_gtmp ;
1998:
1999: FOR wps_index IN 1..new_rec.COUNT
2000: LOOP
2001: