1 PACKAGE BIM_MARKET_FACTS_PKG AUTHID CURRENT_USER AS
2 /*$Header: bimmktfs.pls 120.1 2005/10/11 05:38:20 sbassi noship $*/
3 FUNCTION ret_max_date(p_sales_lead_id in number) return date;
4
5 PROCEDURE POPULATE
6 (p_api_version_number IN NUMBER
7 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
8 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
9 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
10 ,x_msg_Count OUT NOCOPY NUMBER
11 ,x_msg_Data OUT NOCOPY VARCHAR2
12 ,x_return_status OUT NOCOPY VARCHAR2
13 ,p_start_date IN DATE
14 ,p_end_date IN DATE
15 ,p_para_num IN NUMBER
16 ,p_truncate_flg IN VARCHAR2
17 );
18
19 procedure FIRST_LOAD
20 (p_start_date IN DATE
21 ,p_end_date IN DATE
22 ,p_api_version_number IN NUMBER
23 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
24 ,p_load_type IN VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ,x_return_status OUT NOCOPY VARCHAR2
28 );
29
30 procedure SUB_LOAD
31 (p_start_date IN DATE
32 ,p_end_date IN DATE
33 ,p_api_version_number IN NUMBER
34 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
35 ,p_load_type IN VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 ,x_return_status OUT NOCOPY VARCHAR2
39 );
40
41
42 END BIM_MARKET_FACTS_PKG;