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 11095: FROM fte_freight_costs_temp

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

Line 11525: FROM FTE_FREIGHT_COSTS_TEMP

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

Line 11536: FROM FTE_FREIGHT_COSTS_TEMP

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

Line 11815: UPDATE fte_freight_costs_temp

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

Line 11927: FROM FTE_FREIGHT_COSTS_TEMP

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

Line 11938: FROM FTE_FREIGHT_COSTS_TEMP

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

Line 12234: UPDATE fte_freight_costs_temp

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