DBA Data[Home] [Help]

APPS.BIS_PMF_MIGRATION_PVT dependencies on BIS_INDICATORS

Line 103: PROCEDURE update_bis_indicators (

99: RETURN TRUE;
100: END need_resequence;
101: --
102:
103: PROCEDURE update_bis_indicators (
104: p_indicator_id IN NUMBER
105: ,p_dim_level_id IN NUMBER
106: ,p_sequence_no IN NUMBER
107: )

Line 120: END update_bis_indicators;

116: END IF;
117: EXCEPTION
118: WHEN OTHERS THEN
119: ROLLBACK;
120: END update_bis_indicators;
121:
122: PROCEDURE resequence_ind_dimensions (
123: p_indicator_id IN NUMBER
124: )

Line 178: update_bis_indicators(p_indicator_id, c_tl_rec.dimension1_level_id, 1);

174: END IF;
175:
176: IF (l_flag_resequence = TRUE) THEN
177:
178: update_bis_indicators(p_indicator_id, c_tl_rec.dimension1_level_id, 1);
179: update_bis_indicators(p_indicator_id, c_tl_rec.dimension2_level_id, 2);
180: update_bis_indicators(p_indicator_id, c_tl_rec.dimension3_level_id, 3);
181: update_bis_indicators(p_indicator_id, c_tl_rec.dimension4_level_id, 4);
182: update_bis_indicators(p_indicator_id, c_tl_rec.dimension5_level_id, 5);

Line 179: update_bis_indicators(p_indicator_id, c_tl_rec.dimension2_level_id, 2);

175:
176: IF (l_flag_resequence = TRUE) THEN
177:
178: update_bis_indicators(p_indicator_id, c_tl_rec.dimension1_level_id, 1);
179: update_bis_indicators(p_indicator_id, c_tl_rec.dimension2_level_id, 2);
180: update_bis_indicators(p_indicator_id, c_tl_rec.dimension3_level_id, 3);
181: update_bis_indicators(p_indicator_id, c_tl_rec.dimension4_level_id, 4);
182: update_bis_indicators(p_indicator_id, c_tl_rec.dimension5_level_id, 5);
183: update_bis_indicators(p_indicator_id, c_tl_rec.dimension6_level_id, 6);

Line 180: update_bis_indicators(p_indicator_id, c_tl_rec.dimension3_level_id, 3);

176: IF (l_flag_resequence = TRUE) THEN
177:
178: update_bis_indicators(p_indicator_id, c_tl_rec.dimension1_level_id, 1);
179: update_bis_indicators(p_indicator_id, c_tl_rec.dimension2_level_id, 2);
180: update_bis_indicators(p_indicator_id, c_tl_rec.dimension3_level_id, 3);
181: update_bis_indicators(p_indicator_id, c_tl_rec.dimension4_level_id, 4);
182: update_bis_indicators(p_indicator_id, c_tl_rec.dimension5_level_id, 5);
183: update_bis_indicators(p_indicator_id, c_tl_rec.dimension6_level_id, 6);
184: update_bis_indicators(p_indicator_id, c_tl_rec.dimension7_level_id, 7);

Line 181: update_bis_indicators(p_indicator_id, c_tl_rec.dimension4_level_id, 4);

177:
178: update_bis_indicators(p_indicator_id, c_tl_rec.dimension1_level_id, 1);
179: update_bis_indicators(p_indicator_id, c_tl_rec.dimension2_level_id, 2);
180: update_bis_indicators(p_indicator_id, c_tl_rec.dimension3_level_id, 3);
181: update_bis_indicators(p_indicator_id, c_tl_rec.dimension4_level_id, 4);
182: update_bis_indicators(p_indicator_id, c_tl_rec.dimension5_level_id, 5);
183: update_bis_indicators(p_indicator_id, c_tl_rec.dimension6_level_id, 6);
184: update_bis_indicators(p_indicator_id, c_tl_rec.dimension7_level_id, 7);
185:

Line 182: update_bis_indicators(p_indicator_id, c_tl_rec.dimension5_level_id, 5);

178: update_bis_indicators(p_indicator_id, c_tl_rec.dimension1_level_id, 1);
179: update_bis_indicators(p_indicator_id, c_tl_rec.dimension2_level_id, 2);
180: update_bis_indicators(p_indicator_id, c_tl_rec.dimension3_level_id, 3);
181: update_bis_indicators(p_indicator_id, c_tl_rec.dimension4_level_id, 4);
182: update_bis_indicators(p_indicator_id, c_tl_rec.dimension5_level_id, 5);
183: update_bis_indicators(p_indicator_id, c_tl_rec.dimension6_level_id, 6);
184: update_bis_indicators(p_indicator_id, c_tl_rec.dimension7_level_id, 7);
185:
186: END IF;

Line 183: update_bis_indicators(p_indicator_id, c_tl_rec.dimension6_level_id, 6);

179: update_bis_indicators(p_indicator_id, c_tl_rec.dimension2_level_id, 2);
180: update_bis_indicators(p_indicator_id, c_tl_rec.dimension3_level_id, 3);
181: update_bis_indicators(p_indicator_id, c_tl_rec.dimension4_level_id, 4);
182: update_bis_indicators(p_indicator_id, c_tl_rec.dimension5_level_id, 5);
183: update_bis_indicators(p_indicator_id, c_tl_rec.dimension6_level_id, 6);
184: update_bis_indicators(p_indicator_id, c_tl_rec.dimension7_level_id, 7);
185:
186: END IF;
187: END IF;

Line 184: update_bis_indicators(p_indicator_id, c_tl_rec.dimension7_level_id, 7);

180: update_bis_indicators(p_indicator_id, c_tl_rec.dimension3_level_id, 3);
181: update_bis_indicators(p_indicator_id, c_tl_rec.dimension4_level_id, 4);
182: update_bis_indicators(p_indicator_id, c_tl_rec.dimension5_level_id, 5);
183: update_bis_indicators(p_indicator_id, c_tl_rec.dimension6_level_id, 6);
184: update_bis_indicators(p_indicator_id, c_tl_rec.dimension7_level_id, 7);
185:
186: END IF;
187: END IF;
188: CLOSE c_target_level;

Line 549: l_indicator_id BIS_INDICATORS.INDICATOR_ID%TYPE;

545: l_dummy_value NUMBER := 990;
546: l_dimlevel_count NUMBER;
547: l_dim_count NUMBER;
548: l_dim_levelvalue_count NUMBER;
549: l_indicator_id BIS_INDICATORS.INDICATOR_ID%TYPE;
550: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
551: l_sequence_no NUMBER;
552: l_dim_level_id NUMBER;
553: l_dim_level_short_name VARCHAR2(32000);