1 PACKAGE BIS_FUNCTIONAL_AREA_PVT AS
2 /* $Header: BISVFASS.pls 120.0 2005/06/01 14:43:48 appldev noship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BISVFASS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Module: Private for populating the table BIS_FUNCTIONAL_AREAS_TL |
13 REM | and relationship with FND_APPLICATIONS table |
14 REM | NOTES |
15 REM | 24-NOV-2004 Aditya Rao Created. |
16 REM +=======================================================================+
17 */
18
19 G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_FUNCTIONAL_AREA_PVT';
20
21
22 PROCEDURE Create_Functional_Area(
23 p_Api_Version IN NUMBER
24 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
25 ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
26 ,x_Return_Status OUT NOCOPY VARCHAR2
27 ,x_Msg_Count OUT NOCOPY NUMBER
28 ,x_Msg_Data OUT NOCOPY VARCHAR2
29 );
30
31
32 PROCEDURE Update_Functional_Area(
33 p_Api_Version IN NUMBER
34 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
35 ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
36 ,x_Return_Status OUT NOCOPY VARCHAR2
37 ,x_Msg_Count OUT NOCOPY NUMBER
38 ,x_Msg_Data OUT NOCOPY VARCHAR2
39 );
40
41
42 PROCEDURE Translate_Functional_Area(
43 p_Api_Version IN NUMBER
44 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
45 ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
46 ,x_Return_Status OUT NOCOPY VARCHAR2
47 ,x_Msg_Count OUT NOCOPY NUMBER
48 ,x_Msg_Data OUT NOCOPY VARCHAR2
49 );
50
51 PROCEDURE Delete_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 );
59
60 PROCEDURE Create_Func_Area_Apps_Dep (
61 p_Api_Version IN NUMBER
62 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
63 ,p_Functional_Area_Id IN NUMBER
64 ,p_Application_Id IN NUMBER
65 ,x_Return_Status OUT NOCOPY VARCHAR2
66 ,x_Msg_Count OUT NOCOPY NUMBER
67 ,x_Msg_Data OUT NOCOPY VARCHAR2
68 );
69
70
71 PROCEDURE Update_Func_Area_Apps_Dep (
72 p_Api_Version IN NUMBER
73 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
74 ,p_Functional_Area_Id IN NUMBER
75 ,p_Application_Id IN NUMBER
76 ,x_Return_Status OUT NOCOPY VARCHAR2
77 ,x_Msg_Count OUT NOCOPY NUMBER
78 ,x_Msg_Data OUT NOCOPY VARCHAR2
79 );
80
81
82 PROCEDURE Remove_Func_Area_Apps_Dep (
83 p_Api_Version IN NUMBER
84 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
85 ,p_Functional_Area_Id IN NUMBER
86 ,p_Application_Id IN NUMBER
87 ,x_Return_Status OUT NOCOPY VARCHAR2
88 ,x_Msg_Count OUT NOCOPY NUMBER
89 ,x_Msg_Data OUT NOCOPY VARCHAR2
90 );
91
92 PROCEDURE Retrieve_Functional_Area(
93 p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
94 ,x_Func_Area_Rec OUT NOCOPY BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
95 ,x_Return_Status OUT NOCOPY VARCHAR2
96 ,x_Msg_Count OUT NOCOPY NUMBER
97 ,x_Msg_Data OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE Add_Language;
101
102 END BIS_FUNCTIONAL_AREA_PVT;