1 PACKAGE BIS_FUNCTIONAL_AREA_PUB AS
2 /* $Header: BISPFASS.pls 120.0 2005/06/01 15:25:50 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 | BISPFASS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Module: Wrapper 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_PUB';
20
21 C_CREATE CONSTANT VARCHAR2(30):='CREATE';
22 C_UPDATE CONSTANT VARCHAR2(30):='UPDATE';
23 C_RETRIEVE CONSTANT VARCHAR2(30):='RETRIEVE';
24 C_DELETE CONSTANT VARCHAR2(30):='DELETE';
25
26
27 TYPE Functional_Area_Rec_Type IS RECORD
28 (
29 Functional_Area_Id BIS_FUNCTIONAL_AREAS.FUNCTIONAL_AREA_ID%TYPE
30 , Short_Name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE -- requirement of this field is still under discussion
31 , Name BIS_FUNCTIONAL_AREAS_TL.NAME%TYPE
32 , Description BIS_FUNCTIONAL_AREAS_TL.DESCRIPTION%TYPE
33 , Created_By BIS_FUNCTIONAL_AREAS.CREATED_BY%TYPE
34 , Creation_Date BIS_FUNCTIONAL_AREAS.CREATION_DATE%TYPE
35 , Last_Updated_By BIS_FUNCTIONAL_AREAS.LAST_UPDATED_BY%TYPE
36 , Last_Update_Date BIS_FUNCTIONAL_AREAS.LAST_UPDATE_DATE%TYPE
37 , Last_Update_Login BIS_FUNCTIONAL_AREAS.LAST_UPDATE_LOGIN%TYPE
38 );
39
40 TYPE Func_Area_Apps_Depend_Rec_Type IS RECORD
41 (
42 Functional_Area_Id BIS_FUNC_AREA_APP_DEPENDENCY.FUNCTIONAL_AREA_ID%TYPE
43 , Func_Area_Short_Name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE
44 , Application_Id BIS_FUNC_AREA_APP_DEPENDENCY.APPLICATION_ID%TYPE
45 , Apps_Short_Name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
46 );
47
48
49 PROCEDURE Create_Functional_Area(
50 p_Api_Version IN NUMBER
51 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
52 ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
53 ,x_Return_Status OUT NOCOPY VARCHAR2
54 ,x_Msg_Count OUT NOCOPY NUMBER
55 ,x_Msg_Data OUT NOCOPY VARCHAR2
56 );
57
58
59 PROCEDURE Update_Functional_Area(
60 p_Api_Version IN NUMBER
61 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
62 ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
63 ,x_Return_Status OUT NOCOPY VARCHAR2
64 ,x_Msg_Count OUT NOCOPY NUMBER
65 ,x_Msg_Data OUT NOCOPY VARCHAR2
66 );
67
68
69 PROCEDURE Retrieve_Functional_Area(
70 p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
71 ,x_Func_Area_Rec OUT NOCOPY BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
72 ,x_Return_Status OUT NOCOPY VARCHAR2
73 ,x_Msg_Count OUT NOCOPY NUMBER
74 ,x_Msg_Data OUT NOCOPY VARCHAR2
75 );
76
77 PROCEDURE Translate_Functional_Area(
78 p_Api_Version IN NUMBER
79 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
80 ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
81 ,x_Return_Status OUT NOCOPY VARCHAR2
82 ,x_Msg_Count OUT NOCOPY NUMBER
83 ,x_Msg_Data OUT NOCOPY VARCHAR2
84 );
85
86 PROCEDURE Load_Functional_Area(
87 p_Commit IN VARCHAR2 := FND_API.G_FALSE
88 ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
89 ,x_Return_Status OUT NOCOPY VARCHAR2
90 ,x_Msg_Count OUT NOCOPY NUMBER
91 ,x_Msg_Data OUT NOCOPY VARCHAR2
92 );
93
94 PROCEDURE Delete_Functional_Area(
95 p_Api_Version IN NUMBER
96 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
97 ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
98 ,x_Return_Status OUT NOCOPY VARCHAR2
99 ,x_Msg_Count OUT NOCOPY NUMBER
100 ,x_Msg_Data OUT NOCOPY VARCHAR2
101 );
102
103 PROCEDURE Create_Func_Area_Apps_Dep (
104 p_Api_Version IN NUMBER
105 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
106 ,p_Functional_Area_Id IN NUMBER
107 ,p_Application_Id IN NUMBER
108 ,x_Return_Status OUT NOCOPY VARCHAR2
109 ,x_Msg_Count OUT NOCOPY NUMBER
110 ,x_Msg_Data OUT NOCOPY VARCHAR2
111 );
112
113
114 PROCEDURE Update_Func_Area_Apps_Dep (
115 p_Api_Version IN NUMBER
116 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
117 ,p_Functional_Area_Id IN NUMBER
118 ,p_Application_Id IN NUMBER
119 ,x_Return_Status OUT NOCOPY VARCHAR2
120 ,x_Msg_Count OUT NOCOPY NUMBER
121 ,x_Msg_Data OUT NOCOPY VARCHAR2
122 );
123
124
125 PROCEDURE Load_Func_Area_Apps_Dep (
126 p_Commit IN VARCHAR2 := FND_API.G_FALSE
127 ,p_Func_Area_App_Dep_Rec IN BIS_FUNCTIONAL_AREA_PUB.Func_Area_Apps_Depend_Rec_Type
128 ,x_Return_Status OUT NOCOPY VARCHAR2
129 ,x_Msg_Count OUT NOCOPY NUMBER
130 ,x_Msg_Data OUT NOCOPY VARCHAR2
131 );
132
133
134 PROCEDURE Remove_Func_Area_Apps_Dep (
135 p_Api_Version IN NUMBER
136 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
137 ,p_Functional_Area_Id IN NUMBER
138 ,p_Application_Id IN NUMBER
139 ,x_Return_Status OUT NOCOPY VARCHAR2
140 ,x_Msg_Count OUT NOCOPY NUMBER
141 ,x_Msg_Data OUT NOCOPY VARCHAR2
142 );
143
144
145 PROCEDURE ADD_LANGUAGE;
146
147 END BIS_FUNCTIONAL_AREA_PUB;