DBA Data[Home] [Help]

APPS.EDR_SECURITY_UTIL dependencies on FND_FILE

Line 11: FND_FILE.PUT_LINE(FND_FILE.LOG,'Parameter: '||ACTION);

7: l_prod_schema varchar2(30);
8: l_status varchar2(10);
9: l_industry varchar2(10);
10: BEGIN
11: FND_FILE.PUT_LINE(FND_FILE.LOG,'Parameter: '||ACTION);
12: if (ACTION = 'ADD') then
13: FND_FILE.PUT_LINE(FND_FILE.LOG,'Adding security on the eRecords');
14:
15: --Bug 4440223: Start

Line 13: FND_FILE.PUT_LINE(FND_FILE.LOG,'Adding security on the eRecords');

9: l_industry varchar2(10);
10: BEGIN
11: FND_FILE.PUT_LINE(FND_FILE.LOG,'Parameter: '||ACTION);
12: if (ACTION = 'ADD') then
13: FND_FILE.PUT_LINE(FND_FILE.LOG,'Adding security on the eRecords');
14:
15: --Bug 4440223: Start
16: IF NOT FND_INSTALLATION.GET_APP_INFO('EDR', l_status, l_industry, l_prod_schema)
17: THEN

Line 53: FND_FILE.PUT_LINE(FND_FILE.LOG,'Dropping security on the eRecords');

49: 'DELETE'); --statement types
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;

Line 58: FND_FILE.PUT_LINE(FND_FILE.LOG,'Modification of security on eRecords sucessfully completed');

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:
61: --Bug 3187777: Start
62: --This function would strip the occurence of { } and \ from a string making sure