APPS.FII_AP_INV_B_C dependencies on AP_DBI_LOG

Line 2473: -- When exception occurs, we need to restore the AP_DBI_LOG table

2469:
2470: Truncate_table('FII_AP_SUM_WORK_JOBS');
2471:
2472: ----------------------------------------------------------------
2473: -- When exception occurs, we need to restore the AP_DBI_LOG table
2474: -- to its original state by setting those records back to 'N'.
2475: -- THose records will be re-processed in the next run.
2476: -----------------------------------------------------------------
2477: FII_UTIL.put_line('Restoring AP_DBI_LOG table to its original state');

Line 2477: FII_UTIL.put_line('Restoring AP_DBI_LOG table to its original state');

2473: -- When exception occurs, we need to restore the AP_DBI_LOG table
2474: -- to its original state by setting those records back to 'N'.
2475: -- THose records will be re-processed in the next run.
2476: -----------------------------------------------------------------
2477: FII_UTIL.put_line('Restoring AP_DBI_LOG table to its original state');
2478:
2479: IF p_program_type = 'L' THEN
2480: UPDATE ap_dbi_log log
2481: SET exp_processed_flag = 'N'

Line 2480: UPDATE ap_dbi_log log

2476: -----------------------------------------------------------------
2477: FII_UTIL.put_line('Restoring AP_DBI_LOG table to its original state');
2478:
2479: IF p_program_type = 'L' THEN
2480: UPDATE ap_dbi_log log
2481: SET exp_processed_flag = 'N'
2482: WHERE exp_processed_flag = 'Y';
2483: ELSE
2484: UPDATE ap_dbi_log

Line 2484: UPDATE ap_dbi_log

2480: UPDATE ap_dbi_log log
2481: SET exp_processed_flag = 'N'
2482: WHERE exp_processed_flag = 'Y';
2483: ELSE
2484: UPDATE ap_dbi_log
2485: SET exp_processed_flag = 'N'
2486: WHERE exp_processed_flag = 'S';
2487: END IF;
2488: COMMIT;