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_UPDATE_DIM dependencies on BSC_UPDATE_DIM

Line 1: PACKAGE BODY BSC_UPDATE_DIM AS

1: PACKAGE BODY BSC_UPDATE_DIM AS
2: /* $Header: BSCDDIMB.pls 120.16.12010000.2 2008/08/11 09:33:25 sirukull ship $ */
3:
4: /*===========================================================================+
5: | FUNCTION Any_Item_Changed_Any_Relation

Line 343: x_source => 'BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables');

339:
340: EXCEPTION
341: WHEN e_unexpected_error THEN
342: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),
343: x_source => 'BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables');
344: RETURN FALSE;
345:
346: WHEN OTHERS THEN
347: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 348: x_source => 'BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables');

344: RETURN FALSE;
345:
346: WHEN OTHERS THEN
347: BSC_MESSAGE.Add(x_message => SQLERRM,
348: x_source => 'BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables');
349: RETURN FALSE;
350: END Create_AW_Dim_Temp_Tables;
351:
352:

Line 503: x_source => 'BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables');

499:
500: EXCEPTION
501: WHEN e_unexpected_error THEN
502: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),
503: x_source => 'BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables');
504: RETURN FALSE;
505:
506: WHEN OTHERS THEN
507: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 508: x_source => 'BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables');

504: RETURN FALSE;
505:
506: WHEN OTHERS THEN
507: BSC_MESSAGE.Add(x_message => SQLERRM,
508: x_source => 'BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables');
509: RETURN FALSE;
510: END Create_Dbi_Dim_Temp_Tables;
511:
512:

Line 715: x_source => 'BSC_UPDATE_DIM.Delete_Codes_Cascade');

711: RETURN FALSE;
712:
713: WHEN OTHERS THEN
714: BSC_MESSAGE.Add(x_message => SQLERRM,
715: x_source => 'BSC_UPDATE_DIM.Delete_Codes_Cascade');
716: RETURN FALSE;
717:
718: END Delete_Codes_Cascade;
719:

Line 814: x_source => 'BSC_UPDATE_DIM.Delete_Codes_CascadeMN');

810:
811: EXCEPTION
812: WHEN OTHERS THEN
813: BSC_MESSAGE.Add(x_message => SQLERRM,
814: x_source => 'BSC_UPDATE_DIM.Delete_Codes_CascadeMN');
815: RETURN FALSE;
816:
817: END Delete_Codes_CascadeMN;
818:

Line 888: x_source => 'BSC_UPDATE_DIM.Delete_Key_Values_In_Tables');

884:
885: EXCEPTION
886: WHEN OTHERS THEN
887: BSC_MESSAGE.Add(x_message => SQLERRM,
888: x_source => 'BSC_UPDATE_DIM.Delete_Key_Values_In_Tables');
889: RETURN FALSE;
890:
891: END Delete_Key_Values_In_Tables;
892:

Line 900: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

896: +============================================================================*/
897: FUNCTION Denorm_Eni_Item_Vbh_Cat RETURN BOOLEAN IS
898:
899: l_sql VARCHAR2(32000);
900: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
901: l_yes VARCHAR2(3);
902:
903: TYPE t_cursor IS REF CURSOR;
904: l_cursor t_cursor;

Line 1043: x_source => 'BSC_UPDATE_DIM.Denorm_Eni_Item_Vbh_Cat');

1039:
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: BSC_MESSAGE.Add(x_message => SQLERRM,
1043: x_source => 'BSC_UPDATE_DIM.Denorm_Eni_Item_Vbh_Cat');
1044: RETURN FALSE;
1045: END Denorm_Eni_Item_Vbh_Cat;
1046:
1047:

Line 1056: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

1052:
1053: e_unexpected_error EXCEPTION;
1054:
1055: l_sql VARCHAR2(32000);
1056: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
1057:
1058: TYPE t_cursor IS REF CURSOR;
1059: l_cursor t_cursor;
1060:

Line 1224: x_source => 'BSC_UPDATE_DIM.Denorm_Eni_Item_Itm_Cat');

1220:
1221: EXCEPTION
1222: WHEN e_unexpected_error THEN
1223: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),
1224: x_source => 'BSC_UPDATE_DIM.Denorm_Eni_Item_Itm_Cat');
1225: RETURN FALSE;
1226:
1227: WHEN OTHERS THEN
1228: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 1229: x_source => 'BSC_UPDATE_DIM.Denorm_Eni_Item_Itm_Cat');

1225: RETURN FALSE;
1226:
1227: WHEN OTHERS THEN
1228: BSC_MESSAGE.Add(x_message => SQLERRM,
1229: x_source => 'BSC_UPDATE_DIM.Denorm_Eni_Item_Itm_Cat');
1230: RETURN FALSE;
1231: END Denorm_Eni_Item_Itm_Cat;
1232:
1233:

Line 1240: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

1236: +============================================================================*/
1237: FUNCTION Denorm_Hri_Per_Usrdr_H RETURN BOOLEAN IS
1238:
1239: l_sql VARCHAR2(32000);
1240: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
1241: l_lst_cols VARCHAR2(32000);
1242: l_lst_src_cols VARCHAR2(32000);
1243:
1244: l_dim_obj_type VARCHAR2(80);

Line 1356: x_source => 'BSC_UPDATE_DIM.Denorm_Hri_Per_Usrdr_H');

1352:
1353: EXCEPTION
1354: WHEN OTHERS THEN
1355: BSC_MESSAGE.Add(x_message => SQLERRM,
1356: x_source => 'BSC_UPDATE_DIM.Denorm_Hri_Per_Usrdr_H');
1357: RETURN FALSE;
1358: END Denorm_Hri_Per_Usrdr_H;
1359:
1360:

Line 1368: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

1364: FUNCTION Denorm_Pji_Organizations RETURN BOOLEAN IS
1365: e_unexpected_error EXCEPTION;
1366:
1367: l_sql VARCHAR2(32000);
1368: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
1369:
1370: TYPE t_cursor IS REF CURSOR;
1371: l_cursor t_cursor;
1372:

Line 1531: x_source => 'BSC_UPDATE_DIM.Denorm_Pji_Organizations');

1527:
1528: EXCEPTION
1529: WHEN e_unexpected_error THEN
1530: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),
1531: x_source => 'BSC_UPDATE_DIM.Denorm_Pji_Organizations');
1532: RETURN FALSE;
1533:
1534: WHEN OTHERS THEN
1535: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 1536: x_source => 'BSC_UPDATE_DIM.Denorm_Pji_Organizations');

1532: RETURN FALSE;
1533:
1534: WHEN OTHERS THEN
1535: BSC_MESSAGE.Add(x_message => SQLERRM,
1536: x_source => 'BSC_UPDATE_DIM.Denorm_Pji_Organizations');
1537: RETURN FALSE;
1538: END Denorm_Pji_Organizations;
1539:
1540:

Line 1617: x_dbi_dim_data OUT NOCOPY BSC_UPDATE_DIM.t_array_dbi_dim_data

1613: /*===========================================================================+
1614: | PROCEDURE Get_All_Dbi_Dim_Data
1615: +============================================================================*/
1616: PROCEDURE Get_All_Dbi_Dim_Data(
1617: x_dbi_dim_data OUT NOCOPY BSC_UPDATE_DIM.t_array_dbi_dim_data
1618: ) IS
1619: l_i NUMBER;
1620: BEGIN
1621:

Line 1770: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

1766: ORDER BY p.level_pk_col;
1767:
1768: l_num_parent_columns NUMBER;
1769: l_parent_column VARCHAR2(50);
1770: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
1771:
1772: BEGIN
1773: l_num_parent_columns := 0;
1774:

Line 1828: x_dbi_dim_data OUT NOCOPY BSC_UPDATE_DIM.t_dbi_dim_data

1824: | PROCEDURE Get_Dbi_Dim_Data
1825: +============================================================================*/
1826: PROCEDURE Get_Dbi_Dim_Data(
1827: x_dim_short_name IN VARCHAR2,
1828: x_dbi_dim_data OUT NOCOPY BSC_UPDATE_DIM.t_dbi_dim_data
1829: ) IS
1830:
1831: l_i NUMBER;
1832:

Line 1867: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

1863: h_sql VARCHAR2(32700);
1864:
1865: h_short_name VARCHAR2(50);
1866: h_source VARCHAR2(10);
1867: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
1868:
1869: BEGIN
1870: h_where_indics := NULL;
1871: h_sql := NULL;

Line 1902: x_source => 'BSC_UPDATE_DIM.Get_Dbi_Dims_Kpis');

1898:
1899: EXCEPTION
1900: WHEN OTHERS THEN
1901: BSC_MESSAGE.Add(x_message => SQLERRM,
1902: x_source => 'BSC_UPDATE_DIM.Get_Dbi_Dims_Kpis');
1903: RETURN FALSE;
1904:
1905: END Get_Dbi_Dims_Kpis;
1906:

Line 3312: x_source => 'BSC_UPDATE_DIM.Insert_Children_Denorm_Table');

3308: RETURN TRUE;
3309: EXCEPTION
3310: WHEN OTHERS THEN
3311: BSC_MESSAGE.Add(x_message => l_sql,
3312: x_source => 'BSC_UPDATE_DIM.Insert_Children_Denorm_Table');
3313: BSC_MESSAGE.Add(x_message => SQLERRM,
3314: x_source => 'BSC_UPDATE_DIM.Insert_Children_Denorm_Table');
3315: RETURN FALSE;
3316:

Line 3314: x_source => 'BSC_UPDATE_DIM.Insert_Children_Denorm_Table');

3310: WHEN OTHERS THEN
3311: BSC_MESSAGE.Add(x_message => l_sql,
3312: x_source => 'BSC_UPDATE_DIM.Insert_Children_Denorm_Table');
3313: BSC_MESSAGE.Add(x_message => SQLERRM,
3314: x_source => 'BSC_UPDATE_DIM.Insert_Children_Denorm_Table');
3315: RETURN FALSE;
3316:
3317: END Insert_Children_Denorm_Table;
3318:

Line 3726: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN

3722:
3723: --AW_INTEGRATION: We need to load the dimension into AW even that the dimension
3724: -- input table is empty
3725: h_dim_table_type := Get_Dim_Table_Type(x_dim_table);
3726: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
3727: IF Dimension_Used_In_AW_Kpi(x_dim_table) THEN
3728: h_dim_level_list.delete;
3729: h_dim_level_list(1) := x_dim_table;
3730: bsc_aw_load.load_dim(

Line 3917: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

3913: ) RETURN BOOLEAN IS
3914:
3915: e_unexpected_error EXCEPTION;
3916:
3917: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
3918: l_sql VARCHAR2(32000);
3919: l_i NUMBER;
3920: l_lst_select VARCHAR2(8000);
3921: l_lst_select_src VARCHAR2(8000);

Line 4247: x_source => 'BSC_UPDATE_DIM.Refresh_Dbi_Dimension_Table');

4243:
4244: EXCEPTION
4245: WHEN e_unexpected_error THEN
4246: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),
4247: x_source => 'BSC_UPDATE_DIM.Refresh_Dbi_Dimension_Table');
4248: RETURN FALSE;
4249:
4250: WHEN OTHERS THEN
4251: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 4252: x_source => 'BSC_UPDATE_DIM.Refresh_Dbi_Dimension_Table');

4248: RETURN FALSE;
4249:
4250: WHEN OTHERS THEN
4251: BSC_MESSAGE.Add(x_message => SQLERRM,
4252: x_source => 'BSC_UPDATE_DIM.Refresh_Dbi_Dimension_Table');
4253: RETURN FALSE;
4254:
4255: END Refresh_Dbi_Dimension_Table;
4256:

Line 4332: x_source => 'BSC_UPDATE_DIM.Refresh_Dbi_Dimension',

4328: ROLLBACK;
4329:
4330: BSC_MESSAGE.flush;
4331: BSC_MESSAGE.Add(x_message => SQLERRM,
4332: x_source => 'BSC_UPDATE_DIM.Refresh_Dbi_Dimension',
4333: x_mode => 'I');
4334: COMMIT;
4335:
4336: BSC_UPDATE_LOG.Write_Errors_To_Log;

Line 4524: x_source => 'BSC_UPDATE_DIM.Refresh_Denorm_Table');

4520:
4521: EXCEPTION
4522: WHEN OTHERS THEN
4523: BSC_MESSAGE.Add(x_message => SQLERRM,
4524: x_source => 'BSC_UPDATE_DIM.Refresh_Denorm_Table');
4525: RETURN FALSE;
4526: END Refresh_Denorm_Table;
4527:
4528:

Line 4705: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimension');

4701:
4702: EXCEPTION
4703: WHEN e_unexpected_error THEN
4704: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_REFRESH_EDW_DIM_FAILED'),
4705: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimension');
4706: RETURN FALSE;
4707:
4708: WHEN OTHERS THEN
4709: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 4710: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimension');

4706: RETURN FALSE;
4707:
4708: WHEN OTHERS THEN
4709: BSC_MESSAGE.Add(x_message => SQLERRM,
4710: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimension');
4711: RETURN FALSE;
4712: END Refresh_EDW_Dimension;
4713:
4714:

Line 4791: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimensions');

4787:
4788: EXCEPTION
4789: WHEN e_unexpected_error THEN
4790: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_REFRESH_EDW_DIM_FAILED'),
4791: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimensions');
4792: RETURN FALSE;
4793:
4794: WHEN OTHERS THEN
4795: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 4796: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimensions');

4792: RETURN FALSE;
4793:
4794: WHEN OTHERS THEN
4795: BSC_MESSAGE.Add(x_message => SQLERRM,
4796: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimensions');
4797: RETURN FALSE;
4798:
4799: END Refresh_EDW_Dimensions;
4800:

Line 4869: x_source => 'BSC_UPDATE_DIM.Sync_Sec_Assigments');

4865:
4866: EXCEPTION
4867: WHEN OTHERS THEN
4868: BSC_MESSAGE.Add(x_message => SQLERRM,
4869: x_source => 'BSC_UPDATE_DIM.Sync_Sec_Assigments');
4870: RETURN FALSE;
4871:
4872: END Sync_Sec_Assigments;
4873:

Line 5074: x_source => 'BSC_UPDATE_DIM.Validate_Input_Table');

5070:
5071: EXCEPTION
5072: WHEN e_unexpected_error THEN
5073: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_ITABLE_VALID_FAILED'),
5074: x_source => 'BSC_UPDATE_DIM.Validate_Input_Table');
5075: RETURN NULL;
5076:
5077: WHEN OTHERS THEN
5078: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 5079: x_source => 'BSC_UPDATE_DIM.Validate_Input_Table');

5075: RETURN NULL;
5076:
5077: WHEN OTHERS THEN
5078: BSC_MESSAGE.Add(x_message => SQLERRM,
5079: x_source => 'BSC_UPDATE_DIM.Validate_Input_Table');
5080: RETURN NULL;
5081: END Validate_Input_Table;
5082:
5083:

Line 5185: x_source => 'BSC_UPDATE_DIM.WriteRemovedKeyItems');

5181:
5182: EXCEPTION
5183: WHEN OTHERS THEN
5184: BSC_MESSAGE.Add(x_message => SQLERRM,
5185: x_source => 'BSC_UPDATE_DIM.WriteRemovedKeyItems');
5186: RETURN FALSE;
5187:
5188: END WriteRemovedKeyItems;
5189:

Line 5208: END BSC_UPDATE_DIM;

5204: null;
5205: end;
5206:
5207:
5208: END BSC_UPDATE_DIM;