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_DIMENSION_LEVELS_PVT dependencies on BSC_SYS_DIM_LEVELS_TL

Line 23: | Modified Update Query for BSC_SYS_DIM_LEVELS_TL and Insert |

19: | This package creates a dimension level in BSC. |
20: | |
21: | History: |
22: | 04-MAR-2003 PAJOHRI MLS Bug #2721899 |
23: | Modified Update Query for BSC_SYS_DIM_LEVELS_TL and Insert |
24: | Query for BSC_SYS_DIM_LEVELS_TL to handle MLS. |
25: | 22-APR-2003 ADRAO Modified Evaluate_Circular_Relationship() to allow, PMF |
26: | to insert Parent Dim Level being its own child Enh#2901823 |
27: | 07-MAY-2003 Retrieve_Relationship() Added by ADRAO for change Enh#2901823 |

Line 24: | Query for BSC_SYS_DIM_LEVELS_TL to handle MLS. |

20: | |
21: | History: |
22: | 04-MAR-2003 PAJOHRI MLS Bug #2721899 |
23: | Modified Update Query for BSC_SYS_DIM_LEVELS_TL and Insert |
24: | Query for BSC_SYS_DIM_LEVELS_TL to handle MLS. |
25: | 22-APR-2003 ADRAO Modified Evaluate_Circular_Relationship() to allow, PMF |
26: | to insert Parent Dim Level being its own child Enh#2901823 |
27: | 07-MAY-2003 Retrieve_Relationship() Added by ADRAO for change Enh#2901823 |
28: | 13-MAY-2003 PWALI Bug #2942895, SQL BIND COMPLIANCE |

Line 516: g_db_object := 'BSC_SYS_DIM_LEVELS_TL';

512: ,l_Dim_Level_Rec.Bsc_Last_Update_Date --PMD
513: ,p_Dim_Level_Rec.Bsc_Last_Updated_By --PMD
514: ,l_Dim_Level_Rec.Bsc_Last_Update_Date --PMD
515: ,p_Dim_Level_Rec.Bsc_Last_Update_Login); --PMD
516: g_db_object := 'BSC_SYS_DIM_LEVELS_TL';
517: -- Insert values into table bsc_sys_dim_levels_tl.
518: -- Reminder: The last two values are hard coded, need to get them from somewhere,
519: -- talk to Henry.
520: insert into BSC_SYS_DIM_LEVELS_TL( dim_level_id

Line 517: -- Insert values into table bsc_sys_dim_levels_tl.

513: ,p_Dim_Level_Rec.Bsc_Last_Updated_By --PMD
514: ,l_Dim_Level_Rec.Bsc_Last_Update_Date --PMD
515: ,p_Dim_Level_Rec.Bsc_Last_Update_Login); --PMD
516: g_db_object := 'BSC_SYS_DIM_LEVELS_TL';
517: -- Insert values into table bsc_sys_dim_levels_tl.
518: -- Reminder: The last two values are hard coded, need to get them from somewhere,
519: -- talk to Henry.
520: insert into BSC_SYS_DIM_LEVELS_TL( dim_level_id
521: ,language

Line 520: insert into BSC_SYS_DIM_LEVELS_TL( dim_level_id

516: g_db_object := 'BSC_SYS_DIM_LEVELS_TL';
517: -- Insert values into table bsc_sys_dim_levels_tl.
518: -- Reminder: The last two values are hard coded, need to get them from somewhere,
519: -- talk to Henry.
520: insert into BSC_SYS_DIM_LEVELS_TL( dim_level_id
521: ,language
522: ,source_lang
523: ,name
524: ,help

Line 539: FROM BSC_SYS_DIM_LEVELS_TL T

535: FROM FND_LANGUAGES L
536: WHERE L.INSTALLED_FLAG IN ('I', 'B')
537: AND NOT EXISTS
538: ( SELECT NULL
539: FROM BSC_SYS_DIM_LEVELS_TL T
540: WHERE T.DIM_LEVEL_ID = p_Dim_Level_Rec.Bsc_Level_Id
541: AND T.LANGUAGE = L.LANGUAGE_CODE);
542:
543: if (p_commit = FND_API.G_TRUE) then

Line 657: ,BSC_SYS_DIM_LEVELS_TL b

653: ,x_Dim_Level_Rec.Bsc_Last_Updated_By -- PMD
654: ,x_Dim_Level_Rec.Bsc_Last_Update_Date -- PMD
655: ,x_Dim_Level_Rec.Bsc_Last_Update_Login -- PMD
656: from BSC_SYS_DIM_LEVELS_B a
657: ,BSC_SYS_DIM_LEVELS_TL b
658: where a.dim_level_id = b.dim_level_id
659: and a.dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id
660: and b.language = NVL(p_Dim_Level_Rec.Bsc_Language,USERENV('LANG')); --Bug #3528143
661:

Line 845: update BSC_SYS_DIM_LEVELS_TL

841: ,last_update_date = l_Dim_Level_Rec.Bsc_Last_Update_Date -- PMD
842: ,last_update_login = l_Dim_Level_Rec.Bsc_Last_Update_Login -- PMD
843: where dim_level_id = l_Dim_Level_Rec.Bsc_Level_Id;
844:
845: update BSC_SYS_DIM_LEVELS_TL
846: set name = l_Dim_Level_Rec.Bsc_Dim_Level_Long_Name
847: ,help = l_Dim_Level_Rec.Bsc_Dim_Level_Help
848: ,total_disp_name = l_Dim_Level_Rec.Bsc_Dim_Tot_Disp_Name
849: ,comp_disp_name = l_Dim_Level_Rec.Bsc_Dim_Comp_Disp_Name

Line 922: delete from BSC_SYS_DIM_LEVELS_TL

918: SAVEPOINT DeleteBSCDimLevMdPVT;
919: delete from BSC_SYS_DIM_LEVELS_B
920: where dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id;
921:
922: delete from BSC_SYS_DIM_LEVELS_TL
923: where dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id;
924:
925: --PAJOHRI Added 01-JUN-2003
926: -- delete dimensin from groups

Line 2739: UPDATE bsc_sys_dim_levels_tl

2735: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;
2738:
2739: UPDATE bsc_sys_dim_levels_tl
2740: SET name = l_Dim_Level_Rec_Out.Bsc_Dim_Level_Long_Name
2741: ,total_disp_name = l_Dim_Level_Rec_Out.Bsc_Dim_Tot_Disp_Name
2742: ,comp_disp_name = l_Dim_Level_Rec_Out.Bsc_Dim_Comp_Disp_Name
2743: ,help = l_Dim_Level_Rec_Out.Bsc_Dim_Level_Help

Line 2806: UPDATE BSC_SYS_DIM_LEVELS_TL

2802: FROM BSC_SYS_DIM_LEVELS_B
2803: WHERE Short_Name = p_Dim_Level_Rec.Bsc_Level_Short_Name;
2804:
2805:
2806: UPDATE BSC_SYS_DIM_LEVELS_TL
2807: SET NAME = p_dim_level_rec.Bsc_Dim_Level_Long_Name
2808: ,HELP = p_dim_level_rec.Bsc_Dim_Level_Help
2809: ,SOURCE_LANG = p_dim_level_rec.Bsc_Source_Language
2810: WHERE DIM_LEVEL_ID = l_Dim_Level_Id