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.BIS_PMF_MIGRATION_PUB dependencies on BIS_PMF_MIGRATION_PUB

Line 1: PACKAGE BODY BIS_PMF_MIGRATION_PUB AS

1: PACKAGE BODY BIS_PMF_MIGRATION_PUB AS
2: /* $Header: BISPMIGB.pls 120.1 2005/10/21 07:08:36 ppandey noship $ */
3: --
4: /*
5: REM +=======================================================================+

Line 48: p_target_level_rec IN BIS_PMF_MIGRATION_PUB.target_level_rec

44: null;
45: END GET_DIMENSION_ID;
46: --
47: PROCEDURE RESEQUENCE_DIMENSION_LEVELS(
48: p_target_level_rec IN BIS_PMF_MIGRATION_PUB.target_level_rec
49: ,x_resequenced_dimensions OUT NOCOPY BIS_PMF_MIGRATION_PUB.resequenced_dimensions_array
50: ,x_dim_count OUT NOCOPY NUMBER
51: ,x_return_status OUT NOCOPY NUMBER
52: )

Line 49: ,x_resequenced_dimensions OUT NOCOPY BIS_PMF_MIGRATION_PUB.resequenced_dimensions_array

45: END GET_DIMENSION_ID;
46: --
47: PROCEDURE RESEQUENCE_DIMENSION_LEVELS(
48: p_target_level_rec IN BIS_PMF_MIGRATION_PUB.target_level_rec
49: ,x_resequenced_dimensions OUT NOCOPY BIS_PMF_MIGRATION_PUB.resequenced_dimensions_array
50: ,x_dim_count OUT NOCOPY NUMBER
51: ,x_return_status OUT NOCOPY NUMBER
52: )
53: IS

Line 58: l_reseuenced_dimensions_array BIS_PMF_MIGRATION_PUB.resequenced_dimensions_array;

54: CURSOR c_dimcount(p_measure_id IN NUMBER) IS
55: SELECT count(1) FROM
56: bis_indicator_dimensions
57: WHERE indicator_id = p_measure_id;
58: l_reseuenced_dimensions_array BIS_PMF_MIGRATION_PUB.resequenced_dimensions_array;
59: l_dimcount NUMBER;
60: BEGIN
61: OPEN c_dimcount(p_target_level_rec.measure_id);
62: FETCH c_dimcount INTO l_dimcount;

Line 78: x_resequenced_dimensions(1).dim_id := bis_pmf_migration_pub.get_dimension_id (

74: FOR l_count IN 1..l_dimcount LOOP
75: x_resequenced_dimensions(l_count).dim_level_col := 'dimension'||l_count||'_level_id';
76: IF (l_count = 1) THEN
77: x_resequenced_dimensions(1).dim_level_col_val := p_target_level_rec.dimension1_levelid;
78: x_resequenced_dimensions(1).dim_id := bis_pmf_migration_pub.get_dimension_id (
79: p_target_level_rec.dimension1_levelid);
80: x_Resequenced_dimensions(1).seq_no := l_count;
81: END IF;
82: IF (l_count=2) THEN

Line 84: x_resequenced_dimensions(2).dim_id := bis_pmf_migration_pub.get_dimension_id (

80: x_Resequenced_dimensions(1).seq_no := l_count;
81: END IF;
82: IF (l_count=2) THEN
83: x_resequenced_dimensions(2).dim_level_col_val := p_target_level_rec.dimension2_levelid;
84: x_resequenced_dimensions(2).dim_id := bis_pmf_migration_pub.get_dimension_id (
85: p_target_level_rec.dimension2_levelid);
86: x_Resequenced_dimensions(2).seq_no := l_count;
87: END IF;
88: IF (l_count=3) THEN

Line 90: x_resequenced_dimensions(3).dim_id := bis_pmf_migration_pub.get_dimension_id (

86: x_Resequenced_dimensions(2).seq_no := l_count;
87: END IF;
88: IF (l_count=3) THEN
89: x_resequenced_dimensions(3).dim_level_col_val := p_target_level_rec.dimension3_levelid;
90: x_resequenced_dimensions(3).dim_id := bis_pmf_migration_pub.get_dimension_id (
91: p_target_level_rec.dimension3_levelid);
92: x_Resequenced_dimensions(3).seq_no := l_count;
93: END IF;
94: IF (l_count=4) THEN

Line 96: x_resequenced_dimensions(4).dim_id := bis_pmf_migration_pub.get_dimension_id (

92: x_Resequenced_dimensions(3).seq_no := l_count;
93: END IF;
94: IF (l_count=4) THEN
95: x_resequenced_dimensions(4).dim_level_col_val := p_target_level_rec.dimension4_levelid;
96: x_resequenced_dimensions(4).dim_id := bis_pmf_migration_pub.get_dimension_id (
97: p_target_level_rec.dimension4_levelid);
98: x_Resequenced_dimensions(4).seq_no := l_count;
99: END IF;
100: IF (l_count=5) THEN

Line 102: x_resequenced_dimensions(5).dim_id := bis_pmf_migration_pub.get_dimension_id (

98: x_Resequenced_dimensions(4).seq_no := l_count;
99: END IF;
100: IF (l_count=5) THEN
101: x_resequenced_dimensions(5).dim_level_col_val := p_target_level_rec.dimension5_levelid;
102: x_resequenced_dimensions(5).dim_id := bis_pmf_migration_pub.get_dimension_id (
103: p_target_level_rec.dimension5_levelid);
104: x_Resequenced_dimensions(5).seq_no := l_count;
105: END IF;
106: END LOOP;

Line 112: x_resequenced_dimensions(l_dimcount).dim_id := bis_pmf_migration_pub.get_dimension_id (

108: l_dimcount := l_dimcount + 1;
109: IF (l_dimcount <= 7) THEN
110: x_resequenced_dimensions(l_dimcount).dim_level_col := 'dimension'||l_dimcount||'_level_id';
111: x_resequenced_dimensions(l_dimcount).dim_level_col_val := p_target_level_rec.org_levelid;
112: x_resequenced_dimensions(l_dimcount).dim_id := bis_pmf_migration_pub.get_dimension_id (
113: p_target_level_rec.org_levelid);
114: x_Resequenced_dimensions(l_dimcount).seq_no := l_dimcount;
115: l_dimcount := l_dimcount + 1;
116: x_resequenced_dimensions(l_dimcount).dim_level_col := 'dimension'||l_dimcount||'_level_id';

Line 118: x_resequenced_dimensions(l_dimcount).dim_id := bis_pmf_migration_pub.get_dimension_id (

114: x_Resequenced_dimensions(l_dimcount).seq_no := l_dimcount;
115: l_dimcount := l_dimcount + 1;
116: x_resequenced_dimensions(l_dimcount).dim_level_col := 'dimension'||l_dimcount||'_level_id';
117: x_resequenced_dimensions(l_dimcount).dim_level_col_val := p_target_level_rec.time_levelid;
118: x_resequenced_dimensions(l_dimcount).dim_id := bis_pmf_migration_pub.get_dimension_id (
119: p_target_level_rec.time_levelid);
120: x_Resequenced_dimensions(l_dimcount).seq_no := l_dimcount;
121: l_dimcount := l_dimcount +1;
122: FOR l_count IN l_dimcount..7 LOOP

Line 135: p_target_rec IN BIS_PMF_MIGRATION_PUB.target_rec

131: x_return_status := -1;
132: END RESEQUENCE_DIMENSION_LEVELS;
133: --
134: PROCEDURE RESEQUENCE_TARGET_LEVEL_VALUES(
135: p_target_rec IN BIS_PMF_MIGRATION_PUB.target_rec
136: ,p_dim_count IN NUMBER
137: ,x_reseq_target_values OUT NOCOPY BIS_PMF_MIGRATION_PUB.reseq_target_values_arr
138: ,x_return_Status OUT NOCOPY NUMBER
139: )

Line 137: ,x_reseq_target_values OUT NOCOPY BIS_PMF_MIGRATION_PUB.reseq_target_values_arr

133: --
134: PROCEDURE RESEQUENCE_TARGET_LEVEL_VALUES(
135: p_target_rec IN BIS_PMF_MIGRATION_PUB.target_rec
136: ,p_dim_count IN NUMBER
137: ,x_reseq_target_values OUT NOCOPY BIS_PMF_MIGRATION_PUB.reseq_target_values_arr
138: ,x_return_Status OUT NOCOPY NUMBER
139: )
140: IS
141: l_dim_levelcount NUMBER ;

Line 243: l_target_level_rec BIS_PMF_MIGRATION_PUB.target_level_rec;

239: ,dimension1_level_value, dimension2_level_value, dimension3_level_value
240: ,dimension4_level_value, dimension5_level_value
241: FROM bis_target_values
242: WHERE target_level_id = p_target_level_id;
243: l_target_level_rec BIS_PMF_MIGRATION_PUB.target_level_rec;
244: l_reseq_dims BIS_PMF_MIGRATION_PUB.resequenced_dimensions_Array;
245: l_target_rec BIS_PMF_MIGRATION_PUB.target_rec;
246: l_reseq_target_values BIS_PMF_MIGRATION_PUB.reseq_target_values_arr;
247: l_return_status NUMBER;

Line 244: l_reseq_dims BIS_PMF_MIGRATION_PUB.resequenced_dimensions_Array;

240: ,dimension4_level_value, dimension5_level_value
241: FROM bis_target_values
242: WHERE target_level_id = p_target_level_id;
243: l_target_level_rec BIS_PMF_MIGRATION_PUB.target_level_rec;
244: l_reseq_dims BIS_PMF_MIGRATION_PUB.resequenced_dimensions_Array;
245: l_target_rec BIS_PMF_MIGRATION_PUB.target_rec;
246: l_reseq_target_values BIS_PMF_MIGRATION_PUB.reseq_target_values_arr;
247: l_return_status NUMBER;
248: l_sqlstmt VARCHAR2(32000);

Line 245: l_target_rec BIS_PMF_MIGRATION_PUB.target_rec;

241: FROM bis_target_values
242: WHERE target_level_id = p_target_level_id;
243: l_target_level_rec BIS_PMF_MIGRATION_PUB.target_level_rec;
244: l_reseq_dims BIS_PMF_MIGRATION_PUB.resequenced_dimensions_Array;
245: l_target_rec BIS_PMF_MIGRATION_PUB.target_rec;
246: l_reseq_target_values BIS_PMF_MIGRATION_PUB.reseq_target_values_arr;
247: l_return_status NUMBER;
248: l_sqlstmt VARCHAR2(32000);
249: l_sqlstmt1 VARCHAR2(32000);

Line 246: l_reseq_target_values BIS_PMF_MIGRATION_PUB.reseq_target_values_arr;

242: WHERE target_level_id = p_target_level_id;
243: l_target_level_rec BIS_PMF_MIGRATION_PUB.target_level_rec;
244: l_reseq_dims BIS_PMF_MIGRATION_PUB.resequenced_dimensions_Array;
245: l_target_rec BIS_PMF_MIGRATION_PUB.target_rec;
246: l_reseq_target_values BIS_PMF_MIGRATION_PUB.reseq_target_values_arr;
247: l_return_status NUMBER;
248: l_sqlstmt VARCHAR2(32000);
249: l_sqlstmt1 VARCHAR2(32000);
250: l_count NUMBER := 1;

Line 289: BIS_PMF_MIGRATION_PUB.resequence_dimension_levels

285: END IF;
286: IF (c_rec.dimension5_level_id IS NOT NULL) THEN
287: l_dimlevel_count := l_dimlevel_count+1;
288: END IF;
289: BIS_PMF_MIGRATION_PUB.resequence_dimension_levels
290: (p_target_level_rec => l_target_level_rec
291: ,x_resequenced_dimensions => l_reseq_dims
292: ,x_dim_count => l_dim_count
293: ,x_return_status => l_return_status

Line 343: BIS_PMF_MIGRATION_PUB.resequence_target_level_values(

339: l_target_rec.dimension2_level_value := c_targetrec.dimension2_level_value;
340: l_target_rec.dimension3_level_value := c_targetrec.dimension3_level_value;
341: l_target_rec.dimension4_level_value := c_targetrec.dimension4_level_value;
342: l_Target_rec.dimension5_level_value := c_targetrec.dimension5_level_value;
343: BIS_PMF_MIGRATION_PUB.resequence_target_level_values(
344: p_target_rec => l_target_rec
345: ,p_dim_count => l_dim_count
346: ,x_reseq_target_values => l_reseq_target_values
347: ,x_return_Status => l_return_status

Line 376: END BIS_PMF_MIGRATION_PUB;

372: ROLLBACK;
373: x_return_Status := SQLCODE;
374: END MIGRATE_PERFORMANCE_MEASURES;
375:
376: END BIS_PMF_MIGRATION_PUB;
377: -- SHOW ERRORS