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.BSC_MO_HELPER_PKG dependencies on BSC_METADATA_OPTIMIZER_PKG

Line 64: Function FindIndex(arrstr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, findThis in varchar2) return NUMBER ;

60: FUNCTION IsNumber (str IN VARCHAR2) RETURN BOOLEAN ;
61:
62: Function FindIndexVARCHAR2(arrStr IN dbms_sql.varchar2_table, str IN VARCHAR2) return NUMBER;
63: Function FindIndex(arrNum IN dbms_sql.NUMBER_TABLE, num IN NUMBER) RETURN NUMBER;
64: Function FindIndex(arrstr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, findThis in varchar2) return NUMBER ;
65: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, findThis in varchar2) return NUMBER;
66: Function FindKeyIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, keyName in varchar2) return NUMBER;
67: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable, findThis in varchar2) return NUMBER;
68:

Line 65: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, findThis in varchar2) return NUMBER;

61:
62: Function FindIndexVARCHAR2(arrStr IN dbms_sql.varchar2_table, str IN VARCHAR2) return NUMBER;
63: Function FindIndex(arrNum IN dbms_sql.NUMBER_TABLE, num IN NUMBER) RETURN NUMBER;
64: Function FindIndex(arrstr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, findThis in varchar2) return NUMBER ;
65: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, findThis in varchar2) return NUMBER;
66: Function FindKeyIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, keyName in varchar2) return NUMBER;
67: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable, findThis in varchar2) return NUMBER;
68:
69: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable, findThis in varchar2) return NUMBER;

Line 66: Function FindKeyIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, keyName in varchar2) return NUMBER;

62: Function FindIndexVARCHAR2(arrStr IN dbms_sql.varchar2_table, str IN VARCHAR2) return NUMBER;
63: Function FindIndex(arrNum IN dbms_sql.NUMBER_TABLE, num IN NUMBER) RETURN NUMBER;
64: Function FindIndex(arrstr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, findThis in varchar2) return NUMBER ;
65: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, findThis in varchar2) return NUMBER;
66: Function FindKeyIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, keyName in varchar2) return NUMBER;
67: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable, findThis in varchar2) return NUMBER;
68:
69: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable, findThis in varchar2) return NUMBER;
70:

Line 67: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable, findThis in varchar2) return NUMBER;

63: Function FindIndex(arrNum IN dbms_sql.NUMBER_TABLE, num IN NUMBER) RETURN NUMBER;
64: Function FindIndex(arrstr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, findThis in varchar2) return NUMBER ;
65: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, findThis in varchar2) return NUMBER;
66: Function FindKeyIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, keyName in varchar2) return NUMBER;
67: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable, findThis in varchar2) return NUMBER;
68:
69: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable, findThis in varchar2) return NUMBER;
70:
71: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator, findThis in number) return NUMBER ;

Line 69: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable, findThis in varchar2) return NUMBER;

65: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, findThis in varchar2) return NUMBER;
66: Function FindKeyIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, keyName in varchar2) return NUMBER;
67: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable, findThis in varchar2) return NUMBER;
68:
69: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable, findThis in varchar2) return NUMBER;
70:
71: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator, findThis in number) return NUMBER ;
72: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField, findThis in VARCHAR2, p_source IN VARCHAR2, p_impl_type IN NUMBER ) return NUMBER ;
73: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField, findThis in NUMBER) return NUMBER ;

Line 71: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator, findThis in number) return NUMBER ;

67: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable, findThis in varchar2) return NUMBER;
68:
69: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable, findThis in varchar2) return NUMBER;
70:
71: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator, findThis in number) return NUMBER ;
72: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField, findThis in VARCHAR2, p_source IN VARCHAR2, p_impl_type IN NUMBER ) return NUMBER ;
73: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField, findThis in NUMBER) return NUMBER ;
74: --BSC Autogen
75: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV, findThis in VARCHAR2, p_source IN VARCHAR2, pIgnoreCase In Boolean default false) return NUMBER ;

Line 72: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField, findThis in VARCHAR2, p_source IN VARCHAR2, p_impl_type IN NUMBER ) return NUMBER ;

68:
69: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable, findThis in varchar2) return NUMBER;
70:
71: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator, findThis in number) return NUMBER ;
72: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField, findThis in VARCHAR2, p_source IN VARCHAR2, p_impl_type IN NUMBER ) return NUMBER ;
73: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField, findThis in NUMBER) return NUMBER ;
74: --BSC Autogen
75: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV, findThis in VARCHAR2, p_source IN VARCHAR2, pIgnoreCase In Boolean default false) return NUMBER ;
76: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity, findThis in NUMBER) return NUMBER ;

Line 73: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField, findThis in NUMBER) return NUMBER ;

69: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable, findThis in varchar2) return NUMBER;
70:
71: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator, findThis in number) return NUMBER ;
72: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField, findThis in VARCHAR2, p_source IN VARCHAR2, p_impl_type IN NUMBER ) return NUMBER ;
73: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField, findThis in NUMBER) return NUMBER ;
74: --BSC Autogen
75: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV, findThis in VARCHAR2, p_source IN VARCHAR2, pIgnoreCase In Boolean default false) return NUMBER ;
76: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity, findThis in NUMBER) return NUMBER ;
77: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsCalendar, findThis in NUMBER) return NUMBER ;

Line 75: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV, findThis in VARCHAR2, p_source IN VARCHAR2, pIgnoreCase In Boolean default false) return NUMBER ;

71: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator, findThis in number) return NUMBER ;
72: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField, findThis in VARCHAR2, p_source IN VARCHAR2, p_impl_type IN NUMBER ) return NUMBER ;
73: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField, findThis in NUMBER) return NUMBER ;
74: --BSC Autogen
75: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV, findThis in VARCHAR2, p_source IN VARCHAR2, pIgnoreCase In Boolean default false) return NUMBER ;
76: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity, findThis in NUMBER) return NUMBER ;
77: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsCalendar, findThis in NUMBER) return NUMBER ;
78: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels, findThis in varchar2) return NUMBER ;
79:

Line 76: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity, findThis in NUMBER) return NUMBER ;

72: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField, findThis in VARCHAR2, p_source IN VARCHAR2, p_impl_type IN NUMBER ) return NUMBER ;
73: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField, findThis in NUMBER) return NUMBER ;
74: --BSC Autogen
75: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV, findThis in VARCHAR2, p_source IN VARCHAR2, pIgnoreCase In Boolean default false) return NUMBER ;
76: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity, findThis in NUMBER) return NUMBER ;
77: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsCalendar, findThis in NUMBER) return NUMBER ;
78: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels, findThis in varchar2) return NUMBER ;
79:
80:

Line 77: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsCalendar, findThis in NUMBER) return NUMBER ;

73: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField, findThis in NUMBER) return NUMBER ;
74: --BSC Autogen
75: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV, findThis in VARCHAR2, p_source IN VARCHAR2, pIgnoreCase In Boolean default false) return NUMBER ;
76: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity, findThis in NUMBER) return NUMBER ;
77: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsCalendar, findThis in NUMBER) return NUMBER ;
78: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels, findThis in varchar2) return NUMBER ;
79:
80:
81: FUNCTION getInitColumn(p_column IN VARCHAR2) return VARCHAR2 ;

Line 78: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels, findThis in varchar2) return NUMBER ;

74: --BSC Autogen
75: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV, findThis in VARCHAR2, p_source IN VARCHAR2, pIgnoreCase In Boolean default false) return NUMBER ;
76: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity, findThis in NUMBER) return NUMBER ;
77: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsCalendar, findThis in NUMBER) return NUMBER ;
78: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels, findThis in varchar2) return NUMBER ;
79:
80:
81: FUNCTION getInitColumn(p_column IN VARCHAR2) return VARCHAR2 ;
82: FUNCTION get_lookup_value(p_lookup_type IN VARCHAR2, p_lookup_code IN VARCHAR2) return VARCHAR2;

Line 100: PROCEDURE AddIndicator(collIndicadores IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator, p_Code NUMBER,

96: Function table_column_exists(p_table IN VARCHAR2, p_Column IN VARCHAR2) RETURN boolean;
97: PROCEDURE InitializeYear ;
98: PROCEDURE CleanDatabase;
99:
100: PROCEDURE AddIndicator(collIndicadores IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator, p_Code NUMBER,
101: p_Name varchar2, p_indicatorType NUMBER, p_configType NUMBER,
102: p_per_inter NUMBER, p_optMode NUMBER, p_action_flag NUMBER,
103: p_share_flag NUMBER, p_src_ind NUMBER, p_edw_flag NUMBER, p_impl_type NUMBER) ;
104: Function getKPIPropertyValue(Indic IN NUMBER, Variable IN VARCHAR2,

Line 111: --PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable, proc IN VARCHAR2);

107: PROCEDURE writeTmp(msg IN VARCHAR2, pSeverity IN NUMBER DEFAULT NULL, pForce IN boolean default false);
108: PROCEDURE UpdateFlags;
109:
110: PROCEDURE SaveOptimizationMode;
111: --PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable, proc IN VARCHAR2);
112: PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable,
113: pKeyFields IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
114: pData IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,
115: proc IN VARCHAR2);

Line 112: PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable,

108: PROCEDURE UpdateFlags;
109:
110: PROCEDURE SaveOptimizationMode;
111: --PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable, proc IN VARCHAR2);
112: PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable,
113: pKeyFields IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
114: pData IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,
115: proc IN VARCHAR2);
116:

Line 113: pKeyFields IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,

109:
110: PROCEDURE SaveOptimizationMode;
111: --PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable, proc IN VARCHAR2);
112: PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable,
113: pKeyFields IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
114: pData IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,
115: proc IN VARCHAR2);
116:
117:

Line 114: pData IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,

110: PROCEDURE SaveOptimizationMode;
111: --PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable, proc IN VARCHAR2);
112: PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable,
113: pKeyFields IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
114: pData IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,
115: proc IN VARCHAR2);
116:
117:
118: FUNCTION boolean_decode (pVal IN BOOLEAN) RETURN VARCHAR2;

Line 122: PROCEDURE write_this (pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsConfigKpiMV ,

118: FUNCTION boolean_decode (pVal IN BOOLEAN) RETURN VARCHAR2;
119:
120:
121:
122: PROCEDURE write_this (pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsConfigKpiMV ,
123: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);
124: PROCEDURE write_this (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsConfigKpiMV ,
125: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);
126:

Line 124: PROCEDURE write_this (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsConfigKpiMV ,

120:
121:
122: PROCEDURE write_this (pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsConfigKpiMV ,
123: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);
124: PROCEDURE write_this (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsConfigKpiMV ,
125: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);
126:
127: PROCEDURE write_this (pTable IN DBMS_SQL.VARCHAR2_TABLE,
128: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,

Line 133: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsAuxillaryField, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);

129: pForce IN boolean default false);
130: PROCEDURE write_this (pTable IN DBMS_SQL.NUMBER_TABLE,
131: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
132: pForce IN boolean default false);
133: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsAuxillaryField, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
134: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsAuxillaryField, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
135: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsParent, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
136: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsParent, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
137: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsMasterTable,

Line 134: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsAuxillaryField, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);

130: PROCEDURE write_this (pTable IN DBMS_SQL.NUMBER_TABLE,
131: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
132: pForce IN boolean default false);
133: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsAuxillaryField, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
134: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsAuxillaryField, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
135: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsParent, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
136: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsParent, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
137: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsMasterTable,
138: ind IN NUMBER default null,

Line 135: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsParent, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);

131: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
132: pForce IN boolean default false);
133: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsAuxillaryField, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
134: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsAuxillaryField, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
135: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsParent, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
136: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsParent, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
137: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsMasterTable,
138: ind IN NUMBER default null,
139: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,

Line 136: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsParent, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);

132: pForce IN boolean default false);
133: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsAuxillaryField, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
134: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsAuxillaryField, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
135: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsParent, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
136: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsParent, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
137: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsMasterTable,
138: ind IN NUMBER default null,
139: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
140: pForce IN boolean default false);

Line 137: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsMasterTable,

133: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsAuxillaryField, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
134: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsAuxillaryField, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
135: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsParent, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
136: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsParent, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
137: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsMasterTable,
138: ind IN NUMBER default null,
139: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
140: pForce IN boolean default false);
141: PROCEDURE write_this(

Line 142: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable,

138: ind IN NUMBER default null,
139: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
140: pForce IN boolean default false);
141: PROCEDURE write_this(
142: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable,
143: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
144: pForce IN boolean default false);
145: PROCEDURE write_this(
146: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsRelationMN,

Line 146: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsRelationMN,

142: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable,
143: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
144: pForce IN boolean default false);
145: PROCEDURE write_this(
146: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsRelationMN,
147: ind IN NUMBER default null,
148: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
149: pForce IN boolean default false);
150: PROCEDURE write_this(

Line 151: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsRelationMN,

147: ind IN NUMBER default null,
148: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
149: pForce IN boolean default false);
150: PROCEDURE write_this(
151: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsRelationMN,
152: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
153: pForce IN boolean default false);
154: PROCEDURE write_this(
155: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsIndicator,

Line 155: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsIndicator,

151: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsRelationMN,
152: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
153: pForce IN boolean default false);
154: PROCEDURE write_this(
155: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsIndicator,
156: ind IN NUMBER default null,
157: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
158: pForce IN boolean default false);
159: PROCEDURE write_this(

Line 160: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator,

156: ind IN NUMBER default null,
157: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
158: pForce IN boolean default false);
159: PROCEDURE write_this(
160: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator,
161: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
162: pForce IN boolean default false);
163: PROCEDURE write_this(
164: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity,

Line 164: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity,

160: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator,
161: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
162: pForce IN boolean default false);
163: PROCEDURE write_this(
164: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity,
165: ind IN NUMBER default null,
166: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
167: pForce IN boolean default false);
168: PROCEDURE write_this(

Line 169: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity ,

165: ind IN NUMBER default null,
166: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
167: pForce IN boolean default false);
168: PROCEDURE write_this(
169: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity ,
170: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
171: pForce IN boolean default false);
172: PROCEDURE write_this(
173: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsIndicPeriodicity,

Line 173: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsIndicPeriodicity,

169: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity ,
170: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
171: pForce IN boolean default false);
172: PROCEDURE write_this(
173: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsIndicPeriodicity,
174: ind IN NUMBER default null,
175: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
176: pForce IN boolean default false);
177: PROCEDURE write_this(

Line 178: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicPeriodicity ,

174: ind IN NUMBER default null,
175: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
176: pForce IN boolean default false);
177: PROCEDURE write_this(
178: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicPeriodicity ,
179: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
180: pForce IN boolean default false);
181: PROCEDURE write_this(
182: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsCalendar,

Line 182: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsCalendar,

178: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicPeriodicity ,
179: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
180: pForce IN boolean default false);
181: PROCEDURE write_this(
182: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsCalendar,
183: ind IN NUMBER default null,
184: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
185: pForce IN boolean default false);
186: PROCEDURE write_this(

Line 187: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsCalendar,

183: ind IN NUMBER default null,
184: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
185: pForce IN boolean default false);
186: PROCEDURE write_this(
187: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsCalendar,
188: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
189: pForce IN boolean default false);
190: PROCEDURE write_this(
191: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsOldBTables,

Line 191: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsOldBTables,

187: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsCalendar,
188: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
189: pForce IN boolean default false);
190: PROCEDURE write_this(
191: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsOldBTables,
192: ind IN NUMBER default null,
193: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
194: pForce IN boolean default false);
195: PROCEDURE write_this(

Line 196: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsOldBTables,

192: ind IN NUMBER default null,
193: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
194: pForce IN boolean default false);
195: PROCEDURE write_this(
196: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsOldBTables,
197: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
198: pForce IN boolean default false);
199: PROCEDURE write_this(
200: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV,

Line 200: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV,

196: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsOldBTables,
197: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
198: pForce IN boolean default false);
199: PROCEDURE write_this(
200: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV,
201: ind IN NUMBER default null,
202: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
203: pForce IN boolean default false);
204: PROCEDURE write_this(

Line 205: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV,

201: ind IN NUMBER default null,
202: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
203: pForce IN boolean default false);
204: PROCEDURE write_this(
205: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV,
206: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
207: pForce IN boolean default false);
208: PROCEDURE write_this(
209: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsLevels,

Line 209: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsLevels,

205: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV,
206: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
207: pForce IN boolean default false);
208: PROCEDURE write_this(
209: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsLevels,
210: ind IN NUMBER default null,
211: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
212: pForce IN boolean default false);
213: PROCEDURE write_this(

Line 214: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,

210: ind IN NUMBER default null,
211: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
212: pForce IN boolean default false);
213: PROCEDURE write_this(
214: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,
215: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
216: pForce IN boolean default false);
217: PROCEDURE write_this(
218: pTable IN BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels,

Line 218: pTable IN BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels,

214: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,
215: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
216: pForce IN boolean default false);
217: PROCEDURE write_this(
218: pTable IN BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels,
219: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
220: pForce IN boolean default false);
221: PROCEDURE write_this(
222: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,

Line 222: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,

218: pTable IN BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels,
219: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
220: pForce IN boolean default false);
221: PROCEDURE write_this(
222: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
223: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
224: pForce IN boolean default false);
225: PROCEDURE write_this(
226: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsLevelCombinations,

Line 226: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsLevelCombinations,

222: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
223: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
224: pForce IN boolean default false);
225: PROCEDURE write_this(
226: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsLevelCombinations,
227: ind IN NUMBER default null,
228: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
229: pForce IN boolean default false);
230: PROCEDURE write_this(

Line 231: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations,

227: ind IN NUMBER default null,
228: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
229: pForce IN boolean default false);
230: PROCEDURE write_this(
231: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations,
232: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
233: pForce IN boolean default false);
234: PROCEDURE write_this(
235: pTable IN BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevelCombinations,

Line 235: pTable IN BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevelCombinations,

231: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations,
232: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
233: pForce IN boolean default false);
234: PROCEDURE write_this(
235: pTable IN BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevelCombinations,
236: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
237: pForce IN boolean default false);
238: PROCEDURE write_this(
239: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations,

Line 239: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations,

235: pTable IN BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevelCombinations,
236: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
237: pForce IN boolean default false);
238: PROCEDURE write_this(
239: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations,
240: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
241: pForce IN boolean default false);
242: PROCEDURE write_this(
243: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField,

Line 243: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField,

239: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations,
240: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
241: pForce IN boolean default false);
242: PROCEDURE write_this(
243: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField,
244: ind IN NUMBER default null,
245: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
246: pForce IN boolean default false);
247: PROCEDURE write_this(

Line 248: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,

244: ind IN NUMBER default null,
245: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
246: pForce IN boolean default false);
247: PROCEDURE write_this(
248: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
249: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
250: pForce IN boolean default false);
251: PROCEDURE write_this(
252: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDataField,

Line 252: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDataField,

248: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
249: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
250: pForce IN boolean default false);
251: PROCEDURE write_this(
252: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDataField,
253: ind IN NUMBER default null,
254: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
255: pForce IN boolean default false);
256: PROCEDURE write_this(

Line 257: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,

253: ind IN NUMBER default null,
254: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
255: pForce IN boolean default false);
256: PROCEDURE write_this(
257: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,
258: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
259: pForce IN boolean default false);
260: PROCEDURE write_this(
261: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,

Line 261: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,

257: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,
258: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
259: pForce IN boolean default false);
260: PROCEDURE write_this(
261: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,
262: ind IN NUMBER default null,
263: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
264: pForce IN boolean default false);
265: PROCEDURE write_this(

Line 266: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable,

262: ind IN NUMBER default null,
263: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
264: pForce IN boolean default false);
265: PROCEDURE write_this(
266: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable,
267: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
268: pForce IN boolean default false);
269: PROCEDURE write_this(
270: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_string,

Line 270: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_string,

266: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable,
267: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
268: pForce IN boolean default false);
269: PROCEDURE write_this(
270: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_string,
271: ind IN NUMBER default null,
272: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
273: pForce IN boolean default false);
274: PROCEDURE write_this(

Line 275: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_string,

271: ind IN NUMBER default null,
272: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
273: pForce IN boolean default false);
274: PROCEDURE write_this(
275: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_string,
276: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
277: pForce IN boolean default false);
278: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.number_table, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);MBER DEFAULT FND_LOG.LEVEL_STATEMENT);
279: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.TwoDNumberTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);_STATEMENT);

Line 278: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.number_table, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);MBER DEFAULT FND_LOG.LEVEL_STATEMENT);

