DBA Data[Home] [Help]

APPS.BSC_DBGEN_STD_METADATA dependencies on DBMS_SQL

Line 67: dimension_set DBMS_SQL.NUMBER_TABLE,

63: TYPE ClsFact IS RECORD(
64: Fact_id NUMBER,-- bsc indicator equivalent
65: Fact_Name VARCHAR2(240),
66: Fact_Type VARCHAR2(30),
67: dimension_set DBMS_SQL.NUMBER_TABLE,
68: Application_short_name VARCHAR2(30),
69: properties tab_ClsProperties);
70: TYPE tab_clsFact IS TABLE OF clsFact INDEX BY PLS_INTEGER;
71:

Line 83: Parents1N DBMS_SQL.VARCHAR2_TABLE,

79: Level_table_name VARCHAR2(240),
80: Level_PK VARCHAR2(240),
81: Level_PK_Datatype VARCHAR2(100),
82: LEVEL_FK VARCHAR2(240), -- for BSC
83: Parents1N DBMS_SQL.VARCHAR2_TABLE,
84: ParentsMN DBMS_SQL.VARCHAR2_TABLE,
85: properties tab_ClsProperties );
86:
87: TYPE tab_ClsLevel IS TABLE OF ClsLevel INDEX BY PLS_INTEGER;

Line 84: ParentsMN DBMS_SQL.VARCHAR2_TABLE,

80: Level_PK VARCHAR2(240),
81: Level_PK_Datatype VARCHAR2(100),
82: LEVEL_FK VARCHAR2(240), -- for BSC
83: Parents1N DBMS_SQL.VARCHAR2_TABLE,
84: ParentsMN DBMS_SQL.VARCHAR2_TABLE,
85: properties tab_ClsProperties );
86:
87: TYPE tab_ClsLevel IS TABLE OF ClsLevel INDEX BY PLS_INTEGER;
88:

Line 149: Parent_periods dbms_sql.varchar2_table,

145: Periodicity_id NUMBER,
146: Periodicity_Name VARCHAR2(240),
147: periodicity_type NUMBER,
148: Calendar_id NUMBER,
149: Parent_periods dbms_sql.varchar2_table,
150: properties tab_ClsProperties);
151: TYPE tab_ClsPeriodicity IS TABLE OF ClsPeriodicity INDEX BY PLS_INTEGER;
152:
153: TYPE clsNUMBERV IS RECORD