eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_PROFILE_VARIABLE_PVT dependencies on CSC_CORE_UTILS_PVT

Line 130: -- Default = CSC_CORE_UTILS_PVT.G_FALSE

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:

Line 132: -- Default = CSC_CORE_UTILS_PVT.G_FALSE

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)

Line 165: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 166: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 167: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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,

Line 216: -- Default = CSC_CORE_UTILS_PVT.G_FALSE

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:

Line 218: -- Default = CSC_CORE_UTILS_PVT.G_FALSE

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)

Line 239: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 240: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 241: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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,

Line 259: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE

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: --

Line 260: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE

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:

Line 261: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL

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

Line 274: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 275: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 276: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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,

Line 278: --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

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,

Line 279: --p_BLOCK_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

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,

Line 290: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 291: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 292: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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,

Line 294: --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

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,

Line 295: --p_BLOCK_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

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,

Line 319: -- Default = CSC_CORE_UTILS_PVT.G_FALSE

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:

Line 321: -- Default = CSC_CORE_UTILS_PVT.G_FALSE

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)

Line 331: -- default CSC_CORE_UTILS_PVT.G_MISS_NUM

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

Line 345: -- Defualt CSC_CORE_UTILS_PVT.G_MISS_CHAR,

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,

Line 347: -- 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,

Line 349: -- 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,

Line 351: -- 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

Line 353: -- Defualt CSC_CORE_UTILS_PVT.G_MISS_CHAR,

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: --

Line 356: -- Default = CSC_CORE_UTILS_PVT.G_MISS_NUM

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:

Line 363: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 364: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 365: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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 ,

Line 409: -- Default = CSC_CORE_UTILS_PVT.G_FALSE

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:

Line 411: -- Default = CSC_CORE_UTILS_PVT.G_FALSE

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)

Line 430: p_init_msg_list IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 431: p_commit IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 432: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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,

Line 449: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE

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: --

Line 450: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL

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:

Line 464: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 465: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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,

Line 466: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

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,

Line 468: --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

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,

Line 469: --p_BLOCK_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

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

Line 511: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE

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

Line 512: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

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

Line 637: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

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: );