APPS.EDW_SEC_PKG dependencies on EDW_SEC_DIM_INFO_T

Line 14: current_dim_id edw_sec_dim_info_t.dim_id%TYPE;

10: cursor dim_access_cursor is
11: select distinct dim_id from edw_sec_dim_access
12: where resp_id = ses_resp_id;
13:
14: current_dim_id edw_sec_dim_info_t.dim_id%TYPE;
15: current_level_id edw_sec_lvl_info_t.level_id%TYPE;
16:
17: cursor access_value_cursor is
18: select distinct level_id

Line 33: x_context_name edw_sec_dim_info_t.context_name%TYPE := NULL;

29: access_value_rec access_value_cursor%ROWTYPE;
30:
31: x_context_value varchar2(4000) := NULL;
32: temp_context_value varchar2(4000) := NULL;
33: x_context_name edw_sec_dim_info_t.context_name%TYPE := NULL;
34: x_table_name edw_sec_dim_info_t.table_name%TYPE;
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;

Line 34: x_table_name edw_sec_dim_info_t.table_name%TYPE;

30:
31: x_context_value varchar2(4000) := NULL;
32: temp_context_value varchar2(4000) := NULL;
33: x_context_name edw_sec_dim_info_t.context_name%TYPE := NULL;
34: x_table_name edw_sec_dim_info_t.table_name%TYPE;
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:

Line 35: x_lowest_level_col_name edw_sec_dim_info_t.lowest_level_col_name%TYPE;

31: x_context_value varchar2(4000) := NULL;
32: temp_context_value varchar2(4000) := NULL;
33: x_context_name edw_sec_dim_info_t.context_name%TYPE := NULL;
34: x_table_name edw_sec_dim_info_t.table_name%TYPE;
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';

Line 87: from edw_sec_dim_info_t

83: FOR dim_access_rec IN dim_access_cursor LOOP
84:
85: select context_name, table_name, lowest_level_col_name
86: into x_context_name, x_table_name, x_lowest_level_col_name
87: from edw_sec_dim_info_t
88: where dim_id = dim_access_rec.dim_id;
89:
90: current_dim_id := dim_access_rec.dim_id;
91:

Line 224: x_context_name varchar2(30); -- edw_sec_dim_info_t.context_name%TYPE := NULL;

220: version_number number;
221: max_context_length number;
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:

Line 235: x_def_dim_id edw_sec_dim_info_t.dim_id%TYPE;

231:
232: LARGE_CONTEXT_LENGTH EXCEPTION;
233:
234: error_flag varchar2(30) := NULL;
235: x_def_dim_id edw_sec_dim_info_t.dim_id%TYPE;
236:
237: LINK_AOL_USER_ERROR EXCEPTION;
238:
239: x_message varchar2(2000);

Line 305: select dim_id into x_def_dim_id from edw_sec_dim_info_t

301:
302: commit;
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:

Line 700: x_context_name edw_sec_dim_info_t.context_name%TYPE;

696:
697: d_predicate varchar2(4000) := null;
698: x_fact_id number;
699: x_fk_col_name edw_sec_fact_info_t.fk_col_name%TYPE;
700: x_context_name edw_sec_dim_info_t.context_name%TYPE;
701:
702:
703: cursor sec_cursor is select distinct t1.dim_id
704: from edw_sec_dim_access t1, edw_sec_fact_info_t t2

Line 843: from edw_sec_dim_info_t

839: FOR fk_rec in fk_cursor LOOP
840: x_fk_col_name := fk_rec.fk_col_name;
841:
842: select context_name into x_context_name
843: from edw_sec_dim_info_t
844: where dim_id = sec_def_rec.dim_id;
845:
846: x_context_name := '' || x_context_name || '';
847:

Line 899: from edw_sec_dim_info_t

895: FOR fk_rec in fk_cursor LOOP
896: x_fk_col_name := fk_rec.fk_col_name;
897:
898: select context_name into x_context_name
899: from edw_sec_dim_info_t
900: where dim_id = sec_rec.dim_id;
901:
902: x_context_name := '' || x_context_name || '';
903:

Line 1022: x_context_name varchar2(30); --edw_sec_dim_info_t.context_name%TYPE;

1018: PRAGMA AUTONOMOUS_TRANSACTION;
1019:
1020: d_predicate varchar2(4000) := null;
1021: x_fk_col_name varchar2(30); -- edw_sec_fact_info_t.fk_col_name%TYPE;
1022: x_context_name varchar2(30); --edw_sec_dim_info_t.context_name%TYPE;
1023:
1024:
1025: error_flag varchar2(30) := NULL;
1026: version_number number;