APPS.AD_MO_UTIL_PKG dependencies on DBMS_RLS

Line 133: DBMS_RLS.DROP_POLICY( p_apps_user_name,

129:
130: -- if policy aleady exists then drop the policy.
131:
132: IF policy_flag='TRUE' THEN
133: DBMS_RLS.DROP_POLICY( p_apps_user_name,
134: v_synonym,
135: p_sec_policy_name);
136: END IF;
137:

Line 141: dbms_rls.add_policy (p_apps_user_name,

137:
138: IF (upper(v_synonym) in ('AP_EXPENSE_REPORTS',
139: 'AP_EXPENSE_REPORT_PARAMS')) THEN
140:
141: dbms_rls.add_policy (p_apps_user_name,
142: v_synonym,
143: p_sec_policy_name,
144: p_apps_user_name,
145: 'AP_WEB_UTILITIES_PKG.ORGSECURITY', -- OIC policy

Line 150: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);

146: 'SELECT, INSERT, UPDATE, DELETE',
147: TRUE,
148: TRUE,
149: FALSE,
150: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
151:
152: ELSIF (upper(v_synonym) = 'QP_LIST_HEADERS_B') THEN
153:
154: dbms_rls.add_policy (p_apps_user_name,

Line 154: dbms_rls.add_policy (p_apps_user_name,

150: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
151:
152: ELSIF (upper(v_synonym) = 'QP_LIST_HEADERS_B') THEN
153:
154: dbms_rls.add_policy (p_apps_user_name,
155: v_synonym,
156: p_sec_policy_name,
157: p_apps_user_name,
158: 'QP_SECURITY.QP_ORG_SECURITY', -- QP policy

Line 163: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);

159: 'SELECT, INSERT, UPDATE, DELETE',
160: TRUE,
161: TRUE,
162: FALSE,
163: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
164:
165: ELSIF (upper(v_synonym) = 'AR_PAYMENT_SCHEDULES') THEN
166:
167: dbms_rls.add_policy (p_apps_user_name,

Line 167: dbms_rls.add_policy (p_apps_user_name,

163: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
164:
165: ELSIF (upper(v_synonym) = 'AR_PAYMENT_SCHEDULES') THEN
166:
167: dbms_rls.add_policy (p_apps_user_name,
168: v_synonym,
169: p_sec_policy_name,
170: p_apps_user_name,
171: 'MO_GLOBAL.ORG_SECURITY_GLOBAL',

Line 176: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);

172: 'SELECT, INSERT, UPDATE, DELETE',
173: TRUE,
174: TRUE,
175: FALSE,
176: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
177:
178: ELSE
179: dbms_rls.add_policy (p_apps_user_name,
180: v_synonym,

Line 179: dbms_rls.add_policy (p_apps_user_name,

175: FALSE,
176: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
177:
178: ELSE
179: dbms_rls.add_policy (p_apps_user_name,
180: v_synonym,
181: p_sec_policy_name,
182: p_apps_user_name,
183: 'MO_GLOBAL.ORG_SECURITY', -- Standard MO VPD policy

Line 188: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);

184: 'SELECT, INSERT, UPDATE, DELETE',
185: TRUE,
186: TRUE,
187: FALSE,
188: DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
189: END IF;
190:
191: CLOSE c_policy_exists;
192: