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_UTILITIES_PUB

Line 28: REM | BIS_UTILITIES_PUB.Get_Owner_Id to lookup user_id |

24: REM | 08-JUL-2003 mdamle Fix to support bad data |
25: REM | 08-JUL-2003 rchandra For bug 3008385,Only one record can be created in|
26: REM | BIS_APPICATION_MEASURES table for an indicator | |
27: REM | 27-JUL-2004 sawu Modified create/update application measure to use |
28: REM | BIS_UTILITIES_PUB.Get_Owner_Id to lookup user_id |
29: REM | 29-SEP-2004 ankgoel Added WHO columns in Rec for Bug#3891748 |
30: REM | 21-MAR-2005 ankagarw bug#4235732 - changing count(*) to count(1) |
31: REM | 01-JUN-2005 akoduri Modified for Bug #4397786 |
32: REM +=======================================================================+

Line 44: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
47: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
48: BEGIN

Line 47: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

43: , x_return_status OUT NOCOPY VARCHAR2
44: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
45: )
46: IS
47: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
48: BEGIN
49:
50: Create_Application_Measure
51: ( p_api_version => p_api_version

Line 54: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

50: Create_Application_Measure
51: ( p_api_version => p_api_version
52: , p_commit => p_commit
53: , p_Application_Measure_Rec => p_Application_Measure_Rec
54: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
55: , x_return_status => x_return_status
56: , x_error_Tbl => x_error_Tbl
57: );
58:

Line 84: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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: )
86: IS
87: l_error_count number;
88: l_user_id number;

Line 92: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

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
96: WHERE indicator_id = cp_ind_id;

Line 141: l_Rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

137: -- ankgoel: bug#3891748 - Created_By will take precedence over Owner.
138: -- Last_Updated_By can be different from Created_By while creating measures
139: -- during sync-up
140: IF (l_Rec.Created_By IS NULL) THEN
141: l_Rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
142: END IF;
143: IF (l_Rec.Last_Updated_By IS NULL) THEN
144: l_Rec.Last_Updated_By := l_Rec.Created_By;
145: END IF;

Line 228: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_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
231:
232: CURSOR all_info_cursor is

Line 256: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

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
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260:

Line 299: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

295: BIS_UTILITIES_PVT.Add_Error_Message
296: ( p_error_msg_name => 'BIS_INVALID_MEASURE_ID'
297: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
298: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Application_Measures'
299: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
300: , p_error_table => l_error_tbl
301: , x_error_table => x_error_tbl
302: );
303: RAISE FND_API.G_EXC_ERROR;

Line 346: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
349: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
350: BEGIN

Line 349: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

345: , x_return_status OUT NOCOPY VARCHAR2
346: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
347: )
348: IS
349: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
350: BEGIN
351:
352: Update_Application_Measure
353: ( p_api_version => p_api_version

Line 356: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

352: Update_Application_Measure
353: ( p_api_version => p_api_version
354: , p_commit => p_commit
355: , p_Application_Measure_Rec => p_Application_Measure_Rec
356: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
357: , x_return_status => x_return_status
358: , x_error_Tbl => x_error_Tbl
359: );
360:

Line 386: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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: )
388: IS
389: l_user_id number;
390: l_login_id number;

Line 393: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

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:
397: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 400: if ( BIS_UTILITIES_PUB.Value_Missing(l_Rec.Owning_Application)=FND_API.G_TRUE

396:
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398: l_rec := p_Application_Measure_Rec;
399:
400: if ( BIS_UTILITIES_PUB.Value_Missing(l_Rec.Owning_Application)=FND_API.G_TRUE
401: OR BIS_UTILITIES_PUB.Value_NULL(l_Rec.Owning_Application)=FND_API.G_TRUE
402: ) then
403: --added last two params
404: l_error_tbl := x_error_Tbl;

Line 401: OR BIS_UTILITIES_PUB.Value_NULL(l_Rec.Owning_Application)=FND_API.G_TRUE

397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398: l_rec := p_Application_Measure_Rec;
399:
400: if ( BIS_UTILITIES_PUB.Value_Missing(l_Rec.Owning_Application)=FND_API.G_TRUE
401: OR BIS_UTILITIES_PUB.Value_NULL(l_Rec.Owning_Application)=FND_API.G_TRUE
402: ) then
403: --added last two params
404: l_error_tbl := x_error_Tbl;
405: BIS_UTILITIES_PVT.Add_Error_Message

Line 409: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

405: BIS_UTILITIES_PVT.Add_Error_Message
406: ( p_error_msg_name => 'BIS_INVALID_OWNING_APP_VALUE'
407: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
408: , p_error_proc_name => G_PKG_NAME||'.Update_Application_Measure'
409: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
410: , p_error_table => l_error_tbl
411: , x_error_table => x_error_tbl
412: );
413: RAISE FND_API.G_EXC_ERROR;

Line 432: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

428: , x_error_Tbl
429: );
430:
431:
432: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
433:
434: l_login_id := fnd_global.LOGIN_ID;
435:
436: -- mdamle 07/08/2003 - There have been occurrences of bad data when

