APPS.EDR_SECURITY_UTIL dependencies on DBMS_RLS

Line 21: --DBMS_RLS.ADD_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_VIEW',

17: THEN
18: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
19: END IF;
20:
21: --DBMS_RLS.ADD_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_VIEW',
22: -- 'APPS', 'EDR_POLICY_FUNCTION_PKG.PSIG_VIEW', 'SELECT');
23: DBMS_RLS.ADD_POLICY
24: (l_prod_schema, --object schema
25: 'EDR_PSIG_DOCUMENTS', --object name

Line 23: DBMS_RLS.ADD_POLICY

19: END IF;
20:
21: --DBMS_RLS.ADD_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_VIEW',
22: -- 'APPS', 'EDR_POLICY_FUNCTION_PKG.PSIG_VIEW', 'SELECT');
23: DBMS_RLS.ADD_POLICY
24: (l_prod_schema, --object schema
25: 'EDR_PSIG_DOCUMENTS', --object name
26: 'EDR_DOCUMENTS_VIEW', --policy name
27: null, --function schema

Line 31: --DBMS_RLS.ADD_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_MODIFY',

27: null, --function schema
28: 'EDR_POLICY_FUNCTION_PKG.PSIG_VIEW', --policy function
29: 'SELECT'); --statement types
30:
31: --DBMS_RLS.ADD_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_MODIFY',
32: -- 'APPS', 'EDR_POLICY_FUNCTION_PKG.PSIG_MODIFY', 'INSERT, UPDATE');
33: DBMS_RLS.ADD_POLICY
34: (l_prod_schema, --object schema
35: 'EDR_PSIG_DOCUMENTS', --object name

Line 33: DBMS_RLS.ADD_POLICY

29: 'SELECT'); --statement types
30:
31: --DBMS_RLS.ADD_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_MODIFY',
32: -- 'APPS', 'EDR_POLICY_FUNCTION_PKG.PSIG_MODIFY', 'INSERT, UPDATE');
33: DBMS_RLS.ADD_POLICY
34: (l_prod_schema, --object schema
35: 'EDR_PSIG_DOCUMENTS', --object name
36: 'EDR_DOCUMENTS_MODIFY', --policy name
37: null, --function schema

Line 41: --DBMS_RLS.ADD_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_DELETE',

37: null, --function schema
38: 'EDR_POLICY_FUNCTION_PKG.PSIG_MODIFY', --policy function
39: 'INSERT, UPDATE'); --statement types
40:
41: --DBMS_RLS.ADD_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_DELETE',
42: -- 'APPS', 'EDR_POLICY_FUNCTION_PKG.PSIG_DELETE', 'DELETE');
43: DBMS_RLS.ADD_POLICY
44: (l_prod_schema, --object schema
45: 'EDR_PSIG_DOCUMENTS', --object name

Line 43: DBMS_RLS.ADD_POLICY

39: 'INSERT, UPDATE'); --statement types
40:
41: --DBMS_RLS.ADD_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_DELETE',
42: -- 'APPS', 'EDR_POLICY_FUNCTION_PKG.PSIG_DELETE', 'DELETE');
43: DBMS_RLS.ADD_POLICY
44: (l_prod_schema, --object schema
45: 'EDR_PSIG_DOCUMENTS', --object name
46: 'EDR_DOCUMENTS_DELETE', --policy name
47: null, --function schema

Line 54: DBMS_RLS.DROP_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_VIEW');

50: --Bug 4440223: End
51:
52: elsif (ACTION = 'DROP') then
53: FND_FILE.PUT_LINE(FND_FILE.LOG,'Dropping security on the eRecords');
54: DBMS_RLS.DROP_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_VIEW');
55: DBMS_RLS.DROP_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_MODIFY');
56: DBMS_RLS.DROP_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_DELETE');
57: end if;
58: FND_FILE.PUT_LINE(FND_FILE.LOG,'Modification of security on eRecords sucessfully completed');

Line 55: DBMS_RLS.DROP_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_MODIFY');

51:
52: elsif (ACTION = 'DROP') then
53: FND_FILE.PUT_LINE(FND_FILE.LOG,'Dropping security on the eRecords');
54: DBMS_RLS.DROP_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_VIEW');
55: DBMS_RLS.DROP_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_MODIFY');
56: DBMS_RLS.DROP_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_DELETE');
57: end if;
58: FND_FILE.PUT_LINE(FND_FILE.LOG,'Modification of security on eRecords sucessfully completed');
59: END add_drop_policy;

Line 56: DBMS_RLS.DROP_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_DELETE');

52: elsif (ACTION = 'DROP') then
53: FND_FILE.PUT_LINE(FND_FILE.LOG,'Dropping security on the eRecords');
54: DBMS_RLS.DROP_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_VIEW');
55: DBMS_RLS.DROP_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_MODIFY');
56: DBMS_RLS.DROP_POLICY('EDR', 'EDR_PSIG_DOCUMENTS', 'EDR_DOCUMENTS_DELETE');
57: end if;
58: FND_FILE.PUT_LINE(FND_FILE.LOG,'Modification of security on eRecords sucessfully completed');
59: END add_drop_policy;
60: