The following lines contain the word 'select', 'insert', 'update' or 'delete':
select bis_indicator_resps_s.NextVal into l_id from dual;
insert into bis_indicator_resps
(
INDICATOR_RESP_ID
, RESPONSIBILITY_ID
, TARGET_LEVEL_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
)
values
( l_id
, p_Measure_Security_Rec.RESPONSIBILITY_ID
, p_Measure_Security_Rec.TARGET_LEVEL_ID
, SYSDATE
, l_user_id
, SYSDATE
, l_user_id
, l_login_id
);
select RESPONSIBILITY_ID
from bis_indicator_resps
where TARGET_LEVEL_ID=p_Target_Level_Rec.Target_Level_Id;
select a.RESPONSIBILITY_ID
, a.RESPONSIBILITY_KEY
, a.RESPONSIBILITY_NAME
from fnd_responsibility_vl a, bis_indicator_resps b
where VERSION='W'
and start_date <= sysdate
and nvl(end_date, sysdate) >= sysdate
and a.RESPONSIBILITY_ID=b.RESPONSIBILITY_ID and b.TARGET_LEVEL_ID=p_Target_Level_Rec.Target_Level_Id
order by RESPONSIBILITY_NAME;
Procedure Update_Measure_Security
( p_api_version IN NUMBER
, p_commit IN VARCHAR2 := FND_API.G_FALSE
, p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
, p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
, p_error_proc_name => G_PKG_NAME||'.Update_Measure_Security'
, p_error_table => l_error_tbl
, x_error_table => x_error_tbl
);
END Update_Measure_Security;
Procedure Delete_Measure_Security
( p_api_version IN NUMBER
, p_commit IN VARCHAR2 := FND_API.G_FALSE
, p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
is
begin
x_return_status := FND_API.G_RET_STS_SUCCESS;
delete from bis_indicator_resps
where target_level_id = p_Target_Level_Rec.Target_Level_Id;
end Delete_Measure_Security;
Procedure Delete_Measure_Security
( p_api_version IN NUMBER
, p_commit IN VARCHAR2 := FND_API.G_FALSE
, p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
delete from bis_indicator_resps
where target_level_id = p_Measure_Security_Rec.Target_Level_Id
and RESPONSIBILITY_ID = p_Measure_Security_Rec.Responsibility_id;
, p_error_proc_name => G_PKG_NAME||'.Delete_Measure_Security'
, p_error_table => l_error_tbl
, x_error_table => x_error_tbl
);
END Delete_Measure_Security;
select il.target_level_id
, il.target_level_short_name
, il.target_level_name
, ir.Responsibility_ID
, fr.RESPONSIBILITY_NAME
, fr.RESPONSIBILITY_KEY
from bis_indicator_resps ir
, fnd_user_resp_groups ur
, bisbv_target_levels il
, fnd_responsibility_vl fr
where ur.user_id = p_user_id
and ir.responsibility_id = ur.responsibility_id
and ir.responsibility_id = fr.responsibility_id
and il.target_level_id = ir.target_level_id
and il.target_level_id = p_target_level_rec.target_level_id;
select il.target_level_id
, il.target_level_short_name
, il.target_level_name
, ir.Responsibility_ID
, fr.RESPONSIBILITY_NAME
, fr.RESPONSIBILITY_KEY
from bis_indicator_resps ir
, fnd_user_resp_groups ur
, bisbv_target_levels il
, fnd_responsibility_vl fr
where ur.user_id = p_user_id
and ir.responsibility_id = ur.responsibility_id
and ir.responsibility_id = fr.responsibility_id
and il.target_level_id = ir.target_level_id
and il.target_level_short_name=p_target_level_rec.target_level_short_name;
select il.target_level_id
, il.target_level_short_name
, il.target_level_name
, ir.Responsibility_ID
, fr.RESPONSIBILITY_NAME
, fr.RESPONSIBILITY_KEY
from bis_indicator_resps ir
, fnd_user_resp_groups ur
, bisbv_target_levels il
, fnd_responsibility_vl fr
where ur.user_id = p_user_id
and ir.responsibility_id = ur.responsibility_id
and ir.responsibility_id = fr.responsibility_id
and il.target_level_id = ir.target_level_id
and il.target_level_name = p_target_level_rec.target_level_name;
SELECT responsibility_id
FROM fnd_user_resp_groups
WHERE user_id=p_user_id;
SELECT responsibility_id
FROM bis_indicator_Resps
WHERE target_level_id=p_target_level_id;
PROCEDURE Delete_TargetLevel_Resp
( p_commit IN VARCHAR2 := FND_API.G_FALSE
, p_measure_short_name IN VARCHAR2
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
l_indicator_id NUMBER;
SELECT target_level_id FROM bis_target_levels
WHERE indicator_id = cp_indicator_id;
SAVEPOINT delete_resps;
SELECT indicator_id INTO l_indicator_id FROM bis_indicators WHERE short_name = p_measure_short_name;
DELETE FROM bis_indicator_resps
WHERE target_level_id = target_cursor.target_level_id;
ROLLBACK TO delete_resps;
, p_error_proc_name => G_PKG_NAME||'.Delete_TargetLevel_Resp'
, p_error_type => BIS_UTILITIES_PUB.G_ERROR
, p_error_table => l_error_tbl
, x_error_table => x_error_tbl
);
ROLLBACK TO delete_resps;
ROLLBACK TO delete_resps;
ROLLBACK TO delete_resps;
, p_error_proc_name => G_PKG_NAME||'.Delete_TargetLevel_Resp'
, p_error_table => l_error_tbl
, x_error_table => x_error_tbl
);
END Delete_TargetLevel_Resp;