[Home] [Help]
PACKAGE: APPS.IBE_QUOTE_W1_PVT
Source
1 PACKAGE IBE_Quote_W1_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVQW1S.pls 120.8 2010/12/13 06:09:56 scnagara ship $ */
3
4 SAVE_NORMAL NUMBER := 0;
5 SAVE_ADDTOCART NUMBER := 1;
6 SAVE_EXPRESSORDER NUMBER := 2;
7
8
9 PROCEDURE MergeActiveQuoteWrapper (
10 p_api_version_number IN NUMBER := 1 ,
11 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
12 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
13 x_return_status OUT NOCOPY VARCHAR2 ,
14 x_msg_count OUT NOCOPY NUMBER ,
15 x_msg_data OUT NOCOPY VARCHAR2 ,
16 p_party_id IN NUMBER ,
17 p_cust_account_id IN NUMBER ,
18 p_quote_header_id IN NUMBER ,
19 p_last_update_date IN VARCHAR2 := FND_API.G_MISS_DATE,
20 p_mode IN VARCHAR2 := 'MERGE' ,
21 p_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,
22 p_quote_source_code IN VARCHAR2 := 'IStore Account' ,
23 p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
24 p_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
25 p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
26 p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
27 p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
28 p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
29 p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
30 p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31 p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
32 x_quote_header_id OUT NOCOPY NUMBER ,
33 x_last_update_date OUT NOCOPY DATE ,
34 x_retrieval_number OUT NOCOPY NUMBER
35 );
36
37 PROCEDURE SaveWrapper(
38 p_api_version_number IN NUMBER := 1 ,
39 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
40 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
41 x_return_status OUT NOCOPY VARCHAR2 ,
42 x_msg_count OUT NOCOPY NUMBER ,
43 x_msg_data OUT NOCOPY VARCHAR2 ,
44 x_quote_header_id OUT NOCOPY NUMBER ,
45 x_last_update_date OUT NOCOPY DATE ,
46 p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE ,
47 p_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,
48 p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
49 p_sharee_party_id IN NUMBER := FND_API.G_MISS_NUM,
50 p_sharee_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
51 p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
52 p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
53 p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
54 p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
55 p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
56 p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57 p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
58 p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
59 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
60 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
61 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
62 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
63 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
64 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
65 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
66 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
67 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
68 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
69 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
70 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
71 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
72 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
73 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
74 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
75 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
76 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
77 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
78 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
79 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
80 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
81 p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
82 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
83 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
84 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
85 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
86 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
87 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
88 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
89 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
90 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
91 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
92 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
93 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
94 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
95 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
96 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
97 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
98 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
99 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
100 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
101 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
102 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
103 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
104 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
105 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
106 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
107 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
108 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
109 -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
110 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
111 -- added attribute 16-20 for bug 6873117 mgiridha
112 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119 p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121 p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
133 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
134 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
135 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
140 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
142 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
143 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
144 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
145 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
146 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
147 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
148 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
149 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
150 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
151 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
152 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
153 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
154 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
155 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
156 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
157 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
158 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
159 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
160 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
161 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
162 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
163 p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
164 p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
165 p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
166 p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
167 p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
168 p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
169 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
170 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
171 p_ql_creation_date IN jtf_date_table := NULL,
172 p_ql_created_by IN jtf_number_table := NULL,
173 p_ql_last_updated_by IN jtf_number_table := NULL,
174 p_ql_last_update_date IN jtf_date_table := NULL,
175 p_ql_last_update_login IN jtf_number_table := NULL,
176 p_ql_request_id IN jtf_number_table := NULL,
177 p_ql_program_application_id IN jtf_number_table := NULL,
178 p_ql_program_id IN jtf_number_table := NULL,
179 p_ql_program_update_date IN jtf_date_table := NULL,
180 p_ql_quote_line_id IN jtf_number_table := NULL,
181 p_ql_quote_header_id IN jtf_number_table := NULL,
182 p_ql_org_id IN jtf_number_table := NULL,
183 p_ql_line_number IN jtf_number_table := NULL,
184 p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
185 p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
186 p_ql_inventory_item_id IN jtf_number_table := NULL,
187 p_ql_organization_id IN jtf_number_table := NULL,
188 p_ql_quantity IN jtf_number_table := NULL,
189 p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
190 p_ql_start_date_active IN jtf_date_table := NULL,
191 p_ql_end_date_active IN jtf_date_table := NULL,
192 p_ql_order_line_type_id IN jtf_number_table := NULL,
193 p_ql_price_list_id IN jtf_number_table := NULL,
194 p_ql_price_list_line_id IN jtf_number_table := NULL,
195 p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
196 p_ql_line_list_price IN jtf_number_table := NULL,
197 p_ql_line_adjusted_amount IN jtf_number_table := NULL,
198 p_ql_line_adjusted_percent IN jtf_number_table := NULL,
199 p_ql_line_quote_price IN jtf_number_table := NULL,
200 p_ql_related_item_id IN jtf_number_table := NULL,
201 p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
202 p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
203 p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
204 p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
205 p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
206 p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
207 p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
208 p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
209 p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
210 p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,
211 p_ql_attribute5 IN jtf_varchar2_table_300 := NULL,
212 p_ql_attribute6 IN jtf_varchar2_table_300 := NULL,
213 p_ql_attribute7 IN jtf_varchar2_table_300 := NULL,
214 p_ql_attribute8 IN jtf_varchar2_table_300 := NULL,
215 p_ql_attribute9 IN jtf_varchar2_table_300 := NULL,
216 p_ql_attribute10 IN jtf_varchar2_table_300 := NULL,
217 p_ql_attribute11 IN jtf_varchar2_table_300 := NULL,
218 p_ql_attribute12 IN jtf_varchar2_table_300 := NULL,
222 p_ql_accounting_rule_id IN jtf_number_table := NULL,
219 p_ql_attribute13 IN jtf_varchar2_table_300 := NULL,
220 p_ql_attribute14 IN jtf_varchar2_table_300 := NULL,
221 p_ql_attribute15 IN jtf_varchar2_table_300 := NULL,
223 p_ql_ffm_content_name IN jtf_varchar2_table_300 := NULL,
224 p_ql_ffm_content_type IN jtf_varchar2_table_300 := NULL,
225 p_ql_ffm_document_type IN jtf_varchar2_table_300 := NULL,
226 p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
227 p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
228 p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
229 p_ql_invoice_to_party_id IN jtf_number_table := NULL,
230 p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
231 p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
232 p_ql_invoicing_rule_id IN jtf_number_table := NULL,
233 p_ql_marketing_source_code_id IN jtf_number_table := NULL,
234 p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
235 p_ql_commitment_id IN jtf_number_table := NULL,
236 p_ql_agreement_id IN jtf_number_table := NULL,
237 p_ql_minisite_id IN jtf_number_table := NULL,
238 p_ql_section_id IN jtf_number_table := NULL,
239 p_ql_line_codes IN jtf_number_table := NULL,
240 p_ql_end_cust_party_id IN jtf_number_table := NULL,
241 p_ql_end_cust_cust_party_id IN jtf_number_table := NULL,
242 p_ql_end_cust_party_site_id IN jtf_number_table := NULL,
243 p_ql_end_cust_cust_account_id IN jtf_number_table := NULL,
244 p_qrl_line_relationship_id IN jtf_number_table := NULL,
245 p_qrl_creation_date IN jtf_date_table := NULL,
246 p_qrl_created_by IN jtf_number_table := NULL,
247 p_qrl_last_updated_by IN jtf_number_table := NULL,
248 p_qrl_last_update_date IN jtf_date_table := NULL,
249 p_qrl_last_update_login IN jtf_number_table := NULL,
250 p_qrl_request_id IN jtf_number_table := NULL,
251 p_qrl_program_application_id IN jtf_number_table := NULL,
252 p_qrl_program_id IN jtf_number_table := NULL,
253 p_qrl_program_update_date IN jtf_date_table := NULL,
254 p_qrl_quote_line_id IN jtf_number_table := NULL,
255 p_qrl_related_quote_line_id IN jtf_number_table := NULL,
256 p_qrl_relationship_type_code IN jtf_varchar2_table_100 := NULL,
257 p_qrl_reciprocal_flag IN jtf_varchar2_table_100 := NULL,
258 p_qrl_qte_line_index IN jtf_number_table := NULL,
259 p_qrl_related_qte_line_index IN jtf_number_table := NULL,
260 p_qrl_operation_code IN JTF_VARCHAR2_TABLE_100 := null,
261 p_qdl_quote_line_detail_id IN jtf_number_table := NULL,
262 p_qdl_creation_date IN jtf_date_table := NULL,
263 p_qdl_created_by IN jtf_number_table := NULL,
264 p_qdl_last_update_date IN jtf_date_table := NULL,
265 p_qdl_last_updated_by IN jtf_number_table := NULL,
266 p_qdl_last_update_login IN jtf_number_table := NULL,
267 p_qdl_request_id IN jtf_number_table := NULL,
268 p_qdl_program_application_id IN jtf_number_table := NULL,
269 p_qdl_program_id IN jtf_number_table := NULL,
270 p_qdl_program_update_date IN jtf_date_table := NULL,
271 p_qdl_quote_line_id IN jtf_number_table := NULL,
272 p_qdl_config_header_id IN jtf_number_table := NULL,
273 p_qdl_config_revision_num IN jtf_number_table := NULL,
274 p_qdl_config_item_id IN jtf_number_table := NULL,
275 p_qdl_complete_configuration IN jtf_varchar2_table_100 := NULL,
276 p_qdl_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
277 p_qdl_component_code IN jtf_varchar2_table_1000 := NULL,
278 p_qdl_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
279 p_qdl_service_duration IN jtf_number_table := NULL,
280 p_qdl_service_period IN jtf_varchar2_table_100 := NULL,
281 p_qdl_service_unit_selling IN jtf_number_table := NULL,
282 p_qdl_service_unit_list IN jtf_number_table := NULL,
283 p_qdl_service_number IN jtf_number_table := NULL,
284 p_qdl_unit_percent_base_price IN jtf_number_table := NULL,
285 p_qdl_attribute_category IN jtf_varchar2_table_100 := NULL,
286 p_qdl_attribute1 IN jtf_varchar2_table_200 := NULL,
287 p_qdl_attribute2 IN jtf_varchar2_table_200 := NULL,
288 p_qdl_attribute3 IN jtf_varchar2_table_200 := NULL,
289 p_qdl_attribute4 IN jtf_varchar2_table_200 := NULL,
290 p_qdl_attribute5 IN jtf_varchar2_table_200 := NULL,
291 p_qdl_attribute6 IN jtf_varchar2_table_200 := NULL,
292 p_qdl_attribute7 IN jtf_varchar2_table_200 := NULL,
293 p_qdl_attribute8 IN jtf_varchar2_table_200 := NULL,
294 p_qdl_attribute9 IN jtf_varchar2_table_200 := NULL,
295 p_qdl_attribute10 IN jtf_varchar2_table_200 := NULL,
296 p_qdl_attribute11 IN jtf_varchar2_table_200 := NULL,
297 p_qdl_attribute12 IN jtf_varchar2_table_200 := NULL,
298 p_qdl_attribute13 IN jtf_varchar2_table_200 := NULL,
299 p_qdl_attribute14 IN jtf_varchar2_table_200 := NULL,
300 p_qdl_attribute15 IN jtf_varchar2_table_200 := NULL,
301 p_qdl_service_ref_type_code IN jtf_varchar2_table_100 := NULL,
305 p_qdl_service_ref_line_id IN jtf_number_table := NULL,
302 p_qdl_service_ref_order_number IN jtf_number_table := NULL,
303 p_qdl_service_ref_line_number IN jtf_number_table := NULL,
304 p_qdl_service_ref_qte_line_ind IN jtf_number_table := NULL,
306 p_qdl_service_ref_system_id IN jtf_number_table := NULL,
307 p_qdl_service_ref_option_numb IN jtf_number_table := NULL,
308 p_qdl_service_ref_shipment IN jtf_number_table := NULL,
309 p_qdl_return_ref_type IN jtf_varchar2_table_100 := NULL,
310 p_qdl_return_ref_header_id IN jtf_number_table := NULL,
311 p_qdl_return_ref_line_id IN jtf_number_table := NULL,
312 p_qdl_return_attribute1 IN jtf_varchar2_table_300 := NULL,
313 p_qdl_return_attribute2 IN jtf_varchar2_table_300 := NULL,
314 p_qdl_return_attribute3 IN jtf_varchar2_table_300 := NULL,
315 p_qdl_return_attribute4 IN jtf_varchar2_table_300 := NULL,
316 p_qdl_return_attribute5 IN jtf_varchar2_table_300 := NULL,
317 p_qdl_return_attribute6 IN jtf_varchar2_table_300 := NULL,
318 p_qdl_return_attribute7 IN jtf_varchar2_table_300 := NULL,
319 p_qdl_return_attribute8 IN jtf_varchar2_table_300 := NULL,
320 p_qdl_return_attribute9 IN jtf_varchar2_table_300 := NULL,
321 p_qdl_return_attribute10 IN jtf_varchar2_table_300 := NULL,
322 p_qdl_return_attribute11 IN jtf_varchar2_table_300 := NULL,
323 p_qdl_return_attribute12 IN jtf_varchar2_table_300 := NULL,
324 p_qdl_return_attribute13 IN jtf_varchar2_table_300 := NULL,
325 p_qdl_return_attribute14 IN jtf_varchar2_table_300 := NULL,
326 p_qdl_return_attribute15 IN jtf_varchar2_table_300 := NULL,
327 p_qdl_operation_code IN jtf_varchar2_table_100 := NULL,
328 p_qdl_qte_line_index IN jtf_number_table := NULL,
329 p_qdl_return_attr_category IN jtf_varchar2_table_100 := NULL,
330 p_qdl_return_reason_code IN jtf_varchar2_table_100 := NULL,
331 p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
332 p_qpa_qte_line_index IN jtf_number_table := NULL,
333 p_qpa_price_attribute_id IN jtf_number_table := NULL,
334 p_qpa_creation_date IN jtf_date_table := NULL,
335 p_qpa_created_by IN jtf_number_table := NULL,
336 p_qpa_last_update_date IN jtf_date_table := NULL,
337 p_qpa_last_updated_by IN jtf_number_table := NULL,
338 p_qpa_last_update_login IN jtf_number_table := NULL,
339 p_qpa_request_id IN jtf_number_table := NULL,
340 p_qpa_program_application_id IN jtf_number_table := NULL,
341 p_qpa_program_id IN jtf_number_table := NULL,
342 p_qpa_program_update_date IN jtf_date_table := NULL,
343 p_qpa_quote_header_id IN jtf_number_table := NULL,
344 p_qpa_quote_line_id IN jtf_number_table := NULL,
345 p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
346 p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
347 p_qpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
348 p_qpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
349 p_qpa_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,
350 p_qpa_pricing_attribute4 IN jtf_varchar2_table_300 := NULL,
351 p_qpa_pricing_attribute5 IN jtf_varchar2_table_300 := NULL,
352 p_qpa_pricing_attribute6 IN jtf_varchar2_table_300 := NULL,
353 p_qpa_pricing_attribute7 IN jtf_varchar2_table_300 := NULL,
354 p_qpa_pricing_attribute8 IN jtf_varchar2_table_300 := NULL,
355 p_qpa_pricing_attribute9 IN jtf_varchar2_table_300 := NULL,
356 p_qpa_pricing_attribute10 IN jtf_varchar2_table_300 := NULL,
357 p_qpa_pricing_attribute11 IN jtf_varchar2_table_300 := NULL,
358 p_qpa_pricing_attribute12 IN jtf_varchar2_table_300 := NULL,
359 p_qpa_pricing_attribute13 IN jtf_varchar2_table_300 := NULL,
360 p_qpa_pricing_attribute14 IN jtf_varchar2_table_300 := NULL,
361 p_qpa_pricing_attribute15 IN jtf_varchar2_table_300 := NULL,
362 p_qpa_pricing_attribute16 IN jtf_varchar2_table_300 := NULL,
363 p_qpa_pricing_attribute17 IN jtf_varchar2_table_300 := NULL,
364 p_qpa_pricing_attribute18 IN jtf_varchar2_table_300 := NULL,
365 p_qpa_pricing_attribute19 IN jtf_varchar2_table_300 := NULL,
366 p_qpa_pricing_attribute20 IN jtf_varchar2_table_300 := NULL,
367 p_qpa_pricing_attribute21 IN jtf_varchar2_table_300 := NULL,
368 p_qpa_pricing_attribute22 IN jtf_varchar2_table_300 := NULL,
369 p_qpa_pricing_attribute23 IN jtf_varchar2_table_300 := NULL,
370 p_qpa_pricing_attribute24 IN jtf_varchar2_table_300 := NULL,
371 p_qpa_pricing_attribute25 IN jtf_varchar2_table_300 := NULL,
372 p_qpa_pricing_attribute26 IN jtf_varchar2_table_300 := NULL,
373 p_qpa_pricing_attribute27 IN jtf_varchar2_table_300 := NULL,
374 p_qpa_pricing_attribute28 IN jtf_varchar2_table_300 := NULL,
375 p_qpa_pricing_attribute29 IN jtf_varchar2_table_300 := NULL,
376 p_qpa_pricing_attribute30 IN jtf_varchar2_table_300 := NULL,
377 p_qpa_pricing_attribute31 IN jtf_varchar2_table_300 := NULL,
378 p_qpa_pricing_attribute32 IN jtf_varchar2_table_300 := NULL,
379 p_qpa_pricing_attribute33 IN jtf_varchar2_table_300 := NULL,
380 p_qpa_pricing_attribute34 IN jtf_varchar2_table_300 := NULL,
381 p_qpa_pricing_attribute35 IN jtf_varchar2_table_300 := NULL,
382 p_qpa_pricing_attribute36 IN jtf_varchar2_table_300 := NULL,
383 p_qpa_pricing_attribute37 IN jtf_varchar2_table_300 := NULL,
384 p_qpa_pricing_attribute38 IN jtf_varchar2_table_300 := NULL,
388 p_qpa_pricing_attribute42 IN jtf_varchar2_table_300 := NULL,
385 p_qpa_pricing_attribute39 IN jtf_varchar2_table_300 := NULL,
386 p_qpa_pricing_attribute40 IN jtf_varchar2_table_300 := NULL,
387 p_qpa_pricing_attribute41 IN jtf_varchar2_table_300 := NULL,
389 p_qpa_pricing_attribute43 IN jtf_varchar2_table_300 := NULL,
390 p_qpa_pricing_attribute44 IN jtf_varchar2_table_300 := NULL,
391 p_qpa_pricing_attribute45 IN jtf_varchar2_table_300 := NULL,
392 p_qpa_pricing_attribute46 IN jtf_varchar2_table_300 := NULL,
393 p_qpa_pricing_attribute47 IN jtf_varchar2_table_300 := NULL,
394 p_qpa_pricing_attribute48 IN jtf_varchar2_table_300 := NULL,
395 p_qpa_pricing_attribute49 IN jtf_varchar2_table_300 := NULL,
396 p_qpa_pricing_attribute50 IN jtf_varchar2_table_300 := NULL,
397 p_qpa_pricing_attribute51 IN jtf_varchar2_table_300 := NULL,
398 p_qpa_pricing_attribute52 IN jtf_varchar2_table_300 := NULL,
399 p_qpa_pricing_attribute53 IN jtf_varchar2_table_300 := NULL,
400 p_qpa_pricing_attribute54 IN jtf_varchar2_table_300 := NULL,
401 p_qpa_pricing_attribute55 IN jtf_varchar2_table_300 := NULL,
402 p_qpa_pricing_attribute56 IN jtf_varchar2_table_300 := NULL,
403 p_qpa_pricing_attribute57 IN jtf_varchar2_table_300 := NULL,
404 p_qpa_pricing_attribute58 IN jtf_varchar2_table_300 := NULL,
405 p_qpa_pricing_attribute59 IN jtf_varchar2_table_300 := NULL,
406 p_qpa_pricing_attribute60 IN jtf_varchar2_table_300 := NULL,
407 p_qpa_pricing_attribute61 IN jtf_varchar2_table_300 := NULL,
408 p_qpa_pricing_attribute62 IN jtf_varchar2_table_300 := NULL,
409 p_qpa_pricing_attribute63 IN jtf_varchar2_table_300 := NULL,
410 p_qpa_pricing_attribute64 IN jtf_varchar2_table_300 := NULL,
411 p_qpa_pricing_attribute65 IN jtf_varchar2_table_300 := NULL,
412 p_qpa_pricing_attribute66 IN jtf_varchar2_table_300 := NULL,
413 p_qpa_pricing_attribute67 IN jtf_varchar2_table_300 := NULL,
414 p_qpa_pricing_attribute68 IN jtf_varchar2_table_300 := NULL,
415 p_qpa_pricing_attribute69 IN jtf_varchar2_table_300 := NULL,
416 p_qpa_pricing_attribute70 IN jtf_varchar2_table_300 := NULL,
417 p_qpa_pricing_attribute71 IN jtf_varchar2_table_300 := NULL,
418 p_qpa_pricing_attribute72 IN jtf_varchar2_table_300 := NULL,
419 p_qpa_pricing_attribute73 IN jtf_varchar2_table_300 := NULL,
420 p_qpa_pricing_attribute74 IN jtf_varchar2_table_300 := NULL,
421 p_qpa_pricing_attribute75 IN jtf_varchar2_table_300 := NULL,
422 p_qpa_pricing_attribute76 IN jtf_varchar2_table_300 := NULL,
423 p_qpa_pricing_attribute77 IN jtf_varchar2_table_300 := NULL,
424 p_qpa_pricing_attribute78 IN jtf_varchar2_table_300 := NULL,
425 p_qpa_pricing_attribute79 IN jtf_varchar2_table_300 := NULL,
426 p_qpa_pricing_attribute80 IN jtf_varchar2_table_300 := NULL,
427 p_qpa_pricing_attribute81 IN jtf_varchar2_table_300 := NULL,
428 p_qpa_pricing_attribute82 IN jtf_varchar2_table_300 := NULL,
429 p_qpa_pricing_attribute83 IN jtf_varchar2_table_300 := NULL,
430 p_qpa_pricing_attribute84 IN jtf_varchar2_table_300 := NULL,
431 p_qpa_pricing_attribute85 IN jtf_varchar2_table_300 := NULL,
432 p_qpa_pricing_attribute86 IN jtf_varchar2_table_300 := NULL,
433 p_qpa_pricing_attribute87 IN jtf_varchar2_table_300 := NULL,
434 p_qpa_pricing_attribute88 IN jtf_varchar2_table_300 := NULL,
435 p_qpa_pricing_attribute89 IN jtf_varchar2_table_300 := NULL,
436 p_qpa_pricing_attribute90 IN jtf_varchar2_table_300 := NULL,
437 p_qpa_pricing_attribute91 IN jtf_varchar2_table_300 := NULL,
438 p_qpa_pricing_attribute92 IN jtf_varchar2_table_300 := NULL,
439 p_qpa_pricing_attribute93 IN jtf_varchar2_table_300 := NULL,
440 p_qpa_pricing_attribute94 IN jtf_varchar2_table_300 := NULL,
441 p_qpa_pricing_attribute95 IN jtf_varchar2_table_300 := NULL,
442 p_qpa_pricing_attribute96 IN jtf_varchar2_table_300 := NULL,
443 p_qpa_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
444 p_qpa_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
445 p_qpa_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
446 p_qpa_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
447 p_qpa_context IN jtf_varchar2_table_100 := NULL,
448 p_qpa_attribute1 IN jtf_varchar2_table_300 := NULL,
449 p_qpa_attribute2 IN jtf_varchar2_table_300 := NULL,
450 p_qpa_attribute3 IN jtf_varchar2_table_300 := NULL,
451 p_qpa_attribute4 IN jtf_varchar2_table_300 := NULL,
452 p_qpa_attribute5 IN jtf_varchar2_table_300 := NULL,
453 p_qpa_attribute6 IN jtf_varchar2_table_300 := NULL,
454 p_qpa_attribute7 IN jtf_varchar2_table_300 := NULL,
455 p_qpa_attribute8 IN jtf_varchar2_table_300 := NULL,
456 p_qpa_attribute9 IN jtf_varchar2_table_300 := NULL,
457 p_qpa_attribute10 IN jtf_varchar2_table_300 := NULL,
458 p_qpa_attribute11 IN jtf_varchar2_table_300 := NULL,
459 p_qpa_attribute12 IN jtf_varchar2_table_300 := NULL,
460 p_qpa_attribute13 IN jtf_varchar2_table_300 := NULL,
461 p_qpa_attribute14 IN jtf_varchar2_table_300 := NULL,
462 p_qpa_attribute15 IN jtf_varchar2_table_300 := NULL,
463 p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
464 p_qp_qte_line_index IN jtf_number_table := NULL,
465 p_qp_payment_id IN jtf_number_table := NULL,
466 p_qp_creation_date IN jtf_date_table := NULL,
467 p_qp_created_by IN jtf_number_table := NULL,
468 p_qp_last_update_date IN jtf_date_table := NULL,
469 p_qp_last_updated_by IN jtf_number_table := NULL,
473 p_qp_program_id IN jtf_number_table := NULL,
470 p_qp_last_update_login IN jtf_number_table := NULL,
471 p_qp_request_id IN jtf_number_table := NULL,
472 p_qp_program_application_id IN jtf_number_table := NULL,
474 p_qp_program_update_date IN jtf_date_table := NULL,
475 p_qp_quote_header_id IN jtf_number_table := NULL,
476 p_qp_quote_line_id IN jtf_number_table := NULL,
477 p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
478 p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
479 p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
480 p_qp_payment_term_id IN jtf_number_table := NULL,
481 p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
482 p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
483 p_qp_credit_card_exp_date IN jtf_date_table := NULL,
484 p_qp_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
485 p_qp_credit_card_approval_date IN jtf_date_table := NULL,
486 p_qp_payment_amount IN jtf_number_table := NULL,
487 p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
488 p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,
489 p_qp_attribute1 IN jtf_varchar2_table_200 := NULL,
490 p_qp_attribute2 IN jtf_varchar2_table_200 := NULL,
491 p_qp_attribute3 IN jtf_varchar2_table_200 := NULL,
492 p_qp_attribute4 IN jtf_varchar2_table_200 := NULL,
493 p_qp_attribute5 IN jtf_varchar2_table_200 := NULL,
494 p_qp_attribute6 IN jtf_varchar2_table_200 := NULL,
495 p_qp_attribute7 IN jtf_varchar2_table_200 := NULL,
496 p_qp_attribute8 IN jtf_varchar2_table_200 := NULL,
497 p_qp_attribute9 IN jtf_varchar2_table_200 := NULL,
498 p_qp_attribute10 IN jtf_varchar2_table_200 := NULL,
499 p_qp_attribute11 IN jtf_varchar2_table_200 := NULL,
500 p_qp_attribute12 IN jtf_varchar2_table_200 := NULL,
501 p_qp_attribute13 IN jtf_varchar2_table_200 := NULL,
502 p_qp_attribute14 IN jtf_varchar2_table_200 := NULL,
503 p_qp_attribute15 IN jtf_varchar2_table_200 := NULL,
504 p_qp_assignment_id IN jtf_number_table := NULL,
505 p_qp_cvv2 IN JTF_VARCHAR2_TABLE_200 := NULL,
506 p_qs_operation_code IN jtf_varchar2_table_100 := NULL,
507 p_qs_qte_line_index IN jtf_number_table := NULL,
508 p_qs_shipment_id IN jtf_number_table := NULL,
509 p_qs_creation_date IN jtf_date_table := NULL,
510 p_qs_created_by IN jtf_number_table := NULL,
511 p_qs_last_update_date IN jtf_date_table := NULL,
512 p_qs_last_updated_by IN jtf_number_table := NULL,
513 p_qs_last_update_login IN jtf_number_table := NULL,
514 p_qs_request_id IN jtf_number_table := NULL,
515 p_qs_program_application_id IN jtf_number_table := NULL,
516 p_qs_program_id IN jtf_number_table := NULL,
517 p_qs_program_update_date IN jtf_date_table := NULL,
518 p_qs_quote_header_id IN jtf_number_table := NULL,
519 p_qs_quote_line_id IN jtf_number_table := NULL,
520 p_qs_promise_date IN jtf_date_table := NULL,
521 p_qs_request_date IN jtf_date_table := NULL,
522 p_qs_schedule_ship_date IN jtf_date_table := NULL,
523 p_qs_ship_to_party_site_id IN jtf_number_table := NULL,
524 p_qs_ship_to_party_id IN jtf_number_table := NULL,
525 p_qs_ship_to_cust_acct_id IN jtf_number_table := NULL,
526 p_qs_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
527 p_qs_ship_set_id IN jtf_number_table := NULL,
528 p_qs_ship_method_code IN jtf_varchar2_table_100 := NULL,
529 p_qs_freight_terms_code IN jtf_varchar2_table_100 := NULL,
530 p_qs_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
531 p_qs_fob_code IN jtf_varchar2_table_100 := NULL,
532 p_qs_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
533 p_qs_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
534 p_qs_packing_instructions IN jtf_varchar2_table_2000 := NULL,
535 p_qs_quantity IN jtf_number_table := NULL,
536 p_qs_reserved_quantity IN jtf_number_table := NULL,
537 p_qs_reservation_id IN jtf_number_table := NULL,
538 p_qs_order_line_id IN jtf_number_table := NULL,
539 p_qs_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
540 p_qs_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
541 p_qs_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
542 p_qs_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
543 p_qs_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
544 p_qs_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
545 p_qs_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
546 p_qs_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
547 p_qs_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
548 p_qs_ship_to_country IN jtf_varchar2_table_100 := NULL,
549 p_qs_ship_to_city IN jtf_varchar2_table_100 := NULL,
550 p_qs_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
551 p_qs_ship_to_state IN jtf_varchar2_table_100 := NULL,
552 p_qs_ship_to_province IN jtf_varchar2_table_100 := NULL,
553 p_qs_ship_to_county IN jtf_varchar2_table_100 := NULL,
557 p_qs_attribute3 IN jtf_varchar2_table_200 := NULL,
554 p_qs_attribute_category IN jtf_varchar2_table_100 := NULL,
555 p_qs_attribute1 IN jtf_varchar2_table_200 := NULL,
556 p_qs_attribute2 IN jtf_varchar2_table_200 := NULL,
558 p_qs_attribute4 IN jtf_varchar2_table_200 := NULL,
559 p_qs_attribute5 IN jtf_varchar2_table_200 := NULL,
560 p_qs_attribute6 IN jtf_varchar2_table_200 := NULL,
561 p_qs_attribute7 IN jtf_varchar2_table_200 := NULL,
562 p_qs_attribute8 IN jtf_varchar2_table_200 := NULL,
563 p_qs_attribute9 IN jtf_varchar2_table_200 := NULL,
564 p_qs_attribute10 IN jtf_varchar2_table_200 := NULL,
565 p_qs_attribute11 IN jtf_varchar2_table_200 := NULL,
566 p_qs_attribute12 IN jtf_varchar2_table_200 := NULL,
567 p_qs_attribute13 IN jtf_varchar2_table_200 := NULL,
568 p_qs_attribute14 IN jtf_varchar2_table_200 := NULL,
569 p_qs_attribute15 IN jtf_varchar2_table_200 := NULL,
570 p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
571 p_qt_qte_line_index IN jtf_number_table := NULL,
572 p_qt_shipment_index IN jtf_number_table := NULL,
573 p_qt_tax_detail_id IN jtf_number_table := NULL,
574 p_qt_quote_header_id IN jtf_number_table := NULL,
575 p_qt_quote_line_id IN jtf_number_table := NULL,
576 p_qt_quote_shipment_id IN jtf_number_table := NULL,
577 p_qt_creation_date IN jtf_date_table := NULL,
578 p_qt_created_by IN jtf_number_table := NULL,
579 p_qt_last_update_date IN jtf_date_table := NULL,
580 p_qt_last_updated_by IN jtf_number_table := NULL,
581 p_qt_last_update_login IN jtf_number_table := NULL,
582 p_qt_request_id IN jtf_number_table := NULL,
583 p_qt_program_application_id IN jtf_number_table := NULL,
584 p_qt_program_id IN jtf_number_table := NULL,
585 p_qt_program_update_date IN jtf_date_table := NULL,
586 p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
587 p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
588 p_qt_tax_rate IN jtf_number_table := NULL,
589 p_qt_tax_date IN jtf_date_table := NULL,
590 p_qt_tax_amount IN jtf_number_table := NULL,
591 p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
592 p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
593 p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
594 p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
595 p_qt_attribute1 IN jtf_varchar2_table_200 := NULL,
596 p_qt_attribute2 IN jtf_varchar2_table_200 := NULL,
597 p_qt_attribute3 IN jtf_varchar2_table_200 := NULL,
598 p_qt_attribute4 IN jtf_varchar2_table_200 := NULL,
599 p_qt_attribute5 IN jtf_varchar2_table_200 := NULL,
600 p_qt_attribute6 IN jtf_varchar2_table_200 := NULL,
601 p_qt_attribute7 IN jtf_varchar2_table_200 := NULL,
602 p_qt_attribute8 IN jtf_varchar2_table_200 := NULL,
603 p_qt_attribute9 IN jtf_varchar2_table_200 := NULL,
604 p_qt_attribute10 IN jtf_varchar2_table_200 := NULL,
605 p_qt_attribute11 IN jtf_varchar2_table_200 := NULL,
606 p_qt_attribute12 IN jtf_varchar2_table_200 := NULL,
607 p_qt_attribute13 IN jtf_varchar2_table_200 := NULL,
608 p_qt_attribute14 IN jtf_varchar2_table_200 := NULL,
609 p_qt_attribute15 IN jtf_varchar2_table_200 := NULL,
610 p_qlpa_operation_code IN jtf_varchar2_table_100 := NULL,
611 p_qlpa_qte_line_index IN jtf_number_table := NULL,
612 p_qlpa_price_attribute_id IN jtf_number_table := NULL,
613 p_qlpa_creation_date IN jtf_date_table := NULL,
614 p_qlpa_created_by IN jtf_number_table := NULL,
615 p_qlpa_last_update_date IN jtf_date_table := NULL,
616 p_qlpa_last_updated_by IN jtf_number_table := NULL,
617 p_qlpa_last_update_login IN jtf_number_table := NULL,
618 p_qlpa_request_id IN jtf_number_table := NULL,
619 p_qlpa_program_application_id IN jtf_number_table := NULL,
620 p_qlpa_program_id IN jtf_number_table := NULL,
621 p_qlpa_program_update_date IN jtf_date_table := NULL,
622 p_qlpa_quote_header_id IN jtf_number_table := NULL,
623 p_qlpa_quote_line_id IN jtf_number_table := NULL,
624 p_qlpa_flex_title IN jtf_varchar2_table_100 := NULL,
625 p_qlpa_pricing_context IN jtf_varchar2_table_100 := NULL,
626 p_qlpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
627 p_qlpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
628 p_qlpa_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,
629 p_qlpa_pricing_attribute4 IN jtf_varchar2_table_300 := NULL,
630 p_qlpa_pricing_attribute5 IN jtf_varchar2_table_300 := NULL,
631 p_qlpa_pricing_attribute6 IN jtf_varchar2_table_300 := NULL,
632 p_qlpa_pricing_attribute7 IN jtf_varchar2_table_300 := NULL,
633 p_qlpa_pricing_attribute8 IN jtf_varchar2_table_300 := NULL,
634 p_qlpa_pricing_attribute9 IN jtf_varchar2_table_300 := NULL,
635 p_qlpa_pricing_attribute10 IN jtf_varchar2_table_300 := NULL,
636 p_qlpa_pricing_attribute11 IN jtf_varchar2_table_300 := NULL,
637 p_qlpa_pricing_attribute12 IN jtf_varchar2_table_300 := NULL,
641 p_qlpa_pricing_attribute16 IN jtf_varchar2_table_300 := NULL,
638 p_qlpa_pricing_attribute13 IN jtf_varchar2_table_300 := NULL,
639 p_qlpa_pricing_attribute14 IN jtf_varchar2_table_300 := NULL,
640 p_qlpa_pricing_attribute15 IN jtf_varchar2_table_300 := NULL,
642 p_qlpa_pricing_attribute17 IN jtf_varchar2_table_300 := NULL,
643 p_qlpa_pricing_attribute18 IN jtf_varchar2_table_300 := NULL,
644 p_qlpa_pricing_attribute19 IN jtf_varchar2_table_300 := NULL,
645 p_qlpa_pricing_attribute20 IN jtf_varchar2_table_300 := NULL,
646 p_qlpa_pricing_attribute21 IN jtf_varchar2_table_300 := NULL,
647 p_qlpa_pricing_attribute22 IN jtf_varchar2_table_300 := NULL,
648 p_qlpa_pricing_attribute23 IN jtf_varchar2_table_300 := NULL,
649 p_qlpa_pricing_attribute24 IN jtf_varchar2_table_300 := NULL,
650 p_qlpa_pricing_attribute25 IN jtf_varchar2_table_300 := NULL,
651 p_qlpa_pricing_attribute26 IN jtf_varchar2_table_300 := NULL,
652 p_qlpa_pricing_attribute27 IN jtf_varchar2_table_300 := NULL,
653 p_qlpa_pricing_attribute28 IN jtf_varchar2_table_300 := NULL,
654 p_qlpa_pricing_attribute29 IN jtf_varchar2_table_300 := NULL,
655 p_qlpa_pricing_attribute30 IN jtf_varchar2_table_300 := NULL,
656 p_qlpa_pricing_attribute31 IN jtf_varchar2_table_300 := NULL,
657 p_qlpa_pricing_attribute32 IN jtf_varchar2_table_300 := NULL,
658 p_qlpa_pricing_attribute33 IN jtf_varchar2_table_300 := NULL,
659 p_qlpa_pricing_attribute34 IN jtf_varchar2_table_300 := NULL,
660 p_qlpa_pricing_attribute35 IN jtf_varchar2_table_300 := NULL,
661 p_qlpa_pricing_attribute36 IN jtf_varchar2_table_300 := NULL,
662 p_qlpa_pricing_attribute37 IN jtf_varchar2_table_300 := NULL,
663 p_qlpa_pricing_attribute38 IN jtf_varchar2_table_300 := NULL,
664 p_qlpa_pricing_attribute39 IN jtf_varchar2_table_300 := NULL,
665 p_qlpa_pricing_attribute40 IN jtf_varchar2_table_300 := NULL,
666 p_qlpa_pricing_attribute41 IN jtf_varchar2_table_300 := NULL,
667 p_qlpa_pricing_attribute42 IN jtf_varchar2_table_300 := NULL,
668 p_qlpa_pricing_attribute43 IN jtf_varchar2_table_300 := NULL,
669 p_qlpa_pricing_attribute44 IN jtf_varchar2_table_300 := NULL,
670 p_qlpa_pricing_attribute45 IN jtf_varchar2_table_300 := NULL,
671 p_qlpa_pricing_attribute46 IN jtf_varchar2_table_300 := NULL,
672 p_qlpa_pricing_attribute47 IN jtf_varchar2_table_300 := NULL,
673 p_qlpa_pricing_attribute48 IN jtf_varchar2_table_300 := NULL,
674 p_qlpa_pricing_attribute49 IN jtf_varchar2_table_300 := NULL,
675 p_qlpa_pricing_attribute50 IN jtf_varchar2_table_300 := NULL,
676 p_qlpa_pricing_attribute51 IN jtf_varchar2_table_300 := NULL,
677 p_qlpa_pricing_attribute52 IN jtf_varchar2_table_300 := NULL,
678 p_qlpa_pricing_attribute53 IN jtf_varchar2_table_300 := NULL,
679 p_qlpa_pricing_attribute54 IN jtf_varchar2_table_300 := NULL,
680 p_qlpa_pricing_attribute55 IN jtf_varchar2_table_300 := NULL,
681 p_qlpa_pricing_attribute56 IN jtf_varchar2_table_300 := NULL,
682 p_qlpa_pricing_attribute57 IN jtf_varchar2_table_300 := NULL,
683 p_qlpa_pricing_attribute58 IN jtf_varchar2_table_300 := NULL,
684 p_qlpa_pricing_attribute59 IN jtf_varchar2_table_300 := NULL,
685 p_qlpa_pricing_attribute60 IN jtf_varchar2_table_300 := NULL,
686 p_qlpa_pricing_attribute61 IN jtf_varchar2_table_300 := NULL,
687 p_qlpa_pricing_attribute62 IN jtf_varchar2_table_300 := NULL,
688 p_qlpa_pricing_attribute63 IN jtf_varchar2_table_300 := NULL,
689 p_qlpa_pricing_attribute64 IN jtf_varchar2_table_300 := NULL,
690 p_qlpa_pricing_attribute65 IN jtf_varchar2_table_300 := NULL,
691 p_qlpa_pricing_attribute66 IN jtf_varchar2_table_300 := NULL,
692 p_qlpa_pricing_attribute67 IN jtf_varchar2_table_300 := NULL,
693 p_qlpa_pricing_attribute68 IN jtf_varchar2_table_300 := NULL,
694 p_qlpa_pricing_attribute69 IN jtf_varchar2_table_300 := NULL,
695 p_qlpa_pricing_attribute70 IN jtf_varchar2_table_300 := NULL,
696 p_qlpa_pricing_attribute71 IN jtf_varchar2_table_300 := NULL,
697 p_qlpa_pricing_attribute72 IN jtf_varchar2_table_300 := NULL,
698 p_qlpa_pricing_attribute73 IN jtf_varchar2_table_300 := NULL,
699 p_qlpa_pricing_attribute74 IN jtf_varchar2_table_300 := NULL,
700 p_qlpa_pricing_attribute75 IN jtf_varchar2_table_300 := NULL,
701 p_qlpa_pricing_attribute76 IN jtf_varchar2_table_300 := NULL,
702 p_qlpa_pricing_attribute77 IN jtf_varchar2_table_300 := NULL,
703 p_qlpa_pricing_attribute78 IN jtf_varchar2_table_300 := NULL,
704 p_qlpa_pricing_attribute79 IN jtf_varchar2_table_300 := NULL,
705 p_qlpa_pricing_attribute80 IN jtf_varchar2_table_300 := NULL,
706 p_qlpa_pricing_attribute81 IN jtf_varchar2_table_300 := NULL,
707 p_qlpa_pricing_attribute82 IN jtf_varchar2_table_300 := NULL,
708 p_qlpa_pricing_attribute83 IN jtf_varchar2_table_300 := NULL,
709 p_qlpa_pricing_attribute84 IN jtf_varchar2_table_300 := NULL,
710 p_qlpa_pricing_attribute85 IN jtf_varchar2_table_300 := NULL,
711 p_qlpa_pricing_attribute86 IN jtf_varchar2_table_300 := NULL,
712 p_qlpa_pricing_attribute87 IN jtf_varchar2_table_300 := NULL,
713 p_qlpa_pricing_attribute88 IN jtf_varchar2_table_300 := NULL,
714 p_qlpa_pricing_attribute89 IN jtf_varchar2_table_300 := NULL,
715 p_qlpa_pricing_attribute90 IN jtf_varchar2_table_300 := NULL,
716 p_qlpa_pricing_attribute91 IN jtf_varchar2_table_300 := NULL,
717 p_qlpa_pricing_attribute92 IN jtf_varchar2_table_300 := NULL,
718 p_qlpa_pricing_attribute93 IN jtf_varchar2_table_300 := NULL,
722 p_qlpa_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
719 p_qlpa_pricing_attribute94 IN jtf_varchar2_table_300 := NULL,
720 p_qlpa_pricing_attribute95 IN jtf_varchar2_table_300 := NULL,
721 p_qlpa_pricing_attribute96 IN jtf_varchar2_table_300 := NULL,
723 p_qlpa_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
724 p_qlpa_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
725 p_qlpa_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
726 p_qlpa_context IN jtf_varchar2_table_100 := NULL,
727 p_qlpa_attribute1 IN jtf_varchar2_table_300 := NULL,
728 p_qlpa_attribute2 IN jtf_varchar2_table_300 := NULL,
729 p_qlpa_attribute3 IN jtf_varchar2_table_300 := NULL,
730 p_qlpa_attribute4 IN jtf_varchar2_table_300 := NULL,
731 p_qlpa_attribute5 IN jtf_varchar2_table_300 := NULL,
732 p_qlpa_attribute6 IN jtf_varchar2_table_300 := NULL,
733 p_qlpa_attribute7 IN jtf_varchar2_table_300 := NULL,
734 p_qlpa_attribute8 IN jtf_varchar2_table_300 := NULL,
735 p_qlpa_attribute9 IN jtf_varchar2_table_300 := NULL,
736 p_qlpa_attribute10 IN jtf_varchar2_table_300 := NULL,
737 p_qlpa_attribute11 IN jtf_varchar2_table_300 := NULL,
738 p_qlpa_attribute12 IN jtf_varchar2_table_300 := NULL,
739 p_qlpa_attribute13 IN jtf_varchar2_table_300 := NULL,
740 p_qlpa_attribute14 IN jtf_varchar2_table_300 := NULL,
741 p_qlpa_attribute15 IN jtf_varchar2_table_300 := NULL,
742 p_qlp_operation_code IN jtf_varchar2_table_100 := NULL,
743 p_qlp_qte_line_index IN jtf_number_table := NULL,
744 p_qlp_payment_id IN jtf_number_table := NULL,
745 p_qlp_creation_date IN jtf_date_table := NULL,
746 p_qlp_created_by IN jtf_number_table := NULL,
747 p_qlp_last_update_date IN jtf_date_table := NULL,
748 p_qlp_last_updated_by IN jtf_number_table := NULL,
749 p_qlp_last_update_login IN jtf_number_table := NULL,
750 p_qlp_request_id IN jtf_number_table := NULL,
751 p_qlp_program_application_id IN jtf_number_table := NULL,
752 p_qlp_program_id IN jtf_number_table := NULL,
753 p_qlp_program_update_date IN jtf_date_table := NULL,
754 p_qlp_quote_header_id IN jtf_number_table := NULL,
755 p_qlp_quote_line_id IN jtf_number_table := NULL,
756 p_qlp_payment_type_code IN jtf_varchar2_table_100 := NULL,
757 p_qlp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
758 p_qlp_payment_option IN jtf_varchar2_table_300 := NULL,
759 p_qlp_payment_term_id IN jtf_number_table := NULL,
760 p_qlp_credit_card_code IN jtf_varchar2_table_100 := NULL,
761 p_qlp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
762 p_qlp_credit_card_exp_date IN jtf_date_table := NULL,
763 p_qlp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
764 p_qlp_credit_card_aprv_date IN jtf_date_table := NULL,
765 p_qlp_payment_amount IN jtf_number_table := NULL,
766 p_qlp_cust_po_number IN jtf_varchar2_table_100 := NULL,
767 p_qlp_attribute_category IN jtf_varchar2_table_100 := NULL,
768 p_qlp_attribute1 IN jtf_varchar2_table_200 := NULL,
769 p_qlp_attribute2 IN jtf_varchar2_table_200 := NULL,
770 p_qlp_attribute3 IN jtf_varchar2_table_200 := NULL,
771 p_qlp_attribute4 IN jtf_varchar2_table_200 := NULL,
772 p_qlp_attribute5 IN jtf_varchar2_table_200 := NULL,
773 p_qlp_attribute6 IN jtf_varchar2_table_200 := NULL,
774 p_qlp_attribute7 IN jtf_varchar2_table_200 := NULL,
775 p_qlp_attribute8 IN jtf_varchar2_table_200 := NULL,
776 p_qlp_attribute9 IN jtf_varchar2_table_200 := NULL,
777 p_qlp_attribute10 IN jtf_varchar2_table_200 := NULL,
778 p_qlp_attribute11 IN jtf_varchar2_table_200 := NULL,
779 p_qlp_attribute12 IN jtf_varchar2_table_200 := NULL,
780 p_qlp_attribute13 IN jtf_varchar2_table_200 := NULL,
781 p_qlp_attribute14 IN jtf_varchar2_table_200 := NULL,
782 p_qlp_attribute15 IN jtf_varchar2_table_200 := NULL,
783 p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
784 p_qls_qte_line_index IN jtf_number_table := NULL,
785 p_qls_shipment_id IN jtf_number_table := NULL,
786 p_qls_creation_date IN jtf_date_table := NULL,
787 p_qls_created_by IN jtf_number_table := NULL,
788 p_qls_last_update_date IN jtf_date_table := NULL,
789 p_qls_last_updated_by IN jtf_number_table := NULL,
790 p_qls_last_update_login IN jtf_number_table := NULL,
791 p_qls_request_id IN jtf_number_table := NULL,
792 p_qls_program_application_id IN jtf_number_table := NULL,
793 p_qls_program_id IN jtf_number_table := NULL,
794 p_qls_program_update_date IN jtf_date_table := NULL,
795 p_qls_quote_header_id IN jtf_number_table := NULL,
796 p_qls_quote_line_id IN jtf_number_table := NULL,
797 p_qls_promise_date IN jtf_date_table := NULL,
798 p_qls_request_date IN jtf_date_table := NULL,
799 p_qls_schedule_ship_date IN jtf_date_table := NULL,
800 p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
801 p_qls_ship_to_party_id IN jtf_number_table := NULL,
802 p_qls_ship_to_cust_acct_id IN jtf_number_table := NULL,
806 p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
803 p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
804 p_qls_ship_set_id IN jtf_number_table := NULL,
805 p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
807 p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
808 p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
809 p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
810 p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
811 p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
812 p_qls_quantity IN jtf_number_table := NULL,
813 p_qls_reserved_quantity IN jtf_number_table := NULL,
814 p_qls_reservation_id IN jtf_number_table := NULL,
815 p_qls_order_line_id IN jtf_number_table := NULL,
816 p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
817 p_qls_ship_to_cont_fst_name IN jtf_varchar2_table_100 := NULL,
818 p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
819 p_qls_ship_to_cont_lst_name IN jtf_varchar2_table_100 := NULL,
820 p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
821 p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
822 p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
823 p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
824 p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
825 p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
826 p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
827 p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
828 p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
829 p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
830 p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
831 p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
832 p_qls_attribute1 IN jtf_varchar2_table_200 := NULL,
833 p_qls_attribute2 IN jtf_varchar2_table_200 := NULL,
834 p_qls_attribute3 IN jtf_varchar2_table_200 := NULL,
835 p_qls_attribute4 IN jtf_varchar2_table_200 := NULL,
836 p_qls_attribute5 IN jtf_varchar2_table_200 := NULL,
837 p_qls_attribute6 IN jtf_varchar2_table_200 := NULL,
838 p_qls_attribute7 IN jtf_varchar2_table_200 := NULL,
839 p_qls_attribute8 IN jtf_varchar2_table_200 := NULL,
840 p_qls_attribute9 IN jtf_varchar2_table_200 := NULL,
841 p_qls_attribute10 IN jtf_varchar2_table_200 := NULL,
842 p_qls_attribute11 IN jtf_varchar2_table_200 := NULL,
843 p_qls_attribute12 IN jtf_varchar2_table_200 := NULL,
844 p_qls_attribute13 IN jtf_varchar2_table_200 := NULL,
845 p_qls_attribute14 IN jtf_varchar2_table_200 := NULL,
846 p_qls_attribute15 IN jtf_varchar2_table_200 := NULL,
847 p_qlt_operation_code IN jtf_varchar2_table_100 := NULL,
848 p_qlt_qte_line_index IN jtf_number_table := NULL,
849 p_qlt_shipment_index IN jtf_number_table := NULL,
850 p_qlt_tax_detail_id IN jtf_number_table := NULL,
851 p_qlt_quote_header_id IN jtf_number_table := NULL,
852 p_qlt_quote_line_id IN jtf_number_table := NULL,
853 p_qlt_quote_shipment_id IN jtf_number_table := NULL,
854 p_qlt_creation_date IN jtf_date_table := NULL,
855 p_qlt_created_by IN jtf_number_table := NULL,
856 p_qlt_last_update_date IN jtf_date_table := NULL,
857 p_qlt_last_updated_by IN jtf_number_table := NULL,
858 p_qlt_last_update_login IN jtf_number_table := NULL,
859 p_qlt_request_id IN jtf_number_table := NULL,
860 p_qlt_program_application_id IN jtf_number_table := NULL,
861 p_qlt_program_id IN jtf_number_table := NULL,
862 p_qlt_program_update_date IN jtf_date_table := NULL,
863 p_qlt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
864 p_qlt_tax_code IN jtf_varchar2_table_100 := NULL,
865 p_qlt_tax_rate IN jtf_number_table := NULL,
866 p_qlt_tax_date IN jtf_date_table := NULL,
867 p_qlt_tax_amount IN jtf_number_table := NULL,
868 p_qlt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
869 p_qlt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
870 p_qlt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
871 p_qlt_attribute_category IN jtf_varchar2_table_100 := NULL,
872 p_qlt_attribute1 IN jtf_varchar2_table_200 := NULL,
873 p_qlt_attribute2 IN jtf_varchar2_table_200 := NULL,
874 p_qlt_attribute3 IN jtf_varchar2_table_200 := NULL,
875 p_qlt_attribute4 IN jtf_varchar2_table_200 := NULL,
876 p_qlt_attribute5 IN jtf_varchar2_table_200 := NULL,
877 p_qlt_attribute6 IN jtf_varchar2_table_200 := NULL,
878 p_qlt_attribute7 IN jtf_varchar2_table_200 := NULL,
879 p_qlt_attribute8 IN jtf_varchar2_table_200 := NULL,
880 p_qlt_attribute9 IN jtf_varchar2_table_200 := NULL,
881 p_qlt_attribute10 IN jtf_varchar2_table_200 := NULL,
882 p_qlt_attribute11 IN jtf_varchar2_table_200 := NULL,
883 p_qlt_attribute12 IN jtf_varchar2_table_200 := NULL,
884 p_qlt_attribute13 IN jtf_varchar2_table_200 := NULL,
885 p_qlt_attribute14 IN jtf_varchar2_table_200 := NULL,
889 p_qlpaa_price_adj_index IN jtf_number_table := NULL,
886 p_qlt_attribute15 IN jtf_varchar2_table_200 := NULL,
887 p_qlpaa_operation_code IN jtf_varchar2_table_100 := NULL,
888 p_qlpaa_qte_line_index IN jtf_number_table := NULL,
890 p_qlpaa_price_adj_attrib_id IN jtf_number_table := NULL,
891 p_qlpaa_creation_date IN jtf_date_table := NULL,
892 p_qlpaa_created_by IN jtf_number_table := NULL,
893 p_qlpaa_last_update_date IN jtf_date_table := NULL,
894 p_qlpaa_last_updated_by IN jtf_number_table := NULL,
895 p_qlpaa_last_update_login IN jtf_number_table := NULL,
896 p_qlpaa_program_application_id IN jtf_number_table := NULL,
897 p_qlpaa_program_id IN jtf_number_table := NULL,
898 p_qlpaa_program_update_date IN jtf_date_table := NULL,
899 p_qlpaa_request_id IN jtf_number_table := NULL,
900 p_qlpaa_price_adjustment_id IN jtf_number_table := NULL,
901 p_qlpaa_pricing_context IN jtf_varchar2_table_100 := NULL,
902 p_qlpaa_pricing_attribute IN jtf_varchar2_table_100 := NULL,
903 p_qlpaa_prc_attr_value_from IN jtf_varchar2_table_300 := NULL,
904 p_qlpaa_pricing_attr_value_to IN jtf_varchar2_table_300 := NULL,
905 p_qlpaa_comparison_operator IN jtf_varchar2_table_100 := NULL,
906 p_qlpaa_flex_title IN jtf_varchar2_table_100 := NULL,
907 p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
908 p_qlpaj_qte_line_index IN jtf_number_table := NULL,
909 p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
910 p_qlpaj_creation_date IN jtf_date_table := NULL,
911 p_qlpaj_created_by IN jtf_number_table := NULL,
912 p_qlpaj_last_update_date IN jtf_date_table := NULL,
913 p_qlpaj_last_updated_by IN jtf_number_table := NULL,
914 p_qlpaj_last_update_login IN jtf_number_table := NULL,
915 p_qlpaj_program_application_id IN jtf_number_table := NULL,
916 p_qlpaj_program_id IN jtf_number_table := NULL,
917 p_qlpaj_program_update_date IN jtf_date_table := NULL,
918 p_qlpaj_request_id IN jtf_number_table := NULL,
919 p_qlpaj_quote_header_id IN jtf_number_table := NULL,
920 p_qlpaj_quote_line_id IN jtf_number_table := NULL,
921 p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
922 p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
923 p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
924 p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
925 p_qlpaj_modified_from IN jtf_number_table := NULL,
926 p_qlpaj_modified_to IN jtf_number_table := NULL,
927 p_qlpaj_operand IN jtf_number_table := NULL,
928 p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
929 p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
930 p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
931 p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
932 p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
933 p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
934 p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
935 p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
936 p_qlpaj_attribute1 IN jtf_varchar2_table_200 := NULL,
937 p_qlpaj_attribute2 IN jtf_varchar2_table_200 := NULL,
938 p_qlpaj_attribute3 IN jtf_varchar2_table_200 := NULL,
939 p_qlpaj_attribute4 IN jtf_varchar2_table_200 := NULL,
940 p_qlpaj_attribute5 IN jtf_varchar2_table_200 := NULL,
941 p_qlpaj_attribute6 IN jtf_varchar2_table_200 := NULL,
942 p_qlpaj_attribute7 IN jtf_varchar2_table_200 := NULL,
943 p_qlpaj_attribute8 IN jtf_varchar2_table_200 := NULL,
944 p_qlpaj_attribute9 IN jtf_varchar2_table_200 := NULL,
945 p_qlpaj_attribute10 IN jtf_varchar2_table_200 := NULL,
946 p_qlpaj_attribute11 IN jtf_varchar2_table_200 := NULL,
947 p_qlpaj_attribute12 IN jtf_varchar2_table_200 := NULL,
948 p_qlpaj_attribute13 IN jtf_varchar2_table_200 := NULL,
949 p_qlpaj_attribute14 IN jtf_varchar2_table_200 := NULL,
950 p_qlpaj_attribute15 IN jtf_varchar2_table_200 := NULL,
951 p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
952 p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
953 p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
954 p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
955 p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
956 p_qlpaj_cost_id IN jtf_number_table := NULL,
957 p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
958 p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
959 p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
960 p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
961 p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
962 p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
963 p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
964 p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
965 p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
966 p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
967 p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
968 p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
972 p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
969 p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
970 p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
971 p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
973 p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
974 p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
975 p_qlpaj_benefit_qty IN jtf_number_table := NULL,
976 p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
977 p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
978 p_qlpaj_expiration_date IN jtf_date_table := NULL,
979 p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
980 p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
981 p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
982 p_qlpaj_redeemed_date IN jtf_date_table := NULL,
983 p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
984 p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
985 p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
986 p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
987 p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
988 p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
989 p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
990 p_qlpar_operation_code IN jtf_varchar2_table_100 := NULL,
991 p_qlpar_adj_relationship_id IN jtf_number_table := NULL,
992 p_qlpar_creation_date IN jtf_date_table := NULL,
993 p_qlpar_created_by IN jtf_number_table := NULL,
994 p_qlpar_last_update_date IN jtf_date_table := NULL,
995 p_qlpar_last_updated_by IN jtf_number_table := NULL,
996 p_qlpar_last_update_login IN jtf_number_table := NULL,
997 p_qlpar_request_id IN jtf_number_table := NULL,
998 p_qlpar_program_application_id IN jtf_number_table := NULL,
999 p_qlpar_program_id IN jtf_number_table := NULL,
1000 p_qlpar_program_update_date IN jtf_date_table := NULL,
1001 p_qlpar_quote_line_id IN jtf_number_table := NULL,
1002 p_qlpar_qte_line_index IN jtf_number_table := NULL,
1003 p_qlpar_price_adjustment_id IN jtf_number_table := NULL,
1004 p_qlpar_price_adj_index IN jtf_number_table := NULL,
1005 p_qlpar_rltd_price_adj_id IN jtf_number_table := NULL,
1006 p_qlpar_rltd_price_adj_index IN jtf_number_table := NULL,
1007 p_qlae_qte_line_index IN jtf_number_table := NULL,
1008 p_qlae_shipment_index IN jtf_number_table := NULL,
1009 p_qlae_line_attribute_id IN jtf_number_table := NULL,
1010 p_qlae_creation_date IN jtf_date_table := NULL,
1011 p_qlae_created_by IN jtf_number_table := NULL,
1012 p_qlae_last_update_date IN jtf_date_table := NULL,
1013 p_qlae_last_updated_by IN jtf_number_table := NULL,
1014 p_qlae_last_update_login IN jtf_number_table := NULL,
1015 p_qlae_request_id IN jtf_number_table := NULL,
1016 p_qlae_program_application_id IN jtf_number_table := NULL,
1017 p_qlae_program_id IN jtf_number_table := NULL,
1018 p_qlae_program_update_date IN jtf_date_table := NULL,
1019 p_qlae_quote_header_id IN jtf_number_table := NULL,
1020 p_qlae_quote_line_id IN jtf_number_table := NULL,
1021 p_qlae_quote_shipment_id IN jtf_number_table := NULL,
1022 p_qlae_attribute_type_code IN jtf_varchar2_table_100 := NULL,
1023 p_qlae_name IN jtf_varchar2_table_100 := NULL,
1024 p_qlae_value IN jtf_varchar2_table_2000 := NULL,
1025 p_qlae_value_type IN jtf_varchar2_table_300 := NULL,
1026 p_qlae_status IN jtf_varchar2_table_100 := NULL,
1027 p_qlae_application_id IN jtf_number_table := NULL,
1028 p_qlae_start_date_active IN jtf_date_table := NULL,
1029 p_qlae_end_date_active IN jtf_date_table := NULL,
1030 p_qlae_operation_code IN jtf_varchar2_table_100 := NULL,
1031 p_qfc_operation_code IN jtf_varchar2_table_100 := NULL,
1032 p_qfc_qte_line_index IN jtf_number_table := NULL,
1033 p_qfc_shipment_index IN jtf_number_table := NULL,
1034 p_qfc_freight_charge_id IN jtf_number_table := NULL,
1035 p_qfc_last_update_date IN jtf_date_table := NULL,
1036 p_qfc_last_updated_by IN jtf_number_table := NULL,
1037 p_qfc_creation_date IN jtf_date_table := NULL,
1038 p_qfc_created_by IN jtf_number_table := NULL,
1039 p_qfc_last_update_login IN jtf_number_table := NULL,
1040 p_qfc_program_application_id IN jtf_number_table := NULL,
1041 p_qfc_program_id IN jtf_number_table := NULL,
1042 p_qfc_program_update_date IN jtf_date_table := NULL,
1043 p_qfc_request_id IN jtf_number_table := NULL,
1044 p_qfc_quote_shipment_id IN jtf_number_table := NULL,
1045 p_qfc_quote_line_id IN jtf_number_table := NULL,
1046 p_qfc_freight_charge_type_id IN jtf_number_table := NULL,
1047 p_qfc_charge_amount IN jtf_number_table := NULL,
1048 p_qfc_attribute_category IN jtf_varchar2_table_200 := NULL,
1049 p_qfc_attribute1 IN jtf_varchar2_table_200 := NULL,
1050 p_qfc_attribute2 IN jtf_varchar2_table_200 := NULL,
1051 p_qfc_attribute3 IN jtf_varchar2_table_200 := NULL,
1055 p_qfc_attribute7 IN jtf_varchar2_table_200 := NULL,
1052 p_qfc_attribute4 IN jtf_varchar2_table_200 := NULL,
1053 p_qfc_attribute5 IN jtf_varchar2_table_200 := NULL,
1054 p_qfc_attribute6 IN jtf_varchar2_table_200 := NULL,
1056 p_qfc_attribute8 IN jtf_varchar2_table_200 := NULL,
1057 p_qfc_attribute9 IN jtf_varchar2_table_200 := NULL,
1058 p_qfc_attribute10 IN jtf_varchar2_table_200 := NULL,
1059 p_qfc_attribute11 IN jtf_varchar2_table_200 := NULL,
1060 p_qfc_attribute12 IN jtf_varchar2_table_200 := NULL,
1061 p_qfc_attribute13 IN jtf_varchar2_table_200 := NULL,
1062 p_qfc_attribute14 IN jtf_varchar2_table_200 := NULL,
1063 p_qfc_attribute15 IN jtf_varchar2_table_200 := NULL,
1064 p_qlfc_operation_code IN jtf_varchar2_table_100 := NULL,
1065 p_qlfc_qte_line_index IN jtf_number_table := NULL,
1066 p_qlfc_shipment_index IN jtf_number_table := NULL,
1067 p_qlfc_freight_charge_id IN jtf_number_table := NULL,
1068 p_qlfc_last_update_date IN jtf_date_table := NULL,
1069 p_qlfc_last_updated_by IN jtf_number_table := NULL,
1070 p_qlfc_creation_date IN jtf_date_table := NULL,
1071 p_qlfc_created_by IN jtf_number_table := NULL,
1072 p_qlfc_last_update_login IN jtf_number_table := NULL,
1073 p_qlfc_program_application_id IN jtf_number_table := NULL,
1074 p_qlfc_program_id IN jtf_number_table := NULL,
1075 p_qlfc_program_update_date IN jtf_date_table := NULL,
1076 p_qlfc_request_id IN jtf_number_table := NULL,
1077 p_qlfc_quote_shipment_id IN jtf_number_table := NULL,
1078 p_qlfc_quote_line_id IN jtf_number_table := NULL,
1079 p_qlfc_freight_charge_type_id IN jtf_number_table := NULL,
1080 p_qlfc_charge_amount IN jtf_number_table := NULL,
1081 p_qlfc_attribute_category IN jtf_varchar2_table_200 := NULL,
1082 p_qlfc_attribute1 IN jtf_varchar2_table_200 := NULL,
1083 p_qlfc_attribute2 IN jtf_varchar2_table_200 := NULL,
1084 p_qlfc_attribute3 IN jtf_varchar2_table_200 := NULL,
1085 p_qlfc_attribute4 IN jtf_varchar2_table_200 := NULL,
1086 p_qlfc_attribute5 IN jtf_varchar2_table_200 := NULL,
1087 p_qlfc_attribute6 IN jtf_varchar2_table_200 := NULL,
1088 p_qlfc_attribute7 IN jtf_varchar2_table_200 := NULL,
1089 p_qlfc_attribute8 IN jtf_varchar2_table_200 := NULL,
1090 p_qlfc_attribute9 IN jtf_varchar2_table_200 := NULL,
1091 p_qlfc_attribute10 IN jtf_varchar2_table_200 := NULL,
1092 p_qlfc_attribute11 IN jtf_varchar2_table_200 := NULL,
1093 p_qlfc_attribute12 IN jtf_varchar2_table_200 := NULL,
1094 p_qlfc_attribute13 IN jtf_varchar2_table_200 := NULL,
1095 p_qlfc_attribute14 IN jtf_varchar2_table_200 := NULL,
1096 p_qlfc_attribute15 IN jtf_varchar2_table_200 := NULL
1097 );
1098
1099
1100 PROCEDURE SubmitQuoteWrapper(
1101 p_api_version_number IN NUMBER := 1 ,
1102 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1103 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1104 x_return_status OUT NOCOPY VARCHAR2 ,
1105 x_msg_count OUT NOCOPY NUMBER ,
1106 x_msg_data OUT NOCOPY VARCHAR2 ,
1107 p_quote_headerid IN NUMBER ,
1108 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1109 p_sharee_number IN NUMBER := FND_API.G_MISS_NUM ,
1110 p_sharee_party_id IN NUMBER := FND_API.G_MISS_NUM ,
1111 p_sharee_account_id IN NUMBER := FND_API.G_MISS_NUM ,
1112 p_sc_book_flag IN VARCHAR2 := FND_API.G_FALSE ,
1113 p_sc_reserve_flag IN VARCHAR2 := FND_API.G_FALSE ,
1114 p_sc_calculate_price IN VARCHAR2 := FND_API.G_FALSE ,
1115 p_sc_server_id IN NUMBER := -1 ,
1116 p_sc_cc_by_fax IN VARCHAR2 := FND_API.G_FALSE ,
1117
1118 p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
1119 p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1120 p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
1121 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
1122
1123 x_last_update_date OUT NOCOPY DATE ,
1124 x_order_number OUT NOCOPY NUMBER ,
1125 x_order_header_id OUT NOCOPY NUMBER ,
1126 x_order_request_id OUT NOCOPY NUMBER ,
1127 x_contract_id OUT NOCOPY NUMBER ,
1128 x_status OUT NOCOPY VARCHAR2 ,
1129 --Mannamra: Added for bug 4716044
1130 x_hold_flag OUT NOCOPY VARCHAR2
1131
1132 );
1133
1134
1135 PROCEDURE AddModelsToCartWrapper(
1136 x_ql_quote_line_id OUT NOCOPY jtf_number_table ,
1137 p_api_version_number IN NUMBER := 1 ,
1138 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1139 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1140 p_Bundle_Flag IN VARCHAR2 := FND_API.G_FALSE ,
1141 x_return_status OUT NOCOPY VARCHAR2 ,
1142 x_msg_count OUT NOCOPY NUMBER ,
1143 x_msg_data OUT NOCOPY VARCHAR2 ,
1144 x_quote_header_id OUT NOCOPY NUMBER ,
1145 x_last_update_date OUT NOCOPY DATE ,
1149 p_sharee_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1146 p_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,
1147 p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
1148 p_sharee_party_id IN NUMBER := FND_API.G_MISS_NUM,
1150 p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
1151 p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1152 p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1153 p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
1154 p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
1155 p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1156 p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1157 p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
1158 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
1159 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
1160 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
1161 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1162 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
1163 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1164 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
1165 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
1166 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
1167 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
1168 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
1169 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1170 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
1171 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
1172 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
1173 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1174 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
1175 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
1176 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
1177 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
1178 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
1179 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1180 p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1181 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1182 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1183 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1184 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1185 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1186 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1187 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
1188 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
1189 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1190 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1191 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
1192 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
1193 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
1194 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
1195 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
1196 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
1197 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
1198 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
1199 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
1200 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
1201 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1202 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
1203 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1204 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1205 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
1206 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
1207 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1208 -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1209 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1210 -- added attribute 16-20 for bug 6873117 mgiridha
1211 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1212 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1213 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1214 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1215 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1216 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1217 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1218 p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1219 p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1220 p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1221 p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1222 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1223 p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1224 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1225 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1226 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1230 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1227 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1228 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1229 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1231 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
1232 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
1233 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
1234 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1235 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1236 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1237 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1238 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
1239 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1240 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1241 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1242 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1243 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
1244 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
1245 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
1246 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1247 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
1248 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1249 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
1250 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
1251 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
1252 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
1253 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1254 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1255 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
1256 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
1257 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
1258 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
1259 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1260 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
1261 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1262 p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
1263 p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
1264 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1266 p_ql_creation_date IN jtf_date_table := NULL,
1267 p_ql_created_by IN jtf_number_table := NULL,
1268 p_ql_last_updated_by IN jtf_number_table := NULL,
1269 p_ql_last_update_date IN jtf_date_table := NULL,
1270 p_ql_last_update_login IN jtf_number_table := NULL,
1271 p_ql_request_id IN jtf_number_table := NULL,
1272 p_ql_program_application_id IN jtf_number_table := NULL,
1273 p_ql_program_id IN jtf_number_table := NULL,
1274 p_ql_program_update_date IN jtf_date_table := NULL,
1275 p_ql_quote_line_id IN jtf_number_table := NULL,
1276 p_ql_quote_header_id IN jtf_number_table := NULL,
1277 p_ql_org_id IN jtf_number_table := NULL,
1278 p_ql_line_number IN jtf_number_table := NULL,
1279 p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
1280 p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
1281 p_ql_inventory_item_id IN jtf_number_table := NULL,
1282 p_ql_organization_id IN jtf_number_table := NULL,
1283 p_ql_quantity IN jtf_number_table := NULL,
1284 p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
1285 p_ql_start_date_active IN jtf_date_table := NULL,
1286 p_ql_end_date_active IN jtf_date_table := NULL,
1287 p_ql_order_line_type_id IN jtf_number_table := NULL,
1288 p_ql_price_list_id IN jtf_number_table := NULL,
1289 p_ql_price_list_line_id IN jtf_number_table := NULL,
1290 p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
1291 p_ql_line_list_price IN jtf_number_table := NULL,
1292 p_ql_line_adjusted_amount IN jtf_number_table := NULL,
1293 p_ql_line_adjusted_percent IN jtf_number_table := NULL,
1294 p_ql_line_quote_price IN jtf_number_table := NULL,
1295 p_ql_related_item_id IN jtf_number_table := NULL,
1296 p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
1297 p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
1298 p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
1299 p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
1300 p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
1301 p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
1302 p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
1303 p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
1304 p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
1305 p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,
1306 p_ql_attribute5 IN jtf_varchar2_table_300 := NULL,
1307 p_ql_attribute6 IN jtf_varchar2_table_300 := NULL,
1308 p_ql_attribute7 IN jtf_varchar2_table_300 := NULL,
1312 p_ql_attribute11 IN jtf_varchar2_table_300 := NULL,
1309 p_ql_attribute8 IN jtf_varchar2_table_300 := NULL,
1310 p_ql_attribute9 IN jtf_varchar2_table_300 := NULL,
1311 p_ql_attribute10 IN jtf_varchar2_table_300 := NULL,
1313 p_ql_attribute12 IN jtf_varchar2_table_300 := NULL,
1314 p_ql_attribute13 IN jtf_varchar2_table_300 := NULL,
1315 p_ql_attribute14 IN jtf_varchar2_table_300 := NULL,
1316 p_ql_attribute15 IN jtf_varchar2_table_300 := NULL,
1317 p_ql_accounting_rule_id IN jtf_number_table := NULL,
1318 p_ql_ffm_content_name IN jtf_varchar2_table_300 := NULL,
1319 p_ql_ffm_content_type IN jtf_varchar2_table_300 := NULL,
1320 p_ql_ffm_document_type IN jtf_varchar2_table_300 := NULL,
1321 p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
1322 p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
1323 p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
1324 p_ql_invoice_to_party_id IN jtf_number_table := NULL,
1325 p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
1326 p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
1327 p_ql_invoicing_rule_id IN jtf_number_table := NULL,
1328 p_ql_marketing_source_code_id IN jtf_number_table := NULL,
1329 p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
1330 p_ql_commitment_id IN jtf_number_table := NULL,
1331 p_ql_agreement_id IN jtf_number_table := NULL,
1332 p_ql_minisite_id IN jtf_number_table := NULL,
1333 p_ql_section_id IN jtf_number_table := NULL,
1334 p_ql_line_codes IN jtf_number_table := NULL
1335 );
1336
1337 TYPE ConfigCurTyp IS REF CURSOR;
1338 -- API NAME: RECONFIGURE_FROM_IB
1339 PROCEDURE RECONFIGURE_FROM_IB_WRAPPER(
1340 p_api_version_number IN NUMBER := 1,
1341 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1342 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1343 p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
1344 p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1345 p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1346 p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
1347 p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
1348 p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1349 p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1350 p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
1351 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
1352 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
1353 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
1354 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1355 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
1356 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1357 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
1358 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
1359 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
1360 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
1361 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
1362 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1363 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
1364 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
1365 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
1366 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1367 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
1368 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
1369 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
1370 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
1371 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
1372 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1373 p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1374 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1375 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1376 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1377 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1378 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1379 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1380 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
1381 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
1385 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
1382 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1383 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1384 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
1386 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
1387 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
1388 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
1389 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
1390 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
1391 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
1392 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
1393 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
1394 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1395 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
1396 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1397 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1398 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
1399 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
1400 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1401 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1402 -- added attribute 16-20 for bug 6873117 mgiridha
1403 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1404 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1405 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1406 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1407 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1408 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1409 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1410 p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1411 p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1412 p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1413 p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1414 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1415 p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1416 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1417 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1418 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1419 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1420 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1421 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1422 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1423 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
1424 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
1425 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
1426 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1427 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1428 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1429 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1430 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
1431 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1432 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1433 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1434 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1435 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
1436 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
1437 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
1438 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1439 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
1440 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1441 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
1442 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
1443 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
1444 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
1445 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1446 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1447 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
1448 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
1449 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
1450 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
1451 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
1453 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1454 p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
1455 p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
1456 p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
1457 p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
1458 p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1459 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1460 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1461 p_instance_ids IN jtf_number_table := NULL,
1462 x_config_line OUT NOCOPY ConfigCurTyp,
1463 x_last_update_date OUT NOCOPY DATE,
1464 x_return_status OUT NOCOPY VARCHAR2,
1465 x_msg_count OUT NOCOPY NUMBER,
1466 x_msg_data OUT NOCOPY VARCHAR2
1467 );
1468
1469
1470 END IBE_Quote_W1_PVT;
1471