DBA Data[Home] [Help]

APPS.FTE_LANE_SEARCH dependencies on FTE_LANE_REC

Line 750: l_lanes_rec fte_lane_rec;

746: s_frequency_type_code dbms_sql.VARCHAR2_TABLE;
747: s_active_flag dbms_sql.VARCHAR2_TABLE;
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:

Line 1205: l_lanes_rec := fte_lane_rec(v_lane_id(n + l_offset),

1201:
1202: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
1203: if (p_source_type ='T') THEN
1204:
1205: l_lanes_rec := fte_lane_rec(v_lane_id(n + l_offset),
1206: '',
1207: v_origin_id(n + l_offset),
1208: v_destination_id(n + l_offset),
1209: v_carrier_id(n + l_offset),

Line 1244: l_lanes_rec := fte_lane_rec(v_lane_id(n + l_offset),

1240: '');
1241:
1242: else
1243:
1244: l_lanes_rec := fte_lane_rec(v_lane_id(n + l_offset),
1245: v_lane_number(n + l_offset),
1246: v_origin_id(n + l_offset),
1247: v_destination_id(n + l_offset),
1248: v_carrier_id(n + l_offset),

Line 1550: l_lanes_rec := fte_lane_rec(v_lane_id(n + l_offset),

1546:
1547: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
1548: if (p_source_type ='T') THEN
1549:
1550: l_lanes_rec := fte_lane_rec(v_lane_id(n + l_offset),
1551: '',
1552: v_origin_id(n + l_offset),
1553: v_destination_id(n + l_offset),
1554: v_carrier_id(n + l_offset),

Line 1589: l_lanes_rec := fte_lane_rec(v_lane_id(n + l_offset),

1585: '');
1586:
1587: else
1588:
1589: l_lanes_rec := fte_lane_rec(v_lane_id(n + l_offset),
1590: v_lane_number(n + l_offset),
1591: v_origin_id(n + l_offset),
1592: v_destination_id(n + l_offset),
1593: v_carrier_id(n + l_offset),