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_BIS_DIM_REL_PUB dependencies on BSC_APPS

Line 598: BSC_APPS.Init_Bsc_Apps;

594: BEGIN
595:
596: FND_MSG_PUB.Initialize;
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598: BSC_APPS.Init_Bsc_Apps;
599:
600: IF(BSC_UTILITY.is_View_Exists(p_level_view_name)) THEN
601: l_Sql := C_SELECT || C_SELECT_CLAUSE
602: || C_FROM || p_level_view_name

Line 616: AND OWNER = BSC_APPS.get_user_schema('APPS')

612: SELECT count(1)
613: INTO l_count
614: FROM ALL_VIEWS
615: WHERE VIEW_NAME = p_level_view_name
616: AND OWNER = BSC_APPS.get_user_schema('APPS')
617: AND TEXT IS NOT NULL;
618:
619: IF(l_count > 0) THEN
620: l_Sql := 'ALTER VIEW '|| p_level_view_name ||' COMPILE';

Line 622: BSC_APPS.Do_Ddl_AT(l_Sql, ad_ddl.alter_view, p_level_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

618:
619: IF(l_count > 0) THEN
620: l_Sql := 'ALTER VIEW '|| p_level_view_name ||' COMPILE';
621:
622: BSC_APPS.Do_Ddl_AT(l_Sql, ad_ddl.alter_view, p_level_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
623: END IF;
624:
625: EXCEPTION
626: WHEN OTHERS THEN

Line 1257: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

1253: FND_MSG_PUB.Initialize;
1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255: IF (p_dim_obj_id IS NULL) THEN
1256: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1257: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1258: FND_MSG_PUB.ADD;
1259: RAISE FND_API.G_EXC_ERROR;
1260: END IF;
1261: IF (p_parent_ids IS NOT NULL) THEN

Line 1568: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

1564: --DBMS_OUTPUT.PUT_LINE('p_child_data_type '||p_child_data_type);
1565: --DBMS_OUTPUT.PUT_LINE('p_child_data_source '||p_child_data_source);
1566: IF (p_dim_obj_id IS NULL) THEN
1567: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1568: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: SELECT COUNT(*) INTO l_count

Line 1577: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

1573: FROM BSC_SYS_DIM_LEVELS_B
1574: WHERE dim_level_id = p_dim_obj_id;
1575: IF (l_count = 0) THEN
1576: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
1577: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1578: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
1579: FND_MSG_PUB.ADD;
1580: RAISE FND_API.G_EXC_ERROR;
1581: END IF;

Line 2575: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

2571: FND_MSG_PUB.Initialize;
2572: x_return_status := FND_API.G_RET_STS_SUCCESS;
2573: IF (p_dim_obj_id IS NULL) THEN
2574: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2575: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2576: FND_MSG_PUB.ADD;
2577: RAISE FND_API.G_EXC_ERROR;
2578: END IF;
2579: FOR cd IN c_parent_ids LOOP

Line 2969: BSC_APPS.Init_Bsc_Apps;

2965: BEGIN
2966: SAVEPOINT CreateBSC1toNTabsPMD;
2967: FND_MSG_PUB.Initialize;
2968: x_return_status := FND_API.G_RET_STS_SUCCESS;
2969: BSC_APPS.Init_Bsc_Apps;
2970: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Create_One_To_N_MTable Function');
2971: IF (p_dim_obj_id IS NULL) THEN
2972: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2973: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

Line 2973: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

2969: BSC_APPS.Init_Bsc_Apps;
2970: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Create_One_To_N_MTable Function');
2971: IF (p_dim_obj_id IS NULL) THEN
2972: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2973: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2974: FND_MSG_PUB.ADD;
2975: RAISE FND_API.G_EXC_ERROR;
2976: END IF;
2977: IF (p_dim_obj_id IS NOT NULL) THEN

Line 2985: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

2981: WHERE Dim_Level_Id = p_dim_obj_id;
2982:
2983: IF (l_count = 0) THEN
2984: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
2985: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2986: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
2987: FND_MSG_PUB.ADD;
2988: RAISE FND_API.G_EXC_ERROR;
2989: END IF;

Line 3032: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||

3028: l_alias := BSC_BIS_DIM_REL_PUB.get_Next_Alias(NULL);
3029: l_level_pk_cols := NULL;
3030: l_index_Count := 0;
3031: l_sql_stmt := 'CREATE TABLE '||l_dummy_table||' '||' TABLESPACE '||
3032: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
3033: ' AS SELECT '||l_col_names||' ';
3034: FOR cd IN c_parents_Ids LOOP
3035: --DBMS_OUTPUT.PUT_LINE('11 l_level_pk_col <'||cd.Level_Pk_Col||'> l_label_table_name <'||cd.Level_Table_Name||'>' );
3036: l_level_pk_col := cd.Level_Pk_Col;

Line 3108: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_dummy_table);

3104: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 7001, 200));
3105: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 7201, 200));
3106: --DBMS_OUTPUT.PUT_LINE('---------CREATION OF DUMMY MASTER TABLE---------');
3107:
3108: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_dummy_table);
3109:
3110: --DBMS_OUTPUT.PUT_LINE('---------DROP MASTER TABLE----------');
3111: l_sql_stmt := ' SELECT COUNT(*) FROM USER_OBJECTS '||
3112: ' WHERE OBJECT_NAME = :1';

Line 3119: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_master_table);

3115:
3116: IF (l_count <> 0) THEN
3117: l_sql_stmt := 'DROP TABLE '||l_master_table;
3118: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3119: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_master_table);
3120: END IF;
3121:
3122: --DBMS_OUTPUT.PUT_LINE('---------CREATION OF MASTER TABLE---------');
3123: l_sql_stmt := 'CREATE TABLE '||l_master_table||' '||' TABLESPACE '||

Line 3124: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||

3120: END IF;
3121:
3122: --DBMS_OUTPUT.PUT_LINE('---------CREATION OF MASTER TABLE---------');
3123: l_sql_stmt := 'CREATE TABLE '||l_master_table||' '||' TABLESPACE '||
3124: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
3125: ' AS SELECT * FROM '||l_dummy_table;
3126:
3127:
3128: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');

Line 3130: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_master_table);

3126:
3127:
3128: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3129:
3130: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_master_table);
3131:
3132: --DBMS_OUTPUT.PUT_LINE('---------DROP DUMMY TABLE---------');
3133: l_sql_stmt := 'Drop Table '||l_dummy_table;
3134: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_dummy_table);

Line 3134: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_dummy_table);

3130: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_master_table);
3131:
3132: --DBMS_OUTPUT.PUT_LINE('---------DROP DUMMY TABLE---------');
3133: l_sql_stmt := 'Drop Table '||l_dummy_table;
3134: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_dummy_table);
3135:
3136:
3137: --DBMS_OUTPUT.PUT_LINE('---------CREATION OF INDEXS ON MASTER TABLE---------');
3138: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||

Line 3140: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;

3136:
3137: --DBMS_OUTPUT.PUT_LINE('---------CREATION OF INDEXS ON MASTER TABLE---------');
3138: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||
3139: ' ON '||l_master_table||' (CODE,LANGUAGE) '||' '||
3140: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
3141: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3142: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_index, l_master_table);
3143:
3144: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828

Line 3142: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_index, l_master_table);

3138: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||
3139: ' ON '||l_master_table||' (CODE,LANGUAGE) '||' '||
3140: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
3141: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3142: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_index, l_master_table);
3143:
3144: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828
3145: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
3146: ' ON '||l_master_table||' (USER_CODE,LANGUAGE) '||' '||

Line 3147: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;

3143:
3144: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828
3145: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
3146: ' ON '||l_master_table||' (USER_CODE,LANGUAGE) '||' '||
3147: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
3148: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3149: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_index, l_master_table);
3150:
3151: --DBMS_OUTPUT.PUT_LINE('---------CREATION OF INDEXS ON MASTER TABLE LOADER BUG #3120190---------');

Line 3149: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_index, l_master_table);

3145: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
3146: ' ON '||l_master_table||' (USER_CODE,LANGUAGE) '||' '||
3147: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
3148: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3149: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_index, l_master_table);
3150:
3151: --DBMS_OUTPUT.PUT_LINE('---------CREATION OF INDEXS ON MASTER TABLE LOADER BUG #3120190---------');
3152: FOR i IN 0..(l_index_Table.COUNT-1) LOOP
3153: --DBMS_OUTPUT.PUT_LINE('l_index_Table('||i||').p_Column_Name '||l_index_Table(i).p_Column_Name);

Line 3160: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;

3156: --DBMS_OUTPUT.PUT_LINE('index length '||LENGTH(l_master_table||'_N'||(i+1)));
3157: IF (LENGTH(l_master_table||'_N'||(i+1)) <= 30) THEN
3158: l_sql_stmt := ' CREATE INDEX '||l_master_table||'_N'||(i+1)||' '||
3159: ' ON '||l_master_table||' ('||l_index_Table(i).p_Column_Name||') '||' '||
3160: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
3161: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3162: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_index, l_master_table);
3163: ELSE
3164: EXIT;

Line 3162: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_index, l_master_table);

3158: l_sql_stmt := ' CREATE INDEX '||l_master_table||'_N'||(i+1)||' '||
3159: ' ON '||l_master_table||' ('||l_index_Table(i).p_Column_Name||') '||' '||
3160: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
3161: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3162: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_index, l_master_table);
3163: ELSE
3164: EXIT;
3165: END IF;
3166: END LOOP;

Line 3178: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_input_table);

3174:
3175: IF (l_count <> 0) THEN
3176: l_sql_stmt := 'DROP TABLE '||l_input_table;
3177: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3178: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_input_table);
3179: END IF;
3180: l_sql_stmt := ' CREATE TABLE '||l_input_table||' '||' TABLESPACE '||
3181: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
3182: ' AS SELECT '||l_input_col_names||' FROM '||l_master_table||' WHERE 1 = 2';

Line 3181: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||

3177: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3178: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_input_table);
3179: END IF;
3180: l_sql_stmt := ' CREATE TABLE '||l_input_table||' '||' TABLESPACE '||
3181: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
3182: ' AS SELECT '||l_input_col_names||' FROM '||l_master_table||' WHERE 1 = 2';
3183:
3184: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 1, 200));
3185: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 201, 200));

Line 3202: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_input_table);

3198: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 2801, 200));
3199: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 3001, 200));
3200: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 3201, 200));
3201:
3202: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_input_table);
3203:
3204: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_input_table||'_U1 '||
3205: ' ON '||l_input_table||' (USER_CODE) '||' '||
3206: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;

Line 3206: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;

3202: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_input_table);
3203:
3204: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_input_table||'_U1 '||
3205: ' ON '||l_input_table||' (USER_CODE) '||' '||
3206: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
3207: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3208: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_index, l_input_table);
3209:
3210: --create dynamic view for modified master table

Line 3208: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_index, l_input_table);

3204: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_input_table||'_U1 '||
3205: ' ON '||l_input_table||' (USER_CODE) '||' '||
3206: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
3207: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3208: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_index, l_input_table);
3209:
3210: --create dynamic view for modified master table
3211: --DBMS_OUTPUT.PUT_LINE('---------GENERATION OF VIEW BASED ON MASTER TABLE---------');
3212: l_sql_stmt := ' CREATE OR REPLACE VIEW '||l_view_name||' AS (' ||

Line 3217: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_view, l_view_name);

3213: ' SELECT '||l_view_columns||
3214: ' FROM '||l_master_table||
3215: ' WHERE LANGUAGE = USERENV(''LANG''))';
3216: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3217: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_view, l_view_name);
3218:
3219: /************************************************************************
3220: Child dimension object table will contain the columns of the parent
3221: dimension object and will be added or removed.So after the creation of the new

Line 3317: BSC_APPS.Init_Bsc_Apps;

3313: BEGIN
3314: SAVEPOINT CreateBSCMtoNTabsPMD;
3315: FND_MSG_PUB.Initialize;
3316: x_return_status := FND_API.G_RET_STS_SUCCESS;
3317: BSC_APPS.Init_Bsc_Apps;
3318: IF (p_dim_obj_id IS NULL) THEN
3319: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3320: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3321: FND_MSG_PUB.ADD;

Line 3320: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

3316: x_return_status := FND_API.G_RET_STS_SUCCESS;
3317: BSC_APPS.Init_Bsc_Apps;
3318: IF (p_dim_obj_id IS NULL) THEN
3319: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3320: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3321: FND_MSG_PUB.ADD;
3322: RAISE FND_API.G_EXC_ERROR;
3323: END IF;
3324: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Create_M_To_N_MTable Function');

Line 3334: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

3330: WHERE Dim_Level_Id = p_dim_obj_id;
3331:
3332: IF (l_count = 0) THEN
3333: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
3334: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3335: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
3336: FND_MSG_PUB.ADD;
3337: RAISE FND_API.G_EXC_ERROR;
3338: END IF;

Line 3404: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||

3400:
3401: IF (l_count = 0) THEN
3402: --DBMS_OUTPUT.PUT_LINE('---------CREATION OF MASTER TABLE---------');
3403: l_sql_stmt := ' CREATE TABLE '||l_master_table||' '||' TABLESPACE '||
3404: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
3405: ' AS SELECT '||' A.CODE AS '||l_c_level_pk_col||
3406: ', B.CODE AS '||l_p_level_pk_col||
3407: ' FROM '||l_c_level_table||' A, '||
3408: l_p_level_table||' B '||

Line 3415: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_master_table);

3411:
3412: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||SUBSTR(l_sql_stmt, 1, 200)||'>');
3413: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||SUBSTR(l_sql_stmt, 201, 200)||'>');
3414:
3415: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_master_table);
3416: END IF;
3417: --DBMS_OUTPUT.PUT_LINE('l_input_table <'||l_input_table||'>');
3418: --DBMS_OUTPUT.PUT_LINE('---------CREATION OF INPUT TABLE---------');
3419: l_sql_stmt := ' SELECT COUNT(*) FROM USER_OBJECTS '||

Line 3425: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||

3421: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3422: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_input_table;
3423: IF (l_count = 0) THEN
3424: l_sql_stmt := ' CREATE TABLE '||l_input_table||' '||' TABLESPACE '||
3425: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
3426: ' AS SELECT '||' A.USER_CODE AS '||l_c_level_pk_col||'_USR, B.USER_CODE AS '||
3427: l_p_level_pk_col||'_USR '||
3428: ' FROM '||l_c_level_table||' A, '||
3429: ' '||l_p_level_table||' B '||

Line 3437: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_input_table);

3433: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 201, 200));
3434: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 401, 200));
3435: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 601, 200));
3436: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 801, 200));
3437: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_input_table);
3438: END IF;
3439: --insert into BSC_DB_TABLES_RELS & BSC_DB_TABLES
3440: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES_RELS');
3441: SELECT COUNT(*) INTO l_count

Line 3544: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

3540: x_return_status := FND_API.G_RET_STS_SUCCESS;
3541: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Drop_M_To_N_Unused_Tabs Procedure');
3542: IF (p_dim_obj_id IS NULL) THEN
3543: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3544: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3545: FND_MSG_PUB.ADD;
3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;
3548:

Line 3576: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_master_table);

3572: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_master_table;
3573: IF (l_count <> 0) THEN
3574: l_sql_stmt := 'DROP TABLE '||l_master_table;
3575: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3576: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_master_table);
3577: END IF;
3578: l_sql_stmt := ' SELECT COUNT(*) FROM USER_OBJECTS '||
3579: ' WHERE OBJECT_NAME = :1';
3580: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');

Line 3585: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_input_table);

3581: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_input_table;
3582: IF (l_count <> 0) THEN
3583: l_sql_stmt := 'DROP TABLE '||l_input_table;
3584: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3585: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_input_table);
3586: END IF;
3587: --DBMS_OUTPUT.PUT_LINE('DELETE TABLES BSC_DB_TABLES '||l_input_table);
3588: DELETE FROM BSC_DB_TABLES
3589: WHERE Table_Name = l_input_table;

Line 4118: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);

4114: AND PARENT_LEVEL_INDEX >= 0;
4115: --DBMS_OUTPUT.PUT_LINE('kpi_id :- '||l_kpi_id||'dimset_id :- '||l_dimset_id||'No of rels are :- '||l_no_rels );
4116: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN
4117: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
4118: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4119: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4120: FND_MSG_PUB.ADD;
4121: ROLLBACK TO sp_before_rel_config;
4122: RAISE FND_API.G_EXC_ERROR;

Line 4119: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);

4115: --DBMS_OUTPUT.PUT_LINE('kpi_id :- '||l_kpi_id||'dimset_id :- '||l_dimset_id||'No of rels are :- '||l_no_rels );
4116: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN
4117: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
4118: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4119: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4120: FND_MSG_PUB.ADD;
4121: ROLLBACK TO sp_before_rel_config;
4122: RAISE FND_API.G_EXC_ERROR;
4123: END IF;