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_LTP_SPACE_UNAVL_PVT SQL Statements

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

Line: 51


          SELECT organization_id
              INTO x_organization_id
            FROM HR_ALL_ORGANIZATION_UNITS
          WHERE organization_id   = p_organization_id;

Line: 56


          SELECT organization_id
              INTO x_organization_id
            FROM HR_ALL_ORGANIZATION_UNITS
          WHERE NAME  = p_org_name;

Line: 104


          SELECT department_id
             INTO x_department_id
            FROM HR_ALL_ORGANIZATION_UNITS HAOU, BOM_DEPARTMENTS BMDP
          WHERE HAOU.organization_id = BMDP.organization_id
            AND BMDP.organization_id = p_organization_id
            AND BMDP.description   = p_dept_description;

Line: 112


          SELECT department_id
             INTO x_department_id
           FROM HR_ALL_ORGANIZATION_UNITS HAOU, BOM_DEPARTMENTS BMDP
          WHERE HAOU.organization_id = BMDP.organization_id
            AND BMDP.organization_id = (SELECT organization_id
                                          FROM HR_ALL_ORGANIZATION_UNITS
                                         WHERE NAME  = p_org_name)
            AND BMDP.description = p_dept_description;

Line: 156


          SELECT space_id
              INTO x_space_id
            FROM AHL_SPACES_VL
          WHERE space_id   = p_space_id;

Line: 161


          SELECT space_id
              INTO x_space_id
           FROM AHL_SPACES_VL
          WHERE SPACE_NAME  = p_space_name;

Line: 234


   SELECT ROW_ID,
          SPACE_ID,
          START_DATE,
          END_DATE,
          DESCRIPTION,
          OBJECT_VERSION_NUMBER,
          ATTRIBUTE_CATEGORY,
          ATTRIBUTE1,
          ATTRIBUTE2,
          ATTRIBUTE3,
          ATTRIBUTE4,
          ATTRIBUTE5,
          ATTRIBUTE6,
          ATTRIBUTE7,
          ATTRIBUTE8,
          ATTRIBUTE9,
          ATTRIBUTE10,
          ATTRIBUTE11,
          ATTRIBUTE12,
          ATTRIBUTE13,
          ATTRIBUTE14,
          ATTRIBUTE15
     FROM  ahl_space_unavailable_vl
   WHERE   space_unavailability_id = p_space_restriction_rec.space_unavailability_id
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 493


 SELECT a.visit_id,
        space_id,
        trunc(start_date_time) start_date_time
    FROM ahl_space_Assignments a,
         ahl_visits_b b
   WHERE a.visit_id = b.visit_id
    AND a.space_id = c_space_id;

Line: 504


   SELECT start_date, end_date
     FROM ahl_space_unavailable_b
    WHERE space_unavailability_id = c_space_unavailability_id;

Line: 809


  SELECT AHL_SPACE_UNAVAILABLE_B_S.NEXTVAL
    FROM   dual;

Line: 813


     SELECT 1
       FROM   dual
      WHERE EXISTS (SELECT 1
                      FROM   ahl_space_unavailable_b
                     WHERE  space_unavailability_id = x_id);

Line: 823


   SELECT space_id
     FROM AHL_SPACE_UNAVAILABLE_VL
    WHERE space_id = c_space_id
     AND trunc(start_date) = c_start_date
     AND trunc(end_date) = c_end_date;

Line: 1154


   AHL_SPACE_UNAVAILABLE_PKG.INSERT_ROW (
         X_ROWID                   => l_rowid,
         X_SPACE_UNAVAILABILITY_ID => l_space_unavaialability_id,
         X_SPACE_ID                => p_x_space_restriction_rec.space_id,
         X_START_DATE              => p_x_space_restriction_rec.start_date,
         X_END_DATE                => p_x_space_restriction_rec.end_date,
         X_OBJECT_VERSION_NUMBER   => 1,
         X_ATTRIBUTE_CATEGORY      => l_space_restriction_rec.attribute_category,
         X_ATTRIBUTE1              => l_space_restriction_rec.attribute1,
         X_ATTRIBUTE2              => l_space_restriction_rec.attribute2,
         X_ATTRIBUTE3              => l_space_restriction_rec.attribute3,
         X_ATTRIBUTE4              => l_space_restriction_rec.attribute4,
         X_ATTRIBUTE5              => l_space_restriction_rec.attribute5,
         X_ATTRIBUTE6              => l_space_restriction_rec.attribute6,
         X_ATTRIBUTE7              => l_space_restriction_rec.attribute7,
         X_ATTRIBUTE8              => l_space_restriction_rec.attribute8,
         X_ATTRIBUTE9              => l_space_restriction_rec.attribute9,
         X_ATTRIBUTE10             => l_space_restriction_rec.attribute10,
         X_ATTRIBUTE11             => l_space_restriction_rec.attribute11,
         X_ATTRIBUTE12             => l_space_restriction_rec.attribute12,
         X_ATTRIBUTE13             => l_space_restriction_rec.attribute13,
         X_ATTRIBUTE14             => l_space_restriction_rec.attribute14,
         X_ATTRIBUTE15             => l_space_restriction_rec.attribute15,
         X_DESCRIPTION             => l_space_restriction_rec.description,
         X_CREATION_DATE           => SYSDATE,
         X_CREATED_BY              => Fnd_Global.USER_ID,
         X_LAST_UPDATE_DATE        => SYSDATE,
         X_LAST_UPDATED_BY         => Fnd_Global.USER_ID,
         X_LAST_UPDATE_LOGIN       => Fnd_Global.LOGIN_ID);

Line: 1272


