APPS.WSH_CARRIER_SHIP_METHODS_PKG SQL Statements

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

Line: 21

SELECT wsh_carrier_ship_methods_s.nextval
FROM sys.dual;

Line: 26

SELECT rowid
FROM WSH_CARRIER_SHIP_METHODS
WHERE carrier_ship_method_id = x_carrier_ship_method_id;

Line: 107

   INSERT INTO wsh_carrier_ship_methods(
      carrier_ship_method_id,
	   carrier_id,
	   ship_method_code,
	   freight_code,
	   service_level,
	   carrier_site_id,
	   organization_id,
	   enabled_flag,
	   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,
	   web_enabled
	   )
	   VALUES (
        x_Carrier_Ship_Method_id,
	   p_Carrier_Ship_Method_Info.Carrier_Id,
	   p_Carrier_Ship_Method_Info.Ship_Method_Code,
	   p_Carrier_Ship_Method_Info.freight_code,
	   p_Carrier_Ship_Method_Info.service_level,
	   p_Carrier_Ship_Method_Info.carrier_site_id,
	   p_Carrier_Ship_Method_Info.organization_id,
	   p_Carrier_Ship_Method_Info.Enabled_Flag,
	   p_Carrier_Ship_Method_Info.Attribute_Category,
	   p_Carrier_Ship_Method_Info.Attribute1,
	   p_Carrier_Ship_Method_Info.Attribute2,
	   p_Carrier_Ship_Method_Info.Attribute3,
	   p_Carrier_Ship_Method_Info.Attribute4,
	   p_Carrier_Ship_Method_Info.Attribute5,
	   p_Carrier_Ship_Method_Info.Attribute6,
	   p_Carrier_Ship_Method_Info.Attribute7,
	   p_Carrier_Ship_Method_Info.Attribute8,
	   p_Carrier_Ship_Method_Info.Attribute9,
	   p_Carrier_Ship_Method_Info.Attribute10,
	   p_Carrier_Ship_Method_Info.Attribute11,
	   p_Carrier_Ship_Method_Info.Attribute12,
	   p_Carrier_Ship_Method_Info.Attribute13,
	   p_Carrier_Ship_Method_Info.Attribute14,
	   p_Carrier_Ship_Method_Info.Attribute15,
	   p_Carrier_Ship_Method_Info.Creation_date,
	   p_Carrier_Ship_Method_Info.Created_By,
	   p_Carrier_Ship_Method_Info.Last_Update_Date,
	   p_Carrier_Ship_Method_Info.Last_Updated_By,
	   p_Carrier_Ship_Method_Info.Last_Update_Login,
	   p_Carrier_Ship_Method_Info.web_enabled
	   );

Line: 173

      WSH_DEBUG_SV.log(l_module_name,'After insert' );

Line: 193

			WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);

Line: 210

SELECT *
FROM   wsh_carrier_ship_methods
WHERE  rowid = p_rowid
FOR UPDATE of Carrier_Ship_Method_id NOWAIT;

Line: 291

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

Line: 427

PROCEDURE Update_Carrier_Ship_Method (
  p_rowid                          IN     VARCHAR2
, p_Carrier_Ship_Method_Info       IN     CSMRecType
, x_Return_Status                     OUT NOCOPY  VARCHAR2
)
IS
others                             			EXCEPTION;

Line: 437

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

Line: 502

   UPDATE wsh_carrier_ship_methods
   SET
      carrier_id					= p_Carrier_Ship_Method_Info.Carrier_id,
	   ship_method_code			     = p_Carrier_Ship_Method_Info.Ship_Method_Code,
	   freight_code                    = p_Carrier_Ship_Method_Info.Freight_code,
	   service_level                   = p_Carrier_Ship_Method_Info.Service_level,
	   carrier_site_id                 = p_Carrier_Ship_Method_Info.carrier_site_id,
	   organization_id                 = p_Carrier_Ship_Method_Info.organization_id,
	   enabled_flag				= p_Carrier_Ship_Method_Info.Enabled_Flag,
	   attribute_category		     = p_Carrier_Ship_Method_Info.Attribute_Category,
	   attribute1					= p_Carrier_Ship_Method_Info.Attribute1,
	   attribute2					= p_Carrier_Ship_Method_Info.Attribute2,
	   attribute3					= p_Carrier_Ship_Method_Info.Attribute3,
	   attribute4					= p_Carrier_Ship_Method_Info.Attribute4,
	   attribute5					= p_Carrier_Ship_Method_Info.Attribute5,
	   attribute6					= p_Carrier_Ship_Method_Info.Attribute6,
	   attribute7					= p_Carrier_Ship_Method_Info.Attribute7,
	   attribute8					= p_Carrier_Ship_Method_Info.Attribute8,
	   attribute9					= p_Carrier_Ship_Method_Info.Attribute9,
	   attribute10					= p_Carrier_Ship_Method_Info.Attribute10,
	   attribute11					= p_Carrier_Ship_Method_Info.Attribute11,
	   attribute12					= p_Carrier_Ship_Method_Info.Attribute12,
	   attribute13					= p_Carrier_Ship_Method_Info.Attribute13,
	   attribute14					= p_Carrier_Ship_Method_Info.Attribute14,
	   attribute15					= p_Carrier_Ship_Method_Info.Attribute15,
	   last_update_date			     = p_Carrier_Ship_Method_Info.Last_Update_Date,
	   last_updated_by			     = p_Carrier_Ship_Method_Info.Last_Updated_By,
	   last_update_login			= p_Carrier_Ship_Method_Info.Last_Update_Login,
	   web_enabled                         = p_Carrier_Ship_Method_Info.Web_Enabled
WHERE rowid = p_rowid;

Line: 559

           WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);

Line: 567

END Update_Carrier_Ship_Method;

Line: 569

PROCEDURE Delete_Carrier_Ship_Method(
  p_rowid                          IN     VARCHAR2 := NULL
, p_Carrier_Ship_Method_id         IN     NUMBER
, x_Return_Status                     OUT NOCOPY  VARCHAR2
)
IS

CURSOR C_CSM_id
IS
SELECT carrier_ship_method_id
FROM wsh_carrier_ship_methods
WHERE rowid = p_rowid;

Line: 588

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

Line: 621

		DELETE FROM wsh_carrier_ship_methods
      WHERE carrier_ship_method_id = l_csm_id;

Line: 634

            WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Delete_Carrier_Ship_Method',l_module_name);

Line: 642

END Delete_Carrier_Ship_Method;