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_GROUPS_PVT dependencies on BSC_SYS_DIM_GROUPS_TL

Line 23: | Changed BSC_SYS_DIM_GROUPS_TL to BSC_SYS_DIM_GROUPS_VL in |

19: | This package creates a Dimension Group. |
20: | |
21: | History: |
22: | 04-MAR-2003 PAJOHRI MLS Bug #2721899 |
23: | Changed BSC_SYS_DIM_GROUPS_TL to BSC_SYS_DIM_GROUPS_VL in |
24: | select query. |
25: | 29-MAY-03 All Enhancement Phase I- Functions user group short_name if no id |
26: | 07-JUN-03 mahrao Modified for ALL enhancement |
27: | 13-JUN-03 ADEULGAO modified for BUG# 2878840 |

Line 123: g_db_object := 'BSC_SYS_DIM_GROUPS_TL';

119:
120: -- Get the next ID value for the current group.
121: -- Bug#2878840
122:
123: g_db_object := 'BSC_SYS_DIM_GROUPS_TL';
124:
125: -- PMD
126: if l_Dim_Grp_Rec.Bsc_Created_By is null then
127: l_Dim_Grp_Rec.Bsc_Created_By := 0;

Line 136: -- Insert pertaining values into table bsc_sys_dim_groups_tl.

132: end if;
133: -- PMD
134:
135: l_Dim_Grp_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Grp_Rec.Bsc_Last_Update_Date, SYSDATE);
136: -- Insert pertaining values into table bsc_sys_dim_groups_tl.
137: insert into BSC_SYS_DIM_GROUPS_TL( dim_group_id
138: ,language
139: ,source_lang
140: ,name

Line 137: insert into BSC_SYS_DIM_GROUPS_TL( dim_group_id

133: -- PMD
134:
135: l_Dim_Grp_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Grp_Rec.Bsc_Last_Update_Date, SYSDATE);
136: -- Insert pertaining values into table bsc_sys_dim_groups_tl.
137: insert into BSC_SYS_DIM_GROUPS_TL( dim_group_id
138: ,language
139: ,source_lang
140: ,name
141: ,short_name

Line 161: from BSC_SYS_DIM_GROUPS_TL T

157: from FND_LANGUAGES L
158: where L.INSTALLED_FLAG in ('I', 'B')
159: and not exists
160: (select NULL
161: from BSC_SYS_DIM_GROUPS_TL T
162: where T.dim_group_id = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id
163: and T.LANGUAGE = L.LANGUAGE_CODE);
164:
165: if (p_commit = FND_API.G_TRUE) then

Line 302: FROM BSC_SYS_DIM_GROUPS_TL

298:
299: CURSOR c_dim_lvls_by_group (p_grp_short_name VARCHAR2)
300: IS
301: SELECT dim_group_id
302: FROM BSC_SYS_DIM_GROUPS_TL
303: WHERE SHORT_NAME = p_grp_short_name;
304:
305: begin
306: SAVEPOINT UpdateBSCDimGrpPVT;

Line 359: update BSC_SYS_DIM_GROUPS_TL

355: -- PMD
356:
357: l_Dim_Grp_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Grp_Rec.Bsc_Last_Update_Date, SYSDATE);
358: IF (p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name IS NOT NULL) THEN
359: update BSC_SYS_DIM_GROUPS_TL
360: set name = p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name
361: ,source_lang = userenv('LANG')
362: ,last_updated_by = l_Dim_Grp_Rec.Bsc_Last_Updated_By
363: ,last_update_date = l_Dim_Grp_Rec.Bsc_Last_Update_Date

Line 445: FROM BSC_SYS_DIM_GROUPS_TL

441:
442: CURSOR c_dim_lvls_by_group (p_grp_short_name VARCHAR2)
443: IS
444: SELECT dim_group_id
445: FROM BSC_SYS_DIM_GROUPS_TL
446: WHERE SHORT_NAME = p_grp_short_name;
447:
448: begin
449: SAVEPOINT DeleteBSCDimGrpPVT;

Line 483: from BSC_SYS_DIM_GROUPS_TL

479: -- if id and shortname both are null then check that name is not null
480: if l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name is not null then
481: select count(dim_group_id)
482: into l_count
483: from BSC_SYS_DIM_GROUPS_TL
484: where name = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name;
485: if l_count = 0 then
486: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_NAME');
487: FND_MESSAGE.SET_TOKEN('BSC_GROUP_NAME', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);

Line 511: delete from BSC_SYS_DIM_GROUPS_TL

507: into l_count
508: from BSC_SYS_DIM_LEVELS_BY_GROUP
509: where dim_group_id = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id;
510: if l_count = 0 then
511: delete from BSC_SYS_DIM_GROUPS_TL
512: where dim_group_id = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id;
513: end if;
514:
515: if (p_commit = FND_API.G_TRUE) then

Line 595: FROM BSC_SYS_DIM_GROUPS_TL

591:
592: CURSOR c_dim_lvls_by_group (p_grp_short_name VARCHAR2)
593: IS
594: SELECT dim_group_id
595: FROM BSC_SYS_DIM_GROUPS_TL
596: WHERE SHORT_NAME = p_grp_short_name;
597:
598: begin
599: SAVEPOINT CreateBSCDimLevInGrpPVT;

Line 634: from BSC_SYS_DIM_GROUPS_TL

630: -- if id and short name is null then check that name is not null
631: if l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name is not null then
632: select count(dim_group_id)
633: into l_count
634: from BSC_SYS_DIM_GROUPS_TL
635: where name = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name;
636: if l_count = 0 then
637: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_NAME');
638: FND_MESSAGE.SET_TOKEN('BSC_GROUP_NAME', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);

Line 796: -- As SHORT_NAME column that's being added to bsc_sys_dim_groups_tl table

792: g_db_object := 'Retrieve_Dim_Levels_In_Group';
793: -- Code added for ALL start here
794: -- PMF passes dimension level short name and dimension short name.
795: -- dim_level_id is found from bsc_sys_dim_levels_tl table.
796: -- As SHORT_NAME column that's being added to bsc_sys_dim_groups_tl table
797: -- is not populated, for ALL enhancement, query on BSC_SYS_DIM_LEVELS_BY_GROUP
798: -- is based only on dim_level_id.
799: -- This is required for PMF ALL enhancement (phase1).
800: SELECT DISTINCT dim_level_index

Line 868: FROM BSC_SYS_DIM_GROUPS_TL

864:
865: CURSOR c_dim_lvls_by_group (p_grp_short_name VARCHAR2)
866: IS
867: SELECT dim_group_id
868: FROM BSC_SYS_DIM_GROUPS_TL
869: WHERE SHORT_NAME = p_grp_short_name;
870:
871: begin
872: SAVEPOINT UpdateBSCDimLevInGrpPVT;

Line 904: from BSC_SYS_DIM_GROUPS_TL

900: -- if id is null then check that name is not null
901: if p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name is not null then
902: select count(dim_group_id)
903: into l_count
904: from BSC_SYS_DIM_GROUPS_TL
905: where name = p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name;
906: if l_count = 0 then
907: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_NAME');
908: FND_MESSAGE.SET_TOKEN('BSC_GROUP_NAME', p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);

Line 1073: FROM BSC_SYS_DIM_GROUPS_TL

1069:
1070: CURSOR c_dim_lvls_by_group (p_grp_short_name VARCHAR2)
1071: IS
1072: SELECT dim_group_id
1073: FROM BSC_SYS_DIM_GROUPS_TL
1074: WHERE SHORT_NAME = p_grp_short_name;
1075:
1076: begin
1077: SAVEPOINT DeleteBSCDimLevInGrpPVT;

Line 1112: from BSC_SYS_DIM_GROUPS_TL

1108: -- if id and shortname both are null then check that name is not null
1109: if l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name is not null then
1110: select count(dim_group_id)
1111: into l_count
1112: from BSC_SYS_DIM_GROUPS_TL
1113: where name = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name;
1114: if l_count = 0 then
1115: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_NAME');
1116: FND_MESSAGE.SET_TOKEN('BSC_GROUP_NAME', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);

Line 1218: from BSC_SYS_DIM_GROUPS_TL

1214:
1215: BEGIN
1216: Select distinct DIM_GROUP_ID
1217: into v_Id
1218: from BSC_SYS_DIM_GROUPS_TL
1219: where SHORT_NAME = p_Short_Name;
1220: RETURN v_Id;
1221:
1222: EXCEPTION

Line 1258: UPDATE bsc_sys_dim_groups_tl

1254: END IF;
1255:
1256: l_Dim_Grp_rec.Bsc_Last_Update_Date := NVL(p_Dim_Grp_Rec.Bsc_Last_Update_Date, SYSDATE);
1257:
1258: UPDATE bsc_sys_dim_groups_tl
1259: SET name = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name
1260: ,source_lang = userenv('LANG')
1261: ,last_updated_by = NVL(l_Dim_Grp_Rec.Bsc_Last_Updated_By, p_Dim_Grp_Rec.Bsc_Last_Updated_By)
1262: ,last_update_date = l_Dim_Grp_rec.Bsc_Last_Update_Date

Line 1390: UPDATE BSC_SYS_DIM_GROUPS_TL

1386: x_return_status := FND_API.G_RET_STS_SUCCESS;
1387:
1388: FND_MSG_PUB.Initialize;
1389:
1390: UPDATE BSC_SYS_DIM_GROUPS_TL
1391: SET NAME = p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name
1392: ,SOURCE_LANG = p_Dim_Grp_Rec.Bsc_Source_Language
1393: ,LAST_UPDATE_DATE = p_Dim_Grp_Rec.Bsc_Last_Update_Date
1394: WHERE SHORT_NAME = p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Short_Name