274: PROCEDURE write_this(
275: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_string,
276: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
277: pForce IN boolean default false);
278: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.number_table, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);MBER DEFAULT FND_LOG.LEVEL_STATEMENT);
279: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.TwoDNumberTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);_STATEMENT);
280: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsOriginTable, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
281: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsOriginTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);VEL_STATEMENT);
282: PROCEDURE write_this(

Line 279: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.TwoDNumberTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);_STATEMENT);

275: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_string,
276: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
277: pForce IN boolean default false);
278: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.number_table, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);MBER DEFAULT FND_LOG.LEVEL_STATEMENT);
279: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.TwoDNumberTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);_STATEMENT);
280: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsOriginTable, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
281: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsOriginTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);VEL_STATEMENT);
282: PROCEDURE write_this(
283: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable,

Line 280: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsOriginTable, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);

276: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
277: pForce IN boolean default false);
278: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.number_table, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);MBER DEFAULT FND_LOG.LEVEL_STATEMENT);
279: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.TwoDNumberTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);_STATEMENT);
280: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsOriginTable, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
281: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsOriginTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);VEL_STATEMENT);
282: PROCEDURE write_this(
283: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable,
284: ind IN NUMBER default null,

Line 281: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsOriginTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);VEL_STATEMENT);

277: pForce IN boolean default false);
278: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.number_table, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);MBER DEFAULT FND_LOG.LEVEL_STATEMENT);
279: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.TwoDNumberTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);_STATEMENT);
280: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsOriginTable, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
281: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsOriginTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);VEL_STATEMENT);
282: PROCEDURE write_this(
283: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable,
284: ind IN NUMBER default null,
285: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,

Line 283: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable,

279: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.TwoDNumberTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);_STATEMENT);
280: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsOriginTable, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
281: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsOriginTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);VEL_STATEMENT);
282: PROCEDURE write_this(
283: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable,
284: ind IN NUMBER default null,
285: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
286: pForce IN boolean default false);
287: PROCEDURE write_this(

Line 288: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable,

284: ind IN NUMBER default null,
285: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
286: pForce IN boolean default false);
287: PROCEDURE write_this(
288: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable,
289: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
290: pForce IN boolean default false,
291: pIgonoreProduction IN boolean default false);
292: PROCEDURE write_this(

Line 294: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField,

290: pForce IN boolean default false,
291: pIgonoreProduction IN boolean default false);
292: PROCEDURE write_this(
293: pTableName IN VARCHAR2, pFieldName IN VARCHAR2,
294: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField,
295: ind IN NUMBER default null,
296: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
297: pForce IN boolean default false);
298: PROCEDURE write_this(

Line 301: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField,

297: pForce IN boolean default false);
298: PROCEDURE write_this(
299: pTableName IN VARCHAR2,
300: pFieldName IN VARCHAR2,
301: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField,
302: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
303: pForce IN boolean default false);
304: PROCEDURE write_this(
305: pTableName IN VARCHAR2,

Line 306: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsUniqueField,

302: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
303: pForce IN boolean default false);
304: PROCEDURE write_this(
305: pTableName IN VARCHAR2,
306: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsUniqueField,
307: ind IN NUMBER default null,
308: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
309: pForce IN boolean default false);
310: PROCEDURE write_this(

Line 312: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField,

308: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
309: pForce IN boolean default false);
310: PROCEDURE write_this(
311: pTableName IN VARCHAR2,
312: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField,
313: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
314: pForce IN boolean default false);
315: PROCEDURE write_this(
316: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDBColumn,

Line 316: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDBColumn,

312: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField,
313: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
314: pForce IN boolean default false);
315: PROCEDURE write_this(
316: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDBColumn,
317: ind IN NUMBER default null,
318: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
319: pForce IN boolean default false);
320: PROCEDURE write_this(

Line 321: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDBColumn,

317: ind IN NUMBER default null,
318: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
319: pForce IN boolean default false);
320: PROCEDURE write_this(
321: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDBColumn,
322: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
323: pForce IN boolean default false);
324: PROCEDURE write_this(
325: pTable IN BSC_METADATA_OPTIMIZER_PKG.TNewITables,

Line 325: pTable IN BSC_METADATA_OPTIMIZER_PKG.TNewITables,

321: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDBColumn,
322: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
323: pForce IN boolean default false);
324: PROCEDURE write_this(
325: pTable IN BSC_METADATA_OPTIMIZER_PKG.TNewITables,
326: ind IN NUMBER default null,
327: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
328: pForce IN boolean default false);
329: PROCEDURE write_this(

Line 330: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_TNewITables,

326: ind IN NUMBER default null,
327: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
328: pForce IN boolean default false);
329: PROCEDURE write_this(
330: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_TNewITables,
331: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
332: pForce IN boolean default false);
333:
334: FUNCTION new_clsUniqueField return BSC_METADATA_OPTIMIZER_PKG.clsUniqueField;

Line 334: FUNCTION new_clsUniqueField return BSC_METADATA_OPTIMIZER_PKG.clsUniqueField;

330: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_TNewITables,
331: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
332: pForce IN boolean default false);
333:
334: FUNCTION new_clsUniqueField return BSC_METADATA_OPTIMIZER_PKG.clsUniqueField;
335: FUNCTION new_clsTable return BSC_METADATA_OPTIMIZER_PKG.clsTable;
336: FUNCTION new_clsDataField return BSC_METADATA_OPTIMIZER_PKG.clsDataField;
337: FUNCTION new_clsDisAggField return BSC_METADATA_OPTIMIZER_PKG.clsDisAggField;
338: FUNCTION new_clsKeyField return BSC_METADATA_OPTIMIZER_PKG.clsKeyField;

Line 335: FUNCTION new_clsTable return BSC_METADATA_OPTIMIZER_PKG.clsTable;

331: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
332: pForce IN boolean default false);
333:
334: FUNCTION new_clsUniqueField return BSC_METADATA_OPTIMIZER_PKG.clsUniqueField;
335: FUNCTION new_clsTable return BSC_METADATA_OPTIMIZER_PKG.clsTable;
336: FUNCTION new_clsDataField return BSC_METADATA_OPTIMIZER_PKG.clsDataField;
337: FUNCTION new_clsDisAggField return BSC_METADATA_OPTIMIZER_PKG.clsDisAggField;
338: FUNCTION new_clsKeyField return BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
339: FUNCTION new_clsOriginTable return BSC_METADATA_OPTIMIZER_PKG.clsOriginTable;

Line 336: FUNCTION new_clsDataField return BSC_METADATA_OPTIMIZER_PKG.clsDataField;

332: pForce IN boolean default false);
333:
334: FUNCTION new_clsUniqueField return BSC_METADATA_OPTIMIZER_PKG.clsUniqueField;
335: FUNCTION new_clsTable return BSC_METADATA_OPTIMIZER_PKG.clsTable;
336: FUNCTION new_clsDataField return BSC_METADATA_OPTIMIZER_PKG.clsDataField;
337: FUNCTION new_clsDisAggField return BSC_METADATA_OPTIMIZER_PKG.clsDisAggField;
338: FUNCTION new_clsKeyField return BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
339: FUNCTION new_clsOriginTable return BSC_METADATA_OPTIMIZER_PKG.clsOriginTable;
340: FUNCTION new_clsDBColumn return BSC_METADATA_OPTIMIZER_PKG.clsDBColumn;

Line 337: FUNCTION new_clsDisAggField return BSC_METADATA_OPTIMIZER_PKG.clsDisAggField;

333:
334: FUNCTION new_clsUniqueField return BSC_METADATA_OPTIMIZER_PKG.clsUniqueField;
335: FUNCTION new_clsTable return BSC_METADATA_OPTIMIZER_PKG.clsTable;
336: FUNCTION new_clsDataField return BSC_METADATA_OPTIMIZER_PKG.clsDataField;
337: FUNCTION new_clsDisAggField return BSC_METADATA_OPTIMIZER_PKG.clsDisAggField;
338: FUNCTION new_clsKeyField return BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
339: FUNCTION new_clsOriginTable return BSC_METADATA_OPTIMIZER_PKG.clsOriginTable;
340: FUNCTION new_clsDBColumn return BSC_METADATA_OPTIMIZER_PKG.clsDBColumn;
341: FUNCTION new_clsMeasureLOV return BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;

Line 338: FUNCTION new_clsKeyField return BSC_METADATA_OPTIMIZER_PKG.clsKeyField;

334: FUNCTION new_clsUniqueField return BSC_METADATA_OPTIMIZER_PKG.clsUniqueField;
335: FUNCTION new_clsTable return BSC_METADATA_OPTIMIZER_PKG.clsTable;
336: FUNCTION new_clsDataField return BSC_METADATA_OPTIMIZER_PKG.clsDataField;
337: FUNCTION new_clsDisAggField return BSC_METADATA_OPTIMIZER_PKG.clsDisAggField;
338: FUNCTION new_clsKeyField return BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
339: FUNCTION new_clsOriginTable return BSC_METADATA_OPTIMIZER_PKG.clsOriginTable;
340: FUNCTION new_clsDBColumn return BSC_METADATA_OPTIMIZER_PKG.clsDBColumn;
341: FUNCTION new_clsMeasureLOV return BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;
342: FUNCTION new_clsPeriodicity return BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity;

Line 339: FUNCTION new_clsOriginTable return BSC_METADATA_OPTIMIZER_PKG.clsOriginTable;

335: FUNCTION new_clsTable return BSC_METADATA_OPTIMIZER_PKG.clsTable;
336: FUNCTION new_clsDataField return BSC_METADATA_OPTIMIZER_PKG.clsDataField;
337: FUNCTION new_clsDisAggField return BSC_METADATA_OPTIMIZER_PKG.clsDisAggField;
338: FUNCTION new_clsKeyField return BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
339: FUNCTION new_clsOriginTable return BSC_METADATA_OPTIMIZER_PKG.clsOriginTable;
340: FUNCTION new_clsDBColumn return BSC_METADATA_OPTIMIZER_PKG.clsDBColumn;
341: FUNCTION new_clsMeasureLOV return BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;
342: FUNCTION new_clsPeriodicity return BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity;
343: FUNCTION new_clsCalendar return BSC_METADATA_OPTIMIZER_PKG.clsCalendar;

Line 340: FUNCTION new_clsDBColumn return BSC_METADATA_OPTIMIZER_PKG.clsDBColumn;

336: FUNCTION new_clsDataField return BSC_METADATA_OPTIMIZER_PKG.clsDataField;
337: FUNCTION new_clsDisAggField return BSC_METADATA_OPTIMIZER_PKG.clsDisAggField;
338: FUNCTION new_clsKeyField return BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
339: FUNCTION new_clsOriginTable return BSC_METADATA_OPTIMIZER_PKG.clsOriginTable;
340: FUNCTION new_clsDBColumn return BSC_METADATA_OPTIMIZER_PKG.clsDBColumn;
341: FUNCTION new_clsMeasureLOV return BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;
342: FUNCTION new_clsPeriodicity return BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity;
343: FUNCTION new_clsCalendar return BSC_METADATA_OPTIMIZER_PKG.clsCalendar;
344: FUNCTION new_clsMasterTable return BSC_METADATA_OPTIMIZER_PKG.clsMasterTable;

Line 341: FUNCTION new_clsMeasureLOV return BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;

337: FUNCTION new_clsDisAggField return BSC_METADATA_OPTIMIZER_PKG.clsDisAggField;
338: FUNCTION new_clsKeyField return BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
339: FUNCTION new_clsOriginTable return BSC_METADATA_OPTIMIZER_PKG.clsOriginTable;
340: FUNCTION new_clsDBColumn return BSC_METADATA_OPTIMIZER_PKG.clsDBColumn;
341: FUNCTION new_clsMeasureLOV return BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;
342: FUNCTION new_clsPeriodicity return BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity;
343: FUNCTION new_clsCalendar return BSC_METADATA_OPTIMIZER_PKG.clsCalendar;
344: FUNCTION new_clsMasterTable return BSC_METADATA_OPTIMIZER_PKG.clsMasterTable;
345: FUNCTION new_clsLevels return BSC_METADATA_OPTIMIZER_PKG.clsLevels;

Line 342: FUNCTION new_clsPeriodicity return BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity;

338: FUNCTION new_clsKeyField return BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
339: FUNCTION new_clsOriginTable return BSC_METADATA_OPTIMIZER_PKG.clsOriginTable;
340: FUNCTION new_clsDBColumn return BSC_METADATA_OPTIMIZER_PKG.clsDBColumn;
341: FUNCTION new_clsMeasureLOV return BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;
342: FUNCTION new_clsPeriodicity return BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity;
343: FUNCTION new_clsCalendar return BSC_METADATA_OPTIMIZER_PKG.clsCalendar;
344: FUNCTION new_clsMasterTable return BSC_METADATA_OPTIMIZER_PKG.clsMasterTable;
345: FUNCTION new_clsLevels return BSC_METADATA_OPTIMIZER_PKG.clsLevels;
346:

Line 343: FUNCTION new_clsCalendar return BSC_METADATA_OPTIMIZER_PKG.clsCalendar;

339: FUNCTION new_clsOriginTable return BSC_METADATA_OPTIMIZER_PKG.clsOriginTable;
340: FUNCTION new_clsDBColumn return BSC_METADATA_OPTIMIZER_PKG.clsDBColumn;
341: FUNCTION new_clsMeasureLOV return BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;
342: FUNCTION new_clsPeriodicity return BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity;
343: FUNCTION new_clsCalendar return BSC_METADATA_OPTIMIZER_PKG.clsCalendar;
344: FUNCTION new_clsMasterTable return BSC_METADATA_OPTIMIZER_PKG.clsMasterTable;
345: FUNCTION new_clsLevels return BSC_METADATA_OPTIMIZER_PKG.clsLevels;
346:
347: FUNCTION new_tabrec_clsLevels return BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels;

Line 344: FUNCTION new_clsMasterTable return BSC_METADATA_OPTIMIZER_PKG.clsMasterTable;

340: FUNCTION new_clsDBColumn return BSC_METADATA_OPTIMIZER_PKG.clsDBColumn;
341: FUNCTION new_clsMeasureLOV return BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;
342: FUNCTION new_clsPeriodicity return BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity;
343: FUNCTION new_clsCalendar return BSC_METADATA_OPTIMIZER_PKG.clsCalendar;
344: FUNCTION new_clsMasterTable return BSC_METADATA_OPTIMIZER_PKG.clsMasterTable;
345: FUNCTION new_clsLevels return BSC_METADATA_OPTIMIZER_PKG.clsLevels;
346:
347: FUNCTION new_tabrec_clsLevels return BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels;
348: FUNCTION new_clsBasicTable return BSC_METADATA_OPTIMIZER_PKG.clsBasicTable ;

Line 345: FUNCTION new_clsLevels return BSC_METADATA_OPTIMIZER_PKG.clsLevels;

341: FUNCTION new_clsMeasureLOV return BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;
342: FUNCTION new_clsPeriodicity return BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity;
343: FUNCTION new_clsCalendar return BSC_METADATA_OPTIMIZER_PKG.clsCalendar;
344: FUNCTION new_clsMasterTable return BSC_METADATA_OPTIMIZER_PKG.clsMasterTable;
345: FUNCTION new_clsLevels return BSC_METADATA_OPTIMIZER_PKG.clsLevels;
346:
347: FUNCTION new_tabrec_clsLevels return BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels;
348: FUNCTION new_clsBasicTable return BSC_METADATA_OPTIMIZER_PKG.clsBasicTable ;
349: FUNCTION new_clsLevelCombinations return BSC_METADATA_OPTIMIZER_PKG.clsLevelCombinations;

Line 347: FUNCTION new_tabrec_clsLevels return BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels;

343: FUNCTION new_clsCalendar return BSC_METADATA_OPTIMIZER_PKG.clsCalendar;
344: FUNCTION new_clsMasterTable return BSC_METADATA_OPTIMIZER_PKG.clsMasterTable;
345: FUNCTION new_clsLevels return BSC_METADATA_OPTIMIZER_PKG.clsLevels;
346:
347: FUNCTION new_tabrec_clsLevels return BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels;
348: FUNCTION new_clsBasicTable return BSC_METADATA_OPTIMIZER_PKG.clsBasicTable ;
349: FUNCTION new_clsLevelCombinations return BSC_METADATA_OPTIMIZER_PKG.clsLevelCombinations;
350: FUNCTION new_TNewITables return BSC_METADATA_OPTIMIZER_PKG.TNewITables;
351:

Line 348: FUNCTION new_clsBasicTable return BSC_METADATA_OPTIMIZER_PKG.clsBasicTable ;

344: FUNCTION new_clsMasterTable return BSC_METADATA_OPTIMIZER_PKG.clsMasterTable;
345: FUNCTION new_clsLevels return BSC_METADATA_OPTIMIZER_PKG.clsLevels;
346:
347: FUNCTION new_tabrec_clsLevels return BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels;
348: FUNCTION new_clsBasicTable return BSC_METADATA_OPTIMIZER_PKG.clsBasicTable ;
349: FUNCTION new_clsLevelCombinations return BSC_METADATA_OPTIMIZER_PKG.clsLevelCombinations;
350: FUNCTION new_TNewITables return BSC_METADATA_OPTIMIZER_PKG.TNewITables;
351:
352: /*FUNCTION new_ return BSC_METADATA_OPTIMIZER_PKG.;

Line 349: FUNCTION new_clsLevelCombinations return BSC_METADATA_OPTIMIZER_PKG.clsLevelCombinations;

345: FUNCTION new_clsLevels return BSC_METADATA_OPTIMIZER_PKG.clsLevels;
346:
347: FUNCTION new_tabrec_clsLevels return BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels;
348: FUNCTION new_clsBasicTable return BSC_METADATA_OPTIMIZER_PKG.clsBasicTable ;
349: FUNCTION new_clsLevelCombinations return BSC_METADATA_OPTIMIZER_PKG.clsLevelCombinations;
350: FUNCTION new_TNewITables return BSC_METADATA_OPTIMIZER_PKG.TNewITables;
351:
352: /*FUNCTION new_ return BSC_METADATA_OPTIMIZER_PKG.;
353: FUNCTION new_ return ;*/

Line 350: FUNCTION new_TNewITables return BSC_METADATA_OPTIMIZER_PKG.TNewITables;

346:
347: FUNCTION new_tabrec_clsLevels return BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels;
348: FUNCTION new_clsBasicTable return BSC_METADATA_OPTIMIZER_PKG.clsBasicTable ;
349: FUNCTION new_clsLevelCombinations return BSC_METADATA_OPTIMIZER_PKG.clsLevelCombinations;
350: FUNCTION new_TNewITables return BSC_METADATA_OPTIMIZER_PKG.TNewITables;
351:
352: /*FUNCTION new_ return BSC_METADATA_OPTIMIZER_PKG.;
353: FUNCTION new_ return ;*/
354:

Line 352: /*FUNCTION new_ return BSC_METADATA_OPTIMIZER_PKG.;

348: FUNCTION new_clsBasicTable return BSC_METADATA_OPTIMIZER_PKG.clsBasicTable ;
349: FUNCTION new_clsLevelCombinations return BSC_METADATA_OPTIMIZER_PKG.clsLevelCombinations;
350: FUNCTION new_TNewITables return BSC_METADATA_OPTIMIZER_PKG.TNewITables;
351:
352: /*FUNCTION new_ return BSC_METADATA_OPTIMIZER_PKG.;
353: FUNCTION new_ return ;*/
354:
355:
356: FUNCTION get_tab_clsLevels (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;

Line 356: FUNCTION get_tab_clsLevels (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;

352: /*FUNCTION new_ return BSC_METADATA_OPTIMIZER_PKG.;
353: FUNCTION new_ return ;*/
354:
355:
356: FUNCTION get_tab_clsLevels (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
357: FUNCTION get_tab_clsLevelCombinations (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations;
358:
359: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) RETURN DBMS_SQL.NUMBER_TABLE ;
360: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations) RETURN DBMS_SQL.NUMBER_TABLE;

Line 357: FUNCTION get_tab_clsLevelCombinations (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations;

353: FUNCTION new_ return ;*/
354:
355:
356: FUNCTION get_tab_clsLevels (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
357: FUNCTION get_tab_clsLevelCombinations (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations;
358:
359: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) RETURN DBMS_SQL.NUMBER_TABLE ;
360: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations) RETURN DBMS_SQL.NUMBER_TABLE;
361:

Line 359: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) RETURN DBMS_SQL.NUMBER_TABLE ;

355:
356: FUNCTION get_tab_clsLevels (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
357: FUNCTION get_tab_clsLevelCombinations (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations;
358:
359: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) RETURN DBMS_SQL.NUMBER_TABLE ;
360: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations) RETURN DBMS_SQL.NUMBER_TABLE;
361:
362:
363: /*PROCEDURE insertBasicTable( pTable BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,

Line 360: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations) RETURN DBMS_SQL.NUMBER_TABLE;

356: FUNCTION get_tab_clsLevels (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
357: FUNCTION get_tab_clsLevelCombinations (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations;
358:
359: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) RETURN DBMS_SQL.NUMBER_TABLE ;
360: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations) RETURN DBMS_SQL.NUMBER_TABLE;
361:
362:
363: /*PROCEDURE insertBasicTable( pTable BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,
364: pKeys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,

Line 363: /*PROCEDURE insertBasicTable( pTable BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,

359: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) RETURN DBMS_SQL.NUMBER_TABLE ;
360: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations) RETURN DBMS_SQL.NUMBER_TABLE;
361:
362:
363: /*PROCEDURE insertBasicTable( pTable BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,
364: pKeys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
365: pData BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
366: */
367:

Line 364: pKeys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,

360: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations) RETURN DBMS_SQL.NUMBER_TABLE;
361:
362:
363: /*PROCEDURE insertBasicTable( pTable BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,
364: pKeys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
365: pData BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
366: */
367:
368: FUNCTION consolidateString (pTable IN DBMS_SQL.VARCHAR2_TABLE, pSeparator IN VARCHAR2) RETURN VARCHAR2;

Line 365: pData BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);

