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 BISFV_TARGETS

Line 412: FROM bisfv_targets bisfv_targets

408: IS
409: --
410: CURSOR c_all_targets(p_Target_Level_ID IN NUMBER) IS
411: SELECT *
412: FROM bisfv_targets bisfv_targets
413: WHERE bisfv_targets.TARGET_LEVEL_ID = p_Target_Level_ID;
414: --
415: l_ind NUMBER := 0;
416: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

Line 413: WHERE bisfv_targets.TARGET_LEVEL_ID = p_Target_Level_ID;

409: --
410: CURSOR c_all_targets(p_Target_Level_ID IN NUMBER) IS
411: SELECT *
412: FROM bisfv_targets bisfv_targets
413: WHERE bisfv_targets.TARGET_LEVEL_ID = p_Target_Level_ID;
414: --
415: l_ind NUMBER := 0;
416: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
417: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 566: l_bisfv_targets_rec bisfv_targets%ROWTYPE;

562: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
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;

Line 588: INTO l_bisfv_targets_rec

584: = FND_API.G_TRUE
585: AND p_Target_Rec.Target_ID IS NOT NULL
586: ) THEN
587: SELECT *
588: INTO l_bisfv_targets_rec
589: FROM bisfv_targets bisfv_targets
590: WHERE bisfv_targets.TARGET_ID = p_Target_Rec.Target_ID;
591:
592:

Line 589: FROM bisfv_targets bisfv_targets

585: AND p_Target_Rec.Target_ID IS NOT NULL
586: ) THEN
587: SELECT *
588: INTO l_bisfv_targets_rec
589: FROM bisfv_targets bisfv_targets
590: WHERE bisfv_targets.TARGET_ID = p_Target_Rec.Target_ID;
591:
592:
593: ELSIF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Rec.Target_Level_ID)

Line 590: WHERE bisfv_targets.TARGET_ID = p_Target_Rec.Target_ID;

586: ) THEN
587: SELECT *
588: INTO l_bisfv_targets_rec
589: FROM bisfv_targets bisfv_targets
590: WHERE bisfv_targets.TARGET_ID = p_Target_Rec.Target_ID;
591:
592:
593: ELSIF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Rec.Target_Level_ID)
594: = FND_API.G_TRUE

Line 907: INTO l_bisfv_targets_rec

903:
904:
905:
906: SELECT *
907: INTO l_bisfv_targets_rec
908: FROM bisfv_targets bisfv_targets
909: WHERE bisfv_targets.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID
910: -- used to be p_Target_Rec.Plan_ID
911: AND bisfv_targets.PLAN_ID = l_plan_id

Line 908: FROM bisfv_targets bisfv_targets

904:
905:
906: SELECT *
907: INTO l_bisfv_targets_rec
908: FROM bisfv_targets bisfv_targets
909: WHERE bisfv_targets.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID
910: -- used to be p_Target_Rec.Plan_ID
911: AND bisfv_targets.PLAN_ID = l_plan_id
912:

Line 909: WHERE bisfv_targets.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID

905:
906: SELECT *
907: INTO l_bisfv_targets_rec
908: FROM bisfv_targets bisfv_targets
909: WHERE bisfv_targets.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID
910: -- used to be p_Target_Rec.Plan_ID
911: AND bisfv_targets.PLAN_ID = l_plan_id
912:
913: ---changed org and time logic

Line 911: AND bisfv_targets.PLAN_ID = l_plan_id

907: INTO l_bisfv_targets_rec
908: FROM bisfv_targets bisfv_targets
909: WHERE bisfv_targets.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID
910: -- used to be p_Target_Rec.Plan_ID
911: AND bisfv_targets.PLAN_ID = l_plan_id
912:
913: ---changed org and time logic
914: AND (l_org_level_value_id IS NULL
915: OR NVL(bisfv_targets.ORG_LEVEL_VALUE_ID,'T') = NVL(l_org_level_value_id, 'T'))

Line 915: OR NVL(bisfv_targets.ORG_LEVEL_VALUE_ID,'T') = NVL(l_org_level_value_id, 'T'))

911: AND bisfv_targets.PLAN_ID = l_plan_id
912:
913: ---changed org and time logic
914: AND (l_org_level_value_id IS NULL
915: OR NVL(bisfv_targets.ORG_LEVEL_VALUE_ID,'T') = NVL(l_org_level_value_id, 'T'))
916:
917: AND (l_time_level_value_id IS NULL
918: OR NVL(bisfv_targets.TIME_LEVEL_VALUE_ID,'T') = NVL(l_time_level_value_id, 'T'))
919:

Line 918: OR NVL(bisfv_targets.TIME_LEVEL_VALUE_ID,'T') = NVL(l_time_level_value_id, 'T'))

914: AND (l_org_level_value_id IS NULL
915: OR NVL(bisfv_targets.ORG_LEVEL_VALUE_ID,'T') = NVL(l_org_level_value_id, 'T'))
916:
917: AND (l_time_level_value_id IS NULL
918: OR NVL(bisfv_targets.TIME_LEVEL_VALUE_ID,'T') = NVL(l_time_level_value_id, 'T'))
919:
920: AND NVL(bisfv_targets.DIM1_LEVEL_VALUE_ID, 'T')
921: = DECODE( p_Target_Rec.Dim1_Level_Value_ID
922: , FND_API.G_MISS_CHAR

Line 920: AND NVL(bisfv_targets.DIM1_LEVEL_VALUE_ID, 'T')

916:
917: AND (l_time_level_value_id IS NULL
918: OR NVL(bisfv_targets.TIME_LEVEL_VALUE_ID,'T') = NVL(l_time_level_value_id, 'T'))
919:
920: AND NVL(bisfv_targets.DIM1_LEVEL_VALUE_ID, 'T')
921: = DECODE( p_Target_Rec.Dim1_Level_Value_ID
922: , FND_API.G_MISS_CHAR
923: , 'T'
924: , NVL(p_Target_Rec.Dim1_Level_Value_ID, 'T')

Line 926: AND NVL(bisfv_targets.DIM2_LEVEL_VALUE_ID, 'T')

922: , FND_API.G_MISS_CHAR
923: , 'T'
924: , NVL(p_Target_Rec.Dim1_Level_Value_ID, 'T')
925: )
926: AND NVL(bisfv_targets.DIM2_LEVEL_VALUE_ID, 'T')
927: = DECODE( p_Target_Rec.Dim2_Level_Value_ID
928: , FND_API.G_MISS_CHAR
929: , 'T'
930: , NVL(p_Target_Rec.Dim2_Level_Value_ID, 'T')

Line 932: AND NVL(bisfv_targets.DIM3_LEVEL_VALUE_ID, 'T')

928: , FND_API.G_MISS_CHAR
929: , 'T'
930: , NVL(p_Target_Rec.Dim2_Level_Value_ID, 'T')
931: )
932: AND NVL(bisfv_targets.DIM3_LEVEL_VALUE_ID, 'T')
933: = DECODE( p_Target_Rec.Dim3_Level_Value_ID
934: , FND_API.G_MISS_CHAR
935: , 'T'
936: , NVL(p_Target_Rec.Dim3_Level_Value_ID, 'T')

Line 938: AND NVL(bisfv_targets.DIM4_LEVEL_VALUE_ID, 'T')

934: , FND_API.G_MISS_CHAR
935: , 'T'
936: , NVL(p_Target_Rec.Dim3_Level_Value_ID, 'T')
937: )
938: AND NVL(bisfv_targets.DIM4_LEVEL_VALUE_ID, 'T')
939: = DECODE( p_Target_Rec.Dim4_Level_Value_ID
940: , FND_API.G_MISS_CHAR
941: , 'T'
942: , NVL(p_Target_Rec.Dim4_Level_Value_ID, 'T')

Line 944: AND NVL(bisfv_targets.DIM5_LEVEL_VALUE_ID, 'T')

940: , FND_API.G_MISS_CHAR
941: , 'T'
942: , NVL(p_Target_Rec.Dim4_Level_Value_ID, 'T')
943: )
944: AND NVL(bisfv_targets.DIM5_LEVEL_VALUE_ID, 'T')
945: = DECODE( p_Target_Rec.Dim5_Level_Value_ID
946: , FND_API.G_MISS_CHAR
947: , 'T'
948: , NVL(p_Target_Rec.Dim5_Level_Value_ID, 'T')

Line 950: AND NVL(bisfv_targets.DIM6_LEVEL_VALUE_ID, 'T')

946: , FND_API.G_MISS_CHAR
947: , 'T'
948: , NVL(p_Target_Rec.Dim5_Level_Value_ID, 'T')
949: )
950: AND NVL(bisfv_targets.DIM6_LEVEL_VALUE_ID, 'T')
951: = DECODE( p_Target_Rec.Dim6_Level_Value_ID
952: , FND_API.G_MISS_CHAR
953: , 'T'
954: , NVL(p_Target_Rec.Dim6_Level_Value_ID, 'T')

Line 956: AND NVL(bisfv_targets.DIM7_LEVEL_VALUE_ID, 'T')

952: , FND_API.G_MISS_CHAR
953: , 'T'
954: , NVL(p_Target_Rec.Dim6_Level_Value_ID, 'T')
955: )
956: AND NVL(bisfv_targets.DIM7_LEVEL_VALUE_ID, 'T')
957: = DECODE( p_Target_Rec.Dim7_Level_Value_ID
958: , FND_API.G_MISS_CHAR
959: , 'T'
960: , NVL(p_Target_Rec.Dim7_Level_Value_ID, 'T')

Line 965: x_Target_Rec.Target_ID := l_bisfv_targets_rec.Target_ID;

961: )
962: ;
963: END IF;
964: --
965: x_Target_Rec.Target_ID := l_bisfv_targets_rec.Target_ID;
966: x_Target_Rec.Target_Level_ID := l_bisfv_targets_rec.Target_Level_ID;
967: x_Target_Rec.Target_Level_Short_Name
968: := l_bisfv_targets_rec.Target_Level_Short_Name;
969: x_Target_Rec.Target_Level_Name

Line 966: x_Target_Rec.Target_Level_ID := l_bisfv_targets_rec.Target_Level_ID;

962: ;
963: END IF;
964: --
965: x_Target_Rec.Target_ID := l_bisfv_targets_rec.Target_ID;
966: x_Target_Rec.Target_Level_ID := l_bisfv_targets_rec.Target_Level_ID;
967: x_Target_Rec.Target_Level_Short_Name
968: := l_bisfv_targets_rec.Target_Level_Short_Name;
969: x_Target_Rec.Target_Level_Name
970: := l_bisfv_targets_rec.Target_Level_Name;

Line 968: := l_bisfv_targets_rec.Target_Level_Short_Name;

964: --
965: x_Target_Rec.Target_ID := l_bisfv_targets_rec.Target_ID;
966: x_Target_Rec.Target_Level_ID := l_bisfv_targets_rec.Target_Level_ID;
967: x_Target_Rec.Target_Level_Short_Name
968: := l_bisfv_targets_rec.Target_Level_Short_Name;
969: x_Target_Rec.Target_Level_Name
970: := l_bisfv_targets_rec.Target_Level_Name;
971: x_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;
972: x_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;

Line 970: := l_bisfv_targets_rec.Target_Level_Name;

966: x_Target_Rec.Target_Level_ID := l_bisfv_targets_rec.Target_Level_ID;
967: x_Target_Rec.Target_Level_Short_Name
968: := l_bisfv_targets_rec.Target_Level_Short_Name;
969: x_Target_Rec.Target_Level_Name
970: := l_bisfv_targets_rec.Target_Level_Name;
971: x_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;
972: x_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;
973: x_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;
974: x_Target_Rec.Org_Level_Value_ID

Line 971: x_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;

967: x_Target_Rec.Target_Level_Short_Name
968: := l_bisfv_targets_rec.Target_Level_Short_Name;
969: x_Target_Rec.Target_Level_Name
970: := l_bisfv_targets_rec.Target_Level_Name;
971: x_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;
972: x_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;
973: x_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;
974: x_Target_Rec.Org_Level_Value_ID
975: := l_bisfv_targets_rec.Org_Level_Value_ID;

Line 972: x_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;

968: := l_bisfv_targets_rec.Target_Level_Short_Name;
969: x_Target_Rec.Target_Level_Name
970: := l_bisfv_targets_rec.Target_Level_Name;
971: x_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;
972: x_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;
973: x_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;
974: x_Target_Rec.Org_Level_Value_ID
975: := l_bisfv_targets_rec.Org_Level_Value_ID;
976: x_Target_Rec.Time_Level_Value_ID

Line 973: x_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;

969: x_Target_Rec.Target_Level_Name
970: := l_bisfv_targets_rec.Target_Level_Name;
971: x_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;
972: x_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;
973: x_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;
974: x_Target_Rec.Org_Level_Value_ID
975: := l_bisfv_targets_rec.Org_Level_Value_ID;
976: x_Target_Rec.Time_Level_Value_ID
977: := l_bisfv_targets_rec.Time_Level_Value_ID;

Line 975: := l_bisfv_targets_rec.Org_Level_Value_ID;

971: x_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;
972: x_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;
973: x_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;
974: x_Target_Rec.Org_Level_Value_ID
975: := l_bisfv_targets_rec.Org_Level_Value_ID;
976: x_Target_Rec.Time_Level_Value_ID
977: := l_bisfv_targets_rec.Time_Level_Value_ID;
978: x_Target_Rec.Dim1_Level_Value_ID
979: := l_bisfv_targets_rec.Dim1_Level_Value_ID;

Line 977: := l_bisfv_targets_rec.Time_Level_Value_ID;

973: x_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;
974: x_Target_Rec.Org_Level_Value_ID
975: := l_bisfv_targets_rec.Org_Level_Value_ID;
976: x_Target_Rec.Time_Level_Value_ID
977: := l_bisfv_targets_rec.Time_Level_Value_ID;
978: x_Target_Rec.Dim1_Level_Value_ID
979: := l_bisfv_targets_rec.Dim1_Level_Value_ID;
980: x_Target_Rec.Dim2_Level_Value_ID
981: := l_bisfv_targets_rec.Dim2_Level_Value_ID;

Line 979: := l_bisfv_targets_rec.Dim1_Level_Value_ID;

975: := l_bisfv_targets_rec.Org_Level_Value_ID;
976: x_Target_Rec.Time_Level_Value_ID
977: := l_bisfv_targets_rec.Time_Level_Value_ID;
978: x_Target_Rec.Dim1_Level_Value_ID
979: := l_bisfv_targets_rec.Dim1_Level_Value_ID;
980: x_Target_Rec.Dim2_Level_Value_ID
981: := l_bisfv_targets_rec.Dim2_Level_Value_ID;
982: x_Target_Rec.Dim3_Level_Value_ID
983: := l_bisfv_targets_rec.Dim3_Level_Value_ID;

Line 981: := l_bisfv_targets_rec.Dim2_Level_Value_ID;

977: := l_bisfv_targets_rec.Time_Level_Value_ID;
978: x_Target_Rec.Dim1_Level_Value_ID
979: := l_bisfv_targets_rec.Dim1_Level_Value_ID;
980: x_Target_Rec.Dim2_Level_Value_ID
981: := l_bisfv_targets_rec.Dim2_Level_Value_ID;
982: x_Target_Rec.Dim3_Level_Value_ID
983: := l_bisfv_targets_rec.Dim3_Level_Value_ID;
984: x_Target_Rec.Dim4_Level_Value_ID
985: := l_bisfv_targets_rec.Dim4_Level_Value_ID;

Line 983: := l_bisfv_targets_rec.Dim3_Level_Value_ID;

979: := l_bisfv_targets_rec.Dim1_Level_Value_ID;
980: x_Target_Rec.Dim2_Level_Value_ID
981: := l_bisfv_targets_rec.Dim2_Level_Value_ID;
982: x_Target_Rec.Dim3_Level_Value_ID
983: := l_bisfv_targets_rec.Dim3_Level_Value_ID;
984: x_Target_Rec.Dim4_Level_Value_ID
985: := l_bisfv_targets_rec.Dim4_Level_Value_ID;
986: x_Target_Rec.Dim5_Level_Value_ID
987: := l_bisfv_targets_rec.Dim5_Level_Value_ID;

Line 985: := l_bisfv_targets_rec.Dim4_Level_Value_ID;

981: := l_bisfv_targets_rec.Dim2_Level_Value_ID;
982: x_Target_Rec.Dim3_Level_Value_ID
983: := l_bisfv_targets_rec.Dim3_Level_Value_ID;
984: x_Target_Rec.Dim4_Level_Value_ID
985: := l_bisfv_targets_rec.Dim4_Level_Value_ID;
986: x_Target_Rec.Dim5_Level_Value_ID
987: := l_bisfv_targets_rec.Dim5_Level_Value_ID;
988: x_Target_Rec.Dim6_Level_Value_ID
989: := l_bisfv_targets_rec.Dim6_Level_Value_ID;

Line 987: := l_bisfv_targets_rec.Dim5_Level_Value_ID;

983: := l_bisfv_targets_rec.Dim3_Level_Value_ID;
984: x_Target_Rec.Dim4_Level_Value_ID
985: := l_bisfv_targets_rec.Dim4_Level_Value_ID;
986: x_Target_Rec.Dim5_Level_Value_ID
987: := l_bisfv_targets_rec.Dim5_Level_Value_ID;
988: x_Target_Rec.Dim6_Level_Value_ID
989: := l_bisfv_targets_rec.Dim6_Level_Value_ID;
990: x_Target_Rec.Dim7_Level_Value_ID
991: := l_bisfv_targets_rec.Dim7_Level_Value_ID;

Line 989: := l_bisfv_targets_rec.Dim6_Level_Value_ID;

985: := l_bisfv_targets_rec.Dim4_Level_Value_ID;
986: x_Target_Rec.Dim5_Level_Value_ID
987: := l_bisfv_targets_rec.Dim5_Level_Value_ID;
988: x_Target_Rec.Dim6_Level_Value_ID
989: := l_bisfv_targets_rec.Dim6_Level_Value_ID;
990: x_Target_Rec.Dim7_Level_Value_ID
991: := l_bisfv_targets_rec.Dim7_Level_Value_ID;
992: x_Target_Rec.Target := l_bisfv_targets_rec.Target;
993: x_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;

Line 991: := l_bisfv_targets_rec.Dim7_Level_Value_ID;

987: := l_bisfv_targets_rec.Dim5_Level_Value_ID;
988: x_Target_Rec.Dim6_Level_Value_ID
989: := l_bisfv_targets_rec.Dim6_Level_Value_ID;
990: x_Target_Rec.Dim7_Level_Value_ID
991: := l_bisfv_targets_rec.Dim7_Level_Value_ID;
992: x_Target_Rec.Target := l_bisfv_targets_rec.Target;
993: x_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
994: x_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
995: x_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;

Line 992: x_Target_Rec.Target := l_bisfv_targets_rec.Target;

988: x_Target_Rec.Dim6_Level_Value_ID
989: := l_bisfv_targets_rec.Dim6_Level_Value_ID;
990: x_Target_Rec.Dim7_Level_Value_ID
991: := l_bisfv_targets_rec.Dim7_Level_Value_ID;
992: x_Target_Rec.Target := l_bisfv_targets_rec.Target;
993: x_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
994: x_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
995: x_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
996: x_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;

Line 993: x_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;

989: := l_bisfv_targets_rec.Dim6_Level_Value_ID;
990: x_Target_Rec.Dim7_Level_Value_ID
991: := l_bisfv_targets_rec.Dim7_Level_Value_ID;
992: x_Target_Rec.Target := l_bisfv_targets_rec.Target;
993: x_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
994: x_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
995: x_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
996: x_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
997: x_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;

Line 994: x_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;

990: x_Target_Rec.Dim7_Level_Value_ID
991: := l_bisfv_targets_rec.Dim7_Level_Value_ID;
992: x_Target_Rec.Target := l_bisfv_targets_rec.Target;
993: x_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
994: x_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
995: x_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
996: x_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
997: x_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
998: x_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;

Line 995: x_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;

991: := l_bisfv_targets_rec.Dim7_Level_Value_ID;
992: x_Target_Rec.Target := l_bisfv_targets_rec.Target;
993: x_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
994: x_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
995: x_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
996: x_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
997: x_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
998: x_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
999: x_Target_Rec.Notify_Resp1_ID := NVL(l_bisfv_targets_rec.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp1_Short_Name));

Line 996: x_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;

992: x_Target_Rec.Target := l_bisfv_targets_rec.Target;
993: x_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
994: x_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
995: x_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
996: x_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
997: x_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
998: x_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
999: x_Target_Rec.Notify_Resp1_ID := NVL(l_bisfv_targets_rec.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp1_Short_Name));
1000: x_Target_Rec.Notify_Resp1_Short_Name

Line 997: x_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;

993: x_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
994: x_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
995: x_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
996: x_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
997: x_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
998: x_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
999: x_Target_Rec.Notify_Resp1_ID := NVL(l_bisfv_targets_rec.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp1_Short_Name));
1000: x_Target_Rec.Notify_Resp1_Short_Name
1001: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;

Line 998: x_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;

994: x_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
995: x_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
996: x_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
997: x_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
998: x_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
999: x_Target_Rec.Notify_Resp1_ID := NVL(l_bisfv_targets_rec.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp1_Short_Name));
1000: x_Target_Rec.Notify_Resp1_Short_Name
1001: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1002: x_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;

Line 999: x_Target_Rec.Notify_Resp1_ID := NVL(l_bisfv_targets_rec.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp1_Short_Name));

995: x_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
996: x_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
997: x_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
998: x_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
999: x_Target_Rec.Notify_Resp1_ID := NVL(l_bisfv_targets_rec.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp1_Short_Name));
1000: x_Target_Rec.Notify_Resp1_Short_Name
1001: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1002: x_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1003: x_Target_Rec.Notify_Resp2_ID := NVL(l_bisfv_targets_rec.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp2_Short_Name));

Line 1001: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;

997: x_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
998: x_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
999: x_Target_Rec.Notify_Resp1_ID := NVL(l_bisfv_targets_rec.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp1_Short_Name));
1000: x_Target_Rec.Notify_Resp1_Short_Name
1001: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1002: x_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1003: x_Target_Rec.Notify_Resp2_ID := NVL(l_bisfv_targets_rec.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp2_Short_Name));
1004: x_Target_Rec.Notify_Resp2_Short_Name
1005: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;

Line 1002: x_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;

998: x_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
999: x_Target_Rec.Notify_Resp1_ID := NVL(l_bisfv_targets_rec.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp1_Short_Name));
1000: x_Target_Rec.Notify_Resp1_Short_Name
1001: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1002: x_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1003: x_Target_Rec.Notify_Resp2_ID := NVL(l_bisfv_targets_rec.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp2_Short_Name));
1004: x_Target_Rec.Notify_Resp2_Short_Name
1005: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1006: x_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;

Line 1003: x_Target_Rec.Notify_Resp2_ID := NVL(l_bisfv_targets_rec.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp2_Short_Name));

999: x_Target_Rec.Notify_Resp1_ID := NVL(l_bisfv_targets_rec.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp1_Short_Name));
1000: x_Target_Rec.Notify_Resp1_Short_Name
1001: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1002: x_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1003: x_Target_Rec.Notify_Resp2_ID := NVL(l_bisfv_targets_rec.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp2_Short_Name));
1004: x_Target_Rec.Notify_Resp2_Short_Name
1005: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1006: x_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1007: x_Target_Rec.Notify_Resp3_ID := NVL(l_bisfv_targets_rec.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp3_Short_Name));

