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_APPLICATION_MEASURE_PVT dependencies on BIS_APPLICATION_MEASURE_PVT

Line 1: PACKAGE BODY BIS_Application_Measure_PVT AS

1: PACKAGE BODY BIS_Application_Measure_PVT AS
2: /* $Header: BISVAPMB.pls 120.0 2005/06/01 14:09:16 appldev noship $ */
3: --
4: /*
5: REM +=======================================================================+

Line 35: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_APPLICATION_MEASURE_PVT';

31: REM | 01-JUN-2005 akoduri Modified for Bug #4397786 |
32: REM +=======================================================================+
33: */
34: --
35: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_APPLICATION_MEASURE_PVT';
36: --
37: --
38: PROCEDURE Create_Application_Measure
39: ( p_api_version IN NUMBER

Line 42: BIS_Application_Measure_PVT.Application_Measure_Rec_Type

38: PROCEDURE Create_Application_Measure
39: ( p_api_version IN NUMBER
40: , p_commit IN VARCHAR2 := FND_API.G_FALSE
41: , p_Application_Measure_Rec IN
42: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
43: , x_return_status OUT NOCOPY VARCHAR2
44: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
45: )
46: IS

Line 81: BIS_Application_Measure_PVT.Application_Measure_Rec_Type

77: PROCEDURE Create_Application_Measure
78: ( p_api_version IN NUMBER
79: , p_commit IN VARCHAR2 := FND_API.G_FALSE
80: , p_Application_Measure_Rec IN
81: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
82: , p_owner IN VARCHAR2
83: , x_return_status OUT NOCOPY VARCHAR2
84: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
85: )

Line 90: l_rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;

86: IS
87: l_error_count number;
88: l_user_id number;
89: l_login_id number;
90: l_rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
91: l_rec_p BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
92: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
93:
94: CURSOR c_app_meas(cp_ind_id IN NUMBER) IS

Line 91: l_rec_p BIS_Application_Measure_PVT.Application_Measure_Rec_Type;

87: l_error_count number;
88: l_user_id number;
89: l_login_id number;
90: l_rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
91: l_rec_p BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
92: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
93:
94: CURSOR c_app_meas(cp_ind_id IN NUMBER) IS
95: SELECT count(1) FROM BIS_APPLICATION_MEASURES

Line 103: BIS_Application_Measure_PVT.Value_ID_Conversion

99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100: l_rec := p_Application_Measure_Rec;
101:
102: l_rec_p := l_rec;
103: BIS_Application_Measure_PVT.Value_ID_Conversion
104: ( p_api_version
105: , l_rec_p
106: , l_rec
107: , x_return_status

Line 112: BIS_Application_Measure_PVT.Validate_Application_Measure

108: , x_error_Tbl
109: );
110:
111:
112: BIS_Application_Measure_PVT.Validate_Application_Measure
113: ( p_api_version
114: , l_rec
115: , x_return_status
116: , x_error_Tbl

Line 226: BIS_Application_Measure_PVT.Application_Measure_Tbl_Type

222: ( p_api_version IN NUMBER
223: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
224: , p_all_info IN VARCHAR2
225: , x_Application_Measure_tbl OUT NOCOPY
226: BIS_Application_Measure_PVT.Application_Measure_Tbl_Type
227: , x_return_status OUT NOCOPY VARCHAR2
228: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
229: )
230: IS

Line 254: l_rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;

250: , Dataset_Id
251: from bisbv_application_measures
252: where measure_id = p_Measure_Rec.Measure_id;
253:
254: l_rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
255: l_flag number := 0;
256: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
257:
258: BEGIN

Line 344: BIS_Application_Measure_PVT.Application_Measure_Rec_Type

340: PROCEDURE Update_Application_Measure
341: ( p_api_version IN NUMBER
342: , p_commit IN VARCHAR2 := FND_API.G_FALSE
343: , p_Application_Measure_Rec IN
344: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
345: , x_return_status OUT NOCOPY VARCHAR2
346: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
347: )
348: IS

Line 383: BIS_Application_Measure_PVT.Application_Measure_Rec_Type

379: PROCEDURE Update_Application_Measure
380: ( p_api_version IN NUMBER
381: , p_commit IN VARCHAR2 := FND_API.G_FALSE
382: , p_Application_Measure_Rec IN
383: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
384: , p_owner IN VARCHAR2
385: , x_return_status OUT NOCOPY VARCHAR2
386: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
387: )

Line 391: l_rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;

387: )
388: IS
389: l_user_id number;
390: l_login_id number;
391: l_rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
392: l_rec_p BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
393: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
394: l_count number;
395: BEGIN

Line 392: l_rec_p BIS_Application_Measure_PVT.Application_Measure_Rec_Type;

388: IS
389: l_user_id number;
390: l_login_id number;
391: l_rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
392: l_rec_p BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
393: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
394: l_count number;
395: BEGIN
396:

Line 416: BIS_Application_Measure_PVT.Value_ID_Conversion

412: );
413: RAISE FND_API.G_EXC_ERROR;
414: end if;
415: l_rec_p := l_rec;
416: BIS_Application_Measure_PVT.Value_ID_Conversion
417: ( p_api_version
418: , l_rec_p
419: , l_rec
420: , x_return_status

Line 424: BIS_Application_Measure_PVT.Validate_Application_Measure

420: , x_return_status
421: , x_error_Tbl
422: );
423:
424: BIS_Application_Measure_PVT.Validate_Application_Measure
425: ( p_api_version
426: , p_Application_Measure_Rec
427: , x_return_status
428: , x_error_Tbl

Line 503: BIS_Application_Measure_PVT.Application_Measure_Rec_Type

499: PROCEDURE Delete_Application_Measure
500: ( p_api_version IN NUMBER
501: , p_commit IN VARCHAR2 := FND_API.G_FALSE
502: , p_Application_Measure_Rec IN
503: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
504: , x_return_status OUT NOCOPY VARCHAR2
505: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
506: )
507: IS

Line 508: l_rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;

504: , x_return_status OUT NOCOPY VARCHAR2
505: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
506: )
507: IS
508: l_rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
509: l_rec_p BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
510: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
511:
512: BEGIN

Line 509: l_rec_p BIS_Application_Measure_PVT.Application_Measure_Rec_Type;

505: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
506: )
507: IS
508: l_rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
509: l_rec_p BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
510: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
511:
512: BEGIN
513: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 516: BIS_Application_Measure_PVT.Value_ID_Conversion

512: BEGIN
513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514: l_rec := p_Application_Measure_Rec;
515: l_rec_p := l_rec;
516: BIS_Application_Measure_PVT.Value_ID_Conversion
517: ( p_api_version
518: , l_rec_p
519: , l_rec
520: , x_return_status

Line 524: BIS_Application_Measure_PVT.Validate_Application_Measure

520: , x_return_status
521: , x_error_Tbl
522: );
523:
524: BIS_Application_Measure_PVT.Validate_Application_Measure
525: ( p_api_version
526: , l_rec
527: , x_return_status
528: , x_error_Tbl

Line 583: BIS_Application_Measure_PVT.Application_Measure_Rec_Type

579: -- Validates measure
580: PROCEDURE Validate_Application_Measure
581: ( p_api_version IN NUMBER
582: ,p_Application_Measure_Rec IN
583: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
584: , x_return_status OUT NOCOPY VARCHAR2
585: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
586: )
587: IS

Line 675: BIS_Application_Measure_PVT.Application_Measure_Rec_Type

671: -- Value - ID conversion
672: PROCEDURE Value_ID_Conversion
673: ( p_api_version IN NUMBER
674: , p_Application_Measure_Rec IN
675: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
676: , x_Application_Measure_Rec IN OUT NOCOPY
677: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
678: , x_return_status OUT NOCOPY VARCHAR2
679: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 677: BIS_Application_Measure_PVT.Application_Measure_Rec_Type

673: ( p_api_version IN NUMBER
674: , p_Application_Measure_Rec IN
675: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
676: , x_Application_Measure_Rec IN OUT NOCOPY
677: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
678: , x_return_status OUT NOCOPY VARCHAR2
679: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
680: )
681: IS

Line 775: BIS_Application_Measure_PVT.Application_Measure_Rec_Type

771: --
772: PROCEDURE Retrieve_Last_Update_Date
773: ( p_api_version IN NUMBER
774: , p_Application_Measure_Rec IN
775: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
776: , x_last_update_date OUT NOCOPY DATE
777: , x_return_status OUT NOCOPY VARCHAR2
778: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
779: )

Line 834: BIS_Application_Measure_PVT.Application_Measure_Rec_Type

830: --
831: PROCEDURE Lock_Record
832: ( p_api_version IN NUMBER
833: , p_Application_Measure_Rec IN
834: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
835: , p_timestamp IN VARCHAR := NULL
836: , x_return_status OUT NOCOPY VARCHAR2
837: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
838: )

Line 843: l_Rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;

839: IS
840: --
841: l_form_date DATE;
842: l_last_update_date DATE;
843: l_Rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
844: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
845: --
846: BEGIN
847: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 901: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;

897: , x_msg_count OUT NOCOPY NUMBER
898: , x_msg_data OUT NOCOPY VARCHAR2
899: )
900: IS
901: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;
902: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
903: l_measure_id BIS_INDICATORS.INDICATOR_ID%TYPE;
904: BEGIN
905: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 915: BIS_APPLICATION_MEASURE_PVT.Update_Application_Measure( p_api_version

911: l_rec.Measure_id := l_measure_id;
912: l_rec.Application_id := p_Application_Id;
913: l_rec.owning_application := FND_API.G_FALSE;
914:
915: BIS_APPLICATION_MEASURE_PVT.Update_Application_Measure( p_api_version
916: , p_commit
917: , l_rec
918: , x_return_status
919: , l_error_tbl);

Line 946: x_msg_data := x_msg_data||' -> BIS_APPLICATION_MEASURE_PVT.Update_Application_Measure ';

942: ,p_data => x_msg_data);
943: WHEN OTHERS THEN
944: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
945: IF (x_msg_data IS NOT NULL) THEN
946: x_msg_data := x_msg_data||' -> BIS_APPLICATION_MEASURE_PVT.Update_Application_Measure ';
947: ELSE
948: x_msg_data := SQLERRM||' at BIS_APPLICATION_MEASURE_PVT.Update_Application_Measure ';
949: END IF;
950: END Update_Application_Measure;

Line 948: x_msg_data := SQLERRM||' at BIS_APPLICATION_MEASURE_PVT.Update_Application_Measure ';

944: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
945: IF (x_msg_data IS NOT NULL) THEN
946: x_msg_data := x_msg_data||' -> BIS_APPLICATION_MEASURE_PVT.Update_Application_Measure ';
947: ELSE
948: x_msg_data := SQLERRM||' at BIS_APPLICATION_MEASURE_PVT.Update_Application_Measure ';
949: END IF;
950: END Update_Application_Measure;
951: --
952: END BIS_Application_Measure_PVT;

Line 952: END BIS_Application_Measure_PVT;

948: x_msg_data := SQLERRM||' at BIS_APPLICATION_MEASURE_PVT.Update_Application_Measure ';
949: END IF;
950: END Update_Application_Measure;
951: --
952: END BIS_Application_Measure_PVT;