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_TARGET_PVT dependencies on BISBV_TARGET_LEVELS

Line 567: l_bisbv_target_levels_rec bisbv_target_levels%ROWTYPE;

563: )
564: IS
565: --
566: l_bisfv_targets_rec bisfv_targets%ROWTYPE;
567: l_bisbv_target_levels_rec bisbv_target_levels%ROWTYPE;
568: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
569: l_plan_id NUMBER;
570: l_Business_Plan_Rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;
571: l_org_level_value_id VARCHAR2(250);

Line 598: INTO l_bisbv_target_levels_rec

594: = FND_API.G_TRUE
595: AND p_Target_Rec.Target_Level_ID IS NOT NULL
596: ) THEN
597: SELECT *
598: INTO l_bisbv_target_levels_rec
599: FROM bisbv_target_levels bisbv_target_levels
600: WHERE bisbv_target_levels.TARGET_LEVEL_ID
601: = p_Target_Rec.Target_Level_ID;
602:

Line 599: FROM bisbv_target_levels bisbv_target_levels

595: AND p_Target_Rec.Target_Level_ID IS NOT NULL
596: ) THEN
597: SELECT *
598: INTO l_bisbv_target_levels_rec
599: FROM bisbv_target_levels bisbv_target_levels
600: WHERE bisbv_target_levels.TARGET_LEVEL_ID
601: = p_Target_Rec.Target_Level_ID;
602:
603: --

Line 600: WHERE bisbv_target_levels.TARGET_LEVEL_ID

596: ) THEN
597: SELECT *
598: INTO l_bisbv_target_levels_rec
599: FROM bisbv_target_levels bisbv_target_levels
600: WHERE bisbv_target_levels.TARGET_LEVEL_ID
601: = p_Target_Rec.Target_Level_ID;
602:
603: --
604: --

Line 608: IF(l_bisbv_target_levels_rec.DIMENSION1_LEVEL_ID IS NOT NULL) THEN

