1 PACKAGE BIM_CAMPAIGN_FACTS AUTHID CURRENT_USER AS
2 /*$Header: bimcmpfs.pls 120.0 2005/05/31 13:15:48 appldev noship $*/
3
4 FUNCTION convert_currency(
5 p_from_currency VARCHAR2
6 ,p_from_amount NUMBER) return NUMBER;
7
8 FUNCTION ret_max_date(
9 p_sales_lead_id in number) return date ;
10
11 PROCEDURE POPULATE
12 (p_api_version_number IN NUMBER
13 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
14 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
15 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
16 ,x_msg_Count OUT NOCOPY NUMBER
17 ,x_msg_Data OUT NOCOPY VARCHAR2
18 ,x_return_status OUT NOCOPY VARCHAR2
19 ,p_object IN VARCHAR2
20 ,p_start_date IN DATE
21 ,p_end_date IN DATE
22 ,p_para_num IN NUMBER
23 );
24
25 PROCEDURE CAMPAIGN_DAILY_LOAD
26 ( p_api_version_number IN NUMBER
27 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
28 ,x_msg_count OUT NOCOPY NUMBER
29 ,x_msg_data OUT NOCOPY VARCHAR2
30 ,x_return_status OUT NOCOPY VARCHAR2
31 ,p_date DATE := SYSDATE
32 );
33
34 procedure CAMPAIGN_FIRST_LOAD
35 (p_start_date IN DATE
36 ,p_end_date IN DATE
37 ,p_api_version_number IN NUMBER
38 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
39 ,p_load_type IN VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2
42 ,x_return_status OUT NOCOPY VARCHAR2
43 );
44
45 procedure CAMPAIGN_SUBSEQUENT_LOAD
46 (p_start_date IN DATE
47 ,p_end_date IN DATE
48 ,p_api_version_number IN NUMBER
49 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
50 ,p_load_type IN VARCHAR2
51 ,x_msg_count OUT NOCOPY NUMBER
52 ,x_msg_data OUT NOCOPY VARCHAR2
53 ,x_return_status OUT NOCOPY VARCHAR2
54 );
55
56
57 END BIM_CAMPAIGN_FACTS;