361:
362:
363: /*PROCEDURE insertBasicTable( pTable BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,
364: pKeys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
365: pData BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
366: */
367:
368: FUNCTION consolidateString (pTable IN DBMS_SQL.VARCHAR2_TABLE, pSeparator IN VARCHAR2) RETURN VARCHAR2;
369:

Line 374: pInput IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,

370: FUNCTION getDecomposedString(p_string IN VARCHAR2, p_separator IN VARCHAR2) RETURN
371: DBMS_SQL.VARCHAR2_TABLE ;
372:
373: PROCEDURE add_tabrec_clsLevels(
374: pInput IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
375: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,
376: l_group_id IN NUMBER) ;
377: PROCEDURE add_tabrec_clsLevelComb(
378: pInput IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations,

Line 375: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,

371: DBMS_SQL.VARCHAR2_TABLE ;
372:
373: PROCEDURE add_tabrec_clsLevels(
374: pInput IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
375: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,
376: l_group_id IN NUMBER) ;
377: PROCEDURE add_tabrec_clsLevelComb(
378: pInput IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations,
379: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations,

Line 378: pInput IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations,

374: pInput IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
375: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,
376: l_group_id IN NUMBER) ;
377: PROCEDURE add_tabrec_clsLevelComb(
378: pInput IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations,
379: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations,
380: l_group_id IN NUMBER) ;
381:
382:

Line 379: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations,

375: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,
376: l_group_id IN NUMBER) ;
377: PROCEDURE add_tabrec_clsLevelComb(
378: pInput IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations,
379: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations,
380: l_group_id IN NUMBER) ;
381:
382:
383: --PROCEDURE insertKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);

Line 383: --PROCEDURE insertKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);

379: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations,
380: l_group_id IN NUMBER) ;
381:
382:
383: --PROCEDURE insertKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);
384: --PROCEDURE updateKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;
385: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
386: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
387:

Line 384: --PROCEDURE updateKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;

380: l_group_id IN NUMBER) ;
381:
382:
383: --PROCEDURE insertKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);
384: --PROCEDURE updateKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;
385: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
386: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
387:
388: --FUNCTION getAllKeyFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;

Line 385: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);

381:
382:
383: --PROCEDURE insertKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);
384: --PROCEDURE updateKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;
385: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
386: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
387:
388: --FUNCTION getAllKeyFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
389: --FUNCTION getOneKeyField(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;

Line 386: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;

382:
383: --PROCEDURE insertKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);
384: --PROCEDURE updateKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;
385: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
386: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
387:
388: --FUNCTION getAllKeyFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
389: --FUNCTION getOneKeyField(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
390:

Line 388: --FUNCTION getAllKeyFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;

384: --PROCEDURE updateKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;
385: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
386: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
387:
388: --FUNCTION getAllKeyFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
389: --FUNCTION getOneKeyField(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
390:
391: --FUNCTION getAllDataFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
392: --FUNCTION getOneDataField(table_name IN VARCHAR2, field_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsDataField;

Line 389: --FUNCTION getOneKeyField(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;

385: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
386: --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
387:
388: --FUNCTION getAllKeyFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
389: --FUNCTION getOneKeyField(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
390:
391: --FUNCTION getAllDataFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
392: --FUNCTION getOneDataField(table_name IN VARCHAR2, field_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsDataField;
393:

Line 391: --FUNCTION getAllDataFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;

387:
388: --FUNCTION getAllKeyFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
389: --FUNCTION getOneKeyField(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
390:
391: --FUNCTION getAllDataFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
392: --FUNCTION getOneDataField(table_name IN VARCHAR2, field_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsDataField;
393:
394:
395: /* new */

Line 392: --FUNCTION getOneDataField(table_name IN VARCHAR2, field_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsDataField;

388: --FUNCTION getAllKeyFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
389: --FUNCTION getOneKeyField(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
390:
391: --FUNCTION getAllDataFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
392: --FUNCTION getOneDataField(table_name IN VARCHAR2, field_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsDataField;
393:
394:
395: /* new */
396: /*

Line 397: PROCEDURE insertKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);

393:
394:
395: /* new */
396: /*
397: PROCEDURE insertKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);
398: PROCEDURE updateKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;
399: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pDataFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
400: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
401: PROCEDURE insertSingleKey_pls(pTableName IN VARCHAR2, pKeyField IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField) ;

Line 398: PROCEDURE updateKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;

394:
395: /* new */
396: /*
397: PROCEDURE insertKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);
398: PROCEDURE updateKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;
399: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pDataFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
400: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
401: PROCEDURE insertSingleKey_pls(pTableName IN VARCHAR2, pKeyField IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField) ;
402:

Line 399: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pDataFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);

395: /* new */
396: /*
397: PROCEDURE insertKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);
398: PROCEDURE updateKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;
399: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pDataFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
400: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
401: PROCEDURE insertSingleKey_pls(pTableName IN VARCHAR2, pKeyField IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField) ;
402:
403: FUNCTION getAllKeyFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;

Line 400: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;

396: /*
397: PROCEDURE insertKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);
398: PROCEDURE updateKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;
399: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pDataFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
400: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
401: PROCEDURE insertSingleKey_pls(pTableName IN VARCHAR2, pKeyField IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField) ;
402:
403: FUNCTION getAllKeyFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
404: FUNCTION getOneKeyField_pls(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;

Line 401: PROCEDURE insertSingleKey_pls(pTableName IN VARCHAR2, pKeyField IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField) ;

397: PROCEDURE insertKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);
398: PROCEDURE updateKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;
399: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pDataFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
400: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
401: PROCEDURE insertSingleKey_pls(pTableName IN VARCHAR2, pKeyField IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField) ;
402:
403: FUNCTION getAllKeyFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
404: FUNCTION getOneKeyField_pls(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
405:

Line 403: FUNCTION getAllKeyFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;

399: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pDataFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
400: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
401: PROCEDURE insertSingleKey_pls(pTableName IN VARCHAR2, pKeyField IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField) ;
402:
403: FUNCTION getAllKeyFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
404: FUNCTION getOneKeyField_pls(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
405:
406: FUNCTION getAllDataFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
407: FUNCTION getOneDataField_pls(table_name IN VARCHAR2, field_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsDataField;

Line 404: FUNCTION getOneKeyField_pls(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;

400: PROCEDURE insertData_pls(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
401: PROCEDURE insertSingleKey_pls(pTableName IN VARCHAR2, pKeyField IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField) ;
402:
403: FUNCTION getAllKeyFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
404: FUNCTION getOneKeyField_pls(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
405:
406: FUNCTION getAllDataFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
407: FUNCTION getOneDataField_pls(table_name IN VARCHAR2, field_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsDataField;
408: */

Line 406: FUNCTION getAllDataFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;

402:
403: FUNCTION getAllKeyFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
404: FUNCTION getOneKeyField_pls(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
405:
406: FUNCTION getAllDataFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
407: FUNCTION getOneDataField_pls(table_name IN VARCHAR2, field_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsDataField;
408: */
409:
410:

Line 407: FUNCTION getOneDataField_pls(table_name IN VARCHAR2, field_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsDataField;

403: FUNCTION getAllKeyFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
404: FUNCTION getOneKeyField_pls(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
405:
406: FUNCTION getAllDataFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
407: FUNCTION getOneDataField_pls(table_name IN VARCHAR2, field_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsDataField;
408: */
409:
410:
411: /* Field disaggs*/

Line 412: --FUNCTION getDisaggs(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField;

408: */
409:
410:
411: /* Field disaggs*/
412: --FUNCTION getDisaggs(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField;
413: --PROCEDURE insertDisAggs(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAggs IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField, pFieldType IN NUMBER default 1) ;
414: --PROCEDURE insertOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1) ;
415: --PROCEDURE updateOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1);
416:

Line 413: --PROCEDURE insertDisAggs(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAggs IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField, pFieldType IN NUMBER default 1) ;

409:
410:
411: /* Field disaggs*/
412: --FUNCTION getDisaggs(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField;
413: --PROCEDURE insertDisAggs(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAggs IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField, pFieldType IN NUMBER default 1) ;
414: --PROCEDURE insertOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1) ;
415: --PROCEDURE updateOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1);
416:
417: /* Field disagg keys*/

Line 414: --PROCEDURE insertOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1) ;

410:
411: /* Field disaggs*/
412: --FUNCTION getDisaggs(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField;
413: --PROCEDURE insertDisAggs(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAggs IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField, pFieldType IN NUMBER default 1) ;
414: --PROCEDURE insertOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1) ;
415: --PROCEDURE updateOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1);
416:
417: /* Field disagg keys*/
418: --FUNCTION getDisaggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;

Line 415: --PROCEDURE updateOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1);

411: /* Field disaggs*/
412: --FUNCTION getDisaggs(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField;
413: --PROCEDURE insertDisAggs(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAggs IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField, pFieldType IN NUMBER default 1) ;
414: --PROCEDURE insertOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1) ;
415: --PROCEDURE updateOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1);
416:
417: /* Field disagg keys*/
418: --FUNCTION getDisaggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
419: --PROCEDURE insertDisAggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, pFieldType IN NUMBER default 1) ;

Line 418: --FUNCTION getDisaggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;

414: --PROCEDURE insertOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1) ;
415: --PROCEDURE updateOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1);
416:
417: /* Field disagg keys*/
418: --FUNCTION getDisaggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
419: --PROCEDURE insertDisAggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, pFieldType IN NUMBER default 1) ;
420: --PROCEDURE insertOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);
421: --PROCEDURE updateOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);
422:

Line 419: --PROCEDURE insertDisAggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, pFieldType IN NUMBER default 1) ;

415: --PROCEDURE updateOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1);
416:
417: /* Field disagg keys*/
418: --FUNCTION getDisaggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
419: --PROCEDURE insertDisAggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, pFieldType IN NUMBER default 1) ;
420: --PROCEDURE insertOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);
421: --PROCEDURE updateOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);
422:
423:

Line 420: --PROCEDURE insertOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);

416:
417: /* Field disagg keys*/
418: --FUNCTION getDisaggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
419: --PROCEDURE insertDisAggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, pFieldType IN NUMBER default 1) ;
420: --PROCEDURE insertOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);
421: --PROCEDURE updateOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);
422:
423:
424: PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable, proc IN VARCHAR2) ;

Line 421: --PROCEDURE updateOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);

417: /* Field disagg keys*/
418: --FUNCTION getDisaggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
419: --PROCEDURE insertDisAggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, pFieldType IN NUMBER default 1) ;
420: --PROCEDURE insertOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);
421: --PROCEDURE updateOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);
422:
423:
424: PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable, proc IN VARCHAR2) ;
425:

Line 424: PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable, proc IN VARCHAR2) ;

420: --PROCEDURE insertOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);
421: --PROCEDURE updateOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);
422:
423:
424: PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable, proc IN VARCHAR2) ;
425:
426:
427: PROCEDURE terminateWithError(pErrorShortName IN VARCHAR2, pAPI in varchar2 default null);
428: PROCEDURE terminateWithMsg(pMessage IN VARCHAR2, pAPI in varchar2 default null);

Line 445: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField, ind IN NUMBER default null,

441:
442: PROCEDURE InsertRelatedTables(arrTables in dbms_Sql.varchar2_table, numTables in number) ;
443:
444:
445: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField, ind IN NUMBER default null,
446: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false) ;
447: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, ind IN NUMBER default null,
448: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false) ;
449:

Line 447: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, ind IN NUMBER default null,

443:
444:
445: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField, ind IN NUMBER default null,
446: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false) ;
447: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, ind IN NUMBER default null,
448: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false) ;
449:
450: FUNCTION find_objectives_for_table(p_table IN VARCHAR2) return BSC_METADATA_OPTIMIZER_PKG.tab_clsKPIDimSet;
451: PROCEDURE CreateKPIDataTableTmp ;

Line 450: FUNCTION find_objectives_for_table(p_table IN VARCHAR2) return BSC_METADATA_OPTIMIZER_PKG.tab_clsKPIDimSet;

446: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false) ;
447: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, ind IN NUMBER default null,
448: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false) ;
449:
450: FUNCTION find_objectives_for_table(p_table IN VARCHAR2) return BSC_METADATA_OPTIMIZER_PKG.tab_clsKPIDimSet;
451: PROCEDURE CreateKPIDataTableTmp ;
452: PROCEDURE CreateDBMeasureByDimSetTmp ;
453: FUNCTION filters_exist(p_kpi_number IN NUMBER, p_dim_set_id IN NUMBER, p_column_name IN VARCHAR2, p_filter_view OUT NOCOPY VARCHAR2) return boolean;
454: PROCEDURE dump_stack;