eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RM_ASO_RESOURCE_PVT SQL Statements

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

Line: 226


    p_x_aso_resource_rec.last_update_date := SYSDATE;

Line: 227


    p_x_aso_resource_rec.last_updated_by := FND_GLOBAL.user_id;

Line: 228


    p_x_aso_resource_rec.last_update_login := FND_GLOBAL.login_id;

Line: 239


      p_x_bom_resource_tbl(i).last_update_date := SYSDATE;

Line: 240


      p_x_bom_resource_tbl(i).last_updated_by := FND_GLOBAL.user_id;

Line: 241


      p_x_bom_resource_tbl(i).last_update_login := FND_GLOBAL.login_id;

Line: 505


SELECT  resource_id,
        resource_type_id,
        name,
        description,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15
FROM    AHL_RESOURCES
WHERE   resource_id = c_resource_id;

Line: 683


SELECT  bom_resource_id,
        bom_org_id,
        department_id, --pdoki ER 7436910
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15
FROM    AHL_RESOURCE_MAPPINGS
WHERE   resource_mapping_id = c_resource_mapping_id;

Line: 862


SELECT   resource_type, disable_date
FROM     BOM_RESOURCES
WHERE    resource_id = c_bom_resource_id;

Line: 912


SELECT   name
FROM     AHL_RESOURCES
WHERE    UPPER(TRIM(NAME)) = UPPER(TRIM(c_name))
AND      (resource_id <> c_resource_id
OR        c_resource_id IS NULL);

Line: 963


  SELECT count(bom_resource_id)
    FROM ahl_resource_mappings
   WHERE aso_resource_id = c_aso_resource_id;

Line: 967


  SELECT count(bom_resource_id)
    FROM ahl_resource_mappings
   WHERE aso_resource_id = c_aso_resource_id
GROUP BY aso_resource_id, bom_org_id
  HAVING count(bom_resource_id) > 1;

Line: 973


  SELECT bom_resource_id
    FROM ahl_resource_mappings
   WHERE aso_resource_id = c_aso_resource_id
GROUP BY aso_resource_id, bom_resource_id, bom_org_id
  HAVING count(resource_mapping_id) >1;

Line: 981


  SELECT DISTINCT object_id, association_type_code
    FROM ahl_rt_oper_resources
   WHERE aso_resource_id = c_aso_resource_id;

Line: 987


    SELECT 'X'
    FROM    ahl_resource_mappings
    WHERE   DEPARTMENT_ID IS NOT NULL
            AND aso_resource_id in
            (SELECT ASO_RESOURCE_ID
            FROM    ahl_rt_oper_resources
            WHERE   object_id                 = c_object_id
                    AND ASSOCIATION_TYPE_CODE = c_association_type_code
            )
    GROUP BY bom_org_id
    HAVING count(DISTINCT DEPARTMENT_ID) > 1;

Line: 1002


SELECT 'X'
FROM    ahl_resource_mappings
WHERE   DEPARTMENT_ID IS NOT NULL
        AND aso_resource_id in
        (SELECT ALTR.ASO_RESOURCE_ID
        FROM    ahl_alternate_resources ALTR,
                (SELECT RT_OPER_RESOURCE_ID
                FROM    ahl_rt_oper_resources
                WHERE   RT_OPER_RESOURCE_ID      <> c_rt_oper_res_id
                        AND ASSOCIATION_TYPE_CODE = c_association_type_code
                        AND OBJECT_ID             = c_object_id
                )
                ROR
        WHERE   ROR.RT_OPER_RESOURCE_ID = ALTR.rt_oper_resource_id
        )
        OR aso_resource_id =
        (SELECT aso_resource_id
        FROM    ahl_rt_oper_resources
        WHERE   RT_OPER_RESOURCE_ID = c_rt_oper_res_id
        )
GROUP BY bom_org_id
HAVING count(DISTINCT DEPARTMENT_ID) > 1;

Line: 1027


SELECT  RT_OPER_RESOURCE_ID
FROM    AHL_RT_OPER_RESOURCES
WHERE   ASSOCIATION_TYPE_CODE = c_association_type_code
        AND OBJECT_ID         = c_object_id;

Line: 1035


SELECT 'X'
FROM    ahl_resource_mappings
WHERE   DEPARTMENT_ID IS NOT NULL
        AND aso_resource_id in
        (
        SELECT ASO_RESOURCE_ID
        FROM    ahl_rt_oper_resources
        WHERE   object_id                 = c_object_id
                AND ASSOCIATION_TYPE_CODE = c_association_type_code
                AND ASO_RESOURCE_ID <> c_aso_res_id
        )
        OR aso_resource_id = c_alt_res_id
GROUP BY bom_org_id
HAVING count(DISTINCT DEPARTMENT_ID) > 1;

Line: 1052


SELECT OBJECT_ID,ASSOCIATION_TYPE_CODE, ASO_RESOURCE_ID
FROM AHL_RT_OPER_RESOURCES
WHERE RT_OPER_RESOURCE_ID= c_rt_oper_resource_id;

Line: 1058


select RT_OPER_RESOURCE_ID
from ahl_alternate_resources
where ASO_RESOURCE_ID= c_aso_resource_id;

Line: 1199


  SELECT aso_resource_id
    FROM ahl_rt_oper_resources
   WHERE aso_resource_id = c_resource_id;

Line: 1355


    INSERT INTO AHL_RESOURCES
    (
          RESOURCE_ID,
          OBJECT_VERSION_NUMBER,
          LAST_UPDATE_DATE,
          LAST_UPDATED_BY,
          CREATION_DATE,
          CREATED_BY,
          LAST_UPDATE_LOGIN,
          RESOURCE_TYPE_ID,
          NAME,
          DESCRIPTION,
          ATTRIBUTE_CATEGORY,
          ATTRIBUTE1,
          ATTRIBUTE2,
          ATTRIBUTE3,
          ATTRIBUTE4,
          ATTRIBUTE5,
          ATTRIBUTE6,
          ATTRIBUTE7,
          ATTRIBUTE8,
          ATTRIBUTE9,
          ATTRIBUTE10,
          ATTRIBUTE11,
          ATTRIBUTE12,
          ATTRIBUTE13,
          ATTRIBUTE14,
          ATTRIBUTE15
    ) VALUES
    (
          ahl_resources_s.nextval,
          p_x_aso_resource_rec.object_version_number,
          p_x_aso_resource_rec.last_update_date,
          p_x_aso_resource_rec.last_updated_by,
          p_x_aso_resource_rec.creation_date,
          p_x_aso_resource_rec.created_by,
          p_x_aso_resource_rec.last_update_login,
          p_x_aso_resource_rec.resource_type_id,
          p_x_aso_resource_rec.name,
          p_x_aso_resource_rec.description,
          p_x_aso_resource_rec.attribute_category,
          p_x_aso_resource_rec.attribute1,
          p_x_aso_resource_rec.attribute2,
          p_x_aso_resource_rec.attribute3,
          p_x_aso_resource_rec.attribute4,
          p_x_aso_resource_rec.attribute5,
          p_x_aso_resource_rec.attribute6,
          p_x_aso_resource_rec.attribute7,
          p_x_aso_resource_rec.attribute8,
          p_x_aso_resource_rec.attribute9,
          p_x_aso_resource_rec.attribute10,
          p_x_aso_resource_rec.attribute11,
          p_x_aso_resource_rec.attribute12,
          p_x_aso_resource_rec.attribute13,
          p_x_aso_resource_rec.attribute14,
          p_x_aso_resource_rec.attribute15
    ) RETURNING resource_id INTO l_resource_id;

Line: 1418


      INSERT INTO AHL_RESOURCE_MAPPINGS
      (
          RESOURCE_MAPPING_ID,
          OBJECT_VERSION_NUMBER,
          LAST_UPDATE_DATE,
          LAST_UPDATED_BY,
          CREATION_DATE,
          CREATED_BY,
          LAST_UPDATE_LOGIN,
          ASO_RESOURCE_ID,
          BOM_RESOURCE_ID,
          BOM_ORG_ID,
          DEPARTMENT_ID,--pdoki ER 7436910
          ATTRIBUTE_CATEGORY,
          ATTRIBUTE1,
          ATTRIBUTE2,
          ATTRIBUTE3,
          ATTRIBUTE4,
          ATTRIBUTE5,
          ATTRIBUTE6,
          ATTRIBUTE7,
          ATTRIBUTE8,
          ATTRIBUTE9,
          ATTRIBUTE10,
          ATTRIBUTE11,
          ATTRIBUTE12,
          ATTRIBUTE13,
          ATTRIBUTE14,
          ATTRIBUTE15
      ) VALUES
      (
          AHL_RESOURCE_MAPPINGS_S.NEXTVAL,
          p_x_bom_resource_tbl(i).object_version_number,
          p_x_bom_resource_tbl(i).last_update_date,
          p_x_bom_resource_tbl(i).last_updated_by,
          p_x_bom_resource_tbl(i).creation_date,
          p_x_bom_resource_tbl(i).created_by,
          p_x_bom_resource_tbl(i).last_update_login,
          p_x_aso_resource_rec.resource_id,
          p_x_bom_resource_tbl(i).bom_resource_id,
          p_x_bom_resource_tbl(i).bom_org_id,
          p_x_bom_resource_tbl(i).department_id,--pdoki ER 7436910
          p_x_bom_resource_tbl(i).attribute_category,
          p_x_bom_resource_tbl(i).attribute1,
          p_x_bom_resource_tbl(i).attribute2,
          p_x_bom_resource_tbl(i).attribute3,
          p_x_bom_resource_tbl(i).attribute4,
          p_x_bom_resource_tbl(i).attribute5,
          p_x_bom_resource_tbl(i).attribute6,
          p_x_bom_resource_tbl(i).attribute7,
          p_x_bom_resource_tbl(i).attribute8,
          p_x_bom_resource_tbl(i).attribute9,
          p_x_bom_resource_tbl(i).attribute10,
          p_x_bom_resource_tbl(i).attribute11,
          p_x_bom_resource_tbl(i).attribute12,
          p_x_bom_resource_tbl(i).attribute13,
          p_x_bom_resource_tbl(i).attribute14,
          p_x_bom_resource_tbl(i).attribute15
      ) RETURNING resource_mapping_id INTO l_resource_mapping_id;

Line: 1482


    UPDATE AHL_RESOURCES SET
          object_version_number   = object_version_number + 1,
          last_update_date        = p_x_aso_resource_rec.last_update_date,
          last_updated_by         = p_x_aso_resource_rec.last_updated_by,
          last_update_login       = p_x_aso_resource_rec.last_update_login,
          name                    = p_x_aso_resource_rec.name,
          description             = p_x_aso_resource_rec.description,
          attribute_category      = p_x_aso_resource_rec.attribute_category,
          attribute1              = p_x_aso_resource_rec.attribute1,
          attribute2              = p_x_aso_resource_rec.attribute2,
          attribute3              = p_x_aso_resource_rec.attribute3,
          attribute4              = p_x_aso_resource_rec.attribute4,
          attribute5              = p_x_aso_resource_rec.attribute5,
          attribute6              = p_x_aso_resource_rec.attribute6,
          attribute7              = p_x_aso_resource_rec.attribute7,
          attribute8              = p_x_aso_resource_rec.attribute8,
          attribute9              = p_x_aso_resource_rec.attribute9,
          attribute10             = p_x_aso_resource_rec.attribute10,
          attribute11             = p_x_aso_resource_rec.attribute11,
          attribute12             = p_x_aso_resource_rec.attribute12,
          attribute13             = p_x_aso_resource_rec.attribute13,
          attribute14             = p_x_aso_resource_rec.attribute14,
          attribute15             = p_x_aso_resource_rec.attribute15
    WHERE resource_id = p_x_aso_resource_rec.resource_id
    AND object_version_number = p_x_aso_resource_rec.object_version_number;

