APPS.AD_MO_UTIL_PKG dependencies on DBMS_RLS

Line 164: DBMS_RLS.DROP_POLICY( p_apps_user_name,

160:
161: -- if policy aleady exists then drop the policy.
162:
163: IF policy_flag='TRUE' THEN
164: DBMS_RLS.DROP_POLICY( p_apps_user_name,
165: v_synonym,
166: p_sec_policy_name);
167: END IF;
168:

Line 172: dbms_rls.add_policy (p_apps_user_name,

168:
169: IF (upper(v_synonym) in ('AP_EXPENSE_REPORTS',
170: 'AP_EXPENSE_REPORT_PARAMS')) THEN
171:
172: dbms_rls.add_policy (p_apps_user_name,
173: v_synonym,
174: p_sec_policy_name,
175: p_apps_user_name,
176: 'AP_WEB_UTILITIES_PKG.ORGSECURITY', -- OIC policy

Line 181: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);

177: 'SELECT, INSERT, UPDATE, DELETE',
178: TRUE,
179: TRUE,
180: FALSE,
181: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
182:
183: ELSIF (upper(v_synonym) = 'QP_LIST_HEADERS_B') THEN
184:
185: dbms_rls.add_policy (p_apps_user_name,

Line 185: dbms_rls.add_policy (p_apps_user_name,

181: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
182:
183: ELSIF (upper(v_synonym) = 'QP_LIST_HEADERS_B') THEN
184:
185: dbms_rls.add_policy (p_apps_user_name,
186: v_synonym,
187: p_sec_policy_name,
188: p_apps_user_name,
189: 'QP_SECURITY.QP_ORG_SECURITY', -- QP policy

Line 194: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);

190: 'SELECT, INSERT, UPDATE, DELETE',
191: TRUE,
192: TRUE,
193: FALSE,
194: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
195:
196: ELSIF (upper(v_synonym) = 'AR_PAYMENT_SCHEDULES') THEN
197:
198: dbms_rls.add_policy (p_apps_user_name,

Line 198: dbms_rls.add_policy (p_apps_user_name,

194: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
195:
196: ELSIF (upper(v_synonym) = 'AR_PAYMENT_SCHEDULES') THEN
197:
198: dbms_rls.add_policy (p_apps_user_name,
199: v_synonym,
200: p_sec_policy_name,
201: p_apps_user_name,
202: 'MO_GLOBAL.ORG_SECURITY_GLOBAL',

Line 207: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);

203: 'SELECT, INSERT, UPDATE, DELETE',
204: TRUE,
205: TRUE,
206: FALSE,
207: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
208:
209: ELSE
210: dbms_rls.add_policy (p_apps_user_name,
211: v_synonym,

Line 210: dbms_rls.add_policy (p_apps_user_name,

206: FALSE,
207: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
208:
209: ELSE
210: dbms_rls.add_policy (p_apps_user_name,
211: v_synonym,
212: p_sec_policy_name,
213: p_apps_user_name,
214: 'MO_GLOBAL.ORG_SECURITY', -- Standard MO VPD policy

Line 219: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);

215: 'SELECT, INSERT, UPDATE, DELETE',
216: TRUE,
217: TRUE,
218: FALSE,
219: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
220: END IF;
221:
222: CLOSE c_policy_exists;
223: