The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT * FROM AHL_MR_ACTIONS_V
WHERE MR_ACTION_ID=C_MR_ACTION_ID;
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);
SELECT plan_id
FROM QA_PLANS
WHERE upper(name)=upper(c_plan_name)
AND sysdate between EFFECTIVE_FROM
AND nvl(EFFECTIVE_TO,sysdate);
SELECT MR_ACTION_ID
FROM AHL_MR_ACTIONS_B
WHERE MR_ACTION_ID=c_mr_action_id;
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');
SELECT *
FROM AHL_MR_ACTIONS_B
WHERE MR_HEADER_ID=c_mr_header_id
and MR_ACTION_CODE=c_MR_ACTION_CODE;
delete from AHL_MR_ACTIONS_TL
where MR_ACTION_ID = p_x_mr_ACTION_TBL(i).MR_ACTION_ID;
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;
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);
SELECT AHL_MR_ACTIONS_B_S.NEXTVAL
INTO l_MR_ACTION_ID
FROM DUAL;
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);