APPS.FTE_FREIGHT_PRICING dependencies on FTE_FREIGHT_COSTS_TEMP

Line 2234: SELECT fte_freight_costs_temp_s.nextval

2230: IS
2231:
2232: CURSOR C_Next_Freight_Cost_Id
2233: IS
2234: SELECT fte_freight_costs_temp_s.nextval
2235: FROM sys.dual;
2236:
2237: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
2238:

Line 2250: INSERT INTO fte_freight_costs_temp(

2246: OPEN C_Next_Freight_Cost_Id;
2247: FETCH C_Next_Freight_Cost_Id INTO x_freight_cost_temp_id;
2248: CLOSE C_Next_Freight_Cost_Id;
2249:
2250: INSERT INTO fte_freight_costs_temp(
2251: freight_cost_id,
2252: freight_cost_type_id,
2253: charge_unit_value,
2254: unit_amount,

Line 7334: -- WSH_FREIGHT_COSTS or FTE_FREIGHT_COSTS_TEMP depending on p_save_flag values ('T' or 'M')

7330: -- It processes each input shipment content line to identify their patterns
7331: -- and to construct input lines to send to the QP engine using the Pricing preferences
7332: -- Uses process_shipment_pattern to construct inputs to QP engine line and attribute line
7333: -- This API also calls out post-processing APIs and saves to
7334: -- WSH_FREIGHT_COSTS or FTE_FREIGHT_COSTS_TEMP depending on p_save_flag values ('T' or 'M')
7335: -- Looks up delivery detail info from g_shipment_line_rows
7336:
7337: PROCEDURE shipment_pricing (
7338: p_lane_id IN NUMBER DEFAULT NULL,

Line 11094: FROM fte_freight_costs_temp

11090: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'delete_fc_temp_pvt','start');
11091: END IF;
11092:
11093: DELETE
11094: FROM fte_freight_costs_temp
11095: WHERE comparison_request_id = p_request_id
11096: --AND nvl(lane_id,-9999) <> nvl(p_lane_id,-19999)
11097: AND nvl(lane_id,-9999) <> nvl(decode(p_schedule_id,NULL,p_lane_id,NULL),-19999)
11098: AND nvl(schedule_id,-9999) <> nvl(p_schedule_id,-19999);

Line 11524: FROM FTE_FREIGHT_COSTS_TEMP

11520: -- bug : 2763791 : added p_service_type_code
11521:
11522: CURSOR c_move_fc_temp IS
11523: SELECT *
11524: FROM FTE_FREIGHT_COSTS_TEMP
11525: WHERE comparison_request_id = p_request_id
11526: --AND nvl(lane_id,-9999) = nvl(p_lane_id,-9999)
11527: AND nvl(lane_id,-9999) = nvl(decode(p_schedule_id,NULL,p_lane_id,NULL),-9999)
11528: AND nvl(schedule_id,-9999) = nvl(p_schedule_id,-9999)

Line 11535: FROM FTE_FREIGHT_COSTS_TEMP

11531: AND line_type_code NOT IN ('CHARGE','DISCOUNT');
11532:
11533: CURSOR c_move_fc_temp_charge IS
11534: SELECT *
11535: FROM FTE_FREIGHT_COSTS_TEMP
11536: WHERE comparison_request_id = p_request_id
11537: --AND nvl(lane_id,-9999) = nvl(p_lane_id,-9999)
11538: AND nvl(lane_id,-9999) = nvl(decode(p_schedule_id,NULL,p_lane_id,NULL),-9999)
11539: AND nvl(schedule_id,-9999) = nvl(p_schedule_id,-9999)

Line 11814: UPDATE fte_freight_costs_temp

11810:
11811: BEGIN -- anonymous block to make sure transaction goes through even if the
11812: -- enclosed update statement fails
11813:
11814: UPDATE fte_freight_costs_temp
11815: SET moved_to_main_flag = 'Y'
11816: WHERE comparison_request_id = p_request_id
11817: --AND nvl(lane_id,-9999) = nvl(p_lane_id,-9999)
11818: AND nvl(lane_id,-9999) = nvl(decode(p_schedule_id,NULL,p_lane_id,NULL),-9999)

Line 11926: FROM FTE_FREIGHT_COSTS_TEMP

11922: -- bug : 2763791 : added p_service_type_code
11923:
11924: CURSOR c_move_fc_temp IS
11925: SELECT *
11926: FROM FTE_FREIGHT_COSTS_TEMP
11927: WHERE comparison_request_id = p_request_id
11928: --AND nvl(lane_id,-9999) = nvl(p_lane_id,-9999)
11929: AND nvl(lane_id,-9999) = nvl(decode(p_schedule_id,NULL,p_lane_id,NULL),-9999)
11930: AND nvl(schedule_id,-9999) = nvl(p_schedule_id,-9999)

Line 11937: FROM FTE_FREIGHT_COSTS_TEMP

11933: AND line_type_code NOT IN ('CHARGE','DISCOUNT');
11934:
11935: CURSOR c_move_fc_temp_charge IS
11936: SELECT *
11937: FROM FTE_FREIGHT_COSTS_TEMP
11938: WHERE comparison_request_id = p_request_id
11939: --AND nvl(lane_id,-9999) = nvl(p_lane_id,-9999)
11940: AND nvl(lane_id,-9999) = nvl(decode(p_schedule_id,NULL,p_lane_id,NULL),-9999)
11941: AND nvl(schedule_id,-9999) = nvl(p_schedule_id,-9999)

Line 12233: UPDATE fte_freight_costs_temp

12229:
12230: BEGIN -- anonymous block to make sure transaction goes through even if the
12231: -- enclosed update statement fails
12232:
12233: UPDATE fte_freight_costs_temp
12234: SET moved_to_main_flag = 'Y'
12235: WHERE comparison_request_id = p_request_id
12236: --AND nvl(lane_id,-9999) = nvl(p_lane_id,-9999)
12237: AND nvl(lane_id,-9999) = nvl(decode(p_schedule_id,NULL,p_lane_id,NULL),-9999)