PACKAGE: APPS.BIC_CONSOLIDATE_CUST_DATA_PKG

Source

1 package bic_consolidate_cust_data_pkg AUTHID CURRENT_USER as
2 /* $Header: bicflats.pls 115.3 2004/05/13 15:42:48 vsegu ship $ */
3 
4   --
5   -- This procedure calls two procedures populate_party_data and
6   -- populate party_status_data. These two procedures take data from
7   -- bic_customer_summary_all and bic_party_summary which is in row form
8   -- and convert it into column format and insert into bic_party_summ and
9   -- bic_party_status_summ tables respectively.
10   --
11    procedure main_proc(p_start_date date,
12 				  p_end_date   date) ;
13   -- This procedure just delete records from  bic_customer_summary_all
14   -- and bic_party_summary tables
15   procedure purge_summary_data (p_start_date date,
16 				            p_end_date   date) ;
17   procedure purge_party_summary_data ;
18 
19   procedure purge_customer_summary_data ;
20   procedure populate_status_data (p_start_date date,
21 	                 		  p_end_date   date, p_measure_code varchar2 default null);
22   procedure populate_party_data (p_start_date date,
23 				 p_end_date   date);
24   procedure update_market_segment ;
25 end;
26 
27