eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_SEC_PKG dependencies on DBMS_SESSION

Line 54: dbms_session.set_context('edw_context', 'resp_context',null);

50:
51: BEGIN
52:
53: --Reset context values
54: dbms_session.set_context('edw_context', 'resp_context',null);
55: dbms_session.set_context('edw_context', 'error_context',null);
56: dbms_session.set_context('edw_context', 'db_version_context',null);
57:
58:

Line 55: dbms_session.set_context('edw_context', 'error_context',null);

51: BEGIN
52:
53: --Reset context values
54: dbms_session.set_context('edw_context', 'resp_context',null);
55: dbms_session.set_context('edw_context', 'error_context',null);
56: dbms_session.set_context('edw_context', 'db_version_context',null);
57:
58:
59: --Get responsibility_id

Line 56: dbms_session.set_context('edw_context', 'db_version_context',null);

52:
53: --Reset context values
54: dbms_session.set_context('edw_context', 'resp_context',null);
55: dbms_session.set_context('edw_context', 'error_context',null);
56: dbms_session.set_context('edw_context', 'db_version_context',null);
57:
58:
59: --Get responsibility_id
60:

Line 70: dbms_session.set_context('edw_context', 'db_version_context', to_char(version_number));

66: --code change for bug 4498820
67: -- logic changed to take care of 10 G databases
68: --version_number := to_number(substr(x_db_version, 0, 1)||substr(x_db_version, 3, 1)||substr(x_db_version, 5, 1));
69: version_number := replace(substr(x_db_version,1,instr(x_db_version,'.',1,2)+1),'.');
70: dbms_session.set_context('edw_context', 'db_version_context', to_char(version_number));
71:
72:
73: -- Set maximum allowable context length
74:

Line 143: dbms_session.set_context('edw_context', x_context_name, x_context_value);

139:
140:
141: -- Set the context attribute for the dimension
142:
143: dbms_session.set_context('edw_context', x_context_name, x_context_value);
144:
145: END LOOP;
146:
147: dbms_session.set_context('edw_context', 'resp_context', ses_resp_id);

Line 147: dbms_session.set_context('edw_context', 'resp_context', ses_resp_id);

143: dbms_session.set_context('edw_context', x_context_name, x_context_value);
144:
145: END LOOP;
146:
147: dbms_session.set_context('edw_context', 'resp_context', ses_resp_id);
148:
149: commit;
150:
151:

Line 157: dbms_session.set_context('edw_context', 'DEF_SEC_ENABLE', x_default_sec);

153:
154: x_default_sec := FND_PROFILE.VALUE('EDW_DEFAULT_SECURITY');
155: x_default_sec := UPPER(x_default_sec);
156:
157: dbms_session.set_context('edw_context', 'DEF_SEC_ENABLE', x_default_sec);
158:
159: IF x_default_sec = 'Y' THEN /* Need to implement default security */
160:
161: edw_sec_pkg.link_aol_user;

Line 182: dbms_session.set_context('edw_context', 'error_context', 'TRUE');

178:
179:
180: -- Set the error_context to make security function aware of the error occured in initialization function
181:
182: dbms_session.set_context('edw_context', 'error_context', 'TRUE');
183: commit;
184:
185: WHEN OTHERS THEN
186: v_ErrorCode := SQLCODE;

Line 192: dbms_session.set_context('edw_context', 'error_context', 'TRUE');

188:
189: -- Set the error_context to make security function aware of the error occured in initialization function
190: -- This is moved before logging error so that if error logging fails, still we set the error_context
191:
192: dbms_session.set_context('edw_context', 'error_context', 'TRUE');
193:
194:
195: -- Log error message into edw_error_log table
196:

Line 256: dbms_session.set_context('edw_context', x_context_name ,null);

252: x_context_name := '' || x_context_name || '';
253:
254:
255: --Reset context values
256: dbms_session.set_context('edw_context', x_context_name ,null);
257:
258:
259: -- Check for error flag to make sure successfull execution of link_aol_user
260: error_flag := SYS_CONTEXT( 'edw_context', 'error_context');

Line 297: dbms_session.set_context('edw_context', x_context_name, x_context_value);

293:
294:
295: -- Set the context attribute for the dimension
296:
297: dbms_session.set_context('edw_context', x_context_name, x_context_value);
298:
299:
300: << last >>
301:

Line 307: dbms_session.set_context('edw_context', 'DEF_DIM_ID', to_char(x_def_dim_id));

303:
304: -- Set attribute def_dim_id
305: select dim_id into x_def_dim_id from edw_sec_dim_info_t
306: where dim_name = 'EDW_HR_PERSON_M';
307: dbms_session.set_context('edw_context', 'DEF_DIM_ID', to_char(x_def_dim_id));
308:
309:
310: EXCEPTION
311:

Line 328: dbms_session.set_context('edw_context', 'error_context', 'TRUE');

324:
325:
326: -- Set the error_context to make security function aware of the error occured in initialization function
327:
328: dbms_session.set_context('edw_context', 'error_context', 'TRUE');
329: commit;
330:
331: WHEN OTHERS THEN
332: v_ErrorCode := SQLCODE;

Line 338: dbms_session.set_context('edw_context', 'error_context', 'TRUE');

334:
335: -- Set the error_context to make security function aware of the error occured in initialization function
336: -- This is moved before logging error so that if error logging fails, still we set the error_context
337:
338: dbms_session.set_context('edw_context', 'error_context', 'TRUE');
339:
340:
341: -- Log error message into edw_error_log table
342:

Line 405: dbms_session.set_context('edw_context', 'def_access_column',null);

401: -- 2. def_access_id - populated with pk_key at that level i.e. the value of S03_SPRVSR_LVL1_PK_KEY column
402:
403:
404: --Reset context values
405: dbms_session.set_context('edw_context', 'def_access_column',null);
406: dbms_session.set_context('edw_context', 'def_access_id',null);
407:
408:
409: -- Capture apps user and get person_id by going across db_link to fnd_user on master source instance.

Line 406: dbms_session.set_context('edw_context', 'def_access_id',null);

402:
403:
404: --Reset context values
405: dbms_session.set_context('edw_context', 'def_access_column',null);
406: dbms_session.set_context('edw_context', 'def_access_id',null);
407:
408:
409: -- Capture apps user and get person_id by going across db_link to fnd_user on master source instance.
410:

Line 528: dbms_session.set_context('edw_context', 'def_access_column',x_access_column);

524:
525: x_access_column := 'ASGN_ASSIGNMENT_PK_KEY';
526: x_access_id := x_pk_key;
527:
528: dbms_session.set_context('edw_context', 'def_access_column',x_access_column);
529: dbms_session.set_context('edw_context', 'def_access_id',to_char(x_access_id));
530:
531: goto last;
532:

Line 529: dbms_session.set_context('edw_context', 'def_access_id',to_char(x_access_id));

525: x_access_column := 'ASGN_ASSIGNMENT_PK_KEY';
526: x_access_id := x_pk_key;
527:
528: dbms_session.set_context('edw_context', 'def_access_column',x_access_column);
529: dbms_session.set_context('edw_context', 'def_access_id',to_char(x_access_id));
530:
531: goto last;
532:
533: END IF;

Line 578: dbms_session.set_context('edw_context', 'def_access_column',x_access_column);

574: EXECUTE IMMEDIATE sql_stmt INTO x_access_id;
575:
576:
577:
578: dbms_session.set_context('edw_context', 'def_access_column',x_access_column);
579: dbms_session.set_context('edw_context', 'def_access_id',to_char(x_access_id));
580:
581:
582: << last >>

Line 579: dbms_session.set_context('edw_context', 'def_access_id',to_char(x_access_id));

575:
576:
577:
578: dbms_session.set_context('edw_context', 'def_access_column',x_access_column);
579: dbms_session.set_context('edw_context', 'def_access_id',to_char(x_access_id));
580:
581:
582: << last >>
583:

Line 599: dbms_session.set_context('edw_context', 'error_context', 'TRUE');

595: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
596:
597: -- Set the error_context to make security function aware of the error occured in initialization function
598:
599: dbms_session.set_context('edw_context', 'error_context', 'TRUE');
600: commit;
601:
602:
603: WHEN USER_NOT_LINKED THEN

Line 613: dbms_session.set_context('edw_context', 'error_context', 'TRUE');

609: edw_sec_util.log_error(x_object_name, x_object_type, ses_resp_id, null, x_message);
610:
611: -- Set the error_context to make security function aware of the error occured in initialization function
612:
613: dbms_session.set_context('edw_context', 'error_context', 'TRUE');
614: commit;
615:
616:
617: WHEN OTHERS THEN

Line 624: dbms_session.set_context('edw_context', 'error_context', 'TRUE');

620:
621: -- Set the error_context to make security function aware of the error occured in initialization function
622: -- This is moved before logging error so that if error logging fails, still we set the error_context
623:
624: dbms_session.set_context('edw_context', 'error_context', 'TRUE');
625:
626:
627: -- Log error message into edw_error_log table
628: