APPS.BIS_FUNCTIONAL_AREA_PUB dependencies on BIS_FUNCTIONAL_AREA_PUB

Line 1: PACKAGE BODY BIS_FUNCTIONAL_AREA_PUB AS

1: PACKAGE BODY BIS_FUNCTIONAL_AREA_PUB AS
2: /* $Header: BISPFASB.pls 120.0 2005/06/01 16:38:23 appldev noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |

Line 19: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_FUNCTIONAL_AREA_PUB';

15: REM | 24-NOV-2004 Aditya Rao Created. |
16: REM +=======================================================================+
17: */
18:
19: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_FUNCTIONAL_AREA_PUB';
20:
21: /*
22: PRIVATE Validation APIs
23: */

Line 26: p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

22: PRIVATE Validation APIs
23: */
24:
25: PROCEDURE Validate_Functional_Area(
26: p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
27: ,p_Action_Type IN VARCHAR2
28: ,x_Return_Status OUT NOCOPY VARCHAR2
29: ,x_Msg_Count OUT NOCOPY NUMBER
30: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 54: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

50:
51: PROCEDURE Create_Functional_Area(
52: p_Api_Version IN NUMBER
53: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
54: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
55: ,x_Return_Status OUT NOCOPY VARCHAR2
56: ,x_Msg_Count OUT NOCOPY NUMBER
57: ,x_Msg_Data OUT NOCOPY VARCHAR2
58: ) IS

Line 60: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;

56: ,x_Msg_Count OUT NOCOPY NUMBER
57: ,x_Msg_Data OUT NOCOPY VARCHAR2
58: ) IS
59:
60: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
61: l_Count NUMBER;
62:
63: BEGIN
64: SAVEPOINT CreateFuncAreaSP;

Line 127: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area ';

123: WHEN NO_DATA_FOUND THEN
124: ROLLBACK TO CreateFuncAreaSP;
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: IF (x_msg_data IS NOT NULL) THEN
127: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area ';
128: ELSE
129: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area ';
130: END IF;
131: WHEN OTHERS THEN

Line 129: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area ';

125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: IF (x_msg_data IS NOT NULL) THEN
127: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area ';
128: ELSE
129: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area ';
130: END IF;
131: WHEN OTHERS THEN
132: ROLLBACK TO CreateFuncAreaSP;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 135: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area ';

131: WHEN OTHERS THEN
132: ROLLBACK TO CreateFuncAreaSP;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: IF (x_msg_data IS NOT NULL) THEN
135: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area ';
136: ELSE
137: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area ';
138: END IF;
139: END Create_Functional_Area;

Line 137: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area ';

133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: IF (x_msg_data IS NOT NULL) THEN
135: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area ';
136: ELSE
137: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area ';
138: END IF;
139: END Create_Functional_Area;
140:
141:

Line 147: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

143: -- Update Functional Area API
144: PROCEDURE Update_Functional_Area(
145: p_Api_Version IN NUMBER
146: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
147: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
148: ,x_Return_Status OUT NOCOPY VARCHAR2
149: ,x_Msg_Count OUT NOCOPY NUMBER
150: ,x_Msg_Data OUT NOCOPY VARCHAR2
151: ) IS

Line 153: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;

149: ,x_Msg_Count OUT NOCOPY NUMBER
150: ,x_Msg_Data OUT NOCOPY VARCHAR2
151: ) IS
152: l_Count NUMBER;
153: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
154: BEGIN
155: SAVEPOINT UpdateFuncAreaSP;
156: FND_MSG_PUB.Initialize;
157: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 214: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';

210: WHEN NO_DATA_FOUND THEN
211: ROLLBACK TO UpdateFuncAreaSP;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF (x_msg_data IS NOT NULL) THEN
214: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';
215: ELSE
216: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';
217: END IF;
218: WHEN OTHERS THEN

Line 216: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';

212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF (x_msg_data IS NOT NULL) THEN
214: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';
215: ELSE
216: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';
217: END IF;
218: WHEN OTHERS THEN
219: ROLLBACK TO UpdateFuncAreaSP;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 222: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';

218: WHEN OTHERS THEN
219: ROLLBACK TO UpdateFuncAreaSP;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: IF (x_msg_data IS NOT NULL) THEN
222: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';
223: ELSE
224: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';
225: END IF;
226:

Line 224: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';

220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: IF (x_msg_data IS NOT NULL) THEN
222: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';
223: ELSE
224: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';
225: END IF;
226:
227: END Update_Functional_Area;
228:

Line 232: p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

228:
229: -- Retrieve Functional Area API
230:
231: PROCEDURE Retrieve_Functional_Area(
232: p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
233: ,x_Func_Area_Rec OUT NOCOPY BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
234: ,x_Return_Status OUT NOCOPY VARCHAR2
235: ,x_Msg_Count OUT NOCOPY NUMBER
236: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 233: ,x_Func_Area_Rec OUT NOCOPY BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

229: -- Retrieve Functional Area API
230:
231: PROCEDURE Retrieve_Functional_Area(
232: p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
233: ,x_Func_Area_Rec OUT NOCOPY BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
234: ,x_Return_Status OUT NOCOPY VARCHAR2
235: ,x_Msg_Count OUT NOCOPY NUMBER
236: ,x_Msg_Data OUT NOCOPY VARCHAR2
237: ) IS

Line 278: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area ';

274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: WHEN NO_DATA_FOUND THEN
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: IF (x_msg_data IS NOT NULL) THEN
278: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area ';
279: ELSE
280: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area ';
281: END IF;
282: WHEN OTHERS THEN

Line 280: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area ';

276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: IF (x_msg_data IS NOT NULL) THEN
278: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area ';
279: ELSE
280: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area ';
281: END IF;
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: IF (x_msg_data IS NOT NULL) THEN

Line 285: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area ';

281: END IF;
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: IF (x_msg_data IS NOT NULL) THEN
285: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area ';
286: ELSE
287: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area ';
288: END IF;
289: END Retrieve_Functional_Area;

Line 287: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area ';

283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: IF (x_msg_data IS NOT NULL) THEN
285: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area ';
286: ELSE
287: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area ';
288: END IF;
289: END Retrieve_Functional_Area;
290:
291:

Line 296: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

292: -- Translate the Functional Area Name/Description
293: PROCEDURE Translate_Functional_Area(
294: p_Api_Version IN NUMBER
295: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
296: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
297: ,x_Return_Status OUT NOCOPY VARCHAR2
298: ,x_Msg_Count OUT NOCOPY NUMBER
299: ,x_Msg_Data OUT NOCOPY VARCHAR2
300: ) IS

Line 302: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;

298: ,x_Msg_Count OUT NOCOPY NUMBER
299: ,x_Msg_Data OUT NOCOPY VARCHAR2
300: ) IS
301: l_Count NUMBER;
302: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
303:
304: BEGIN
305: SAVEPOINT TransFuncAreaSP;
306: FND_MSG_PUB.Initialize;

Line 364: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Translate_Functional_Area ';

360: WHEN NO_DATA_FOUND THEN
361: ROLLBACK TO TransFuncAreaSP;
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
363: IF (x_msg_data IS NOT NULL) THEN
364: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Translate_Functional_Area ';
365: ELSE
366: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Translate_Functional_Area ';
367: END IF;
368: WHEN OTHERS THEN

Line 366: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Translate_Functional_Area ';

362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
363: IF (x_msg_data IS NOT NULL) THEN
364: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Translate_Functional_Area ';
365: ELSE
366: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Translate_Functional_Area ';
367: END IF;
368: WHEN OTHERS THEN
369: ROLLBACK TO TransFuncAreaSP;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 372: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Translate_Functional_Area ';

368: WHEN OTHERS THEN
369: ROLLBACK TO TransFuncAreaSP;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: IF (x_msg_data IS NOT NULL) THEN
372: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Translate_Functional_Area ';
373: ELSE
374: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Translate_Functional_Area ';
375: END IF;
376: END Translate_Functional_Area;

Line 374: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Translate_Functional_Area ';

370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: IF (x_msg_data IS NOT NULL) THEN
372: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Translate_Functional_Area ';
373: ELSE
374: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Translate_Functional_Area ';
375: END IF;
376: END Translate_Functional_Area;
377:
378:

Line 383: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

