[Home] [Help]
PACKAGE: APPS.IBC_CTYPE_PVT
Source
1 PACKAGE Ibc_Ctype_Pvt AUTHID CURRENT_USER AS
2 /* $Header: ibcvctys.pls 120.1 2005/06/01 23:25:05 appldev $ */
3
4 -- Purpose: API to Populate Content Type.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Sri Rangarajan 01/06/2002 Created Package
10 -- shitij.vatsa 11/04/2002 Updated for NOCOPY
11 -- Sri Rangarajan 01/06/2004 Added the Method get_sql_from_flex
12
13 -- Package name : IBC_Ctype_Pvt
14 -- Purpose :
15 -- History : 05/18/2005 Sharma GSCC NOCOPY issue fixed
16 -- NOTE :
17 -- End of Comments
18
19
20
21 -- Default number of records fetch per call
22 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
23 IBC_APPL_ID NUMBER := 549;
24
25 G_NAME VARCHAR2(4) := 'NAME';
26 G_DESCRIPTION VARCHAR2(11) := 'DESCRIPTION';
27
28
29 TYPE Index_Link_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
30 G_MISS_Link_Tbl Index_Link_Tbl_Type;
31
32 TYPE VARCHAR_Tbl_Type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
33
34
35 TYPE Content_type_Rec_Type IS RECORD(
36 CONTENT_TYPE_CODE VARCHAR2(100)
37 ,CONTENT_TYPE_NAME VARCHAR2(240)
38 ,CONTENT_TYPE_STATUS VARCHAR2(30)
39 ,DESCRIPTION VARCHAR2(2000)
40 ,APPLICATION_ID NUMBER
41 ,CREATED_BY NUMBER
42 ,CREATION_DATE DATE
43 ,LAST_UPDATED_BY NUMBER
44 ,LAST_UPDATE_DATE DATE
45 ,LAST_UPDATE_LOGIN NUMBER
46 ,REQUEST_ID NUMBER
47 ,PROGRAM_UPDATE_DATE DATE
48 ,PROGRAM_APPLICATION_ID NUMBER
49 ,PROGRAM_ID NUMBER
50 ,OBJECT_VERSION_NUMBER NUMBER
51 );
52
53 G_MISS_Content_Type_REC Content_Type_Rec_Type;
54
55 TYPE Content_Type_Tbl_Type IS TABLE OF Content_Type_Rec_Type
56 INDEX BY BINARY_INTEGER;
57
58 G_MISS_Content_Type_Tbl Content_Type_Tbl_Type;
59
60
61 TYPE Attribute_type_Rec_Type IS RECORD(
62 OPERATION_CODE VARCHAR2(30)
63 ,ATTRIBUTE_TYPE_CODE VARCHAR2(100)
64 ,ATTRIBUTE_TYPE_NAME VARCHAR2(240)
65 ,DESCRIPTION VARCHAR2(2000)
66 ,CONTENT_TYPE_CODE VARCHAR2(100)
67 ,DATA_TYPE_CODE VARCHAR2(30)
68 ,DATA_LENGTH NUMBER
69 ,MIN_INSTANCES NUMBER
70 ,MAX_INSTANCES NUMBER
71 ,REFERENCE_CODE VARCHAR2(100)
72 ,DEFAULT_VALUE VARCHAR2(240)
73 ,UPDATEABLE_FLAG VARCHAR2(1)
74 ,CREATED_BY NUMBER
75 ,CREATION_DATE DATE
76 ,LAST_UPDATED_BY NUMBER
77 ,LAST_UPDATE_DATE DATE
78 ,LAST_UPDATE_LOGIN NUMBER
79 ,OBJECT_VERSION_NUMBER NUMBER
80 );
81
82 G_MISS_Attribute_Type_REC Attribute_Type_Rec_Type;
83
84 TYPE Attribute_Type_Tbl_Type IS TABLE OF Attribute_Type_Rec_Type
85 INDEX BY BINARY_INTEGER;
86
87 G_MISS_Attribute_Type_Tbl Attribute_Type_Tbl_Type;
88
89
90 -- *******************************************************
91 -- Start of Comments
92 -- *******************************************************
93 -- API Name: Create_Content_Type
94 -- Type : Public
95 -- Pre-Req :
96 -- Parameters:
97 -- IN
98 -- p_api_version_number IN NUMBER Required
99 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101 -- P_Content_Type_Rec IN Content_Type_Rec_Type Required
102 -- P_Attribute_Type_Tbl IN Attribute_Type_Tbl_Type Required
103 --
104 -- OUT:
105 -- x_return_status OUT NOCOPY VARCHAR2
106 -- x_msg_count OUT NOCOPY NUMBER
107 -- x_msg_data OUT NOCOPY VARCHAR2
108 --
109 -- End of Comments
110 --
111 PROCEDURE Create_Content_Type(
112 P_Api_Version_Number IN NUMBER,
113 P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
114 P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
115 P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
116 P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type := Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
117 P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type := Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,
118 X_Return_Status OUT NOCOPY VARCHAR2,
119 X_Msg_Count OUT NOCOPY NUMBER,
120 X_Msg_Data OUT NOCOPY VARCHAR2
121 );
122
123
124 -- *******************************************************
125 -- Start of Comments
126 -- *******************************************************
127 -- API Name: Update_Content_Type
128 -- Type : Public
129 -- Pre-Req :
130 -- Parameters:
131 -- IN
132 -- p_api_version_number IN NUMBER Required
133 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135 -- P_Content_Type_Rec IN Content_Type_Rec_Type Required
136 -- P_Attribute_Type_Tbl IN Attribute_Type_Tbl_Type Required
137 --
138 -- OUT:
139 -- x_return_status OUT NOCOPY VARCHAR2
140 -- x_msg_count OUT NOCOPY NUMBER
141 -- x_msg_data OUT NOCOPY VARCHAR2
142 --
143 -- End of Comments
144 --
145
146
147 PROCEDURE Update_Content_Type(
148 P_Api_Version_Number IN NUMBER,
149 P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
150 P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
151 P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
152 P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type := Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
153 P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type := Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,
154 x_Content_Type_Rec OUT NOCOPY Ibc_Ctype_Pvt.Content_Type_Rec_Type,
155 x_Attribute_Type_Tbl OUT NOCOPY Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type,
156 X_Return_Status OUT NOCOPY VARCHAR2,
157 X_Msg_Count OUT NOCOPY NUMBER,
158 X_Msg_Data OUT NOCOPY VARCHAR2
159 );
160
161 -- *******************************************************
162 -- Start of Comments
163 -- *******************************************************
164 -- API Name: Delete_Content_Type
165 -- Type : Public
166 -- Pre-Req :
167 -- Parameters:
168 -- IN
169 -- p_api_version_number IN NUMBER Required
170 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172 -- P_Content_Type_Code IN VARCHAR2 Required
173 --
174 -- OUT:
175 -- x_return_status OUT NOCOPY VARCHAR2
176 -- x_msg_count OUT NOCOPY NUMBER
177 -- x_msg_data OUT NOCOPY VARCHAR2
178 --
179 -- End of Comments
180 --
181
182 PROCEDURE delete_Content_Type(
183 P_Api_Version_Number IN NUMBER,
184 P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
185 P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
186 P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
187 P_Content_Type_Code IN VARCHAR2,
188 X_Return_Status OUT NOCOPY VARCHAR2,
189 X_Msg_Count OUT NOCOPY NUMBER,
190 X_Msg_Data OUT NOCOPY VARCHAR2
191 );
192
193
194
195 -- *******************************************************
196 -- Start of Comments
197 -- *******************************************************
198 -- API Name: Get_Content_type
199 -- Type : Public
200 -- Pre-Req :
201 -- Parameters:
202 -- IN
203 -- p_api_version_number IN NUMBER Required
204 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
205 -- P_Content_Type_Rec IN Content_Type_Rec_Type Required
206 -- p_rec_requested IN NUMBER Optional Default = 30
207 -- p_start_rec_ptr IN NUMBER Optional Default = 1
208 --
209 -- Return Total Records Count Flag. This flag controls whether the total record count
210 -- and total record amount is returned.
211 --
212 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
213 --
214 -- OUT:
215 -- X_Content_Type_Tbl OUT NOCOPY Content_Type_Tbl_Type
216 -- x_returned_rec_count OUT NOCOPY NUMBER
217 -- x_next_rec_ptr OUT NOCOPY NUMBER
218 -- x_tot_rec_count OUT NOCOPY NUMBER
219 -- x_tot_rec_amount OUT NOCOPY NUMBER
220 -- x_return_status OUT NOCOPY VARCHAR2
221 -- x_msg_count OUT NOCOPY NUMBER
222 -- x_msg_data OUT NOCOPY VARCHAR2
223
224
225
226 -- PROCEDURE Get_Content_type(
227 -- P_Api_Version_Number IN NUMBER,
228 -- P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
229 -- P_Content_Type_Rec IN Content_Type_Rec_Type,
230 -- p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
231 -- p_start_rec_prt IN NUMBER := 1,
232 -- p_return_tot_count IN NUMBER := FND_API.G_FALSE,
233 -- X_Content_Type_Tbl OUT NOCOPY Content_Type_Tbl_Type,
234 -- x_returned_rec_count OUT NOCOPY NUMBER,
235 -- x_next_rec_ptr OUT NOCOPY NUMBER,
236 -- x_tot_rec_count OUT NOCOPY NUMBER,
237 -- x_return_status OUT NOCOPY VARCHAR2,
238 -- x_msg_count OUT NOCOPY NUMBER,
239 -- x_msg_data OUT NOCOPY VARCHAR2
240 -- );
241
242 FUNCTION get_ctype_rec RETURN Ibc_Ctype_Pvt.content_type_rec_type;
243
244
245 PROCEDURE Create_Attribute_Type(
246 P_Api_Version_Number IN NUMBER,
247 P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
248 P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
249 P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
250 P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
251 X_Return_Status OUT NOCOPY VARCHAR2,
252 X_Msg_Count OUT NOCOPY NUMBER,
253 X_Msg_Data OUT NOCOPY VARCHAR2
254 );
255
256 PROCEDURE get_Attribute_Type_LOV(
257 P_Api_Version_Number IN NUMBER
258 ,P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE
259 ,p_content_type_code IN VARCHAR2 --1
260 ,p_attribute_type_code IN VARCHAR2 --2
261 ,x_code OUT NOCOPY JTF_VARCHAR2_TABLE_100 --4
262 ,x_name OUT NOCOPY JTF_VARCHAR2_TABLE_300 -- 5
263 ,x_description OUT NOCOPY JTF_VARCHAR2_TABLE_2000 --3
264 ,X_Return_Status OUT NOCOPY VARCHAR2 --6
265 ,X_Msg_Count OUT NOCOPY NUMBER -- 7
266 ,X_Msg_Data OUT NOCOPY VARCHAR2 -- 8
267 );
268
269 PROCEDURE get_Content_Type(
270 p_api_version_number IN NUMBER DEFAULT 1.0
271 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.g_false
272 ,p_content_type_code IN VARCHAR2 -- 1
273 ,x_content_type_name OUT NOCOPY VARCHAR2 -- 2
274 ,x_content_type_description OUT NOCOPY VARCHAR2 -- 3
275 ,x_content_type_status OUT NOCOPY VARCHAR2 -- 4
276 ,X_ATTRIBUTE_TYPE_CODE OUT NOCOPY JTF_VARCHAR2_TABLE_100 -- 5
277 ,x_ATTRIBUTE_TYPE_NAME OUT NOCOPY JTF_VARCHAR2_TABLE_300 -- 6
278 ,x_DESCRIPTION OUT NOCOPY JTF_VARCHAR2_TABLE_2000 -- 7
279 ,x_CONTENT_TYPE_CODE OUT NOCOPY JTF_VARCHAR2_TABLE_100 -- 8
280 ,x_DATA_TYPE_CODE OUT NOCOPY JTF_VARCHAR2_TABLE_100 -- 9
281 ,x_DATA_LENGTH OUT NOCOPY JTF_NUMBER_TABLE -- 10
282 ,x_MIN_INSTANCES OUT NOCOPY JTF_NUMBER_TABLE -- 11
283 ,x_MAX_INSTANCES OUT NOCOPY JTF_NUMBER_TABLE -- 12
284 ,x_Flex_value_set_id OUT NOCOPY JTF_NUMBER_TABLE -- 13
285 ,x_REFERENCE_CODE OUT NOCOPY JTF_VARCHAR2_TABLE_100 -- 14
286 ,x_DEFAULT_VALUE OUT NOCOPY JTF_VARCHAR2_TABLE_300 -- 15
287 ,x_UPDATEABLE_FLAG OUT NOCOPY JTF_VARCHAR2_TABLE_100 -- 16 Varchar2(1)
288 ,x_CREATED_BY OUT NOCOPY JTF_NUMBER_TABLE -- 17
289 ,x_CREATION_DATE OUT NOCOPY JTF_DATE_TABLE -- 18
290 ,x_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE --19
291 ,x_LAST_UPDATE_DATE OUT NOCOPY JTF_DATE_TABLE -- 20
292 ,x_LAST_UPDATE_LOGIN OUT NOCOPY JTF_NUMBER_TABLE --21
293 ,x_OBJECT_VERSION_NUMBER OUT NOCOPY JTF_NUMBER_TABLE --22
294 ,x_return_status OUT NOCOPY VARCHAR2 -- 23
295 ,x_msg_count OUT NOCOPY INTEGER --24
296 ,x_msg_data OUT NOCOPY VARCHAR2 --25
297 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')--26
298 );
299
300
301 PROCEDURE Is_Valid_Flex_Value(
302 P_Api_Version_Number IN NUMBER
303 ,P_Init_Msg_List IN VARCHAR2
304 ,p_flex_value_set_id IN NUMBER
305 ,p_flex_value_code IN VARCHAR2
306 ,x_exists OUT NOCOPY VARCHAR2
307 ,X_Return_Status OUT NOCOPY VARCHAR2
308 ,X_Msg_Count OUT NOCOPY NUMBER
309 ,X_Msg_Data OUT NOCOPY VARCHAR2
310 );
311
312
313 -- Uses the Flex_value_set_id defined for the attributes and returns
314 -- the SQL corresponding to Flex Value set
315 --
316 PROCEDURE get_sql_from_flex(
317 p_api_version_number IN NUMBER DEFAULT 1.0
318 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.g_false
319 ,p_flex_value_set_id IN NUMBER --1
320 ,x_select OUT NOCOPY VARCHAR2 --4
321 ,X_Return_Status OUT NOCOPY VARCHAR2 --6
322 ,X_Msg_Count OUT NOCOPY NUMBER -- 7
323 ,X_Msg_Data OUT NOCOPY VARCHAR2 -- 8
324 );
325
326 END Ibc_Ctype_Pvt;