DBA Data[Home] [Help]

APPS.FTE_FREIGHT_PRICING_SPECIAL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 32

SELECT uom_for_num_of_units
FROM wsh_global_parameters;
Line: 106

    SELECT     fpp.lane_id,
               fppd.lane_function,
               fppd.parameter_sub_type,
               fppd.parameter_name,
               fpp.value_from,
               fppd.default_value_from
    FROM       fte_prc_parameter_defaults fppd, fte_prc_parameters fpp
    WHERE      fppd.parameter_id = fpp.parameter_id (+)
    AND        fpp.lane_id (+) = c_lane_id
    AND        fppd.lane_function = c_lane_function
    AND        fppd.parameter_type = 'RULE'
    AND        fppd.parameter_sub_type = c_pattern_name
    ORDER BY   fppd.parameter_sub_type, fppd.parameter_name;
Line: 121

   SELECT      DISTINCT fppd.parameter_sub_type pattern_name
   FROM        fte_prc_parameter_defaults fppd
   WHERE       fppd.lane_function = c_lane_function
     AND       fppd.parameter_type = 'RULE'
   ORDER BY    1;
Line: 146

   g_lane_rules_tab.DELETE;
Line: 154

    l_def_values.delete;
Line: 269

    SELECT     fpp.parameter_instance_id,fpp.lane_id,
               fppd.lane_function,fppd.parameter_sub_type, fppd.parameter_name,
               nvl(fpp.value_from,fppd.default_value_from),
               nvl(fpp.value_to,fppd.default_value_to),
               fpp.uom_class, fpp.uom_code, fpp.currency_code
    FROM       fte_prc_parameter_defaults fppd, fte_prc_parameters fpp
    WHERE      fppd.parameter_id = fpp.parameter_id (+)
    AND        fpp.lane_id (+) = c_lane_id
    AND        fppd.parameter_type = 'PARAMETER'
    ORDER BY   fppd.parameter_type, fppd.parameter_sub_type, fppd.parameter_name;
Line: 596

   g_lane_parameters.DELETE;
Line: 1336

  SELECT
  wc.dim_dimensional_factor,
  wc.dim_weight_uom,
  wc.dim_volume_uom,
  wc.dim_dimension_uom,
  wc.dim_min_pack_vol
  FROM
    wsh_carriers wc
  WHERE
   wc.carrier_id=p_carrier_id;
Line: 1348

  SELECT
  wcs.dim_dimensional_factor,
  wcs.dim_weight_uom,
  wcs.dim_volume_uom,
  wcs.dim_dimension_uom,
  wcs.dim_min_pack_vol
  FROM
    wsh_carrier_services wcs
  WHERE
      wcs.carrier_id = p_carrier_id
  AND wcs.service_level = p_service_code;
Line: 2689

             l_set_num :=1; --set to delete
Line: 2691

             fte_qp_engine.delete_set_from_line_event( p_set_num       => l_set_num,
                                                      x_return_status => l_return_status);
Line: 2693

            fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
Line: 2696

                         raise fte_freight_pricing_util.g_delete_set_failed;
Line: 2706

             l_set_num :=2; --set to delete
Line: 2708

             fte_qp_engine.delete_set_from_line_event( p_set_num       => l_set_num,
                                                      x_return_status => l_return_status);
Line: 2710

            fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
Line: 2713

                         raise fte_freight_pricing_util.g_delete_set_failed;
Line: 2807

      WHEN fte_freight_pricing_util.g_delete_set_failed THEN
           x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
Line: 2809

           fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_delete_set_failed');
Line: 4034

                l_set_num :=2; --set to delete
Line: 4035

                fte_qp_engine.delete_set_from_line_event( p_set_num       => l_set_num,
                                                          x_return_status => l_return_status);
Line: 4038

                fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
Line: 4041

                             raise fte_freight_pricing_util.g_delete_set_failed;
Line: 4045

		g_bumped_rolledup_lines.DELETE;
Line: 4052

                l_set_num :=1; --set to delete
Line: 4053

                fte_qp_engine.delete_set_from_line_event( p_set_num       => l_set_num,
                                                          x_return_status => l_return_status);
Line: 4056

                fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
Line: 4059

                             raise fte_freight_pricing_util.g_delete_set_failed;
Line: 4072

		g_bumped_rolledup_lines.DELETE;
Line: 4108

                 l_set_num :=2; --set to delete
Line: 4109

                 fte_qp_engine.delete_set_from_line_event( p_set_num       => l_set_num,
                                                          x_return_status => l_return_status);
Line: 4112

                fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
Line: 4115

                             raise fte_freight_pricing_util.g_delete_set_failed;
Line: 4119

		g_bumped_rolledup_lines.DELETE;
Line: 4124

                 l_set_num :=1; --set to delete
Line: 4125

                 fte_qp_engine.delete_set_from_line_event( p_set_num       => l_set_num,
                                                          x_return_status => l_return_status);
Line: 4128

                fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
Line: 4131

                             raise fte_freight_pricing_util.g_delete_set_failed;
Line: 4144

		g_bumped_rolledup_lines.DELETE;
Line: 4200

      WHEN fte_freight_pricing_util.g_delete_set_failed THEN
           x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
Line: 4202

           fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_delete_set_failed');
Line: 4597

        x_fc_main_update_rows     	OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
        x_summary_lanesched_price      	OUT NOCOPY NUMBER,
        x_summary_lanesched_price_uom  	OUT NOCOPY VARCHAR2,
        x_return_status           	OUT NOCOPY VARCHAR2 )
IS
  l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
Line: 5163

	    x_fc_main_update_rows(j).delivery_leg_id := l_leg_id_array(i);
Line: 5164

	    x_fc_main_update_rows(j).delivery_id := l_delivery_id_array(i);
Line: 5165

	    x_fc_main_update_rows(j).freight_cost_id := fte_freight_pricing.get_fc_id_from_dleg(l_leg_id_array(i));
Line: 5166

	    x_fc_main_update_rows(j).line_type_code := 'SUMMARY';
Line: 5167

	    x_fc_main_update_rows(j).freight_cost_type_id := l_freight_cost_type_id;
Line: 5168

	    x_fc_main_update_rows(j).unit_amount := round(l_delivery_summary(l_delivery_id_array(i)),2);
Line: 5169

	    x_fc_main_update_rows(j).total_amount := round(l_delivery_summary(l_delivery_id_array(i)),2);
Line: 5170

	    x_fc_main_update_rows(j).currency_code := l_currency_code;
Line: 5171

	    x_fc_main_update_rows(j).charge_source_code := 'PRICING_ENGINE';
Line: 5172

	    x_fc_main_update_rows(j).estimated_flag := 'Y';
Line: 5324

  SELECT TO_NUMBER(segment2)
  FROM mtl_categories
  WHERE category_id = c_category_id;
Line: 5495

        x_fc_main_update_rows     	OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
        x_summary_lanesched_price      	OUT NOCOPY NUMBER,
        x_summary_lanesched_price_uom  	OUT NOCOPY VARCHAR2,
        x_return_status           	OUT NOCOPY VARCHAR2 )
IS
  l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
Line: 5545

  l_main_update_count NUMBER;
Line: 5588

  l_main_update_count:=0;
Line: 5625

	  l_pricing_engine_rows.DELETE;
Line: 5626

	  FTE_FREIGHT_PRICING.g_rolledup_lines.DELETE;
Line: 5705

	  l_pricing_attribute_rows.DELETE;
Line: 6102

	    x_fc_main_update_rows(j).delivery_leg_id := l_leg_id_array(i);
Line: 6103

	    x_fc_main_update_rows(j).delivery_id := l_delivery_id_array(i);
Line: 6104

	    x_fc_main_update_rows(j).freight_cost_id := fte_freight_pricing.get_fc_id_from_dleg(l_leg_id_array(i));
Line: 6105

	    x_fc_main_update_rows(j).line_type_code := 'SUMMARY';
Line: 6106

	    x_fc_main_update_rows(j).freight_cost_type_id := l_freight_cost_type_id;
Line: 6107

	    x_fc_main_update_rows(j).unit_amount := round(l_delivery_summary(l_delivery_id_array(i)),2);
Line: 6108

	    x_fc_main_update_rows(j).total_amount := round(l_delivery_summary(l_delivery_id_array(i)),2);
Line: 6109

	    x_fc_main_update_rows(j).currency_code := l_currency_code;
Line: 6110

	    x_fc_main_update_rows(j).charge_source_code := 'PRICING_ENGINE';
Line: 6111

	    x_fc_main_update_rows(j).estimated_flag := 'Y';