Line 1005: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;

1001: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1002: x_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1003: x_Target_Rec.Notify_Resp2_ID := NVL(l_bisfv_targets_rec.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp2_Short_Name));
1004: x_Target_Rec.Notify_Resp2_Short_Name
1005: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1006: x_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1007: x_Target_Rec.Notify_Resp3_ID := NVL(l_bisfv_targets_rec.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp3_Short_Name));
1008: x_Target_Rec.Notify_Resp3_Short_Name
1009: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;

Line 1006: x_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;

1002: x_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1003: x_Target_Rec.Notify_Resp2_ID := NVL(l_bisfv_targets_rec.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp2_Short_Name));
1004: x_Target_Rec.Notify_Resp2_Short_Name
1005: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1006: x_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1007: x_Target_Rec.Notify_Resp3_ID := NVL(l_bisfv_targets_rec.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp3_Short_Name));
1008: x_Target_Rec.Notify_Resp3_Short_Name
1009: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;
1010: x_Target_Rec.Notify_Resp3_Name := l_bisfv_targets_rec.Notify_Resp3_Name;

Line 1007: x_Target_Rec.Notify_Resp3_ID := NVL(l_bisfv_targets_rec.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp3_Short_Name));

1003: x_Target_Rec.Notify_Resp2_ID := NVL(l_bisfv_targets_rec.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp2_Short_Name));
1004: x_Target_Rec.Notify_Resp2_Short_Name
1005: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1006: x_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1007: x_Target_Rec.Notify_Resp3_ID := NVL(l_bisfv_targets_rec.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp3_Short_Name));
1008: x_Target_Rec.Notify_Resp3_Short_Name
1009: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;
1010: x_Target_Rec.Notify_Resp3_Name := l_bisfv_targets_rec.Notify_Resp3_Name;
1011:

Line 1009: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;

1005: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1006: x_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1007: x_Target_Rec.Notify_Resp3_ID := NVL(l_bisfv_targets_rec.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp3_Short_Name));
1008: x_Target_Rec.Notify_Resp3_Short_Name
1009: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;
1010: x_Target_Rec.Notify_Resp3_Name := l_bisfv_targets_rec.Notify_Resp3_Name;
1011:
1012: -- if numeric target is missing, get the computed target
1013: --

Line 1010: x_Target_Rec.Notify_Resp3_Name := l_bisfv_targets_rec.Notify_Resp3_Name;

1006: x_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1007: x_Target_Rec.Notify_Resp3_ID := NVL(l_bisfv_targets_rec.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp3_Short_Name));
1008: x_Target_Rec.Notify_Resp3_Short_Name
1009: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;
1010: x_Target_Rec.Notify_Resp3_Name := l_bisfv_targets_rec.Notify_Resp3_Name;
1011:
1012: -- if numeric target is missing, get the computed target
1013: --
1014: IF ((BIS_UTILITIES_PUB.Value_Missing(x_Target_Rec.Target) = FND_API.G_TRUE)