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:
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)
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,
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,
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,
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:
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)
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,
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,
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,
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: --
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:
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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)
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
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,
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,
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,
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
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: --
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:
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,
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,
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 ,
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:
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)
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,
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,
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,
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: --
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:
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,
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,
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,
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,
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
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
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
629: -- For create: G_CREATE, for update: G_UPDATE
630: -- End of Comments
631: PROCEDURE Validate_table_column(
632: P_Api_Name IN VARCHAR2,
633: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
634: P_Validation_mode IN VARCHAR2,
635: p_validate_rec IN Table_Column_Rec_Type,
636: X_Return_Status OUT NOCOPY VARCHAR2
637: );