DBA Data[Home] [Help]

APPS.FTE_TRIP_RATING_GRP dependencies on FTE_SEARCH_CRITERIA_REC

Line 2649: l_search_criteria_rec fte_search_criteria_rec;

2645: i NUMBER;
2646: j NUMBER;
2647: k NUMBER;
2648: l_search_criteria_tab fte_search_criteria_tab;
2649: l_search_criteria_rec fte_search_criteria_rec;
2650: l_lanes_tab fte_lane_tab;
2651: l_schedules_tab fte_schedule_tab;
2652: l_lane_rec fte_lane_rec;
2653: l_msg_data VARCHAR2(32767);

Line 2675: l_search_criteria_rec := fte_search_criteria_rec(

2671: LOOP
2672: IF (p_ss_rate_sort_tab(i).lane_id IS NULL)
2673: THEN
2674:
2675: l_search_criteria_rec := fte_search_criteria_rec(
2676: relax_flag => 'Y',
2677: origin_loc_id => p_ss_attr_rec.origin_location_id,
2678: destination_loc_id => p_ss_attr_rec.destination_location_id,
2679: origin_country => null,

Line 2713: --Changes made to fte_search_criteria_rec 19-FEB-2004

2709: pickupstop_location_id => p_ss_attr_rec.pick_up_stop_location_id,
2710: dropoffstop_location_id => p_ss_attr_rec.drop_off_stop_location_id,
2711: ship_to_site_id => null,
2712: vehicle_id => null,
2713: --Changes made to fte_search_criteria_rec 19-FEB-2004
2714: effective_date => p_ss_attr_rec.dep_date_from,
2715: effective_date_type => '=',
2716: tariff_name => null -- Added J+
2717: );