The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
X_DIMENSION_CODE IN VARCHAR2,
X_DIMENSION_NAME IN VARCHAR2,
X_STATUS_CODE IN VARCHAR2,
X_UPDATE_ALLOWED IN VARCHAR2,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATED_BY IN NUMBER,
X_CREATION_DATE IN DATE,
X_CREATED_BY IN NUMBER,
X_LAST_UPDATE_LOGIN IN NUMBER
) is
begin
insert into PA_ADW_DIMENSION_STATUS(
DIMENSION_CODE ,
DIMENSION_NAME ,
STATUS_CODE ,
UPDATE_ALLOWED ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN
) values (
X_DIMENSION_CODE ,
X_DIMENSION_NAME ,
X_STATUS_CODE ,
X_UPDATE_ALLOWED ,
X_LAST_UPDATE_DATE ,
X_LAST_UPDATED_BY ,
X_CREATION_DATE ,
X_CREATED_BY ,
X_LAST_UPDATE_LOGIN
);
end INSERT_ROW;
update PA_ADW_DIMENSION_STATUS set
DIMENSION_NAME = X_DIMENSION_NAME,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
LAST_UPDATE_LOGIN = 0
where DIMENSION_CODE = X_DIMENSION_CODE
and userenv('LANG') =
(select LANGUAGE_CODE from FND_LANGUAGES where INSTALLED_FLAG = 'B');
procedure UPDATE_ROW (
X_DIMENSION_CODE IN VARCHAR2,
X_DIMENSION_NAME IN VARCHAR2,
X_STATUS_CODE IN VARCHAR2,
X_UPDATE_ALLOWED IN VARCHAR2,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_LOGIN IN NUMBER
) is
begin
update PA_ADW_DIMENSION_STATUS set
DIMENSION_NAME = X_DIMENSION_NAME,
STATUS_CODE = X_STATUS_CODE,
UPDATE_ALLOWED = X_UPDATE_ALLOWED,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
where DIMENSION_CODE = X_DIMENSION_CODE ;
end UPDATE_ROW;