APPS.HR_LONG2LOB dependencies on AD_LONG_COLUMN_CONVERSIONS

Line 160: || ' FROM ad_long_column_conversions '

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

Line 225: || ' FROM ad_long_column_conversions '

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

Line 290: || ' FROM ad_long_column_conversions '

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

Line 342: FROM ad_long_column_conversions

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

Line 402: UPDATE ad_long_column_conversions

398: RAISE_APPLICATION_ERROR (-20001,'Exception in renaming the new column.');
399: END;
400: END IF;
401:
402: UPDATE ad_long_column_conversions
403: SET status = ad_longtolob_pkg.g_col_renamed_status
404: WHERE schema_name = rec.schema_name
405: AND table_name = rec.table_name
406: AND old_column_name = rec.old_column_name;

Line 419: FROM ad_long_column_conversions

415: DECLARE
416: CURSOR c1 (cur_table_name VARCHAR2, cur_old_column_name VARCHAR2)
417: IS
418: SELECT schema_name, table_name, old_column_name
419: FROM ad_long_column_conversions
420: WHERE status IN (ad_longtolob_pkg.g_col_renamed_status)
421: AND table_name = cur_table_name
422: AND old_column_name = cur_old_column_name;
423:

Line 452: UPDATE ad_long_column_conversions

448: THEN
449: RAISE_APPLICATION_ERROR (-20001,'Exception in dropping the 2nd trigger.');
450: END;
451:
452: UPDATE ad_long_column_conversions
453: SET status = ad_longtolob_pkg.g_drop_trigger_status
454: WHERE schema_name = rec.schema_name
455: AND table_name = rec.table_name
456: AND old_column_name = rec.old_column_name;

Line 469: FROM ad_long_column_conversions

465: DECLARE
466: CURSOR c1 (cur_table_name VARCHAR2, cur_old_column_name VARCHAR2)
467: IS
468: SELECT schema_name, table_name, old_column_name
469: FROM ad_long_column_conversions
470: WHERE status IN (ad_longtolob_pkg.g_drop_trigger_status,ad_longtolob_pkg.g_col_renamed_status)
471: AND table_name = cur_table_name
472: AND old_column_name = cur_old_column_name;
473:

Line 496: UPDATE ad_long_column_conversions

492: THEN
493: RAISE_APPLICATION_ERROR (-20001,'Exception in marking the columns as unused.');
494: END;
495:
496: UPDATE ad_long_column_conversions
497: SET status = ad_longtolob_pkg.g_complete_status
498: WHERE schema_name = rec.schema_name
499: AND table_name = rec.table_name
500: AND old_column_name = rec.old_column_name;

Line 513: FROM ad_long_column_conversions

509: DECLARE
510: CURSOR c1 (cur_table_name VARCHAR2, cur_old_column_name VARCHAR2)
511: IS
512: SELECT schema_name, table_name, old_column_name
513: FROM ad_long_column_conversions
514: WHERE status IN (
515: ad_longtolob_pkg.g_drop_trigger_status,ad_longtolob_pkg.g_col_renamed_status)
516: AND table_name = cur_table_name
517: AND old_column_name = cur_old_column_name;

Line 541: UPDATE ad_long_column_conversions

537: THEN
538: RAISE_APPLICATION_ERROR (-20001,'Exception in dropping the old column.');
539: END;
540:
541: UPDATE ad_long_column_conversions
542: SET status = ad_longtolob_pkg.g_complete_status
543: WHERE schema_name = rec.schema_name
544: AND table_name = rec.table_name
545: AND old_column_name = rec.old_column_name;