APPS.BSC_MO_HELPER_PKG dependencies on BSC_SYS_INIT

Line 3573: -- Read the given variable from BSC_SYS_INIT

3569:
3570: --****************************************************************************
3571: -- Inic: getInitColumn
3572: -- DESCRIPTION:
3573: -- Read the given variable from BSC_SYS_INIT
3574: --
3575: -- PARAMETERS:
3576: -- Variable: variable name
3577: --****************************************************************************

Line 3585: l_stmt := 'SELECT PROPERTY_VALUE FROM BSC_SYS_INIT WHERE UPPER(PROPERTY_CODE) = :1';

3581: l_value varchar2(300);
3582: cv CurTyp;
3583: l_error VARCHAR2(400);
3584: BEGIN
3585: l_stmt := 'SELECT PROPERTY_VALUE FROM BSC_SYS_INIT WHERE UPPER(PROPERTY_CODE) = :1';
3586: open cv for l_stmt using p_column;
3587: FETCH cv into l_value;
3588: CLOSE cv;
3589: return l_value;

Line 5813: -- Write the given variable in BSC_SYS_INIT table.

5809: --****************************************************************************
5810: -- EscribirInic : WriteInitTable
5811: --
5812: -- DESCRIPTION:
5813: -- Write the given variable in BSC_SYS_INIT table.
5814: -- PARAMETERS:
5815: -- Variable: variable name
5816: -- Valor: value
5817: -- db_obj: database

Line 5825: SELECT Count(1) INTO l_count FROM BSC_SYS_INIT

5821: l_count NUMBER;
5822: BEGIN
5823:
5824: IF propertyValue IS NOT NULL THEN
5825: SELECT Count(1) INTO l_count FROM BSC_SYS_INIT
5826: WHERE UPPER(PROPERTY_CODE) = UPPER(propertyCode);
5827:
5828: IF l_count > 0 THEN
5829: UPDATE BSC_SYS_INIT SET PROPERTY_VALUE = propertyValue, LAST_UPDATED_BY = BSC_METADATA_OPTIMIZER_PKG.gUserID, LAST_UPDATE_DATE = SYSDATE

Line 5829: UPDATE BSC_SYS_INIT SET PROPERTY_VALUE = propertyValue, LAST_UPDATED_BY = BSC_METADATA_OPTIMIZER_PKG.gUserID, LAST_UPDATE_DATE = SYSDATE

5825: SELECT Count(1) INTO l_count FROM BSC_SYS_INIT
5826: WHERE UPPER(PROPERTY_CODE) = UPPER(propertyCode);
5827:
5828: IF l_count > 0 THEN
5829: UPDATE BSC_SYS_INIT SET PROPERTY_VALUE = propertyValue, LAST_UPDATED_BY = BSC_METADATA_OPTIMIZER_PKG.gUserID, LAST_UPDATE_DATE = SYSDATE
5830: WHERE UPPER(PROPERTY_CODE) = UPPER(propertyCode);
5831: --Execute IMMEDIATE l_stmt using propertyValue, BSC_METADATA_OPTIMIZER_PKG.gUserID, UPPER(propertyCode);
5832: Else
5833: INSERT INTO BSC_SYS_INIT (PROPERTY_CODE, PROPERTY_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 5833: INSERT INTO BSC_SYS_INIT (PROPERTY_CODE, PROPERTY_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

5829: UPDATE BSC_SYS_INIT SET PROPERTY_VALUE = propertyValue, LAST_UPDATED_BY = BSC_METADATA_OPTIMIZER_PKG.gUserID, LAST_UPDATE_DATE = SYSDATE
5830: WHERE UPPER(PROPERTY_CODE) = UPPER(propertyCode);
5831: --Execute IMMEDIATE l_stmt using propertyValue, BSC_METADATA_OPTIMIZER_PKG.gUserID, UPPER(propertyCode);
5832: Else
5833: INSERT INTO BSC_SYS_INIT (PROPERTY_CODE, PROPERTY_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
5834: VALUES(propertyCode, propertyValue, BSC_METADATA_OPTIMIZER_PKG.gUserID, SYSDATE, BSC_METADATA_OPTIMIZER_PKG.gUserID, SYSDATE);
5835: End IF;
5836: End IF;
5837: End;

Line 5993: --Update BSC_SYS_INIT

5989: l_index1 := BSC_METADATA_OPTIMIZER_PKG.gIndicators.next(l_index1);
5990: END LOOP;
5991: End IF;
5992:
5993: --Update BSC_SYS_INIT
5994: WriteInitTable( 'UPDATE_DATE', to_char(sysdate, 'dd/mm/yyyy'));
5995:
5996: --TerminarPorError (Get_Message('BSC_TABLES_INIT_FAILED'))
5997: End ;

Line 6650: --BSC-MV Note: Store new summarization level into BSC_SYS_INIT

6646: AND INDICATOR IN (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = BSC_METADATA_OPTIMIZER_PKG.g_processID);*/
6647:
6648: WriteInitTable('SYSTEM_STAGE', '2');
6649:
6650: --BSC-MV Note: Store new summarization level into BSC_SYS_INIT
6651: If BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV Then
6652: WriteInitTable('ADV_SUM_LEVEL', BSC_METADATA_OPTIMIZER_PKG.g_Adv_Summarization_Level);
6653: End If;
6654: