APPS.BSC_MO_UI_PKG dependencies on BSC_DBGEN_UTILS

Line 336: IF (NOT BSC_DBGEN_UTILS.IS_TMP_TABLE_EXISTED('BSC_TMP_OPT_KPI_DATA')) THEN

332: --Procedure added for bug 3911548
333: procedure create_tmp_opt_kpi_data is
334: l_stmt varchar2(1000);
335: begin
336: IF (NOT BSC_DBGEN_UTILS.IS_TMP_TABLE_EXISTED('BSC_TMP_OPT_KPI_DATA')) THEN
337: begin
338: bsc_mo_helper_pkg.dropTable('BSC_TMP_OPT_KPI_DATA');
339: exception when others then
340: null;

Line 469: WHERE BSC_DBGEN_UTILS.GET_OBJECTIVE_TYPE(SHORT_NAME) = :2 ';

465: if (pMode = 'ALL') THEN
466: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
467: SELECT INDICATOR, prototype_flag, :1
468: FROM BSC_KPIS_VL
469: WHERE BSC_DBGEN_UTILS.GET_OBJECTIVE_TYPE(SHORT_NAME) = :2 ';
470: execute immediate l_stmt USING pProcessId, 'OBJECTIVE';
471: commit;
472: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
473: BSC_MO_HELPER_PKG.writeTmp( 'Completed updateRelatedIndicators');

Line 585: and BSC_DBGEN_UTILS.get_objective_type(kpis.short_name) <> ''OBJECTIVE'') ';

581: where process_id = :1
582: and indicator in
583: (select indicator from bsc_kpis_vl kpis
584: where kpis.short_name is not null
585: and BSC_DBGEN_UTILS.get_objective_type(kpis.short_name) <> ''OBJECTIVE'') ';
586: execute immediate l_stmt USING pProcessId;
587: END IF;
588: commit;
589: