APPS.WSH_DEPARTURE_TEMPLATE_ROWS SQL Statements

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

Line: 18

procedure insert_row(
  X_rowid			in out varchar2,
  X_departure_template_id	in out number,
  X_name			varchar2,
  X_organization_id		number,
  X_vehicle_item_id		number,
  X_vehicle_number 		varchar2,
  X_freight_carrier_code	varchar2,
  X_planned_frequency		varchar2,
  X_planned_day			varchar2,
  X_planned_time		number,
  X_weight_uom_code		varchar2,
  X_volume_uom_code		varchar2,
  X_routing_instructions	varchar2,
  X_attribute_category		varchar2,
  X_attribute1			varchar2,
  X_attribute2			varchar2,
  X_attribute3			varchar2,
  X_attribute4			varchar2,
  X_attribute5			varchar2,
  X_attribute6			varchar2,
  X_attribute7			varchar2,
  X_attribute8			varchar2,
  X_attribute9			varchar2,
  X_attribute10			varchar2,
  X_attribute11			varchar2,
  X_attribute12			varchar2,
  X_attribute13			varchar2,
  X_attribute14			varchar2,
  X_attribute15			varchar2,
  X_creation_date		date,
  X_created_by			number,
  X_last_update_date		date,
  X_last_updated_by		number,
  X_last_update_login		number)
is

  cursor id_sequence is
    select wsh_departure_templates_s.nextval
    from sys.dual;

Line: 60

    select rowid
    from wsh_departure_templates
    where departure_template_id = X_departure_template_id;

Line: 70

  insert into wsh_departure_templates(

    departure_template_id,
    name,
    organization_id,
    vehicle_item_id,
    vehicle_number ,
    freight_carrier_code,
    planned_frequency,
    planned_day,
    planned_time,
    weight_uom_code,
    volume_uom_code,
    routing_instructions,
    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)

  values(

    X_departure_template_id,
    X_name,
    X_organization_id,
    X_vehicle_item_id,
    X_vehicle_number ,
    X_freight_carrier_code,
    X_planned_frequency,
    X_planned_day,
    X_planned_time,
    X_weight_uom_code,
    X_volume_uom_code,
    X_routing_instructions,
    X_attribute_category,
    X_attribute1,
    X_attribute2,
    X_attribute3,
    X_attribute4,
    X_attribute5,
    X_attribute6,
    X_attribute7,
    X_attribute8,
    X_attribute9,
    X_attribute10,
    X_attribute11,
    X_attribute12,
    X_attribute13,
    X_attribute14,
    X_attribute15,
    X_creation_date,
    X_created_by,
    X_last_update_date,
    X_last_updated_by,
    X_last_update_login
  );

Line: 159

end insert_row;

Line: 209

    select *
    from   wsh_departure_templates
    where  rowid = X_rowid
    for update nowait;

Line: 225

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 390

procedure update_row(
  X_rowid			varchar2,
  X_departure_template_id	number,
  X_name			varchar2,
  X_organization_id		number,
  X_vehicle_item_id		number,
  X_vehicle_number 		varchar2,
  X_freight_carrier_code	varchar2,
  X_planned_frequency		varchar2,
  X_planned_day			varchar2,
  X_planned_time		number,
  X_weight_uom_code		varchar2,
  X_volume_uom_code		varchar2,
  X_routing_instructions	varchar2,
  X_attribute_category		varchar2,
  X_attribute1			varchar2,
  X_attribute2			varchar2,
  X_attribute3			varchar2,
  X_attribute4			varchar2,
  X_attribute5			varchar2,
  X_attribute6			varchar2,
  X_attribute7			varchar2,
  X_attribute8			varchar2,
  X_attribute9			varchar2,
  X_attribute10			varchar2,
  X_attribute11			varchar2,
  X_attribute12			varchar2,
  X_attribute13			varchar2,
  X_attribute14			varchar2,
  X_attribute15			varchar2,
  X_last_update_date            date,
  X_last_updated_by             number,
  X_last_update_login           number)
is
begin

  update wsh_departure_templates set

    departure_template_id	= X_departure_template_id,
    name			= X_name,
    organization_id		= X_organization_id,
    vehicle_item_id		= X_vehicle_item_id,
    vehicle_number 		= X_vehicle_number ,
    freight_carrier_code	= X_freight_carrier_code,
    planned_frequency		= X_planned_frequency,
    planned_day			= X_planned_day,
    planned_time		= X_planned_time,
    weight_uom_code		= X_weight_uom_code,
    volume_uom_code		= X_volume_uom_code,
    routing_instructions	= X_routing_instructions,
    attribute_category		= X_attribute_category,
    attribute1			= X_attribute1,
    attribute2			= X_attribute2,
    attribute3			= X_attribute3,
    attribute4			= X_attribute4,
    attribute5			= X_attribute5,
    attribute6			= X_attribute6,
    attribute7			= X_attribute7,
    attribute8			= X_attribute8,
    attribute9			= X_attribute9,
    attribute10			= X_attribute10,
    attribute11			= X_attribute11,
    attribute12			= X_attribute12,
    attribute13			= X_attribute13,
    attribute14			= X_attribute14,
    attribute15			= X_attribute15,
    last_update_date		= X_last_update_date,
    last_updated_by		= X_last_updated_by,
    last_update_login		= X_last_update_login

  where rowid = X_rowid;

Line: 471

end update_row;

Line: 487

procedure delete_row(X_rowid varchar2)
is
begin

  delete from wsh_departure_templates
  where rowid = X_rowid;

Line: 498

end delete_row;