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

Line 8: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

4: p_api_version IN NUMBER,
5: p_Indicator_Region_Rec
6: IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type,
7: x_return_status OUT NOCOPY VARCHAR2,
8: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
9: )
10: IS
11: l_user_ind_id NUMBER;
12: l_rowid VARCHAR2(18);

Line 13: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

9: )
10: IS
11: l_user_ind_id NUMBER;
12: l_rowid VARCHAR2(18);
13: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
14:
15: cursor c is
16: select rowid from BIS_USER_IND_SELECTIONS
17: where IND_SELECTION_ID = l_user_ind_id;

Line 118: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

114: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,
115: x_Indicator_Region_Tbl
116: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
119: )
120: IS
121: cursor c_user_ind_selection is
122: SELECT distinct a.ind_selection_id

Line 162: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

158: -- mdamle 01/15/2001 - Add Dim6 and Dim7
159: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
160: l_dim7_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
161:
162: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
163: l_sob_level_id NUMBER;
164: l_time_level_id NUMBER;
165: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
166:

Line 448: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

444: , p_Target_level_id IN NUMBER
445: , x_Indicator_Region_Tbl
446: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type
447: , x_return_status OUT NOCOPY VARCHAR2
448: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
449: )
450: IS
451:
452: l_Indicator_Region_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;

Line 465: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

461: -- mdamle 01/15/2001 - Add Dim6 and Dim7
462: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
463: l_dim7_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
464:
465: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
466: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
467: l_Org_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
468:
469: CURSOR c_user_ind_selection IS

Line 730: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,

726:
727:
728: Procedure Update_User_Ind_Selection(
729: p_api_version IN NUMBER,
730: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
731: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
732: p_plug_id IN NUMBER ,
733: p_Indicator_Region_Rec
734: IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type,

Line 731: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,

727:
728: Procedure Update_User_Ind_Selection(
729: p_api_version IN NUMBER,
730: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
731: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
732: p_plug_id IN NUMBER ,
733: p_Indicator_Region_Rec
734: IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type,
735: x_return_status OUT NOCOPY VARCHAR2,

Line 736: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

732: p_plug_id IN NUMBER ,
733: p_Indicator_Region_Rec
734: IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type,
735: x_return_status OUT NOCOPY VARCHAR2,
736: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
737: )
738: IS
739: BEGIN
740: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 752: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,

748:
749:
750: Procedure Delete_User_Ind_Selections(
751: p_api_version IN NUMBER,
752: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
753: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
754: p_plug_id IN NUMBER,
755: x_return_status OUT NOCOPY VARCHAR2,
756: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 753: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,

749:
750: Procedure Delete_User_Ind_Selections(
751: p_api_version IN NUMBER,
752: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
753: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
754: p_plug_id IN NUMBER,
755: x_return_status OUT NOCOPY VARCHAR2,
756: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
757: )

Line 756: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

752: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
753: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
754: p_plug_id IN NUMBER,
755: x_return_status OUT NOCOPY VARCHAR2,
756: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
757: )
758: IS
759:
760: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 760: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

756: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
757: )
758: IS
759:
760: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
761:
762: BEGIN
763:
764: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 797: p_user_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,

793:
794: END Delete_User_Ind_Selections;
795:
796: Procedure Retrieve_User_Labels(
797: p_user_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,
798: p_user_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR,
799: p_plug_id IN NUMBER,
800: x_label_tbl OUT NOCOPY BIS_INDICATOR_REGION_PVT.User_Label_Tbl_Type,
801: x_return_status OUT NOCOPY VARCHAR2

Line 798: p_user_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR,

794: END Delete_User_Ind_Selections;
795:
796: Procedure Retrieve_User_Labels(
797: p_user_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,
798: p_user_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR,
799: p_plug_id IN NUMBER,
800: x_label_tbl OUT NOCOPY BIS_INDICATOR_REGION_PVT.User_Label_Tbl_Type,
801: x_return_status OUT NOCOPY VARCHAR2
802: )

Line 816: -- IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_ID) THEN

812:
813: BEGIN
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816: -- IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_ID) THEN
817: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_ID) = FND_API.G_TRUE THEN
818: l_User_ID := p_User_ID;
819: ELSE
820: SELECT user_id

Line 817: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_ID) = FND_API.G_TRUE THEN

813: BEGIN
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816: -- IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_ID) THEN
817: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_ID) = FND_API.G_TRUE THEN
818: l_User_ID := p_User_ID;
819: ELSE
820: SELECT user_id
821: INTO l_user_id

