APPS.BSC_SIMULATION_VIEW_PVT dependencies on BSC_APPS

Line 349: BSC_APPS.Init_Bsc_Apps;

345:
346:
347: BEGIN
348:
349: BSC_APPS.Init_Bsc_Apps;
350:
351: IF(INSTR(p_table_name,'BIS')>0)THEN
352: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)
353: INTO l_owner FROM DUAL;

Line 352: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)

348:
349: BSC_APPS.Init_Bsc_Apps;
350:
351: IF(INSTR(p_table_name,'BIS')>0)THEN
352: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)
353: INTO l_owner FROM DUAL;
354: ELSIF(INSTR(p_table_name,'FND')>0) THEN
355: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)
356: INTO l_owner FROM DUAL;

Line 355: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)

351: IF(INSTR(p_table_name,'BIS')>0)THEN
352: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)
353: INTO l_owner FROM DUAL;
354: ELSIF(INSTR(p_table_name,'FND')>0) THEN
355: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)
356: INTO l_owner FROM DUAL;
357: ELSE
358: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('AK'),USER)
359: INTO l_owner FROM DUAL;

Line 358: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('AK'),USER)

354: ELSIF(INSTR(p_table_name,'FND')>0) THEN
355: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)
356: INTO l_owner FROM DUAL;
357: ELSE
358: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('AK'),USER)
359: INTO l_owner FROM DUAL;
360: END IF;
361:
362:

Line 465: AND owner = DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema,USER)

461: CURSOR c_column IS
462: SELECT column_name
463: FROM all_tab_columns
464: WHERE table_name = p_table_name
465: AND owner = DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema,USER)
466: ORDER BY column_name;
467:
468: h_colum VARCHAR2(100);
469: h_key_name VARCHAR2(30);

Line 480: BSC_APPS.Init_Bsc_Apps;

476:
477:
478: BEGIN
479:
480: BSC_APPS.Init_Bsc_Apps;
481:
482: h_key_name := 'TAB_VIEW_ID';
483: IF( p_table_column = BSC_SIMULATION_VIEW_PVT.C_SOURCE_CODE )THEN
484: h_key_name := 'SOURCE_CODE';

Line 614: BSC_APPS.Init_Bsc_Apps;

610: WHERE tab_id =BSC_SIMULATION_VIEW_PUB.c_TAB_ID
611: AND tab_view_id = p_target_kpi;
612:
613: IF( l_count =0 )THEN
614: BSC_APPS.Init_Bsc_Apps;
615:
616: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array
617: (
618: p_copy_Ak_Tables => FND_API.G_FALSE

Line 1287: BSC_APPS.Init_Bsc_Apps;

1283: SAVEPOINT copysimmetadata;
1284: FND_MSG_PUB.INITIALIZE;
1285: x_return_status := FND_API.G_RET_STS_SUCCESS;
1286:
1287: BSC_APPS.Init_Bsc_Apps;
1288:
1289: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array
1290: (
1291: p_copy_Ak_Tables => FND_API.G_TRUE

Line 1511: BSC_APPS.Init_Bsc_Apps;

1507: IF(l_count >0) THEN
1508:
1509: --Now we will initialize the tables from where we need to copy the data to sim objectives
1510:
1511: BSC_APPS.Init_Bsc_Apps;
1512:
1513: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array
1514: (
1515: p_copy_Ak_Tables => FND_API.G_TRUE

Line 1665: BSC_APPS.Write_Line_Log('Dimension with short Name[ ' ||p_Region_Code||'] already exists' , BSC_APPS.OUTPUT_FILE);

1661: WHERE
1662: short_name = p_Region_Code;
1663:
1664: IF l_Count > 0 THEN
1665: BSC_APPS.Write_Line_Log('Dimension with short Name[ ' ||p_Region_Code||'] already exists' , BSC_APPS.OUTPUT_FILE);
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;
1668:
1669: BSC_BIS_DIMENSION_PUB.Create_Dimension (