eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_FREIGHT_COST_TYPES_PVT SQL Statements

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

Line: 18


SELECT wsh_freight_cost_types_s.nextval
FROM sys.dual;

Line: 23


SELECT rowid
FROM wsh_freight_cost_types
WHERE freight_cost_type_id = x_freight_cost_type_id;

Line: 79


	INSERT INTO wsh_freight_cost_types(
		freight_cost_type_id,
		name,
		freight_cost_type_code,
		amount,
		currency_code,
		description,
		start_date_active,
		end_date_active,
		attribute_category,
		attribute1,
		attribute2,
		attribute3,
		attribute4,
		attribute5,
		attribute6,
		attribute7,
		attribute8,
		attribute9,
		attribute10,
		attribute11,
		attribute12,
		attribute13,
		attribute14,
		attribute15,
		creation_date,
		created_by,
  	 	last_update_date,
  	 	last_updated_by,
  		last_update_login,
   	        program_application_id,
   	        program_id,
   	        program_update_date,
   	        request_id,
   	        charge_map_flag
   	) VALUES (
   	x_freight_cost_type_id,
	p_freight_cost_type_info.name,
	p_freight_cost_type_info.freight_cost_type_code,
	p_freight_cost_type_info.amount,
	p_freight_cost_type_info.currency_code,
	p_freight_cost_type_info.description,
	p_freight_cost_type_info.start_date_active,
	p_freight_cost_type_info.end_date_active,
	p_freight_cost_type_info.attribute_category,
	p_freight_cost_type_info.attribute1,
	p_freight_cost_type_info.attribute2,
	p_freight_cost_type_info.attribute3,
	p_freight_cost_type_info.attribute4,
	p_freight_cost_type_info.attribute5,
	p_freight_cost_type_info.attribute6,
	p_freight_cost_type_info.attribute7,
	p_freight_cost_type_info.attribute8,
	p_freight_cost_type_info.attribute9,
	p_freight_cost_type_info.attribute10,
	p_freight_cost_type_info.attribute11,
	p_freight_cost_type_info.attribute12,
	p_freight_cost_type_info.attribute13,
	p_freight_cost_type_info.attribute14,
	p_freight_cost_type_info.attribute15,
	p_freight_cost_type_info.creation_date,
	p_freight_cost_type_info.created_by,
	p_freight_cost_type_info.last_update_date,
	p_freight_cost_type_info.last_updated_by,
	p_freight_cost_type_info.last_update_login,
	p_freight_cost_type_info.program_application_id,
	p_freight_cost_type_info.program_id,
	p_freight_cost_type_info.program_update_date,
	p_freight_cost_type_info.request_id,
   	p_freight_cost_type_info.charge_map_flag
   	);

Line: 196


PROCEDURE Update_Freight_Cost_Type(
  p_rowid                      IN     VARCHAR2
, p_freight_cost_type_info     IN     Freight_Cost_Type_Rec_Type
, x_return_status              OUT NOCOPY  VARCHAR2
)
IS

--
l_debug_on BOOLEAN;

Line: 206


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

Line: 232


	UPDATE wsh_freight_cost_types
   SET
	   name                      = p_freight_cost_type_info.name,
	   freight_cost_type_code    = p_freight_cost_type_info.freight_cost_type_code,
	   amount                    = p_freight_cost_type_info.amount,
	   currency_code             = p_freight_cost_type_info.currency_code,
	   description               = p_freight_cost_type_info.description,
	   start_date_active         = p_freight_cost_type_info.start_date_active,
	   end_date_active           = p_freight_cost_type_info.end_date_active,
	   attribute_category        = p_freight_cost_type_info.attribute_category,
	   attribute1                = p_freight_cost_type_info.attribute1,
	   attribute2                = p_freight_cost_type_info.attribute2,
	   attribute3                = p_freight_cost_type_info.attribute3,
	   attribute4                = p_freight_cost_type_info.attribute4,
	   attribute5                = p_freight_cost_type_info.attribute5,
	   attribute6                = p_freight_cost_type_info.attribute6,
	   attribute7                = p_freight_cost_type_info.attribute7,
	   attribute8                = p_freight_cost_type_info.attribute8,
	   attribute9                = p_freight_cost_type_info.attribute9,
	   attribute10               = p_freight_cost_type_info.attribute10,
	   attribute11               = p_freight_cost_type_info.attribute11,
	   attribute12               = p_freight_cost_type_info.attribute12,
	   attribute13               = p_freight_cost_type_info.attribute13,
	   attribute14               = p_freight_cost_type_info.attribute14,
	   attribute15               = p_freight_cost_type_info.attribute15,
	   creation_date             = p_freight_cost_type_info.creation_date,
	   created_by                = p_freight_cost_type_info.created_by,
	   last_update_date          = p_freight_cost_type_info.last_update_date,
	   last_updated_by           = p_freight_cost_type_info.last_updated_by,
	   last_update_login         = p_freight_cost_type_info.last_update_login,
	   program_application_id    = p_freight_cost_type_info.program_application_id,
	   program_id                = p_freight_cost_type_info.program_id,
	   program_update_date	     = p_freight_cost_type_info.program_update_date,
	   request_id                = p_freight_cost_type_info.request_id,
	   charge_map_flag           = p_freight_cost_type_info.charge_map_flag
   WHERE freight_cost_type_id = p_freight_cost_type_info.freight_cost_type_id;

Line: 282


		wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.UPDATE_FREIGHT_COST_TYPE');

Line: 292


END Update_Freight_Cost_Type;

Line: 301


SELECT *
FROM wsh_freight_cost_types
WHERE rowid = p_rowid
FOR UPDATE OF freight_cost_type_id NOWAIT;

Line: 337


	   FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 408


	   AND   (Recinfo.last_update_date = p_freight_cost_type_info.last_update_date)
	   AND   (Recinfo.last_update_login = p_freight_cost_type_info.last_update_login)
        ) THEN
	   --
	   -- Debug Statements
	   --
	   IF l_debug_on THEN
	       WSH_DEBUG_SV.pop(l_module_name);

Line: 453


PROCEDURE Delete_Freight_Cost_Type(
  p_rowid                    IN     VARCHAR2
, p_freight_cost_type_id     IN     NUMBER
, x_return_status	     OUT NOCOPY  VARCHAR2
)
IS
CURSOR C_Get_Freight_cost_type_id
IS
SELECT freight_cost_type_id
FROM wsh_freight_cost_types
WHERE rowid = p_rowid;

Line: 471


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

Line: 502


	DELETE FROM wsh_freight_cost_types
	WHERE freight_cost_type_id = p_freight_cost_type_id;

Line: 517


		wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.DELETE_FREIGHT_COST_TYPE');

Line: 528


		wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.DELETE_FREIGHT_COST_TYPE');

Line: 538


END Delete_Freight_Cost_Type;