DBA Data[Home] [Help]

APPS.PA_OLAP_PVT dependencies on DBMS_CUBE

Line 177: DBMS_CUBE.BUILD('

173: as
174:
175: begin
176:
177: DBMS_CUBE.BUILD('
178: "PA_CALENDAR_TYPE" USING (LOAD NO SYNCH, COMPILE SORT),
179: "PA_CBS_ELEMENTS_DM" USING (LOAD NO SYNCH, COMPILE SORT),
180: "PA_CBS_VERSIONS_DM" USING (LOAD NO SYNCH, COMPILE SORT),
181: "PA_CURRENCY_DM" USING (LOAD NO SYNCH, COMPILE SORT),

Line 199: dbms_cube_log.table_create(dbms_cube_log.type_build);

195: begin
196:
197:
198: /*
199: dbms_cube_log.table_create(dbms_cube_log.type_build);
200: dbms_cube_log.table_create(dbms_cube_log.type_operations);
201: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
202: */
203:

Line 200: dbms_cube_log.table_create(dbms_cube_log.type_operations);

196:
197:
198: /*
199: dbms_cube_log.table_create(dbms_cube_log.type_build);
200: dbms_cube_log.table_create(dbms_cube_log.type_operations);
201: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
202: */
203:
204: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL ,SOLVE PARALLEL)',

Line 201: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);

197:
198: /*
199: dbms_cube_log.table_create(dbms_cube_log.type_build);
200: dbms_cube_log.table_create(dbms_cube_log.type_operations);
201: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
202: */
203:
204: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL ,SOLVE PARALLEL)',
205: 'S', -- FAST SOLVE (incremental solve)

Line 204: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL ,SOLVE PARALLEL)',

200: dbms_cube_log.table_create(dbms_cube_log.type_operations);
201: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
202: */
203:
204: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL ,SOLVE PARALLEL)',
205: 'S', -- FAST SOLVE (incremental solve)
206: false, -- refresh after errors
207: 6, -- parallelism
208: true, -- atomic refresh

Line 212: DBMS_CUBE.BUILD('PA_AC_ACTUAL_CUBE USING (LOAD PARALLEL ,SOLVE PARALLEL)',

208: true, -- atomic refresh
209: true, -- automatic order
210: false); -- add dimensions
211:
212: DBMS_CUBE.BUILD('PA_AC_ACTUAL_CUBE USING (LOAD PARALLEL ,SOLVE PARALLEL)',
213: 'S', -- FAST SOLVE (incremental solve)
214: false, -- refresh after errors
215: 6, -- parallelism
216: true, -- atomic refresh

Line 232: dbms_cube_log.table_create(dbms_cube_log.type_build);

228: begin
229:
230:
231: /*
232: dbms_cube_log.table_create(dbms_cube_log.type_build);
233: dbms_cube_log.table_create(dbms_cube_log.type_operations);
234: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
235: */
236:

Line 233: dbms_cube_log.table_create(dbms_cube_log.type_operations);

229:
230:
231: /*
232: dbms_cube_log.table_create(dbms_cube_log.type_build);
233: dbms_cube_log.table_create(dbms_cube_log.type_operations);
234: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
235: */
236:
237: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL,SOLVE PARALLEL)',

Line 234: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);

230:
231: /*
232: dbms_cube_log.table_create(dbms_cube_log.type_build);
233: dbms_cube_log.table_create(dbms_cube_log.type_operations);
234: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
235: */
236:
237: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL,SOLVE PARALLEL)',
238: 'C', -- COMPLETE refresh

Line 237: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL,SOLVE PARALLEL)',

233: dbms_cube_log.table_create(dbms_cube_log.type_operations);
234: dbms_cube_log.enable(dbms_cube_log.TYPE_OPERATIONS, dbms_cube_log.TARGET_TABLE, dbms_cube_log.LEVEL_MEDIUM);
235: */
236:
237: DBMS_CUBE.BUILD('PA_PLAN_ACTUALS_CUBE USING (LOAD PARALLEL,SOLVE PARALLEL)',
238: 'C', -- COMPLETE refresh
239: false, -- refresh after errors
240: 7, -- parallelism
241: true, -- atomic refresh

Line 246: DBMS_CUBE.BUILD('PA_AC_ACTUAL_CUBE USING (LOAD PARALLEL,SOLVE PARALLEL)',

242: true, -- automatic order
243: false); -- add dimensions
244:
245:
246: DBMS_CUBE.BUILD('PA_AC_ACTUAL_CUBE USING (LOAD PARALLEL,SOLVE PARALLEL)',
247: 'C', -- COMPLETE refresh
248: false, -- refresh after errors
249: 7, -- parallelism
250: true, -- atomic refresh

Line 270: dbms_cube.import_xml( to_clob(

266: where aw_name = 'PA_PPR_AW';
267:
268: if ( aw_count > 0 ) then
269:
270: dbms_cube.import_xml( to_clob(
271: '
272:
273:
274:

Line 4401: dbms_cube.import_xml(v_xml_clob);

4397:
4398:
4399: dbms_lob.close(v_xml_clob);
4400: --dbms_output.put_line(v_xml_clob);
4401: dbms_cube.import_xml(v_xml_clob);
4402:
4403: end ;
4404:
4405: end PA_olap_PVT;