DBA Data[Home] [Help]

APPS.BIC_LIFECYCLE_EXTRACT_PKG dependencies on BIC_CONSOLIDATE_CUST_DATA_PKG

Line 91: bic_consolidate_cust_data_pkg.purge_party_summary_data;

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

Line 92: bic_consolidate_cust_data_pkg.purge_customer_summary_data;

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 (

Line 174: bic_consolidate_cust_data_pkg.populate_status_data(p_start_date, p_end_date, 'LIFE_CYCLE' );

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;

Line 175: bic_consolidate_cust_data_pkg.purge_party_summary_data;

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;

Line 176: bic_consolidate_cust_data_pkg.purge_customer_summary_data;

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