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_BSC_BRIDGE dependencies on EDW_HIERARCHIES_MD_V

Line 69: p_hier_prefix EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE

65: FROM EDW_FACTS_MD_V
66: WHERE FACT_NAME = p_fact_name;
67:
68: CURSOR c_time_hier_id(
69: p_hier_prefix EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE
70: ) IS
71: SELECT HIER_ID
72: FROM EDW_HIERARCHIES_MD_V
73: WHERE

Line 72: FROM EDW_HIERARCHIES_MD_V

68: CURSOR c_time_hier_id(
69: p_hier_prefix EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE
70: ) IS
71: SELECT HIER_ID
72: FROM EDW_HIERARCHIES_MD_V
73: WHERE
74: DIM_ID = v_time_dimension_id
75: AND HIER_PREFIX = p_hier_prefix;
76:

Line 163: v_445_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;

159: SYN.TABLE_OWNER = TAB.OWNER AND
160: TAB.COLUMN_NAME = UPPER(p_col_name);
161:
162:
163: v_445_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
164: v_pa_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
165: v_gl_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
166: v_enterprise_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
167: v_gregerion_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;

Line 164: v_pa_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;

160: TAB.COLUMN_NAME = UPPER(p_col_name);
161:
162:
163: v_445_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
164: v_pa_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
165: v_gl_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
166: v_enterprise_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
167: v_gregerion_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
168:

Line 165: v_gl_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;

161:
162:
163: v_445_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
164: v_pa_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
165: v_gl_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
166: v_enterprise_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
167: v_gregerion_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
168:
169:

Line 166: v_enterprise_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;

162:
163: v_445_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
164: v_pa_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
165: v_gl_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
166: v_enterprise_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
167: v_gregerion_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
168:
169:
170:

Line 167: v_gregerion_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;

163: v_445_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
164: v_pa_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
165: v_gl_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
166: v_enterprise_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
167: v_gregerion_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE := NULL;
168:
169:
170:
171: FUNCTION GET_DIM_ID(

Line 259: p_hier_prefix IN EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE

255: p_measure_name EDW_FACT_ATTRIBUTES_MD_V.ATTRIBUTE_NAME%TYPE
256: )RETURN NUMBER;
257:
258: FUNCTION GET_HIER_ID(
259: p_hier_prefix IN EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE
260: ) RETURN NUMBER;
261:
262: FUNCTION GET_TIME_HIER_ID(
263: p_hier_prefix IN EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE

Line 263: p_hier_prefix IN EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE

259: p_hier_prefix IN EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE
260: ) RETURN NUMBER;
261:
262: FUNCTION GET_TIME_HIER_ID(
263: p_hier_prefix IN EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE
264: ) RETURN NUMBER;
265:
266: --Kernal Entries
267: -- #1.1

Line 867: p_hier_prefix IN EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE

863: END GET_FACT_ID;
864:
865:
866: FUNCTION GET_TIME_HIER_ID(
867: p_hier_prefix IN EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE
868: ) RETURN NUMBER IS
869: BEGIN
870: IF p_hier_prefix = 'TIME45' THEN
871: IF v_445_id IS NOT NULL THEN

Line 910: p_hier_prefix IN EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE

906: END GET_TIME_HIER_ID;
907:
908:
909: FUNCTION GET_HIER_ID(
910: p_hier_prefix IN EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE
911: ) RETURN NUMBER IS
912: l_hier_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE;
913: BEGIN
914: OPEN c_time_hier_id(p_hier_prefix);

Line 912: l_hier_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE;

908:
909: FUNCTION GET_HIER_ID(
910: p_hier_prefix IN EDW_HIERARCHIES_MD_V.HIER_PREFIX%TYPE
911: ) RETURN NUMBER IS
912: l_hier_id EDW_HIERARCHIES_MD_V.HIER_ID%TYPE;
913: BEGIN
914: OPEN c_time_hier_id(p_hier_prefix);
915: FETCH c_time_hier_id INTO l_hier_id;
916: CLOSE c_time_hier_id;