APPS.AHL_FMP_MR_INTERVAL_PVT SQL Statements

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

Line: 359

SELECT  DECODE( relationship_id, null,
                                 inventory_item_id,
                                 position_inventory_item_id ),
        DECODE( relationship_id, null,
                                 item_number,
                                 position_item_number ),
        relationship_id,
        position_ref_meaning
FROM    AHL_MR_EFFECTIVITIES_V
WHERE   mr_effectivity_id = c_mr_effectivity_id;

Line: 447

  p_x_interval_rec.last_update_date := SYSDATE;

Line: 448

  p_x_interval_rec.last_updated_by := FND_GLOBAL.user_id;

Line: 449

  p_x_interval_rec.last_update_login := FND_GLOBAL.login_id;

Line: 633

SELECT  counter_id,
        interval_value,
        earliest_due_value,
        start_value,
        stop_value,
        tolerance_before,
        tolerance_after,
        reset_value,
        start_date,
        stop_date,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15
FROM    AHL_MR_INTERVALS_APP_V
WHERE   mr_interval_id = c_mr_interval_id;

Line: 1084

    SELECT  NVL( initial_reading, 0 )
    INTO    l_initial_reading
    FROM    csi_counter_template_vl --amsriniv
    WHERE   counter_id = p_interval_rec.counter_id;

Line: 1199

SELECT   counter_id,
         counter_name
FROM     AHL_MR_INTERVALS_V
WHERE    mr_effectivity_id = c_mr_effectivity_id
GROUP BY counter_id,
         counter_name
HAVING   count(*) > 1;

Line: 1209

SELECT   counter_id,
         counter_name,
         start_value,
         stop_value,
         start_date,
         stop_date
FROM     AHL_MR_INTERVALS_V
WHERE    mr_effectivity_id = c_mr_effectivity_id
GROUP BY counter_id,
         counter_name,
         start_value,
         stop_value,
         start_date,
         stop_date
HAVING   count(*) > 1;

Line: 1227

SELECT   counter_id,
         counter_name,
         start_date,
         stop_date
FROM     AHL_MR_INTERVALS_V
WHERE    mr_effectivity_id = c_mr_effectivity_id
ORDER BY counter_id,
         start_date,
         stop_date;

Line: 1239

SELECT   counter_id,
         counter_name,
         earliest_due_value,
         start_value,
         stop_value
FROM     AHL_MR_INTERVALS_V
WHERE    mr_effectivity_id = c_mr_effectivity_id
ORDER BY counter_id,
         start_value,
         stop_value;

Line: 1252

SELECT   counter_name
FROM     AHL_MR_INTERVALS_V
WHERE    mr_effectivity_id = c_mr_effectivity_id
AND      reset_value IS NOT NULL
GROUP BY counter_name
HAVING   count(*) > 1;

Line: 1433

SELECT repetitive_flag,
       type_code
FROM   AHL_MR_HEADERS_APP_V
WHERE  mr_header_id = c_mr_header_id;

Line: 1460

SELECT threshold_date,
       program_duration,
       program_duration_uom_code
FROM   AHL_MR_EFFECTIVITIES_APP_V
WHERE  mr_effectivity_id = c_mr_effectivity_id;

Line: 1500

PROCEDURE update_threshold
(
  p_x_threshold_rec         IN OUT NOCOPY   threshold_rec_type,
  p_repetitive_flag         IN              VARCHAR2,
  p_appln_code              IN              VARCHAR2,
  p_mr_type_code            IN              VARCHAR2,
  x_return_status           OUT NOCOPY      VARCHAR2,
  p_super_user              IN            VARCHAR2,
  p_mr_header_id            IN             NUMBER
)
IS

l_return_status            VARCHAR2(1);

Line: 1680

    UPDATE AHL_MR_EFFECTIVITIES SET
      object_version_number     = object_version_number + 1,
      threshold_date            = p_x_threshold_rec.threshold_date,
      program_duration          = p_x_threshold_rec.program_duration,
      program_duration_uom_code = p_x_threshold_rec.program_duration_uom_code,
      last_update_date          = SYSDATE,
      last_updated_by           = FND_GLOBAL.user_id,
      last_update_login         = FND_GLOBAL.login_id
    WHERE mr_effectivity_id     = p_x_threshold_rec.mr_effectivity_id
    AND   object_version_number = p_x_threshold_rec.object_version_number;

Line: 1701

END update_threshold;

Line: 1792

  update_threshold
  (
    p_x_threshold_rec, -- IN
    g_repetitive_flag, -- IN
    G_APPLN_USAGE, -- IN
    g_mr_type_code,
    l_return_status, -- OUT
    p_super_user,
    p_mr_header_id

  );

Line: 1943

      INSERT INTO AHL_MR_INTERVALS
      (
        MR_INTERVAL_ID,
        OBJECT_VERSION_NUMBER,
        MR_EFFECTIVITY_ID,
        COUNTER_ID,
        INTERVAL_VALUE,
        EARLIEST_DUE_VALUE,
        START_VALUE,
        STOP_VALUE,
        START_DATE,
        STOP_DATE,
        TOLERANCE_BEFORE,
        TOLERANCE_AFTER,
        RESET_VALUE,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_LOGIN
      ) VALUES
      (
        AHL_MR_INTERVALS_S.NEXTVAL,
        p_x_interval_tbl(i).object_version_number,
        p_x_threshold_rec.mr_effectivity_id,
        p_x_interval_tbl(i).counter_id,
        p_x_interval_tbl(i).interval_value,
        p_x_interval_tbl(i).earliest_due_value,
        p_x_interval_tbl(i).start_value,
        p_x_interval_tbl(i).stop_value,
        p_x_interval_tbl(i).start_date,
        p_x_interval_tbl(i).stop_date,
        p_x_interval_tbl(i).tolerance_before,
        p_x_interval_tbl(i).tolerance_after,
        p_x_interval_tbl(i).reset_value,
        p_x_interval_tbl(i).attribute_category,
        p_x_interval_tbl(i).attribute1,
        p_x_interval_tbl(i).attribute2,
        p_x_interval_tbl(i).attribute3,
        p_x_interval_tbl(i).attribute4,
        p_x_interval_tbl(i).attribute5,
        p_x_interval_tbl(i).attribute6,
        p_x_interval_tbl(i).attribute7,
        p_x_interval_tbl(i).attribute8,
        p_x_interval_tbl(i).attribute9,
        p_x_interval_tbl(i).attribute10,
        p_x_interval_tbl(i).attribute11,
        p_x_interval_tbl(i).attribute12,
        p_x_interval_tbl(i).attribute13,
        p_x_interval_tbl(i).attribute14,
        p_x_interval_tbl(i).attribute15,
        p_x_interval_tbl(i).last_update_date,
        p_x_interval_tbl(i).last_updated_by,
        p_x_interval_tbl(i).creation_date,
        p_x_interval_tbl(i).created_by,
        p_x_interval_tbl(i).last_update_login
      ) RETURNING mr_interval_id INTO l_mr_interval_id;

Line: 2023

      UPDATE AHL_MR_INTERVALS SET
        object_version_number = object_version_number + 1,
        counter_id            = p_x_interval_tbl(i).counter_id,
        interval_value        = p_x_interval_tbl(i).interval_value,
        earliest_due_value    = p_x_interval_tbl(i).earliest_due_value,
        start_value           = p_x_interval_tbl(i).start_value,
        stop_value            = p_x_interval_tbl(i).stop_value,
        start_date            = p_x_interval_tbl(i).start_date,
        stop_date             = p_x_interval_tbl(i).stop_date,
        tolerance_before      = p_x_interval_tbl(i).tolerance_before,
        tolerance_after       = p_x_interval_tbl(i).tolerance_after,
        reset_value           = p_x_interval_tbl(i).reset_value,
        attribute_category    = p_x_interval_tbl(i).attribute_category,
        attribute1            = p_x_interval_tbl(i).attribute1,
        attribute2            = p_x_interval_tbl(i).attribute2,
        attribute3            = p_x_interval_tbl(i).attribute3,
        attribute4            = p_x_interval_tbl(i).attribute4,
        attribute5            = p_x_interval_tbl(i).attribute5,
        attribute6            = p_x_interval_tbl(i).attribute6,
        attribute7            = p_x_interval_tbl(i).attribute7,
        attribute8            = p_x_interval_tbl(i).attribute8,
        attribute9            = p_x_interval_tbl(i).attribute9,
        attribute10           = p_x_interval_tbl(i).attribute10,
        attribute11           = p_x_interval_tbl(i).attribute11,
        attribute12           = p_x_interval_tbl(i).attribute12,
        attribute13           = p_x_interval_tbl(i).attribute13,
        attribute14           = p_x_interval_tbl(i).attribute14,
        attribute15           = p_x_interval_tbl(i).attribute15,
        last_update_date      = p_x_interval_tbl(i).last_update_date,
        last_updated_by       = p_x_interval_tbl(i).last_updated_by,
        last_update_login     = p_x_interval_tbl(i).last_update_login
      WHERE mr_interval_id  = p_x_interval_tbl(i).mr_interval_id
      AND   object_version_number     = p_x_interval_tbl(i).object_version_number;

Line: 2071

      DELETE AHL_MR_INTERVALS
      WHERE mr_interval_id        = p_x_interval_tbl(i).mr_interval_id
      AND   object_version_number = p_x_interval_tbl(i).object_version_number;