APPS.EDW_SEC_PKG dependencies on EDW_SEC_DIM_ACCESS

Line 11: select distinct dim_id from edw_sec_dim_access

7:
8: -- PRAGMA AUTONOMOUS_TRANSACTION;
9:
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;

Line 19: from edw_sec_dim_access

15: current_level_id edw_sec_lvl_info_t.level_id%TYPE;
16:
17: cursor access_value_cursor is
18: select distinct level_id
19: from edw_sec_dim_access
20: where resp_id = ses_resp_id
21: and dim_id = current_dim_id;
22:
23: x_db_version varchar2(30);

Line 116: ' in ( select access_value from edw_sec_dim_access where resp_id = ' || ses_resp_id || ' and dim_id = ' || current_dim_id || ' and level_id = ' || current_level_id ||' )';

112: current_level_id := access_value_rec.level_id;
113:
114: If temp_context_value is null then
115: temp_context_value := x_star_user_col_name ||
116: ' in ( select access_value from edw_sec_dim_access where resp_id = ' || ses_resp_id || ' and dim_id = ' || current_dim_id || ' and level_id = ' || current_level_id ||' )';
117:
118: else
119: temp_context_value := temp_context_value ||
120: ' OR ' ||

Line 122: ' in ( select access_value from edw_sec_dim_access where resp_id = ' || ses_resp_id || ' and dim_id = ' || current_dim_id || ' and level_id = ' || current_level_id ||' )';

118: else
119: temp_context_value := temp_context_value ||
120: ' OR ' ||
121: x_star_user_col_name ||
122: ' in ( select access_value from edw_sec_dim_access where resp_id = ' || ses_resp_id || ' and dim_id = ' || current_dim_id || ' and level_id = ' || current_level_id ||' )';
123: end if;
124:
125: END LOOP;
126:

Line 704: from edw_sec_dim_access t1, edw_sec_fact_info_t t2

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
705: where resp_id = ses_resp_id
706: and t1.dim_id = t2.dim_id
707: and t2.fact_id = x_fact_id;
708:

Line 713: x_def_dim_id edw_sec_dim_access.dim_id%TYPE;

709: sec_rec sec_cursor%ROWTYPE;
710:
711: ---------------------------------------------------------------
712:
713: x_def_dim_id edw_sec_dim_access.dim_id%TYPE;
714:
715: cursor sec_def_cursor is select distinct t1.dim_id
716: from edw_sec_dim_access t1, edw_sec_fact_info_t t2
717: where resp_id = ses_resp_id

Line 716: from edw_sec_dim_access t1, edw_sec_fact_info_t t2

712:
713: x_def_dim_id edw_sec_dim_access.dim_id%TYPE;
714:
715: cursor sec_def_cursor is select distinct t1.dim_id
716: from edw_sec_dim_access t1, edw_sec_fact_info_t t2
717: where resp_id = ses_resp_id
718: and t1.dim_id = t2.dim_id
719: and t2.fact_id = x_fact_id
720: and t1.dim_id <> x_def_dim_id;