1 Package BSC_MO_UI_PKG AS
2 /* $Header: BSCMOUIS.pls 120.3 2006/08/04 13:09:54 amitgupt noship $ */
3 G_PKG_NAME VARCHAR2(30) := 'BSC_MO_UI_PKG';
4 TYPE CurTyp IS REF CURSOR;
5
6 --pMode = 'ALL' or 'INCREMENTAL'
7 --PROCEDURE updateRelatedIndicatorsNew(pMode IN VARCHAR2);
8 PROCEDURE RenameInputTable(pOld IN VARCHAR2, pNew IN VARCHAR2, pStatus OUT NOCOPY VARCHAR2, pMessage OUT NOCOPY VARCHAR2) ;
9 PROCEDURE updateRelatedIndicators(pMode IN VARCHAR2, pProcessId IN NUMBER);
10 PROCEDURE GetLevelsForIndicator(pIndicator IN NUMBER) ; --RETURN tab_clsIndicatorLevels;
11 FUNCTION GetDescriptionForColumn(pTableName IN VARCHAR2, pColumnName IN VARCHAR2) RETURN VARCHAR2;
12 PROCEDURE launchOptimizer(pMode IN VARCHAR2, pRequestId OUT NOCOPY NUMBER, pStatus OUT NOCOPY VARCHAR2, pMessage OUT NOCOPY VARCHAR2);
13 PROCEDURE truncateTable(pTableName IN VARCHAR2, pSchema IN VARCHAR2 DEFAULT null);
14 FUNCTION getColDetails(pColType IN VARCHAR2, pTableName IN VARCHAR2, pTabType IN VARCHAR2) return CLOB ;
15 PROCEDURE getRelatedIndicators(pKPIList IN VARCHAR2, pProcessId IN NUMBER);
16 PROCEDURE deleteBSCSession(pSession IN NUMBER);
17 PROCEDURE CreateDBMeasureByKpiView;
18 PROCEDURE cleanUITempTable;
19 PROCEDURE checkSystemLock(p_all_objectives IN NUMBER, p_program_id IN NUMBER, p_user_id IN NUMBER, p_process_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, x_msg_data OUT NOCOPY VARCHAR2);
20 PROCEDURE getSystemLock(p_all_objectives IN NUMBER, p_query_time IN DATE, p_program_id IN NUMBER, p_user_id IN NUMBER, p_process_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, x_msg_data OUT NOCOPY VARCHAR2);
21
22 END BSC_MO_UI_PKG;
[Home] [Help]