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.HR_LONG2LOB dependencies on AD_LONGTOLOB_PKG

Line 146: ad_longtolob_pkg.initialize_process

142:
143: -- Steps-1 Intiliazation of AD tables.
144: IF (l_init_process = TRUE) THEN
145: BEGIN
146: ad_longtolob_pkg.initialize_process
147: (p_specific_table => lp_table_name);
148: END;
149: END IF;
150:

Line 161: || ad_longtolob_pkg.g_initialized_status

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('''
164: || lp_table_name
165: || ''')'

Line 182: IF (l_curr_status = ad_longtolob_pkg.g_initialized_status)

178:
179: EXIT WHEN l_cur%NOTFOUND;
180:
181: BEGIN
182: IF (l_curr_status = ad_longtolob_pkg.g_initialized_status)
183: THEN
184: -- overrding the new column datatype
185: IF ( lp_new_column_data_type IS NOT NULL
186: AND lp_new_column_data_type IN

Line 193: ad_longtolob_pkg.add_new_column (l_schema,

189: THEN
190: l_new_data_type := lp_new_column_data_type;
191: END IF;
192:
193: ad_longtolob_pkg.add_new_column (l_schema,
194: l_table_name,
195: l_old_column_name,
196: l_new_column_name,
197: l_new_data_type,

Line 226: || ad_longtolob_pkg.g_add_new_column_status

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('''
229: || lp_table_name
230: || ''')'

Line 247: IF (l_curr_status = ad_longtolob_pkg.g_add_new_column_status

243:
244: EXIT WHEN l_cur%NOTFOUND;
245:
246: BEGIN
247: IF (l_curr_status = ad_longtolob_pkg.g_add_new_column_status
248: )
249: THEN
250: --overrding the new column datatype
251: IF ( lp_new_column_data_type IS NOT NULL

Line 259: ad_longtolob_pkg.create_transform_triggers

255: THEN
256: l_new_data_type := lp_new_column_data_type;
257: END IF;
258:
259: ad_longtolob_pkg.create_transform_triggers
260: (l_schema,
261: l_table_name,
262: l_old_column_name,
263: l_new_column_name,

Line 291: || ad_longtolob_pkg.g_add_trigger_status

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('''
294: || lp_table_name
295: || ''')'

Line 292: || ''','''|| ad_longtolob_pkg.g_add_new_column_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('''
294: || lp_table_name
295: || ''')'
296: || ' AND upper(old_column_name) = upper('''

Line 311: IF (l_curr_status IN (ad_longtolob_pkg.g_add_trigger_status,ad_longtolob_pkg.g_add_new_column_status))

307:
308: EXIT WHEN l_cur%NOTFOUND;
309:
310: BEGIN
311: IF (l_curr_status IN (ad_longtolob_pkg.g_add_trigger_status,ad_longtolob_pkg.g_add_new_column_status))
312: THEN
313: ad_longtolob_pkg.update_new_data (l_schema,
314: l_table_name,
315: l_old_column_name,

Line 313: ad_longtolob_pkg.update_new_data (l_schema,

309:
310: BEGIN
311: IF (l_curr_status IN (ad_longtolob_pkg.g_add_trigger_status,ad_longtolob_pkg.g_add_new_column_status))
312: THEN
313: ad_longtolob_pkg.update_new_data (l_schema,
314: l_table_name,
315: l_old_column_name,
316: l_old_data_type,
317: l_new_column_name

Line 343: (ad_longtolob_pkg.g_update_rows_status,

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: )
346: AND table_name = cur_p_table_name
347: AND old_column_name = cur_old_column_name;

Line 344: ad_longtolob_pkg.g_drop_old_column_status

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: )
346: AND table_name = cur_p_table_name
347: AND old_column_name = cur_old_column_name;
348:

Line 396: SET status = ad_longtolob_pkg.g_col_renamed_status

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;
400: END LOOP;

Line 412: WHERE status IN (ad_longtolob_pkg.g_col_renamed_status)

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:
416: l_command VARCHAR2 (300);

Line 433: SET status = ad_longtolob_pkg.g_drop_trigger_status

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;
437: END LOOP;

Line 449: WHERE status IN (ad_longtolob_pkg.g_drop_trigger_status,ad_longtolob_pkg.g_col_renamed_status)

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:
453: l_column_name VARCHAR2 (30);

Line 470: SET status = ad_longtolob_pkg.g_complete_status

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;
474: END LOOP;

Line 487: ad_longtolob_pkg.g_drop_trigger_status,ad_longtolob_pkg.g_col_renamed_status)

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;
490:
491: l_column_name VARCHAR2 (30);

Line 508: SET status = ad_longtolob_pkg.g_complete_status

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;
512: END LOOP;