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_PVT dependencies on BIS_PMF_MIGRATION_PVT

Line 1: PACKAGE BODY BIS_PMF_MIGRATION_PVT AS

1: PACKAGE BODY BIS_PMF_MIGRATION_PVT AS
2: /* $Header: BISVMIGB.pls 120.2 2005/12/15 03:23:41 ankgoel noship $ */
3: --
4: /*
5: REM +=======================================================================+

Line 141: l_target_level_rec BIS_PMF_MIGRATION_PVT.target_level_rec;

137: AND time_level_id IS NOT NULL
138: AND rownum < 2;
139:
140: l_flag_resequence BOOLEAN := FALSE;
141: l_target_level_rec BIS_PMF_MIGRATION_PVT.target_level_rec;
142: c_tl_rec c_target_level%ROWTYPE;
143:
144: BEGIN
145:

Line 231: p_target_level_rec IN BIS_PMF_MIGRATION_PVT.target_level_rec

227: END migrate_indicator_dimensions;
228: --
229:
230: PROCEDURE RESEQUENCE_DIMENSION_LEVELS(
231: p_target_level_rec IN BIS_PMF_MIGRATION_PVT.target_level_rec
232: ,x_resequenced_dimensions OUT NOCOPY BIS_PMF_MIGRATION_PVT.resequenced_dimensions_array
233: ,x_dim_count OUT NOCOPY NUMBER
234: ,x_return_status OUT NOCOPY NUMBER
235: )

Line 232: ,x_resequenced_dimensions OUT NOCOPY BIS_PMF_MIGRATION_PVT.resequenced_dimensions_array

228: --
229:
230: PROCEDURE RESEQUENCE_DIMENSION_LEVELS(
231: p_target_level_rec IN BIS_PMF_MIGRATION_PVT.target_level_rec
232: ,x_resequenced_dimensions OUT NOCOPY BIS_PMF_MIGRATION_PVT.resequenced_dimensions_array
233: ,x_dim_count OUT NOCOPY NUMBER
234: ,x_return_status OUT NOCOPY NUMBER
235: )
236: IS

Line 241: l_reseuenced_dimensions_array BIS_PMF_MIGRATION_PVT.resequenced_dimensions_array;

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
244: OPEN c_dimcount(p_target_level_rec.measure_id);
245: FETCH c_dimcount INTO l_dimcount;

Line 261: x_resequenced_dimensions(1).dim_id := bis_pmf_migration_pvt.get_dimension_id (

257: FOR l_count IN 1..l_dimcount LOOP
258: x_resequenced_dimensions(l_count).dim_level_col := 'dimension'||l_count||'_level_id';
259: IF (l_count = 1) THEN
260: x_resequenced_dimensions(1).dim_level_col_val := p_target_level_rec.dimension1_levelid;
261: x_resequenced_dimensions(1).dim_id := bis_pmf_migration_pvt.get_dimension_id (
262: p_target_level_rec.dimension1_levelid);
263: x_Resequenced_dimensions(1).seq_no := l_count;
264: END IF;
265: IF (l_count=2) THEN

Line 267: x_resequenced_dimensions(2).dim_id := bis_pmf_migration_pvt.get_dimension_id (

263: x_Resequenced_dimensions(1).seq_no := l_count;
264: END IF;
265: IF (l_count=2) THEN
266: x_resequenced_dimensions(2).dim_level_col_val := p_target_level_rec.dimension2_levelid;
267: x_resequenced_dimensions(2).dim_id := bis_pmf_migration_pvt.get_dimension_id (
268: p_target_level_rec.dimension2_levelid);
269: x_Resequenced_dimensions(2).seq_no := l_count;
270: END IF;
271: IF (l_count=3) THEN

Line 273: x_resequenced_dimensions(3).dim_id := bis_pmf_migration_pvt.get_dimension_id (

269: x_Resequenced_dimensions(2).seq_no := l_count;
270: END IF;
271: IF (l_count=3) THEN
272: x_resequenced_dimensions(3).dim_level_col_val := p_target_level_rec.dimension3_levelid;
273: x_resequenced_dimensions(3).dim_id := bis_pmf_migration_pvt.get_dimension_id (
274: p_target_level_rec.dimension3_levelid);
275: x_Resequenced_dimensions(3).seq_no := l_count;
276: END IF;
277: IF (l_count=4) THEN

Line 279: x_resequenced_dimensions(4).dim_id := bis_pmf_migration_pvt.get_dimension_id (

275: x_Resequenced_dimensions(3).seq_no := l_count;
276: END IF;
277: IF (l_count=4) THEN
278: x_resequenced_dimensions(4).dim_level_col_val := p_target_level_rec.dimension4_levelid;
279: x_resequenced_dimensions(4).dim_id := bis_pmf_migration_pvt.get_dimension_id (
280: p_target_level_rec.dimension4_levelid);
281: x_Resequenced_dimensions(4).seq_no := l_count;
282: END IF;
283: IF (l_count=5) THEN

Line 285: x_resequenced_dimensions(5).dim_id := bis_pmf_migration_pvt.get_dimension_id (

281: x_Resequenced_dimensions(4).seq_no := l_count;
282: END IF;
283: IF (l_count=5) THEN
284: x_resequenced_dimensions(5).dim_level_col_val := p_target_level_rec.dimension5_levelid;
285: x_resequenced_dimensions(5).dim_id := bis_pmf_migration_pvt.get_dimension_id (
286: p_target_level_rec.dimension5_levelid);
287: x_Resequenced_dimensions(5).seq_no := l_count;
288: END IF;
289: END LOOP;

Line 295: x_resequenced_dimensions(l_dimcount).dim_id := bis_pmf_migration_pvt.get_dimension_id (

291: l_dimcount := l_dimcount + 1;
292: IF (l_dimcount <= 7) THEN
293: x_resequenced_dimensions(l_dimcount).dim_level_col := 'dimension'||l_dimcount||'_level_id';
294: x_resequenced_dimensions(l_dimcount).dim_level_col_val := p_target_level_rec.org_levelid;
295: x_resequenced_dimensions(l_dimcount).dim_id := bis_pmf_migration_pvt.get_dimension_id (
296: p_target_level_rec.org_levelid);
297: x_Resequenced_dimensions(l_dimcount).seq_no := l_dimcount;
298: l_dimcount := l_dimcount + 1;
299: x_resequenced_dimensions(l_dimcount).dim_level_col := 'dimension'||l_dimcount||'_level_id';

Line 301: x_resequenced_dimensions(l_dimcount).dim_id := bis_pmf_migration_pvt.get_dimension_id (

297: x_Resequenced_dimensions(l_dimcount).seq_no := l_dimcount;
298: l_dimcount := l_dimcount + 1;
299: x_resequenced_dimensions(l_dimcount).dim_level_col := 'dimension'||l_dimcount||'_level_id';
300: x_resequenced_dimensions(l_dimcount).dim_level_col_val := p_target_level_rec.time_levelid;
301: x_resequenced_dimensions(l_dimcount).dim_id := bis_pmf_migration_pvt.get_dimension_id (
302: p_target_level_rec.time_levelid);
303: x_Resequenced_dimensions(l_dimcount).seq_no := l_dimcount;
304: l_dimcount := l_dimcount +1;
305: FOR l_count IN l_dimcount..7 LOOP

Line 318: p_dimvalues_rec IN BIS_PMF_MIGRATION_PVT.dim_values_rec

314: x_return_status := -1;
315: END RESEQUENCE_DIMENSION_LEVELS;
316: --
317: PROCEDURE RESEQUENCE_DIM_LEVEL_VALUES(
318: p_dimvalues_rec IN BIS_PMF_MIGRATION_PVT.dim_values_rec
319: ,p_dim_count IN NUMBER
320: ,x_reseq_dim_values OUT NOCOPY BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr
321: ,x_return_Status OUT NOCOPY NUMBER
322: )

Line 320: ,x_reseq_dim_values OUT NOCOPY BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr

316: --
317: PROCEDURE RESEQUENCE_DIM_LEVEL_VALUES(
318: p_dimvalues_rec IN BIS_PMF_MIGRATION_PVT.dim_values_rec
319: ,p_dim_count IN NUMBER
320: ,x_reseq_dim_values OUT NOCOPY BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr
321: ,x_return_Status OUT NOCOPY NUMBER
322: )
323: IS
324: l_dim_levelcount NUMBER ;

Line 409: p_dimvalues_rec IN BIS_PMF_MIGRATION_PVT.dim_values_Rec

405: x_return_status := -1;
406: END;
407: --
408: PROCEDURE RESEQUENCE_IND_LEVEL_VALUES(
409: p_dimvalues_rec IN BIS_PMF_MIGRATION_PVT.dim_values_Rec
410: ,p_dim_count IN NUMBER
411: ,x_reseq_dim_values OUT NOCOPY BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr
412: ,x_return_status OUT NOCOPY NUMBER
413: )

Line 411: ,x_reseq_dim_values OUT NOCOPY BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr

407: --
408: PROCEDURE RESEQUENCE_IND_LEVEL_VALUES(
409: p_dimvalues_rec IN BIS_PMF_MIGRATION_PVT.dim_values_Rec
410: ,p_dim_count IN NUMBER
411: ,x_reseq_dim_values OUT NOCOPY BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr
412: ,x_return_status OUT NOCOPY NUMBER
413: )
414: IS
415: l_dim_levelcount NUMBER ;

Line 531: l_target_level_rec BIS_PMF_MIGRATION_PVT.target_level_rec;

527: ,dimension3_level_value, dimension4_level_value
528: ,dimension5_level_value
529: FROM bis_user_ind_selections
530: WHERE target_level_id = p_target_level_id;
531: l_target_level_rec BIS_PMF_MIGRATION_PVT.target_level_rec;
532: l_reseq_dims BIS_PMF_MIGRATION_PVT.resequenced_dimensions_Array;
533: l_target_rec BIS_PMF_MIGRATION_PVT.dim_Values_rec;
534: l_reseq_target_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
535: l_Actual_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;

Line 532: l_reseq_dims BIS_PMF_MIGRATION_PVT.resequenced_dimensions_Array;

528: ,dimension5_level_value
529: FROM bis_user_ind_selections
530: WHERE target_level_id = p_target_level_id;
531: l_target_level_rec BIS_PMF_MIGRATION_PVT.target_level_rec;
532: l_reseq_dims BIS_PMF_MIGRATION_PVT.resequenced_dimensions_Array;
533: l_target_rec BIS_PMF_MIGRATION_PVT.dim_Values_rec;
534: l_reseq_target_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
535: l_Actual_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;
536: l_reseq_actual_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;

Line 533: l_target_rec BIS_PMF_MIGRATION_PVT.dim_Values_rec;

529: FROM bis_user_ind_selections
530: WHERE target_level_id = p_target_level_id;
531: l_target_level_rec BIS_PMF_MIGRATION_PVT.target_level_rec;
532: l_reseq_dims BIS_PMF_MIGRATION_PVT.resequenced_dimensions_Array;
533: l_target_rec BIS_PMF_MIGRATION_PVT.dim_Values_rec;
534: l_reseq_target_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
535: l_Actual_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;
536: l_reseq_actual_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
537: l_userind_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;

Line 534: l_reseq_target_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;

530: WHERE target_level_id = p_target_level_id;
531: l_target_level_rec BIS_PMF_MIGRATION_PVT.target_level_rec;
532: l_reseq_dims BIS_PMF_MIGRATION_PVT.resequenced_dimensions_Array;
533: l_target_rec BIS_PMF_MIGRATION_PVT.dim_Values_rec;
534: l_reseq_target_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
535: l_Actual_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;
536: l_reseq_actual_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
537: l_userind_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;
538: l_reseq_userind_Values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;

Line 535: l_Actual_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;

531: l_target_level_rec BIS_PMF_MIGRATION_PVT.target_level_rec;
532: l_reseq_dims BIS_PMF_MIGRATION_PVT.resequenced_dimensions_Array;
533: l_target_rec BIS_PMF_MIGRATION_PVT.dim_Values_rec;
534: l_reseq_target_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
535: l_Actual_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;
536: l_reseq_actual_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
537: l_userind_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;
538: l_reseq_userind_Values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
539: l_return_status NUMBER;

Line 536: l_reseq_actual_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;

532: l_reseq_dims BIS_PMF_MIGRATION_PVT.resequenced_dimensions_Array;
533: l_target_rec BIS_PMF_MIGRATION_PVT.dim_Values_rec;
534: l_reseq_target_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
535: l_Actual_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;
536: l_reseq_actual_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
537: l_userind_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;
538: l_reseq_userind_Values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
539: l_return_status NUMBER;
540: l_sqlstmt VARCHAR2(32000);

Line 537: l_userind_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;

533: l_target_rec BIS_PMF_MIGRATION_PVT.dim_Values_rec;
534: l_reseq_target_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
535: l_Actual_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;
536: l_reseq_actual_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
537: l_userind_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;
538: l_reseq_userind_Values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
539: l_return_status NUMBER;
540: l_sqlstmt VARCHAR2(32000);
541: l_sqlstmt1 VARCHAR2(32000);

Line 538: l_reseq_userind_Values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;

534: l_reseq_target_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
535: l_Actual_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;
536: l_reseq_actual_values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
537: l_userind_rec BIS_PMF_MIGRATION_PVT.dim_values_rec;
538: l_reseq_userind_Values BIS_PMF_MIGRATION_PVT.reseq_dim_values_arr;
539: l_return_status NUMBER;
540: l_sqlstmt VARCHAR2(32000);
541: l_sqlstmt1 VARCHAR2(32000);
542: l_sqlstmt2 VARCHAR2(32000);

Line 612: IF (BIS_PMF_MIGRATION_PVT.NEEDS_MIGRATION(l_target_level_rec_new)) THEN

608: l_target_level_rec_new.org_level_id := c_rec.org_level_id;
609: l_target_level_rec_new.time_level_id := c_rec.time_level_id;
610: l_target_level_rec_new.measure_id := c_rec.indicator_id;
611:
612: IF (BIS_PMF_MIGRATION_PVT.NEEDS_MIGRATION(l_target_level_rec_new)) THEN
613: BIS_PMF_MIGRATION_PVT.resequence_dimension_levels
614: (p_target_level_rec => l_target_level_rec
615: ,x_resequenced_dimensions => l_reseq_dims
616: ,x_dim_count => l_dim_count

Line 613: BIS_PMF_MIGRATION_PVT.resequence_dimension_levels

609: l_target_level_rec_new.time_level_id := c_rec.time_level_id;
610: l_target_level_rec_new.measure_id := c_rec.indicator_id;
611:
612: IF (BIS_PMF_MIGRATION_PVT.NEEDS_MIGRATION(l_target_level_rec_new)) THEN
613: BIS_PMF_MIGRATION_PVT.resequence_dimension_levels
614: (p_target_level_rec => l_target_level_rec
615: ,x_resequenced_dimensions => l_reseq_dims
616: ,x_dim_count => l_dim_count
617: ,x_return_status => l_return_status

Line 686: BIS_PMF_MIGRATION_PVT.resequence_dim_level_values(

682: l_target_rec.dimension2_level_value := c_targetrec.dimension2_level_value;
683: l_target_rec.dimension3_level_value := c_targetrec.dimension3_level_value;
684: l_target_rec.dimension4_level_value := c_targetrec.dimension4_level_value;
685: l_Target_rec.dimension5_level_value := c_targetrec.dimension5_level_value;
686: BIS_PMF_MIGRATION_PVT.resequence_dim_level_values(
687: p_dimvalues_rec => l_target_rec
688: ,p_dim_count => l_dim_count
689: ,x_reseq_dim_values => l_reseq_target_values
690: ,x_return_Status => l_return_status

Line 719: BIS_PMF_MIGRATION_PVT.resequence_dim_level_values(

715: l_actual_rec.dimension2_level_Value := c_actual_rec.dimension2_level_value;
716: l_actual_rec.dimension3_level_value := c_actual_rec.dimension3_level_value;
717: l_actual_rec.dimension4_level_value := c_actual_rec.dimension4_level_value;
718: l_actual_rec.dimension5_level_value := c_actual_rec.dimension5_level_value;
719: BIS_PMF_MIGRATION_PVT.resequence_dim_level_values(
720: p_dimvalues_rec => l_actual_rec
721: ,p_dim_count => l_dim_count
722: ,x_reseq_dim_values => l_reseq_actual_values
723: ,x_return_Status => l_return_status

Line 753: /*BIS_PMF_MIGRATION_PVT.resequence_ind_level_values(

749: l_userind_rec.dimension2_level_Value := c_userind_rec.dimension2_level_value;
750: l_userind_rec.dimension3_level_value := c_userind_rec.dimension3_level_value;
751: l_userind_rec.dimension4_level_value := c_userind_rec.dimension4_level_value;
752: l_userind_rec.dimension5_level_value := c_userind_rec.dimension5_level_value;
753: /*BIS_PMF_MIGRATION_PVT.resequence_ind_level_values(
754: p_dimvalues_rec => l_userind_rec
755: ,p_dim_count => l_dim_count
756: ,x_reseq_dim_values => l_reseq_userind_values
757: ,x_return_Status => l_return_status

Line 905: l_mig_target_level_rec BIS_PMF_MIGRATION_PVT.target_level_rec;

901: dimension7_level_id = cp_tl_rec.dimension7_level_id
902: );
903:
904: l_tl_count NUMBER := 0;
905: l_mig_target_level_rec BIS_PMF_MIGRATION_PVT.target_level_rec;
906: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
907: l_reseq_dims BIS_PMF_MIGRATION_PVT.resequenced_dimensions_Array;
908: l_return_status NUMBER;
909: l_dim_count NUMBER;

Line 907: l_reseq_dims BIS_PMF_MIGRATION_PVT.resequenced_dimensions_Array;

903:
904: l_tl_count NUMBER := 0;
905: l_mig_target_level_rec BIS_PMF_MIGRATION_PVT.target_level_rec;
906: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
907: l_reseq_dims BIS_PMF_MIGRATION_PVT.resequenced_dimensions_Array;
908: l_return_status NUMBER;
909: l_dim_count NUMBER;
910:
911: BEGIN

Line 926: BIS_PMF_MIGRATION_PVT.resequence_dimension_levels

922: l_mig_target_level_Rec.dimension3_levelid := p_target_level_rec.dimension3_level_id;
923: l_mig_target_level_rec.dimension4_levelid := p_target_level_rec.dimension4_level_id;
924: l_mig_target_level_rec.dimension5_levelid := p_target_level_rec.dimension5_level_id;
925:
926: BIS_PMF_MIGRATION_PVT.resequence_dimension_levels
927: (p_target_level_rec => l_mig_target_level_rec
928: ,x_resequenced_dimensions => l_reseq_dims
929: ,x_dim_count => l_dim_count
930: ,x_return_status => l_return_status

Line 961: l_org_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.org_level_id);

957: END IF;
958:
959: -- IF either org or time exists then return true here. As it should never
960: -- happen that, only org got migrated and not time
961: l_org_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.org_level_id);
962: l_time_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.time_level_id);
963: l_dim1_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension1_level_id);
964: l_dim2_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension2_level_id);
965: l_dim3_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension3_level_id);

Line 962: l_time_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.time_level_id);

958:
959: -- IF either org or time exists then return true here. As it should never
960: -- happen that, only org got migrated and not time
961: l_org_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.org_level_id);
962: l_time_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.time_level_id);
963: l_dim1_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension1_level_id);
964: l_dim2_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension2_level_id);
965: l_dim3_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension3_level_id);
966: l_dim4_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension4_level_id);

Line 963: l_dim1_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension1_level_id);

959: -- IF either org or time exists then return true here. As it should never
960: -- happen that, only org got migrated and not time
961: l_org_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.org_level_id);
962: l_time_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.time_level_id);
963: l_dim1_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension1_level_id);
964: l_dim2_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension2_level_id);
965: l_dim3_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension3_level_id);
966: l_dim4_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension4_level_id);
967: l_dim5_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension5_level_id);

Line 964: l_dim2_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension2_level_id);

960: -- happen that, only org got migrated and not time
961: l_org_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.org_level_id);
962: l_time_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.time_level_id);
963: l_dim1_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension1_level_id);
964: l_dim2_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension2_level_id);
965: l_dim3_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension3_level_id);
966: l_dim4_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension4_level_id);
967: l_dim5_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension5_level_id);
968: l_dim6_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension6_level_id);

Line 965: l_dim3_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension3_level_id);

961: l_org_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.org_level_id);
962: l_time_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.time_level_id);
963: l_dim1_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension1_level_id);
964: l_dim2_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension2_level_id);
965: l_dim3_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension3_level_id);
966: l_dim4_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension4_level_id);
967: l_dim5_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension5_level_id);
968: l_dim6_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension6_level_id);
969: l_dim7_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension7_level_id);

Line 966: l_dim4_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension4_level_id);

962: l_time_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.time_level_id);
963: l_dim1_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension1_level_id);
964: l_dim2_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension2_level_id);
965: l_dim3_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension3_level_id);
966: l_dim4_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension4_level_id);
967: l_dim5_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension5_level_id);
968: l_dim6_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension6_level_id);
969: l_dim7_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension7_level_id);
970:

Line 967: l_dim5_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension5_level_id);

963: l_dim1_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension1_level_id);
964: l_dim2_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension2_level_id);
965: l_dim3_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension3_level_id);
966: l_dim4_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension4_level_id);
967: l_dim5_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension5_level_id);
968: l_dim6_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension6_level_id);
969: l_dim7_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension7_level_id);
970:
971: l_org_time_exists := TRUE;

Line 968: l_dim6_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension6_level_id);

964: l_dim2_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension2_level_id);
965: l_dim3_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension3_level_id);
966: l_dim4_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension4_level_id);
967: l_dim5_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension5_level_id);
968: l_dim6_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension6_level_id);
969: l_dim7_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension7_level_id);
970:
971: l_org_time_exists := TRUE;
972: IF (l_org_id = l_dim1_id)

Line 969: l_dim7_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension7_level_id);

965: l_dim3_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension3_level_id);
966: l_dim4_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension4_level_id);
967: l_dim5_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension5_level_id);
968: l_dim6_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension6_level_id);
969: l_dim7_id := BIS_PMF_MIGRATION_PVT.GET_DIMENSION_ID(p_target_level_rec.dimension7_level_id);
970:
971: l_org_time_exists := TRUE;
972: IF (l_org_id = l_dim1_id)
973: THEN

Line 1051: END BIS_PMF_MIGRATION_PVT;

1047: CLOSE c_target_lvl_exists;
1048: END IF;
1049: RETURN FALSE;
1050: END;
1051: END BIS_PMF_MIGRATION_PVT;
1052: --SHOW ERRORS