379: -- Load Functional Areas for LCT
380:
381: PROCEDURE Load_Functional_Area(
382: p_Commit IN VARCHAR2 := FND_API.G_FALSE
383: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
384: ,x_Return_Status OUT NOCOPY VARCHAR2
385: ,x_Msg_Count OUT NOCOPY NUMBER
386: ,x_Msg_Data OUT NOCOPY VARCHAR2
387: ) IS

Line 389: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;

385: ,x_Msg_Count OUT NOCOPY NUMBER
386: ,x_Msg_Data OUT NOCOPY VARCHAR2
387: ) IS
388:
389: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
390:
391: BEGIN
392: SAVEPOINT LoadFuncAreaSP;
393: FND_MSG_PUB.Initialize;

Line 396: BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area

392: SAVEPOINT LoadFuncAreaSP;
393: FND_MSG_PUB.Initialize;
394: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
395:
396: BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area
397: (
398: p_Func_Area_Rec => p_Func_Area_Rec
399: ,x_Func_Area_Rec => l_Func_Area_Rec
400: ,x_Return_Status => x_Return_Status

Line 405: BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area(

401: ,x_Msg_Count => x_Msg_Count
402: ,x_Msg_Data => x_Msg_Data
403: );
404: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
405: BIS_FUNCTIONAL_AREA_PUB.Create_Functional_Area(
406: p_Api_Version => 1.0
407: ,p_Commit => p_Commit
408: ,p_Func_Area_Rec => p_Func_Area_Rec
409: ,x_Return_Status => x_Return_Status

Line 423: BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area(

419: , l_Func_Area_Rec.Last_Updated_By
420: , l_Func_Area_Rec.Last_Update_Date
421: , NULL)) THEN
422:
423: BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area(
424: p_Api_Version => 1.0
425: ,p_Commit => p_Commit
426: ,p_Func_Area_Rec => p_Func_Area_Rec
427: ,x_Return_Status => x_Return_Status

Line 464: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Load_Functional_Area ';

460: WHEN NO_DATA_FOUND THEN
461: ROLLBACK TO LoadFuncAreaSP;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: IF (x_msg_data IS NOT NULL) THEN
464: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Load_Functional_Area ';
465: ELSE
466: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Load_Functional_Area ';
467: END IF;
468: RAISE;

Line 466: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Load_Functional_Area ';

462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: IF (x_msg_data IS NOT NULL) THEN
464: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Load_Functional_Area ';
465: ELSE
466: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Load_Functional_Area ';
467: END IF;
468: RAISE;
469: WHEN OTHERS THEN
470: ROLLBACK TO LoadFuncAreaSP;

Line 473: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Load_Functional_Area ';

469: WHEN OTHERS THEN
470: ROLLBACK TO LoadFuncAreaSP;
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: IF (x_msg_data IS NOT NULL) THEN
473: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Load_Functional_Area ';
474: ELSE
475: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Load_Functional_Area ';
476: END IF;
477: RAISE;

Line 475: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Load_Functional_Area ';

471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: IF (x_msg_data IS NOT NULL) THEN
473: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Load_Functional_Area ';
474: ELSE
475: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Load_Functional_Area ';
476: END IF;
477: RAISE;
478:
479: END Load_Functional_Area;

Line 556: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep ';

552: WHEN NO_DATA_FOUND THEN
553: ROLLBACK TO CreateFuncAreaAppDepSP;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: IF (x_msg_data IS NOT NULL) THEN
556: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep ';
557: ELSE
558: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep ';
559: END IF;
560: WHEN OTHERS THEN

Line 558: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep ';

554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: IF (x_msg_data IS NOT NULL) THEN
556: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep ';
557: ELSE
558: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep ';
559: END IF;
560: WHEN OTHERS THEN
561: ROLLBACK TO CreateFuncAreaAppDepSP;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 564: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep ';

560: WHEN OTHERS THEN
561: ROLLBACK TO CreateFuncAreaAppDepSP;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: IF (x_msg_data IS NOT NULL) THEN
564: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep ';
565: ELSE
566: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep ';
567: END IF;
568: END Create_Func_Area_Apps_Dep;

Line 566: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep ';

562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: IF (x_msg_data IS NOT NULL) THEN
564: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep ';
565: ELSE
566: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep ';
567: END IF;
568: END Create_Func_Area_Apps_Dep;
569:
570: -- Update Functional Area dependency with Application ID

Line 645: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';

641: WHEN NO_DATA_FOUND THEN
642: ROLLBACK TO UpdateFuncAreaAppDepSP;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: IF (x_msg_data IS NOT NULL) THEN
645: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';
646: ELSE
647: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';
648: END IF;
649: WHEN OTHERS THEN

Line 647: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';

643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: IF (x_msg_data IS NOT NULL) THEN
645: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';
646: ELSE
647: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';
648: END IF;
649: WHEN OTHERS THEN
650: ROLLBACK TO UpdateFuncAreaAppDepSP;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 653: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';

649: WHEN OTHERS THEN
650: ROLLBACK TO UpdateFuncAreaAppDepSP;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: IF (x_msg_data IS NOT NULL) THEN
653: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';
654: ELSE
655: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';
656: END IF;
657:

Line 655: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';

651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: IF (x_msg_data IS NOT NULL) THEN
653: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';
654: ELSE
655: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';
656: END IF;
657:
658: END Update_Func_Area_Apps_Dep;
659:

Line 663: ,p_Func_Area_App_Dep_Rec IN BIS_FUNCTIONAL_AREA_PUB.Func_Area_Apps_Depend_Rec_Type

659:
660: -- Load API for loading Functional Area/Application ID dependnecy
661: PROCEDURE Load_Func_Area_Apps_Dep (
662: p_Commit IN VARCHAR2 := FND_API.G_FALSE
663: ,p_Func_Area_App_Dep_Rec IN BIS_FUNCTIONAL_AREA_PUB.Func_Area_Apps_Depend_Rec_Type
664: ,x_Return_Status OUT NOCOPY VARCHAR2
665: ,x_Msg_Count OUT NOCOPY NUMBER
666: ,x_Msg_Data OUT NOCOPY VARCHAR2
667: ) IS

Line 669: l_Func_Area_App_Dep_Rec BIS_FUNCTIONAL_AREA_PUB.Func_Area_Apps_Depend_Rec_Type;

665: ,x_Msg_Count OUT NOCOPY NUMBER
666: ,x_Msg_Data OUT NOCOPY VARCHAR2
667: ) IS
668: l_Count NUMBER;
669: l_Func_Area_App_Dep_Rec BIS_FUNCTIONAL_AREA_PUB.Func_Area_Apps_Depend_Rec_Type;
670: BEGIN
671: SAVEPOINT LoadFuncAreaAppDepSP;
672: FND_MSG_PUB.Initialize;
673: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 691: BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep (

687: WHERE FUNCTIONAL_AREA_ID = l_Func_Area_App_Dep_Rec.Functional_Area_Id
688: AND APPLICATION_ID = l_Func_Area_App_Dep_Rec.Application_Id;
689:
690: IF (l_Count = 0) THEN
691: BIS_FUNCTIONAL_AREA_PUB.Create_Func_Area_Apps_Dep (
692: p_Api_Version => 1.0
693: ,p_Commit => p_Commit
694: ,p_Functional_Area_Id => l_Func_Area_App_Dep_Rec.Functional_Area_Id
695: ,p_Application_Id => l_Func_Area_App_Dep_Rec.Application_Id

Line 704: BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep (

700: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703: ELSE
704: BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep (
705: p_Api_Version => 1.0
706: ,p_Commit => p_Commit
707: ,p_Functional_Area_Id => l_Func_Area_App_Dep_Rec.Functional_Area_Id
708: ,p_Application_Id => l_Func_Area_App_Dep_Rec.Application_Id

Line 745: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Load_Func_Area_Apps_Dep ';

741: WHEN NO_DATA_FOUND THEN
742: ROLLBACK TO LoadFuncAreaAppDepSP;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: IF (x_msg_data IS NOT NULL) THEN
745: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Load_Func_Area_Apps_Dep ';
746: ELSE
747: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Load_Func_Area_Apps_Dep ';
748: END IF;
749: RAISE;

Line 747: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Load_Func_Area_Apps_Dep ';

743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: IF (x_msg_data IS NOT NULL) THEN
745: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Load_Func_Area_Apps_Dep ';
746: ELSE
747: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Load_Func_Area_Apps_Dep ';
748: END IF;
749: RAISE;
750: WHEN OTHERS THEN
751: ROLLBACK TO LoadFuncAreaAppDepSP;

Line 754: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Load_Func_Area_Apps_Dep ';

750: WHEN OTHERS THEN
751: ROLLBACK TO LoadFuncAreaAppDepSP;
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: IF (x_msg_data IS NOT NULL) THEN
754: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Load_Func_Area_Apps_Dep ';
755: ELSE
756: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Load_Func_Area_Apps_Dep ';
757: END IF;
758: RAISE;

Line 756: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Load_Func_Area_Apps_Dep ';

752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: IF (x_msg_data IS NOT NULL) THEN
754: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Load_Func_Area_Apps_Dep ';
755: ELSE
756: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Load_Func_Area_Apps_Dep ';
757: END IF;
758: RAISE;
759: END Load_Func_Area_Apps_Dep;
760:

Line 763: p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

759: END Load_Func_Area_Apps_Dep;
760:
761: -- Validation API for Functional Area
762: PROCEDURE Validate_Functional_Area(
763: p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
764: ,p_Action_Type IN VARCHAR2
765: ,x_Return_Status OUT NOCOPY VARCHAR2
766: ,x_Msg_Count OUT NOCOPY NUMBER
767: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 853: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Validate_Functional_Area ';

849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
850: WHEN NO_DATA_FOUND THEN
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: IF (x_msg_data IS NOT NULL) THEN
853: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Validate_Functional_Area ';
854: ELSE
855: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Validate_Functional_Area ';
856: END IF;
857: WHEN OTHERS THEN

Line 855: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Validate_Functional_Area ';

851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: IF (x_msg_data IS NOT NULL) THEN
853: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Validate_Functional_Area ';
854: ELSE
855: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Validate_Functional_Area ';
856: END IF;
857: WHEN OTHERS THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: IF (x_msg_data IS NOT NULL) THEN

Line 860: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Validate_Functional_Area ';

856: END IF;
857: WHEN OTHERS THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: IF (x_msg_data IS NOT NULL) THEN
860: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Validate_Functional_Area ';
861: ELSE
862: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Validate_Functional_Area ';
863: END IF;
864:

Line 862: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Validate_Functional_Area ';

858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: IF (x_msg_data IS NOT NULL) THEN
860: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Validate_Functional_Area ';
861: ELSE
862: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Validate_Functional_Area ';
863: END IF;
864:
865: END Validate_Functional_Area;
866:

Line 991: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Validate_Func_Area_Apps_Dep ';

987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: WHEN NO_DATA_FOUND THEN
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990: IF (x_msg_data IS NOT NULL) THEN
991: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Validate_Func_Area_Apps_Dep ';
992: ELSE
993: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Validate_Func_Area_Apps_Dep ';
994: END IF;
995: WHEN OTHERS THEN

Line 993: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Validate_Func_Area_Apps_Dep ';

989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990: IF (x_msg_data IS NOT NULL) THEN
991: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Validate_Func_Area_Apps_Dep ';
992: ELSE
993: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Validate_Func_Area_Apps_Dep ';
994: END IF;
995: WHEN OTHERS THEN
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: IF (x_msg_data IS NOT NULL) THEN

Line 998: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Validate_Func_Area_Apps_Dep ';

994: END IF;
995: WHEN OTHERS THEN
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: IF (x_msg_data IS NOT NULL) THEN
998: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Validate_Func_Area_Apps_Dep ';
999: ELSE
1000: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Validate_Func_Area_Apps_Dep ';
1001: END IF;
1002: END Validate_Func_Area_Apps_Dep;

Line 1000: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Validate_Func_Area_Apps_Dep ';

996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: IF (x_msg_data IS NOT NULL) THEN
998: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Validate_Func_Area_Apps_Dep ';
999: ELSE
1000: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Validate_Func_Area_Apps_Dep ';
1001: END IF;
1002: END Validate_Func_Area_Apps_Dep;
1003:
1004: -- Returns the next functional area id, this may not be multiuser friendly

Line 1053: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type

1049: -- Delete the Functional Area
1050: PROCEDURE Delete_Functional_Area(
1051: p_Api_Version IN NUMBER
1052: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
1053: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
1054: ,x_Return_Status OUT NOCOPY VARCHAR2
1055: ,x_Msg_Count OUT NOCOPY NUMBER
1056: ,x_Msg_Data OUT NOCOPY VARCHAR2
1057: ) IS

Line 1058: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;

1054: ,x_Return_Status OUT NOCOPY VARCHAR2
1055: ,x_Msg_Count OUT NOCOPY NUMBER
1056: ,x_Msg_Data OUT NOCOPY VARCHAR2
1057: ) IS
1058: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
1059: l_Count NUMBER;
1060:
1061: CURSOR c_FuncArea_Dep IS
1062: SELECT B.FUNCTIONAL_AREA_ID,

Line 1084: BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area

1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: END IF;
1082:
1083:
1084: BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area
1085: (
1086: p_Func_Area_Rec => p_Func_Area_Rec
1087: ,x_Func_Area_Rec => l_Func_Area_Rec
1088: ,x_Return_Status => x_Return_Status

Line 1138: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';

1134: WHEN NO_DATA_FOUND THEN
1135: ROLLBACK TO DeleteFuncAreaSP;
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137: IF (x_msg_data IS NOT NULL) THEN
1138: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';
1139: ELSE
1140: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';
1141: END IF;
1142: WHEN OTHERS THEN

Line 1140: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';

1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137: IF (x_msg_data IS NOT NULL) THEN
1138: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';
1139: ELSE
1140: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';
1141: END IF;
1142: WHEN OTHERS THEN
1143: ROLLBACK TO DeleteFuncAreaSP;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1146: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';

1142: WHEN OTHERS THEN
1143: ROLLBACK TO DeleteFuncAreaSP;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1145: IF (x_msg_data IS NOT NULL) THEN
1146: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';
1147: ELSE
1148: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';
1149: END IF;
1150: END Delete_Functional_Area;

Line 1148: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';

1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1145: IF (x_msg_data IS NOT NULL) THEN
1146: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';
1147: ELSE
1148: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';
1149: END IF;
1150: END Delete_Functional_Area;
1151:
1152: -- remove Functional Area/Application ID dependency

Line 1224: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Remove_Func_Area_Apps_Dep ';

1220: WHEN NO_DATA_FOUND THEN
1221: ROLLBACK TO RemoveFuncAreaDependencySP;
1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1223: IF (x_msg_data IS NOT NULL) THEN
1224: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Remove_Func_Area_Apps_Dep ';
1225: ELSE
1226: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Remove_Func_Area_Apps_Dep ';
1227: END IF;
1228: WHEN OTHERS THEN

Line 1226: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Remove_Func_Area_Apps_Dep ';

1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1223: IF (x_msg_data IS NOT NULL) THEN
1224: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Remove_Func_Area_Apps_Dep ';
1225: ELSE
1226: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Remove_Func_Area_Apps_Dep ';
1227: END IF;
1228: WHEN OTHERS THEN
1229: ROLLBACK TO RemoveFuncAreaDependencySP;
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1232: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Remove_Func_Area_Apps_Dep ';

1228: WHEN OTHERS THEN
1229: ROLLBACK TO RemoveFuncAreaDependencySP;
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231: IF (x_msg_data IS NOT NULL) THEN
1232: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Remove_Func_Area_Apps_Dep ';
1233: ELSE
1234: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Remove_Func_Area_Apps_Dep ';
1235: END IF;
1236: END Remove_Func_Area_Apps_Dep;

Line 1234: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Remove_Func_Area_Apps_Dep ';

1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231: IF (x_msg_data IS NOT NULL) THEN
1232: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Remove_Func_Area_Apps_Dep ';
1233: ELSE
1234: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Remove_Func_Area_Apps_Dep ';
1235: END IF;
1236: END Remove_Func_Area_Apps_Dep;
1237:
1238: -- Add language API

Line 1246: END BIS_FUNCTIONAL_AREA_PUB;

1242: BIS_FUNCTIONAL_AREA_PVT.ADD_LANGUAGE;
1243: END ADD_LANGUAGE;
1244:
1245:
1246: END BIS_FUNCTIONAL_AREA_PUB;