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_ACTUAL_PVT dependencies on BIS_UTILITIES_PUB

Line 26: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

22: IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
23: ,x_Indicator_Region_Tbl
24: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type
25: ,x_return_status OUT NOCOPY VARCHAR2
26: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
27: )
28: IS
29: i NUMBER := 0;
30: l_Target_Level_id NUMBER;

Line 50: IF BIS_UTILITIES_PUB.Value_Missing (p_Target_Level_Rec.Target_Level_ID)

46: BEGIN
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49: /*
50: IF BIS_UTILITIES_PUB.Value_Missing (p_Target_Level_Rec.Target_Level_ID)
51: = FND_API.G_TRUE
52: THEN
53:
54: BIS_TARGET_LEVEL_PUB.Retrieve_Target_Level

Line 101: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

97: IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
98: ,x_Indicator_Region_Tbl
99: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type
100: ,x_return_status OUT NOCOPY VARCHAR2
101: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
102: )
103: IS
104: i NUMBER := 0;
105: l_Target_Level_id NUMBER;

Line 127: BIS_UTILITIES_PUB.put_line(p_text => 'Target Level Id to get User_ind_sel : '

123: x_return_status := FND_API.G_RET_STS_SUCCESS;
124:
125: l_Target_Level_id := p_Target_level_Rec.Target_Level_id;
126:
127: BIS_UTILITIES_PUB.put_line(p_text => 'Target Level Id to get User_ind_sel : '
128: || l_Target_Level_id);
129:
130: FOR cr IN cr_tl_selections LOOP
131:

Line 162: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

158: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
159: ,p_commit IN VARCHAR2 Default FND_API.G_FALSE
160: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
161: ,x_return_status OUT NOCOPY VARCHAR2
162: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
163: )
164: IS
165:
166: l_target_level_id NUMBER;

Line 175: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

171: l_actual_id NUMBER;
172: l_action VARCHAR2(10);
173: l_Return_Status VARCHAR2(1);
174: e_invalidActualException EXCEPTION;
175: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
176:
177: CURSOR cr_actual IS
178: SELECT ACTUAL_ID
179: -- SELECT creation_date, last_update_date

Line 220: /*IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Time_Level_Value_ID)

216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218:
219: -- $$
220: /*IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Time_Level_Value_ID)
221: = FND_API.G_TRUE
222: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Time_Level_Value_ID)
223: = FND_API.G_TRUE
224: THEN

Line 222: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Time_Level_Value_ID)

218:
219: -- $$
220: /*IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Time_Level_Value_ID)
221: = FND_API.G_TRUE
222: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Time_Level_Value_ID)
223: = FND_API.G_TRUE
224: THEN
225:
226: -- get the period_name for the current date

Line 386: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

382: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
383: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
384: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
385: ,x_return_status OUT NOCOPY VARCHAR2
386: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
387: )
388: IS
389:
390: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;

Line 393: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

389:
390: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
391: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
392: l_Target_Level_Rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
393: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
394:
395:
396: CURSOR cr_bv_actual (p_actual_rec BIS_ACTUAL_PUB.ACTUAL_Rec_Type) IS
397: SELECT

Line 474: IF ((BIS_UTILITIES_PUB.Value_Missing

470: BEGIN
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472: l_Actual_Rec := p_Actual_Rec;
473:
474: IF ((BIS_UTILITIES_PUB.Value_Missing
475: (l_Actual_Rec.target_level_ID) = FND_API.G_TRUE)
476: AND (BIS_UTILITIES_PUB.Value_Null
477: (l_Actual_Rec.target_level_ID) = FND_API.G_TRUE))
478: THEN

Line 476: AND (BIS_UTILITIES_PUB.Value_Null

472: l_Actual_Rec := p_Actual_Rec;
473:
474: IF ((BIS_UTILITIES_PUB.Value_Missing
475: (l_Actual_Rec.target_level_ID) = FND_API.G_TRUE)
476: AND (BIS_UTILITIES_PUB.Value_Null
477: (l_Actual_Rec.target_level_ID) = FND_API.G_TRUE))
478: THEN
479: l_Target_Level_Rec.target_level_ID := p_Actual_Rec.target_level_ID;
480: l_Target_Level_Rec_p := l_Target_Level_Rec;

Line 520: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

516: BIS_UTILITIES_PVT.Add_Error_Message
517: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
518: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
519: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Actual'
520: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
521: , p_error_table => l_error_tbl
522: , x_error_table => x_error_tbl
523: );
524: RAISE FND_API.G_EXC_ERROR;

Line 556: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

552: BIS_UTILITIES_PVT.Add_Error_Message
553: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
554: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
555: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Actual'
556: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
557: , p_error_table => l_error_tbl
558: , x_error_table => x_error_tbl
559: );
560: RAISE FND_API.G_EXC_ERROR;

Line 615: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

611: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
612: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
613: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
614: ,x_return_status OUT NOCOPY VARCHAR2
615: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
616: )
617: IS
618: BEGIN
619: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 639: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

635: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
636: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
637: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
638: ,x_return_status OUT NOCOPY VARCHAR2
639: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
640: )
641: IS
642: BEGIN
643: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 663: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

659: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
660: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
661: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
662: ,x_return_status OUT NOCOPY VARCHAR2
663: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
664: )
665: IS
666: BEGIN
667: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 681: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

677: ( p_api_version IN NUMBER
678: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
679: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
680: , x_return_status OUT NOCOPY VARCHAR2
681: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
682: )
683: IS
684: --
685: l_return_status VARCHAR2(10);

Line 686: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

682: )
683: IS
684: --
685: l_return_status VARCHAR2(10);
686: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
687: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
688: l_error VARCHAR2(10) := FND_API.G_FALSE;
689: --
690: BEGIN

Line 687: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

683: IS
684: --
685: l_return_status VARCHAR2(10);
686: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
687: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
688: l_error VARCHAR2(10) := FND_API.G_FALSE;
689: --
690: BEGIN
691:

Line 1096: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1092: ( p_api_version IN NUMBER
1093: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1094: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
1095: , x_return_status OUT NOCOPY VARCHAR2
1096: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1097: )
1098: IS
1099: BEGIN
1100: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1115: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1111: ( p_api_version IN NUMBER
1112: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1113: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
1114: , x_return_status OUT NOCOPY VARCHAR2
1115: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1116: )
1117: IS
1118: BEGIN
1119: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1133: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1129: ( p_api_version IN NUMBER
1130: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
1131: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
1132: , x_return_status OUT NOCOPY VARCHAR2
1133: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1134: )
1135: IS
1136: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1137: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

Line 1149: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Target_Level_ID)

1145: l_Actual_Rec := p_Actual_Rec;
1146:
1147: -- convert Target Level
1148: --
1149: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Target_Level_ID)
1150: = FND_API.G_TRUE
1151: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Target_Level_ID)
1152: = FND_API.G_TRUE
1153: THEN

Line 1151: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Target_Level_ID)

1147: -- convert Target Level
1148: --
1149: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Target_Level_ID)
1150: = FND_API.G_TRUE
1151: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Target_Level_ID)
1152: = FND_API.G_TRUE
1153: THEN
1154: BEGIN
1155: