APPS.BIC_LIFECYCLE_EXTRACT_PKG dependencies on BIC_LC_SETUP_ALL

Line 185: 'No records in BIC_LC_SETUP_ALL');

181: WHEN NO_LC_SETUP_DATA THEN
182: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
183: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
184: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,
185: 'No records in BIC_LC_SETUP_ALL');
186: ROLLBACK;
187: WHEN NO_LC_PROFILE_DATA THEN
188: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
189: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

Line 602: FROM bic_lc_setup_all

598: --bic_core_pkg.rp_report_id := 'BICCSUMM'; 4911126
599:
600: SELECT measure_value1, measure_value2, measure_value1_op, measure_value2_op
601: INTO g_growing_vlu1, g_growing_vlu2, g_op_growing1, g_op_growing2
602: FROM bic_lc_setup_all
603: WHERE stage_code = 'GROWING';
604:
605:
606:

Line 609: FROM bic_lc_setup_all

605:
606:
607: SELECT measure_value1, measure_value2, measure_value1_op, measure_value2_op
608: INTO g_defected_vlu1, g_defected_vlu2, g_op_defected1, g_op_defected2
609: FROM bic_lc_setup_all
610: WHERE stage_code = 'DEFECTED';
611:
612:
613:

Line 622: FROM bic_lc_setup_all

618: dbms_output.put_line('g_op_defected2 :- ' || g_op_defected2) ;
619: */
620: SELECT measure_value1, measure_value2, measure_value1_op, measure_value2_op
621: INTO g_declining_vlu1, g_declining_vlu2, g_op_declining1, g_op_declining2
622: FROM bic_lc_setup_all
623: WHERE stage_code = 'DECLINING';
624:
625:
626: