APPS.AHL_FMP_MR_ACTION_PVT SQL Statements

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

Line: 12

 SELECT * FROM AHL_MR_ACTIONS_V
        WHERE MR_ACTION_ID=C_MR_ACTION_ID;

Line: 243

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

Line: 252

SELECT plan_id
   FROM QA_PLANS
   WHERE upper(name)=upper(c_plan_name)
   AND sysdate between EFFECTIVE_FROM
   AND nvl(EFFECTIVE_TO,sysdate);

Line: 313

SELECT MR_ACTION_ID
   FROM AHL_MR_ACTIONS_B
   WHERE MR_ACTION_ID=c_mr_action_id;

Line: 319

 SELECT MR_STATUS_CODE,nvl(TYPE_CODE,'X') TYPE_CODE
   FROM AHL_MR_HEADERS_B
   WHERE MR_HEADER_ID=c_mr_header_id
   and MR_STATUS_CODE IN('DRAFT','APPROVAL_REJECTED');

Line: 328

 SELECT *
   FROM AHL_MR_ACTIONS_B
   WHERE MR_HEADER_ID=c_mr_header_id
   and   MR_ACTION_CODE=c_MR_ACTION_CODE;

Line: 558

                  delete from AHL_MR_ACTIONS_TL
                  where MR_ACTION_ID = p_x_mr_ACTION_TBL(i).MR_ACTION_ID;

Line: 566

                     delete from AHL_MR_ACTIONS_B
                     where MR_ACTION_ID = p_x_mr_ACTION_TBL(i).MR_ACTION_ID
                     AND OBJECT_VERSION_NUMBER=p_x_mr_ACTION_TBL(i).OBJECT_VERSION_NUMBER;

Line: 579

                AHL_MR_ACTIONS_PKG.UPDATE_ROW (
                          X_MR_ACTION_ID                        =>p_x_mr_ACTION_TBL(i).MR_ACTION_ID,
                          X_OBJECT_VERSION_NUMBER               =>p_x_mr_ACTION_TBL(i).OBJECT_VERSION_NUMBER,
                          X_MR_HEADER_ID                        =>p_x_mr_ACTION_TBL(i).MR_HEADER_ID,
                          X_MR_ACTION_CODE                      =>p_x_mr_ACTION_TBL(i).MR_ACTION_CODE,
                          X_PLAN_ID                             =>p_x_mr_ACTION_TBL(i).PLAN_ID,
                          X_DESCRIPTION                         =>p_x_mr_ACTION_TBL(i).DESCRIPTION,
                          X_ATTRIBUTE_CATEGORY                  =>p_x_mr_ACTION_TBL(i).ATTRIBUTE_CATEGORY,
                          X_ATTRIBUTE1                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE1,
                          X_ATTRIBUTE2                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE2,
                          X_ATTRIBUTE3                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE3,
                          X_ATTRIBUTE4                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE4,
                          X_ATTRIBUTE5                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE5,
                          X_ATTRIBUTE6                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE6,
                          X_ATTRIBUTE7                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE7,
                          X_ATTRIBUTE8                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE8,
                          X_ATTRIBUTE9                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE9,
                          X_ATTRIBUTE10                         =>p_x_mr_ACTION_TBL(i).ATTRIBUTE10,
                          X_ATTRIBUTE11                         =>p_x_mr_ACTION_TBL(i).ATTRIBUTE11,
                          X_ATTRIBUTE12                         =>p_x_mr_ACTION_TBL(i).ATTRIBUTE12,
                          X_ATTRIBUTE13                         =>p_x_mr_ACTION_TBL(i).ATTRIBUTE13,
                          X_ATTRIBUTE14                         =>p_x_mr_ACTION_TBL(i).ATTRIBUTE14,
                          X_ATTRIBUTE15                         =>p_x_mr_ACTION_TBL(i).ATTRIBUTE15,
                          X_LAST_UPDATE_DATE                    =>sysdate,
                          X_LAST_UPDATED_BY                     =>fnd_global.user_id,
                          X_LAST_UPDATE_LOGIN                   =>fnd_global.user_id);

Line: 608

             SELECT AHL_MR_ACTIONS_B_S.NEXTVAL
                    INTO  l_MR_ACTION_ID
                    FROM DUAL;

Line: 613

             AHL_MR_ACTIONS_PKG.INSERT_ROW (
                          X_ROWID                               =>l_ROWID,
                          X_MR_ACTION_ID                        =>l_MR_ACTION_ID,
                          X_OBJECT_VERSION_NUMBER               =>1,
                          X_MR_HEADER_ID                        =>p_x_mr_ACTION_TBL(i).MR_HEADER_ID,
                          X_MR_ACTION_CODE                      =>p_x_mr_ACTION_TBL(i).MR_ACTION_CODE,
                          X_PLAN_ID                             =>p_x_mr_ACTION_TBL(i).PLAN_ID,
                          X_DESCRIPTION                         =>p_x_mr_ACTION_TBL(i).DESCRIPTION,
                          X_ATTRIBUTE_CATEGORY                  =>p_x_mr_ACTION_TBL(i).ATTRIBUTE_CATEGORY,
                          X_ATTRIBUTE1                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE1,
                          X_ATTRIBUTE2                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE2,
                          X_ATTRIBUTE3                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE3,
                          X_ATTRIBUTE4                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE4,
                          X_ATTRIBUTE5                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE5,
                          X_ATTRIBUTE6                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE6,
                          X_ATTRIBUTE7                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE7,
                          X_ATTRIBUTE8                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE8,
                          X_ATTRIBUTE9                          =>p_x_mr_ACTION_TBL(i).ATTRIBUTE9,
                          X_ATTRIBUTE10                         =>p_x_mr_ACTION_TBL(i).ATTRIBUTE10,
                          X_ATTRIBUTE11                         =>p_x_mr_ACTION_TBL(i).ATTRIBUTE11,
                          X_ATTRIBUTE12                         =>p_x_mr_ACTION_TBL(i).ATTRIBUTE12,
                          X_ATTRIBUTE13                         =>p_x_mr_ACTION_TBL(i).ATTRIBUTE13,
                          X_ATTRIBUTE14                         =>p_x_mr_ACTION_TBL(i).ATTRIBUTE14,
                          X_ATTRIBUTE15                         =>p_x_mr_ACTION_TBL(i).ATTRIBUTE15,
                          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.user_id);