DBA Data[Home] [Help]

APPS.FTE_LANE_SEARCH dependencies on FTE_SCHEDULE_REC

Line 752: l_schedules_rec fte_schedule_rec;

748:
749: l_num_rows NUMBER := 0;
750: l_lanes_rec fte_lane_rec;
751: l_lanes_tab fte_lane_tab;
752: l_schedules_rec fte_schedule_rec;
753: l_schedules_tab fte_schedule_tab;
754:
755: -- similar to hash table to keep track of unique lane ids
756: type t_result_ids is table of NUMBER index by binary_integer;

Line 1791: l_schedules_rec := fte_schedule_rec(s_schedule_id(n + l_offset),

1787: dbms_sql.COLUMN_VALUE(l_cursor_id, 30, s_frequency_type_code);
1788: dbms_sql.COLUMN_VALUE(l_cursor_id, 31, s_active_flag);
1789:
1790: FOR n IN 1..l_rows_fetched LOOP
1791: l_schedules_rec := fte_schedule_rec(s_schedule_id(n + l_offset),
1792: s_lane_id(n + l_offset),
1793: s_lane_number(n + l_offset),
1794: s_dep_date(n + l_offset),
1795: s_arr_date(n + l_offset),