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

Line 478: BSC_APPS.Init_Bsc_Apps;

474: AND K.parent_level_rel IS NOT NULL
475: AND K.table_relation IS NOT NULL;
476:
477: BEGIN
478: BSC_APPS.Init_Bsc_Apps;
479: x_return_status := FND_API.G_RET_STS_SUCCESS;
480:
481: UPDATE bsc_sys_dim_level_rels
482: SET relation_col = p_Relation_Col

Line 969: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'));

965:
966: --check for not null fields
967: IF (l_dim_obj_name IS NULL) THEN
968: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
969: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'));
970: FND_MSG_PUB.ADD;
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;
973: IF (NOT is_Valid_AlphaNum(l_dim_obj_name)) THEN

Line 976: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'));

972: END IF;
973: IF (NOT is_Valid_AlphaNum(l_dim_obj_name)) THEN
974: FND_MESSAGE.SET_NAME('BSC','BSC_ALPHA_NUM_REQUIRED');
975: FND_MESSAGE.SET_TOKEN('VALUE', l_dim_obj_name);
976: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'));
977: FND_MSG_PUB.ADD;
978: RAISE FND_API.G_EXC_ERROR;
979: END IF;
980: IF (p_display_name IS NULL) THEN

Line 982: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));

978: RAISE FND_API.G_EXC_ERROR;
979: END IF;
980: IF (p_display_name IS NULL) THEN
981: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
982: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));
983: FND_MSG_PUB.ADD;
984: RAISE FND_API.G_EXC_ERROR;
985: END IF;
986: IF (l_application_id IS NULL) THEN

Line 988: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'APPLICATION_ID'));

984: RAISE FND_API.G_EXC_ERROR;
985: END IF;
986: IF (l_application_id IS NULL) THEN
987: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
988: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'APPLICATION_ID'));
989: FND_MSG_PUB.ADD;
990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992: IF (p_data_source IS NULL) THEN

Line 994: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DATA_SOURCE'));

990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992: IF (p_data_source IS NULL) THEN
993: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
994: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DATA_SOURCE'));
995: FND_MSG_PUB.ADD;
996: RAISE FND_API.G_EXC_ERROR;
997: END IF;
998: IF ((p_data_source <> 'BSC') AND (p_data_source <> 'PMF')) THEN

Line 1020: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'));

1016: FROM BIS_LEVELS_VL
1017: WHERE UPPER(short_name) = UPPER(l_dim_obj_name);
1018: IF (l_count > 0) THEN
1019: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1020: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'));
1021: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_dim_obj_name);
1022: FND_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;

Line 1031: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'));

1027: FROM BSC_SYS_DIM_LEVELS_VL
1028: WHERE UPPER(short_name) = UPPER(l_dim_obj_name);
1029: IF (l_count > 0) THEN
1030: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1031: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'));
1032: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_dim_obj_name);
1033: FND_MSG_PUB.ADD;
1034: RAISE FND_API.G_EXC_ERROR;
1035: END IF;

Line 1063: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));

1059: FROM BIS_LEVELS_VL
1060: WHERE UPPER(name) = UPPER(p_display_name);
1061: IF (l_count <> 0) THEN
1062: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1063: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));
1064: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
1065: FND_MSG_PUB.ADD;
1066: RAISE FND_API.G_EXC_ERROR;
1067: END IF;

Line 1187: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'));

1183: END IF;
1184: l_bsc_dim_obj_rec.Bsc_Level_Name := 'BSC_D_'||SUBSTR(l_bsc_dim_obj_rec.Bsc_Level_Name, 1, 21);
1185: IF (NOT is_Valid_Identifier(l_bsc_dim_obj_rec.Bsc_Level_Name)) THEN
1186: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SQL_IDENTIFIER');
1187: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'));
1188: FND_MESSAGE.SET_TOKEN('SQL_VALUE', l_bsc_dim_obj_rec.Bsc_Level_Name);
1189: FND_MSG_PUB.ADD;
1190: RAISE FND_API.G_EXC_ERROR;
1191: END IF;

Line 1257: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'));

1253: END IF;
1254: IF ((l_bis_dim_level_rec.Level_Values_View_Name IS NOT NULL) AND
1255: (NOT is_Valid_Identifier(l_bis_dim_level_rec.Level_Values_View_Name))) THEN
1256: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SQL_IDENTIFIER');
1257: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'));
1258: FND_MESSAGE.SET_TOKEN('SQL_VALUE', l_bis_dim_level_rec.Level_Values_View_Name);
1259: FND_MSG_PUB.ADD;
1260: RAISE FND_API.G_EXC_ERROR;
1261: END IF;

Line 1565: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);

1561: FND_MSG_PUB.Initialize;
1562: x_return_status := FND_API.G_RET_STS_SUCCESS;
1563: IF (p_dim_obj_short_name IS NULL) THEN
1564: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1565: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);
1566: FND_MSG_PUB.ADD;
1567: RAISE FND_API.G_EXC_ERROR;
1568: END IF;
1569: IF (p_dim_short_names IS NOT NULL) THEN

Line 1665: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);

1661: FND_MSG_PUB.Initialize;
1662: x_return_status := FND_API.G_RET_STS_SUCCESS;
1663: IF (p_dim_obj_short_name IS NULL) THEN
1664: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1665: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);
1666: FND_MSG_PUB.ADD;
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669: IF (p_dim_short_names IS NOT NULL) THEN

Line 1830: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);

1826: FND_MSG_PUB.Initialize;
1827: x_return_status := FND_API.G_RET_STS_SUCCESS;
1828: IF (p_dim_obj_short_name IS NULL) THEN
1829: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1830: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);
1831: FND_MSG_PUB.ADD;
1832: RAISE FND_API.G_EXC_ERROR;
1833: END IF;
1834:

Line 2146: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);

2142: l_dim_obj_name := p_dim_obj_short_name;
2143:
2144: IF (l_dim_obj_name IS NULL) THEN
2145: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2146: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);
2147: FND_MSG_PUB.ADD;
2148: RAISE FND_API.G_EXC_ERROR;
2149: END IF;
2150: IF (p_data_source IS NULL) THEN

Line 2152: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DATA_SOURCE'), TRUE);

2148: RAISE FND_API.G_EXC_ERROR;
2149: END IF;
2150: IF (p_data_source IS NULL) THEN
2151: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2152: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DATA_SOURCE'), TRUE);
2153: FND_MSG_PUB.ADD;
2154: RAISE FND_API.G_EXC_ERROR;
2155: END IF;
2156: IF ((p_data_source <> 'BSC') AND (p_data_source <> 'PMF')) THEN

Line 2179: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);

2175: FROM BIS_LEVELS
2176: WHERE short_name = l_dim_obj_name;
2177: IF (l_count = 0) THEN
2178: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2179: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);
2180: FND_MSG_PUB.ADD;
2181: RAISE FND_API.G_EXC_ERROR;
2182: END IF;
2183: --check if short_name exists in the BSC system

Line 2189: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);

2185: FROM BSC_SYS_DIM_LEVELS_B
2186: WHERE Short_Name = l_dim_obj_name;
2187: IF (l_count = 0) THEN
2188: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2189: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);
2190: FND_MSG_PUB.ADD;
2191: RAISE FND_API.G_EXC_ERROR;
2192: END IF;
2193: SELECT dim_level_id

Line 2224: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'), TRUE);

2220: WHERE UPPER(short_name) <> UPPER(l_dim_obj_name)
2221: AND UPPER(name) = UPPER(p_display_name);
2222: IF (l_count <> 0) THEN
2223: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
2224: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'), TRUE);
2225: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
2226: FND_MSG_PUB.ADD;
2227: RAISE FND_API.G_EXC_ERROR;
2228: END IF;

Line 2408: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ABBREVIATION'), TRUE);

2404: AND dim_level_id <> l_bsc_dim_obj_rec.Bsc_Level_Id
2405: AND Source = 'BSC';
2406: IF (l_count <> 0) THEN
2407: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
2408: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ABBREVIATION'), TRUE);
2409: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_bsc_dim_obj_rec.Bsc_Level_Abbreviation);
2410: FND_MSG_PUB.ADD;
2411: RAISE FND_API.G_EXC_ERROR;
2412: END IF;

Line 2469: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'), TRUE);

2465: END IF;
2466: IF ((l_bis_dim_level_rec.Level_Values_View_Name IS NOT NULL) AND
2467: (NOT is_Valid_Identifier(l_bis_dim_level_rec.Level_Values_View_Name))) THEN
2468: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SQL_IDENTIFIER');
2469: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'), TRUE);
2470: FND_MESSAGE.SET_TOKEN('SQL_VALUE', l_bis_dim_level_rec.Level_Values_View_Name);
2471: FND_MSG_PUB.ADD;
2472: RAISE FND_API.G_EXC_ERROR;
2473: END IF;

Line 3053: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);

3049: x_return_status := FND_API.G_RET_STS_SUCCESS;
3050:
3051: IF (p_dim_obj_short_name IS NULL) THEN
3052: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3053: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);
3054: FND_MSG_PUB.ADD;
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057:

Line 3070: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);

3066: END IF;
3067: CLOSE cr_bsc_dim_obj;
3068: IF (l_dim_level_id = -1) THEN
3069: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
3070: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);
3071: FND_MSG_PUB.ADD;
3072: RAISE FND_API.G_EXC_ERROR;
3073: END IF;
3074:

Line 3232: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);

3228: SAVEPOINT DeleteBSCDimObjectPMD;
3229:
3230: IF (p_dim_obj_short_name IS NULL) THEN
3231: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3232: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);
3233: FND_MSG_PUB.ADD;
3234: RAISE FND_API.G_EXC_ERROR;
3235: END IF;
3236: -- CALL PMF'S API

Line 3376: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);

3372: END IF;
3373: END IF;
3374: IF (l_delete_count = 0) THEN
3375: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
3376: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);
3377: FND_MSG_PUB.ADD;
3378: RAISE FND_API.G_EXC_ERROR;
3379: END IF;
3380: IF (p_commit = FND_API.G_TRUE) THEN

Line 3459: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);

3455:
3456: l_dim_Group_id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(BSC_BIS_DIMENSION_PUB.Unassigned_Dim);
3457: IF (p_dim_obj_short_name IS NULL) THEN
3458: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3459: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);
3460: FND_MSG_PUB.ADD;
3461: RAISE FND_API.G_EXC_ERROR;
3462: END IF;
3463:

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

3656: RAISE FND_API.G_EXC_ERROR;
3657: END IF;
3658: IF (p_Dim_Level_Rec.Bsc_Level_Id IS NULL) THEN
3659: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3660: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3661: FND_MSG_PUB.ADD;
3662: RAISE FND_API.G_EXC_ERROR;
3663: END IF;
3664: IF (p_Dim_Level_Rec.Bsc_Level_Name IS NULL) THEN

Line 3666: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'), TRUE);

3662: RAISE FND_API.G_EXC_ERROR;
3663: END IF;
3664: IF (p_Dim_Level_Rec.Bsc_Level_Name IS NULL) THEN
3665: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3666: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'), TRUE);
3667: FND_MSG_PUB.ADD;
3668: RAISE FND_API.G_EXC_ERROR;
3669: END IF;
3670: --Initialize 'l_Dim_Level_Rec' record with the default values

Line 3684: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ABBREVIATION'), TRUE);

3680: p_Dim_Level_Rec.Bsc_Level_Abbreviation := UPPER(p_Dim_Level_Rec.Bsc_Level_Abbreviation);
3681: IF (NOT is_Valid_AlphaNum(p_Dim_Level_Rec.Bsc_Level_Abbreviation)) THEN
3682: FND_MESSAGE.SET_NAME('BSC','BSC_ALPHA_NUM_REQUIRED');
3683: FND_MESSAGE.SET_TOKEN('VALUE', p_Dim_Level_Rec.Bsc_Level_Abbreviation);
3684: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ABBREVIATION'), TRUE);
3685: FND_MSG_PUB.ADD;
3686: RAISE FND_API.G_EXC_ERROR;
3687: END IF;
3688: IF(INSTR(p_Dim_Level_Rec.Bsc_Level_Name, 'BSC_D_') = 1) THEN

Line 3701: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'), TRUE);

3697: RAISE FND_API.G_EXC_ERROR;
3698: END IF;
3699: IF (NOT is_Valid_Identifier(l_Bsc_Level_Name)) THEN
3700: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SQL_IDENTIFIER');
3701: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'), TRUE);
3702: FND_MESSAGE.SET_TOKEN('SQL_VALUE',l_Bsc_Level_Name);
3703: FND_MSG_PUB.ADD;
3704: RAISE FND_API.G_EXC_ERROR;
3705: END IF;

Line 3795: AND Owner = BSC_APPS.get_user_schema('APPS');

3791: SELECT Column_Name
3792: FROM ALL_TAB_COLUMNS
3793: WHERE Table_Name = UPPER(p_Dim_Level_Rec.Bsc_Level_Name)
3794: AND Column_Name LIKE l_prefix
3795: AND Owner = BSC_APPS.get_user_schema('APPS');
3796:
3797: --meastmon Fix bug#3337923 Performance issue: remove UPPER from left part to allow use of indexes
3798: CURSOR allTabCol2 IS
3799: SELECT Column_Name

Line 3806: AND Owner = BSC_APPS.get_user_schema('APPS');

3802: AND (Column_Name LIKE '%DESCRIPTION%'
3803: OR Column_Name LIKE '%NAME%'
3804: OR Column_Name LIKE '%PK')
3805: AND ROWNUM < 2
3806: AND Owner = BSC_APPS.get_user_schema('APPS');
3807:
3808: BEGIN
3809: FND_MSG_PUB.Initialize;
3810: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3827: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);

3823: RAISE FND_API.G_EXC_ERROR;
3824: END IF;
3825: IF (p_Dim_Level_Rec.Bsc_Level_Short_Name IS NULL) THEN
3826: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3827: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);
3828: FND_MSG_PUB.ADD;
3829: RAISE FND_API.G_EXC_ERROR;
3830: END IF;
3831: IF ((p_Dim_Level_Rec.Source IS NULL) OR ((p_Dim_Level_Rec.Source <> 'OLTP') AND (p_Dim_Level_Rec.Source <> 'EDW'))) THEN

Line 3916: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'), TRUE);

3912: p_Dim_Level_Rec.Bsc_Level_View_Name := bsc_utility.get_valid_bsc_master_tbl_name(p_Dim_Level_Rec.Bsc_Level_Short_Name);
3913: END IF;
3914: IF (NOT is_Valid_Identifier(p_Dim_Level_Rec.Bsc_Level_View_Name)) THEN
3915: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SQL_IDENTIFIER');
3916: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'), TRUE);
3917: FND_MESSAGE.SET_TOKEN('SQL_VALUE', p_Dim_Level_Rec.Bsc_Level_View_Name);
3918: FND_MSG_PUB.ADD;
3919: RAISE FND_API.G_EXC_ERROR;
3920: END IF;

Line 4073: BSC_APPS.Init_Bsc_Apps;

