APPS.AHL_FMP_MR_VISIT_TYPES_PVT SQL Statements

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

Line: 9

PROCEDURE INSERT_ROW
 (
 p_x_mr_visit_type_rec              IN OUT  NOCOPY mr_visit_type_REC_type
 )
AS
BEGIN
             INSERT INTO AHL_MR_VISIT_TYPES
                          (
                          MR_VISIT_TYPE_ID,
                          OBJECT_VERSION_NUMBER,
                          LAST_UPDATE_DATE,
                          LAST_UPDATED_BY,
                          CREATION_DATE,
                          CREATED_BY,
                          LAST_UPDATE_LOGIN,
                          MR_VISIT_TYPE_CODE,
                          MR_HEADER_ID,
                          ATTRIBUTE_CATEGORY,
                          ATTRIBUTE1,
                          ATTRIBUTE2,
                          ATTRIBUTE3,
                          ATTRIBUTE4,
                          ATTRIBUTE5,
                          ATTRIBUTE6,
                          ATTRIBUTE7,
                          ATTRIBUTE8,
                          ATTRIBUTE9,
                          ATTRIBUTE10,
                          ATTRIBUTE11,
                          ATTRIBUTE12,
                          ATTRIBUTE13,
                          ATTRIBUTE14,
                          ATTRIBUTE15
                          )
                          VALUES
                          (
                          AHL_MR_VISIT_TYPES_S.NEXTVAL,
                          1,
                          SYSDATE,
                          FND_GLOBAL.user_ID,
                          SYSDATE,
                          FND_GLOBAL.USER_ID,
                          FND_GLOBAL.LOGIN_ID,
                          P_X_MR_VISIT_TYPE_REC.MR_VISIT_TYPE_CODE,
                          P_X_MR_VISIT_TYPE_REC.MR_HEADER_ID,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE_CATEGORY,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE1,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE2,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE3,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE4,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE5,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE6,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE7,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE8,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE9,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE10,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE11,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE12,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE13,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE14,
                          P_X_MR_VISIT_TYPE_REC.ATTRIBUTE15)
                          RETURNING MR_VISIT_TYPE_ID INTO P_X_MR_VISIT_TYPE_REC.MR_VISIT_TYPE_ID;

Line: 74

PROCEDURE UPDATE_ROW
 (
 p_mr_visit_type_rec              IN mr_visit_type_REC_type
 )
AS
BEGIN
                UPDATE AHL_MR_VISIT_TYPES
                SET      mr_visit_type_ID                    =P_MR_VISIT_TYPE_REC.mr_visit_type_ID,
                         OBJECT_VERSION_NUMBER               =P_MR_VISIT_TYPE_REC.OBJECT_VERSION_NUMBER+1,
                         MR_HEADER_ID                        =P_MR_VISIT_TYPE_REC.MR_HEADER_ID,
                         mr_visit_type_CODE                  =P_MR_VISIT_TYPE_REC.mr_visit_type_CODE,
                         ATTRIBUTE_CATEGORY                  =P_MR_VISIT_TYPE_REC.ATTRIBUTE_CATEGORY,
                         ATTRIBUTE1                          =P_MR_VISIT_TYPE_REC.ATTRIBUTE1,
                         ATTRIBUTE2                          =P_MR_VISIT_TYPE_REC.ATTRIBUTE2,
                         ATTRIBUTE3                          =P_MR_VISIT_TYPE_REC.ATTRIBUTE3,
                         ATTRIBUTE4                          =P_MR_VISIT_TYPE_REC.ATTRIBUTE4,
                         ATTRIBUTE5                          =P_MR_VISIT_TYPE_REC.ATTRIBUTE5,
                         ATTRIBUTE6                          =P_MR_VISIT_TYPE_REC.ATTRIBUTE6,
                         ATTRIBUTE7                          =P_MR_VISIT_TYPE_REC.ATTRIBUTE7,
                         ATTRIBUTE8                          =P_MR_VISIT_TYPE_REC.ATTRIBUTE8,
                         ATTRIBUTE9                          =P_MR_VISIT_TYPE_REC.ATTRIBUTE9,
                         ATTRIBUTE10                         =P_MR_VISIT_TYPE_REC.ATTRIBUTE10,
                         ATTRIBUTE11                         =P_MR_VISIT_TYPE_REC.ATTRIBUTE11,
                         ATTRIBUTE12                         =P_MR_VISIT_TYPE_REC.ATTRIBUTE12,
                         ATTRIBUTE13                         =P_MR_VISIT_TYPE_REC.ATTRIBUTE13,
                         ATTRIBUTE14                         =P_MR_VISIT_TYPE_REC.ATTRIBUTE14,
                         ATTRIBUTE15                         =P_MR_VISIT_TYPE_REC.ATTRIBUTE15,
                         LAST_UPDATE_DATE                    =sysdate,
                         LAST_UPDATED_BY                     =fnd_global.user_id,
                         LAST_UPDATE_LOGIN                   =fnd_global.login_id
                         WHERE MR_VISIT_TYPE_ID=P_MR_VISIT_TYPE_REC.mr_visit_type_ID
                        and object_version_number=P_MR_VISIT_TYPE_REC.object_version_number;

Line: 114

PROCEDURE DELETE_ROW
 (
 p_mr_visit_type_rec              IN  mr_visit_type_REC_type
 )
AS
BEGIN
                  delete from AHL_mr_visit_types
                  where mr_visit_type_ID = p_mr_visit_type_rec .mr_visit_type_ID
                  and object_version_number=p_mr_visit_type_rec .object_version_number;

Line: 175

        IS SELECT
        MR_VISIT_TYPE_ID,
        OBJECT_VERSION_NUMBER,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_LOGIN,
        MR_VISIT_TYPE_CODE,
        MR_VISIT_TYPE,
        DESCRIPTION,
        MR_HEADER_ID,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15
        FROM AHL_MR_VISIT_TYPES_V
        WHERE MR_VISIT_TYPE_ID=C_MR_VISIT_TYPE_ID;

Line: 398

SELECT lookup_code
   FROM FND_LOOKUP_VALUES_VL
   WHERE lookup_type= c_lookup_type
   AND upper(ltrim(rtrim(meaning)))=upper(ltrim(rtrim(c_meaning)))
   AND sysdate between start_date_active
   AND nvl(end_date_active,sysdate);

Line: 433

SELECT mr_visit_type_ID
   FROM AHL_MR_VISIT_TYPES_app_v
   WHERE mr_visit_type_ID=c_mr_visit_type_id
   AND   OBJECT_VERSION_NUMBER=C_OBJECT_VERSION_NUMBER
   for update;

Line: 441

  SELECT MR_STATUS_CODE,IMPLEMENT_STATUS_CODE
   FROM AHL_MR_HEADERS_APP_V
   WHERE MR_HEADER_ID=c_mr_header_id
   and MR_STATUS_CODE IN('DRAFT','APPROVAL_REJECTED');

Line: 451

  SELECT MR_VISIT_TYPE_CODE,MR_VISIT_TYPE_ID,MR_HEADER_ID
   FROM AHL_mr_visit_typeS_app_v
   WHERE MR_HEADER_ID=c_mr_header_id
   and   MR_VISIT_TYPE_CODE=c_mr_visit_type_CODE;

Line: 462

    SELECT  'x'
    FROM    ahl_mr_headers_b
    WHERE   mr_header_id = c_mr_header_id AND
            program_type_code = 'MO_PROC';

Line: 477

 SELECT 'x'
 FROM   AHL_MR_VISIT_TYPES vt,
        AHL_MR_HEADERS_B mrh
 WHERE  vt.mr_header_id = mrh.mr_header_id
 AND    mrh.implement_status_code IN ('MANDATORY','OPTIONAL_IMPLEMENT')
 AND    mrh.mr_header_id = c_mr_header_id;

Line: 488

 SELECT 'X'
 FROM   AHL_MR_ORGANIZATIONS mro
 WHERE  mro.mr_title = c_mr_title;

Line: 494

 SELECT title
    FROM AHL_MR_HEADERS_B
    WHERE mr_header_id = c_mr_header_id
    AND   implement_status_code IN ('MANDATORY','OPTIONAL_IMPLEMENT');

Line: 815

                        DELETE_ROW (p_x_mr_visit_type_tbl(i) );

Line: 818

                   UPDATE_ROW (p_x_mr_visit_type_tbl(i) );

Line: 821

                   INSERT_ROW (p_x_mr_visit_type_tbl(i) );