APPS.EDW_SEC_POLICY dependencies on EDW_SEC_POLICY

Line 1: package body edw_sec_policy as

1: package body edw_sec_policy as
2: /* $Header: EDWSPLCB.pls 120.1 2006/03/28 01:47:43 rkumar noship $*/
3:
4: -- This procedure associates a security policy to specified fact table
5:

Line 16: x_object_name varchar2(30) := 'EDW_SEC_POLICY.ATTACH_POLICY';

12: fact_short_name varchar2(50);
13:
14: g_conc_program_id number;
15:
16: x_object_name varchar2(30) := 'EDW_SEC_POLICY.ATTACH_POLICY';
17: x_object_type varchar2(30) := 'Security Procedure';
18:
19: x_count number :=0;
20:

Line 66: DBMS_RLS.ADD_POLICY(x_object_owner, fact_short_name, 'edw_sec_policy', 'apps', 'edw_sec_pkg.dim_sec', 'select', TRUE);

62: END IF;
63:
64: -- Associate the policy with fact table
65:
66: DBMS_RLS.ADD_POLICY(x_object_owner, fact_short_name, 'edw_sec_policy', 'apps', 'edw_sec_pkg.dim_sec', 'select', TRUE);
67:
68: EXCEPTION
69:
70: WHEN OTHERS THEN

Line 100: x_object_name varchar2(30) := 'EDW_SEC_POLICY.DETACH_POLICY';

96: fact_short_name varchar2(50);
97:
98: g_conc_program_id number;
99:
100: x_object_name varchar2(30) := 'EDW_SEC_POLICY.DETACH_POLICY';
101: x_object_type varchar2(30) := 'Security Procedure';
102:
103: x_count number :=0;
104:

Line 152: DBMS_RLS.DROP_POLICY(x_object_owner, fact_short_name, 'edw_sec_policy');

148:
149:
150: -- Remove the policy from fact table
151:
152: DBMS_RLS.DROP_POLICY(x_object_owner, fact_short_name, 'edw_sec_policy');
153:
154: EXCEPTION
155:
156: WHEN OTHERS THEN

Line 193: x_object_name varchar2(50) := 'EDW_SEC_POLICY.ATTACH_DEFAULT_POLICY';

189: fact_short_name varchar2(50);
190:
191: g_conc_program_id number;
192:
193: x_object_name varchar2(50) := 'EDW_SEC_POLICY.ATTACH_DEFAULT_POLICY';
194: x_object_type varchar2(30) := 'Security Procedure';
195:
196: x_count number :=0;
197:

Line 277: x_object_name varchar2(50) := 'EDW_SEC_POLICY.DETACH_DEFAULT_POLICY';

273: fact_short_name varchar2(50);
274:
275: g_conc_program_id number;
276:
277: x_object_name varchar2(50) := 'EDW_SEC_POLICY.DETACH_DEFAULT_POLICY';
278: x_object_type varchar2(30) := 'Security Procedure';
279:
280: x_count number :=0;
281:

Line 353: END edw_sec_policy;

349:
350: END detach_default_policy;
351:
352:
353: END edw_sec_policy;