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 EDW_SEC_PKG

Line 1: package body edw_sec_pkg as

1: package body edw_sec_pkg as
2: /* $Header: EDWSPKGB.pls 120.2 2005/09/20 00:07:19 amitgupt noship $*/
3:
4: -- This procedure sets the EDW context attributes
5:

Line 39: x_object_name varchar2(30) := 'EDW_SEC_PKG.SET_CONTEXT';

35: x_lowest_level_col_name edw_sec_dim_info_t.lowest_level_col_name%TYPE;
36: x_star_user_col_name edw_sec_lvl_info_t.star_level_name_col_name%TYPE;
37: x_access_value number;
38:
39: x_object_name varchar2(30) := 'EDW_SEC_PKG.SET_CONTEXT';
40: x_object_type varchar2(30) := 'Security Procedure';
41:
42: v_Errorcode number;
43: v_ErrorText varchar2(200);

Line 161: edw_sec_pkg.link_aol_user;

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;
162: edw_sec_pkg.set_default_context;
163:
164: END IF;
165:

Line 162: edw_sec_pkg.set_default_context;

158:
159: IF x_default_sec = 'Y' THEN /* Need to implement default security */
160:
161: edw_sec_pkg.link_aol_user;
162: edw_sec_pkg.set_default_context;
163:
164: END IF;
165:
166:

Line 226: x_object_name varchar2(40) := 'EDW_SEC_PKG.SET_DEFAULT_CONTEXT';

222:
223: x_context_value varchar2(4000) := NULL;
224: x_context_name varchar2(30); -- edw_sec_dim_info_t.context_name%TYPE := NULL;
225:
226: x_object_name varchar2(40) := 'EDW_SEC_PKG.SET_DEFAULT_CONTEXT';
227: x_object_type varchar2(30) := 'Security Procedure';
228:
229: v_Errorcode number;
230: v_ErrorText varchar2(200);

Line 359: x_object_name varchar2(40) := 'EDW_SEC_PKG.LINK_AOL_USER';

355: PROCEDURE Link_aol_user IS
356:
357: -- PRAGMA AUTONOMOUS_TRANSACTION;
358:
359: x_object_name varchar2(40) := 'EDW_SEC_PKG.LINK_AOL_USER';
360: x_object_type varchar2(30) := 'Security Procedure';
361:
362: v_Errorcode number;
363: v_ErrorText varchar2(200);

Line 680: ('EDW_SEC_PKG.set_global_names_for_source', 'EDW Security Package', NULL,

676: insert into edw_error_log
677: (object_name, object_type, resp_id, message,
678: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
679: values
680: ('EDW_SEC_PKG.set_global_names_for_source', 'EDW Security Package', NULL,
681: 'Oracle error occured in EDW_SEC_PKG.set_global_names_for_source procedure at step : '|| x_step
682: || '. Errorcode is : ' || v_ErrorCode || ' and Errortext is : ' || v_ErrorText,
683: sysdate, 0, sysdate, 0, 0);
684: commit;

Line 681: 'Oracle error occured in EDW_SEC_PKG.set_global_names_for_source procedure at step : '|| x_step

677: (object_name, object_type, resp_id, message,
678: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
679: values
680: ('EDW_SEC_PKG.set_global_names_for_source', 'EDW Security Package', NULL,
681: 'Oracle error occured in EDW_SEC_PKG.set_global_names_for_source procedure at step : '|| x_step
682: || '. Errorcode is : ' || v_ErrorCode || ' and Errortext is : ' || v_ErrorText,
683: sysdate, 0, sysdate, 0, 0);
684: commit;
685: END set_global_names_for_source;

Line 754: x_object_name varchar2(30) := 'EDW_SEC_PKG.DIM_SEC';

750: version_number number;
751: max_predicate_length number;
752: temp_predicate varchar2(4000);
753:
754: x_object_name varchar2(30) := 'EDW_SEC_PKG.DIM_SEC';
755: x_object_type varchar2(30) := 'Security Procedure';
756:
757: v_Errorcode number;
758: v_ErrorText varchar2(200);

Line 770: edw_sec_pkg.set_global_names_for_source;

766:
767:
768: BEGIN
769: --added for bug 4577390, need to global names to false
770: edw_sec_pkg.set_global_names_for_source;
771:
772: --- Set edw context Added for bug 4577390
773: edw_sec_pkg.set_context;
774:

Line 773: edw_sec_pkg.set_context;

769: --added for bug 4577390, need to global names to false
770: edw_sec_pkg.set_global_names_for_source;
771:
772: --- Set edw context Added for bug 4577390
773: edw_sec_pkg.set_context;
774:
775: --Get responsibility_id
776:
777: --ses_resp_id := FND_PROFILE.VALUE('RESP_ID');

Line 1030: x_object_name varchar2(30) := 'EDW_SEC_PKG.DEFAULT_SEC';

1026: version_number number;
1027: max_predicate_length number;
1028: temp_predicate varchar2(4000);
1029:
1030: x_object_name varchar2(30) := 'EDW_SEC_PKG.DEFAULT_SEC';
1031: x_object_type varchar2(30) := 'Security Procedure';
1032:
1033: v_Errorcode number;
1034: v_ErrorText varchar2(200);

Line 1047: edw_sec_pkg.set_global_names_for_source;

1043:
1044:
1045: BEGIN
1046: --added for bug 4577390, need to global names to false
1047: edw_sec_pkg.set_global_names_for_source;
1048:
1049: --- Set edw context Added for bug 4577390
1050: edw_sec_pkg.set_context;
1051:

Line 1050: edw_sec_pkg.set_context;

1046: --added for bug 4577390, need to global names to false
1047: edw_sec_pkg.set_global_names_for_source;
1048:
1049: --- Set edw context Added for bug 4577390
1050: edw_sec_pkg.set_context;
1051:
1052: -- Check for error flag to make sure successfull execution of initialization function
1053:
1054: error_flag := SYS_CONTEXT( 'edw_context', 'error_context');

Line 1196: END edw_sec_pkg;

1192:
1193:
1194:
1195:
1196: END edw_sec_pkg;