APPS.HR_LONG2LOB dependencies on AD_LONG_COLUMN_CONVERSIONS

Line 159: || ' FROM ad_long_column_conversions '

155: l_str :=
156: ' SELECT schema_name, table_name, old_column_name,'
157: || ' new_column_name, new_data_type, status, '
158: || ' action, ROWID '
159: || ' FROM ad_long_column_conversions '
160: || ' WHERE status = '''
161: || ad_longtolob_pkg.g_initialized_status
162: || ''''
163: || ' AND upper(table_name) = upper('''

Line 224: || ' FROM ad_long_column_conversions '

220: l_str :=
221: ' SELECT schema_name, table_name, old_column_name,'
222: || ' new_column_name, new_data_type, status, '
223: || ' action, ROWID '
224: || ' FROM ad_long_column_conversions '
225: || ' WHERE status = '''
226: || ad_longtolob_pkg.g_add_new_column_status
227: || ''''
228: || ' and upper(table_name) = upper('''

Line 289: || ' FROM ad_long_column_conversions '

285: l_str :=
286: ' SELECT schema_name, table_name, old_column_name,'
287: || ' old_data_type, new_column_name, new_data_type, status, '
288: || ' action, ROWID '
289: || ' FROM ad_long_column_conversions '
290: || ' WHERE status IN ('''
291: || ad_longtolob_pkg.g_add_trigger_status
292: || ''','''|| ad_longtolob_pkg.g_add_new_column_status || ''''
293: || ') AND upper(table_name) = upper('''

Line 341: FROM ad_long_column_conversions

337: DECLARE
338: CURSOR c1 (cur_p_table_name VARCHAR2, cur_old_column_name VARCHAR2)
339: IS
340: SELECT schema_name, table_name, old_column_name, new_column_name
341: FROM ad_long_column_conversions
342: WHERE status IN
343: (ad_longtolob_pkg.g_update_rows_status,
344: ad_longtolob_pkg.g_drop_old_column_status
345: )

Line 395: UPDATE ad_long_column_conversions

391: RAISE_APPLICATION_ERROR (-20001,'Exception in renaming the column.');
392: END;
393: END IF;
394:
395: UPDATE ad_long_column_conversions
396: SET status = ad_longtolob_pkg.g_col_renamed_status
397: WHERE schema_name = rec.schema_name
398: AND table_name = rec.table_name
399: AND old_column_name = rec.old_column_name;

Line 411: FROM ad_long_column_conversions

407: DECLARE
408: CURSOR c1 (cur_table_name VARCHAR2, cur_old_column_name VARCHAR2)
409: IS
410: SELECT schema_name, table_name, old_column_name
411: FROM ad_long_column_conversions
412: WHERE status IN (ad_longtolob_pkg.g_col_renamed_status)
413: AND table_name = cur_table_name
414: AND old_column_name = cur_old_column_name;
415:

Line 432: UPDATE ad_long_column_conversions

428: || '_$R2U2';
429:
430: EXECUTE IMMEDIATE l_command;
431:
432: UPDATE ad_long_column_conversions
433: SET status = ad_longtolob_pkg.g_drop_trigger_status
434: WHERE schema_name = rec.schema_name
435: AND table_name = rec.table_name
436: AND old_column_name = rec.old_column_name;

Line 448: FROM ad_long_column_conversions

444: DECLARE
445: CURSOR c1 (cur_table_name VARCHAR2, cur_old_column_name VARCHAR2)
446: IS
447: SELECT schema_name, table_name, old_column_name
448: FROM ad_long_column_conversions
449: WHERE status IN (ad_longtolob_pkg.g_drop_trigger_status,ad_longtolob_pkg.g_col_renamed_status)
450: AND table_name = cur_table_name
451: AND old_column_name = cur_old_column_name;
452:

Line 469: UPDATE ad_long_column_conversions

465: || '_old';
466:
467: EXECUTE IMMEDIATE l_command;
468:
469: UPDATE ad_long_column_conversions
470: SET status = ad_longtolob_pkg.g_complete_status
471: WHERE schema_name = rec.schema_name
472: AND table_name = rec.table_name
473: AND old_column_name = rec.old_column_name;

Line 485: FROM ad_long_column_conversions

481: DECLARE
482: CURSOR c1 (cur_table_name VARCHAR2, cur_old_column_name VARCHAR2)
483: IS
484: SELECT schema_name, table_name, old_column_name
485: FROM ad_long_column_conversions
486: WHERE status IN (
487: ad_longtolob_pkg.g_drop_trigger_status,ad_longtolob_pkg.g_col_renamed_status)
488: AND table_name = cur_table_name
489: AND old_column_name = cur_old_column_name;

Line 507: UPDATE ad_long_column_conversions

503: || '_old';
504:
505: EXECUTE IMMEDIATE l_command;
506:
507: UPDATE ad_long_column_conversions
508: SET status = ad_longtolob_pkg.g_complete_status
509: WHERE schema_name = rec.schema_name
510: AND table_name = rec.table_name
511: AND old_column_name = rec.old_column_name;