4069: FND_MSG_PUB.Initialize;
4070: x_return_status := FND_API.G_RET_STS_SUCCESS;
4071: SAVEPOINT CreateBSCPmfViewPMD;
4072:
4073: BSC_APPS.Init_Bsc_Apps;
4074: IF ((p_Dim_Level_Rec.Bsc_Source IS NULL) OR (p_Dim_Level_Rec.Bsc_Source <> 'PMF')) THEN
4075: RAISE FND_API.G_EXC_ERROR;
4076: END IF;
4077: IF (p_Dim_Level_Rec.Bsc_Level_Short_Name IS NULL) THEN

Line 4079: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);

4075: RAISE FND_API.G_EXC_ERROR;
4076: END IF;
4077: IF (p_Dim_Level_Rec.Bsc_Level_Short_Name IS NULL) THEN
4078: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4079: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);
4080: FND_MSG_PUB.ADD;
4081: RAISE FND_API.G_EXC_ERROR;
4082: END IF;
4083: IF (p_Dim_Level_Rec.Bsc_Level_Pk_Key IS NULL) THEN

Line 4085: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_PK_COL'), TRUE);

4081: RAISE FND_API.G_EXC_ERROR;
4082: END IF;
4083: IF (p_Dim_Level_Rec.Bsc_Level_Pk_Key IS NULL) THEN
4084: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4085: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_PK_COL'), TRUE);
4086: FND_MSG_PUB.ADD;
4087: RAISE FND_API.G_EXC_ERROR;
4088: END IF;
4089: IF (p_Dim_Level_Rec.Bsc_Level_Name_Column IS NULL) THEN

Line 4091: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_COL'), TRUE);

4087: RAISE FND_API.G_EXC_ERROR;
4088: END IF;
4089: IF (p_Dim_Level_Rec.Bsc_Level_Name_Column IS NULL) THEN
4090: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4091: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_COL'), TRUE);
4092: FND_MSG_PUB.ADD;
4093: RAISE FND_API.G_EXC_ERROR;
4094: END IF;
4095: IF (p_Dim_Level_Rec.Bsc_Level_View_Name IS NULL) THEN

Line 4097: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'), TRUE);

4093: RAISE FND_API.G_EXC_ERROR;
4094: END IF;
4095: IF (p_Dim_Level_Rec.Bsc_Level_View_Name IS NULL) THEN
4096: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4097: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'), TRUE);
4098: FND_MSG_PUB.ADD;
4099: RAISE FND_API.G_EXC_ERROR;
4100: END IF;
4101: IF ((p_Dim_Level_Rec.Bsc_Level_Name IS NOT NULL) AND (is_Valid_Identifier(p_Dim_Level_Rec.Bsc_Level_Name))) THEN

Line 4156: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.create_view, p_Dim_Level_Rec.Bsc_Level_View_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4152: UPDATE BSC_SYS_DIM_LEVELS_B
4153: SET Table_Type = 1
4154: WHERE Short_Name = p_Dim_Level_Rec.Bsc_Level_Short_Name;
4155:
4156: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.create_view, p_Dim_Level_Rec.Bsc_Level_View_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4157:
4158: EXCEPTION
4159: --if exception, it means PMF View does not exists,
4160: --in this case update Table_Type = -1, which is a indication of view does not exists

Line 4244: AND OWNER = BSC_APPS.get_user_schema;

4240: FROM ALL_TAB_COLUMNS
4241: WHERE TABLE_NAME = l_master_table
4242: AND column_name NOT IN ('LANGUAGE', 'SOURCE_LANG')
4243: AND column_name IS NOT NULL
4244: AND OWNER = BSC_APPS.get_user_schema;
4245:
4246: l_rollback_ddl_stmts BSC_APPS.t_array_ddl_stmts;
4247: l_num_rollback_ddl_stmts NUMBER := 0;
4248:

Line 4246: l_rollback_ddl_stmts BSC_APPS.t_array_ddl_stmts;

4242: AND column_name NOT IN ('LANGUAGE', 'SOURCE_LANG')
4243: AND column_name IS NOT NULL
4244: AND OWNER = BSC_APPS.get_user_schema;
4245:
4246: l_rollback_ddl_stmts BSC_APPS.t_array_ddl_stmts;
4247: l_num_rollback_ddl_stmts NUMBER := 0;
4248:
4249: BEGIN
4250: FND_MSG_PUB.Initialize;

Line 4254: BSC_APPS.Init_Bsc_Apps;

4250: FND_MSG_PUB.Initialize;
4251: x_return_status := FND_API.G_RET_STS_SUCCESS;
4252: SAVEPOINT CreateBSCMasTabsPMD;
4253:
4254: BSC_APPS.Init_Bsc_Apps;
4255: IF ((p_Dim_Level_Rec.Bsc_Source IS NULL) OR (p_Dim_Level_Rec.Bsc_Source <> 'BSC')) THEN
4256: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DATA_SOURCE');
4257: FND_MSG_PUB.ADD;
4258: RAISE FND_API.G_EXC_ERROR;

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

4258: RAISE FND_API.G_EXC_ERROR;
4259: END IF;
4260: IF (p_Dim_Level_Rec.Bsc_Level_Id IS NULL) THEN
4261: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4262: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
4263: FND_MSG_PUB.ADD;
4264: RAISE FND_API.G_EXC_ERROR;
4265: END IF;
4266: IF (p_Dim_Level_Rec.Bsc_Level_Name IS NULL) THEN

Line 4268: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'), TRUE);

4264: RAISE FND_API.G_EXC_ERROR;
4265: END IF;
4266: IF (p_Dim_Level_Rec.Bsc_Level_Name IS NULL) THEN
4267: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4268: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'), TRUE);
4269: FND_MSG_PUB.ADD;
4270: RAISE FND_API.G_EXC_ERROR;
4271: END IF;
4272: IF (p_Dim_Level_Rec.Bsc_Level_View_Name IS NULL) THEN

Line 4274: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'), TRUE);

4270: RAISE FND_API.G_EXC_ERROR;
4271: END IF;
4272: IF (p_Dim_Level_Rec.Bsc_Level_View_Name IS NULL) THEN
4273: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4274: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'), TRUE);
4275: FND_MSG_PUB.ADD;
4276: RAISE FND_API.G_EXC_ERROR;
4277: END IF;
4278: IF (p_Dim_Level_Rec.Bsc_Level_Abbreviation IS NULL) THEN

Line 4289: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'), TRUE);

4285: l_master_table := 'BSC_D_'||UPPER(p_Dim_Level_Rec.Bsc_Level_Name);
4286:
4287: IF (NOT is_Valid_Identifier(l_master_table)) THEN
4288: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SQL_IDENTIFIER');
4289: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'), TRUE);
4290: FND_MESSAGE.SET_TOKEN('SQL_VALUE', l_master_table);
4291: FND_MSG_PUB.ADD;
4292: RAISE FND_API.G_EXC_ERROR;
4293: END IF;

Line 4327: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4323: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_master_table;
4324:
4325: IF (l_count <> 0) THEN
4326: l_sql_stmt := 'DROP TABLE '||l_master_table;
4327: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4328: END IF;
4329:
4330: -- CHANGED THIS TO REARRANGE THE COLS MASTER TABLES
4331: -- BUG #3081595

Line 4338: ' '||' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;

4334: ' USER_CODE VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'), ' ||
4335: ' NAME VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_Disp_Key_Size||'), '||
4336: ' LANGUAGE VARCHAR2(4) NOT NULL,'||
4337: ' SOURCE_LANG VARCHAR2(4) NOT NULL )'||
4338: ' '||' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4339:
4340: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4341:
4342: -- in case we need to rollback the ddl

Line 4340: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4336: ' LANGUAGE VARCHAR2(4) NOT NULL,'||
4337: ' SOURCE_LANG VARCHAR2(4) NOT NULL )'||
4338: ' '||' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4339:
4340: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4341:
4342: -- in case we need to rollback the ddl
4343: l_num_rollback_ddl_stmts := l_num_rollback_ddl_stmts + 1;
4344: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).sql_stmt := 'DROP TABLE '||l_master_table;

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

