The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
X_JTF_AUTH_PRINCIPAL_ID in NUMBER,
X_PRINCIPAL_DESC_ID in NUMBER,
X_OBJECT_VERSION_NUMBER in NUMBER,
X_PRINCIPAL_NAME in VARCHAR2,
X_APPLICATION_ID in NUMBER,
X_USER_ID in NUMBER,
X_IS_USER_FLAG in NUMBER,
X_DAC_ROLE_FLAG in NUMBER,
X_PRINCIPAL_DESC in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_CREATION_DATE in DATE,
X_CREATED_BY in NUMBER,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
JTF_AUTH_PRINCIPALS_PKG.INSERT_ROW (
X_JTF_AUTH_PRINCIPAL_ID,
X_PRINCIPAL_DESC_ID,
X_OBJECT_VERSION_NUMBER,
X_PRINCIPAL_NAME,
X_APPLICATION_ID,
X_USER_ID,
X_IS_USER_FLAG,
X_DAC_ROLE_FLAG,
X_PRINCIPAL_DESC,
X_DESCRIPTION,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);
end INSERT_ROW;
procedure UPDATE_ROW (
X_JTF_AUTH_PRINCIPAL_ID in NUMBER,
X_PRINCIPAL_DESC_ID in NUMBER,
X_OBJECT_VERSION_NUMBER in NUMBER,
X_PRINCIPAL_NAME in VARCHAR2,
X_APPLICATION_ID in NUMBER,
X_USER_ID in NUMBER,
X_IS_USER_FLAG in NUMBER,
X_DAC_ROLE_FLAG in NUMBER,
X_PRINCIPAL_DESC in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
JTF_AUTH_PRINCIPALS_PKG.UPDATE_ROW (
X_JTF_AUTH_PRINCIPAL_ID,
X_PRINCIPAL_DESC_ID,
X_OBJECT_VERSION_NUMBER,
X_PRINCIPAL_NAME,
X_APPLICATION_ID,
X_USER_ID,
X_IS_USER_FLAG,
X_DAC_ROLE_FLAG,
X_PRINCIPAL_DESC,
X_DESCRIPTION,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);
end UPDATE_ROW;
procedure DELETE_ROW (
X_JTF_AUTH_PRINCIPAL_ID in NUMBER
) is
begin
JTF_AUTH_PRINCIPALS_PKG.DELETE_ROW (
X_JTF_AUTH_PRINCIPAL_ID
);
end DELETE_ROW;
PROCEDURE delete_row (
p_principal_name IN VARCHAR2,
p_is_user_flag IN VARCHAR2,
x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
) IS
BEGIN
jtf_auth_principals_pkg.delete_row(
p_principal_name,
p_is_user_flag,
x_return_status,
x_msg_count,
x_msg_data);
END delete_row;