DBA Data[Home] [Help]

APPS.FV_GTAS_GL_PKG dependencies on FV_GTAS_RUN

Line 2758: UPDATE fv_gtas_run

2754:
2755: log(l_module_name,'Inserted in fv_gtas_processed_je_hdrs: '||SQL%ROWCOUNT);
2756: log(l_module_name,'Updating GTAS run ' );
2757:
2758: UPDATE fv_gtas_run
2759: SET process_date = SYSDATE,
2760: jc_run_month = gbl_period_num_high,
2761: run_fed_flag = 'J'
2762: WHERE set_of_books_id = gbl_sob_id

Line 2853: log(l_module_name, 'Updatin fv_gtas_run');

2849: EXCEPTION WHEN NO_DATA_FOUND THEN
2850: log(l_module_name, 'No rows found to dete from fv_gtas_processed_je_hdrs.');
2851: END;
2852:
2853: log(l_module_name, 'Updatin fv_gtas_run');
2854: UPDATE fv_gtas_run
2855: SET process_date = NULL,
2856: jc_run_month = NULL,
2857: run_fed_flag = 'A'

Line 2854: UPDATE fv_gtas_run

2850: log(l_module_name, 'No rows found to dete from fv_gtas_processed_je_hdrs.');
2851: END;
2852:
2853: log(l_module_name, 'Updatin fv_gtas_run');
2854: UPDATE fv_gtas_run
2855: SET process_date = NULL,
2856: jc_run_month = NULL,
2857: run_fed_flag = 'A'
2858: WHERE set_of_books_id = gbl_sob_id