4346: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).object_name := l_master_table;
4347:
4348: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||
4349: ' ON '||l_master_table||' (CODE,LANGUAGE) '||' '||
4350: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4351:
4352: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4353:
4354: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828

Line 4352: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4348: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||
4349: ' ON '||l_master_table||' (CODE,LANGUAGE) '||' '||
4350: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4351:
4352: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4353:
4354: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828
4355: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
4356: ' ON '||l_master_table||' (USER_CODE,LANGUAGE) '||' '||

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

4353:
4354: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828
4355: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
4356: ' ON '||l_master_table||' (USER_CODE,LANGUAGE) '||' '||
4357: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4358:
4359: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4360:
4361: l_col_names := NULL;

Line 4359: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4355: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
4356: ' ON '||l_master_table||' (USER_CODE,LANGUAGE) '||' '||
4357: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4358:
4359: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4360:
4361: l_col_names := NULL;
4362: --Bug #3081595
4363: l_col_names := 'USER_CODE, NAME ';

Line 4372: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4368: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_input_table;
4369:
4370: IF (l_count <> 0) THEN
4371: l_sql_stmt := 'DROP TABLE '||l_input_table;
4372: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4373: END IF;
4374: l_sql_stmt := ' CREATE TABLE '||l_input_table||' '||' TABLESPACE '||
4375: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4376: ' AS SELECT '||l_col_names||' FROM '||l_master_table||' WHERE 1 = 2';

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

4371: l_sql_stmt := 'DROP TABLE '||l_input_table;
4372: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4373: END IF;
4374: l_sql_stmt := ' CREATE TABLE '||l_input_table||' '||' TABLESPACE '||
4375: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4376: ' AS SELECT '||l_col_names||' FROM '||l_master_table||' WHERE 1 = 2';
4377:
4378: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4379:

Line 4378: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4374: l_sql_stmt := ' CREATE TABLE '||l_input_table||' '||' TABLESPACE '||
4375: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4376: ' AS SELECT '||l_col_names||' FROM '||l_master_table||' WHERE 1 = 2';
4377:
4378: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4379:
4380: -- in case we need to rollback the ddl
4381: l_num_rollback_ddl_stmts := l_num_rollback_ddl_stmts + 1;
4382: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).sql_stmt := 'DROP TABLE '||l_input_table;

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

4384: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).object_name := l_input_table;
4385:
4386: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_input_table||'_U1 '||
4387: ' ON '||l_input_table||' (USER_CODE) '||' '||
4388: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4389:
4390: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4391:
4392: l_col_names := NULL;

Line 4390: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4386: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_input_table||'_U1 '||
4387: ' ON '||l_input_table||' (USER_CODE) '||' '||
4388: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4389:
4390: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4391:
4392: l_col_names := NULL;
4393: FOR cd IN c_view_cols LOOP
4394: IF (l_col_names IS NULL )THEN

Line 4406: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_view, l_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4402: ' SELECT '||l_col_names||
4403: ' FROM '||l_master_table||
4404: ' WHERE LANGUAGE = USERENV(''LANG''))';
4405:
4406: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_view, l_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4407:
4408: -- in case we need to rollback the ddl
4409: l_num_rollback_ddl_stmts := l_num_rollback_ddl_stmts + 1;
4410: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).sql_stmt := 'DROP VIEW '||l_view_name;

Line 4464: BSC_APPS.Execute_DDL_Stmts_AT(l_rollback_ddl_stmts, l_num_rollback_ddl_stmts, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4460:
4461: x_return_status := FND_API.G_RET_STS_ERROR;
4462:
4463: -- try to rollback ddl stmts
4464: BSC_APPS.Execute_DDL_Stmts_AT(l_rollback_ddl_stmts, l_num_rollback_ddl_stmts, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4465:
4466: RETURN FALSE;
4467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4468: ROLLBACK TO CreateBSCMasTabsPMD;

Line 4480: BSC_APPS.Execute_DDL_Stmts_AT(l_rollback_ddl_stmts, l_num_rollback_ddl_stmts, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4477:
4478:
4479: -- try to rollback ddl stmts
4480: BSC_APPS.Execute_DDL_Stmts_AT(l_rollback_ddl_stmts, l_num_rollback_ddl_stmts, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4481:
4482: RETURN FALSE;
4483: WHEN NO_DATA_FOUND THEN
4484: ROLLBACK TO CreateBSCMasTabsPMD;

Line 4493: BSC_APPS.Execute_DDL_Stmts_AT(l_rollback_ddl_stmts, l_num_rollback_ddl_stmts, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4489: x_msg_data := SQLERRM||' at BSC_BIS_DIM_OBJ_PUB.Create_Bsc_Master_Tabs ';
4490: END IF;
4491:
4492: -- try to rollback ddl stmts
4493: BSC_APPS.Execute_DDL_Stmts_AT(l_rollback_ddl_stmts, l_num_rollback_ddl_stmts, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4494:
4495: RETURN FALSE;
4496: WHEN OTHERS THEN
4497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4507: BSC_APPS.Execute_DDL_Stmts_AT(l_rollback_ddl_stmts, l_num_rollback_ddl_stmts, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4503:
4504: ROLLBACK TO CreateBSCMasTabsPMD;
4505:
4506: -- try to rollback ddl stmts
4507: BSC_APPS.Execute_DDL_Stmts_AT(l_rollback_ddl_stmts, l_num_rollback_ddl_stmts, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4508:
4509: RETURN FALSE;
4510: END Create_Bsc_Master_Tabs;
4511: /*******************************************************************************

Line 4542: AND OWNER = BSC_APPS.get_user_schema;

4538: FROM ALL_TAB_COLUMNS
4539: WHERE TABLE_NAME = l_master_table
4540: AND column_name IS NOT NULL
4541: AND column_name NOT IN ('LANGUAGE', 'SOURCE_LANG')
4542: AND OWNER = BSC_APPS.get_user_schema;
4543:
4544: --cursor to see, if this dimension object is used in many to many relations
4545: CURSOR c_rel_type IS
4546: SELECT parent_dim_level_id

Line 4573: BSC_APPS.Init_Bsc_Apps;

4569: FND_MSG_PUB.Initialize;
4570: x_return_status := FND_API.G_RET_STS_SUCCESS;
4571: SAVEPOINT AlterBSCMasTabsPMD;
4572:
4573: BSC_APPS.Init_Bsc_Apps;
4574: IF ((p_Dim_Level_Rec.Bsc_Source IS NULL) OR (p_Dim_Level_Rec.Bsc_Source <> 'BSC')) THEN
4575: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DATA_SOURCE');
4576: FND_MSG_PUB.ADD;
4577: RAISE FND_API.G_EXC_ERROR;

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

4577: RAISE FND_API.G_EXC_ERROR;
4578: END IF;
4579: IF (p_Dim_Level_Rec.Bsc_Level_Id IS NULL) THEN
4580: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4581: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
4582: FND_MSG_PUB.ADD;
4583: RAISE FND_API.G_EXC_ERROR;
4584: END IF;
4585: IF (p_Dim_Level_Rec.Bsc_Level_Name IS NULL) THEN

Line 4587: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'), TRUE);

4583: RAISE FND_API.G_EXC_ERROR;
4584: END IF;
4585: IF (p_Dim_Level_Rec.Bsc_Level_Name IS NULL) THEN
4586: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4587: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'), TRUE);
4588: FND_MSG_PUB.ADD;
4589: RAISE FND_API.G_EXC_ERROR;
4590: END IF;
4591: IF (p_Dim_Level_Rec.Bsc_Level_View_Name IS NULL) THEN

Line 4593: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'), TRUE);

4589: RAISE FND_API.G_EXC_ERROR;
4590: END IF;
4591: IF (p_Dim_Level_Rec.Bsc_Level_View_Name IS NULL) THEN
4592: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4593: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'), TRUE);
4594: FND_MSG_PUB.ADD;
4595: RAISE FND_API.G_EXC_ERROR;
4596: END IF;
4597: l_master_table := UPPER(p_Dim_Level_Rec.Bsc_Level_Name);

Line 4601: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'), TRUE);

4597: l_master_table := UPPER(p_Dim_Level_Rec.Bsc_Level_Name);
4598:
4599: IF (NOT is_Valid_Identifier(l_master_table)) THEN
4600: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SQL_IDENTIFIER');
4601: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_TAB_NAME'), TRUE);
4602: FND_MESSAGE.SET_TOKEN('SQL_VALUE', l_master_table);
4603: FND_MSG_PUB.ADD;
4604: RAISE FND_API.G_EXC_ERROR;
4605: END IF;

Line 4679: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, p_Dim_Level_Rec_Old.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4675: l_sql_stmt := 'ALTER TABLE '||p_Dim_Level_Rec_Old.Bsc_Level_Name||
4676: ' MODIFY USER_CODE VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') '||
4677: ' MODIFY NAME VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_Disp_Key_Size||') ';
4678:
4679: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, p_Dim_Level_Rec_Old.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4680:
4681:
4682: l_sql_stmt := 'ALTER TABLE BSC_DI_'||p_Dim_Level_Rec_Old.Bsc_Level_Id||' '||
4683: ' MODIFY USER_CODE VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') '||

Line 4686: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, 'BSC_DI_'||p_Dim_Level_Rec_Old.Bsc_Level_Id, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4682: l_sql_stmt := 'ALTER TABLE BSC_DI_'||p_Dim_Level_Rec_Old.Bsc_Level_Id||' '||
4683: ' MODIFY USER_CODE VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') '||
4684: ' MODIFY NAME VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_Disp_Key_Size||') ';
4685:
4686: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, 'BSC_DI_'||p_Dim_Level_Rec_Old.Bsc_Level_Id, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4687: IF ((p_Dim_Level_Rec.Bsc_Level_User_Key_Size <> p_Dim_Level_Rec_Old.Bsc_Level_User_Key_Size)) THEN
4688: FOR cd IN c_db_tables LOOP
4689: l_sql_stmt := ' ALTER TABLE '||cd.Table_Name||
4690: ' MODIFY '||cd.Column_Name||

Line 4692: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, cd.TABLE_NAME, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4688: FOR cd IN c_db_tables LOOP
4689: l_sql_stmt := ' ALTER TABLE '||cd.Table_Name||
4690: ' MODIFY '||cd.Column_Name||
4691: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') ';
4692: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, cd.TABLE_NAME, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4693: END LOOP;
4694: END IF;
4695:
4696: /********************************************************

Line 4711: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4707:
4708: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_master_table;
4709: IF (l_count <> 0) THEN
4710: l_sql_stmt := 'DROP TABLE '||l_master_table;
4711: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4712: END IF;
4713: l_sql_stmt := ' CREATE TABLE '||l_master_table||' '||' TABLESPACE '||
4714: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4715: ' AS SELECT * FROM '||p_Dim_Level_Rec_Old.Bsc_Level_Name;

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

4710: l_sql_stmt := 'DROP TABLE '||l_master_table;
4711: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4712: END IF;
4713: l_sql_stmt := ' CREATE TABLE '||l_master_table||' '||' TABLESPACE '||
4714: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4715: ' AS SELECT * FROM '||p_Dim_Level_Rec_Old.Bsc_Level_Name;
4716:
4717: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4718: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||

Line 4717: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4713: l_sql_stmt := ' CREATE TABLE '||l_master_table||' '||' TABLESPACE '||
4714: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4715: ' AS SELECT * FROM '||p_Dim_Level_Rec_Old.Bsc_Level_Name;
4716:
4717: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4718: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||
4719: ' ON '||l_master_table||' (CODE, LANGUAGE) '||' '||
4720: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.Bsc_Storage_Clause;
4721:

Line 4720: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.Bsc_Storage_Clause;

4716:
4717: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4718: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||
4719: ' ON '||l_master_table||' (CODE, LANGUAGE) '||' '||
4720: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.Bsc_Storage_Clause;
4721:
4722: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4723:
4724: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828

Line 4722: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4718: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||
4719: ' ON '||l_master_table||' (CODE, LANGUAGE) '||' '||
4720: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.Bsc_Storage_Clause;
4721:
4722: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4723:
4724: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828
4725: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
4726: ' ON '||l_master_table||' (USER_CODE, LANGUAGE) '||' '||

Line 4727: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.Bsc_Storage_Clause;

4723:
4724: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828
4725: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
4726: ' ON '||l_master_table||' (USER_CODE, LANGUAGE) '||' '||
4727: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.Bsc_Storage_Clause;
4728: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4729: l_count := 1;
4730: FOR cd IN c_One_To_N_Index LOOP
4731: -- Create a new Non-Unique INDEX for Loader Performance - Bug #3120190

Line 4728: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4724: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828
4725: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
4726: ' ON '||l_master_table||' (USER_CODE, LANGUAGE) '||' '||
4727: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.Bsc_Storage_Clause;
4728: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4729: l_count := 1;
4730: FOR cd IN c_One_To_N_Index LOOP
4731: -- Create a new Non-Unique INDEX for Loader Performance - Bug #3120190
4732:

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

4732:
4733: IF (LENGTH(l_master_table||'_N'||l_count) <= 30) THEN
4734: l_sql_stmt := ' CREATE INDEX '||l_master_table||'_N'||l_count||' '||
4735: ' ON '||l_master_table||' ('||cd.Level_Pk_Col||') '||' '||
4736: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4737:
4738: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4739: l_count := l_count + 1;
4740: ELSE

Line 4738: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4734: l_sql_stmt := ' CREATE INDEX '||l_master_table||'_N'||l_count||' '||
4735: ' ON '||l_master_table||' ('||cd.Level_Pk_Col||') '||' '||
4736: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4737:
4738: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4739: l_count := l_count + 1;
4740: ELSE
4741: EXIT;
4742: END IF;

Line 4746: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, p_Dim_Level_Rec_Old.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4742: END IF;
4743: END LOOP;
4744: l_sql_stmt := 'DROP TABLE '||p_Dim_Level_Rec_Old.Bsc_Level_Name;
4745:
4746: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, p_Dim_Level_Rec_Old.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4747: --update BSC_DB_TABLES_RELS
4748: UPDATE BSC_DB_TABLES_RELS
4749: SET Table_Name = l_master_table
4750: WHERE Source_Table_Name = l_input_table;

Line 4768: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_view, l_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4764: ' SELECT '||l_col_names||
4765: ' FROM '||l_master_table||
4766: ' WHERE LANGUAGE = USERENV(''LANG''))';
4767:
4768: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_view, l_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4769: END IF;
4770: l_flag := BSC_BIS_DIM_OBJ_PUB.Alter_M_By_N_Tables
4771: ( p_Dim_Level_Rec => p_Dim_Level_Rec
4772: , p_Dim_Level_Rec_Old => p_Dim_Level_Rec_Old

Line 4858: l_Tbl_Statements BSC_APPS.Autonomous_Statements_Tbl_Type;

4854: l_sql_stmt VARCHAR2(32000);
4855: l_old_mas_name BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
4856: l_master_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
4857: l_input_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
4858: l_Tbl_Statements BSC_APPS.Autonomous_Statements_Tbl_Type;
4859: e_mlog_exception EXCEPTION;
4860: l_error_msg VARCHAR2(4000);
4861:
4862: CURSOR c_MN_Tables IS

Line 4870: BSC_APPS.Init_Bsc_Apps;

4866: AND Relation_Type = 2;
4867: BEGIN
4868: FND_MSG_PUB.Initialize;
4869: x_return_status := FND_API.G_RET_STS_SUCCESS;
4870: BSC_APPS.Init_Bsc_Apps;
4871:
4872: SAVEPOINT AlterBSCMxNPMD;
4873: IF ((p_Dim_Level_Rec.Bsc_Level_User_Key_Size = p_Dim_Level_Rec_Old.Bsc_Level_User_Key_Size) AND
4874: (UPPER(p_Dim_Level_Rec.Bsc_Level_Abbreviation) = UPPER(p_Dim_Level_Rec_Old.Bsc_Level_Abbreviation)) AND

Line 4917: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4913:
4914: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_master_table;
4915: IF (l_count <> 0) THEN
4916: l_sql_stmt := 'DROP TABLE '||l_master_table;
4917: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4918: END IF;
4919: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
4920: ' WHERE OBJECT_NAME = :1';
4921:

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

4924: x_msg_data := 'Master Table does not exists '||l_old_mas_name;
4925: RAISE FND_API.G_EXC_ERROR;
4926: END IF;
4927: l_sql_stmt := ' CREATE TABLE '||l_master_table||' '||' TABLESPACE '||
4928: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4929: ' AS SELECT * FROM '||l_old_mas_name;
4930:
4931: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4932:

Line 4931: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4927: l_sql_stmt := ' CREATE TABLE '||l_master_table||' '||' TABLESPACE '||
4928: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4929: ' AS SELECT * FROM '||l_old_mas_name;
4930:
4931: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4932:
4933: --meastmon 02-27-2004: Here is missing the sql statement. I found this by casualty. So fixing
4934: -- -----
4935: ---Need to update the following table when there is change in abbrevation bug#4091924

Line 4952: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_old_mas_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4948: END IF;
4949:
4950: l_sql_stmt := 'DROP TABLE '||l_old_mas_name;
4951: -- -----
4952: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_old_mas_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4953:
4954: --update BSC_DB_TABLES_RELS
4955: UPDATE BSC_DB_TABLES_RELS
4956: SET Table_Name = l_master_table

Line 4965: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4961:
4962: l_Tbl_Statements.DELETE;
4963: l_sql_stmt := 'ALTER TABLE '||l_master_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||' NUMBER )';
4964:
4965: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4966: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4967: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4968: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
4969: l_Tbl_Statements(0).x_Statement := l_sql_stmt;

Line 4966: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;

4962: l_Tbl_Statements.DELETE;
4963: l_sql_stmt := 'ALTER TABLE '||l_master_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||' NUMBER )';
4964:
4965: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4966: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4967: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4968: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
4969: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
4970: l_Tbl_Statements(0).x_Object_Name := l_master_table;

Line 4967: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;

4963: l_sql_stmt := 'ALTER TABLE '||l_master_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||' NUMBER )';
4964:
4965: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4966: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4967: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4968: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
4969: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
4970: l_Tbl_Statements(0).x_Object_Name := l_master_table;
4971:

Line 4977: l_Tbl_Statements(1).x_Bsc_Apps_Short_Name := NULL;

4973: p_Dim_Level_Rec.Bsc_Pk_Col||' = '||p_Dim_Level_Rec_Old.Bsc_Pk_Col;
4974:
4975: --EXECUTE IMMEDIATE l_sql_stmt;
4976: l_Tbl_Statements(1).x_Fnd_Apps_Schema := NULL;
4977: l_Tbl_Statements(1).x_Bsc_Apps_Short_Name := NULL;
4978: l_Tbl_Statements(1).x_Statement_Type := NULL;
4979: l_Tbl_Statements(1).x_Statement := l_sql_stmt;
4980: l_Tbl_Statements(1).x_Object_Name := NULL;
4981:

Line 4984: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4980: l_Tbl_Statements(1).x_Object_Name := NULL;
4981:
4982: l_sql_stmt := 'ALTER TABLE '||l_master_table||' DROP COLUMN '||p_Dim_Level_Rec_Old.Bsc_Pk_Col;
4983:
4984: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4985: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4986: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4987: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
4988: l_Tbl_Statements(2).x_Statement := l_sql_stmt;

Line 4985: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;

4981:
4982: l_sql_stmt := 'ALTER TABLE '||l_master_table||' DROP COLUMN '||p_Dim_Level_Rec_Old.Bsc_Pk_Col;
4983:
4984: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4985: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4986: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4987: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
4988: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
4989: l_Tbl_Statements(2).x_Object_Name := l_master_table;

Line 4986: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;

4982: l_sql_stmt := 'ALTER TABLE '||l_master_table||' DROP COLUMN '||p_Dim_Level_Rec_Old.Bsc_Pk_Col;
4983:
4984: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4985: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4986: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4987: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
4988: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
4989: l_Tbl_Statements(2).x_Object_Name := l_master_table;
4990: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);

Line 4990: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);

4986: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4987: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
4988: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
4989: l_Tbl_Statements(2).x_Object_Name := l_master_table;
4990: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);
4991:
4992: l_Tbl_Statements.DELETE;
4993: l_sql_stmt := 'ALTER TABLE '||l_input_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
4994: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';

Line 4996: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4992: l_Tbl_Statements.DELETE;
4993: l_sql_stmt := 'ALTER TABLE '||l_input_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
4994: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';
4995:
4996: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4997: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4998: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4999: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5000: l_Tbl_Statements(0).x_Statement := l_sql_stmt;

Line 4997: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;

4993: l_sql_stmt := 'ALTER TABLE '||l_input_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
4994: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';
4995:
4996: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4997: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4998: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4999: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5000: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
5001: l_Tbl_Statements(0).x_Object_Name := l_master_table;

Line 4998: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;

4994: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';
4995:
4996: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4997: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4998: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4999: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5000: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
5001: l_Tbl_Statements(0).x_Object_Name := l_master_table;
5002:

Line 5008: l_Tbl_Statements(1).x_Bsc_Apps_Short_Name := NULL;

5004: p_Dim_Level_Rec.Bsc_Pk_Col||'_USR = '||p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5005:
5006: --EXECUTE IMMEDIATE l_sql_stmt;
5007: l_Tbl_Statements(1).x_Fnd_Apps_Schema := NULL;
5008: l_Tbl_Statements(1).x_Bsc_Apps_Short_Name := NULL;
5009: l_Tbl_Statements(1).x_Statement_Type := NULL;
5010: l_Tbl_Statements(1).x_Statement := l_sql_stmt;
5011: l_Tbl_Statements(1).x_Object_Name := NULL;
5012:

Line 5015: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5011: l_Tbl_Statements(1).x_Object_Name := NULL;
5012:
5013: l_sql_stmt := 'ALTER TABLE '||l_input_table||' DROP COLUMN '||p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5014:
5015: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5016: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5017: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5018: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5019: l_Tbl_Statements(2).x_Statement := l_sql_stmt;

Line 5016: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;

5012:
5013: l_sql_stmt := 'ALTER TABLE '||l_input_table||' DROP COLUMN '||p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5014:
5015: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5016: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5017: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5018: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5019: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5020: l_Tbl_Statements(2).x_Object_Name := l_master_table;

Line 5017: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;

5013: l_sql_stmt := 'ALTER TABLE '||l_input_table||' DROP COLUMN '||p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5014:
5015: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5016: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5017: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5018: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5019: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5020: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5021: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);

Line 5021: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);

5017: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5018: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5019: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5020: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5021: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);
5022:
5023: ELSIF (p_Dim_Level_Rec.Bsc_Level_User_Key_Size <> p_Dim_Level_Rec_Old.Bsc_Level_User_Key_Size) THEN
5024: l_sql_stmt := ' ALTER TABLE '||l_input_table||
5025: ' MODIFY '||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||

Line 5027: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5023: ELSIF (p_Dim_Level_Rec.Bsc_Level_User_Key_Size <> p_Dim_Level_Rec_Old.Bsc_Level_User_Key_Size) THEN
5024: l_sql_stmt := ' ALTER TABLE '||l_input_table||
5025: ' MODIFY '||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5026: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') ';
5027: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5028: END IF;
5029:
5030: /********************************************************************
5031: Here we need to call the API BSC_SYNC_MVLOGS.Sync_dim_table_mv_log

Line 5117: l_Tbl_Statements BSC_APPS.Autonomous_Statements_Tbl_Type;

5113: l_index_Name VARCHAR2(100) := NULL;
5114: l_index_Count NUMBER;
5115: l_flag BOOLEAN;
5116: l_Create_View BOOLEAN := FALSE;
5117: l_Tbl_Statements BSC_APPS.Autonomous_Statements_Tbl_Type;
5118: e_mlog_exception EXCEPTION;
5119: l_error_msg VARCHAR2(4000);
5120:
5121: --cursor to get the columns for creation of view based on master-table

Line 5128: AND OWNER = BSC_APPS.get_user_schema;

5124: FROM ALL_TAB_COLUMNS
5125: WHERE TABLE_NAME = l_master_table
5126: AND column_name NOT IN ('LANGUAGE', 'SOURCE_LANG')
5127: AND column_name IS NOT NULL
5128: AND OWNER = BSC_APPS.get_user_schema;
5129:
5130: --cursor to know the index on Column
5131: CURSOR c_Parent_Index_Name IS
5132: SELECT Index_Name

Line 5136: AND INDEX_OWNER = BSC_APPS.get_user_schema;

5132: SELECT Index_Name
5133: FROM ALL_IND_COLUMNS
5134: WHERE Table_Name = l_master_table
5135: AND Column_Name = UPPER(p_Dim_Level_Rec_Old.Bsc_Pk_Col)
5136: AND INDEX_OWNER = BSC_APPS.get_user_schema;
5137:
5138: CURSOR c_One_by_N IS
5139: SELECT Dim_Level_Id
5140: FROM BSC_SYS_DIM_LEVEL_RELS

Line 5146: BSC_APPS.Init_Bsc_Apps;

5142: AND relation_type = 1;
5143: BEGIN
5144: FND_MSG_PUB.Initialize;
5145: x_return_status := FND_API.G_RET_STS_SUCCESS;
5146: BSC_APPS.Init_Bsc_Apps;
5147:
5148: SAVEPOINT AlterBSCOnexNPMD;
5149: IF ((p_Dim_Level_Rec.Bsc_Level_User_Key_Size = p_Dim_Level_Rec_Old.Bsc_Level_User_Key_Size) AND
5150: (UPPER(p_Dim_Level_Rec.Bsc_Pk_Col) = UPPER(p_Dim_Level_Rec_Old.Bsc_Pk_Col))) THEN

Line 5199: AND OWNER = BSC_APPS.get_user_schema;

5195: WHILE (l_flag) LOOP
5196: SELECT COUNT(1) INTO l_count
5197: FROM ALL_INDEXES
5198: WHERE INDEX_NAME = l_index_Name
5199: AND OWNER = BSC_APPS.get_user_schema;
5200:
5201: IF (l_count = 0) THEN
5202: l_flag := FALSE;
5203: EXIT;

Line 5214: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5210: END IF;
5211: l_Tbl_Statements.DELETE;
5212: l_sql_stmt := 'ALTER TABLE '||l_master_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||' NUMBER)';
5213:
5214: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5215: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5216: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5217: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5218: l_Tbl_Statements(0).x_Statement := l_sql_stmt;

Line 5215: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;

5211: l_Tbl_Statements.DELETE;
5212: l_sql_stmt := 'ALTER TABLE '||l_master_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||' NUMBER)';
5213:
5214: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5215: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5216: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5217: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5218: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
5219: l_Tbl_Statements(0).x_Object_Name := l_master_table;

Line 5216: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;

5212: l_sql_stmt := 'ALTER TABLE '||l_master_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||' NUMBER)';
5213:
5214: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5215: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5216: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5217: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5218: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
5219: l_Tbl_Statements(0).x_Object_Name := l_master_table;
5220:

Line 5226: l_Tbl_Statements(1).x_Bsc_Apps_Short_Name := NULL;

5222: p_Dim_Level_Rec.Bsc_Pk_Col ||' = '||p_Dim_Level_Rec_Old.Bsc_Pk_Col;
5223:
5224: --EXECUTE IMMEDIATE l_sql_stmt;
5225: l_Tbl_Statements(1).x_Fnd_Apps_Schema := NULL;
5226: l_Tbl_Statements(1).x_Bsc_Apps_Short_Name := NULL;
5227: l_Tbl_Statements(1).x_Statement_Type := NULL;
5228: l_Tbl_Statements(1).x_Statement := l_sql_stmt;
5229: l_Tbl_Statements(1).x_Object_Name := NULL;
5230:

Line 5233: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5229: l_Tbl_Statements(1).x_Object_Name := NULL;
5230:
5231: l_sql_stmt := 'ALTER TABLE '||l_master_table||' DROP COLUMN '||p_Dim_Level_Rec_Old.Bsc_Pk_Col;
5232:
5233: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5234: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5235: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5236: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5237: l_Tbl_Statements(2).x_Statement := l_sql_stmt;

Line 5234: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;

5230:
5231: l_sql_stmt := 'ALTER TABLE '||l_master_table||' DROP COLUMN '||p_Dim_Level_Rec_Old.Bsc_Pk_Col;
5232:
5233: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5234: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5235: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5236: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5237: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5238: l_Tbl_Statements(2).x_Object_Name := l_master_table;

Line 5235: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;

5231: l_sql_stmt := 'ALTER TABLE '||l_master_table||' DROP COLUMN '||p_Dim_Level_Rec_Old.Bsc_Pk_Col;
5232:
5233: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5234: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5235: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5236: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5237: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5238: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5239: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);

Line 5239: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);

5235: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5236: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5237: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5238: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5239: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);
5240:
5241: l_Tbl_Statements.DELETE;
5242: l_sql_stmt := 'ALTER TABLE '||l_master_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5243: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';

Line 5245: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5241: l_Tbl_Statements.DELETE;
5242: l_sql_stmt := 'ALTER TABLE '||l_master_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5243: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';
5244:
5245: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5246: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5247: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5248: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5249: l_Tbl_Statements(0).x_Statement := l_sql_stmt;

Line 5246: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;

5242: l_sql_stmt := 'ALTER TABLE '||l_master_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5243: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';
5244:
5245: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5246: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5247: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5248: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5249: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
5250: l_Tbl_Statements(0).x_Object_Name := l_master_table;

Line 5247: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;

5243: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';
5244:
5245: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5246: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5247: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5248: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5249: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
5250: l_Tbl_Statements(0).x_Object_Name := l_master_table;
5251:

Line 5258: l_Tbl_Statements(1).x_Bsc_Apps_Short_Name := NULL;

5254: p_Dim_Level_Rec.Bsc_Pk_Col||'_USR = '||p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5255:
5256: --EXECUTE IMMEDIATE l_sql_stmt;
5257: l_Tbl_Statements(1).x_Fnd_Apps_Schema := NULL;
5258: l_Tbl_Statements(1).x_Bsc_Apps_Short_Name := NULL;
5259: l_Tbl_Statements(1).x_Statement_Type := NULL;
5260: l_Tbl_Statements(1).x_Statement := l_sql_stmt;
5261: l_Tbl_Statements(1).x_Object_Name := NULL;
5262: l_sql_stmt := 'ALTER TABLE '||l_master_table||' DROP COLUMN '||

Line 5265: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5261: l_Tbl_Statements(1).x_Object_Name := NULL;
5262: l_sql_stmt := 'ALTER TABLE '||l_master_table||' DROP COLUMN '||
5263: p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5264:
5265: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5266: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5267: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5268: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5269: l_Tbl_Statements(2).x_Statement := l_sql_stmt;

Line 5266: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;

5262: l_sql_stmt := 'ALTER TABLE '||l_master_table||' DROP COLUMN '||
5263: p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5264:
5265: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5266: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5267: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5268: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5269: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5270: l_Tbl_Statements(2).x_Object_Name := l_master_table;

Line 5267: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;

5263: p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5264:
5265: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5266: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5267: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5268: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5269: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5270: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5271: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);

Line 5271: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);

5267: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5268: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5269: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5270: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5271: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);
5272:
5273: l_Tbl_Statements.DELETE;
5274: l_sql_stmt := 'ALTER TABLE '||l_input_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5275: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';

Line 5277: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5273: l_Tbl_Statements.DELETE;
5274: l_sql_stmt := 'ALTER TABLE '||l_input_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5275: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';
5276:
5277: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5278: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5279: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5280: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5281: l_Tbl_Statements(0).x_Statement := l_sql_stmt;

Line 5278: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;

5274: l_sql_stmt := 'ALTER TABLE '||l_input_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5275: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';
5276:
5277: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5278: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5279: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5280: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5281: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
5282: l_Tbl_Statements(0).x_Object_Name := l_master_table;

Line 5279: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;

5275: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';
5276:
5277: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5278: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5279: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5280: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5281: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
5282: l_Tbl_Statements(0).x_Object_Name := l_master_table;
5283:

Line 5289: l_Tbl_Statements(1).x_Bsc_Apps_Short_Name := NULL;

5285: p_Dim_Level_Rec.Bsc_Pk_Col||'_USR = '||p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5286:
5287: --EXECUTE IMMEDIATE l_sql_stmt;
5288: l_Tbl_Statements(1).x_Fnd_Apps_Schema := NULL;
5289: l_Tbl_Statements(1).x_Bsc_Apps_Short_Name := NULL;
5290: l_Tbl_Statements(1).x_Statement_Type := NULL;
5291: l_Tbl_Statements(1).x_Statement := l_sql_stmt;
5292: l_Tbl_Statements(1).x_Object_Name := NULL;
5293:

Line 5298: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5294:
5295: l_sql_stmt := 'ALTER TABLE '||l_input_table||' DROP COLUMN '||
5296: p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5297:
5298: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5299: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5300: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5301: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5302: l_Tbl_Statements(2).x_Statement := l_sql_stmt;

Line 5299: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;

5295: l_sql_stmt := 'ALTER TABLE '||l_input_table||' DROP COLUMN '||
5296: p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5297:
5298: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5299: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5300: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5301: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5302: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5303: l_Tbl_Statements(2).x_Object_Name := l_master_table;

Line 5300: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;

5296: p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5297:
5298: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5299: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5300: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5301: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5302: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5303: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5304: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);

Line 5304: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);

5300: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5301: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5302: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5303: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5304: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);
5305:
5306: /********************************************************
5307: Here we need to update the relation_col column in BSC_SYS_DIM_LEVEL_RELS
5308: table whenever we are changing the level_pk_col of the parent.

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

5316: --Due to DB restrictions, index can't be created if length is > 30 characters.
5317: IF (LENGTH(l_index_Name) <= 30) THEN
5318: l_sql_stmt := ' CREATE INDEX '||l_index_Name||' '||
5319: ' ON '||l_master_table||' ('||p_Dim_Level_Rec.Bsc_Pk_Col||') '||' '||
5320: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
5321: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5322: END IF;
5323: ELSIF (p_Dim_Level_Rec.Bsc_Level_User_Key_Size <> p_Dim_Level_Rec_Old.Bsc_Level_User_Key_Size) THEN
5324: l_Create_View := TRUE;

Line 5321: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5317: IF (LENGTH(l_index_Name) <= 30) THEN
5318: l_sql_stmt := ' CREATE INDEX '||l_index_Name||' '||
5319: ' ON '||l_master_table||' ('||p_Dim_Level_Rec.Bsc_Pk_Col||') '||' '||
5320: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
5321: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5322: END IF;
5323: ELSIF (p_Dim_Level_Rec.Bsc_Level_User_Key_Size <> p_Dim_Level_Rec_Old.Bsc_Level_User_Key_Size) THEN
5324: l_Create_View := TRUE;
5325:

Line 5330: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5326: l_sql_stmt := ' ALTER TABLE '||l_master_table||
5327: ' MODIFY '||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5328: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') ';
5329:
5330: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5331:
5332: l_sql_stmt := ' ALTER TABLE '||l_input_table||
5333: ' MODIFY '||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5334: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') ';

Line 5336: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5332: l_sql_stmt := ' ALTER TABLE '||l_input_table||
5333: ' MODIFY '||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5334: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') ';
5335:
5336: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5337: END IF;
5338: IF (l_Create_View) THEN
5339: l_col_names := NULL;
5340: FOR cd IN c_view_cols LOOP

Line 5353: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_view, l_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5349: ' SELECT '||l_col_names||
5350: ' FROM '||l_master_table||
5351: ' WHERE LANGUAGE = USERENV(''LANG''))';
5352:
5353: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_view, l_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5354: END IF;
5355:
5356: --Now synch up the MLOG tables with the new User_Key_Size and Disp_Key_Size
5357:

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

5849: END IF;
5850: END LOOP;
5851: IF((l_is_found = FALSE) AND (dim_objs_array.COUNT >= BSC_BIS_KPI_MEAS_PUB.Config_Limit_Dim)) THEN
5852: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
5853: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
5854: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
5855: FND_MSG_PUB.ADD;
5856: RAISE FND_API.G_EXC_ERROR;
5857: END IF;

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

5850: END LOOP;
5851: IF((l_is_found = FALSE) AND (dim_objs_array.COUNT >= BSC_BIS_KPI_MEAS_PUB.Config_Limit_Dim)) THEN
5852: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
5853: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
5854: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
5855: FND_MSG_PUB.ADD;
5856: RAISE FND_API.G_EXC_ERROR;
5857: END IF;
5858: END LOOP;

Line 6132: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_view, PMF_EDW.Level_Table_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

6128: SET Table_Type = -1
6129: WHERE Short_Name = PMF_EDW.Short_Name;
6130:
6131: l_sql := 'DROP VIEW ' || PMF_EDW.Level_Table_Name;
6132: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_view, PMF_EDW.Level_Table_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
6133: END LOOP;
6134: EXCEPTION
6135: WHEN OTHERS THEN
6136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7091: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_PK_COL'), TRUE);

7087: l_Level_Pk_Col := 'BSC_'||l_Level_Pk_Col;
7088: END IF;
7089: ELSIF (NOT is_Valid_Identifier(l_Level_Pk_Col)) THEN
7090: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SQL_IDENTIFIER');
7091: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_PK_COL'), TRUE);
7092: FND_MESSAGE.SET_TOKEN('SQL_VALUE', l_Level_Pk_Col);
7093: FND_MSG_PUB.ADD;
7094: RAISE FND_API.G_EXC_ERROR;
7095: END IF;