52: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
53: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
54: = FND_API.G_TRUE) then
55: --changed to call Measure_Value_ID_Conversion
56: BIS_Measure_PVT.Measure_Value_ID_Conversion
57: ( p_api_version => p_api_version
58: , p_Measure_Rec => p_Measure_Rec
59: , x_Measure_Rec => l_Measure_Rec
60: , x_return_status => x_return_status
78:
79:
80: -- used the following proc instead and added the if check
81: l_measure_rec_p := l_Measure_Rec;
82: BIS_MEASURE_PVT.Dimension_Value_ID_Conversion
83: ( p_api_version => p_api_version
84: , p_Measure_Rec => l_measure_rec_p
85: , x_Measure_Rec => l_Measure_Rec
86: , x_return_status => x_return_status
91: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) then
92: RAISE FND_API.G_EXC_ERROR;
93: END IF;
94:
95: BIS_Measure_PVT.Create_Measure
96: ( p_api_version => p_api_version
97: , p_commit => p_commit
98: , p_Measure_Rec => l_Measure_Rec
99: , p_owner => p_owner
135: l_Measure_Rec BIS_Measure_PUB.Measure_Rec_Type;
136: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
137: BEGIN
138:
139: BIS_Measure_PVT.Retrieve_Measures
140: ( p_api_version => p_api_version
141: , p_all_info => p_all_info
142: , x_Measure_Tbl => x_Measure_Tbl
143: , x_return_status => x_return_status
187: OR
188: BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id) = FND_API.G_TRUE)
189: THEN
190: --changed to call Measure_Value_ID_Conversion
191: BIS_Measure_PVT.Measure_Value_ID_Conversion
192: ( p_api_version => p_api_version
193: , p_Measure_Rec => p_Measure_Rec
194: , x_Measure_Rec => l_Measure_Rec
195: , x_return_status => x_return_status
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203: END IF;
204:
205: BIS_Measure_PVT.Retrieve_Measure
206: ( p_api_version => p_api_version
207: , p_Measure_Rec => l_Measure_Rec
208: , p_all_info => p_all_info
209: , x_Measure_Rec => x_Measure_Rec
255: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
256: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
257: = FND_API.G_TRUE) then
258: --changed to call Measure_Value_ID_Conversion
259: BIS_Measure_PVT.Measure_Value_ID_Conversion
260: ( p_api_version => p_api_version
261: , p_Measure_Rec => p_Measure_Rec
262: , x_Measure_Rec => l_Measure_Rec
263: , x_return_status => x_return_status
270: END IF;
271:
272: --added this call
273: l_measure_rec_p := l_Measure_Rec;
274: BIS_Measure_PVT.Dimension_Value_ID_Conversion
275: ( p_api_version => p_api_version
276: , p_Measure_Rec => l_measure_rec_p
277: , x_Measure_Rec => l_Measure_Rec
278: , x_return_status => x_return_status
282: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:
286: BIS_Measure_PVT.Update_Measure
287: ( p_api_version => p_api_version
288: , p_commit => p_commit
289: , p_Measure_Rec => l_Measure_Rec
290: , p_owner => p_owner
335: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
336: = FND_API.G_TRUE) then
337: --changed to call Measure_Value_ID_Conversion
338: --used to call Value_ID_Conv with shortname
339: BIS_Measure_PVT.Measure_Value_ID_Conversion
340: ( p_api_version => p_api_version
341: , p_Measure_Rec => p_Measure_Rec
342: , x_Measure_Rec => l_Measure_Rec
343: , x_return_status => x_return_status
349: END IF;
350:
351: end if;
352:
353: BIS_Measure_PVT.Delete_Measure
354: ( p_api_version => p_api_version
355: , p_commit => p_commit
356: , p_Measure_Rec => l_Measure_Rec
357: , x_return_status => x_return_status
390: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
391: BEGIN
392: l_Measure_Rec := p_Measure_Rec;
393: --changed to call Measure_Value_ID_Conversion
394: BIS_Measure_PVT.Measure_Value_ID_Conversion
395: ( p_api_version => p_api_version
396: , p_Measure_Rec => p_Measure_Rec
397: , x_Measure_Rec => l_Measure_Rec
398: , x_return_status => x_return_status
404: END IF;
405:
406: --added this call
407: l_measure_rec_p := l_Measure_Rec;
408: BIS_Measure_PVT.Dimension_Value_ID_Conversion
409: ( p_api_version => p_api_version
410: , p_Measure_Rec => l_measure_rec_p
411: , x_Measure_Rec => l_Measure_Rec
412: , x_return_status => x_return_status
416: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419:
420: BIS_Measure_PVT.Validate_Measure
421: ( p_api_version => p_api_version
422: , p_Measure_Rec => l_Measure_Rec
423: , x_return_status => x_return_status
424: , x_error_Tbl => x_error_Tbl
462: OR BIS_UTILITIES_PUB.Value_NULL(l_Measure_Rec.Measure_id)
463: = FND_API.G_TRUE) then
464: --changed to call Measure_Value_ID_Conversion
465: --used to call Value_ID_Conversion with short name
466: BIS_MEASURE_PVT.Measure_Value_ID_Conversion
467: ( p_api_version => p_api_version
468: , p_Measure_Rec => p_Measure_Rec
469: , x_Measure_Rec => l_Measure_Rec
470: , x_return_status => x_return_status
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477: end if;
478:
479: BIS_Measure_PVT.Retrieve_Measure_Dimensions
480: ( p_api_version => p_api_version
481: , p_Measure_Rec => l_Measure_Rec
482: , x_dimension_Tbl => x_dimension_Tbl
483: , x_return_status => x_return_status
528:
529: l_Measure_Rec := p_Measure_Rec;
530:
531: --changed to call Measure_Value_ID_Conversion
532: BIS_MEASURE_PVT.Measure_Value_ID_Conversion
533: ( p_api_version => p_api_version
534: , p_Measure_Rec => p_Measure_Rec
535: , x_Measure_Rec => l_Measure_Rec
536: , x_return_status => x_return_status
543: end if;
544:
545: --added this call
546: l_measure_rec_p := l_Measure_Rec;
547: BIS_Measure_PVT.Dimension_Value_ID_Conversion
548: ( p_api_version => p_api_version
549: , p_Measure_Rec => l_measure_rec_p
550: , x_Measure_Rec => l_Measure_Rec
551: , x_return_status => x_return_status
556: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559:
560: BIS_MEASURE_PVT.Translate_Measure
561: ( p_api_version => p_api_version
562: , p_commit => p_commit
563: , p_validation_level => p_validation_level
564: , p_Measure_Rec => l_Measure_Rec
610: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
611: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
612: = FND_API.G_TRUE) then
613: --changed to call Measure_Value_ID_Conversion
614: BIS_MEASURE_PVT.Measure_Value_ID_Conversion
615: ( p_api_version => p_api_version
616: , p_Measure_Rec => p_Measure_Rec
617: , x_Measure_Rec => l_Measure_Rec
618: , x_return_status => x_return_status
622:
623: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
624: l_measure_rec_p := l_Measure_Rec;
625: --added this call
626: BIS_Measure_PVT.Dimension_Value_ID_Conversion
627: ( p_api_version => p_api_version
628: , p_Measure_Rec => l_measure_rec_p
629: , x_Measure_Rec => l_Measure_Rec
630: , x_return_status => x_return_status
634: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
635: RAISE FND_API.G_EXC_ERROR;
636: END IF;
637:
638: BIS_MEASURE_PVT.Create_Measure
639: ( p_api_version => p_api_version
640: , p_commit => p_commit
641: , p_validation_level => p_validation_level
642: , p_Measure_Rec => l_Measure_Rec
646: );
647: ELSE
648: --added this call
649: l_measure_rec_p := l_Measure_Rec;
650: BIS_Measure_PVT.Dimension_Value_ID_Conversion
651: ( p_api_version => p_api_version
652: , p_Measure_Rec => l_measure_rec_p
653: , x_Measure_Rec => l_Measure_Rec
654: , x_return_status => x_return_status
658: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;
661:
662: BIS_MEASURE_PVT.Update_Measure
663: ( p_api_version => p_api_version
664: , p_commit => p_commit
665: , p_validation_level => p_validation_level
666: , p_Measure_Rec => l_Measure_Rec
745: IF (BIS_UTILITIES_PUB.Value_Missing
746: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
747: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
748: = FND_API.G_TRUE) then
749: BIS_MEASURE_PVT.Measure_Value_ID_Conversion
750: ( p_api_version => p_api_version
751: , p_Measure_Rec => p_Measure_Rec
752: , x_Measure_Rec => l_Measure_Rec
753: , x_return_status => x_return_status
757:
758:
759: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
760: l_measure_rec_p := l_Measure_Rec;
761: BIS_Measure_PVT.Dimension_Value_ID_Conversion
762: ( p_api_version => p_api_version
763: , p_Measure_Rec => l_measure_rec_p
764: , x_Measure_Rec => l_Measure_Rec
765: , x_return_status => x_return_status
809:
810: END IF;
811:
812: -- Changed to call the new overloaded Create_Measure
813: BIS_MEASURE_PVT.Create_Measure
814: ( p_api_version => p_api_version
815: , p_commit => p_commit
816: , p_validation_level => p_validation_level
817: , p_Measure_Rec => l_Measure_Rec
823: );
824:
825: ELSE
826: l_measure_rec_p := l_Measure_Rec;
827: BIS_Measure_PVT.Dimension_Value_ID_Conversion
828: ( p_api_version => p_api_version
829: , p_Measure_Rec => l_measure_rec_p
830: , x_Measure_Rec => l_Measure_Rec
831: , x_return_status => x_return_status
875:
876: END IF;
877:
878: -- Changed to call the new overloaded Create_Measure
879: BIS_MEASURE_PVT.Update_Measure
880: ( p_api_version => p_api_version
881: , p_commit => p_commit
882: , p_validation_level => p_validation_level
883: , p_Measure_Rec => l_Measure_Rec
919: -- for last_updated_by , created_by as 1
920: PROCEDURE updt_pm_owner(p_pm_short_name IN VARCHAR2
921: ,x_return_status OUT NOCOPY VARCHAR2) AS
922: BEGIN
923: BIS_MEASURE_PVT.updt_pm_owner(p_pm_short_name => p_pm_short_name
924: ,x_return_status => x_return_status);
925: EXCEPTION
926: WHEN OTHERS THEN
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941: IS
942:
943: BEGIN
944:
945: BIS_MEASURE_PVT.Translate_Measure_By_lang
946: ( p_api_version => p_api_version
947: , p_commit => p_commit
948: , p_Measure_Rec => p_Measure_Rec
949: , p_owner => p_owner
976: FUNCTION GET_CUSTOMIZED_ENABLED( p_indicator_id IN NUMBER )
977: RETURN VARCHAR2
978: IS
979: BEGIN
980: RETURN BIS_MEASURE_PVT.GET_CUSTOMIZED_ENABLED (p_indicator_id => p_indicator_id);
981:
982: END GET_CUSTOMIZED_ENABLED;
983:
984: END BIS_MEASURE_PUB;