PROCEDURE Update_Space_Restriction (
   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,
   p_module_type             IN     VARCHAR2  := 'JSP',
   p_space_restriction_rec   IN    ahl_ltp_space_unavl_pub.Space_Restriction_Rec,
   x_return_status             OUT NOCOPY VARCHAR2,
   x_msg_count                 OUT NOCOPY NUMBER,
   x_msg_data                  OUT NOCOPY VARCHAR2
)
IS
--
 CURSOR check_duplicate_cur (c_space_id IN NUMBER,
                             c_start_date IN DATE,
                             c_end_date IN DATE)
 IS
   SELECT space_id
     FROM AHL_SPACE_UNAVAILABLE_VL
    WHERE space_id = c_space_id
     AND trunc(start_date) = c_start_date
     AND trunc(end_date) = c_end_date;

Line: 1297


 SELECT start_date,end_date
   FROM AHL_SPACE_UNAVAILABLE_VL
  WHERE space_unavailability_id = c_space_unavabl_id;

Line: 1303


  SELECT organization_id,bom_department_id
   FROM ahl_spaces_b
   WHERE space_id = c_space_id;

Line: 1308


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

Line: 1331


  SAVEPOINT update_space_restriction;

Line: 1336


   AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_unavl_pvt.Update Space Restriction','+SUAVL+');

Line: 1442


   AHL_SPACE_UNAVAILABLE_PKG.UPDATE_ROW
         (
         X_SPACE_UNAVAILABILITY_ID => l_Aspace_restriction_rec.space_unavailability_id,
         X_SPACE_ID                => l_Aspace_restriction_rec.space_id,
         X_START_DATE              => l_Aspace_restriction_rec.start_date,
         X_END_DATE                => l_Aspace_restriction_rec.end_date,
         X_OBJECT_VERSION_NUMBER   => l_Aspace_restriction_rec.object_version_number+1,
         X_ATTRIBUTE_CATEGORY      => l_Aspace_restriction_rec.attribute_category,
         X_ATTRIBUTE1              => l_Aspace_restriction_rec.attribute1,
         X_ATTRIBUTE2              => l_Aspace_restriction_rec.attribute2,
         X_ATTRIBUTE3              => l_Aspace_restriction_rec.attribute3,
         X_ATTRIBUTE4              => l_Aspace_restriction_rec.attribute4,
         X_ATTRIBUTE5              => l_Aspace_restriction_rec.attribute5,
         X_ATTRIBUTE6              => l_Aspace_restriction_rec.attribute6,
         X_ATTRIBUTE7              => l_Aspace_restriction_rec.attribute7,
         X_ATTRIBUTE8              => l_Aspace_restriction_rec.attribute8,
         X_ATTRIBUTE9              => l_Aspace_restriction_rec.attribute9,
         X_ATTRIBUTE10             => l_Aspace_restriction_rec.attribute10,
         X_ATTRIBUTE11             => l_Aspace_restriction_rec.attribute11,
         X_ATTRIBUTE12             => l_Aspace_restriction_rec.attribute12,
         X_ATTRIBUTE13             => l_Aspace_restriction_rec.attribute13,
         X_ATTRIBUTE14             => l_Aspace_restriction_rec.attribute14,
         X_ATTRIBUTE15             => l_Aspace_restriction_rec.attribute15,
         X_DESCRIPTION             => l_Aspace_restriction_rec.description,
         X_LAST_UPDATE_DATE        => SYSDATE,
         X_LAST_UPDATED_BY         => Fnd_Global.USER_ID,
         X_LAST_UPDATE_LOGIN       => Fnd_Global.LOGIN_ID);

Line: 1487


   Ahl_Debug_Pub.debug( 'End of private api Update Space Restriction','+SUAVL+');

Line: 1494


    ROLLBACK TO update_space_restriction;

Line: 1502


        AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Update Space Restriction','+SUAVL+');

Line: 1508


    ROLLBACK TO update_space_restriction;

Line: 1517


        AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Update Space Restriction','+SUAVL+');

Line: 1523


    ROLLBACK TO update_space_restriction;

Line: 1528


                            p_procedure_name  =>  'UPDATE_SPACE_RESTRICTION',
                            p_error_text      => SUBSTR(SQLERRM,1,240));

Line: 1538


        AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Update Space Restriction','+SUAVL+');

Line: 1542


END Update_Space_Restriction;

Line: 1558


PROCEDURE Delete_Space_Restriction (
   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,
   p_space_restriction_rec      IN     ahl_ltp_space_unavl_pub.Space_Restriction_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) := 'DELETE_SPACE_RESTRICTION';

Line: 1582


  SELECT   space_unavailability_id,object_version_number
    FROM     ahl_space_unavailable_vl
   WHERE    space_unavailability_id = c_space_unavailability_id
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1590


  SAVEPOINT delete_space_restriction;

Line: 1597


   AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_unavl_pvt.Delete Space Restriction','+SUAVL+');

Line: 1635


 AHL_SPACE_UNAVAILABLE_PKG.DELETE_ROW (
         X_SPACE_UNAVAILABILITY_ID => l_space_unavailability_id
     );

Line: 1654


   Ahl_Debug_Pub.debug( 'End of private api Delete Space Restriction','+SUAVL+');

Line: 1661


    ROLLBACK TO delete_space_restriction;

Line: 1669


        AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Delete Space Restriction','+SUAVL+');

Line: 1674


    ROLLBACK TO delete_space_restriction;

Line: 1683


        AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Delete Space Restriction','+SUAVL+');

Line: 1689


    ROLLBACK TO delete_space_restriction;

Line: 1694


                            p_procedure_name  =>  'DELETE_SPACE_RESTRICTION',
                            p_error_text      => SUBSTR(SQLERRM,1,240));

Line: 1704


        AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Delete Space Restriction','+SUAVL+');

Line: 1709


END Delete_Space_Restriction;