[Home] [Help]
PACKAGE: APPS.CSC_PROFILE_VARIABLE_PUB
Source
1 PACKAGE CSC_Profile_Variable_PUB AUTHID CURRENT_USER AS
2 /* $Header: cscppvas.pls 115.14 2002/11/28 09:36:06 bhroy ship $ */
3
4 -- *******************************************************
5 -- Start of Comments
6 -- -------------------------------------------------------
7 -- Record name:PROFVAR_Rec_Type
8 -- -------------------------------------------------------
9 -- Parameters:
10 -- BLOCK_ID
11 -- CREATED_BY
12 -- CREATION_DATE
13 -- LAST_UPDATED_BY
14 -- LAST_UPDATE_DATE
15 -- LAST_UPDATE_LOGIN
16 -- BLOCK_NAME
17 -- DESCRIPTION
18 -- START_DATE_ACTIVE
19 -- END_DATE_ACTIVE
20 -- SEEDED_FLAG
21 -- BLOCK_NAME_CODE
22 -- FORM_FUNCTION_ID
23 -- COLUMN_ID
24 -- SQL_STMNT_FOR_DRILLDOWN
25 -- SQL_STMNT
26 -- SELECT_CLAUSE
27 -- CURRENCY_CODE
28 -- FROM_CLAUSE
29 -- WHERE_CLAUSE
30 -- ORDER_BY_CLAUSE
31 -- OTHER_CLAUSE
32 -- BLOCK_LEVEL
33 -- APPLICATION_ID
34
35 TYPE ProfVar_Rec_Type IS RECORD (
36 BLOCK_ID NUMBER,
37 CREATED_BY NUMBER,
38 CREATION_DATE DATE,
39 LAST_UPDATED_BY NUMBER,
40 LAST_UPDATE_DATE DATE,
41 LAST_UPDATE_LOGIN NUMBER,
42 BLOCK_NAME VARCHAR2(80),
43 DESCRIPTION VARCHAR2(240),
44 START_DATE_ACTIVE DATE,
45 END_DATE_ACTIVE DATE,
46 SEEDED_FLAG VARCHAR2(1),
47 BLOCK_NAME_CODE VARCHAR2(80),
48 OBJECT_CODE VARCHAR2(30),
49 SQL_STMNT VARCHAR2(2000),
50 SQL_STMNT_FOR_DRILLDOWN VARCHAR2(2000),
51 SELECT_CLAUSE VARCHAR2(2000),
52 CURRENCY_CODE VARCHAR2(30),
53 FROM_CLAUSE VARCHAR2(200),
54 WHERE_CLAUSE VARCHAR2(2000),
55 ORDER_BY_CLAUSE VARCHAR2(200),
56 OTHER_CLAUSE VARCHAR2(200),
57 BLOCK_LEVEL VARCHAR2(20),
58 OBJECT_VERSION_NUMBER NUMBER,
59 APPLICATION_ID NUMBER
60 );
61
62
63 G_MISS_PROF_REC ProfVar_Rec_Type;
64
65
66 G_Miss_Table_Column_Tbl CSC_Profile_Variable_PVT.Table_Column_tbl_TYPE;
67
68
69 -- ------------------------------------------------------------------
70 -- API name: Create_Profile_Variable
71 -- Version : Initial version 1.0
72 -- Type: Public
73 -- Function: Creates a customer profile variable in the table CS_PROF_BLOCKS
74 -- Pre-reqs: None.
75
76 -- Parameters:
77
78 -- Standard IN Parameters:
79
80 -- p_api_version IN NUMBER Required
81 -- p_init_msg_list IN VARCHAR2 Optional
82 -- Default = FND_API.G_FALSE
83 -- p_commit IN VARCHAR2 Optional
84 -- Default = FND_API.G_FALSE
85
86 -- Standard OUT NOCOPY Parameters:
87
88 -- x_return_status OUT NOCOPY VARCHAR2(1)
89 -- x_msg_count OUT NOCOPY NUMBER
90 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
91
92 -- Customer Profile Variable IN Parameters:
93
94 -- p_resp_appl_id IN NUMBER Optional
95 -- Application identifier
96 -- p_resp_id IN NUMBER Optional
97 -- Responsibility identifier
98 -- p_user_id IN NUMBER Required
99 -- Application user identifier
100 -- p_login_id IN NUMBER Optional
101 -- Login session identifier
102 -- p_org_id IN NUMBER Optional
103 -- Operating unit identifier
104 -- Required if Multi-Org is enabled.
105 -- Ignored if Multi-Org is disabled.
106 -- p_block_name IN VARCHAR2(80) Required
107 -- Variable Block Name.
108 -- P_description IN VARCHAR2(240) Optional
109 -- Variable Block description
110 -- p_seeded_flag IN VARCHAR2(1) Optional
111 -- Indicates whether the Variable is seeded.
112 -- p_sql_stmnt IN VARCHAR2(2000) Required
113 -- Sql stmnt. Must be non-null.
114 -- p_start_date_active IN DATE Optional
115 -- Start active date for the variable block.
116 -- p_end_date_active IN DATE Optional
117 -- End date for the variable block.
118
119 -- Customer Profile Variable OUT NOCOPY parameters:
120 -- p_application_id IN NUMBER Optional
121 -- x_block_id OUT NOCOPY NUMBER
122 -- System generated ID of Customer Profile Variable.
123 --
124 -----------------------------------------------------------------------
125
126 PROCEDURE Create_Profile_Variable(
127 p_api_version_number IN NUMBER,
128 p_init_msg_list IN VARCHAR2,
129 p_commit IN VARCHAR2,
130 p_validation_level IN VARCHAR2 DEFAULT NULL,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_block_name IN VARCHAR2,
135 p_block_name_code IN VARCHAR2 DEFAULT NULL,
136 p_description IN VARCHAR2 DEFAULT NULL,
137 p_sql_stmnt IN VARCHAR2 DEFAULT NULL,
138 p_seeded_flag IN VARCHAR2 DEFAULT NULL,
139 p_start_date_active IN DATE DEFAULT NULL,
140 p_end_date_active IN DATE DEFAULT NULL,
141 p_currency_code IN VARCHAR2 DEFAULT NULL,
142 --p_form_function_id IN NUMBER := FND_API.G_MISS_NUM,
143 p_object_code IN VARCHAR2 DEFAULT NULL,
144 p_select_clause IN VARCHAR2 DEFAULT NULL,
145 p_from_clause IN VARCHAR2 DEFAULT NULL,
146 p_where_clause IN VARCHAR2 DEFAULT NULL,
147 p_other_clause IN VARCHAR2 DEFAULT NULL,
148 p_block_level IN VARCHAR2 DEFAULT NULL,
149 p_CREATED_BY IN NUMBER DEFAULT NULL,
150 p_CREATION_DATE IN DATE DEFAULT NULL,
151 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
152 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
153 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
154 x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
155 p_APPLICATION_ID IN NUMBER DEFAULT NULL,
156 x_block_id OUT NOCOPY NUMBER
157 );
158
159 -- ------------------------------------------------------------------
160 -- API name: Create_Profile_Variable
161 -- Version : Initial version 1.0
162 -- Type: Public
163 -- Function: Creates a customer profile variable in the table CS_PROF_BLOCKS
164 -- Pre-reqs: None.
165
166 -- Parameters:
167
168 -- Standard IN Parameters:
169
170 -- p_api_version IN NUMBER Required
171 -- p_init_msg_list IN VARCHAR2 Optional
172 -- Default = FND_API.G_FALSE
173 -- p_commit IN VARCHAR2 Optional
174 -- Default = FND_API.G_FALSE
175
176 -- Standard OUT NOCOPY Parameters:
177
178 -- x_return_status OUT NOCOPY VARCHAR2(1)
179 -- x_msg_count OUT NOCOPY NUMBER
180 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
181
182 -- Customer Profile Variable IN Parameters:
183
184 -- P_Prof_Var_Rec IN ProfVar_Rec_Type
185
186 -- Customer Profile Variable OUT NOCOPY parameters:
187
188 -- x_block_id OUT NOCOPY NUMBER
189 -- System generated ID of Customer Profile Variable.
190 --
191 -----------------------------------------------------------------------
192
193 PROCEDURE Create_Profile_Variable(
194 P_Api_Version_Number IN NUMBER,
195 P_Init_Msg_List IN VARCHAR2,
196 P_Commit IN VARCHAR2,
197 P_Validation_Level IN NUMBER DEFAULT NULL,
198 P_Prof_Var_Rec IN ProfVar_Rec_Type,
199 X_Return_Status OUT NOCOPY VARCHAR2,
200 X_Msg_Count OUT NOCOPY NUMBER,
201 X_Msg_Data OUT NOCOPY VARCHAR2,
202 X_Block_Id OUT NOCOPY NUMBER ,
203 x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
204 );
205
206 -- *******************************************************
207 -- Start of Comments
208 -- *******************************************************
209 -- API Name: Create_table_column
210 -- Type : Public
211 -- Pre-Req :
212 -- Parameters:
213 -- IN
214 -- p_api_version_number IN NUMBER Required
215 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217 -- P_TabCol_Rec IN TabCol_Rec_Type Required
218 --
219 -- OUT NOCOPY:
220 -- x_return_status OUT NOCOPY VARCHAR2
221 -- x_msg_count OUT NOCOPY NUMBER
222 -- x_msg_data OUT NOCOPY VARCHAR2
223 --
224 -- Version : Current version 1.0
225 --
226 -- End of Comments
227 --
228 PROCEDURE Create_table_column(
229 P_Api_Version_Number IN NUMBER,
230 P_Init_Msg_List IN VARCHAR2,
231 P_Commit IN VARCHAR2,
232 P_Validation_level IN NUMBER,
233 p_Table_Column_Tbl IN CSC_Profile_Variable_pvt.Table_Column_Tbl_Type,
234 --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := FND_API.G_MISS_CHAR,
235 --p_BLOCK_ID IN NUMBER,
236 X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
237 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
238 X_Return_Status OUT NOCOPY VARCHAR2,
239 X_Msg_Count OUT NOCOPY NUMBER,
240 X_Msg_Data OUT NOCOPY VARCHAR2
241 );
242 -- ------------------------------------------------------------------
243 -- API name: Update_Profile_Variable
244 -- Version : Initial version 1.0
245 -- Type: Public
246 -- Function: Updates a customer profile variable in the table CS_PROF_BLOCKS
247 -- Pre-reqs: None.
248
249 -- Parameters:
250
251 -- Standard IN Parameters:
252
253 -- p_api_version IN NUMBER Required
254 -- p_init_msg_list IN VARCHAR2 Optional
255 -- Default = FND_API.G_FALSE
256 -- p_commit IN VARCHAR2 Optional
257 -- Default = FND_API.G_FALSE
258
259 -- Standard OUT NOCOPY Parameters:
260
261 -- x_return_status OUT NOCOPY VARCHAR2(1)
262 -- x_msg_count OUT NOCOPY NUMBER
263 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
264
265 -- Customer Profile Variable IN Parameters:
266
267 -- p_resp_appl_id IN NUMBER Optional
268 -- Application identifier
269 -- p_resp_id IN NUMBER Optional
270 -- Responsibility identifier
271 -- p_user_id IN NUMBER Required
272 -- Application user identifier
273 -- p_login_id IN NUMBER Optional
274 -- Login session identifier
275 -- p_org_id IN NUMBER Optional
276 -- Operating unit identifier
277 -- Required if Multi-Org is enabled.
278 -- Ignored if Multi-Org is disabled.
279 -- p_block_id IN NUMBER Required
280 -- System generated ID of Customer Profile Variable.
281 -- p_block_name IN VARCHAR2(80) Required
282 -- Variable Block Name.
283 -- P_description IN VARCHAR2(240) Optional
284 -- Variable Block description
285 -- p_seeded_flag IN VARCHAR2(1) Optional
286 -- Indicates whether the Variable is seeded.
287 -- p_sql_stmnt IN VARCHAR2(2000) Required
288 -- Sql stmnt. Must be non-null.
289 -- p_start_date_active IN DATE Optional
290 -- Start active date for the variable block.
291 -- p_end_date_active IN DATE Optional
292 -- End date for the variable block.
293 -- p_application_id IN NUMBER Optional
294
295 -- -----------------------------------------------------------------
296
297 PROCEDURE Update_Profile_Variable(
298 p_api_version_number IN NUMBER,
299 p_init_msg_list IN VARCHAR2,
300 p_commit IN VARCHAR2,
301 p_validation_level IN VARCHAR2 DEFAULT NULL,
302 x_return_status OUT NOCOPY VARCHAR2,
303 x_msg_count OUT NOCOPY NUMBER,
304 x_msg_data OUT NOCOPY VARCHAR2,
305 p_block_id IN NUMBER DEFAULT NULL,
306 p_block_name IN VARCHAR2 DEFAULT NULL,
307 p_block_name_code IN VARCHAR2 DEFAULT NULL,
308 p_description IN VARCHAR2 DEFAULT NULL,
309 p_currency_code IN VARCHAR2 DEFAULT NULL,
310 p_sql_stmnt IN VARCHAR2 DEFAULT NULL,
311 p_seeded_flag IN VARCHAR2 DEFAULT NULL,
312 --p_form_function_id IN NUMBER DEFAULT NULL,
313 p_object_code IN VARCHAR2 DEFAULT NULL,
314 p_start_date_active IN DATE DEFAULT NULL,
315 p_end_date_active IN DATE DEFAULT NULL,
316 p_select_clause IN VARCHAR2 DEFAULT NULL,
317 p_from_clause IN VARCHAR2 DEFAULT NULL,
318 p_where_clause IN VARCHAR2 DEFAULT NULL,
319 p_other_clause IN VARCHAR2 DEFAULT NULL,
320 p_block_level IN VARCHAR2 DEFAULT NULL,
321 p_CREATED_BY IN NUMBER DEFAULT NULL,
322 p_CREATION_DATE IN DATE DEFAULT NULL,
323 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
324 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
325 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
326 px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
327 p_APPLICATION_ID IN NUMBER DEFAULT NULL
328 );
329
330
331 -- ------------------------------------------------------------------
332 -- API name: Update_Profile_Variable
333 -- Version : Initial version 1.0
334 -- Type: Public
335 -- Function: Updates a customer profile variable in the table CS_PROF_BLOCKS
336 -- Pre-reqs: None.
337
338 -- Parameters:
339
340 -- Standard IN Parameters:
341
342 -- p_api_version IN NUMBER Required
343 -- p_init_msg_list IN VARCHAR2 Optional
344 -- Default = FND_API.G_FALSE
345 -- p_commit IN VARCHAR2 Optional
346 -- Default = FND_API.G_FALSE
347
348 -- Standard OUT NOCOPY Parameters:
349
350 -- x_return_status OUT NOCOPY VARCHAR2(1)
351 -- x_msg_count OUT NOCOPY NUMBER
352 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
353
354 -- Customer Profile Variable IN Parameters:
355 -- P_Prof_Var_Rec IN ProfVar_Rec_Type
356
357 -- -----------------------------------------------------------------
358
359 PROCEDURE Update_Profile_Variable (
360 p_api_version_number IN VARCHAR2,
361 p_init_msg_list IN VARCHAR2,
362 p_commit IN VARCHAR2,
363 p_validation_level IN VARCHAR2 DEFAULT NULL,
364 p_prof_var_rec IN ProfVar_Rec_Type,
365 px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER ,
366 x_return_status OUT NOCOPY VARCHAR2,
367 x_msg_data OUT NOCOPY VARCHAR2,
368 x_msg_count OUT NOCOPY NUMBER
369 );
370
371 -- *******************************************************
372 -- Start of Comments
373 -- *******************************************************
374 -- API Name: Update_table_column
375 -- Type : Public
376 -- Pre-Req :
377 -- Parameters:
378 -- IN
379 -- p_api_version_number IN NUMBER Required
380 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
381 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
382 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
383 -- P_TabCol_Rec IN TabCol_Rec_Type Required
384 --
385 -- OUT NOCOPY:
386 -- x_return_status OUT NOCOPY VARCHAR2
387 -- x_msg_count OUT NOCOPY NUMBER
388 -- x_msg_data OUT NOCOPY VARCHAR2
389 --
390 -- End of Comments
391 --
392
393 PROCEDURE Update_table_column(
394 P_Api_Version_Number IN NUMBER,
395 P_Init_Msg_List IN VARCHAR2,
396 P_Commit IN VARCHAR2,
397 P_Validation_Level IN NUMBER,
398 p_Table_Column_Rec IN CSC_Profile_Variable_PVT.Table_Column_Rec_Type,
399 --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := FND_API.G_MISS_CHAR,
400 --p_BLOCK_ID IN NUMBER := FND_API.G_MISS_NUM,
401 px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER ,
402 X_Return_Status OUT NOCOPY VARCHAR2,
403 X_Msg_Count OUT NOCOPY NUMBER,
404 X_Msg_Data OUT NOCOPY VARCHAR2
405 );
406
407
408 END CSC_Profile_Variable_pub;