APPS.AMS_DELIVKITITEM_PVT SQL Statements

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

Line: 45

   SELECT ams_deliv_kit_items_s.NEXTVAL
     FROM DUAL;

Line: 49

   SELECT COUNT(*)
     FROM ams_deliv_kit_items
    WHERE deliverable_kit_item_id = deliv_kit_item_id;

Line: 55

   SELECT kit_flag
     FROM ams_deliverables_all_b
    WHERE deliverable_id = deliv_kit_item_id;

Line: 62

   SELECT COUNT(*)
     FROM ams_deliv_kit_items
    WHERE deliverable_kit_part_id = deliv_kit_id;*/

Line: 116

   AMS_Utility_PVT.debug_message(l_full_name ||': insert');

Line: 165

   INSERT INTO ams_deliv_kit_items
   (
      deliverable_kit_item_id,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      last_update_login,
      object_version_number,
      deliverable_kit_id,
      deliverable_kit_part_id,
      kit_part_included_from_kit_id,
      quantity,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
      ) VALUES (
      l_deliv_kit_item_rec.deliverable_kit_item_id,
      SYSDATE,
      FND_GLOBAL.user_id,
      SYSDATE,
      FND_GLOBAL.user_id,
      FND_GLOBAL.conc_login_id,
      1,  -- object_version_number
      l_deliv_kit_item_rec.deliverable_kit_id,
      l_deliv_kit_item_rec.deliverable_kit_part_id,
      l_deliv_kit_item_rec.kit_part_included_from_kit_id,
      l_deliv_kit_item_rec.quantity,
      l_deliv_kit_item_rec.attribute_category,
      l_deliv_kit_item_rec.attribute1,
      l_deliv_kit_item_rec.attribute2,
      l_deliv_kit_item_rec.attribute3,
      l_deliv_kit_item_rec.attribute4,
      l_deliv_kit_item_rec.attribute5,
      l_deliv_kit_item_rec.attribute6,
      l_deliv_kit_item_rec.attribute7,
      l_deliv_kit_item_rec.attribute8,
      l_deliv_kit_item_rec.attribute9,
      l_deliv_kit_item_rec.attribute10,
      l_deliv_kit_item_rec.attribute11,
      l_deliv_kit_item_rec.attribute12,
      l_deliv_kit_item_rec.attribute13,
      l_deliv_kit_item_rec.attribute14,
      l_deliv_kit_item_rec.attribute15
   );

Line: 233

   UPDATE ams_deliverables_all_b
      SET kit_flag = 'Y'
    WHERE deliverable_id = l_deliv_kit_item_rec.deliverable_kit_id;

Line: 331

PROCEDURE delete_deliv_kit_item
(
  p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2 := FND_API.g_false,
  p_commit              IN      VARCHAR2 := FND_API.g_false,

  x_return_status OUT NOCOPY VARCHAR2,
  x_msg_count    OUT NOCOPY NUMBER,
  x_msg_data     OUT NOCOPY VARCHAR2,

  p_deliv_kit_item_id   IN      NUMBER,
  p_object_version      IN      NUMBER
)

IS

  l_api_version CONSTANT NUMBER       := 1.0;

Line: 348

  l_api_name    CONSTANT VARCHAR2(30) := 'delete_deliv_kit_item';

Line: 355

  SELECT COUNT(*)
    FROM ams_deliv_kit_items
   WHERE deliverable_kit_id =
       ( SELECT deliverable_kit_id
           FROM ams_deliv_kit_items
          WHERE deliverable_kit_item_id = kit_item_id);

Line: 363

  SELECT deliverable_kit_id
    FROM ams_deliv_kit_items
   WHERE deliverable_kit_item_id = kit_item_id;

Line: 370

   SAVEPOINT delete_deliv_kit_item;

Line: 398

   AMS_Utility_PVT.debug_message(l_full_name ||': delete');

Line: 409

   DELETE FROM ams_deliv_kit_items
   WHERE deliverable_kit_item_id = p_deliv_kit_item_id
   AND object_version_number = p_object_version;

Line: 426

   AMS_Utility_PVT.debug_message(l_full_name ||': after delete');

Line: 494

      ROLLBACK TO delete_deliv_kit_item;

Line: 503

      ROLLBACK TO delete_deliv_kit_item;

Line: 512

      ROLLBACK TO delete_deliv_kit_item;

Line: 526

END delete_deliv_kit_item;

Line: 558

   SELECT deliverable_kit_item_id
     FROM ams_deliv_kit_items
    WHERE deliverable_kit_item_id = p_deliv_kit_item_id
      AND object_version_number = p_object_version
   FOR UPDATE OF deliverable_kit_item_id NOWAIT;

Line: 675

PROCEDURE update_deliv_kit_item
(
  p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2 := FND_API.g_false,
  p_commit              IN      VARCHAR2 := FND_API.g_false,
  p_validation_level    IN      NUMBER   := FND_API.g_valid_level_full,

  x_return_status OUT NOCOPY VARCHAR2,
  x_msg_count    OUT NOCOPY NUMBER,
  x_msg_data     OUT NOCOPY VARCHAR2,

  p_deliv_kit_item_rec  IN      deliv_kit_item_rec_type
)

IS

   l_api_version CONSTANT NUMBER := 1.0;

Line: 692

   l_api_name    CONSTANT VARCHAR2(30) := 'update_deliv_kit_item';

Line: 701

   SAVEPOINT update_deliv_kit_item;

Line: 736

         p_validation_mode    => JTF_PLSQL_API.g_update,
         x_return_status      => l_return_status
      );

Line: 768

   AMS_Utility_PVT.debug_message(l_full_name ||': update');

Line: 771

   UPDATE ams_deliv_kit_items SET
      last_update_date = SYSDATE,
      last_updated_by = FND_GLOBAL.user_id,
      last_update_login = FND_GLOBAL.conc_login_id,
      object_version_number = l_deliv_kit_item_rec.object_version_number + 1,
      deliverable_kit_id = l_deliv_kit_item_rec.deliverable_kit_id,
      deliverable_kit_part_id = l_deliv_kit_item_rec.deliverable_kit_part_id,
      kit_part_included_from_kit_id = l_deliv_kit_item_rec.kit_part_included_from_kit_id,
      quantity = l_deliv_kit_item_rec.quantity,
      attribute_category = l_deliv_kit_item_rec.attribute_category,
      attribute1 = l_deliv_kit_item_rec.attribute1,
      attribute2 = l_deliv_kit_item_rec.attribute2,
      attribute3 = l_deliv_kit_item_rec.attribute3,
      attribute4 = l_deliv_kit_item_rec.attribute4,
      attribute5 = l_deliv_kit_item_rec.attribute5,
      attribute6 = l_deliv_kit_item_rec.attribute6,
      attribute7 = l_deliv_kit_item_rec.attribute7,
      attribute8 = l_deliv_kit_item_rec.attribute8,
      attribute9 = l_deliv_kit_item_rec.attribute9,
      attribute10 = l_deliv_kit_item_rec.attribute10,
      attribute11 = l_deliv_kit_item_rec.attribute11,
      attribute12 = l_deliv_kit_item_rec.attribute12,
      attribute13 = l_deliv_kit_item_rec.attribute13,
      attribute14 = l_deliv_kit_item_rec.attribute14,
      attribute15 = l_deliv_kit_item_rec.attribute15
   WHERE deliverable_kit_item_id = l_deliv_kit_item_rec.deliverable_kit_item_id
   AND object_version_number = l_deliv_kit_item_rec.object_version_number;

Line: 829

      ROLLBACK TO update_deliv_kit_item;

Line: 838

      ROLLBACK TO update_deliv_kit_item;

Line: 847

      ROLLBACK TO update_deliv_kit_item;

Line: 861

END update_deliv_kit_item;

Line: 1189

SELECT DECODE(can_fulfill_electronic_flag, 'Y', 'ELEC','PHYS')
FROM  ams_Deliverables_all_b
where deliverable_id = p_deliv_id;

Line: 1196

SELECT DECODE(inventory_flag, 'Y', 'INVN','PHYS') TYPE
       ,nvl(non_inv_quantity_on_hand,-99999) Quantity
FROM  ams_Deliverables_all_b
where deliverable_id = p_deliv_id;

Line: 1414

   x_deliv_kit_item_rec.last_update_date := FND_API.g_miss_date;

Line: 1415

   x_deliv_kit_item_rec.last_updated_by := FND_API.g_miss_num;

Line: 1418

   x_deliv_kit_item_rec.last_update_login := FND_API.g_miss_num;

Line: 1461

   SELECT *
     FROM ams_deliv_kit_items
    WHERE deliverable_kit_item_id = p_deliv_kit_item_rec.deliverable_kit_item_id;