SSOQ
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
IDM_STAGING.MAP_ORG_PROF
Parameters
Name
Type
Mode
P_ORG
VARCHAR2
IN
P_SRV
VARCHAR2
IN
P_SECL
NUMBER
IN
Definition
procedure map_org_prof (p_org in VARCHAR2, p_srv in VARCHAR2, p_secL in NUMBER) AS v_orgobj ORGANIZATION.OBJECT_ID%Type; -- Cursor C1 (cp_srv VARCHAR2, cp_secLevel NUMBER) is SELECT unique Profile.object_id, Profile.active FROM Service, Profile, profile_role, Service_role WHERE Profile.object_id = profile_role.profile_object_id AND profile_role.role_object_id = service_role.role_object_id AND Service_role.service_object_id = Service.object_id AND Service.code = cp_srv AND Profile.security_level <= cp_secLevel AND Profile.Human_System = 1; -- Begin -- SELECT object_id INTO v_orgobj FROM ORGANIZATION WHERE code = p_org; -- For v_prfs In C1(p_srv, p_secL) Loop INSERT INTO PROFILE_ORGANIZATION(profile_object_id, organization_object_id, active, last_changed) VALUES(v_prfs.object_id, v_orgobj, v_prfs.active, sysdate); End Loop; -- Commit; -- End map_org_prof;