1 PACKAGE BIM_CMP_PKG AUTHID CURRENT_USER AS
2 /*$Header: bimcmpgs.pls 115.10 2001/01/23 14:40:27 pkm ship $*/
3 PROCEDURE BIM_CMP_COST_PLEAD_POPULATE
4 (
5 p_start_date in date DEFAULT NULL,
6 p_end_date in date DEFAULT NULL,
7 p_campaign_id in number DEFAULT NULL,
8 p_drill_down in varchar2 DEFAULT NULL,
9 p_campaign_status_id in number DEFAULT NULL,
10 p_campaign_type_id in varchar2 DEFAULT NULL,
11 p_media_id in number DEFAULT NULL,
12 p_channel_id in varchar2 DEFAULT NULL,
13 p_period_type in varchar2 DEFAULT NULL,
14 p_view_by in varchar2 DEFAULT NULL
15 ) ;
16
17 PROCEDURE BIM_CMP_COST_POPULATE
18 (
19 p_start_date in date DEFAULT NULL,
20 p_end_date in date DEFAULT NULL,
21 p_campaign_id in number DEFAULT NULL,
22 p_drill_down in varchar2 DEFAULT 'Y',
23 p_campaign_status_id in number DEFAULT NULL,
24 p_campaign_type_id in varchar2 DEFAULT NULL,
25 p_media_id in number DEFAULT NULL,
26 p_channel_id in varchar2 DEFAULT NULL,
27 p_view_by in varchar2 DEFAULT NULL
28 ) ;
29
30 PROCEDURE BIM_CMP_COST_SUM_POPULATE
31 (
32 p_all_value in varchar2 DEFAULT NULL,
33 p_campaign_status_id in number DEFAULT NULL,
34 p_campaign_type_id in varchar2 DEFAULT NULL,
35 p_media_id in number DEFAULT NULL,
36 p_channel_id in varchar2 DEFAULT NULL,
37 p_view_by in varchar2 DEFAULT NULL
38 ) ;
39
40 PROCEDURE BIM_CMP_PERF_POPULATE
41 (
42 p_start_date in date DEFAULT NULL,
43 p_end_date in date DEFAULT NULL,
44 p_campaign_id in number DEFAULT NULL,
45 p_campaign_type_id in varchar2 DEFAULT NULL,
46 p_campaign_status_id in number DEFAULT NULL,
47 p_media_id in number DEFAULT NULL,
48 p_channel_id in varchar2 DEFAULT NULL,
49 p_drill_down in varchar2 DEFAULT 'Y',
50 p_sales_channel_code in varchar2 DEFAULT NULL,
51 p_market_segment_id in number DEFAULT NULL,
52 p_interest_type_id in number DEFAULT NULL,
53 p_primary_interest_code_id in number DEFAULT NULL,
54 p_secondary_interest_code_id in number DEFAULT NULL,
55 p_geography_code in varchar2 DEFAULT NULL,
56 p_period_type in varchar2 DEFAULT NULL,
57 p_view_by in varchar2 DEFAULT NULL
58 ) ;
59
60 PROCEDURE BIM_CMP_PERF_SUM_POPULATE
61 (
62 p_period_type in varchar2 DEFAULT NULL,
63 p_all_value in varchar2 DEFAULT 'ALL',
64 p_start_date in date DEFAULT NULL,
65 p_end_date in date DEFAULT NULL,
66 p_campaign_type_id in varchar2 DEFAULT NULL,
67 p_campaign_status_id in number DEFAULT NULL,
68 p_media_id in number DEFAULT NULL,
69 p_channel_id in varchar2 DEFAULT NULL,
70 p_sales_channel_code in varchar2 DEFAULT NULL,
71 p_market_segment_id in number DEFAULT NULL,
72 p_interest_type_id in number DEFAULT NULL,
73 p_primary_interest_code_id in number DEFAULT NULL,
74 p_secondary_interest_code_id in number DEFAULT NULL,
75 p_geography_code in varchar2 DEFAULT NULL,
76 p_view_by in varchar2 DEFAULT NULL
77 ) ;
78
79 PROCEDURE BIM_CMP_RESP_POPULATE
80
81 (
82 p_start_date in date default null,
83 p_end_date in date default null,
84 p_drill_down in varchar2 default null,
85 p_media_id in number default null,
86 p_channel_id in varchar2 default null,
87 p_market_segment_id in number default null,
88 p_geography_code in varchar2 default null,
89 p_campaign_id in number default null,
90 p_campaign_status_id in number default null,
91 p_campaign_type_id in varchar2 default null,
92 p_period_type in varchar2 default null,
93 p_view_by in varchar2 default null
94 ) ;
95
96 PROCEDURE BIM_CMP_REV_POPULATE
97 (
98 p_campaign_id in number DEFAULT NULL,
99 p_drill_down in varchar2 DEFAULT 'Y'
100 ) ;
101
102 PROCEDURE BIM_CMP_REV_SUM_POPULATE
103 (
104 p_all_value in varchar DEFAULT 'ALL',
105 p_campaign_type_id in varchar2 DEFAULT NULL,
106 p_campaign_status_id in number DEFAULT NULL
107 ) ;
108
109 END BIM_CMP_PKG;