16077: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
16078: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;
16079: shift_num shift_no ;
16080:
16081: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
16082: f_date f_dt ;
16083:
16084: TYPE t_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
16085: t_date t_dt ;
16080:
16081: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
16082: f_date f_dt ;
16083:
16084: TYPE t_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
16085: t_date t_dt ;
16086:
16087: BEGIN
16088: /* 8i Database does not support BULK COLLECT - B3881832 */