[Home] [Help]
59: REM | 08-APR-04 ankgoel Modified for bug#3557236 |
60: REM | 27-MAY-04 ankgoel Modified for bug#3610655 |
61: REM | 03-JUN-04 ankgoel Modified for bug#3583357. Added procedure call |
62: REM | for re-sequencing dimensions in |
63: REM | bis_indicator_dimensions using the dim level |
64: REM | order in bis_target_levels. |
65: REM | 27-JUL-04 sawu Resolved WHO column info based on p_owner |
66: REM | 02-SEP-04 sawu Bug#3859267: added isColumnMappedAlready(), |
67: REM | isSourceColumnMappedAlready() and |
325: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
326:
327: l_login_id := fnd_global.LOGIN_ID;
328:
329: insert into bis_indicator_dimensions
330: (
331: INDICATOR_ID
332: , Dimension_ID
333: , SEQUENCE_NO
1885:
1886: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1887: l_login_id := fnd_global.LOGIN_ID;
1888:
1889: UPDATE bis_indicator_dimensions
1890: set
1891: Dimension_ID = p_dimension_id
1892: , CREATION_DATE = SYSDATE
1893: , CREATED_BY = l_user_id
2657:
2658: -- ankgoel: bug#3922308: Now that the user can update the actual data source
2659: -- for a measure, however the new souce having the same set of dimensions,
2660: -- it may happen that the order of set of dimensions is modified.
2661: -- Get dimensions from the original record in that order, so that bis_indicator_dimensions
2662: -- will still have the same sequence of dimensions.
2663: -- This will be done only if the measure has an existing summary level.
2664: IF ((l_count > 0) AND (p_Measure_rec.is_validate <> FND_API.G_FALSE)) THEN
2665: GetOriginalDimensions( p_Measure_Rec_Orig => l_Measure_Rec_Orig
2721: , x_error_Tbl => x_error_Tbl
2722: );
2723:
2724: -- delete all the dimension links and reinsert the new ones
2725: delete from bis_indicator_dimensions
2726: where indicator_id = l_measure_rec.Measure_id;
2727:
2728: Create_Indicator_Dimensions(l_measure_rec,p_owner,x_return_status,x_error_tbl);
2729:
2971: , x_error_Tbl => x_error_Tbl
2972: );
2973:
2974: -- delete all the dimension links and reinsert the new ones
2975: delete from bis_indicator_dimensions
2976: where indicator_id = l_measure_rec.Measure_id;
2977:
2978: --Changed the call to call the overloaded api with Org and Time
2979: Create_Indicator_Dimensions
3096: where indicator_id = p_Measure_Rec.Measure_Id;
3097:
3098: -- mdamle 4/23/2003 - PMD - Measure Definer - When a measure is created
3099: -- from PMD, dimensions will not be created within those pages. Hence, add the check.
3100: select count(1) into l_dcount from bis_indicator_dimensions
3101: where indicator_id = p_Measure_Rec.Measure_Id;
3102: if (l_dcount > 0) then
3103: delete from bis_indicator_dimensions
3104: where indicator_id = p_Measure_Rec.Measure_Id;
3099: -- from PMD, dimensions will not be created within those pages. Hence, add the check.
3100: select count(1) into l_dcount from bis_indicator_dimensions
3101: where indicator_id = p_Measure_Rec.Measure_Id;
3102: if (l_dcount > 0) then
3103: delete from bis_indicator_dimensions
3104: where indicator_id = p_Measure_Rec.Measure_Id;
3105: end if;
3106:
3107: delete from bis_indicators_tl
4375: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4376:
4377: cursor ind_dim(p_measure_id number) is
4378: select id.dimension_id
4379: from bis_indicator_dimensions id
4380: where id.indicator_id = p_measure_id
4381: order by id.sequence_no;
4382:
4383: BEGIN
5096:
5097: UPDATE bis_indicators_tl SET last_updated_by = 1 , created_by = 1
5098: WHERE indicator_id = i.indicator_id;
5099:
5100: UPDATE bis_indicator_dimensions SET last_updated_by = 1 , created_by = 1
5101: WHERE indicator_id = i.indicator_id;
5102:
5103: END LOOP;
5104: