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_LEVEL_PVT dependencies on BIS_DIMENSION_LEVEL_PUB

Line 57: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

53: -- returns the record with the G_MISS_CHAR/G_MISS_NUM replaced
54: -- by null
55: --
56: PROCEDURE SetNULL
57: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
58: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
59: );
60:
61: --==================================================================

Line 58: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

54: -- by null
55: --
56: PROCEDURE SetNULL
57: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
58: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
59: );
60:
61: --==================================================================
62:

Line 154: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

150:
151:
152: --
153: PROCEDURE SetNULL
154: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
155: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
156: )
157: IS
158: BEGIN

Line 155: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

151:
152: --
153: PROCEDURE SetNULL
154: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
155: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
156: )
157: IS
158: BEGIN
159:

Line 371: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

367: IS
368:
369: l_target_level_id number;
370:
371: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
372: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
373: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
374: l_return_status VARCHAR2(100);
375: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 377: l_Dimension_Level_Rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

373: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
374: l_return_status VARCHAR2(100);
375: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
376: l_Measure_Rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
377: l_Dimension_Level_Rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
378:
379: BEGIN
380: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Measure_ID)
381: = FND_API.G_TRUE) then

Line 1232: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

1228: l_wf_process_name VARCHAR2(80);
1229: l_Def_Notify_Resp_short_name VARCHAR2(100);
1230: l_Def_Notify_Resp_name VARCHAR2(240);
1231: l_Def_Notify_Resp_ID NUMBER;
1232: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1233: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1234: BEGIN
1235: x_return_status := FND_API.G_RET_STS_SUCCESS;
1236:

Line 3291: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

3287: --
3288: PROCEDURE Retrieve_Time_level
3289: ( p_api_version IN NUMBER
3290: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3291: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
3292: , x_dimension_level_number OUT NOCOPY NUMBER
3293: , x_return_status OUT NOCOPY VARCHAR2
3294: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3295: )

Line 3299: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

3295: )
3296: IS
3297:
3298: l_time_dimension_id NUMBER;
3299: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
3300: l_dimension_level_tbl BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type;
3301: l_found NUMBER := 0;
3302: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3303:

Line 3300: l_dimension_level_tbl BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type;

3296: IS
3297:
3298: l_time_dimension_id NUMBER;
3299: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
3300: l_dimension_level_tbl BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type;
3301: l_found NUMBER := 0;
3302: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3303:
3304: CURSOR cr_tl_id_dim_level(p_target_level_id NUMBER) IS

Line 3417: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level

3413: where upper(dimension_short_name) =
3414: BIS_UTILITIES_PVT.Get_Time_Dimension_Name;
3415: */
3416: FOR i IN 1..l_dimension_level_tbl.COUNT LOOP
3417: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level
3418: ( p_api_version
3419: , p_Dimension_Level_Rec => l_dimension_level_tbl(i)
3420: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
3421: , x_return_status => x_return_status

Line 3477: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

3473: )
3474: IS
3475:
3476: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
3477: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
3478: l_dimension_level_number NUMBER;
3479: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3480: l_return_status VARCHAR2(32000);
3481:

Line 3511: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

3507:
3508: PROCEDURE Retrieve_Org_level
3509: ( p_api_version IN NUMBER
3510: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3511: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
3512: , x_dimension_level_number OUT NOCOPY NUMBER
3513: , x_return_status OUT NOCOPY VARCHAR2
3514: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3515: )

Line 3520: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

3516: IS
3517:
3518: l_org_dimension_id NUMBER;
3519: l_dimension_short_name VARCHAR2(80);
3520: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
3521: l_dimension_level_tbl BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type;
3522: l_err_track NUMBER := 0;
3523: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3524:

Line 3521: l_dimension_level_tbl BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type;

3517:
3518: l_org_dimension_id NUMBER;
3519: l_dimension_short_name VARCHAR2(80);
3520: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
3521: l_dimension_level_tbl BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type;
3522: l_err_track NUMBER := 0;
3523: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3524:
3525:

Line 3671: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level

3667:
3668: FOR i IN 1..l_dimension_level_tbl.COUNT
3669: LOOP
3670:
3671: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level
3672: ( p_api_version
3673: , p_Dimension_Level_Rec => l_dimension_level_tbl(i)
3674: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
3675: , x_return_status => x_return_status

Line 3732: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;

3728: )
3729: IS
3730: l_measure_rec BIS_MEASURE_PUB.MEASURE_REC_TYPE;
3731: l_measure_rec_p BIS_MEASURE_PUB.MEASURE_REC_TYPE;
3732: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3733: l_dim_level_rec_p BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3734: l_target_level_id NUMBER;
3735: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3736:

Line 3733: l_dim_level_rec_p BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;

3729: IS
3730: l_measure_rec BIS_MEASURE_PUB.MEASURE_REC_TYPE;
3731: l_measure_rec_p BIS_MEASURE_PUB.MEASURE_REC_TYPE;
3732: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3733: l_dim_level_rec_p BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3734: l_target_level_id NUMBER;
3735: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3736:
3737: l_dim1_id NUMBER;

Line 3847: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3843: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension1_level_id)= FND_API.G_TRUE) THEN
3844: SetNULL(l_dim_level_rec,l_dim_level_rec);
3845: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension1_level_id;
3846: l_dim_level_rec_p := l_dim_level_rec;
3847: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3848: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3849: ,x_Dimension_Level_Rec => l_dim_level_rec
3850: ,x_return_status => x_return_status
3851: ,x_error_Tbl => x_error_tbl

Line 3861: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3857: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension2_level_id)= FND_API.G_TRUE) THEN
3858: SetNULL(l_dim_level_rec,l_dim_level_rec);
3859: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension2_level_id;
3860: l_dim_level_rec_p := l_dim_level_rec;
3861: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3862: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3863: ,x_Dimension_Level_Rec => l_dim_level_rec
3864: ,x_return_status => x_return_status
3865: ,x_error_Tbl => x_error_tbl

Line 3875: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3871: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension3_level_id)= FND_API.G_TRUE) THEN
3872: SetNULL(l_dim_level_rec,l_dim_level_rec);
3873: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension3_level_id;
3874: l_dim_level_rec_p := l_dim_level_rec;
3875: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3876: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3877: ,x_Dimension_Level_Rec => l_dim_level_rec
3878: ,x_return_status => x_return_status
3879: ,x_error_Tbl => x_error_tbl

Line 3889: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3885: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension4_level_id)= FND_API.G_TRUE) THEN
3886: SetNULL(l_dim_level_rec,l_dim_level_rec);
3887: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension4_level_id;
3888: l_dim_level_rec_p := l_dim_level_rec;
3889: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3890: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3891: ,x_Dimension_Level_Rec => l_dim_level_rec
3892: ,x_return_status => x_return_status
3893: ,x_error_Tbl => x_error_tbl

Line 3903: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3899: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension5_level_id)= FND_API.G_TRUE) THEN
3900: SetNULL(l_dim_level_rec,l_dim_level_rec);
3901: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension5_level_id;
3902: l_dim_level_rec_p := l_dim_level_rec;
3903: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3904: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3905: ,x_Dimension_Level_Rec => l_dim_level_rec
3906: ,x_return_status => x_return_status
3907: ,x_error_Tbl => x_error_tbl

Line 3917: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3913: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension6_level_id)= FND_API.G_TRUE) THEN
3914: SetNULL(l_dim_level_rec,l_dim_level_rec);
3915: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension6_level_id;
3916: l_dim_level_rec_p := l_dim_level_rec;
3917: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3918: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3919: ,x_Dimension_Level_Rec => l_dim_level_rec
3920: ,x_return_status => x_return_status
3921: ,x_error_Tbl => x_error_tbl

Line 3931: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3927: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension7_level_id)= FND_API.G_TRUE) THEN
3928: SetNULL(l_dim_level_rec,l_dim_level_rec);
3929: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension7_level_id;
3930: l_dim_level_rec_p := l_dim_level_rec;
3931: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3932: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3933: ,x_Dimension_Level_Rec => l_dim_level_rec
3934: ,x_return_status => x_return_status
3935: ,x_error_Tbl => x_error_tbl