Line: 1517


            INSERT INTO AHL_RESOURCE_MAPPINGS(
            RESOURCE_MAPPING_ID,
            OBJECT_VERSION_NUMBER,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            CREATION_DATE,
            CREATED_BY,
            LAST_UPDATE_LOGIN,
            ASO_RESOURCE_ID,
            BOM_RESOURCE_ID,
            BOM_ORG_ID,
            DEPARTMENT_ID,--pdoki ER 7436910
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15)
            VALUES(
            AHL_RESOURCE_MAPPINGS_S.NEXTVAL,
            p_x_bom_resource_tbl(i).object_version_number,
            p_x_bom_resource_tbl(i).last_update_date,
            p_x_bom_resource_tbl(i).last_updated_by,
            p_x_bom_resource_tbl(i).creation_date,
            p_x_bom_resource_tbl(i).created_by,
            p_x_bom_resource_tbl(i).last_update_login,
            p_x_aso_resource_rec.resource_id,
            p_x_bom_resource_tbl(i).bom_resource_id,
            p_x_bom_resource_tbl(i).bom_org_id,
            p_x_bom_resource_tbl(i).department_id,--pdoki ER 7436910
            p_x_bom_resource_tbl(i).attribute_category,
            p_x_bom_resource_tbl(i).attribute1,
            p_x_bom_resource_tbl(i).attribute2,
            p_x_bom_resource_tbl(i).attribute3,
            p_x_bom_resource_tbl(i).attribute4,
            p_x_bom_resource_tbl(i).attribute5,
            p_x_bom_resource_tbl(i).attribute6,
            p_x_bom_resource_tbl(i).attribute7,
            p_x_bom_resource_tbl(i).attribute8,
            p_x_bom_resource_tbl(i).attribute9,
            p_x_bom_resource_tbl(i).attribute10,
            p_x_bom_resource_tbl(i).attribute11,
            p_x_bom_resource_tbl(i).attribute12,
            p_x_bom_resource_tbl(i).attribute13,
            p_x_bom_resource_tbl(i).attribute14,
            p_x_bom_resource_tbl(i).attribute15)
            RETURNING resource_mapping_id INTO l_resource_mapping_id;

Line: 1576


            UPDATE AHL_RESOURCE_MAPPINGS SET
            object_version_number   = object_version_number + 1,
            last_update_date        = p_x_bom_resource_tbl(i).last_update_date,
            last_updated_by         = p_x_bom_resource_tbl(i).last_updated_by,
            last_update_login       = p_x_bom_resource_tbl(i).last_update_login,
            bom_resource_id         = p_x_bom_resource_tbl(i).bom_resource_id,
            bom_org_id              = p_x_bom_resource_tbl(i).bom_org_id,
            department_id           = p_x_bom_resource_tbl(i).department_id,--pdoki ER 7436910
            attribute_category      = p_x_bom_resource_tbl(i).attribute_category,
            attribute1              = p_x_bom_resource_tbl(i).attribute1,
            attribute2              = p_x_bom_resource_tbl(i).attribute2,
            attribute3              = p_x_bom_resource_tbl(i).attribute3,
            attribute4              = p_x_bom_resource_tbl(i).attribute4,
            attribute5              = p_x_bom_resource_tbl(i).attribute5,
            attribute6              = p_x_bom_resource_tbl(i).attribute6,
            attribute7              = p_x_bom_resource_tbl(i).attribute7,
            attribute8              = p_x_bom_resource_tbl(i).attribute8,
            attribute9              = p_x_bom_resource_tbl(i).attribute9,
            attribute10             = p_x_bom_resource_tbl(i).attribute10,
            attribute11             = p_x_bom_resource_tbl(i).attribute11,
            attribute12             = p_x_bom_resource_tbl(i).attribute12,
            attribute13             = p_x_bom_resource_tbl(i).attribute13,
            attribute14             = p_x_bom_resource_tbl(i).attribute14,
            attribute15             = p_x_bom_resource_tbl(i).attribute15
            WHERE resource_mapping_id = p_x_bom_resource_tbl(i).resource_mapping_id
            AND object_version_number = p_x_bom_resource_tbl(i).object_version_number;

Line: 1609


            DELETE FROM AHL_RESOURCE_MAPPINGS
            WHERE resource_mapping_id = p_x_bom_resource_tbl(i).resource_mapping_id
            AND object_version_number = p_x_bom_resource_tbl(i).object_version_number;

Line: 1636


      DELETE FROM AHL_RESOURCE_SKILLS
      WHERE AHL_RESOURCE_ID = p_x_aso_resource_rec.resource_id;

Line: 1639


        DELETE FROM AHL_RESOURCES
        WHERE resource_id = p_x_aso_resource_rec.resource_id
        AND object_version_number = p_x_aso_resource_rec.object_version_number;

Line: 1649


          DELETE FROM AHL_RESOURCE_MAPPINGS
          WHERE aso_resource_id = p_x_aso_resource_rec.resource_id;