604: --
605: --Removed check for org and time
606:
607:
608: IF(l_bisbv_target_levels_rec.DIMENSION1_LEVEL_ID IS NOT NULL) THEN
609: IF( BIS_UTILITIES_PUB.Value_Missing
610: (p_Target_Rec.Dim1_Level_Value_ID)
611: = FND_API.G_TRUE
612: OR p_Target_Rec.Dim1_Level_Value_ID IS NULL

Line 646: IF(l_bisbv_target_levels_rec.DIMENSION2_LEVEL_ID IS NOT NULL) THEN

642: );
643: RAISE FND_API.G_EXC_ERROR;
644: END IF;
645: --
646: IF(l_bisbv_target_levels_rec.DIMENSION2_LEVEL_ID IS NOT NULL) THEN
647: IF( BIS_UTILITIES_PUB.Value_Missing
648: (p_Target_Rec.Dim2_Level_Value_ID)
649: = FND_API.G_TRUE
650: OR p_Target_Rec.Dim2_Level_Value_ID IS NULL

Line 682: IF(l_bisbv_target_levels_rec.DIMENSION3_LEVEL_ID IS NOT NULL) THEN

678: );
679: RAISE FND_API.G_EXC_ERROR;
680: END IF;
681: --
682: IF(l_bisbv_target_levels_rec.DIMENSION3_LEVEL_ID IS NOT NULL) THEN
683: IF( BIS_UTILITIES_PUB.Value_Missing
684: (p_Target_Rec.Dim3_Level_Value_ID)
685: = FND_API.G_TRUE
686: OR p_Target_Rec.Dim3_Level_Value_ID IS NULL

Line 719: IF(l_bisbv_target_levels_rec.DIMENSION4_LEVEL_ID IS NOT NULL) THEN

715: );
716: RAISE FND_API.G_EXC_ERROR;
717: END IF;
718: --
719: IF(l_bisbv_target_levels_rec.DIMENSION4_LEVEL_ID IS NOT NULL) THEN
720: IF( BIS_UTILITIES_PUB.Value_Missing
721: (p_Target_Rec.Dim4_Level_Value_ID)
722: = FND_API.G_TRUE
723: OR p_Target_Rec.Dim4_Level_Value_ID IS NULL

Line 755: IF(l_bisbv_target_levels_rec.DIMENSION5_LEVEL_ID IS NOT NULL) THEN

751: );
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;
754: --
755: IF(l_bisbv_target_levels_rec.DIMENSION5_LEVEL_ID IS NOT NULL) THEN
756: IF( BIS_UTILITIES_PUB.Value_Missing
757: (p_Target_Rec.Dim5_Level_Value_ID)
758: = FND_API.G_TRUE
759: OR p_Target_Rec.Dim5_Level_Value_ID IS NULL

Line 791: IF(l_bisbv_target_levels_rec.DIMENSION6_LEVEL_ID IS NOT NULL) THEN

787: );
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790: --
791: IF(l_bisbv_target_levels_rec.DIMENSION6_LEVEL_ID IS NOT NULL) THEN
792: IF( BIS_UTILITIES_PUB.Value_Missing
793: (p_Target_Rec.Dim6_Level_Value_ID)
794: = FND_API.G_TRUE
795: OR p_Target_Rec.Dim6_Level_Value_ID IS NULL

Line 828: IF(l_bisbv_target_levels_rec.DIMENSION7_LEVEL_ID IS NOT NULL) THEN

824: RAISE FND_API.G_EXC_ERROR;
825: END IF;
826: --
827: --
828: IF(l_bisbv_target_levels_rec.DIMENSION7_LEVEL_ID IS NOT NULL) THEN
829: IF( BIS_UTILITIES_PUB.Value_Missing
830: (p_Target_Rec.Dim7_Level_Value_ID)
831: = FND_API.G_TRUE
832: OR p_Target_Rec.Dim7_Level_Value_ID IS NULL

Line 2639: l_bisbv_target_levels BISBV_TARGET_LEVELS%ROWTYPE;

2635: , x_dim7_view_name OUT NOCOPY VARCHAR2
2636: )
2637: IS
2638: --
2639: l_bisbv_target_levels BISBV_TARGET_LEVELS%ROWTYPE;
2640: --
2641: BEGIN
2642: -- retrieve the target level record
2643: SELECT *

Line 2644: INTO l_bisbv_target_levels

2640: --
2641: BEGIN
2642: -- retrieve the target level record
2643: SELECT *
2644: INTO l_bisbv_target_levels
2645: FROM BISBV_TARGET_LEVELS
2646: WHERE TARGET_LEVEL_ID = TO_NUMBER(p_target_level_id);
2647: --
2648: -- retrieve the Org level view name

Line 2645: FROM BISBV_TARGET_LEVELS

2641: BEGIN
2642: -- retrieve the target level record
2643: SELECT *
2644: INTO l_bisbv_target_levels
2645: FROM BISBV_TARGET_LEVELS
2646: WHERE TARGET_LEVEL_ID = TO_NUMBER(p_target_level_id);
2647: --
2648: -- retrieve the Org level view name
2649: IF(l_bisbv_target_levels.ORG_LEVEL_ID IS NOT NULL) THEN

Line 2649: IF(l_bisbv_target_levels.ORG_LEVEL_ID IS NOT NULL) THEN

2645: FROM BISBV_TARGET_LEVELS
2646: WHERE TARGET_LEVEL_ID = TO_NUMBER(p_target_level_id);
2647: --
2648: -- retrieve the Org level view name
2649: IF(l_bisbv_target_levels.ORG_LEVEL_ID IS NOT NULL) THEN
2650: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2651: INTO x_org_view_name
2652: FROM
2653: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

Line 2655: = l_bisbv_target_levels.ORG_LEVEL_ID;

2651: INTO x_org_view_name
2652: FROM
2653: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2654: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2655: = l_bisbv_target_levels.ORG_LEVEL_ID;
2656: END IF;
2657: --
2658: -- retrieve the Time level view name
2659: IF(l_bisbv_target_levels.TIME_LEVEL_ID IS NOT NULL) THEN

Line 2659: IF(l_bisbv_target_levels.TIME_LEVEL_ID IS NOT NULL) THEN

2655: = l_bisbv_target_levels.ORG_LEVEL_ID;
2656: END IF;
2657: --
2658: -- retrieve the Time level view name
2659: IF(l_bisbv_target_levels.TIME_LEVEL_ID IS NOT NULL) THEN
2660: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2661: INTO x_time_view_name
2662: FROM
2663: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

Line 2665: = l_bisbv_target_levels.TIME_LEVEL_ID;

2661: INTO x_time_view_name
2662: FROM
2663: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2664: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2665: = l_bisbv_target_levels.TIME_LEVEL_ID;
2666: END IF;
2667: --
2668: -- retrieve the dim1 level view name
2669: IF(l_bisbv_target_levels.DIMENSION1_LEVEL_ID IS NOT NULL) THEN

Line 2669: IF(l_bisbv_target_levels.DIMENSION1_LEVEL_ID IS NOT NULL) THEN

2665: = l_bisbv_target_levels.TIME_LEVEL_ID;
2666: END IF;
2667: --
2668: -- retrieve the dim1 level view name
2669: IF(l_bisbv_target_levels.DIMENSION1_LEVEL_ID IS NOT NULL) THEN
2670: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2671: INTO x_dim1_view_name
2672: FROM
2673: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

Line 2675: = l_bisbv_target_levels.DIMENSION1_LEVEL_ID;

2671: INTO x_dim1_view_name
2672: FROM
2673: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2674: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2675: = l_bisbv_target_levels.DIMENSION1_LEVEL_ID;
2676: END IF;
2677: --
2678: -- retrieve the dim2 level view name
2679: IF(l_bisbv_target_levels.DIMENSION2_LEVEL_ID IS NOT NULL) THEN

Line 2679: IF(l_bisbv_target_levels.DIMENSION2_LEVEL_ID IS NOT NULL) THEN

2675: = l_bisbv_target_levels.DIMENSION1_LEVEL_ID;
2676: END IF;
2677: --
2678: -- retrieve the dim2 level view name
2679: IF(l_bisbv_target_levels.DIMENSION2_LEVEL_ID IS NOT NULL) THEN
2680: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2681: INTO x_dim2_view_name
2682: FROM
2683: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

Line 2685: = l_bisbv_target_levels.DIMENSION2_LEVEL_ID;

2681: INTO x_dim2_view_name
2682: FROM
2683: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2684: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2685: = l_bisbv_target_levels.DIMENSION2_LEVEL_ID;
2686: END IF;
2687: --
2688: -- retrieve the dim3 level view name
2689: IF(l_bisbv_target_levels.DIMENSION3_LEVEL_ID IS NOT NULL) THEN

Line 2689: IF(l_bisbv_target_levels.DIMENSION3_LEVEL_ID IS NOT NULL) THEN

2685: = l_bisbv_target_levels.DIMENSION2_LEVEL_ID;
2686: END IF;
2687: --
2688: -- retrieve the dim3 level view name
2689: IF(l_bisbv_target_levels.DIMENSION3_LEVEL_ID IS NOT NULL) THEN
2690: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2691: INTO x_dim3_view_name
2692: FROM
2693: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

Line 2695: = l_bisbv_target_levels.DIMENSION3_LEVEL_ID;

2691: INTO x_dim3_view_name
2692: FROM
2693: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2694: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2695: = l_bisbv_target_levels.DIMENSION3_LEVEL_ID;
2696: END IF;
2697: --
2698: -- retrieve the dim4 level view name
2699: IF(l_bisbv_target_levels.DIMENSION4_LEVEL_ID IS NOT NULL) THEN

Line 2699: IF(l_bisbv_target_levels.DIMENSION4_LEVEL_ID IS NOT NULL) THEN

2695: = l_bisbv_target_levels.DIMENSION3_LEVEL_ID;
2696: END IF;
2697: --
2698: -- retrieve the dim4 level view name
2699: IF(l_bisbv_target_levels.DIMENSION4_LEVEL_ID IS NOT NULL) THEN
2700: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2701: INTO x_dim4_view_name
2702: FROM
2703: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

Line 2705: = l_bisbv_target_levels.DIMENSION4_LEVEL_ID;

2701: INTO x_dim4_view_name
2702: FROM
2703: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2704: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2705: = l_bisbv_target_levels.DIMENSION4_LEVEL_ID;
2706: END IF;
2707: --
2708: -- retrieve the dim5 level view name
2709: IF(l_bisbv_target_levels.DIMENSION5_LEVEL_ID IS NOT NULL) THEN

Line 2709: IF(l_bisbv_target_levels.DIMENSION5_LEVEL_ID IS NOT NULL) THEN

2705: = l_bisbv_target_levels.DIMENSION4_LEVEL_ID;
2706: END IF;
2707: --
2708: -- retrieve the dim5 level view name
2709: IF(l_bisbv_target_levels.DIMENSION5_LEVEL_ID IS NOT NULL) THEN
2710: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2711: INTO x_dim5_view_name
2712: FROM
2713: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

Line 2715: = l_bisbv_target_levels.DIMENSION5_LEVEL_ID;

2711: INTO x_dim5_view_name
2712: FROM
2713: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2714: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2715: = l_bisbv_target_levels.DIMENSION5_LEVEL_ID;
2716: END IF;
2717: -- retrieve the dim6 level view name
2718: IF(l_bisbv_target_levels.DIMENSION6_LEVEL_ID IS NOT NULL) THEN
2719: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME

Line 2718: IF(l_bisbv_target_levels.DIMENSION6_LEVEL_ID IS NOT NULL) THEN

2714: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2715: = l_bisbv_target_levels.DIMENSION5_LEVEL_ID;
2716: END IF;
2717: -- retrieve the dim6 level view name
2718: IF(l_bisbv_target_levels.DIMENSION6_LEVEL_ID IS NOT NULL) THEN
2719: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2720: INTO x_dim6_view_name
2721: FROM
2722: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

Line 2724: = l_bisbv_target_levels.DIMENSION6_LEVEL_ID;

2720: INTO x_dim6_view_name
2721: FROM
2722: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2723: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2724: = l_bisbv_target_levels.DIMENSION6_LEVEL_ID;
2725: END IF;
2726: -- retrieve the dim7 level view name
2727: IF(l_bisbv_target_levels.DIMENSION7_LEVEL_ID IS NOT NULL) THEN
2728: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME

Line 2727: IF(l_bisbv_target_levels.DIMENSION7_LEVEL_ID IS NOT NULL) THEN

2723: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2724: = l_bisbv_target_levels.DIMENSION6_LEVEL_ID;
2725: END IF;
2726: -- retrieve the dim7 level view name
2727: IF(l_bisbv_target_levels.DIMENSION7_LEVEL_ID IS NOT NULL) THEN
2728: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2729: INTO x_dim7_view_name
2730: FROM
2731: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

Line 2733: = l_bisbv_target_levels.DIMENSION7_LEVEL_ID;

2729: INTO x_dim7_view_name
2730: FROM
2731: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2732: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2733: = l_bisbv_target_levels.DIMENSION7_LEVEL_ID;
2734: END IF;
2735: --
2736: --
2737: --commented RAISE