APPS.WSH_DELIVERY_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_delivery_template_id            in out number,
  X_name                            varchar2,
  X_organization_id                 number,
  X_planned_dep_template_id         number,
  X_loading_order_flag              varchar2,
  X_sequence_number                 number,
  X_customer_id                     number,
  X_ultimate_ship_to_id             number,
  X_intermediate_ship_to_id         number,
  X_pooled_ship_to_id               number,
  X_weight_uom_code                 varchar2,
  X_volume_uom_code                 varchar2,
  X_expected_arrival_day_offset     number,
  X_expected_arrival_hour_offset    number,
  X_expected_arrival_min_offset     number,
  X_planned_frequency               varchar2,
  X_planned_day                     varchar2,
  X_planned_time                    number,
  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_global_attribute_category       varchar2 default null,
  X_global_attribute1               varchar2 default null,
  X_global_attribute2               varchar2 default null,
  X_global_attribute3               varchar2 default null,
  X_global_attribute4               varchar2 default null,
  X_global_attribute5               varchar2 default null,
  X_global_attribute6               varchar2 default null,
  X_global_attribute7               varchar2 default null,
  X_global_attribute8               varchar2 default null,
  X_global_attribute9               varchar2 default null,
  X_global_attribute10              varchar2 default null,
  X_global_attribute11              varchar2 default null,
  X_global_attribute12              varchar2 default null,
  X_global_attribute13              varchar2 default null,
  X_global_attribute14              varchar2 default null,
  X_global_attribute15              varchar2 default null,
  X_global_attribute16              varchar2 default null,
  X_global_attribute17              varchar2 default null,
  X_global_attribute18              varchar2 default null,
  X_global_attribute19              varchar2 default null,
  X_global_attribute20              varchar2 default null,
  X_creation_date                   date,
  X_created_by                      number,
  X_last_update_date                date,
  X_last_updated_by                 number,
  X_last_update_login               number)
is

  X_dummy     varchar2(18);

Line: 85

    select wsh_delivery_templates_s.nextval
    from sys.dual;

Line: 89

    select rowid
    from wsh_delivery_templates
    where delivery_template_id = X_delivery_template_id;

Line: 96

    select rowid
    into X_dummy
    from wsh_departure_templates
    where departure_template_id = X_planned_dep_template_id
    for update nowait;

Line: 107

  insert into wsh_delivery_templates(

    delivery_template_id,
    name,
    organization_id,
    planned_dep_template_id,
    loading_order_flag,
    sequence_number,
    customer_id,
    ultimate_ship_to_id,
    intermediate_ship_to_id,
    pooled_ship_to_id,
    weight_uom_code,
    volume_uom_code,
    expected_arrival_day_offset,
    expected_arrival_hour_offset,
    expected_arrival_min_offset,
    planned_frequency,
    planned_day,
    planned_time,
    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_delivery_template_id,
    X_name,
    X_organization_id,
    X_planned_dep_template_id,
    X_loading_order_flag,
    X_sequence_number,
    X_customer_id,
    X_ultimate_ship_to_id,
    X_intermediate_ship_to_id,
    X_pooled_ship_to_id,
    X_weight_uom_code,
    X_volume_uom_code,
    X_expected_arrival_day_offset,
    X_expected_arrival_hour_offset,
    X_expected_arrival_min_offset,
    X_planned_frequency,
    X_planned_day,
    X_planned_time,
    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: 212

end insert_row;

Line: 289

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

Line: 305

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

Line: 599

procedure update_row(
  X_rowid                           varchar2,
  X_delivery_template_id            number,
  X_name                            varchar2,
  X_organization_id                 number,
  X_planned_dep_template_id         number,
  X_loading_order_flag              varchar2,
  X_sequence_number                 number,
  X_customer_id                     number,
  X_ultimate_ship_to_id             number,
  X_intermediate_ship_to_id         number,
  X_pooled_ship_to_id               number,
  X_weight_uom_code                 varchar2,
  X_volume_uom_code                 varchar2,
  X_expected_arrival_day_offset     number,
  X_expected_arrival_hour_offset    number,
  X_expected_arrival_min_offset     number,
  X_planned_frequency               varchar2,
  X_planned_day                     varchar2,
  X_planned_time                    number,
  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_global_attribute_category       varchar2 default null,
  X_global_attribute1               varchar2 default null,
  X_global_attribute2               varchar2 default null,
  X_global_attribute3               varchar2 default null,
  X_global_attribute4               varchar2 default null,
  X_global_attribute5               varchar2 default null,
  X_global_attribute6               varchar2 default null,
  X_global_attribute7               varchar2 default null,
  X_global_attribute8               varchar2 default null,
  X_global_attribute9               varchar2 default null,
  X_global_attribute10              varchar2 default null,
  X_global_attribute11              varchar2 default null,
  X_global_attribute12              varchar2 default null,
  X_global_attribute13              varchar2 default null,
  X_global_attribute14              varchar2 default null,
  X_global_attribute15              varchar2 default null,
  X_global_attribute16              varchar2 default null,
  X_global_attribute17              varchar2 default null,
  X_global_attribute18              varchar2 default null,
  X_global_attribute19              varchar2 default null,
  X_global_attribute20              varchar2 default null,
  X_last_update_date                date,
  X_last_updated_by                 number,
  X_last_update_login               number)
is
  X_dummy		  varchar2(18);

Line: 664

    select rowid
    into X_dummy
    from wsh_departure_templates
    where departure_template_id = X_planned_dep_template_id
    for update nowait;

Line: 671

  update wsh_delivery_templates set

    delivery_template_id            = X_delivery_template_id,
    name                            = X_name,
    organization_id                 = X_organization_id,
    planned_dep_template_id         = X_planned_dep_template_id,
    loading_order_flag              = X_loading_order_flag,
    sequence_number                 = X_sequence_number,
    customer_id                     = X_customer_id,
    ultimate_ship_to_id             = X_ultimate_ship_to_id,
    intermediate_ship_to_id         = X_intermediate_ship_to_id,
    pooled_ship_to_id               = X_pooled_ship_to_id,
    weight_uom_code                 = X_weight_uom_code,
    volume_uom_code                 = X_volume_uom_code,
    expected_arrival_day_offset     = X_expected_arrival_day_offset,
    expected_arrival_hour_offset    = X_expected_arrival_hour_offset,
    expected_arrival_min_offset     = X_expected_arrival_min_offset,
    planned_frequency               = X_planned_frequency,
    planned_day                     = X_planned_day,
    planned_time                    = X_planned_time,
    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,
    global_attribute_category       = X_global_attribute_category,
    global_attribute1               = X_global_attribute1,
    global_attribute2               = X_global_attribute2,
    global_attribute3               = X_global_attribute3,
    global_attribute4               = X_global_attribute4,
    global_attribute5               = X_global_attribute5,
    global_attribute6               = X_global_attribute6,
    global_attribute7               = X_global_attribute7,
    global_attribute8               = X_global_attribute8,
    global_attribute9               = X_global_attribute9,
    global_attribute10              = X_global_attribute10,
    global_attribute11              = X_global_attribute11,
    global_attribute12              = X_global_attribute12,
    global_attribute13              = X_global_attribute13,
    global_attribute14              = X_global_attribute14,
    global_attribute15              = X_global_attribute15,
    global_attribute16              = X_global_attribute16,
    global_attribute17              = X_global_attribute17,
    global_attribute18              = X_global_attribute18,
    global_attribute19              = X_global_attribute19,
    global_attribute20              = X_global_attribute20,
    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: 747

end update_row;

Line: 763

procedure delete_row(X_rowid varchar2)
is
begin

  delete from wsh_delivery_templates
  where rowid = X_rowid;

Line: 774

end delete_row;