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:
127: PROCEDURE write_this (pTable IN DBMS_SQL.VARCHAR2_TABLE,
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,
129: 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,
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);
127: PROCEDURE write_this (pTable IN DBMS_SQL.VARCHAR2_TABLE,
128: 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);
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,
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,
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,
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);
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(
142: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable,
143: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
147: ind IN NUMBER default null,
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(
151: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsRelationMN,
152: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
156: ind IN NUMBER default null,
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(
160: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator,
161: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
165: ind IN NUMBER default null,
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(
169: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity ,
170: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
174: ind IN NUMBER default null,
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(
178: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicPeriodicity ,
179: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
183: ind IN NUMBER default null,
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(
187: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsCalendar,
188: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
192: ind IN NUMBER default null,
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(
196: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsOldBTables,
197: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
201: ind IN NUMBER default null,
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(
205: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV,
206: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
210: ind IN NUMBER default null,
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(
214: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,
215: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
219: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
223: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
227: ind IN NUMBER default null,
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(
231: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations,
232: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
236: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
240: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
244: ind IN NUMBER default null,
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(
248: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
249: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
253: ind IN NUMBER default null,
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(
257: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,
258: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
262: ind IN NUMBER default null,
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(
266: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable,
267: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
271: ind IN NUMBER default null,
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(
275: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_string,
276: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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);
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);
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(
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,
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,
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,
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(
288: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable,
289: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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(
293: pTableName IN VARCHAR2, pFieldName IN VARCHAR2,
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(
299: pTableName IN VARCHAR2,
300: pFieldName IN VARCHAR2,
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,
306: pTable IN BSC_METADATA_OPTIMIZER_PKG.clsUniqueField,
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(
311: pTableName IN VARCHAR2,
312: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField,
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,
317: ind IN NUMBER default null,
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(
321: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDBColumn,
322: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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,
326: ind IN NUMBER default null,
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(
330: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_TNewITables,
331: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
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;
335: FUNCTION new_clsTable return BSC_METADATA_OPTIMIZER_PKG.clsTable;
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:
450: FUNCTION find_objectives_for_table(p_table IN VARCHAR2) return BSC_METADATA_OPTIMIZER_PKG.tab_clsKPIDimSet;
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 ;
452: PROCEDURE CreateDBMeasureByDimSetTmp ;