APPS.EDW_BSC_BRIDGE dependencies on EDW_FACTS_MD_V

Line 18: fact_id EDW_FACTS_MD_V.FACT_ID%TYPE,

14: t_FactMeasure
15: INDEX BY BINARY_INTEGER;
16:
17: TYPE t_Fact IS RECORD (
18: fact_id EDW_FACTS_MD_V.FACT_ID%TYPE,
19: fact_name EDW_FACTS_MD_V.FACT_NAME%TYPE
20: );
21:
22: TYPE FactTable IS TABLE of

Line 19: fact_name EDW_FACTS_MD_V.FACT_NAME%TYPE

15: INDEX BY BINARY_INTEGER;
16:
17: TYPE t_Fact IS RECORD (
18: fact_id EDW_FACTS_MD_V.FACT_ID%TYPE,
19: fact_name EDW_FACTS_MD_V.FACT_NAME%TYPE
20: );
21:
22: TYPE FactTable IS TABLE of
23: t_Fact

Line 44: v_fact_id EDW_FACTS_MD_V.FACT_ID%TYPE := NULL;

40: SCRIPTED constant VARCHAR2(30) := 'Scripted';
41: DEBUG constant VARCHAR2(30) := 'Debug';
42: -- Cache the EDW_TIME_M Dimsension ID.
43: v_time_dimension_id EDW_DIMENSIONS_MD_V.DIM_NAME%TYPE := NULL;
44: v_fact_id EDW_FACTS_MD_V.FACT_ID%TYPE := NULL;
45: v_fact_name EDW_FACTS_MD_V.FACT_NAME%TYPE := NULL;
46:
47: CURSOR dim_id(
48: p_object_name EDW_DIMENSIONS_MD_V.DIM_NAME%TYPE

Line 45: v_fact_name EDW_FACTS_MD_V.FACT_NAME%TYPE := NULL;

41: DEBUG constant VARCHAR2(30) := 'Debug';
42: -- Cache the EDW_TIME_M Dimsension ID.
43: v_time_dimension_id EDW_DIMENSIONS_MD_V.DIM_NAME%TYPE := NULL;
44: v_fact_id EDW_FACTS_MD_V.FACT_ID%TYPE := NULL;
45: v_fact_name EDW_FACTS_MD_V.FACT_NAME%TYPE := NULL;
46:
47: CURSOR dim_id(
48: p_object_name EDW_DIMENSIONS_MD_V.DIM_NAME%TYPE
49: ) IS

Line 58: FROM EDW_FACTS_MD_V;

54: CURSOR c_fact IS
55: SELECT
56: FACT_ID
57: , FACT_NAME
58: FROM EDW_FACTS_MD_V;
59:
60: CURSOR c_factid (
61: p_fact_name EDW_FACTS_MD_V.FACT_NAME%TYPE
62: )IS

Line 61: p_fact_name EDW_FACTS_MD_V.FACT_NAME%TYPE

57: , FACT_NAME
58: FROM EDW_FACTS_MD_V;
59:
60: CURSOR c_factid (
61: p_fact_name EDW_FACTS_MD_V.FACT_NAME%TYPE
62: )IS
63: SELECT
64: FACT_ID
65: FROM EDW_FACTS_MD_V

Line 65: FROM EDW_FACTS_MD_V

61: p_fact_name EDW_FACTS_MD_V.FACT_NAME%TYPE
62: )IS
63: SELECT
64: FACT_ID
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

Line 188: p_fact_name IN EDW_FACTS_MD_V.FACT_NAME%TYPE

184: , p_info EDW_CALSUM4_BSC_LOG.INFO%TYPE
185: );
186:
187: FUNCTION GET_FACT_ID(
188: p_fact_name IN EDW_FACTS_MD_V.FACT_NAME%TYPE
189: ) RETURN EDW_FACTS_MD_V.FACT_ID%TYPE;
190:
191: FUNCTION CHECK_VALIDILITY(
192: p_tbl_name ALL_TAB_COLUMNS.TABLE_NAME%TYPE ,

Line 189: ) RETURN EDW_FACTS_MD_V.FACT_ID%TYPE;

185: );
186:
187: FUNCTION GET_FACT_ID(
188: p_fact_name IN EDW_FACTS_MD_V.FACT_NAME%TYPE
189: ) RETURN EDW_FACTS_MD_V.FACT_ID%TYPE;
190:
191: FUNCTION CHECK_VALIDILITY(
192: p_tbl_name ALL_TAB_COLUMNS.TABLE_NAME%TYPE ,
193: p_col_name ALL_TAB_COLUMNS.COLUMN_NAME%TYPE)

Line 272: l_fact_id EDW_FACTS_MD_V.FACT_ID%TYPE;

268: PROCEDURE POPULATE_EDW_CALSUM4_BSC(
269: errbuf OUT NOCOPY VARCHAR2,
270: retcode OUT NOCOPY NUMBER
271: ) IS
272: l_fact_id EDW_FACTS_MD_V.FACT_ID%TYPE;
273: l_fact EDW_FACTS_MD_V.FACT_NAME%TYPE;
274: l_fact_tbl FactTable;
275: l_fact_count BINARY_INTEGER;
276: l_fact_index BINARY_INTEGER;

Line 273: l_fact EDW_FACTS_MD_V.FACT_NAME%TYPE;

269: errbuf OUT NOCOPY VARCHAR2,
270: retcode OUT NOCOPY NUMBER
271: ) IS
272: l_fact_id EDW_FACTS_MD_V.FACT_ID%TYPE;
273: l_fact EDW_FACTS_MD_V.FACT_NAME%TYPE;
274: l_fact_tbl FactTable;
275: l_fact_count BINARY_INTEGER;
276: l_fact_index BINARY_INTEGER;
277: BEGIN

Line 853: p_fact_name IN EDW_FACTS_MD_V.FACT_NAME%TYPE

849: LOG(NULL, DONE, 'EDW_CALSUM4_BSC table was populated successfully!');
850: END;
851:
852: FUNCTION GET_FACT_ID(
853: p_fact_name IN EDW_FACTS_MD_V.FACT_NAME%TYPE
854: ) RETURN EDW_FACTS_MD_V.FACT_ID%TYPE IS
855: BEGIN
856: IF(v_fact_name IS NULL OR v_fact_name <> p_fact_name) THEN
857: v_fact_name := p_fact_name;

Line 854: ) RETURN EDW_FACTS_MD_V.FACT_ID%TYPE IS

850: END;
851:
852: FUNCTION GET_FACT_ID(
853: p_fact_name IN EDW_FACTS_MD_V.FACT_NAME%TYPE
854: ) RETURN EDW_FACTS_MD_V.FACT_ID%TYPE IS
855: BEGIN
856: IF(v_fact_name IS NULL OR v_fact_name <> p_fact_name) THEN
857: v_fact_name := p_fact_name;
858: OPEN c_factid(p_fact_name);