Line 505: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
508: l_rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
509: l_rec_p BIS_Application_Measure_PVT.Application_Measure_Rec_Type;

Line 510: l_error_tbl 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;
514: l_rec := p_Application_Measure_Rec;

Line 554: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

550: BIS_UTILITIES_PVT.Add_Error_Message
551: ( p_error_msg_name => 'BIS_INVALID_APPORMEASURE_ID'
552: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
553: , p_error_proc_name => G_PKG_NAME||'.Delete_Application_Measure'
554: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
555: , p_error_table => l_error_tbl
556: , x_error_table => x_error_tbl
557: );
558: --RAISE FND_API.G_EXC_ERROR;

Line 585: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
588: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
589: l_app_rec BIS_APPLICATION_PVT.Application_Rec_Type;

Line 590: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

586: )
587: IS
588: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
589: l_app_rec BIS_APPLICATION_PVT.Application_Rec_Type;
590: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
591: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
592: BEGIN
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:

Line 591: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

587: IS
588: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
589: l_app_rec BIS_APPLICATION_PVT.Application_Rec_Type;
590: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
591: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
592: BEGIN
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: -- if application id is -1 then we need to skip validating the application

Line 679: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
682: -- l_error_count number;
683: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;

Line 685: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

681: IS
682: -- l_error_count number;
683: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
684: l_app_rec BIS_APPLICATION_PVT.Application_Rec_Type;
685: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
686: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
687: l_app_rec_p BIS_APPLICATION_PVT.Application_Rec_Type;
688: BEGIN
689: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 697: if (BIS_UTILITIES_PUB.Value_Missing

693: l_measure_rec.measure_short_name
694: := p_Application_Measure_Rec.Measure_Short_name;
695: l_measure_rec.measure_name := p_Application_Measure_Rec.Measure_name;
696:
697: if (BIS_UTILITIES_PUB.Value_Missing
698: (l_Measure_Rec.Measure_id) = FND_API.G_TRUE
699: OR BIS_UTILITIES_PUB.Value_NULL(l_Measure_Rec.Measure_id)
700: = FND_API.G_TRUE)
701: then

Line 699: OR BIS_UTILITIES_PUB.Value_NULL(l_Measure_Rec.Measure_id)

695: l_measure_rec.measure_name := p_Application_Measure_Rec.Measure_name;
696:
697: if (BIS_UTILITIES_PUB.Value_Missing
698: (l_Measure_Rec.Measure_id) = FND_API.G_TRUE
699: OR BIS_UTILITIES_PUB.Value_NULL(l_Measure_Rec.Measure_id)
700: = FND_API.G_TRUE)
701: then
702: BEGIN
703: l_measure_rec_p := l_measure_rec;

Line 723: OR BIS_UTILITIES_PUB.Value_Missing(l_app_rec.application_id) = FND_API.G_TRUE) then

719: p_Application_Measure_Rec.Application_Short_name;
720: l_app_rec.Application_name := p_Application_Measure_Rec.Application_name;
721:
722: if ( l_app_rec.application_id is NULL
723: OR BIS_UTILITIES_PUB.Value_Missing(l_app_rec.application_id) = FND_API.G_TRUE) then
724: l_app_rec_p := l_app_rec;
725: BIS_APPLICATION_PVT.Value_Id_conversion
726: ( p_api_version => 1.0
727: , p_application_Rec => l_app_rec_p

Line 778: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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: )
780: IS
781: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
782: BEGIN

Line 781: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

777: , x_return_status OUT NOCOPY VARCHAR2
778: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
779: )
780: IS
781: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
782: BEGIN
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: IF( BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Measure_id)
785: = FND_API.G_FALSE

Line 784: IF( BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Measure_id)

780: IS
781: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
782: BEGIN
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: IF( BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Measure_id)
785: = FND_API.G_FALSE
786: AND BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Application_id)
787: = FND_API.G_FALSE
788: ) THEN

Line 786: AND BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Application_id)

782: BEGIN
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: IF( BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Measure_id)
785: = FND_API.G_FALSE
786: AND BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Application_id)
787: = FND_API.G_FALSE
788: ) THEN
789: SELECT NVL(LAST_UPDATE_DATE, CREATION_DATE)
790: INTO x_last_update_date

Line 807: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

803: BIS_UTILITIES_PVT.Add_Error_Message
804: ( p_error_msg_name => 'BIS_INVALID_APPORMEASURE_ID'
805: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
806: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Last_Update_Date'
807: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
808: , p_error_table => l_error_tbl
809: , x_error_table => x_error_tbl
810: );
811: --RAISE FND_API.G_EXC_ERROR;

Line 837: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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: )
839: IS
840: --
841: l_form_date DATE;

Line 844: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

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;
848: --

Line 902: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

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;
906: SELECT indicator_id