DBA Data[Home] [Help]

APPS.HZ_ELOCATION_PKG dependencies on DBMS_RLS

Line 1845: dbms_rls.enable_policy(l_owners(l_count) , l_objects(l_count),

1841: FETCH c_policies BULK COLLECT INTO l_owners, l_objects, l_policies;
1842: CLOSE c_policies;
1843: -- disable currently enabled policies
1844: FOR l_count IN 1..l_owners.COUNT LOOP
1845: dbms_rls.enable_policy(l_owners(l_count) , l_objects(l_count),
1846: l_policies(l_count), FALSE);
1847: END LOOP;
1848: OPEN c_index(x_index_owner);
1849: FETCH c_index into l_status,l_domidx_opstatus;

Line 1938: dbms_rls.enable_policy(l_owners(l_count), l_objects(l_count),

1934: Close c_index;
1935: --disable_debug;
1936: -- restore previous state: re-enable previously enabled policies
1937: FOR l_count IN 1..l_owners.COUNT LOOP
1938: dbms_rls.enable_policy(l_owners(l_count), l_objects(l_count),
1939: l_policies(l_count), TRUE);
1940: END LOOP;
1941: -- clean up.
1942: l_owners.DELETE;

Line 1975: dbms_rls.enable_policy(l_owners(l_count), l_objects(l_count),

1971: p_msg_level=>fnd_log.level_procedure);
1972: END IF;
1973: -- bug fix 3872778 enable policy function
1974: FOR l_count IN 1..l_owners.COUNT LOOP
1975: dbms_rls.enable_policy(l_owners(l_count), l_objects(l_count),
1976: l_policies(l_count), TRUE);
1977: END LOOP;
1978: --disable_debug;
1979: retcode := '2';