Line 909: IF (NOT BIS_UTILITIES_PUB.Value_Not_Missing(

905: RAISE e_InvalidEventException;
906: END IF;
907:
908: /*
909: IF (NOT BIS_UTILITIES_PUB.Value_Not_Missing(
910: p_Indicator_Region_Rec.USER_ID)) OR
911: (NOT BIS_UTILITIES_PUB.Value_Not_Missing(
912: p_Indicator_Region_Rec.PLUG_ID)) THEN
913: */

Line 911: (NOT BIS_UTILITIES_PUB.Value_Not_Missing(

907:
908: /*
909: IF (NOT BIS_UTILITIES_PUB.Value_Not_Missing(
910: p_Indicator_Region_Rec.USER_ID)) OR
911: (NOT BIS_UTILITIES_PUB.Value_Not_Missing(
912: p_Indicator_Region_Rec.PLUG_ID)) THEN
913: */
914: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_Indicator_Region_Rec.USER_ID)
915: = FND_API.G_FALSE

Line 914: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_Indicator_Region_Rec.USER_ID)

910: p_Indicator_Region_Rec.USER_ID)) OR
911: (NOT BIS_UTILITIES_PUB.Value_Not_Missing(
912: p_Indicator_Region_Rec.PLUG_ID)) THEN
913: */
914: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_Indicator_Region_Rec.USER_ID)
915: = FND_API.G_FALSE
916: OR BIS_UTILITIES_PUB.Value_Not_Missing(p_Indicator_Region_Rec.PLUG_ID)
917: = FND_API.G_FALSE
918: THEN

Line 916: OR BIS_UTILITIES_PUB.Value_Not_Missing(p_Indicator_Region_Rec.PLUG_ID)

912: p_Indicator_Region_Rec.PLUG_ID)) THEN
913: */
914: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_Indicator_Region_Rec.USER_ID)
915: = FND_API.G_FALSE
916: OR BIS_UTILITIES_PUB.Value_Not_Missing(p_Indicator_Region_Rec.PLUG_ID)
917: = FND_API.G_FALSE
918: THEN
919:
920: RAISE e_MissingValuesException;

Line 925: IF (NOT BIS_UTILITIES_PUB.Value_Not_Missing(

921:
922: -- Don't need to validate rest if retrieving or deleting
923: IF p_event IN ('CREATE','UPDATE') THEN
924: /*
925: IF (NOT BIS_UTILITIES_PUB.Value_Not_Missing(
926: p_Indicator_Region_Rec.Target_Level_ID)) OR
927: (NOT BIS_UTILITIES_PUB.Value_Not_Missing(
928: p_Indicator_Region_Rec.org_level_value_id)) THEN
929: */

Line 927: (NOT BIS_UTILITIES_PUB.Value_Not_Missing(

923: IF p_event IN ('CREATE','UPDATE') THEN
924: /*
925: IF (NOT BIS_UTILITIES_PUB.Value_Not_Missing(
926: p_Indicator_Region_Rec.Target_Level_ID)) OR
927: (NOT BIS_UTILITIES_PUB.Value_Not_Missing(
928: p_Indicator_Region_Rec.org_level_value_id)) THEN
929: */
930: IF BIS_UTILITIES_PUB.Value_Not_Missing(
931: p_Indicator_Region_Rec.Target_Level_ID) = FND_API.G_FALSE

Line 930: IF BIS_UTILITIES_PUB.Value_Not_Missing(

926: p_Indicator_Region_Rec.Target_Level_ID)) OR
927: (NOT BIS_UTILITIES_PUB.Value_Not_Missing(
928: p_Indicator_Region_Rec.org_level_value_id)) THEN
929: */
930: IF BIS_UTILITIES_PUB.Value_Not_Missing(
931: p_Indicator_Region_Rec.Target_Level_ID) = FND_API.G_FALSE
932: -- mdamle 01/15/2001 - Use Dim6 and Dim7
933: -- OR BIS_UTILITIES_PUB.Value_Not_Missing(
934: -- p_Indicator_Region_Rec.Org_Level_Value_ID) = FND_API.G_FALSE

Line 933: -- OR BIS_UTILITIES_PUB.Value_Not_Missing(

929: */
930: IF BIS_UTILITIES_PUB.Value_Not_Missing(
931: p_Indicator_Region_Rec.Target_Level_ID) = FND_API.G_FALSE
932: -- mdamle 01/15/2001 - Use Dim6 and Dim7
933: -- OR BIS_UTILITIES_PUB.Value_Not_Missing(
934: -- p_Indicator_Region_Rec.Org_Level_Value_ID) = FND_API.G_FALSE
935: THEN
936: RAISE e_MissingValuesException;
937: END IF;