87: BEGIN
88: rec_count := 0;
89: g_lc_st_month := p_start_date;
90: g_lc_end_month := p_end_date ;
91: bic_consolidate_cust_data_pkg.purge_party_summary_data;
92: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
93: Initialize ;
94: bic_summary_extract_pkg.debug(' entered extract_lifecycle_data + : ');
95: IF p_delete_flag = 'N' THEN
88: rec_count := 0;
89: g_lc_st_month := p_start_date;
90: g_lc_end_month := p_end_date ;
91: bic_consolidate_cust_data_pkg.purge_party_summary_data;
92: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
93: Initialize ;
94: bic_summary_extract_pkg.debug(' entered extract_lifecycle_data + : ');
95: IF p_delete_flag = 'N' THEN
96: bic_summary_extract_pkg.extract_periods (
170: write_log('Before Inserting Stable, Defected, Growing and Declining
171: Customers for Life Cycle ....',
172: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
173: Insert_Others(x_c_select) ;
174: bic_consolidate_cust_data_pkg.populate_status_data(p_start_date, p_end_date, 'LIFE_CYCLE' );
175: bic_consolidate_cust_data_pkg.purge_party_summary_data;
176: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
177: bic_summary_extract_pkg.debug(' exited extract_lifecycle_data - : ');
178: -- bic_summary_extract_pkg.g_period_start_date := p_start_date;
171: Customers for Life Cycle ....',
172: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
173: Insert_Others(x_c_select) ;
174: bic_consolidate_cust_data_pkg.populate_status_data(p_start_date, p_end_date, 'LIFE_CYCLE' );
175: bic_consolidate_cust_data_pkg.purge_party_summary_data;
176: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
177: bic_summary_extract_pkg.debug(' exited extract_lifecycle_data - : ');
178: -- bic_summary_extract_pkg.g_period_start_date := p_start_date;
179: COMMIT;
172: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
173: Insert_Others(x_c_select) ;
174: bic_consolidate_cust_data_pkg.populate_status_data(p_start_date, p_end_date, 'LIFE_CYCLE' );
175: bic_consolidate_cust_data_pkg.purge_party_summary_data;
176: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
177: bic_summary_extract_pkg.debug(' exited extract_lifecycle_data - : ');
178: -- bic_summary_extract_pkg.g_period_start_date := p_start_date;
179: COMMIT;
180: EXCEPTION