APPS.WSH_FREIGHT_COSTS_PUB SQL Statements

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

Line: 26

			SELECT freight_cost_type_id INTO x_freight_cost_type_id
			FROM wsh_freight_cost_types
			WHERE name = p_freight_cost_type;

Line: 34

		SELECT freight_cost_type_id INTO l_type_id
		FROM wsh_freight_cost_types
		WHERE freight_cost_type_id = x_freight_cost_type_id;

Line: 53

PROCEDURE Delete_Freight_Costs (
  p_api_version_number     IN     NUMBER
, p_init_msg_list          IN     VARCHAR2
, p_commit                 IN     VARCHAR2
, x_return_status             OUT NOCOPY  VARCHAR2
, x_msg_count                 OUT NOCOPY  NUMBER
, x_msg_data                  OUT NOCOPY  VARCHAR2
, p_pub_freight_costs		IN     WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType
)
IS
l_return_status            VARCHAR2(30);

Line: 69

	WSH_FREIGHT_COSTS_PVT.Delete_freight_cost(
		p_rowid       			=>   	NULL,
		p_freight_cost_id   	=>   	p_pub_freight_costs.freight_cost_id,
		x_return_status     	=>   	x_return_status);

Line: 88

END Delete_Freight_Costs;

Line: 154

  x_pvt_freight_rec.LAST_UPDATE_DATE		 := p_pub_freight_rec.LAST_UPDATE_DATE;

Line: 155

  x_pvt_freight_rec.LAST_UPDATED_BY		 := p_pub_freight_rec.LAST_UPDATED_BY;

Line: 156

  x_pvt_freight_rec.LAST_UPDATE_LOGIN		 := p_pub_freight_rec.LAST_UPDATE_LOGIN;

Line: 159

  x_pvt_freight_rec.PROGRAM_UPDATE_DATE		 := p_pub_freight_rec.PROGRAM_UPDATE_DATE;

Line: 208

PROCEDURE Create_Update_Freight_Costs (
  p_api_version_number     IN     NUMBER
, p_init_msg_list          IN     VARCHAR2
, p_commit                 IN     VARCHAR2
, x_return_status             OUT NOCOPY  VARCHAR2
, x_msg_count                   OUT NOCOPY  NUMBER
, x_msg_data                    OUT NOCOPY  VARCHAR2
, p_pub_freight_costs   IN     WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType
, p_action_code            IN     VARCHAR2
, x_freight_cost_id           OUT NOCOPY  NUMBER) IS

l_debug_on BOOLEAN;

Line: 220

l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Update_Freight_Costs';

Line: 223

l_api_name   		CONSTANT VARCHAR2(30) := 'Create_Update_Freight_Costs';

Line: 240

      wsh_debug_sv.push (l_module_name, 'Create_Update_Freight_Costs');

Line: 274

   WSH_INTERFACE_GRP.Create_Update_Freight_Costs(
      p_api_version_number     => p_api_version_number,
      p_init_msg_list          => p_init_msg_list,
      p_commit                 => p_commit,
      x_return_status          => x_return_status,
      x_msg_count              => x_msg_count,
      x_msg_data               => x_msg_data,
      p_freight_info_tab       => l_freight_info_tab,
      p_in_rec                 => l_in_rec,
      x_out_tab                => l_out_tab );

Line: 336

      wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

Line: 346

END Create_Update_Freight_Costs;