APPS.FV_FACTS_GL_PKG_EXT dependencies on FV_FACTS1_LINE_BALANCES

Line 572: UPDATE fv_facts1_line_balances ffpb

568: FROM fv_facts1_run
569: WHERE fiscal_year = l_period_year)
570: LOOP
571:
572: UPDATE fv_facts1_line_balances ffpb
573: SET ffpb.party_classification = l_vendor_type,
574: ffpb.eliminations_dept =
575: DECODE (l_vendor_type, 'FEDERAL', SUBSTR(NVL(l_elimination_id, '00'), 1, 6), ' '),
576: g_ng_indicator = DECODE(l_vendor_type, 'FEDERAL', 'F', 'N')

Line 589: 'Updated fv_facts1_line_balances');

585:
586:
587: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,
589: 'Updated fv_facts1_line_balances');
590: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_rows||' rows updated.');
591: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'for set of books id: '|| sob_rec.set_of_books_id);
592: END IF;
593:

Line 601: l_location := l_module_name||'update_fv_facts1_line_balances';

597: EXCEPTION
598: WHEN OTHERS THEN
599: p_retcode := g_FAILURE;
600: p_errbuf := SQLERRM;
601: l_location := l_module_name||'update_fv_facts1_line_balances';
602: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
603: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
604: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
605: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

Line 617: fv_utility.log_mesg(fnd_log.level_statement, l_module_name, 'UPDATED '||l_tot_rows||' ROWS IN FV_FACTS1_LINE_BALANCES.');

613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
614: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
615: END IF;
616:
617: fv_utility.log_mesg(fnd_log.level_statement, l_module_name, 'UPDATED '||l_tot_rows||' ROWS IN FV_FACTS1_LINE_BALANCES.');
618:
619: l_tot_rows := 0;
620:
621: