1 package ast_uwq_wrapper_pkg AUTHID CURRENT_USER AS
2 /* $Header: astugens.pls 120.1 2005/08/10 02:20:25 appldev ship $ */
3
4 FUNCTION Convert_to_server_time(p_client_time IN date) return DATE;
5
6 g_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
7
8 PROCEDURE Create_Contact(
9 p_admin_flag IN VARCHAR2,
10 p_admin_group_id IN NUMBER,
11 p_resource_id IN NUMBER,
12 p_customer_id IN NUMBER,
13 p_lead_id IN NUMBER,
14 p_contact_party_id IN NUMBER,
15 p_address_id IN NUMBER,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_msg_count OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2
19 );
20
21 PROCEDURE create_task (
22 p_task_name IN VARCHAR2,
23 p_task_type_name IN VARCHAR2 DEFAULT NULL,
24 p_task_type_id IN NUMBER DEFAULT NULL,
25 p_description IN VARCHAR2 DEFAULT NULL,
26 p_owner_id IN NUMBER DEFAULT NULL,
27 p_customer_id IN NUMBER DEFAULT NULL,
28 p_contact_id IN NUMBER DEFAULT NULL,
29 p_date_type IN VARCHAR2 DEFAULT NULL,
30 p_start_date IN DATE DEFAULT NULL,
31 p_end_date IN DATE DEFAULT NULL,
32 p_source_object_type_code IN VARCHAR2 DEFAULT NULL,
33 p_source_object_id IN NUMBER DEFAULT NULL,
34 p_source_object_name IN VARCHAR2 DEFAULT NULL,
35 p_phone_id IN NUMBER DEFAULT NULL,
36 p_address_id IN NUMBER DEFAULT NULL,
37 p_duration IN NUMBER DEFAULT NULL,
38 p_duration_uom IN VARCHAR2 DEFAULT NULL,
39 p_called_node IN VARCHAR2,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 x_task_id OUT NOCOPY NUMBER
44 );
45
46 PROCEDURE add_context_to_table (
47 p_counter IN BINARY_INTEGER,
48 p_context_id IN NUMBER,
49 p_context_type IN VARCHAR2,
50 p_last_update_date IN DATE,
51 p_last_updated_by IN NUMBER,
52 p_last_update_login IN NUMBER,
53 p_creation_date IN DATE,
54 p_created_by IN NUMBER
55 );
56
57 PROCEDURE create_note (
58 p_source_object_id IN NUMBER,
59 p_source_object_code IN VARCHAR2,
60 p_notes IN VARCHAR2,
61 p_notes_detail IN VARCHAR2,
62 p_entered_by IN NUMBER,
63 p_entered_date IN DATE,
64 p_last_update_date IN DATE,
65 p_last_updated_by IN NUMBER,
66 p_creation_date IN DATE,
67 p_created_by IN NUMBER,
68 p_last_update_login IN NUMBER,
69 p_party_id IN NUMBER,
70 x_jtf_note_id OUT NOCOPY NUMBER,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2
74 );
75 --New parameter p_total_revenue_forecast_amt added for R12 forecast amount enhancement
76 PROCEDURE header_rec_set (
77 p_last_update_date IN DATE,
78 p_lead_id IN NUMBER,
79 p_lead_number IN VARCHAR2,
80 p_description IN VARCHAR2,
81 p_status_code IN VARCHAR2,
82 p_source_promotion_id IN NUMBER,
83 p_customer_id IN NUMBER,
84 p_address_id IN NUMBER,
85 p_sales_stage_id IN NUMBER,
86 p_win_probability IN NUMBER,
87 p_total_amount IN NUMBER,
88 p_total_revenue_forecast_amt IN NUMBER,
89 p_channel_code IN VARCHAR2,
90 p_decision_date IN DATE,
91 p_currency_code IN VARCHAR2,
92 p_vehicle_response_code IN VARCHAR2,
93 p_customer_budget IN NUMBER,
94 p_close_comment IN VARCHAR2,
95 p_parent_project IN VARCHAR2,
96 p_freeze_flag IN VARCHAR2,
97 header_rec IN OUT NOCOPY AS_OPPORTUNITY_PUB.Header_Rec_type
98 );
99
100 PROCEDURE create_opportunity (
101 p_admin_flag IN VARCHAR2,
102 p_admin_group_id IN NUMBER,
103 p_resource_id IN NUMBER,
104 p_last_update_date IN DATE,
105 p_lead_id IN NUMBER,
106 p_lead_number IN VARCHAR2,
107 p_description IN VARCHAR2,
108 p_status_code IN VARCHAR2,
109 p_source_code IN VARCHAR2, -- Added by Sumita for bug # 3812865
110 p_source_code_id IN NUMBER,
111 p_customer_id IN NUMBER,
112 p_contact_party_id IN NUMBER,
113 p_address_id IN NUMBER,
114 p_sales_stage_id IN NUMBER,
115 p_win_probability IN NUMBER,
116 p_total_amount IN NUMBER,
117 p_total_revenue_forecast_amt IN NUMBER,
118 p_channel_code IN VARCHAR2,
119 p_decision_date IN DATE,
120 p_currency_code IN VARCHAR2,
121 p_vehicle_response_code IN VARCHAR2,
122 p_customer_budget IN NUMBER,
123 p_close_comment IN VARCHAR2,
124 p_parent_project IN VARCHAR2,
125 p_freeze_flag IN VARCHAR2,
126 p_salesgroup_id IN NUMBER,
127 p_called_node IN VARCHAR2,
128 p_action_key IN VARCHAR2, -- Added by Sumita for bug # 3812865
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 x_lead_id OUT NOCOPY NUMBER
133 );
134
135 PROCEDURE create_lead (
136 p_admin_group_id IN NUMBER,
137 p_identity_salesforce_id IN NUMBER,
138 p_status_code IN VARCHAR2,
139 p_customer_id IN NUMBER,
140 p_contact_party_id IN NUMBER,
141 p_address_id IN NUMBER,
142 p_admin_flag IN VARCHAR2,
143 p_assign_to_salesforce_id IN NUMBER,
144 p_assign_sales_group_id IN NUMBER,
145 p_budget_status_code IN VARCHAR2,
146 p_description IN VARCHAR2,
147 p_source_code IN VARCHAR2, -- Added by Sumita for bug # 3812865
148 p_source_code_id IN NUMBER,
149 p_lead_rank_id IN NUMBER,
150 p_decision_timeframe_code IN VARCHAR2,
151 p_initiating_contact_id IN NUMBER,
152 p_phone_id IN NUMBER,
153 p_called_node IN VARCHAR2,
154 p_action_key IN VARCHAR2, -- Added by Sumita for bug # 3812865
155 x_sales_lead_id OUT NOCOPY NUMBER,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2
159 );
160
161 PROCEDURE update_lead (
162 p_sales_lead_id IN NUMBER := FND_API.G_MISS_NUM,
163 p_admin_group_id IN NUMBER := FND_API.G_MISS_NUM,
164 p_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
165 p_last_update_date IN DATE,
166 p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
167 p_customer_id IN NUMBER := FND_API.G_MISS_NUM,
168 p_address_id IN NUMBER := FND_API.G_MISS_NUM,
169 p_assign_to_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
170 p_admin_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
171 p_assign_sales_group_id IN NUMBER := FND_API.G_MISS_NUM,
172 p_budget_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
173 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
174 p_source_promotion_id IN NUMBER := FND_API.G_MISS_NUM,
175 p_lead_rank_id IN NUMBER := FND_API.G_MISS_NUM,
176 p_decision_timeframe_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
177 p_initiating_contact_id IN NUMBER := FND_API.G_MISS_NUM,
178 p_accept_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
179 p_qualified_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
180 p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
181 p_close_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
182 p_called_node IN VARCHAR2 := FND_API.G_MISS_CHAR,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2
186 );
187
188 PROCEDURE create_opp_for_lead (
189 p_admin_flag IN VARCHAR2,
190 p_sales_lead_id IN NUMBER,
191 p_resource_id IN NUMBER,
192 p_salesgroup_id IN NUMBER,
193 p_called_node IN VARCHAR2,
194 x_app_launch OUT NOCOPY VARCHAR2,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 x_opportunity_id OUT NOCOPY NUMBER
199 );
200
201 PROCEDURE reassign_lead (
202 p_admin_flag IN VARCHAR2,
203 p_admin_group_id IN NUMBER,
204 p_default_group_id IN NUMBER,
205 p_person_id IN NUMBER,
206 p_resource_id IN NUMBER,
207 p_sales_lead_id IN NUMBER,
208 p_new_salesforce_id IN NUMBER,
209 p_last_update_date IN DATE,
210 p_new_sales_group_id IN NUMBER,
211 p_new_owner_id IN NUMBER, --person_id of new owner
212 p_called_node IN VARCHAR2,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2
216 );
217
218 procedure get_potential_opportunity (
219 p_sales_lead_id IN NUMBER,
220 p_admin_flag IN VARCHAR2,
221 p_admin_group_id IN NUMBER,
222 p_resource_id IN NUMBER,
223 x_query_string OUT NOCOPY varchar2
224 );
225
226 PROCEDURE update_opportunity (
227 p_admin_flag IN VARCHAR2,
228 p_admin_group_id IN NUMBER,
229 p_resource_id IN NUMBER,
230 p_last_update_date IN DATE,
231 p_lead_id IN NUMBER,
232 p_lead_number IN VARCHAR2,
233 p_description IN VARCHAR2,
234 p_status_code IN VARCHAR2,
235 p_close_reason_code IN VARCHAR2,
236 p_source_promotion_id IN NUMBER,
237 p_customer_id IN NUMBER,
238 p_contact_party_id IN NUMBER,
239 p_address_id IN NUMBER,
240 p_sales_stage_id IN NUMBER,
241 p_win_probability IN NUMBER,
242 p_total_amount IN NUMBER,
243 p_total_revenue_forecast_amt IN NUMBER,
244 p_channel_code IN VARCHAR2,
245 p_decision_date IN DATE,
246 p_currency_code IN VARCHAR2,
247 p_vehicle_response_code IN VARCHAR2,
248 p_customer_budget IN NUMBER,
249 p_close_comment IN VARCHAR2,
250 p_parent_project IN VARCHAR2,
251 p_freeze_flag IN VARCHAR2,
252 p_called_node IN VARCHAR2,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 x_lead_id OUT NOCOPY NUMBER
257 );
258 END ast_uwq_wrapper_pkg;