APPS.BIS_PMF_MIGRATION_PVT dependencies on BIS_INDICATOR_DIMENSIONS

Line 32: REM | bis_indicator_dimensions using the dim level |

28: REM | c_targetlvls in MIGRATE_PERFORMANCE_MEASURES API|
29: REM | accordingly changed |
30: REM | 03-JUN-2004 ankgoel Modified for bug#3583357. Added procedures for |
31: REM | re-sequencing dimensions in |
32: REM | bis_indicator_dimensions using the dim level |
33: REM | order in bis_target_levels. |
34: REM | 21-MAR-2005 ankagarw bug#4235732 - changing count(*) to count(1) |
35: REM | 19-OCT-2005 ppandey Enh 4618419- SQL Literal Fix |
36: REM | 15-DEC-2005 ankgoel Bug 4879417- Execute dynamic SQL with a NULL check |

Line 71: FROM bis_indicator_dimensions BIS_IND,

67: RETURN BOOLEAN
68: IS
69: CURSOR c_dim_dim_levels(p_dim_level_id NUMBER, p_indicator_id NUMBER) IS
70: SELECT sequence_no
71: FROM bis_indicator_dimensions BIS_IND,
72: bis_levels BIS_LVL
73: WHERE BIS_IND.dimension_id = BIS_LVL.dimension_id
74: AND BIS_IND.indicator_id = p_indicator_id
75: AND BIS_LVL.level_id = p_dim_level_id;

Line 111: UPDATE bis_indicator_dimensions

107: )
108: IS
109: BEGIN
110: IF(p_dim_level_id IS NOT NULL) THEN
111: UPDATE bis_indicator_dimensions
112: SET sequence_no = p_sequence_no
113: ,last_update_date = SYSDATE
114: WHERE indicator_id = p_indicator_id
115: AND dimension_id = get_dimension_id(p_dim_level_id);

Line 239: bis_indicator_dimensions

235: )
236: IS
237: CURSOR c_dimcount(p_measure_id IN NUMBER) IS
238: SELECT count(1) FROM
239: bis_indicator_dimensions
240: WHERE indicator_id = p_measure_id;
241: l_reseuenced_dimensions_array BIS_PMF_MIGRATION_PVT.resequenced_dimensions_array;
242: l_dimcount NUMBER;
243: BEGIN

Line 638: UPDATE bis_indicator_dimensions

634: --EXIT;
635: GOTO skip_record;
636: ELSE
637: --if (c_rec.indicator_id < 995) THEN
638: UPDATE bis_indicator_dimensions
639: SET sequence_no = l_dummy_value
640: WHERE dimension_id=l_Reseq_dims(l_count).dim_id AND
641: indicator_id=c_rec.indicator_id;
642: --END IF;

Line 652: UPDATE bis_indicator_dimensions

648: EXIT;
649: ELSE
650: --if (c_rec.indicator_id > 995) THEN
651: l_indicator_id := c_rec.indicator_id;
652: UPDATE bis_indicator_dimensions
653: SET sequence_no= l_reseq_dims(l_count).seq_no
654: WHERE dimension_id = l_reseq_dims(l_count).dim_id AND
655: indicator_id = c_Rec.indicator_id;
656: --END IF;