APPS.CSP_EXCESS_LISTS_PKG_W SQL Statements

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

Line: 66

          t(ddindx).last_updated_by := a7(indx);

Line: 67

          t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a8(indx));

Line: 68

          t(ddindx).last_update_login := a9(indx);

Line: 259

          a7(indx) := t(ddindx).last_updated_by;

Line: 260

          a8(indx) := t(ddindx).last_update_date;

Line: 261

          a9(indx) := t(ddindx).last_update_login;

Line: 297

  procedure insert_row(px_excess_line_id in out nocopy  NUMBER
    , p_created_by  NUMBER
    , p_creation_date  date
    , p_last_updated_by  NUMBER
    , p_last_update_date  date
    , p_last_update_login  NUMBER
    , p_organization_id  NUMBER
    , p_subinventory_code  VARCHAR2
    , p_condition_code  VARCHAR2
    , p_inventory_item_id  NUMBER
    , p_excess_quantity  NUMBER
    , p_requisition_line_id  NUMBER
    , p_returned_quantity  NUMBER
    , p_current_return_qty  NUMBER
    , p_excess_status  VARCHAR2
    , p_return_org_id  NUMBER
    , p_return_sub_inv  VARCHAR2
    , p_attribute_category  VARCHAR2
    , p_attribute1  VARCHAR2
    , p_attribute2  VARCHAR2
    , p_attribute3  VARCHAR2
    , p_attribute4  VARCHAR2
    , p_attribute5  VARCHAR2
    , p_attribute6  VARCHAR2
    , p_attribute7  VARCHAR2
    , p_attribute8  VARCHAR2
    , p_attribute9  VARCHAR2
    , p_attribute10  VARCHAR2
    , p_attribute11  VARCHAR2
    , p_attribute12  VARCHAR2
    , p_attribute13  VARCHAR2
    , p_attribute14  VARCHAR2
    , p_attribute15  VARCHAR2
  )

  as
    ddp_creation_date date;

Line: 334

    ddp_last_update_date date;

Line: 344

    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);

Line: 375

    csp_excess_lists_pkg.insert_row(px_excess_line_id,
      p_created_by,
      ddp_creation_date,
      p_last_updated_by,
      ddp_last_update_date,
      p_last_update_login,
      p_organization_id,
      p_subinventory_code,
      p_condition_code,
      p_inventory_item_id,
      p_excess_quantity,
      p_requisition_line_id,
      p_returned_quantity,
      p_current_return_qty,
      p_excess_status,
      p_return_org_id,
      p_return_sub_inv,
      p_attribute_category,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15);

Line: 444

  procedure update_row(p_excess_line_id  NUMBER
    , p_created_by  NUMBER
    , p_creation_date  date
    , p_last_updated_by  NUMBER
    , p_last_update_date  date
    , p_last_update_login  NUMBER
    , p_organization_id  NUMBER
    , p_subinventory_code  VARCHAR2
    , p_condition_code  VARCHAR2
    , p_inventory_item_id  NUMBER
    , p_excess_quantity  NUMBER
    , p_requisition_line_id  NUMBER
    , p_returned_quantity  NUMBER
    , p_current_return_qty  NUMBER
    , p_attribute_category  VARCHAR2
    , p_attribute1  VARCHAR2
    , p_attribute2  VARCHAR2
    , p_attribute3  VARCHAR2
    , p_attribute4  VARCHAR2
    , p_attribute5  VARCHAR2
    , p_attribute6  VARCHAR2
    , p_attribute7  VARCHAR2
    , p_attribute8  VARCHAR2
    , p_attribute9  VARCHAR2
    , p_attribute10  VARCHAR2
    , p_attribute11  VARCHAR2
    , p_attribute12  VARCHAR2
    , p_attribute13  VARCHAR2
    , p_attribute14  VARCHAR2
    , p_attribute15  VARCHAR2
  )

  as
    ddp_creation_date date;

Line: 478

    ddp_last_update_date date;

Line: 488

    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);

Line: 516

    csp_excess_lists_pkg.update_row(p_excess_line_id,
      p_created_by,
      ddp_creation_date,
      p_last_updated_by,
      ddp_last_update_date,
      p_last_update_login,
      p_organization_id,
      p_subinventory_code,
      p_condition_code,
      p_inventory_item_id,
      p_excess_quantity,
      p_requisition_line_id,
      p_returned_quantity,
      p_current_return_qty,
      p_attribute_category,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15);

Line: 582

    , p_last_updated_by  NUMBER
    , p_last_update_date  date
    , p_last_update_login  NUMBER
    , p_organization_id  NUMBER
    , p_subinventory_code  VARCHAR2
    , p_condition_code  VARCHAR2
    , p_inventory_item_id  NUMBER
    , p_excess_quantity  NUMBER
    , p_requisition_line_id  NUMBER
    , p_returned_quantity  NUMBER
    , p_current_return_qty  NUMBER
    , p_attribute_category  VARCHAR2
    , p_attribute1  VARCHAR2
    , p_attribute2  VARCHAR2
    , p_attribute3  VARCHAR2
    , p_attribute4  VARCHAR2
    , p_attribute5  VARCHAR2
    , p_attribute6  VARCHAR2
    , p_attribute7  VARCHAR2
    , p_attribute8  VARCHAR2
    , p_attribute9  VARCHAR2
    , p_attribute10  VARCHAR2
    , p_attribute11  VARCHAR2
    , p_attribute12  VARCHAR2
    , p_attribute13  VARCHAR2
    , p_attribute14  VARCHAR2
    , p_attribute15  VARCHAR2
  )

  as
    ddp_creation_date date;

Line: 613

    ddp_last_update_date date;

Line: 623

    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);

Line: 654

      p_last_updated_by,
      ddp_last_update_date,
      p_last_update_login,
      p_organization_id,
      p_subinventory_code,
      p_condition_code,
      p_inventory_item_id,
      p_excess_quantity,
      p_requisition_line_id,
      p_returned_quantity,
      p_current_return_qty,
      p_attribute_category,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15);