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

Line 9: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

5: p_api_version IN NUMBER,
6: p_Indicator_Region_Rec
7: IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
10: )
11: IS
12: l_user_id NUMBER;
13: l_user_name VARCHAR2(100);

Line 15: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

11: IS
12: l_user_id NUMBER;
13: l_user_name VARCHAR2(100);
14: l_user_ind_id NUMBER;
15: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
16: l_rowid VARCHAR2(18);
17: e_CreateException EXCEPTION;
18: cursor c is
19: select rowid from BIS_USER_IND_SELECTIONS

Line 25: BIS_UTILITIES_PUB.Retrieve_User(

21:
22: BEGIN
23: x_return_status := FND_API.G_RET_STS_SUCCESS;
24:
25: BIS_UTILITIES_PUB.Retrieve_User(
26: p_user_id => p_Indicator_Region_Rec.user_id
27: ,p_user_name => p_Indicator_Region_Rec.user_name
28: ,x_user_id => l_user_id
29: ,x_user_name => l_user_name

Line 73: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,

69: END Create_User_Ind_Selection;
70:
71: Procedure Retrieve_User_Ind_Selections(
72: p_api_version IN NUMBER,
73: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
74: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
75: p_plug_id IN NUMBER ,
76: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,
77: x_Indicator_Region_Tbl

Line 74: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,

70:
71: Procedure Retrieve_User_Ind_Selections(
72: p_api_version IN NUMBER,
73: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
74: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
75: p_plug_id IN NUMBER ,
76: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,
77: x_Indicator_Region_Tbl
78: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,

Line 80: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

76: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,
77: x_Indicator_Region_Tbl
78: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
81: )
82: IS
83: l_Indicator_Region_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
84: e_RetrieveException EXCEPTION;

Line 85: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

81: )
82: IS
83: l_Indicator_Region_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
84: e_RetrieveException EXCEPTION;
85: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
86: l_Indicator_Region_Tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
87: BEGIN
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:

Line 90: BIS_UTILITIES_PUB.Retrieve_User(

86: l_Indicator_Region_Tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
87: BEGIN
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90: BIS_UTILITIES_PUB.Retrieve_User(
91: p_user_id => p_user_id
92: ,p_user_name => p_user_name
93: ,x_user_id => l_indicator_region_rec.user_id
94: ,x_user_name => l_indicator_region_rec.user_name

Line 161: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

157: p_Target_level_rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type,
158: x_Indicator_Region_Tbl
159: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
162: )
163: IS
164:
165: l_Indicator_Region_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;

Line 168: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

164:
165: l_Indicator_Region_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
166: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
167: e_RetrieveException EXCEPTION;
168: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
169: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
170: l_Indicator_Region_Tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
171: BEGIN
172:

Line 176: IF BIS_UTILITIES_PUB.VALUE_MISSING(p_Target_level_rec.Target_Level_ID)

172:
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174: l_Target_level_rec := p_Target_level_rec;
175:
176: IF BIS_UTILITIES_PUB.VALUE_MISSING(p_Target_level_rec.Target_Level_ID)
177: = FND_API.G_TRUE THEN
178:
179: -- mdamle 01/15/2001 - Resequence Dimensions
180: IF (l_target_level_rec.org_level_id IS NOT NULL) AND

Line 253: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,

249:
250:
251: Procedure Update_User_Ind_Selection(
252: p_api_version IN NUMBER,
253: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
254: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
255: p_plug_id IN NUMBER ,
256: p_Indicator_Region_Tbl
257: IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,

Line 254: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,

250:
251: Procedure Update_User_Ind_Selection(
252: p_api_version IN NUMBER,
253: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
254: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
255: p_plug_id IN NUMBER ,
256: p_Indicator_Region_Tbl
257: IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
258: x_return_status OUT NOCOPY VARCHAR2,

Line 259: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

255: p_plug_id IN NUMBER ,
256: p_Indicator_Region_Tbl
257: IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
260: )
261: IS
262: l_user_id NUMBER;
263: l_user_name VARCHAR2(100);

Line 264: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

260: )
261: IS
262: l_user_id NUMBER;
263: l_user_name VARCHAR2(100);
264: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
265:
266: e_UpdateException EXCEPTION;
267: BEGIN
268: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 270: BIS_UTILITIES_PUB.Retrieve_User(

266: e_UpdateException EXCEPTION;
267: BEGIN
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270: BIS_UTILITIES_PUB.Retrieve_User(
271: p_user_id => p_user_id
272: ,p_user_name => p_user_name
273: ,x_user_id => l_user_id
274: ,x_user_name => l_user_name

Line 326: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,

322:
323:
324: Procedure Delete_User_Ind_Selections(
325: p_api_version IN NUMBER,
326: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
327: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
328: p_plug_id IN NUMBER,
329: x_return_status OUT NOCOPY VARCHAR2,
330: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 327: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,

323:
324: Procedure Delete_User_Ind_Selections(
325: p_api_version IN NUMBER,
326: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
327: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
328: p_plug_id IN NUMBER,
329: x_return_status OUT NOCOPY VARCHAR2,
330: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
331: )

Line 330: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

326: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
327: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
328: p_plug_id IN NUMBER,
329: x_return_status OUT NOCOPY VARCHAR2,
330: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
331: )
332: IS
333: l_Indicator_Region_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
334: l_user_id NUMBER;

Line 336: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

332: IS
333: l_Indicator_Region_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
334: l_user_id NUMBER;
335: l_user_name VARCHAR2(100);
336: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
337: e_DeleteException EXCEPTION;
338: BEGIN
339: x_return_status := FND_API.G_RET_STS_SUCCESS;
340:

Line 341: BIS_UTILITIES_PUB.Retrieve_User(

337: e_DeleteException EXCEPTION;
338: BEGIN
339: x_return_status := FND_API.G_RET_STS_SUCCESS;
340:
341: BIS_UTILITIES_PUB.Retrieve_User(
342: p_user_id => p_user_id
343: ,p_user_name => p_user_name
344: ,x_user_id => l_user_id
345: ,x_user_name => l_user_name