eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_UTILITY dependencies on BSC_UTILITY

Line 1: PACKAGE BODY BSC_UTILITY AS

1: PACKAGE BODY BSC_UTILITY AS
2: /*$Header: BSCUTILB.pls 120.31 2007/10/04 14:39:13 sirukull ship $ */
3: /*===========================================================================+
4: | Copyright (c) 1995 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 81: bsc_utility

77: BSCUTILB.pls
78:
79: PACKAGE NAME
80:
81: bsc_utility
82:
83: DESCRIPTION
84: This package includes all OBSC public utility functions/procedures.
85:

Line 203: IF( bsc_utility.msg_level >= print_level ) THEN

199:
200: PROCEDURE print_debug( str VARCHAR2, print_level NUMBER ) IS
201: BEGIN
202:
203: IF( bsc_utility.msg_level >= print_level ) THEN
204: print_debug( str );
205: END IF;
206:
207: END print_debug;

Line 233: bsc_utility.MSG_LEVEL_TIMING );

229: PROCEDURE print_fcn_label( p_label VARCHAR2 ) IS
230: BEGIN
231:
232: print_debug( p_label || ' ' || to_char(sysdate, 'DD-MON-YY HH:MI:SS'),
233: bsc_utility.MSG_LEVEL_TIMING );
234:
235: END print_fcn_label;
236:
237: PROCEDURE print_fcn_label2( p_label VARCHAR2 ) IS

Line 241: bsc_utility.MSG_LEVEL_DEBUG );

237: PROCEDURE print_fcn_label2( p_label VARCHAR2 ) IS
238: BEGIN
239:
240: print_debug( p_label || ' ' || to_char(sysdate, 'DD-MON-YY HH:MI:SS'),
241: bsc_utility.MSG_LEVEL_DEBUG );
242:
243: END print_fcn_label2;
244:
245: -----------------------------------------------------------------------------

Line 257: bsc_utility.print_debug('SQL stmt: '||x_sql_stmt);

253: h_ignore NUMBER;
254:
255: BEGIN
256:
257: bsc_utility.print_debug('SQL stmt: '||x_sql_stmt);
258:
259: h_handle := dbms_sql.open_cursor;
260: dbms_sql.parse(h_handle, x_sql_stmt, dbms_sql.native);
261: h_ignore := dbms_sql.execute(h_handle);

Line 281: x_source => 'BSC_UTILITY.Close_Cursor'

277: EXCEPTION
278: WHEN OTHERS THEN
279: BSC_MESSAGE.add(
280: x_message => sqlerrm,
281: x_source => 'BSC_UTILITY.Close_Cursor'
282: );
283:
284: print_debug('ERROR: bsc_utility.close_cursor()',
285: bsc_utility.MSG_LEVEL_BASIC);

Line 284: print_debug('ERROR: bsc_utility.close_cursor()',

280: x_message => sqlerrm,
281: x_source => 'BSC_UTILITY.Close_Cursor'
282: );
283:
284: print_debug('ERROR: bsc_utility.close_cursor()',
285: bsc_utility.MSG_LEVEL_BASIC);
286: RAISE;
287: END close_cursor;
288:

Line 285: bsc_utility.MSG_LEVEL_BASIC);

281: x_source => 'BSC_UTILITY.Close_Cursor'
282: );
283:
284: print_debug('ERROR: bsc_utility.close_cursor()',
285: bsc_utility.MSG_LEVEL_BASIC);
286: RAISE;
287: END close_cursor;
288:
289:

Line 317: BSC_UTILITY.debug(x_calling_fn => 'BSC_UTILITY.DO_SQL',

313: x_type => 0,
314: x_mode => 'I'
315: );
316:
317: BSC_UTILITY.debug(x_calling_fn => 'BSC_UTILITY.DO_SQL',
318: x_debug_msg => x_sql_stmt,
319: x_mode => 'I'
320: );
321:

Line 1428: IF (BSC_UTILITY.is_View_Exists(p_Table_View_Name)) THEN

1424: p_Table_View_Name IN VARCHAR2
1425: ) RETURN BOOLEAN
1426: IS
1427: BEGIN
1428: IF (BSC_UTILITY.is_View_Exists(p_Table_View_Name)) THEN
1429: RETURN TRUE;
1430: ELSIF (BSC_UTILITY.is_Table_Exists(p_Table_View_Name)) THEN
1431: RETURN TRUE;
1432: ELSE

Line 1430: ELSIF (BSC_UTILITY.is_Table_Exists(p_Table_View_Name)) THEN

1426: IS
1427: BEGIN
1428: IF (BSC_UTILITY.is_View_Exists(p_Table_View_Name)) THEN
1429: RETURN TRUE;
1430: ELSIF (BSC_UTILITY.is_Table_Exists(p_Table_View_Name)) THEN
1431: RETURN TRUE;
1432: ELSE
1433: RETURN FALSE;
1434: END IF;

Line 1556: l_Application_Short_Name := BSC_UTILITY.c_BSC;

1552: l_Function_Return BOOLEAN;
1553:
1554: BEGIN
1555:
1556: l_Application_Short_Name := BSC_UTILITY.c_BSC;
1557:
1558: l_Function_Return := FND_INSTALLATION.Get_App_Info
1559: (
1560: Application_Short_Name => l_Application_Short_Name

Line 1757: bsc_utility.c_BSC_MEASURE,

1753:
1754:
1755: /*********************************************************************************
1756: Return default internal name based on p_type. Currently supported type:
1757: bsc_utility.c_BSC_MEASURE,
1758: bsc_utility.c_BSC_DIMENSION,
1759: bsc_utility.c_BSC_DIM_OBJECT
1760:
1761: Input Parameters:-

Line 1758: bsc_utility.c_BSC_DIMENSION,

1754:
1755: /*********************************************************************************
1756: Return default internal name based on p_type. Currently supported type:
1757: bsc_utility.c_BSC_MEASURE,
1758: bsc_utility.c_BSC_DIMENSION,
1759: bsc_utility.c_BSC_DIM_OBJECT
1760:
1761: Input Parameters:-
1762: p_type :- one of the supported types

Line 1759: bsc_utility.c_BSC_DIM_OBJECT

1755: /*********************************************************************************
1756: Return default internal name based on p_type. Currently supported type:
1757: bsc_utility.c_BSC_MEASURE,
1758: bsc_utility.c_BSC_DIMENSION,
1759: bsc_utility.c_BSC_DIM_OBJECT
1760:
1761: Input Parameters:-
1762: p_type :- one of the supported types
1763: *********************************************************************************/

Line 1774: IF (l_type = bsc_utility.c_BSC_MEASURE) THEN

1770: l_msg_data VARCHAR2(10);
1771: l_msg_count NUMBER;
1772: BEGIN
1773: l_type := UPPER(p_type);
1774: IF (l_type = bsc_utility.c_BSC_MEASURE) THEN
1775: SELECT NVL(MAX(dataset_id) + 1, 0)
1776: INTO l_next
1777: FROM BSC_SYS_DATASETS_TL;
1778: l_ret_val := bsc_bis_measure_pub.c_PMD || l_next;

Line 1780: ELSIF (l_type = bsc_utility.c_BSC_DIMENSION) THEN

1776: INTO l_next
1777: FROM BSC_SYS_DATASETS_TL;
1778: l_ret_val := bsc_bis_measure_pub.c_PMD || l_next;
1779:
1780: ELSIF (l_type = bsc_utility.c_BSC_DIMENSION) THEN
1781: SELECT NVL(MAX(dim_group_id) + 1, 0)
1782: INTO l_next
1783: FROM BSC_SYS_DIM_GROUPS_TL;
1784: l_ret_val := bsc_bis_dimension_pub.c_BSC_DIM || l_next;

Line 1786: ELSIF (l_type = bsc_utility.c_BSC_DIM_OBJ) THEN

1782: INTO l_next
1783: FROM BSC_SYS_DIM_GROUPS_TL;
1784: l_ret_val := bsc_bis_dimension_pub.c_BSC_DIM || l_next;
1785:
1786: ELSIF (l_type = bsc_utility.c_BSC_DIM_OBJ) THEN
1787: SELECT NVL(MAX(dim_level_id) + 1, 0)
1788: INTO l_next
1789: FROM BSC_SYS_DIM_LEVELS_B;
1790: l_ret_val := bsc_bis_dim_obj_pub.c_BSC_DIM_OBJ || l_next;

Line 1829: , p_List_Data OUT NOCOPY BSC_UTILITY.varchar_tabletype

1825: PROCEDURE Parse_String
1826: (
1827: p_List VARCHAR2
1828: , p_Separator VARCHAR2
1829: , p_List_Data OUT NOCOPY BSC_UTILITY.varchar_tabletype
1830: , p_List_number OUT NOCOPY NUMBER
1831: ) IS
1832:
1833: l_start NUMBER;

Line 1948: l_alias := bsc_utility.get_Next_Alias(l_alias);

1944: IF (l_count = 0) THEN
1945: l_found := FALSE;
1946: END IF;
1947: IF(l_found) THEN
1948: l_alias := bsc_utility.get_Next_Alias(l_alias);
1949: l_table_name := 'BSC_D_' ||SUBSTR(UPPER(REPLACE(p_short_name, ' ', '_')) , 1, 18)||l_alias|| '_V';
1950: END IF;
1951: END LOOP;
1952:

Line 2242: AND BSC_BIS_DIMENSION_PUB.Get_Dimension_Source(d.SHORT_NAME)=BSC_UTILITY.c_PMF

2238: INTO l_Count
2239: FROM BSC_SYS_DIM_GROUPS_VL d,
2240: BSC_KPI_DIM_GROUPS k
2241: WHERE d.DIM_GROUP_ID = k.DIM_GROUP_ID
2242: AND BSC_BIS_DIMENSION_PUB.Get_Dimension_Source(d.SHORT_NAME)=BSC_UTILITY.c_PMF
2243: AND d.SHORT_NAME=p_Short_Name;
2244:
2245: IF (l_Count <> 0) THEN
2246: RETURN 'BIS_DIM_IMPORT_DIM';

Line 2261: WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY

2257: -- Condition for Dimension Group created/used in Weighted Report.
2258: SELECT COUNT(1)
2259: INTO l_Count
2260: FROM ak_regions
2261: WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY
2262: AND attribute10 = BSC_UTILITY.C_REPORT_TYPE_MDS
2263: AND attribute12 = p_Short_Name;
2264:
2265: IF (l_Count <> 0) THEN

Line 2262: AND attribute10 = BSC_UTILITY.C_REPORT_TYPE_MDS

2258: SELECT COUNT(1)
2259: INTO l_Count
2260: FROM ak_regions
2261: WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY
2262: AND attribute10 = BSC_UTILITY.C_REPORT_TYPE_MDS
2263: AND attribute12 = p_Short_Name;
2264:
2265: IF (l_Count <> 0) THEN
2266: RETURN 'BIS_DIM_ASSIGN_AGREPORT';

Line 2280: WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY

2276: -- Condition for Dimension Group created/used in Table Based Report.
2277: SELECT COUNT(1)
2278: INTO l_Count
2279: FROM ak_regions
2280: WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY
2281: AND attribute10 = BSC_UTILITY.C_REPORT_TYPE_TABLE
2282: AND attribute12 = p_Short_Name;
2283:
2284: IF (l_Count <> 0) THEN

Line 2281: AND attribute10 = BSC_UTILITY.C_REPORT_TYPE_TABLE

2277: SELECT COUNT(1)
2278: INTO l_Count
2279: FROM ak_regions
2280: WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY
2281: AND attribute10 = BSC_UTILITY.C_REPORT_TYPE_TABLE
2282: AND attribute12 = p_Short_Name;
2283:
2284: IF (l_Count <> 0) THEN
2285: RETURN 'BIS_DIM_ASSIGN_TABLEREPORT';

Line 2291: WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY

2287:
2288: SELECT COUNT(1)
2289: INTO l_Count
2290: FROM ak_regions
2291: WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY
2292: AND attribute10 IS NULL
2293: AND attribute12 = p_Short_Name;
2294:
2295: IF (l_Count <> 0) THEN

Line 2465: IF(p_Object_Type = bsc_utility.c_BSC_MEASURE) THEN

2461: RETURN VARCHAR2
2462: IS
2463: l_Return_Short_Name VARCHAR2(30);
2464: BEGIN
2465: IF(p_Object_Type = bsc_utility.c_BSC_MEASURE) THEN
2466: l_Return_Short_Name := bsc_utility.c_BSC_MEASURE_SHORT_NAME||TO_CHAR(SYSDATE,'J')||ABS(DBMS_UTILITY.GET_TIME);
2467: END IF;
2468: RETURN l_Return_Short_Name;
2469: EXCEPTION

Line 2466: l_Return_Short_Name := bsc_utility.c_BSC_MEASURE_SHORT_NAME||TO_CHAR(SYSDATE,'J')||ABS(DBMS_UTILITY.GET_TIME);

2462: IS
2463: l_Return_Short_Name VARCHAR2(30);
2464: BEGIN
2465: IF(p_Object_Type = bsc_utility.c_BSC_MEASURE) THEN
2466: l_Return_Short_Name := bsc_utility.c_BSC_MEASURE_SHORT_NAME||TO_CHAR(SYSDATE,'J')||ABS(DBMS_UTILITY.GET_TIME);
2467: END IF;
2468: RETURN l_Return_Short_Name;
2469: EXCEPTION
2470: WHEN OTHERS THEN

Line 2544: WHILE (BSC_UTILITY.is_more( l_short_names,l_dim_obj_sht_name)) LOOP

2540: IF (p_Short_Names IS NOT NULL) THEN
2541: x_region_codes := FND_TABLE_OF_VARCHAR2_30();
2542: l_sql := 'SELECT DISTINCT REGION_CODE FROM ak_region_items WHERE node_query_flag = ''Y'' AND node_display_flag = ''N'' AND SUBSTR(attribute2,INSTR(attribute2,''+'') +1 ,LENGTH(attribute2)) IN (' ;
2543: l_short_names := p_Short_Names;
2544: WHILE (BSC_UTILITY.is_more( l_short_names,l_dim_obj_sht_name)) LOOP
2545: l_attr2_sql := l_attr2_sql || '''' || l_dim_obj_sht_name || ''',' ;
2546: END LOOP;
2547: IF(l_attr2_sql IS NOT NULL) THEN
2548: --Remove the additional comma at the end

Line 2799: BSC_UTILITY.Validate_PLSQL (

2795: l_View_Cols VARCHAR2(2000);
2796: l_Custom_Cols VARCHAR2(2000);
2797: BEGIN
2798: -- STEP#1 of algorithm
2799: BSC_UTILITY.Validate_PLSQL (
2800: p_Plsql_Function => p_Plsql_Function
2801: , x_Return_Status => x_Return_Status
2802: , x_Msg_Count => x_Msg_Count
2803: , x_Msg_Data => x_Msg_Data

Line 2823: BSC_UTILITY.Get_Plsql_Parameters (

2819: END IF;
2820: */
2821:
2822: -- STEP#2 of algorithm
2823: BSC_UTILITY.Get_Plsql_Parameters (
2824: p_Report_Function => p_Plsql_Function
2825: , x_Parameter_1 => l_Parameter_1
2826: , x_Parameter_2 => l_Parameter_2
2827: , x_Parameter_3 => l_Parameter_3

Line 2850: BSC_UTILITY.Obtain_Report_Query (

2846:
2847: -- STEP#3 of Algorithm
2848: -- l_Custom_Cols has the comma seperated SELECT CLAUSE required
2849: -- and sufficient for the Report region.
2850: BSC_UTILITY.Obtain_Report_Query (
2851: p_Region_Code => p_Region_Code
2852: , p_Region_Application_Id => p_Region_Application_Id
2853: , p_Plsql_Function => p_Plsql_Function
2854: , p_Attribute_Code => p_Attribute_Code

Line 2874: BSC_UTILITY.Validate_Sql_String (

2870: FND_MSG_PUB.ADD;
2871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2872: END IF;
2873:
2874: BSC_UTILITY.Validate_Sql_String (
2875: p_Sql_String => l_Custom_Sql
2876: , x_Columns => l_View_Cols
2877: , x_Return_Status => x_Return_Status
2878: , x_Msg_Count => x_Msg_Count

Line 2934: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_Plsql_For_Report ';

2930: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2931: WHEN NO_DATA_FOUND THEN
2932: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2933: IF (x_msg_data IS NOT NULL) THEN
2934: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_Plsql_For_Report ';
2935: ELSE
2936: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_Plsql_For_Report ';
2937: END IF;
2938: WHEN OTHERS THEN

Line 2936: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_Plsql_For_Report ';

2932: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2933: IF (x_msg_data IS NOT NULL) THEN
2934: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_Plsql_For_Report ';
2935: ELSE
2936: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_Plsql_For_Report ';
2937: END IF;
2938: WHEN OTHERS THEN
2939: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2940: IF (x_msg_data IS NOT NULL) THEN

Line 2941: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_Plsql_For_Report ';

2937: END IF;
2938: WHEN OTHERS THEN
2939: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2940: IF (x_msg_data IS NOT NULL) THEN
2941: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_Plsql_For_Report ';
2942: ELSE
2943: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_Plsql_For_Report ';
2944: END IF;
2945: END Validate_Plsql_For_Report;

Line 2943: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_Plsql_For_Report ';

2939: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2940: IF (x_msg_data IS NOT NULL) THEN
2941: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_Plsql_For_Report ';
2942: ELSE
2943: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_Plsql_For_Report ';
2944: END IF;
2945: END Validate_Plsql_For_Report;
2946:
2947:

Line 2970: l_Package_Token_Table BSC_UTILITY.Varchar_Tabletype;

2966: l_Temp_String2 ALL_SOURCE.TEXT%TYPE;
2967:
2968: l_Package_Specification VARCHAR2(32000);
2969:
2970: l_Package_Token_Table BSC_UTILITY.Varchar_Tabletype;
2971: l_Package_Token_Count NUMBER;
2972:
2973: l_Token_Count1 NUMBER;
2974: l_Token_Count2 NUMBER;

Line 3009: BSC_UTILITY.Parse_String

3005:
3006: --DBMS_OUTPUT.PUT_LINE (' l_Package_Name - ' || l_Package_Name);
3007: --DBMS_OUTPUT.PUT_LINE (' l_Function_Name - ' || l_Function_Name);
3008:
3009: BSC_UTILITY.Parse_String
3010: (
3011: p_List => l_Package_Specification
3012: , p_Separator => ','
3013: , p_List_Data => l_Package_Token_Table

Line 3192: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_PLSQL ';

3188: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3189: WHEN NO_DATA_FOUND THEN
3190: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3191: IF (x_msg_data IS NOT NULL) THEN
3192: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_PLSQL ';
3193: ELSE
3194: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_PLSQL ';
3195: END IF;
3196: WHEN OTHERS THEN

Line 3194: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_PLSQL ';

3190: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3191: IF (x_msg_data IS NOT NULL) THEN
3192: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_PLSQL ';
3193: ELSE
3194: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_PLSQL ';
3195: END IF;
3196: WHEN OTHERS THEN
3197: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3198: IF (x_msg_data IS NOT NULL) THEN

Line 3199: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_PLSQL ';

3195: END IF;
3196: WHEN OTHERS THEN
3197: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3198: IF (x_msg_data IS NOT NULL) THEN
3199: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_PLSQL ';
3200: ELSE
3201: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_PLSQL ';
3202: END IF;
3203: END Validate_PLSQL;

Line 3201: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_PLSQL ';

3197: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3198: IF (x_msg_data IS NOT NULL) THEN
3199: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_PLSQL ';
3200: ELSE
3201: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_PLSQL ';
3202: END IF;
3203: END Validate_PLSQL;
3204:
3205:

Line 3223: l_Attribute_Code BSC_UTILITY.Varchar_Tabletype;

3219: , x_Return_Status OUT NOCOPY VARCHAR2
3220: , x_Msg_Count OUT NOCOPY NUMBER
3221: , x_Msg_Data OUT NOCOPY VARCHAR2
3222: ) IS
3223: l_Attribute_Code BSC_UTILITY.Varchar_Tabletype;
3224: l_Attribute1 BSC_UTILITY.Varchar_Tabletype;
3225: l_Attribute2 BSC_UTILITY.Varchar_Tabletype;
3226: l_Attribute3 BSC_UTILITY.Varchar_Tabletype;
3227: l_Default_Values BSC_UTILITY.Varchar_Tabletype;

Line 3224: l_Attribute1 BSC_UTILITY.Varchar_Tabletype;

3220: , x_Msg_Count OUT NOCOPY NUMBER
3221: , x_Msg_Data OUT NOCOPY VARCHAR2
3222: ) IS
3223: l_Attribute_Code BSC_UTILITY.Varchar_Tabletype;
3224: l_Attribute1 BSC_UTILITY.Varchar_Tabletype;
3225: l_Attribute2 BSC_UTILITY.Varchar_Tabletype;
3226: l_Attribute3 BSC_UTILITY.Varchar_Tabletype;
3227: l_Default_Values BSC_UTILITY.Varchar_Tabletype;
3228:

Line 3225: l_Attribute2 BSC_UTILITY.Varchar_Tabletype;

3221: , x_Msg_Data OUT NOCOPY VARCHAR2
3222: ) IS
3223: l_Attribute_Code BSC_UTILITY.Varchar_Tabletype;
3224: l_Attribute1 BSC_UTILITY.Varchar_Tabletype;
3225: l_Attribute2 BSC_UTILITY.Varchar_Tabletype;
3226: l_Attribute3 BSC_UTILITY.Varchar_Tabletype;
3227: l_Default_Values BSC_UTILITY.Varchar_Tabletype;
3228:
3229: l_Non_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;

Line 3226: l_Attribute3 BSC_UTILITY.Varchar_Tabletype;

3222: ) IS
3223: l_Attribute_Code BSC_UTILITY.Varchar_Tabletype;
3224: l_Attribute1 BSC_UTILITY.Varchar_Tabletype;
3225: l_Attribute2 BSC_UTILITY.Varchar_Tabletype;
3226: l_Attribute3 BSC_UTILITY.Varchar_Tabletype;
3227: l_Default_Values BSC_UTILITY.Varchar_Tabletype;
3228:
3229: l_Non_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;
3230: l_Non_Time_Dimension_Value BSC_UTILITY.Varchar_Tabletype;

Line 3227: l_Default_Values BSC_UTILITY.Varchar_Tabletype;

3223: l_Attribute_Code BSC_UTILITY.Varchar_Tabletype;
3224: l_Attribute1 BSC_UTILITY.Varchar_Tabletype;
3225: l_Attribute2 BSC_UTILITY.Varchar_Tabletype;
3226: l_Attribute3 BSC_UTILITY.Varchar_Tabletype;
3227: l_Default_Values BSC_UTILITY.Varchar_Tabletype;
3228:
3229: l_Non_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;
3230: l_Non_Time_Dimension_Value BSC_UTILITY.Varchar_Tabletype;
3231: l_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;

Line 3229: l_Non_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;

3225: l_Attribute2 BSC_UTILITY.Varchar_Tabletype;
3226: l_Attribute3 BSC_UTILITY.Varchar_Tabletype;
3227: l_Default_Values BSC_UTILITY.Varchar_Tabletype;
3228:
3229: l_Non_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;
3230: l_Non_Time_Dimension_Value BSC_UTILITY.Varchar_Tabletype;
3231: l_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;
3232: l_Time_Dimension_Value BSC_UTILITY.Varchar_Tabletype;
3233:

Line 3230: l_Non_Time_Dimension_Value BSC_UTILITY.Varchar_Tabletype;

3226: l_Attribute3 BSC_UTILITY.Varchar_Tabletype;
3227: l_Default_Values BSC_UTILITY.Varchar_Tabletype;
3228:
3229: l_Non_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;
3230: l_Non_Time_Dimension_Value BSC_UTILITY.Varchar_Tabletype;
3231: l_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;
3232: l_Time_Dimension_Value BSC_UTILITY.Varchar_Tabletype;
3233:
3234: l_Attribute_Code_Count NUMBER;

Line 3231: l_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;

3227: l_Default_Values BSC_UTILITY.Varchar_Tabletype;
3228:
3229: l_Non_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;
3230: l_Non_Time_Dimension_Value BSC_UTILITY.Varchar_Tabletype;
3231: l_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;
3232: l_Time_Dimension_Value BSC_UTILITY.Varchar_Tabletype;
3233:
3234: l_Attribute_Code_Count NUMBER;
3235: l_Attribute1_Count NUMBER;

Line 3232: l_Time_Dimension_Value BSC_UTILITY.Varchar_Tabletype;

3228:
3229: l_Non_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;
3230: l_Non_Time_Dimension_Value BSC_UTILITY.Varchar_Tabletype;
3231: l_Time_Dimension_Type BSC_UTILITY.Varchar_Tabletype;
3232: l_Time_Dimension_Value BSC_UTILITY.Varchar_Tabletype;
3233:
3234: l_Attribute_Code_Count NUMBER;
3235: l_Attribute1_Count NUMBER;
3236: l_Attribute2_Count NUMBER;

Line 3254: BSC_UTILITY.Parse_String

3250: FND_MSG_PUB.Initialize;
3251: l_Table_Count := 0;
3252: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
3253:
3254: BSC_UTILITY.Parse_String
3255: (
3256: p_List => p_Attribute_Code
3257: , p_Separator => ','
3258: , p_List_Data => l_Attribute_Code

Line 3262: BSC_UTILITY.Parse_String

3258: , p_List_Data => l_Attribute_Code
3259: , p_List_number => l_Attribute_Code_Count
3260: );
3261:
3262: BSC_UTILITY.Parse_String
3263: (
3264: p_List => p_Attribute1
3265: , p_Separator => ','
3266: , p_List_Data => l_Attribute1

Line 3270: BSC_UTILITY.Parse_String

3266: , p_List_Data => l_Attribute1
3267: , p_List_number => l_Attribute1_Count
3268: );
3269:
3270: BSC_UTILITY.Parse_String
3271: (
3272: p_List => p_Attribute2
3273: , p_Separator => ','
3274: , p_List_Data => l_Attribute2

Line 3278: BSC_UTILITY.Parse_String

3274: , p_List_Data => l_Attribute2
3275: , p_List_number => l_Attribute2_Count
3276: );
3277:
3278: BSC_UTILITY.Parse_String
3279: (
3280: p_List => p_Attribute3
3281: , p_Separator => ','
3282: , p_List_Data => l_Attribute3

Line 3286: BSC_UTILITY.Parse_String

3282: , p_List_Data => l_Attribute3
3283: , p_List_number => l_Attribute3_Count
3284: );
3285:
3286: BSC_UTILITY.Parse_String
3287: (
3288: p_List => p_Default_Values
3289: , p_Separator => ','
3290: , p_List_Data => l_Default_Values

Line 3545: x_msg_data := x_msg_data||' -> BSC_UTILITY.Obtain_Report_Query ';

3541: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3542: WHEN NO_DATA_FOUND THEN
3543: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3544: IF (x_msg_data IS NOT NULL) THEN
3545: x_msg_data := x_msg_data||' -> BSC_UTILITY.Obtain_Report_Query ';
3546: ELSE
3547: x_msg_data := SQLERRM||' at BSC_UTILITY.Obtain_Report_Query ';
3548: END IF;
3549: WHEN OTHERS THEN

Line 3547: x_msg_data := SQLERRM||' at BSC_UTILITY.Obtain_Report_Query ';

3543: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3544: IF (x_msg_data IS NOT NULL) THEN
3545: x_msg_data := x_msg_data||' -> BSC_UTILITY.Obtain_Report_Query ';
3546: ELSE
3547: x_msg_data := SQLERRM||' at BSC_UTILITY.Obtain_Report_Query ';
3548: END IF;
3549: WHEN OTHERS THEN
3550: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3551: IF (x_msg_data IS NOT NULL) THEN

Line 3552: x_msg_data := x_msg_data||' -> BSC_UTILITY.Obtain_Report_Query ';

3548: END IF;
3549: WHEN OTHERS THEN
3550: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3551: IF (x_msg_data IS NOT NULL) THEN
3552: x_msg_data := x_msg_data||' -> BSC_UTILITY.Obtain_Report_Query ';
3553: ELSE
3554: x_msg_data := SQLERRM||' at BSC_UTILITY.Obtain_Report_Query ';
3555: END IF;
3556: END Obtain_Report_Query;

Line 3554: x_msg_data := SQLERRM||' at BSC_UTILITY.Obtain_Report_Query ';

3550: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3551: IF (x_msg_data IS NOT NULL) THEN
3552: x_msg_data := x_msg_data||' -> BSC_UTILITY.Obtain_Report_Query ';
3553: ELSE
3554: x_msg_data := SQLERRM||' at BSC_UTILITY.Obtain_Report_Query ';
3555: END IF;
3556: END Obtain_Report_Query;
3557:
3558:

Line 3648: BSC_UTILITY.Do_Ddl_AT(l_Sql_View, AD_DDL.CREATE_VIEW, l_Temp_View_Name, 'APPS', 'BIS');

3644: l_Sql_View := l_Sql_View || ' AS ';
3645: l_Sql_View := l_Sql_View || p_Sql_String;
3646:
3647: l_Stage := 'CREATE_VIEW';
3648: BSC_UTILITY.Do_Ddl_AT(l_Sql_View, AD_DDL.CREATE_VIEW, l_Temp_View_Name, 'APPS', 'BIS');
3649:
3650: -- View has been created successfully, if it reaches here.
3651:
3652: FOR cGCN IN c_Get_Column_Names LOOP

Line 3662: BSC_UTILITY.Do_Ddl_AT(l_Sql_View, AD_DDL.DROP_VIEW, l_Temp_View_Name, 'APPS', 'BIS');

3658: END LOOP;
3659:
3660: l_Sql_View := 'DROP VIEW ' || l_Temp_View_Name;
3661: l_Stage := 'DROP_VIEW';
3662: BSC_UTILITY.Do_Ddl_AT(l_Sql_View, AD_DDL.DROP_VIEW, l_Temp_View_Name, 'APPS', 'BIS');
3663:
3664: EXCEPTION
3665: WHEN OTHERS THEN
3666: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3674: l_String_Table BSC_UTILITY.Varchar_Tabletype;

3670: -- Sorts a comma separated string using a Enhanced Bubble Sort (Very bad - but ok for now)
3671: FUNCTION Sort_String (
3672: p_String IN VARCHAR2
3673: ) RETURN VARCHAR2 IS
3674: l_String_Table BSC_UTILITY.Varchar_Tabletype;
3675: l_Temp VARCHAR2(1024);
3676: l_Count NUMBER;
3677: i NUMBER;
3678: j NUMBER;

Line 3684: BSC_UTILITY.Parse_String

3680: BEGIN
3681: IF (p_String IS NULL) THEN
3682: RETURN NULL;
3683: END IF;
3684: BSC_UTILITY.Parse_String
3685: (
3686: p_List => p_String
3687: , p_Separator => ','
3688: , p_List_Data => l_String_Table

Line 3817: (BSC_UTILITY.Is_Src_Col_In_Formulas(m.measure_Col) = 'T') OR

3813: WHERE d.dataset_id = p_dataset_id
3814: AND m.measure_id = d.measure_id1
3815: AND ((BSC_BIS_MEASURE_PUB.Is_Formula_Type(m.measure_Col) = 'T') OR
3816: (d.measure_id2 IS NOT NULL) OR
3817: (BSC_UTILITY.Is_Src_Col_In_Formulas(m.measure_Col) = 'T') OR
3818: ((SELECT COUNT(1) FROM bsc_sys_datasets_b
3819: WHERE dataset_id <> d.dataset_id
3820: AND (measure_id1 = d.measure_id1 OR measure_id2 = d.measure_id1)) > 0)
3821: );

Line 3857: l_List_Table BSC_UTILITY.Varchar_Tabletype;

3853: ) RETURN VARCHAR2 IS
3854:
3855: l_Merged_String VARCHAR2(32000);
3856:
3857: l_List_Table BSC_UTILITY.Varchar_Tabletype;
3858: l_List_Count NUMBER;
3859: l_UList_Table BSC_UTILITY.Varchar_Tabletype;
3860: l_UList_Count NUMBER;
3861:

Line 3859: l_UList_Table BSC_UTILITY.Varchar_Tabletype;

3855: l_Merged_String VARCHAR2(32000);
3856:
3857: l_List_Table BSC_UTILITY.Varchar_Tabletype;
3858: l_List_Count NUMBER;
3859: l_UList_Table BSC_UTILITY.Varchar_Tabletype;
3860: l_UList_Count NUMBER;
3861:
3862: l_Final_List VARCHAR2(32000);
3863: BEGIN

Line 3877: BSC_UTILITY.Parse_String

3873: END IF;
3874: END IF;
3875:
3876: IF (l_Merged_String IS NOT NULL) THEN
3877: BSC_UTILITY.Parse_String
3878: (
3879: p_List => l_Merged_String
3880: , p_Separator => ','
3881: , p_List_Data => l_List_Table

Line 3886: l_UList_Table := BSC_UTILITY.Get_Unique_List(l_List_Table);

3882: , p_List_number => l_List_Count
3883: );
3884: END IF;
3885:
3886: l_UList_Table := BSC_UTILITY.Get_Unique_List(l_List_Table);
3887:
3888: FOR i IN 1..l_UList_Table.COUNT LOOP
3889: IF (l_Final_List IS NULL) THEN
3890: l_Final_List := l_UList_Table(i);

Line 3905: UTILITY FUNCTION TO RETURN A UNIQUE LIST of TYPE BSC_UTILITY.varchar_tabletype

3901: END Create_Unique_Comma_List;
3902:
3903:
3904: /*****************************************************************************
3905: UTILITY FUNCTION TO RETURN A UNIQUE LIST of TYPE BSC_UTILITY.varchar_tabletype
3906: ******************************************************************************/
3907:
3908: FUNCTION Get_Unique_List (p_List IN BSC_UTILITY.varchar_tabletype)
3909: RETURN BSC_UTILITY.varchar_tabletype IS

Line 3908: FUNCTION Get_Unique_List (p_List IN BSC_UTILITY.varchar_tabletype)

3904: /*****************************************************************************
3905: UTILITY FUNCTION TO RETURN A UNIQUE LIST of TYPE BSC_UTILITY.varchar_tabletype
3906: ******************************************************************************/
3907:
3908: FUNCTION Get_Unique_List (p_List IN BSC_UTILITY.varchar_tabletype)
3909: RETURN BSC_UTILITY.varchar_tabletype IS
3910: l_Unique_List BSC_UTILITY.varchar_tabletype;
3911: l_Element VARCHAR2(32000);
3912: l_Count NUMBER;

Line 3909: RETURN BSC_UTILITY.varchar_tabletype IS

3905: UTILITY FUNCTION TO RETURN A UNIQUE LIST of TYPE BSC_UTILITY.varchar_tabletype
3906: ******************************************************************************/
3907:
3908: FUNCTION Get_Unique_List (p_List IN BSC_UTILITY.varchar_tabletype)
3909: RETURN BSC_UTILITY.varchar_tabletype IS
3910: l_Unique_List BSC_UTILITY.varchar_tabletype;
3911: l_Element VARCHAR2(32000);
3912: l_Count NUMBER;
3913: l_Duplicate BOOLEAN;

Line 3910: l_Unique_List BSC_UTILITY.varchar_tabletype;

3906: ******************************************************************************/
3907:
3908: FUNCTION Get_Unique_List (p_List IN BSC_UTILITY.varchar_tabletype)
3909: RETURN BSC_UTILITY.varchar_tabletype IS
3910: l_Unique_List BSC_UTILITY.varchar_tabletype;
3911: l_Element VARCHAR2(32000);
3912: l_Count NUMBER;
3913: l_Duplicate BOOLEAN;
3914: BEGIN

Line 3962: IF(l_measure_type=BSC_UTILITY.C_MEASURE_SOURCE_CDS_CALC)THEN

3958: INTO l_measure_type
3959: FROM bis_indicators
3960: WHERE short_name = p_Measure_Short_Name;
3961:
3962: IF(l_measure_type=BSC_UTILITY.C_MEASURE_SOURCE_CDS_CALC)THEN
3963: l_flag:=FND_API.G_TRUE;
3964: END IF;
3965: RETURN l_flag;
3966:

Line 4015: IF((l_measure_type=BSC_UTILITY.C_MEASURE_TYPE_CDS_SCORE) OR (l_measure_type=BSC_UTILITY.C_MEASURE_TYPE_CDS_PERF))THEN

4011: INTO l_measure_type
4012: FROM bis_indicators
4013: WHERE dataset_id = p_dataset_id;
4014:
4015: IF((l_measure_type=BSC_UTILITY.C_MEASURE_TYPE_CDS_SCORE) OR (l_measure_type=BSC_UTILITY.C_MEASURE_TYPE_CDS_PERF))THEN
4016: l_flag:=FND_API.G_TRUE;
4017: END IF;
4018: RETURN l_flag;
4019: EXCEPTION

Line 4077: IF(l_measure_type=BSC_UTILITY.C_MEASURE_SOURCE_CDS_CALC)THEN

4073: INTO l_measure_type
4074: FROM bis_indicators
4075: WHERE dataset_id = p_dataset_id;
4076:
4077: IF(l_measure_type=BSC_UTILITY.C_MEASURE_SOURCE_CDS_CALC)THEN
4078: l_flag:=FND_API.G_TRUE;
4079: END IF;
4080: RETURN l_flag;
4081:

Line 4111: AND a.attribute1 IN (BSC_UTILITY.C_ATTRTYPE_MEASURE,BSC_UTILITY.C_ATTRTYPE_MEASURE_NO_TARGET,BSC_UTILITY.C_BUCKET_MEASURE,BSC_UTILITY.C_SUB_MEASURE)

4107: INTO l_count
4108: FROM ak_region_items a,
4109: ak_regions b
4110: WHERE a.region_code = b.region_code
4111: AND a.attribute1 IN (BSC_UTILITY.C_ATTRTYPE_MEASURE,BSC_UTILITY.C_ATTRTYPE_MEASURE_NO_TARGET,BSC_UTILITY.C_BUCKET_MEASURE,BSC_UTILITY.C_SUB_MEASURE)
4112: AND a.attribute2 = l_attribute2
4113: AND b.attribute10 = BSC_UTILITY.C_MULTIPLE_DATA_SOURCE;
4114:
4115: IF(l_count>0)THEN

Line 4113: AND b.attribute10 = BSC_UTILITY.C_MULTIPLE_DATA_SOURCE;

4109: ak_regions b
4110: WHERE a.region_code = b.region_code
4111: AND a.attribute1 IN (BSC_UTILITY.C_ATTRTYPE_MEASURE,BSC_UTILITY.C_ATTRTYPE_MEASURE_NO_TARGET,BSC_UTILITY.C_BUCKET_MEASURE,BSC_UTILITY.C_SUB_MEASURE)
4112: AND a.attribute2 = l_attribute2
4113: AND b.attribute10 = BSC_UTILITY.C_MULTIPLE_DATA_SOURCE;
4114:
4115: IF(l_count>0)THEN
4116: l_flag := FND_API.G_TRUE;
4117: END IF;

Line 4168: END BSC_UTILITY;

4164: WHEN OTHERS THEN
4165: x_result := -1;
4166: END comp_leapyear_prioryear;
4167:
4168: END BSC_UTILITY;