[Home] [Help]
PACKAGE: APPS.CSC_PROFILE_VARIABLE_PVT
Source
1 PACKAGE CSC_Profile_Variable_Pvt AUTHID CURRENT_USER AS
2 /* $Header: cscvpvas.pls 120.1.12020000.4 2013/04/08 10:53:40 spamujul 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 -- BLOCK_LEVEL
32 -- OTHER_CLAUSE
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(240) ,
43 DESCRIPTION VARCHAR2(240),
44 START_DATE_ACTIVE DATE ,
45 END_DATE_ACTIVE DATE ,
46 SEEDED_FLAG VARCHAR2(1),
47 BLOCK_NAME_CODE VARCHAR2(240),
48 OBJECT_CODE VARCHAR2(30) ,
49 SQL_STMNT VARCHAR2(2000),
50 BATCH_SQL_STMNT VARCHAR2(4000),
51 SQL_STMNT_FOR_DRILLDOWN VARCHAR2(4000) , /* increased to 4000 for bug 4205145 */
52 SELECT_CLAUSE VARCHAR2(2000),
53 CURRENCY_CODE VARCHAR2(30),
54 FROM_CLAUSE VARCHAR2(240),
55 WHERE_CLAUSE VARCHAR2(2000),
56 ORDER_BY_CLAUSE VARCHAR2(200),
57 OTHER_CLAUSE VARCHAR2(200),
58 BLOCK_LEVEL VARCHAR2(20),
59 OBJECT_VERSION_NUMBER NUMBER,
60 APPLICATION_ID NUMBER
61 );
62
63 G_MISS_PROF_REC ProfVar_Rec_Type;
64
65
66 -- *******************************************************
67 -- Start of Comments
68 -- -------------------------------------------------------
69 -- Record name:TabCol_Rec_Type
70 -- -------------------------------------------------------
71 -- Parameters:
72 -- TABLE_COLUMN_ID
73 -- BLOCK_ID
74 -- TABLE_NAME
75 -- COLUMN_NAME
76 -- LABEL
77 -- LAST_UPDATE_DATE
78 -- LAST_UPDATED_BY
79 -- CREATION_DATE
80 -- CREATED_BY
81 -- LAST_UPDATE_LOGIN
82 -- SEEDED_FLAG
83 --
84 --
85 -- End of Comments
86
87
88
89 TYPE Table_Column_Rec_Type IS RECORD
90 (
91 TABLE_COLUMN_ID NUMBER ,
92 BLOCK_ID NUMBER ,
93 TABLE_NAME VARCHAR2(30),
94 COLUMN_NAME VARCHAR2(30),
95 LABEL VARCHAR2(80),
96 TABLE_ALIAS VARCHAR2(80) ,
97 COLUMN_SEQUENCE NUMBER ,
98 DRILLDOWN_COLUMN_FLAG VARCHAR2(3),
99 LAST_UPDATE_DATE DATE ,
100 LAST_UPDATED_BY NUMBER,
101 CREATION_DATE DATE ,
102 CREATED_BY NUMBER,
103 LAST_UPDATE_LOGIN NUMBER,
104 SEEDED_FLAG VARCHAR2(3)
105 );
106
107 G_MISS_Table_Column_REC Table_Column_Rec_Type;
108
109 TYPE Table_Column_Tbl_Type IS TABLE OF Table_Column_Rec_Type
110 INDEX BY BINARY_INTEGER;
111 G_MISS_Table_Column_TBL Table_Column_Tbl_Type;
112
113 -- ------------------------------------------------------------------
114 -- Create_Profile_Variable
115 -- -----------------------------------------------------------------
116 -- Start Of Comments
117
118 -- API name: Create_Profile_Variable
119 -- Version : Initial version 1.0
120 -- Type: Private
121 -- Function: Creates a profile variable in the table CSC_PROF_BLOCKS_B
122 -- Pre-reqs: None.
123
124 -- Parameters:
125
126 -- Standard IN Parameters:
127
128 -- p_api_version IN NUMBER Required
129 -- p_init_msg_list IN VARCHAR2 Optional
130 -- Default = CSC_CORE_UTILS_PVT.G_FALSE
131 -- p_commit IN VARCHAR2 Optional
132 -- Default = CSC_CORE_UTILS_PVT.G_FALSE
133
134 -- Standard OUT Parameters:
135
136 -- x_return_status OUT VARCHAR2(1)
137 -- x_msg_count OUT NUMBER
138 -- x_msg_data OUT VARCHAR2(2000)
139
140 -- Customer Profile Variable IN Parameters:
141
142 -- p_block_name IN VARCHAR2(80) Required
143 -- Variable Block Name.
144 -- P_description IN VARCHAR2(240) Optional
145 -- Variable Block description
146 -- p_seeded_flag IN VARCHAR2(1) Optional
147 -- Indicates whether the Variable is seeded.
148 -- p_sql_stmnt IN VARCHAR2(2000) Required
149 -- Sql stmnt. Must be non-null.
150 -- p_start_date_active IN DATE Optional
151 -- Start active date for the variable block.
152 -- p_end_date_active IN DATE Optional
153 -- End date for the variable block.
154
155 -- Customer Profile Variable OUT parameters:
156
157 -- x_block_id OUT NUMBER
158 -- System generated ID of Profile Variable.
159
160 -- End Of Comments
161 -- -----------------------------------------------------------------
162
163 PROCEDURE Create_Profile_Variable(
164 p_api_version_number IN NUMBER,
165 p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
166 p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
167 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_block_name IN VARCHAR2,
172 p_block_name_code IN VARCHAR2 ,
173 p_description IN VARCHAR2 ,
174 p_sql_stmnt IN VARCHAR2 ,
175 p_batch_sql_stmnt IN VARCHAR2 ,
176 p_sql_stmnt_for_drilldown IN VARCHAR2 DEFAULT NULL,
177 p_seeded_flag IN VARCHAR2 ,
178 p_start_date_active IN DATE ,
179 p_end_date_active IN DATE ,
180 p_currency_code IN VARCHAR2,
181 --p_form_function_id IN NUMBER ,
182 p_object_code IN VARCHAR2 DEFAULT NULL ,
183 p_select_clause IN VARCHAR2,
184 p_from_clause IN VARCHAR2 ,
185 p_where_clause IN VARCHAR2 ,
186 p_order_by_clause IN VARCHAR2 DEFAULT NULL,
187 p_other_clause IN VARCHAR2 ,
188 p_block_level IN VARCHAR2 ,
189 p_CREATED_BY IN NUMBER ,
190 p_CREATION_DATE IN DATE ,
191 p_LAST_UPDATED_BY IN NUMBER ,
192 p_LAST_UPDATE_DATE IN DATE ,
193 p_LAST_UPDATE_LOGIN IN NUMBER,
194 x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
195 p_APPLICATION_ID IN NUMBER,
196 x_block_id OUT NOCOPY NUMBER
197 );
198
199 -- ------------------------------------------------------------------
200 -- Create_Profile_Variable
201 -- -----------------------------------------------------------------
202 -- Start Of Comments
203
204 -- API name: Create_Profile_Variable
205 -- Version : Initial version 1.0
206 -- Type: Private
207 -- Function: Creates a profile variable in the table CSC_PROF_BLOCKS_B
208 -- Pre-reqs: None.
209
210 -- Parameters:
211
212 -- Standard IN Parameters:
213
214 -- p_api_version IN NUMBER Required
215 -- p_init_msg_list IN VARCHAR2 Optional
216 -- Default = CSC_CORE_UTILS_PVT.G_FALSE
217 -- p_commit IN VARCHAR2 Optional
218 -- Default = CSC_CORE_UTILS_PVT.G_FALSE
219
220 -- Standard OUT Parameters:
221
222 -- x_return_status OUT VARCHAR2(1)
223 -- x_msg_count OUT NUMBER
224 -- x_msg_data OUT VARCHAR2(2000)
225
226 -- Customer Profile Variable IN Parameters:
227 -- P_prof_var_Rec IN ProfVar_Rec_Type
228
229 -- Customer Profile Variable OUT parameters:
230
231 -- x_block_id OUT NUMBER
232 -- System generated ID of Profile Variable.
233 -- -----------------------------------------------------------------
234
235 -- End Of Comments
236
237 PROCEDURE Create_Profile_Variable(
238 p_api_version_number IN NUMBER,
239 p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
240 p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
241 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
242 p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
243 x_msg_data OUT NOCOPY VARCHAR2,
244 x_msg_count OUT NOCOPY NUMBER,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_block_id OUT NOCOPY NUMBER,
247 x_object_version_number OUT NOCOPY NUMBER
248 );
249
250 -- *******************************************************
251 -- Start of Comments
252 -- *******************************************************
253 -- API Name: Create_table_column
254 -- Type : Private
255 -- Pre-Req :
256 -- Parameters:
257 -- IN
258 -- p_api_version_number IN NUMBER Required
259 -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
260 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
261 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
262 -- P_TabCol_Rec IN TabCol_Rec_Type Required
263 --
264 -- OUT:
265 -- x_return_status OUT VARCHAR2
266 -- x_msg_count OUT NUMBER
267 -- x_msg_data OUT VARCHAR2
268
269 --
270 -- End of Comments
271 --
272 PROCEDURE Create_table_column(
273 P_Api_Version_Number IN NUMBER,
274 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
275 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
276 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
277 p_Table_Column_Tbl IN Table_Column_Tbl_Type := G_MISS_Table_Column_TBL,
278 --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
279 --p_BLOCK_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
280 X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
281 X_object_version_number OUT NOCOPY NUMBER,
282 X_Return_Status OUT NOCOPY VARCHAR2,
283 X_Msg_Count OUT NOCOPY NUMBER,
284 X_Msg_Data OUT NOCOPY VARCHAR2
285 );
286
287
288 PROCEDURE Create_table_column(
289 P_Api_Version_Number IN NUMBER,
290 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
291 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
292 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
293 p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_Table_Column_REC,
294 --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
295 --p_BLOCK_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
296 X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
297 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
298 X_Return_Status OUT NOCOPY VARCHAR2,
299 X_Msg_Count OUT NOCOPY NUMBER,
300 X_Msg_Data OUT NOCOPY VARCHAR2
301 );
302
303 -- ------------------------------------------------------------------
304 --Update_Profile_Variable
305 -- -----------------------------------------------------------------
306 -- ------------------------------------------------------------------
307 -- API name: Update_Profile_Variable
308 -- Version : Initial version 1.0
309 -- Type: Private
310 -- Function: Updates a profile variable in the table CSC_PROF_BLOCKS_B
311 -- Pre-reqs: None.
312
313 -- Parameters:
314
315 -- Standard IN Parameters:
316
317 -- p_api_version IN NUMBER Required
318 -- p_init_msg_list IN VARCHAR2 Optional
319 -- Default = CSC_CORE_UTILS_PVT.G_FALSE
320 -- p_commit IN VARCHAR2 Optional
321 -- Default = CSC_CORE_UTILS_PVT.G_FALSE
322
323 -- Standard OUT Parameters:
324
325 -- x_return_status OUT VARCHAR2(1)
326 -- x_msg_count OUT NUMBER
327 -- x_msg_data OUT VARCHAR2(2000)
328
329 -- Customer Profile Variable IN Parameters:
330 -- p_block_id IN NUMBER Required
331 -- default CSC_CORE_UTILS_PVT.G_MISS_NUM
332 -- p_block_name IN VARCHAR2(80) Optional
333 -- Variable Block Name.
334 -- P_description IN VARCHAR2(240) Optional
335 -- Variable Block description
336 -- p_seeded_flag IN VARCHAR2(1) Optional
337 -- Indicates whether the Variable is seeded.
338 -- p_sql_stmnt IN VARCHAR2(2000) Optional
339 -- Sql stmnt. Must be non-null.
340 -- p_start_date_active IN DATE Optional
341 -- Start active date for the variable block.
342 -- p_end_date_active IN DATE Optional
343 -- End date for the variable block.
344 -- p_sql_stmnt_for_drilldown IN VARCHAR2 Optional
345 -- Defualt CSC_CORE_UTILS_PVT.G_MISS_CHAR,
346 -- p_select_clause IN VARCHAR2 Optional
347 -- Defualt CSC_CORE_UTILS_PVT.G_MISS_CHAR,
348 -- p_from_clause IN VARCHAR2 Optional
349 -- Defualt CSC_CORE_UTILS_PVT.G_MISS_CHAR,
350 -- p_where_clause IN VARCHAR2 Optional
351 -- Defualt CSC_CORE_UTILS_PVT.G_MISS_CHAR,
352 -- p_other_clause IN VARCHAR2 Optional
353 -- Defualt CSC_CORE_UTILS_PVT.G_MISS_CHAR,
354 -- Customer Profile Variable OUT parameters:
355 -- p_APPLICATION_ID IN NUMBER Optional
356 -- Default = CSC_CORE_UTILS_PVT.G_MISS_NUM
357 --
358 -- -----------------------------------------------------------------
359 -- End of comments
360
361 PROCEDURE Update_Profile_Variable(
362 p_api_version_number IN NUMBER,
363 p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
364 p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
365 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
366 x_return_status OUT NOCOPY VARCHAR2,
367 x_msg_count OUT NOCOPY NUMBER,
368 x_msg_data OUT NOCOPY VARCHAR2,
369 p_block_id IN NUMBER ,
370 p_block_name IN VARCHAR2 DEFAULT NULL,
371 p_block_name_code IN VARCHAR2 DEFAULT NULL,
372 p_description IN VARCHAR2 DEFAULT NULL,
373 p_currency_code IN VARCHAR2 DEFAULT NULL,
374 p_sql_stmnt IN VARCHAR2 DEFAULT NULL,
375 p_batch_sql_stmnt IN VARCHAR2 DEFAULT NULL,
376 p_seeded_flag IN VARCHAR2 DEFAULT NULL,
377 --p_form_function_id IN NUMBER ,
378 p_object_code IN VARCHAR2 DEFAULT NULL ,
379 p_start_date_active IN DATE DEFAULT NULL,
380 p_end_date_active IN DATE DEFAULT NULL ,
381 p_sql_stmnt_for_drilldown IN VARCHAR2 DEFAULT NULL ,
382 p_select_clause IN VARCHAR2 DEFAULT NULL ,
383 p_from_clause IN VARCHAR2 DEFAULT NULL,
384 p_where_clause IN VARCHAR2 DEFAULT NULL,
385 p_order_by_clause IN VARCHAR2 DEFAULT NULL ,
386 p_other_clause IN VARCHAR2 DEFAULT NULL,
387 p_block_level IN VARCHAR2 DEFAULT NULL,
388 p_CREATED_BY IN NUMBER DEFAULT NULL,
389 p_CREATION_DATE IN DATE DEFAULT NULL ,
390 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
391 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
392 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
393 px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER ,
394 p_APPLICATION_ID IN NUMBER DEFAULT NULL);
395
396 -- ------------------------------------------------------------------
397 -- API name: Update_Profile_Variable
398 -- Version : Initial version 1.0
399 -- Type: Private
400 -- Function: Updates a profile variable in the table CSC_PROF_BLOCKS_B
401 -- Pre-reqs: None.
402
403 -- Parameters:
404
405 -- Standard IN Parameters:
406
407 -- p_api_version IN NUMBER Required
408 -- p_init_msg_list IN VARCHAR2 Optional
409 -- Default = CSC_CORE_UTILS_PVT.G_FALSE
410 -- p_commit IN VARCHAR2 Optional
411 -- Default = CSC_CORE_UTILS_PVT.G_FALSE
412
413 -- Standard OUT Parameters:
414
415 -- x_return_status OUT VARCHAR2(1)
416 -- x_msg_count OUT NUMBER
417 -- x_msg_data OUT VARCHAR2(2000)
418
419 -- Customer Profile Variable IN Parameters:
420 -- p_prof_var_rec IN ProfVar_Rec_Type
421 -- Customer Profile Variable OUT parameters:
422
423 --
424 -- -----------------------------------------------------------------
425 -- End of comments
426
427
428 PROCEDURE Update_Profile_Variable(
429 p_api_version_number IN NUMBER,
430 p_init_msg_list IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
431 p_commit IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
432 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
433 p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
434 px_Object_Version_Number IN OUT NOCOPY NUMBER,
435 x_msg_data OUT NOCOPY VARCHAR2,
436 x_msg_count OUT NOCOPY VARCHAR2,
437 x_return_status OUT NOCOPY VARCHAR2
438 );
439 -- *******************************************************
440 -- Start of Comments
441 -- *******************************************************
442 -- API Name: Update_table_column
443 -- Type : Private
444 -- Pre-Req :
445 -- Parameters:
446 -- IN
447 -- p_api_version_number IN NUMBER Required
448 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
449 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
450 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
451 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
452 -- P_TabCol_Rec IN TabCol_Rec_Type Required
453 --
454 -- OUT:
455 -- x_return_status OUT VARCHAR2
456 -- x_msg_count OUT NUMBER
457 -- x_msg_data OUT VARCHAR2
458
459 --
460 -- End of Comments
461
462 PROCEDURE Update_table_column(
463 P_Api_Version_Number IN NUMBER,
464 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
465 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
466 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
467 p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_TABLE_COLUMN_REC,
468 --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
469 --p_BLOCK_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
470 px_Object_Version_Number IN OUT NOCOPY NUMBER,
471 X_Return_Status OUT NOCOPY VARCHAR2,
472 X_Msg_Count OUT NOCOPY NUMBER,
473 X_Msg_Data OUT NOCOPY VARCHAR2
474 );
475
476
477
478 PROCEDURE Delete_profile_variables(
479 P_Api_Version_Number IN NUMBER,
480 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
481 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
482 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
483 p_BLOCK_ID IN NUMBER,
484 p_OBJECT_VERSION_NUMBER IN NUMBER,
485 X_Return_Status OUT NOCOPY VARCHAR2,
486 X_Msg_Count OUT NOCOPY NUMBER,
487 X_Msg_Data OUT NOCOPY VARCHAR2
488 );
489
490
491 PROCEDURE Delete_Table_Columns(
492 P_Api_Version_Number IN NUMBER,
493 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
494 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
495 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
496 p_BLOCK_ID IN NUMBER,
497 px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
498 X_Return_Status OUT NOCOPY VARCHAR2,
499 X_Msg_Count OUT NOCOPY NUMBER,
500 X_Msg_Data OUT NOCOPY VARCHAR2
501 );
502
503
504 --------------------------------------------------------------------------
505 -- Procedure Build_Sql_Stmnt
506 -- Description: Concatenates the select_Clause, from_clause, where_clause
507 -- and Other_clause to build an sql statement which will be stored in
508 -- the sql_statement column in cs_prof_blocks table.
509 -- Input Parameters
510 -- p_api_name, standard parameter for writting messages
511 -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
512 -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
513 -- p_sql_statement, concatented field using select_Clause, from_clause
514 -- where_clause and Other_Clause columns using the Build_Sql_Stmnt
515 -- procedure
516 -- Out Parameters
517 -- x_return_status, standard parameter for the return status
518 --------------------------------------------------------------------------
519
520 PROCEDURE Build_Sql_Stmnt
521 ( p_api_name IN VARCHAR2,
522 p_select_clause IN VARCHAR2,
523 p_from_clause IN VARCHAR2,
524 p_where_clause IN VARCHAR2,
525 p_other_clause IN VARCHAR2,
526 x_sql_Stmnt OUT NOCOPY VARCHAR2,
527 x_return_status OUT NOCOPY VARCHAR2 );
528
529 PROCEDURE Build_Drilldown_Sql_Stmnt(
530 p_block_id IN NUMBER,
531 P_TABLE_COLUMN_TBL IN Table_Column_Tbl_Type,
532 x_sql_stmnt OUT NOCOPY VARCHAR2 );
533
534 PROCEDURE Build_PLSQL_Table(
535 p_block_id IN NUMBER,
536 x_table_column_tbl OUT NOCOPY Table_Column_Tbl_Type );
537
538
539
540 PROCEDURE Build_Drilldown_Sql_Stmnt(p_block_id NUMBER,
541 x_sql_stmnt OUT NOCOPY VARCHAR2 );
542
543 PROCEDURE Build_Drilldown_Sql_Stmnt(p_block_id NUMBER,
544 x_sql_stmnt OUT NOCOPY VARCHAR2,
545 p_call_from VARCHAR2
546 );
547
548
549 -- ------------------------------------------------------------------
550 -- API name: Validate_Prof_Var_attributes
551 -- Version : Initial version 1.0
552 -- Type: Validates a profile variables for the table CSC_PROF_BLOCKS_B
553 -- Pre-reqs: None.
554
555 -- Parameters:
556
557 -- Standard IN Parameters:
558
559 -- p_api_name IN NUMBER Required
560
561 -- Standard OUT Parameters:
562
563 -- x_return_status OUT VARCHAR2(1)
564
565 -- Customer Profile Variable IN Parameters:
566 -- p_validate_var_rec IN ProfVar_Rec_Type
567
568 -- Customer Profile Variable OUT parameters:
569
570 --
571 -- -----------------------------------------------------------------
572 -- End of comments
573
574 PROCEDURE Validate_Profile_Variables(
575 p_api_name IN VARCHAR2,
576 p_validation_mode IN VARCHAR2,
577 p_validate_rec IN ProfVar_Rec_Type,
578 x_return_status OUT NOCOPY VARCHAR2,
579 x_msg_count OUT NOCOPY NUMBER,
580 x_msg_data OUT NOCOPY VARCHAR2 ) ;
581
582
583
584 -- ------------------------------------------------------------------
585 -- API name: Get_Prof_Var_Rec
586 -- Version : Initial version 1.0
587 -- Type: Gets the Profile variable record type
588 -- Pre-reqs: None.
589 -- Parameters:
590
591 -- Standard IN Parameters:
592
593 -- p_api_name IN NUMBER Required
594
595 -- Standard OUT Parameters:
596
597 -- x_return_status OUT VARCHAR2(1)
598
599 -- Customer Profile Variable IN Parameters:
600 -- p_block_id IN VARCHAR2
601 -- p_validate_var_rec IN ProfVar_Rec_Type
602
603 -- Customer Profile Variable OUT parameters:
604 -- x_prof_var_rec OUT CSC_PROF_BLOCKS_B%ROWTYPE
605
606 --
607 -- -----------------------------------------------------------------
608 -- End of comments
609
610 PROCEDURE GET_PROF_BLOCKS(
611 p_Api_Name IN VARCHAR2,
612 p_BLOCK_ID IN NUMBER,
613 p_Object_Version_Number IN NUMBER,
614 X_PROF_BLOCKS_REC OUT NOCOPY CSC_PROF_BLOCKS_VL%ROWTYPE,
615 X_return_status OUT NOCOPY VARCHAR2
616 );
617
618
619 Procedure GET_TABLE_COLUMN(
620 p_Api_Name in VARCHAR2,
621 p_Table_Column_Id IN NUMBER,
622 p_Object_Version_Number IN NUMBER,
623 X_Table_Column_Rec OUT NOCOPY CSC_PROF_TABLE_COLUMNS_VL%ROWTYPE ,
624 X_Return_status OUT NOCOPY VARCHAR2
625 );
626
627
628 -- Start of Comments
629 --
630 -- validation procedures
631 --
632 -- p_validation_mode is a constant defined in package
633 -- For create: G_CREATE, for update: G_UPDATE
634 -- End of Comments
635 PROCEDURE Validate_table_column(
636 P_Api_Name IN VARCHAR2,
637 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
638 P_Validation_mode IN VARCHAR2,
639 p_validate_rec IN Table_Column_Rec_Type,
640 X_Return_Status OUT NOCOPY VARCHAR2
641 );
642
643 PROCEDURE Validate_block_level
644 ( p_api_name IN VARCHAR2,
645 p_parameter_name IN VARCHAR2,
646 p_block_level IN VARCHAR2,
647 x_return_status OUT NOCOPY VARCHAR2
648 );
649
650 END CSC_Profile_Variable_Pvt;