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
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)
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
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)
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
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)
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
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)
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
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,
549: -- Pre-reqs: None.
550:
551: -- Parameters:
552:
553: -- Standard IN Parameters:
554:
555: -- p_api_name IN NUMBER Required
556:
557: -- Standard OUT Parameters:
553: -- Standard IN Parameters:
554:
555: -- p_api_name IN NUMBER Required
556:
557: -- Standard OUT Parameters:
558:
559: -- x_return_status OUT VARCHAR2(1)
560:
561: -- Customer Profile Variable IN Parameters:
583: -- Type: Gets the Profile variable record type
584: -- Pre-reqs: None.
585: -- Parameters:
586:
587: -- Standard IN Parameters:
588:
589: -- p_api_name IN NUMBER Required
590:
591: -- Standard OUT Parameters:
587: -- Standard IN Parameters:
588:
589: -- p_api_name IN NUMBER Required
590:
591: -- Standard OUT Parameters:
592:
593: -- x_return_status OUT VARCHAR2(1)
594:
595: -- Customer Profile Variable IN Parameters: