[Home] [Help]
PACKAGE: APPS.BIS_OBJECT_EXTENSIONS_PUB
Source
1 PACKAGE BIS_OBJECT_EXTENSIONS_PUB AS
2 /* $Header: BISPEXTS.pls 120.0 2005/06/01 15:13:00 appldev noship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BISPEXTS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Module: Public package for populating the extension tables |
13 REM | - BIS_MEASURES_EXTENSION_TL |
14 REM | - BIS_FORM_FUNCTION_EXTENSION_TL/B |
15 REM | NOTES |
16 REM | 08-DEC-2004 Krishna Created. |
17 REM | 27-DEC-2004 ashankar added the Procedure Object_Funct_Area_Map |
18 REM +=======================================================================+
19 */
20
21 G_PKG_NAME CONSTANT VARCHAR2(30):= 'BIS_OBJECT_EXTENSIONS_PUB';
22 C_CREATE CONSTANT VARCHAR2(6) := 'CREATE';
23 C_UPDATE CONSTANT VARCHAR2(6) := 'UPDATE';
24 C_DELETE CONSTANT VARCHAR2(6) := 'DELETE';
25 C_LOAD CONSTANT VARCHAR2(4) := 'LOAD';
26 C_RETRIEVE CONSTANT VARCHAR2(8) := 'RETRIEVE';
27 C_TRANS CONSTANT VARCHAR2(9) := 'TRANSLATE';
28 C_INVALID CONSTANT NUMBER := -999;
29 C_FORCE CONSTANT VARCHAR2(5) := 'FORCE';
30 C_MEASURE CONSTANT VARCHAR2(7) := 'MEASURE';
31
32
33
34 TYPE Measure_Extension_Type IS RECORD
35 (
36 Measure_Short_Name BIS_MEASURES_EXTENSION.MEASURE_SHORT_NAME%TYPE
37 , Name BIS_MEASURES_EXTENSION_TL.NAME%TYPE
38 , Description BIS_MEASURES_EXTENSION_TL.DESCRIPTION%TYPE
39 , Functional_Area_Id BIS_MEASURES_EXTENSION.FUNCTIONAL_AREA_ID%TYPE
40 , Func_Area_Short_Name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE
41 , Created_By BIS_MEASURES_EXTENSION_TL.CREATED_BY%TYPE
42 , Creation_Date BIS_MEASURES_EXTENSION_TL.CREATION_DATE%TYPE
43 , Last_Updated_By BIS_MEASURES_EXTENSION_TL.LAST_UPDATED_BY%TYPE
44 , Last_Update_Date BIS_MEASURES_EXTENSION_TL.LAST_UPDATE_DATE%TYPE
45 , Last_Update_Login BIS_MEASURES_EXTENSION_TL.LAST_UPDATE_LOGIN%TYPE
46 );
47
48
49
50 TYPE Form_Function_Extension_Type IS RECORD
51 (
52 Object_Type BIS_FORM_FUNCTION_EXTENSION.OBJECT_TYPE%TYPE
53 , Object_Name BIS_FORM_FUNCTION_EXTENSION.OBJECT_NAME%TYPE
54 , Name BIS_FORM_FUNCTION_EXTENSION_TL.NAME%TYPE
55 , Description BIS_FORM_FUNCTION_EXTENSION_TL.DESCRIPTION%TYPE
56 , Application_Id BIS_FORM_FUNCTION_EXTENSION.APPLICATION_ID%TYPE
57 , Func_Area_Id BIS_FORM_FUNCTION_EXTENSION.FUNCTIONAL_AREA_ID%TYPE
58 , Func_Area_short_name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE
59 , Language BIS_FORM_FUNCTION_EXTENSION_TL.LANGUAGE%TYPE
60 , Source_Lang BIS_FORM_FUNCTION_EXTENSION_TL.SOURCE_LANG%TYPE
61 , Created_By BIS_FORM_FUNCTION_EXTENSION_TL.CREATED_BY%TYPE
62 , Creation_Date BIS_FORM_FUNCTION_EXTENSION_TL.CREATION_DATE%TYPE
63 , Last_Updated_By BIS_FORM_FUNCTION_EXTENSION_TL.LAST_UPDATED_BY%TYPE
64 , Last_Update_Date BIS_FORM_FUNCTION_EXTENSION_TL.LAST_UPDATE_DATE%TYPE
65 , Last_Update_Login BIS_FORM_FUNCTION_EXTENSION_TL.LAST_UPDATE_LOGIN%TYPE
66 );
67
68 -- APIS to manage Measure Extensions
69 PROCEDURE Create_Measure_Extension(
70 p_Api_Version IN NUMBER
71 ,p_Commit IN VARCHAR2
72 ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
73 ,x_Return_Status OUT NOCOPY VARCHAR2
74 ,x_Msg_Count OUT NOCOPY NUMBER
75 ,x_Msg_Data OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE Retrieve_Measure_Extension(
79 p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
80 ,x_Meas_Extn_Rec OUT NOCOPY BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_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 Update_Measure_Extension(
87 p_Api_Version IN NUMBER
88 ,p_Commit IN VARCHAR2
89 ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
90 ,x_Return_Status OUT NOCOPY VARCHAR2
91 ,x_Msg_Count OUT NOCOPY NUMBER
92 ,x_Msg_Data OUT NOCOPY VARCHAR2
93 );
94
95
96 PROCEDURE Translate_Measure_Extension(
97 p_Api_Version IN NUMBER
98 ,p_Commit IN VARCHAR2
99 ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
100 ,x_Return_Status OUT NOCOPY VARCHAR2
101 ,x_Msg_Count OUT NOCOPY NUMBER
102 ,x_Msg_Data OUT NOCOPY VARCHAR2
103 );
104 PROCEDURE Load_Measure_Extension(
105 p_Api_Version IN NUMBER
106 ,p_Commit IN VARCHAR2
107 ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
108 ,p_Custom_mode IN VARCHAR2
109 ,x_Return_Status OUT NOCOPY VARCHAR2
110 ,x_Msg_Count OUT NOCOPY NUMBER
111 ,x_Msg_Data OUT NOCOPY VARCHAR2
112 );
113
114
115
116 -- APIS to manage FORM_FUNCTION extensions
117 PROCEDURE Create_Form_Func_Extension(
118 p_Api_Version IN NUMBER
119 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
120 ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
121 ,x_Return_Status OUT NOCOPY VARCHAR2
122 ,x_Msg_Count OUT NOCOPY NUMBER
123 ,x_Msg_Data OUT NOCOPY VARCHAR2
124 );
125
126
127 PROCEDURE Update_Form_Func_Extension(
128 p_Api_Version IN NUMBER
129 ,p_Commit IN VARCHAR2
130 ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
131 ,x_Return_Status OUT NOCOPY VARCHAR2
132 ,x_Msg_Count OUT NOCOPY NUMBER
133 ,x_Msg_Data OUT NOCOPY VARCHAR2
134 );
135
136
137 PROCEDURE Translate_Form_Func_Extension(
138 p_Api_Version IN NUMBER
139 ,p_Commit IN VARCHAR2
140 ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
141 ,x_Return_Status OUT NOCOPY VARCHAR2
142 ,x_Msg_Count OUT NOCOPY NUMBER
143 ,x_Msg_Data OUT NOCOPY VARCHAR2
144 );
145 PROCEDURE Load_Form_Func_Extension(
146 p_Api_Version IN NUMBER
147 ,p_Commit IN VARCHAR2
148 ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
149 ,p_Custom_mode IN VARCHAR2
150 ,x_Return_Status OUT NOCOPY VARCHAR2
151 ,x_Msg_Count OUT NOCOPY NUMBER
152 ,x_Msg_Data OUT NOCOPY VARCHAR2
153 );
154 PROCEDURE Retrieve_Form_Func_Extension(
155 p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
156 , x_Form_Func_Extn_Rec OUT NOCOPY BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
157 , x_Return_Status OUT NOCOPY VARCHAR2
158 , x_Msg_Count OUT NOCOPY NUMBER
159 , x_Msg_Data OUT NOCOPY VARCHAR2
160 );
161 PROCEDURE Delete_Form_Func_Extension(
162 p_Api_Version IN NUMBER
163 ,p_Commit IN VARCHAR2
164 ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
165 ,x_Return_Status OUT NOCOPY VARCHAR2
166 ,x_Msg_Count OUT NOCOPY NUMBER
167 ,x_Msg_Data OUT NOCOPY VARCHAR2
168 );
169
170 PROCEDURE Delete_Measure_Extension(
171 p_Api_Version IN NUMBER
172 ,p_Commit IN VARCHAR2
173 ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
174 ,x_Return_Status OUT NOCOPY VARCHAR2
175 ,x_Msg_Count OUT NOCOPY NUMBER
176 ,x_Msg_Data OUT NOCOPY VARCHAR2
177 );
178
179 /***********************************************************************
180 Object Functional Area Mapping
181 /***********************************************************************/
182
183 PROCEDURE Object_Funct_Area_Map
184 (
185 p_Api_Version IN NUMBER
186 , p_Commit IN VARCHAR2 := FND_API.G_FALSE
187 , p_Obj_Type IN VARCHAR2
188 , p_Obj_Name IN VARCHAR2
189 , p_App_Id IN NUMBER
190 , p_Func_Area_Sht_Name IN VARCHAR2
191 , x_Return_Status OUT NOCOPY VARCHAR2
192 , x_Msg_Count OUT NOCOPY NUMBER
193 , x_Msg_Data OUT NOCOPY VARCHAR2
194
195 );
196
197 /************************************************************************/
198 PROCEDURE Add_Language;
199
200 END BIS_OBJECT_EXTENSIONS_PUB;