[Home] [Help]
PACKAGE: APPS.BIM_ACQ_PKG
Source
1 PACKAGE BIM_ACQ_PKG AUTHID CURRENT_USER AS
2 /*$Header: bimacqus.pls 115.6 2001/04/10 18:19:54 pkm ship $*/
3 PROCEDURE BIM_CMP_ACQ_POPULATE
4 (
5 p_campaign_id number DEFAULT NULL,
6 p_campaign_type_id varchar2 DEFAULT NULL,
7 p_campaign_status_id number DEFAULT NULL,
8 p_period_type varchar2 DEFAULT NULL,
9 p_start_date date DEFAULT NULL,
10 p_end_date date DEFAULT NULL,
11 p_media_id number DEFAULT NULL,
12 p_channel_id varchar2 DEFAULT NULL,
13 p_market_segment_id number DEFAULT NULL,
14 p_sales_channel_code varchar2 DEFAULT NULL,
15 p_interest_type_id number DEFAULT NULL,
16 p_primary_interest_code_id number DEFAULT NULL,
17 p_secondary_interest_code_id number DEFAULT NULL,
18 p_geography_code varchar2 DEFAULT NULL,
19 p_view_by varchar2 DEFAULT NULL,
20 p_drill_down varchar2 DEFAULT 'Y'
21 ) ;
22
23 PROCEDURE BIM_CMP_ACQ_SUM_POPULATE
24 (
25 p_campaign_id number DEFAULT NULL,
26 p_campaign_type_id varchar2 DEFAULT NULL,
27 p_campaign_status_id number DEFAULT NULL,
28 p_period_type varchar2 DEFAULT NULL,
29 p_start_date date DEFAULT NULL,
30 p_end_date date DEFAULT NULL,
31 p_media_id number DEFAULT NULL,
32 p_channel_id varchar2 DEFAULT NULL,
33 p_market_segment_id number DEFAULT NULL,
34 p_sales_channel_code varchar2 DEFAULT NULL,
35 p_interest_type_id number DEFAULT NULL,
36 p_primary_interest_code_id number DEFAULT NULL,
37 p_secondary_interest_code_id number DEFAULT NULL,
38 p_geography_code varchar2 DEFAULT NULL,
39 p_view_by varchar2 DEFAULT NULL,
40 p_drill_down varchar2 DEFAULT 'Y',
41 p_all_value varchar2 DEFAULT 'ALL'
42 ) ;
43
44
45 PROCEDURE BIM_ACT_ACQ_SUM_POPULATE
46 (
47 p_campaign_id number DEFAULT NULL,
48 p_campaign_type_id varchar2 DEFAULT NULL,
49 p_campaign_status_id number DEFAULT NULL,
50 p_period_type varchar2 DEFAULT NULL,
51 p_start_date date DEFAULT NULL,
52 p_end_date date DEFAULT NULL,
53 p_media_id number DEFAULT NULL,
54 p_channel_id varchar2 DEFAULT NULL,
55 p_market_segment_id number DEFAULT NULL,
56 p_sales_channel_code varchar2 DEFAULT NULL,
57 p_interest_type_id number DEFAULT NULL,
58 p_primary_interest_code_id number DEFAULT NULL,
59 p_secondary_interest_code_id number DEFAULT NULL,
60 p_geography_code varchar2 DEFAULT NULL,
61 p_view_by varchar2 DEFAULT NULL,
62 p_drill_down varchar2 DEFAULT 'Y',
63 p_all_value varchar2 DEFAULT 'ALL'
64 ) ;
65
66 PROCEDURE BIM_ACT_ACQ_POPULATE
67 (
68 p_campaign_id number DEFAULT NULL,
69 p_campaign_type_id varchar2 DEFAULT NULL,
70 p_campaign_status_id number DEFAULT NULL,
71 p_period_type varchar2 DEFAULT NULL,
72 p_start_date date DEFAULT NULL,
73 p_end_date date DEFAULT NULL,
74 p_media_id number DEFAULT NULL,
75 p_channel_id varchar2 DEFAULT NULL,
76 p_market_segment_id number DEFAULT NULL,
77 p_sales_channel_code varchar2 DEFAULT NULL,
78 p_interest_type_id number DEFAULT NULL,
79 p_primary_interest_code_id number DEFAULT NULL,
80 p_secondary_interest_code_id number DEFAULT NULL,
81 p_geography_code varchar2 DEFAULT NULL,
82 p_view_by varchar2 DEFAULT NULL,
83 p_drill_down varchar2 DEFAULT 'Y'
84 ) ;
85
86
87 PROCEDURE BIM_MCH_ACQ_SUM_POPULATE
88 (
89 p_campaign_id number DEFAULT NULL,
90 p_campaign_status_id number DEFAULT NULL,
91 p_campaign_type_id varchar2 DEFAULT NULL,
92 p_period_type varchar2 DEFAULT NULL,
93 p_start_date date DEFAULT NULL,
94 p_end_date date DEFAULT NULL,
95 p_media_id number DEFAULT NULL,
96 p_channel_id varchar2 DEFAULT NULL,
97 p_market_segment_id number DEFAULT NULL,
98 p_sales_channel_code varchar2 DEFAULT NULL,
99 p_interest_type_id number DEFAULT NULL,
100 p_primary_interest_code_id number DEFAULT NULL,
101 p_secondary_interest_code_id number DEFAULT NULL,
102 p_geography_code varchar2 DEFAULT NULL,
103 p_view_by varchar2 DEFAULT NULL,
104 p_drill_down varchar2 DEFAULT 'Y',
105 p_all_value varchar2 DEFAULT 'ALL'
106 ) ;
107
108
109 PROCEDURE BIM_MCH_ACQ_POPULATE
110 (
111 p_campaign_id number DEFAULT NULL,
112 p_campaign_status_id number DEFAULT NULL,
113 p_campaign_type_id varchar2 DEFAULT NULL,
114 p_period_type varchar2 DEFAULT NULL,
115 p_start_date date DEFAULT NULL,
116 p_end_date date DEFAULT NULL,
117 p_media_id number DEFAULT NULL,
118 p_channel_id varchar2 DEFAULT NULL,
119 p_market_segment_id number DEFAULT NULL,
120 p_sales_channel_code varchar2 DEFAULT NULL,
121 p_interest_type_id number DEFAULT NULL,
122 p_primary_interest_code_id number DEFAULT NULL,
123 p_secondary_interest_code_id number DEFAULT NULL,
124 p_geography_code varchar2 DEFAULT NULL,
125 p_view_by varchar2 DEFAULT NULL,
126 p_drill_down varchar2 DEFAULT 'Y'
127 ) ;
128
129 END BIM_ACQ_PKG ;