APPS.AHL_RM_PROD_ZONE_AS_PVT SQL Statements

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

Line: 259

  p_x_prod_zone_as_rec.last_update_date := SYSDATE;

Line: 260

  p_x_prod_zone_as_rec.last_updated_by := FND_GLOBAL.user_id;

Line: 261

  p_x_prod_zone_as_rec.last_update_login := FND_GLOBAL.login_id;

Line: 382

SELECT  product_type_code,
        zone_code,
        sub_zone_code,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15
FROM    AHL_PRODTYPE_ZONES
WHERE   prodtype_zone_id = c_prodtype_zone_id;

Line: 650

  SELECT product_type_code, zone_code
    FROM ahl_prodtype_zones
   WHERE product_type_code = c_product_type_code
     AND zone_code = c_zone_code;

Line: 682

SELECT   zone_code,
         zone,
         sub_zone_code,
         sub_zone
FROM     AHL_PRODTYPE_ZONES_V
WHERE    product_type_code = c_product_type_code
GROUP BY zone_code,
         zone,
         sub_zone_code,
         sub_zone
HAVING   count(*) > 1;

Line: 745

  SELECT product_type_code, zone_code, sub_zone_code
    FROM ahl_prodtype_zones
   WHERE prodtype_zone_id = c_prodtype_zone_id;

Line: 750

  SELECT route_id
    FROM ahl_routes_app_v
   WHERE product_type_code = c_product_type_code
     AND zone_code = c_zone_code;

Line: 757

  SELECT route_id
    FROM ahl_routes_app_v
   WHERE product_type_code = c_product_type_code
     AND zone_code = c_zone_code
     AND sub_zone_code = c_sub_zone_code;

Line: 942

        INSERT INTO AHL_PRODTYPE_ZONES
        (
          PRODTYPE_ZONE_ID,
          OBJECT_VERSION_NUMBER,
          LAST_UPDATE_DATE,
          LAST_UPDATED_BY,
          CREATION_DATE,
          CREATED_BY,
          LAST_UPDATE_LOGIN,
          PRODUCT_TYPE_CODE,
          ZONE_CODE,
          SUB_ZONE_CODE,
          ATTRIBUTE_CATEGORY,
          ATTRIBUTE1,
          ATTRIBUTE2,
          ATTRIBUTE3,
          ATTRIBUTE4,
          ATTRIBUTE5,
          ATTRIBUTE6,
          ATTRIBUTE7,
          ATTRIBUTE8,
          ATTRIBUTE9,
          ATTRIBUTE10,
          ATTRIBUTE11,
          ATTRIBUTE12,
          ATTRIBUTE13,
          ATTRIBUTE14,
          ATTRIBUTE15
        ) VALUES
        (
          AHL_PRODTYPE_ZONES_S.NEXTVAL,
          p_x_prod_zone_as_tbl(i).object_version_number,
          p_x_prod_zone_as_tbl(i).last_update_date,
          p_x_prod_zone_as_tbl(i).last_updated_by,
          p_x_prod_zone_as_tbl(i).creation_date,
          p_x_prod_zone_as_tbl(i).created_by,
          p_x_prod_zone_as_tbl(i).last_update_login,
          p_x_prod_zone_as_tbl(i).product_type_code,
          p_x_prod_zone_as_tbl(i).zone_code,
          p_x_prod_zone_as_tbl(i).sub_zone_code,
          p_x_prod_zone_as_tbl(i).attribute_category,
          p_x_prod_zone_as_tbl(i).attribute1,
          p_x_prod_zone_as_tbl(i).attribute2,
          p_x_prod_zone_as_tbl(i).attribute3,
          p_x_prod_zone_as_tbl(i).attribute4,
          p_x_prod_zone_as_tbl(i).attribute5,
          p_x_prod_zone_as_tbl(i).attribute6,
          p_x_prod_zone_as_tbl(i).attribute7,
          p_x_prod_zone_as_tbl(i).attribute8,
          p_x_prod_zone_as_tbl(i).attribute9,
          p_x_prod_zone_as_tbl(i).attribute10,
          p_x_prod_zone_as_tbl(i).attribute11,
          p_x_prod_zone_as_tbl(i).attribute12,
          p_x_prod_zone_as_tbl(i).attribute13,
          p_x_prod_zone_as_tbl(i).attribute14,
          p_x_prod_zone_as_tbl(i).attribute15
        ) RETURNING prodtype_zone_id INTO l_prodtype_zone_id;

Line: 1016

        UPDATE AHL_PRODTYPE_ZONES SET
          object_version_number   = object_version_number + 1,
          last_update_date        = p_x_prod_zone_as_tbl(i).last_update_date,
          last_updated_by         = p_x_prod_zone_as_tbl(i).last_updated_by,
          last_update_login       = p_x_prod_zone_as_tbl(i).last_update_login,
          product_type_code       = p_x_prod_zone_as_tbl(i).product_type_code,
          zone_code               = p_x_prod_zone_as_tbl(i).zone_code,
          sub_zone_code           = p_x_prod_zone_as_tbl(i).sub_zone_code,
          attribute_category      = p_x_prod_zone_as_tbl(i).attribute_category,
          attribute1              = p_x_prod_zone_as_tbl(i).attribute1,
          attribute2              = p_x_prod_zone_as_tbl(i).attribute2,
          attribute3              = p_x_prod_zone_as_tbl(i).attribute3,
          attribute4              = p_x_prod_zone_as_tbl(i).attribute4,
          attribute5              = p_x_prod_zone_as_tbl(i).attribute5,
          attribute6              = p_x_prod_zone_as_tbl(i).attribute6,
          attribute7              = p_x_prod_zone_as_tbl(i).attribute7,
          attribute8              = p_x_prod_zone_as_tbl(i).attribute8,
          attribute9              = p_x_prod_zone_as_tbl(i).attribute9,
          attribute10             = p_x_prod_zone_as_tbl(i).attribute10,
          attribute11             = p_x_prod_zone_as_tbl(i).attribute11,
          attribute12             = p_x_prod_zone_as_tbl(i).attribute12,
          attribute13             = p_x_prod_zone_as_tbl(i).attribute13,
          attribute14             = p_x_prod_zone_as_tbl(i).attribute14,
          attribute15             = p_x_prod_zone_as_tbl(i).attribute15
        WHERE prodtype_zone_id = p_x_prod_zone_as_tbl(i).prodtype_zone_id
        AND object_version_number = p_x_prod_zone_as_tbl(i).object_version_number;

Line: 1076

      DELETE FROM AHL_PRODTYPE_ZONES
      WHERE prodtype_zone_id = p_x_prod_zone_as_tbl(i).prodtype_zone_id
      AND object_version_number = p_x_prod_zone_as_tbl(i).object_version_number;

Line: 1087

          DELETE FROM AHL_PRODTYPE_ZONES
          WHERE product_type_code = l_get_prod_zone_rec.product_type_code
            AND zone_code = l_get_prod_zone_rec.zone_code;

Line: 1092

            UPDATE AHL_ROUTES_B
               SET zone_code = NULL,
                   sub_zone_code = NULL
             WHERE route_id = I.route_id;

Line: 1100

            UPDATE AHL_ROUTES_B
               SET sub_zone_code = NULL
             WHERE route_id= I.route_id;