DBA Data[Home] [Help]

APPS.FTE_FREIGHT_RATING_PUB dependencies on FTE_SEARCH_CRITERIA_REC

Line 1030: l_search_criteria fte_search_criteria_rec;

1026: l_api_name CONSTANT VARCHAR2(30) := 'SEARCH_SERVICES';
1027: l_return_status VARCHAR2(1);
1028: l_msg_count NUMBER := 0;
1029: l_msg_data VARCHAR2(32767);
1030: l_search_criteria fte_search_criteria_rec;
1031: l_lanes_tab fte_lane_tab;
1032: l_lane_rec fte_lane_rec;
1033: l_schedules_tab fte_schedule_tab;
1034: i NUMBER;

Line 1103: l_search_criteria := fte_search_criteria_rec(

1099: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'p_source_header_rec.arrival_date='||p_source_header_rec.arrival_date);
1100: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'p_source_header_rec.ship_from_location_id='||p_source_header_rec.ship_from_location_id);
1101: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'p_source_header_rec.ship_to_site_id='||p_source_header_rec.ship_to_site_id);
1102:
1103: l_search_criteria := fte_search_criteria_rec(
1104: relax_flag => 'Y',
1105: origin_loc_id => p_source_header_rec.ship_from_location_id,
1106: destination_loc_id => p_source_header_rec.ship_to_location_id,
1107: -- FTE J rate estimate : begin --

Line 1125: --Changes to fte_search_criteria_rec 11-Oct-2004(remove equipment_code,equipment,add tariff_name

1121: commodity_catg_id => null,
1122: commodity => null,
1123: service_code => l_service_level,
1124: service => null,
1125: --Changes to fte_search_criteria_rec 11-Oct-2004(remove equipment_code,equipment,add tariff_name
1126: --equipment_code => null,
1127: --equipment => null,
1128: tariff_name => null,
1129:

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

1143: -- dropoffstop_location_id => null,
1144: dropoffstop_location_id => p_source_header_rec.ship_to_location_id, -- FTE J rate estimate
1145: ship_to_site_id => p_source_header_rec.ship_to_site_id,
1146: vehicle_id => null,
1147: --Changes made to fte_search_criteria_rec 19-FEB-2004
1148: effective_date => p_source_header_rec.ship_date,
1149: effective_date_type => '='
1150: );
1151: