APPS.CSD_REPAIR_GROUPS_PVT SQL Statements

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

Line: 38

  SELECT CSD_REPAIR_ORDER_GROUPS_S1.NEXTVAL
  FROM sys.dual;

Line: 235

  csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Insert_Row');

Line: 239

  CSD_REPAIR_ORDER_GROUPS_PKG.Insert_Row
  (px_REPAIR_GROUP_ID          =>  l_repair_group_id,
   p_INCIDENT_ID               =>  x_repair_order_group_rec.incident_id,
   p_REPAIR_GROUP_NUMBER       =>  l_repair_group_number,
   p_REPAIR_TYPE_ID            =>  x_repair_order_group_rec.repair_type_id,
   p_WIP_ENTITY_ID             =>  x_repair_order_group_rec.wip_entity_id,
   p_INVENTORY_ITEM_ID         =>  x_repair_order_group_rec.inventory_item_id,
   p_UNIT_OF_MEASURE           =>  x_repair_order_group_rec.unit_of_measure,
   p_GROUP_QUANTITY            =>  x_repair_order_group_rec.group_quantity,
   p_REPAIR_ORDER_QUANTITY     =>  x_repair_order_group_rec.repair_order_quantity,
   p_RMA_QUANTITY              =>  x_repair_order_group_rec.rma_quantity,
   p_RECEIVED_QUANTITY         =>  x_repair_order_group_rec.received_quantity,
   p_APPROVED_QUANTITY         =>  x_repair_order_group_rec.approved_quantity,
   p_SUBMITTED_QUANTITY        =>  x_repair_order_group_rec.submitted_quantity,
   p_COMPLETED_QUANTITY        =>  x_repair_order_group_rec.completed_quantity,
   p_RELEASED_QUANTITY         =>  x_repair_order_group_rec.released_quantity,
   p_SHIPPED_QUANTITY          =>  x_repair_order_group_rec.shipped_quantity,
   p_CREATED_BY                =>  FND_GLOBAL.USER_ID,
   p_CREATION_DATE             =>  SYSDATE,
   p_LAST_UPDATED_BY           =>  FND_GLOBAL.USER_ID,
   p_LAST_UPDATE_DATE          =>  SYSDATE,
   p_LAST_UPDATE_LOGIN         =>  FND_GLOBAL.LOGIN_ID,
   p_CONTEXT                   =>  x_repair_order_group_rec.context,
   p_ATTRIBUTE1                =>  x_repair_order_group_rec.attribute1,
   p_ATTRIBUTE2                =>  x_repair_order_group_rec.attribute2,
   p_ATTRIBUTE3                =>  x_repair_order_group_rec.attribute3,
   p_ATTRIBUTE4                =>  x_repair_order_group_rec.attribute4,
   p_ATTRIBUTE5                =>  x_repair_order_group_rec.attribute5,
   p_ATTRIBUTE6                =>  x_repair_order_group_rec.attribute6,
   p_ATTRIBUTE7                =>  x_repair_order_group_rec.attribute7,
   p_ATTRIBUTE8                =>  x_repair_order_group_rec.attribute8,
   p_ATTRIBUTE9                =>  x_repair_order_group_rec.attribute9,
   p_ATTRIBUTE10               =>  x_repair_order_group_rec.attribute10,
   p_ATTRIBUTE11               =>  x_repair_order_group_rec.attribute11,
   p_ATTRIBUTE12               =>  x_repair_order_group_rec.attribute12,
   p_ATTRIBUTE13               =>  x_repair_order_group_rec.attribute13,
   p_ATTRIBUTE14               =>  x_repair_order_group_rec.attribute14,
   p_ATTRIBUTE15               =>  x_repair_order_group_rec.attribute15,
   p_OBJECT_VERSION_NUMBER     =>  1,
   p_GROUP_TXN_STATUS          =>  x_repair_order_group_rec.group_txn_status,
   p_GROUP_APPROVAL_STATUS     =>  x_repair_order_group_rec.group_approval_status,
   p_REPAIR_MODE               =>  x_repair_order_group_rec.repair_mode);

Line: 343

PROCEDURE UPDATE_REPAIR_GROUPS
( p_api_version              IN     NUMBER,
  p_commit                   IN     VARCHAR2,
  p_init_msg_list            IN     VARCHAR2,
  p_validation_level         IN     NUMBER,
  x_repair_order_group_rec   IN OUT NOCOPY CSD_REPAIR_GROUPS_PVT.REPAIR_ORDER_GROUP_REC,
  x_return_status            OUT NOCOPY    VARCHAR2,
  x_msg_count                OUT NOCOPY    NUMBER,
  x_msg_data                 OUT NOCOPY    VARCHAR2
)
IS

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

Line: 370

  SELECT
     repair_group_id,
     object_version_number
  FROM  csd_repair_order_groups
  WHERE repair_group_id = p_repair_group_id;

Line: 381

   SAVEPOINT  update_repair_order_group;

Line: 456

  csd_gen_utility_pvt.ADD('Fetch the Group Id for Update');

Line: 514

    SELECT
      count(*)
    INTO l_count
    FROM csd_repairs
    WHERE repair_group_id = x_repair_order_group_rec.repair_group_id;

Line: 530

      Select
       inventory_item_id,
       repair_type_id,
       unit_of_measure,
       group_quantity
      into
       l_inventory_item_id,
       l_repair_type_id,
       l_unit_of_measure,
       l_group_quantity
      from csd_repair_order_groups
      where repair_group_id = x_repair_order_group_rec.repair_group_id;

Line: 557

        FND_MESSAGE.SET_NAME('CSD','CSD_API_UPDATE_NOT_ALLOWED');

Line: 571

  csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Update_Row');

Line: 575

  CSD_REPAIR_ORDER_GROUPS_PKG.Update_Row(
    p_REPAIR_GROUP_ID         =>  x_repair_order_group_rec.repair_group_id,
    p_INCIDENT_ID             =>  x_repair_order_group_rec.incident_id,
    p_REPAIR_GROUP_NUMBER     =>  x_repair_order_group_rec.repair_group_number,
    p_REPAIR_TYPE_ID          =>  x_repair_order_group_rec.repair_type_id,
    p_WIP_ENTITY_ID           =>  x_repair_order_group_rec.wip_entity_id,
    p_INVENTORY_ITEM_ID       =>  x_repair_order_group_rec.inventory_item_id,
    p_UNIT_OF_MEASURE         =>  x_repair_order_group_rec.unit_of_measure,
    p_GROUP_QUANTITY          =>  x_repair_order_group_rec.group_quantity,
    p_REPAIR_ORDER_QUANTITY   =>  x_repair_order_group_rec.repair_order_quantity,
    p_RMA_QUANTITY            =>  x_repair_order_group_rec.rma_quantity,
    p_RECEIVED_QUANTITY       =>  x_repair_order_group_rec.received_quantity,
    p_APPROVED_QUANTITY       =>  x_repair_order_group_rec.approved_quantity,
    p_SUBMITTED_QUANTITY      =>  x_repair_order_group_rec.submitted_quantity,
    p_COMPLETED_QUANTITY      =>  x_repair_order_group_rec.completed_quantity,
    p_RELEASED_QUANTITY       =>  x_repair_order_group_rec.released_quantity,
    p_SHIPPED_QUANTITY        =>  x_repair_order_group_rec.shipped_quantity,
    p_CREATED_BY              =>  FND_GLOBAL.USER_ID,
    p_CREATION_DATE           =>  SYSDATE,
    p_LAST_UPDATED_BY         =>  FND_GLOBAL.USER_ID,
    p_LAST_UPDATE_DATE        =>  SYSDATE,
    p_LAST_UPDATE_LOGIN       =>  FND_GLOBAL.LOGIN_ID,
    p_CONTEXT                 =>  x_repair_order_group_rec.context,
    p_ATTRIBUTE1              =>  x_repair_order_group_rec.attribute1,
    p_ATTRIBUTE2              =>  x_repair_order_group_rec.attribute2,
    p_ATTRIBUTE3              =>  x_repair_order_group_rec.attribute3,
    p_ATTRIBUTE4              =>  x_repair_order_group_rec.attribute4,
    p_ATTRIBUTE5              =>  x_repair_order_group_rec.attribute5,
    p_ATTRIBUTE6              =>  x_repair_order_group_rec.attribute6,
    p_ATTRIBUTE7              =>  x_repair_order_group_rec.attribute7,
    p_ATTRIBUTE8              =>  x_repair_order_group_rec.attribute8,
    p_ATTRIBUTE9              =>  x_repair_order_group_rec.attribute9,
    p_ATTRIBUTE10             =>  x_repair_order_group_rec.attribute10,
    p_ATTRIBUTE11             =>  x_repair_order_group_rec.attribute11,
    p_ATTRIBUTE12             =>  x_repair_order_group_rec.attribute12,
    p_ATTRIBUTE13             =>  x_repair_order_group_rec.attribute13,
    p_ATTRIBUTE14             =>  x_repair_order_group_rec.attribute14,
    p_ATTRIBUTE15             =>  x_repair_order_group_rec.attribute15,
    p_OBJECT_VERSION_NUMBER   =>  l_obj_ver_num + 1,
    p_GROUP_TXN_STATUS        =>  x_repair_order_group_rec.group_txn_status,
    p_GROUP_APPROVAL_STATUS     =>  x_repair_order_group_rec.group_approval_status,
    p_REPAIR_MODE               =>  x_repair_order_group_rec.repair_mode);

Line: 640

        ROLLBACK TO update_group_repair_order;

Line: 646

        ROLLBACK TO update_group_repair_order;

Line: 652

        ROLLBACK TO update_group_repair_order;

Line: 664

END UPDATE_REPAIR_GROUPS;

Line: 674

PROCEDURE DELETE_REPAIR_GROUPS
( p_api_version              IN     NUMBER,
  p_commit                   IN     VARCHAR2,
  p_init_msg_list            IN     VARCHAR2,
  p_validation_level         IN     NUMBER,
  p_repair_group_id          IN     NUMBER,
  x_return_status            OUT NOCOPY    VARCHAR2,
  x_msg_count                OUT NOCOPY    NUMBER,
  x_msg_data                 OUT NOCOPY    VARCHAR2
)
IS

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

Line: 699

   SAVEPOINT  delete_repair_order_group;

Line: 764

    SELECT
      count(*)
    INTO l_count
    FROM csd_repairs
    WHERE repair_group_id = p_repair_group_id;

Line: 788

  csd_gen_utility_pvt.ADD('Calling : CSD_REPAIR_ORDER_GROUPS_PKG.Delete_Row');

Line: 792

  CSD_REPAIR_ORDER_GROUPS_PKG.Delete_Row
    ( p_REPAIR_GROUP_ID  => p_repair_group_id);

Line: 814

        ROLLBACK TO delete_repair_order_group;

Line: 820

        ROLLBACK TO delete_repair_order_group;

Line: 826

        ROLLBACK TO delete_repair_order_group;

Line: 838

END DELETE_REPAIR_GROUPS;

Line: 998

  SELECT repair_line_id,repair_number from csd_repairs
  WHERE repair_group_id = p_repair_order_group
  FOR UPDATE NOWAIT;

Line: 1093

      SELECT
        'x'
      INTO l_dummy
      FROM jtf_rs_resource_extns
      WHERE resource_id = p_resource_id;

Line: 1114

  csd_gen_utility_pvt.ADD('Update the Repair Orders');

Line: 1129

      select object_version_number
      into l_object_version_number
      from csd_repairs
      where repair_line_id = RO_record.repair_line_id;

Line: 1141

    CSD_REPAIRS_PVT.Update_Repair_Order
      (P_Api_Version_Number    => 1.0,
       P_Init_Msg_List         => 'T',
       P_Commit                => 'F',
       p_validation_level      => 0,
       p_REPAIR_LINE_ID        => RO_record.repair_line_id,
       P_REPLN_Rec             => l_ro_rec,
       X_Return_Status         => l_return_status,
       X_Msg_Count             => l_msg_count,
       X_Msg_Data              => l_msg_data
     );

Line: 1174

      select object_version_number,
           group_quantity
      into l_group_object_version_number,
         l_group_quantity
      from csd_repair_order_groups_v
      where repair_group_id = p_repair_group_id;

Line: 1195

      SELECT COUNT(*)
        INTO l_tot_approved
        FROM csd_repairs
       WHERE repair_group_id = p_repair_group_id
         AND approval_status = 'A'
         AND approval_required_flag = 'Y';

Line: 1211

      SELECT COUNT(*)
        INTO l_tot_rejected
        FROM csd_repairs
      WHERE repair_group_id = p_repair_group_id
      AND approval_status = 'R'
      AND approval_required_flag = 'Y';

Line: 1226

      SELECT COUNT(*)
        INTO l_tot_no_approval
      FROM csd_repairs
      WHERE repair_group_id = p_repair_group_id
           AND approval_required_flag = 'N';

Line: 1289

    csd_gen_utility_pvt.ADD('CSD_REPAIR_ESTIMATE_PVT.UPDATE_RO_GROUP_ESTIMATE Update Group RO call');

Line: 1297

    CSD_REPAIR_GROUPS_PVT.UPDATE_REPAIR_GROUPS
    ( p_api_version             => 1.0,
      p_commit                  => 'F',
      p_init_msg_list           => 'T',
      p_validation_level        => fnd_api.g_valid_level_full,
      x_repair_order_group_rec  => l_group_ro_rec,
      x_return_status           => l_return_status,
      x_msg_count               => l_msg_count,
      x_msg_data                => l_msg_data  );

Line: 1308

         csd_gen_utility_pvt.ADD('CSD_REPAIR_ESTIMATE_PVT.UPDATE_RO_GROUP_ESTIMATE UPDATE_REPAIR_GROUPS :'||x_return_status);