2147: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
2148:
2149: l_dep_task_tbl jtf_number_table;
2150: l_arr_task_tbl jtf_number_table;
2151: l_start_time_tbl jtf_date_table;
2152: l_end_time_tbl jtf_date_table;
2153: l_new_trip trip_rec_type;
2154:
2155: CURSOR c_shift_tasks IS
2148:
2149: l_dep_task_tbl jtf_number_table;
2150: l_arr_task_tbl jtf_number_table;
2151: l_start_time_tbl jtf_date_table;
2152: l_end_time_tbl jtf_date_table;
2153: l_new_trip trip_rec_type;
2154:
2155: CURSOR c_shift_tasks IS
2156: SELECT d.task_id dep_task_id