[Home] [Help]
PACKAGE: APPS.IBE_LEAD_IMPORT_PVT
Source
1 package IBE_LEAD_IMPORT_PVT AS
2 /* $Header: IBEVLIMS.pls 120.0 2005/05/30 03:24:56 appldev noship $ */
3
4 Type t_genref is REF CURSOR;
5
6 Type G_Leads_Rec is Record
7 (
8 Quote_Header_ID ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID%TYPE,
9 phone_id hz_contact_points.contact_point_id%TYPE,
10 party_id hz_parties.party_id%TYPE,
11 party_name hz_parties.party_name%TYPE,
12 party_type hz_parties.party_type%TYPE,
13 party_site_id hz_party_sites.party_site_id%TYPE,
14 rel_party_id hz_parties.party_id%TYPE,
15 org_contact_id hz_org_contacts.org_contact_ID%TYPE,
16 contact_role_code VARCHAR2(30),
17 notes varchar2(2000),
18 currency_code VARCHAR2(15),
19 order_id NUMBER,
20 order_num oe_order_headers.order_number%TYPE,
21 order_creation_date oe_order_headers.creation_date%TYPE,
22 promo_code ams_source_codes.SOURCE_CODE%TYPE,
23 total_amount NUMBER,
24 lead_description varchar2(2000),
25 SOURCE_PRIMARY_REFERENCE varchar2(240),
26 SOURCE_SECONDARY_REFERENCE varchar2(240),
27 SOURCE_PROMOTION_ID ASO_QUOTE_HEADERS_ALL.marketing_source_code_id%type
28 );
29
30 Type G_Lead_Line_Rec is Record
31 (
32 quote_header_id ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID%TYPE,
33 inventory_item_id ASO_QUOTE_LINES_ALL.INVENTORY_ITEM_ID%TYPE,
34 organization_id ASO_QUOTE_LINES_ALL.INVENTORY_ITEM_ID%TYPE,
35 uom_code ASO_QUOTE_LINES_ALL.UOM_CODE%TYPE,
36 quantity ASO_QUOTE_LINES_ALL.QUANTITY%TYPE,
37 part_no Varchar2(255),
38 product_description Varchar2(2000),
39 line_price ASO_QUOTE_LINES_ALL.LINE_QUOTE_PRICE%TYPE,
40 promotion_id ASO_QUOTE_LINES_ALL.marketing_source_code_id%type
41 );
42
43 Type G_Lead_Line_Tbl is Table of G_Lead_Line_Rec Index By Binary_Integer;
44
45 G_ORDER_LEAD CONSTANT VARCHAR2(10) := 'ORDER';
46 G_QUOTE_LEAD CONSTANT VARCHAR2(10) := 'QUOTE';
47
48 G_COMPLETE_IMPORT CONSTANT VARCHAR2(15) := 'COMPLETE';
49 G_INCREMENTAL_IMPORT CONSTANT VARCHAR2(15) := 'INCREMENTAL';
50
51 procedure write_log
52 (
53 p_status IN NUMBER,
54 p_lead_type IN VARCHAR2,
55 p_begin_date IN DATE,
56 p_end_date IN DATE,
57 p_import_mode IN VARCHAR2,
58 x_log_id OUT NOCOPY NUMBER
59 );
60
61 procedure update_log
62 (
63 p_status IN NUMBER,
64 p_log_id IN NUMBER,
65 p_num_success IN NUMBER,
66 p_num_failed IN NUMBER,
67 p_num_total IN NUMBER,
68 p_elapsed_time IN NUMBER
69 );
70
71 procedure insert_log_details
72 (
73 p_message IN VARCHAR2,
74 p_header_rec IN G_LEADS_REC,
75 p_status_flag IN VARCHAR2,
76 p_purge_flag IN VARCHAR2,
77 p_log_id IN NUMBER
78 );
79
80 procedure parseInput
81 (
82 p_inString IN VARCHAR2,
83 p_Type IN VARCHAR2,
84 p_keyString IN VARCHAR2,
85 p_number IN NUMBER,
86 x_QueryString OUT NOCOPY VARCHAR2
87 );
88
89 procedure get_Quotes_records
90 (
91 p_begin_date IN DATE,
92 p_end_date IN DATE,
93 p_party_number IN VARCHAR2,
94 p_promo_code IN VARCHAR2,
95 p_role_exclusion IN VARCHAR2,
96 x_quote_records OUT NOCOPY t_genref
97 );
98
99 procedure get_Quote_Line_Records
100 (
101 p_quote_header_id IN NUMBER,
102 x_quote_lines OUT NOCOPY t_genref
103 );
104
105 procedure get_Order_Records
106 (
107 p_begin_date IN DATE,
108 p_end_date IN DATE,
109 p_party_number IN VARCHAR2,
110 p_promo_code IN VARCHAR2,
111 p_role_exclusion IN VARCHAR2,
112 x_order_records OUT NOCOPY t_genref
113 );
114
115 procedure get_Order_line_Records
116 (
117 p_order_header_id IN NUMBER,
118 x_Order_lines OUT NOCOPY t_genref
119 );
120
121 procedure get_date_period
122 (
123 p_lead_type IN VARCHAR2,
124 p_begin_date IN DATE,
125 p_end_date IN DATE,
126 x_import_mode OUT NOCOPY VARCHAR2,
127 x_begin_Date OUT NOCOPY DATE,
128 x_end_date OUT NOCOPY DATE
129 );
130
131 procedure create_order_leads
132 (
133 p_retcode OUT NOCOPY NUMBER,
134 p_errmsg OUT NOCOPY VARCHAR2,
135 p_begin_date IN VARCHAR2,
136 p_end_date IN VARCHAR2,
137 p_debug_flag IN VARCHAR2,
138 p_purge_flag IN VARCHAR2,
139 p_write_detail_log IN VARCHAR2,
140 p_party_number IN VARCHAR2,
141 p_promo_code IN VARCHAR2,
142 p_role_exclusion IN VARCHAR2
143 );
144
145 procedure create_quote_leads
146 (
147 p_retcode OUT NOCOPY NUMBER,
148 p_errmsg OUT NOCOPY VARCHAR2,
149 p_begin_date IN VARCHAR2,
150 p_end_date IN VARCHAR2,
151 p_debug_flag IN VARCHAR2,
152 p_purge_flag IN VARCHAR2,
153 p_write_detail_log IN VARCHAR2,
154 p_party_number IN VARCHAR2,
155 p_promo_code IN VARCHAR2,
156 p_role_exclusion IN VARCHAR2
157
158 );
159
160 procedure process_sales_lead_import(
161 p_header_rec IN G_LEADS_REC,
162 p_lines_rec_tbl IN G_LEAD_LINE_TBL,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER
166 );
167
168 procedure create_sales_lead(
169 p_header_rec IN G_LEADS_REC,
170 p_lines_rec_tbl IN G_LEAD_LINE_TBL,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_sales_lead_id OUT NOCOPY NUMBER,
175 x_sales_lead_line_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_TBL_TYPE,
176 x_sales_lead_cnt_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_TBL_TYPE
177 );
178
179 procedure create_LeadAndNotes(
180 p_sales_lead_id IN NUMBER,
181 p_lead_note IN VARCHAR2,
182 p_party_id IN NUMBER,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER
186 );
187
188 procedure rank_sales_lead(
189 p_sales_lead_id IN NUMBER,
190 x_return_Status OUT NOCOPY VARCHAR2,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_rank_id OUT NOCOPY NUMBER,
194 x_score OUT NOCOPY NUMBER
195 );
196
197 /*procedure Assign_Sales_Team(
198 p_sales_lead_id IN NUMBER,
199 x_return_status OUT VARCHAR2,
200 x_msg_data OUT VARCHAR2,
201 x_msg_count OUT NUMBER,
202 x_access_id OUT NUMBER
203 );
204
205
206 procedure create_Sales_Team(
207 p_sales_lead_id IN NUMBER,
208 p_party_id IN NUMBER,
209 p_party_site_id IN NUMBER,
210 x_return_status OUT VARCHAR2,
211 x_msg_data OUT VARCHAR2,
212 x_msg_count OUT NUMBER,
213 x_access_id OUT NUMBER
214 );*/
215
216 procedure create_interest(
217 p_party_id IN NUMBER,
218 p_party_site_id IN NUMBER,
219 p_lines_tbl IN G_LEAD_LINE_TBL,
220 p_contact_id IN NUMBER,
221 p_party_type IN VARCHAR2,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER
225 );
226
227 procedure Build_Sales_Team(
228 p_sales_lead_id IN NUMBER,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER
232 );
233
234 procedure Import_Quote_Lead(
235 p_quote_header_id IN NUMBER,
236 x_return_status OUT NOCOPY VARCHAR2,
237 X_msg_data OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER
239 );
240
241 procedure Import_Order_Lead(
242 p_quote_header_id IN NUMBER,
243 x_return_status OUT NOCOPY VARCHAR2,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER
246 );
247
248 procedure print_Parameter(
249 p_begin_date IN VARCHAR2,
250 p_end_date IN VARCHAR2,
251 p_debug_flag IN VARCHAR2,
252 p_purge_flag IN VARCHAR2,
253 p_write_detail_log IN VARCHAR2);
254
255 procedure printOutput( p_message IN VARCHAR2);
256
257 procedure sendEmail(
258 p_lead_type IN VARCHAR2,
259 p_status IN VARCHAR2,
260 p_log_id IN VARCHAR2,
261 p_num_total IN NUMBER,
262 p_num_failed IN NUMBER,
263 p_num_success IN NUMBER,
264 p_begin_date IN DATE,
265 p_end_date IN DATE,
266 p_elapsed_time IN NUMBER,
267 p_debug_flag IN VARCHAR2,
268 p_purge_flag IN VARCHAR2,
269 x_return_status OUT NOCOPY VARCHAR2,
270 x_msg_count OUT NOCOPY NUMBER,
271 x_msg_data OUT NOCOPY VARCHAR2);
272 end;