[Home] [Help]
PACKAGE: APPS.ASO_QUOTE_PUB_W1
Source
1 PACKAGE ASO_Quote_Pub_W1 AUTHID CURRENT_USER as
2 /* $Header: asovqw2s.pls 120.1.12010000.6 2010/04/19 04:08:43 cazhou ship $ */
3
4
5 PROCEDURE Check_Atp
6 (
7 /* OUT parameters for quote line record ASO_ATP_INT.Atp_Tbl_Typ */
8 x_atp_inventory_item_id OUT NOCOPY jtf_number_table,
9 x_atp_inventory_item_name OUT NOCOPY jtf_varchar2_table_300,
10 x_inventory_item_description OUT NOCOPY JTF_VARCHAR2_TABLE_300,
11 x_padded_concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_300,
12 x_atp_source_organization_id OUT NOCOPY jtf_number_table,
13 x_atp_source_organization_code OUT NOCOPY jtf_varchar2_table_300,
14 x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
15 x_atp_identifier OUT NOCOPY jtf_number_table,
16 x_atp_customer_id OUT NOCOPY jtf_number_table,
17 x_atp_customer_site_id OUT NOCOPY jtf_number_table,
18 x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
19 x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
20 x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
21 x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
22 x_atp_ship_date OUT NOCOPY jtf_date_table,
23 x_atp_available_quantity OUT NOCOPY jtf_number_table,
24 x_atp_request_date_quantity OUT NOCOPY jtf_number_table,
25 x_atp_error_code OUT NOCOPY jtf_number_table,
26 x_atp_message OUT NOCOPY jtf_varchar2_table_2000,
27
28 x_atp_request_date_type OUT NOCOPY jtf_varchar2_table_300,
29 x_atp_req_date_type_meaning OUT NOCOPY jtf_varchar2_table_300,
30 x_atp_demand_class_code OUT NOCOPY jtf_varchar2_table_300,
31 x_atp_demand_class_meaning OUT NOCOPY jtf_varchar2_table_300,
32 x_atp_ship_set_name OUT NOCOPY jtf_varchar2_table_300,
33 x_atp_arrival_set_name OUT NOCOPY jtf_varchar2_table_300,
34 x_atp_line_number OUT NOCOPY jtf_varchar2_table_800,
35 x_atp_group_ship_date OUT NOCOPY jtf_date_table,
36 x_atp_requested_arrival_date OUT NOCOPY jtf_date_table,
37 x_atp_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
38 x_atp_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
39 x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
40 x_atp_quote_header_id OUT NOCOPY jtf_number_table,
41 x_atp_calling_module OUT NOCOPY jtf_number_table,
42 x_atp_quote_number OUT NOCOPY jtf_number_table,
43 x_atp_ato_line_id OUT NOCOPY jtf_number_table,
44 x_atp_ref_line_id OUT NOCOPY jtf_number_table,
45 x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
46 x_atp_action OUT NOCOPY jtf_number_table,
47 x_atp_arrival_date OUT NOCOPY jtf_date_table,
48 x_atp_organization_id OUT NOCOPY jtf_number_table,
49 x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
50 x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
51 x_atp_included_item_flag OUT NOCOPY jtf_number_table,
52 x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,
53 x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,
54 x_atp_country OUT NOCOPY jtf_varchar2_table_600,
55 x_atp_state OUT NOCOPY jtf_varchar2_table_600,
56 x_atp_city OUT NOCOPY jtf_varchar2_table_600,
57 x_atp_postal_code OUT NOCOPY jtf_varchar2_table_600,
58 x_atp_match_item_id OUT NOCOPY jtf_number_table,
59 /* Parameters for quote header record */
60 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
61 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
62 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
63 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
64 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
65 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
66 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
67 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
68 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
69 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
70 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
71 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
72 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
73 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
74 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
75 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
77 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
78 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
79 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
80 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
81 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
82 p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
83 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
84 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
85 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
86 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
87 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
88 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
90 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
91 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
94 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
95 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
96 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
97 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
98 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
99 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
100 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
101 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
102 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
103 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
104 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
105 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
106 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
109 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
110 p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111 p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
112 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
113 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121 p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123 p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
134 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
135 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
136 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
142 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
143 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
145 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
146 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
147 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
148 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
149 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
150 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
152 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
153 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
154 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
155 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
156 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
158 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
159 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
160 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
161 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
162 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
163 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
164 p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
165 p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
166 p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
167 p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
168 p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
169 p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
170 p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
171 p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
172 p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
173 p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
174 p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
175 p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
176 p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
177 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
178 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
179 p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
180 p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
181 p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
182 p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
183 p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
184 p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
185 p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
186 p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
187 p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
188 p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
189 p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
190 p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
191 p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
192 p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
193 p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
194 p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
195 p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
196 p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
197
198 /* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */
199 p_ql_creation_date IN jtf_date_table := NULL,
200 p_ql_created_by IN jtf_number_table := NULL,
201 p_ql_last_updated_by IN jtf_number_table := NULL,
202 p_ql_last_update_date IN jtf_date_table := NULL,
203 p_ql_last_update_login IN jtf_number_table := NULL,
204 p_ql_request_id IN jtf_number_table := NULL,
205 p_ql_program_application_id IN jtf_number_table := NULL,
206 p_ql_program_id IN jtf_number_table := NULL,
207 p_ql_program_update_date IN jtf_date_table := NULL,
208 p_ql_quote_line_id IN jtf_number_table := NULL,
209 p_ql_quote_header_id IN jtf_number_table := NULL,
210 p_ql_org_id IN jtf_number_table := NULL,
211 p_ql_line_number IN jtf_number_table := NULL,
212 p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
213 p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
214 p_ql_inventory_item_id IN jtf_number_table := NULL,
215 p_ql_organization_id IN jtf_number_table := NULL,
216 p_ql_quantity IN jtf_number_table := NULL,
217 p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
218 p_ql_start_date_active IN jtf_date_table := NULL,
219 p_ql_end_date_active IN jtf_date_table := NULL,
220 p_ql_order_line_type_id IN jtf_number_table := NULL,
221 p_ql_price_list_id IN jtf_number_table := NULL,
222 p_ql_price_list_line_id IN jtf_number_table := NULL,
223 p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
224 p_ql_line_list_price IN jtf_number_table := NULL,
225 p_ql_line_adjusted_amount IN jtf_number_table := NULL,
226 p_ql_line_adjusted_percent IN jtf_number_table := NULL,
227 p_ql_line_quote_price IN jtf_number_table := NULL,
228 p_ql_related_item_id IN jtf_number_table := NULL,
232 p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
229 p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
230 p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
231 p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
233 p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
234 p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
235 p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
236 p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
237 p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
238 p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,
239 p_ql_attribute5 IN jtf_varchar2_table_300 := NULL,
240 p_ql_attribute6 IN jtf_varchar2_table_300 := NULL,
241 p_ql_attribute7 IN jtf_varchar2_table_300 := NULL,
242 p_ql_attribute8 IN jtf_varchar2_table_300 := NULL,
243 p_ql_attribute9 IN jtf_varchar2_table_300 := NULL,
244 p_ql_attribute10 IN jtf_varchar2_table_300 := NULL,
245 p_ql_attribute11 IN jtf_varchar2_table_300 := NULL,
246 p_ql_attribute12 IN jtf_varchar2_table_300 := NULL,
247 p_ql_attribute13 IN jtf_varchar2_table_300 := NULL,
248 p_ql_attribute14 IN jtf_varchar2_table_300 := NULL,
249 p_ql_attribute15 IN jtf_varchar2_table_300 := NULL,
250 p_ql_attribute16 IN jtf_varchar2_table_300 := NULL,
251 p_ql_attribute17 IN jtf_varchar2_table_300 := NULL,
252 p_ql_attribute18 IN jtf_varchar2_table_300 := NULL,
253 p_ql_attribute19 IN jtf_varchar2_table_300 := NULL,
254 p_ql_attribute20 IN jtf_varchar2_table_300 := NULL,
255 p_ql_accounting_rule_id IN jtf_number_table := NULL,
256 p_ql_ffm_content_name IN jtf_varchar2_table_300 := NULL,
257 p_ql_ffm_content_type IN jtf_varchar2_table_300 := NULL,
258 p_ql_ffm_document_type IN jtf_varchar2_table_300 := NULL,
259 p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
260 p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
261 p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
262 p_ql_invoice_to_party_id IN jtf_number_table := NULL,
263 p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
264 p_ql_invoicing_rule_id IN jtf_number_table := NULL,
265 p_ql_marketing_source_code_id IN jtf_number_table := NULL,
266 p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
267 p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
268 p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
269 p_ql_minisite_id IN jtf_number_table := NULL,
270 p_ql_section_id IN jtf_number_table := NULL,
271 p_ql_priced_price_list_id IN jtf_number_table := NULL,
272 p_ql_agreement_id IN jtf_number_table := NULL,
273 p_ql_commitment_id IN jtf_number_table := NULL,
274 p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
275 p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
276
277 /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
278 p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
279 p_qls_qte_line_index IN jtf_number_table := NULL,
280 p_qls_shipment_id IN jtf_number_table := NULL,
281 p_qls_creation_date IN jtf_date_table := NULL,
282 p_qls_created_by IN jtf_number_table := NULL,
283 p_qls_last_update_date IN jtf_date_table := NULL,
284 p_qls_last_updated_by IN jtf_number_table := NULL,
285 p_qls_last_update_login IN jtf_number_table := NULL,
286 p_qls_request_id IN jtf_number_table := NULL,
287 p_qls_program_application_id IN jtf_number_table := NULL,
288 p_qls_program_id IN jtf_number_table := NULL,
289 p_qls_program_update_date IN jtf_date_table := NULL,
290 p_qls_quote_header_id IN jtf_number_table := NULL,
291 p_qls_quote_line_id IN jtf_number_table := NULL,
292 p_qls_promise_date IN jtf_date_table := NULL,
293 p_qls_request_date IN jtf_date_table := NULL,
294 p_qls_schedule_ship_date IN jtf_date_table := NULL,
295 p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
296 p_qls_ship_to_party_id IN jtf_number_table := NULL,
297 p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
298 p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
299 p_qls_ship_set_id IN jtf_number_table := NULL,
300 p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
301 p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
302 p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
303 p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
304 p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
305 p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
306 p_qls_quantity IN jtf_number_table := NULL,
310 p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
307 p_qls_reserved_quantity IN jtf_varchar2_table_300 := NULL,
308 p_qls_reservation_id IN jtf_number_table := NULL,
309 p_qls_order_line_id IN jtf_number_table := NULL,
311 p_qls_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
312 p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
313 p_qls_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
314 p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
315 p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
316 p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
317 p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
318 p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
319 p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
320 p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
321 p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
322 p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
323 p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
324 p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
325 p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
326 p_qls_attribute1 IN jtf_varchar2_table_300 := NULL,
327 p_qls_attribute2 IN jtf_varchar2_table_300 := NULL,
328 p_qls_attribute3 IN jtf_varchar2_table_300 := NULL,
329 p_qls_attribute4 IN jtf_varchar2_table_300 := NULL,
330 p_qls_attribute5 IN jtf_varchar2_table_300 := NULL,
331 p_qls_attribute6 IN jtf_varchar2_table_300 := NULL,
332 p_qls_attribute7 IN jtf_varchar2_table_300 := NULL,
333 p_qls_attribute8 IN jtf_varchar2_table_300 := NULL,
334 p_qls_attribute9 IN jtf_varchar2_table_300 := NULL,
335 p_qls_attribute10 IN jtf_varchar2_table_300 := NULL,
336 p_qls_attribute11 IN jtf_varchar2_table_300 := NULL,
337 p_qls_attribute12 IN jtf_varchar2_table_300 := NULL,
338 p_qls_attribute13 IN jtf_varchar2_table_300 := NULL,
339 p_qls_attribute14 IN jtf_varchar2_table_300 := NULL,
340 p_qls_attribute15 IN jtf_varchar2_table_300 := NULL,
341 p_qls_attribute16 IN jtf_varchar2_table_300 := NULL,
342 p_qls_attribute17 IN jtf_varchar2_table_300 := NULL,
343 p_qls_attribute18 IN jtf_varchar2_table_300 := NULL,
344 p_qls_attribute19 IN jtf_varchar2_table_300 := NULL,
345 p_qls_attribute20 IN jtf_varchar2_table_300 := NULL,
346 p_qls_ship_quote_price IN jtf_number_table := NULL,
347 p_qls_pricing_quantity IN jtf_number_table := NULL,
348 p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
349 p_qls_ship_from_org_id IN jtf_number_table := NULL,
350 p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
351 p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
352 p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
353 p_qls_object_version_number IN jtf_number_table := NULL,
354 /* Standard IN parameters */
355 P_API_VERSION_NUMBER IN NUMBER := 1,
356 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,
357 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
358
359 /* Standard OUT parameters */
360 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
361 X_MSG_COUNT OUT NOCOPY NUMBER,
362 X_MSG_DATA OUT NOCOPY VARCHAR2
363 );
364
365 Procedure Get_Payment_Channel_Attribs (
366 p_instr_channel_code IN VARCHAR2,
367 x_instr_secCode_Use OUT NOCOPY VARCHAR2,
368 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
369 X_MSG_COUNT OUT NOCOPY NUMBER,
370 X_MSG_DATA OUT NOCOPY VARCHAR2
371 );
372
373 PROCEDURE Validate_Model_Configuration
374 (
375 x_return_status OUT NOCOPY VARCHAR2,
376 x_msg_count OUT NOCOPY VARCHAR2,
377 x_msg_data OUT NOCOPY VARCHAR2,
378 x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
379 x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
380 x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
381 x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
382 p_quote_header_id IN NUMBER :=FND_API.G_MISS_NUM,
383 p_quote_line_id IN NUMBER :=FND_API.G_MISS_NUM,
384 p_update_quote IN VARCHAR2 := FND_API.G_MISS_CHAR,
385 p_config_effective_date IN DATE :=FND_API.G_MISS_DATE,
386 p_config_model_lookup_date IN DATE :=FND_API.G_MISS_DATE
387 );
388
389 PROCEDURE Copy_From_Quote(
390 x_quote_header_id OUT NOCOPY NUMBER,
391 x_quote_number OUT NOCOPY NUMBER,
392 p_cq_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
393 p_cq_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
394 p_cq_quote_number IN NUMBER := FND_API.G_MISS_NUM,
395 p_cq_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
396 p_cq_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
397 p_cq_resource_id IN NUMBER := FND_API.G_MISS_NUM,
398 p_cq_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
399 p_cq_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
403 p_cc_copy_header_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
400 p_cq_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
401 p_cq_price_updated_date IN DATE := FND_API.G_MISS_DATE,
402 p_cq_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
404 p_cc_new_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
405 p_cc_copy_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
406 p_cc_copy_task IN VARCHAR2 := FND_API.G_MISS_CHAR,
407 p_cc_copy_attachment IN VARCHAR2 := FND_API.G_MISS_CHAR,
408 p_cc_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
409 p_cc_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
410 p_cc_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
411 p_cc_calc_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
412 p_cc_calculate_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
413 p_cc_copy_shipping IN VARCHAR2 := FND_API.G_MISS_CHAR,
414 p_cc_copy_billing IN VARCHAR2 := FND_API.G_MISS_CHAR,
415 p_cc_copy_payment IN VARCHAR2 := FND_API.G_MISS_CHAR,
416 p_cc_copy_sales_supplement IN VARCHAR2 := FND_API.G_MISS_CHAR,
417 p_cc_copy_sales_credit IN VARCHAR2 := FND_API.G_MISS_CHAR,
418 p_cc_copy_flexfield IN VARCHAR2 := FND_API.G_MISS_CHAR,
419 p_cc_copy_contract_terms IN VARCHAR2 := FND_API.G_MISS_CHAR,
420 p_cc_copy_end_customer IN VARCHAR2 := FND_API.G_MISS_CHAR,
421 p_cc_copy_sales_team IN VARCHAR2 := FND_API.G_MISS_CHAR,
422 p_cc_copy_line_shipping IN VARCHAR2 := FND_API.G_MISS_CHAR,
423 p_cc_copy_line_billing IN VARCHAR2 := FND_API.G_MISS_CHAR,
424 p_cc_copy_line_end_customer IN VARCHAR2 := FND_API.G_MISS_CHAR,
425 p_cc_copy_line_payment IN VARCHAR2 := FND_API.G_MISS_CHAR,
426 p_cc_copy_line_sales_supp IN VARCHAR2 := FND_API.G_MISS_CHAR,
427 p_cc_copy_line_flexfield IN VARCHAR2 := FND_API.G_MISS_CHAR,
428 p_cc_copy_line_attachment IN VARCHAR2 := FND_API.G_MISS_CHAR,
429 p_cc_copy_line_sales_credit IN VARCHAR2 := FND_API.G_MISS_CHAR,
430 p_cc_copy_to_same_customer IN VARCHAR2 := FND_API.G_MISS_CHAR,
431 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
432 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
433 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
434 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
435 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
436 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
437 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
438 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
439 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
440 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
441 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
442 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
443 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
444 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
445 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
446 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
448 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
449 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
450 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
451 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
452 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
453 p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
454 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
455 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
456 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
457 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
458 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
459 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
460 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
461 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
462 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
463 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
464 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
465 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
466 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
467 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
468 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
469 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
470 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
471 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
472 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
473 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
474 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
475 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
476 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
477 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
478 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
479 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
480 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
481 p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
485 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
482 p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
483 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
484 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
486 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
487 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
488 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
489 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
490 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
491 p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
492 p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
493 p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
494 p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
495 p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
496 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
497 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
498 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
502 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
503 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
504 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
505 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
506 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
507 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
508 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
509 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
510 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
511 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
512 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
513 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
514 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
515 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
516 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
517 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
518 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
519 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
520 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
521 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
522 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
523 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
524 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
525 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
526 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
527 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
528 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
529 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
530 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
531 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
532 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
533 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
534 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
535 p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
536 p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
537 p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
538 p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
539 p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
540 p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
541 p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
542 p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
543 p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
544 p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
545 p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
546 p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
547 p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
548 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
549 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
550 p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
551 p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
552 p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
553 p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
554 p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
555 p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
556 p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
557 p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
558 p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
559 p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
560 p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
561 p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
562 p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
566 p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
563 p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
564 p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
565 p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
567 p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
568 p_q_header_paynow_charges IN NUMBER := FND_API.G_MISS_NUM,
569 -- hd shipment record
570 p_qs_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
571 p_qs_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
572 p_qs_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
573 p_qs_creation_date IN DATE := FND_API.G_MISS_DATE,
574 p_qs_created_by IN NUMBER := FND_API.G_MISS_NUM,
575 p_qs_last_update_date IN DATE := FND_API.G_MISS_DATE,
576 p_qs_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
577 p_qs_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
578 p_qs_request_id IN NUMBER := FND_API.G_MISS_NUM,
579 p_qs_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
580 p_qs_program_id IN NUMBER := FND_API.G_MISS_NUM,
581 p_qs_program_update_date IN DATE := FND_API.G_MISS_DATE,
582 p_qs_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
583 p_qs_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
584 p_qs_promise_date IN DATE := FND_API.G_MISS_DATE,
585 p_qs_request_date IN DATE := FND_API.G_MISS_DATE,
586 p_qs_schedule_ship_date IN DATE := FND_API.G_MISS_DATE,
587 p_qs_ship_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
588 p_qs_ship_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
589 p_qs_ship_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
590 p_qs_ship_partial_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
591 p_qs_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,
592 p_qs_ship_method_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
593 p_qs_freight_terms_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
594 p_qs_freight_carrier_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
595 p_qs_fob_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
596 p_qs_shipping_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
597 p_qs_packing_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
598 p_qs_quantity IN NUMBER := FND_API.G_MISS_NUM,
599 p_qs_reserved_quantity IN VARCHAR2 := FND_API.G_MISS_CHAR,
600 p_qs_reservation_id IN NUMBER := FND_API.G_MISS_NUM,
601 p_qs_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
602 p_qs_ship_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
603 p_qs_ship_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
607 p_qs_ship_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
604 p_qs_ship_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
605 p_qs_ship_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
606 p_qs_ship_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
608 p_qs_ship_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
609 p_qs_ship_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
610 p_qs_ship_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
611 p_qs_ship_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
612 p_qs_ship_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
613 p_qs_ship_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
614 p_qs_ship_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
615 p_qs_ship_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
616 p_qs_ship_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
617 p_qs_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
618 p_qs_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
619 p_qs_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
620 p_qs_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
621 p_qs_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
622 p_qs_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
623 p_qs_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
624 p_qs_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
625 p_qs_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
626 p_qs_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
627 p_qs_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
628 p_qs_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
629 p_qs_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
630 p_qs_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
631 p_qs_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
632 p_qs_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
633 p_qs_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
634 p_qs_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
635 p_qs_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
636 p_qs_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
637 p_qs_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
638 p_qs_ship_quote_price IN NUMBER := FND_API.G_MISS_NUM,
639 p_qs_pricing_quantity IN NUMBER := FND_API.G_MISS_NUM,
640 p_qs_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
641 p_qs_ship_from_org_id IN NUMBER := FND_API.G_MISS_NUM,
642 p_qs_ship_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
643 p_qs_request_date_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
644 p_qs_demand_class_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
645 p_qs_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
646 -- hd payment record
647 p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
648 p_qp_qte_line_index IN jtf_number_table := NULL,
649 p_qp_payment_id IN jtf_number_table := NULL,
650 p_qp_creation_date IN jtf_date_table := NULL,
651 p_qp_created_by IN jtf_number_table := NULL,
652 p_qp_last_update_date IN jtf_date_table := NULL,
653 p_qp_last_updated_by IN jtf_number_table := NULL,
654 p_qp_last_update_login IN jtf_number_table := NULL,
655 p_qp_request_id IN jtf_number_table := NULL,
656 p_qp_program_application_id IN jtf_number_table := NULL,
657 p_qp_program_id IN jtf_number_table := NULL,
658 p_qp_program_update_date IN jtf_date_table := NULL,
659 p_qp_quote_header_id IN jtf_number_table := NULL,
660 p_qp_quote_line_id IN jtf_number_table := NULL,
661 p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
662 p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
663 p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
664 p_qp_payment_term_id IN jtf_number_table := NULL,
665 p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
666 p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
667 p_qp_credit_card_exp_date IN jtf_date_table := NULL,
668 p_qp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
669 p_qp_credit_card_aprv_date IN jtf_date_table := NULL,
670 p_qp_payment_amount IN jtf_number_table := NULL,
671 p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,
672 p_qp_attribute1 IN jtf_varchar2_table_300 := NULL,
673 p_qp_attribute2 IN jtf_varchar2_table_300 := NULL,
677 p_qp_attribute6 IN jtf_varchar2_table_300 := NULL,
674 p_qp_attribute3 IN jtf_varchar2_table_300 := NULL,
675 p_qp_attribute4 IN jtf_varchar2_table_300 := NULL,
676 p_qp_attribute5 IN jtf_varchar2_table_300 := NULL,
678 p_qp_attribute7 IN jtf_varchar2_table_300 := NULL,
679 p_qp_attribute8 IN jtf_varchar2_table_300 := NULL,
680 p_qp_attribute9 IN jtf_varchar2_table_300 := NULL,
681 p_qp_attribute10 IN jtf_varchar2_table_300 := NULL,
682 p_qp_attribute11 IN jtf_varchar2_table_300 := NULL,
683 p_qp_attribute12 IN jtf_varchar2_table_300 := NULL,
684 p_qp_attribute13 IN jtf_varchar2_table_300 := NULL,
685 p_qp_attribute14 IN jtf_varchar2_table_300 := NULL,
686 p_qp_attribute15 IN jtf_varchar2_table_300 := NULL,
687 p_qp_attribute16 IN jtf_varchar2_table_300 := NULL,
688 p_qp_attribute17 IN jtf_varchar2_table_300 := NULL,
689 p_qp_attribute18 IN jtf_varchar2_table_300 := NULL,
690 p_qp_attribute19 IN jtf_varchar2_table_300 := NULL,
691 p_qp_attribute20 IN jtf_varchar2_table_300 := NULL,
692 p_qp_shipment_index IN jtf_number_table := NULL,
693 p_qp_quote_shipment_id IN jtf_number_table := NULL,
694 p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
695 p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
696 p_qp_trxn_extension_id IN jtf_number_table := NULL,
697 p_qp_instrument_id IN jtf_number_table := NULL,
698 p_qp_instr_assignment_id IN jtf_number_table := NULL,
699 p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
700 p_qp_object_version_number IN jtf_number_table := NULL,
701 -- hd price attributes
702 p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
703 p_qpa_qte_line_index IN jtf_number_table := NULL,
704 p_qpa_price_attribute_id IN jtf_number_table := NULL,
705 p_qpa_creation_date IN jtf_date_table := NULL,
706 p_qpa_created_by IN jtf_number_table := NULL,
707 p_qpa_last_update_date IN jtf_date_table := NULL,
708 p_qpa_last_updated_by IN jtf_number_table := NULL,
709 p_qpa_last_update_login IN jtf_number_table := NULL,
710 p_qpa_request_id IN jtf_number_table := NULL,
711 p_qpa_program_application_id IN jtf_number_table := NULL,
712 p_qpa_program_id IN jtf_number_table := NULL,
713 p_qpa_program_update_date IN jtf_date_table := NULL,
714 p_qpa_quote_header_id IN jtf_number_table := NULL,
715 p_qpa_quote_line_id IN jtf_number_table := NULL,
716 p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
717 p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
718 p_qpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
719 p_qpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
720 p_qpa_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,
721 p_qpa_pricing_attribute4 IN jtf_varchar2_table_300 := NULL,
722 p_qpa_pricing_attribute5 IN jtf_varchar2_table_300 := NULL,
723 p_qpa_pricing_attribute6 IN jtf_varchar2_table_300 := NULL,
724 p_qpa_pricing_attribute7 IN jtf_varchar2_table_300 := NULL,
725 p_qpa_pricing_attribute8 IN jtf_varchar2_table_300 := NULL,
726 p_qpa_pricing_attribute9 IN jtf_varchar2_table_300 := NULL,
727 p_qpa_pricing_attribute10 IN jtf_varchar2_table_300 := NULL,
728 p_qpa_pricing_attribute11 IN jtf_varchar2_table_300 := NULL,
729 p_qpa_pricing_attribute12 IN jtf_varchar2_table_300 := NULL,
730 p_qpa_pricing_attribute13 IN jtf_varchar2_table_300 := NULL,
731 p_qpa_pricing_attribute14 IN jtf_varchar2_table_300 := NULL,
732 p_qpa_pricing_attribute15 IN jtf_varchar2_table_300 := NULL,
733 p_qpa_pricing_attribute16 IN jtf_varchar2_table_300 := NULL,
734 p_qpa_pricing_attribute17 IN jtf_varchar2_table_300 := NULL,
735 p_qpa_pricing_attribute18 IN jtf_varchar2_table_300 := NULL,
736 p_qpa_pricing_attribute19 IN jtf_varchar2_table_300 := NULL,
737 p_qpa_pricing_attribute20 IN jtf_varchar2_table_300 := NULL,
738 p_qpa_pricing_attribute21 IN jtf_varchar2_table_300 := NULL,
739 p_qpa_pricing_attribute22 IN jtf_varchar2_table_300 := NULL,
740 p_qpa_pricing_attribute23 IN jtf_varchar2_table_300 := NULL,
741 p_qpa_pricing_attribute24 IN jtf_varchar2_table_300 := NULL,
742 p_qpa_pricing_attribute25 IN jtf_varchar2_table_300 := NULL,
743 p_qpa_pricing_attribute26 IN jtf_varchar2_table_300 := NULL,
744 p_qpa_pricing_attribute27 IN jtf_varchar2_table_300 := NULL,
745 p_qpa_pricing_attribute28 IN jtf_varchar2_table_300 := NULL,
746 p_qpa_pricing_attribute29 IN jtf_varchar2_table_300 := NULL,
750 p_qpa_pricing_attribute33 IN jtf_varchar2_table_300 := NULL,
747 p_qpa_pricing_attribute30 IN jtf_varchar2_table_300 := NULL,
748 p_qpa_pricing_attribute31 IN jtf_varchar2_table_300 := NULL,
749 p_qpa_pricing_attribute32 IN jtf_varchar2_table_300 := NULL,
751 p_qpa_pricing_attribute34 IN jtf_varchar2_table_300 := NULL,
752 p_qpa_pricing_attribute35 IN jtf_varchar2_table_300 := NULL,
753 p_qpa_pricing_attribute36 IN jtf_varchar2_table_300 := NULL,
754 p_qpa_pricing_attribute37 IN jtf_varchar2_table_300 := NULL,
755 p_qpa_pricing_attribute38 IN jtf_varchar2_table_300 := NULL,
756 p_qpa_pricing_attribute39 IN jtf_varchar2_table_300 := NULL,
757 p_qpa_pricing_attribute40 IN jtf_varchar2_table_300 := NULL,
758 p_qpa_pricing_attribute41 IN jtf_varchar2_table_300 := NULL,
759 p_qpa_pricing_attribute42 IN jtf_varchar2_table_300 := NULL,
760 p_qpa_pricing_attribute43 IN jtf_varchar2_table_300 := NULL,
761 p_qpa_pricing_attribute44 IN jtf_varchar2_table_300 := NULL,
762 p_qpa_pricing_attribute45 IN jtf_varchar2_table_300 := NULL,
763 p_qpa_pricing_attribute46 IN jtf_varchar2_table_300 := NULL,
764 p_qpa_pricing_attribute47 IN jtf_varchar2_table_300 := NULL,
765 p_qpa_pricing_attribute48 IN jtf_varchar2_table_300 := NULL,
766 p_qpa_pricing_attribute49 IN jtf_varchar2_table_300 := NULL,
767 p_qpa_pricing_attribute50 IN jtf_varchar2_table_300 := NULL,
768 p_qpa_pricing_attribute51 IN jtf_varchar2_table_300 := NULL,
769 p_qpa_pricing_attribute52 IN jtf_varchar2_table_300 := NULL,
770 p_qpa_pricing_attribute53 IN jtf_varchar2_table_300 := NULL,
771 p_qpa_pricing_attribute54 IN jtf_varchar2_table_300 := NULL,
772 p_qpa_pricing_attribute55 IN jtf_varchar2_table_300 := NULL,
773 p_qpa_pricing_attribute56 IN jtf_varchar2_table_300 := NULL,
774 p_qpa_pricing_attribute57 IN jtf_varchar2_table_300 := NULL,
775 p_qpa_pricing_attribute58 IN jtf_varchar2_table_300 := NULL,
776 p_qpa_pricing_attribute59 IN jtf_varchar2_table_300 := NULL,
777 p_qpa_pricing_attribute60 IN jtf_varchar2_table_300 := NULL,
778 p_qpa_pricing_attribute61 IN jtf_varchar2_table_300 := NULL,
779 p_qpa_pricing_attribute62 IN jtf_varchar2_table_300 := NULL,
780 p_qpa_pricing_attribute63 IN jtf_varchar2_table_300 := NULL,
781 p_qpa_pricing_attribute64 IN jtf_varchar2_table_300 := NULL,
782 p_qpa_pricing_attribute65 IN jtf_varchar2_table_300 := NULL,
783 p_qpa_pricing_attribute66 IN jtf_varchar2_table_300 := NULL,
784 p_qpa_pricing_attribute67 IN jtf_varchar2_table_300 := NULL,
785 p_qpa_pricing_attribute68 IN jtf_varchar2_table_300 := NULL,
786 p_qpa_pricing_attribute69 IN jtf_varchar2_table_300 := NULL,
787 p_qpa_pricing_attribute70 IN jtf_varchar2_table_300 := NULL,
788 p_qpa_pricing_attribute71 IN jtf_varchar2_table_300 := NULL,
789 p_qpa_pricing_attribute72 IN jtf_varchar2_table_300 := NULL,
790 p_qpa_pricing_attribute73 IN jtf_varchar2_table_300 := NULL,
791 p_qpa_pricing_attribute74 IN jtf_varchar2_table_300 := NULL,
792 p_qpa_pricing_attribute75 IN jtf_varchar2_table_300 := NULL,
793 p_qpa_pricing_attribute76 IN jtf_varchar2_table_300 := NULL,
794 p_qpa_pricing_attribute77 IN jtf_varchar2_table_300 := NULL,
795 p_qpa_pricing_attribute78 IN jtf_varchar2_table_300 := NULL,
796 p_qpa_pricing_attribute79 IN jtf_varchar2_table_300 := NULL,
797 p_qpa_pricing_attribute80 IN jtf_varchar2_table_300 := NULL,
798 p_qpa_pricing_attribute81 IN jtf_varchar2_table_300 := NULL,
799 p_qpa_pricing_attribute82 IN jtf_varchar2_table_300 := NULL,
800 p_qpa_pricing_attribute83 IN jtf_varchar2_table_300 := NULL,
801 p_qpa_pricing_attribute84 IN jtf_varchar2_table_300 := NULL,
802 p_qpa_pricing_attribute85 IN jtf_varchar2_table_300 := NULL,
803 p_qpa_pricing_attribute86 IN jtf_varchar2_table_300 := NULL,
804 p_qpa_pricing_attribute87 IN jtf_varchar2_table_300 := NULL,
805 p_qpa_pricing_attribute88 IN jtf_varchar2_table_300 := NULL,
806 p_qpa_pricing_attribute89 IN jtf_varchar2_table_300 := NULL,
807 p_qpa_pricing_attribute90 IN jtf_varchar2_table_300 := NULL,
808 p_qpa_pricing_attribute91 IN jtf_varchar2_table_300 := NULL,
809 p_qpa_pricing_attribute92 IN jtf_varchar2_table_300 := NULL,
810 p_qpa_pricing_attribute93 IN jtf_varchar2_table_300 := NULL,
811 p_qpa_pricing_attribute94 IN jtf_varchar2_table_300 := NULL,
812 p_qpa_pricing_attribute95 IN jtf_varchar2_table_300 := NULL,
813 p_qpa_pricing_attribute96 IN jtf_varchar2_table_300 := NULL,
814 p_qpa_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
815 p_qpa_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
816 p_qpa_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
817 p_qpa_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
818 p_qpa_context IN jtf_varchar2_table_100 := NULL,
819 p_qpa_attribute1 IN jtf_varchar2_table_300 := NULL,
820 p_qpa_attribute2 IN jtf_varchar2_table_300 := NULL,
824 p_qpa_attribute6 IN jtf_varchar2_table_300 := NULL,
821 p_qpa_attribute3 IN jtf_varchar2_table_300 := NULL,
822 p_qpa_attribute4 IN jtf_varchar2_table_300 := NULL,
823 p_qpa_attribute5 IN jtf_varchar2_table_300 := NULL,
825 p_qpa_attribute7 IN jtf_varchar2_table_300 := NULL,
826 p_qpa_attribute8 IN jtf_varchar2_table_300 := NULL,
827 p_qpa_attribute9 IN jtf_varchar2_table_300 := NULL,
828 p_qpa_attribute10 IN jtf_varchar2_table_300 := NULL,
829 p_qpa_attribute11 IN jtf_varchar2_table_300 := NULL,
830 p_qpa_attribute12 IN jtf_varchar2_table_300 := NULL,
831 p_qpa_attribute13 IN jtf_varchar2_table_300 := NULL,
832 p_qpa_attribute14 IN jtf_varchar2_table_300 := NULL,
833 p_qpa_attribute15 IN jtf_varchar2_table_300 := NULL,
834 p_qpa_attribute16 IN jtf_varchar2_table_300 := NULL,
835 p_qpa_attribute17 IN jtf_varchar2_table_300 := NULL,
836 p_qpa_attribute18 IN jtf_varchar2_table_300 := NULL,
837 p_qpa_attribute19 IN jtf_varchar2_table_300 := NULL,
838 p_qpa_attribute20 IN jtf_varchar2_table_300 := NULL,
839 p_qpa_object_version_number IN jtf_number_table := NULL,
840 --hd tax details
841 p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
842 p_qt_qte_line_index IN jtf_number_table := NULL,
843 p_qt_shipment_index IN jtf_number_table := NULL,
844 p_qt_tax_detail_id IN jtf_number_table := NULL,
845 p_qt_quote_header_id IN jtf_number_table := NULL,
846 p_qt_quote_line_id IN jtf_number_table := NULL,
847 p_qt_quote_shipment_id IN jtf_number_table := NULL,
848 p_qt_creation_date IN jtf_date_table := NULL,
849 p_qt_created_by IN jtf_number_table := NULL,
850 p_qt_last_update_date IN jtf_date_table := NULL,
851 p_qt_last_updated_by IN jtf_number_table := NULL,
852 p_qt_last_update_login IN jtf_number_table := NULL,
853 p_qt_request_id IN jtf_number_table := NULL,
854 p_qt_program_application_id IN jtf_number_table := NULL,
855 p_qt_program_id IN jtf_number_table := NULL,
856 p_qt_program_update_date IN jtf_date_table := NULL,
857 p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
858 p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
859 p_qt_tax_rate IN jtf_number_table := NULL,
860 p_qt_tax_date IN jtf_date_table := NULL,
861 p_qt_tax_amount IN jtf_number_table := NULL,
862 p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
863 p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
864 p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
868 p_qt_attribute3 IN jtf_varchar2_table_300 := NULL,
865 p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
866 p_qt_attribute1 IN jtf_varchar2_table_300 := NULL,
867 p_qt_attribute2 IN jtf_varchar2_table_300 := NULL,
869 p_qt_attribute4 IN jtf_varchar2_table_300 := NULL,
870 p_qt_attribute5 IN jtf_varchar2_table_300 := NULL,
871 p_qt_attribute6 IN jtf_varchar2_table_300 := NULL,
872 p_qt_attribute7 IN jtf_varchar2_table_300 := NULL,
873 p_qt_attribute8 IN jtf_varchar2_table_300 := NULL,
874 p_qt_attribute9 IN jtf_varchar2_table_300 := NULL,
875 p_qt_attribute10 IN jtf_varchar2_table_300 := NULL,
876 p_qt_attribute11 IN jtf_varchar2_table_300 := NULL,
877 p_qt_attribute12 IN jtf_varchar2_table_300 := NULL,
878 p_qt_attribute13 IN jtf_varchar2_table_300 := NULL,
879 p_qt_attribute14 IN jtf_varchar2_table_300 := NULL,
880 p_qt_attribute15 IN jtf_varchar2_table_300 := NULL,
881 p_qt_attribute16 IN jtf_varchar2_table_300 := NULL,
882 p_qt_attribute17 IN jtf_varchar2_table_300 := NULL,
883 p_qt_attribute18 IN jtf_varchar2_table_300 := NULL,
884 p_qt_attribute19 IN jtf_varchar2_table_300 := NULL,
885 p_qt_attribute20 IN jtf_varchar2_table_300 := NULL,
886 p_qt_object_version_number IN jtf_number_table := NULL,
887 p_qt_tax_rate_id IN jtf_number_table := NULL,
888 -- qh sales credit recore
889 p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
890 p_qsc_qte_line_index IN jtf_number_table := NULL,
891 p_qsc_sales_credit_id IN jtf_number_table := NULL,
892 p_qsc_creation_date IN jtf_date_table := NULL,
893 p_qsc_created_by IN jtf_number_table := NULL,
894 p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
895 p_qsc_last_update_date IN jtf_date_table := NULL,
896 p_qsc_last_update_login IN jtf_number_table := NULL,
897 p_qsc_request_id IN jtf_number_table := NULL,
898 p_qsc_program_application_id IN jtf_number_table := NULL,
899 p_qsc_program_id IN jtf_number_table := NULL,
900 p_qsc_program_update_date IN jtf_date_table := NULL,
901 p_qsc_quote_header_id IN jtf_number_table := NULL,
902 p_qsc_quote_line_id IN jtf_number_table := NULL,
903 p_qsc_percent IN jtf_number_table := NULL,
904 p_qsc_resource_id IN jtf_number_table := NULL,
905 p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
906 p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
907 p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
908 p_qsc_resource_group_id IN jtf_number_table := NULL,
909 p_qsc_employee_person_id IN jtf_number_table := NULL,
910 p_qsc_sales_credit_type_id IN jtf_number_table := NULL,
911 p_qsc_attribute_category IN jtf_varchar2_table_100 := NULL,
912 p_qsc_attribute1 IN jtf_varchar2_table_300 := NULL,
913 p_qsc_attribute2 IN jtf_varchar2_table_300 := NULL,
914 p_qsc_attribute3 IN jtf_varchar2_table_300 := NULL,
915 p_qsc_attribute4 IN jtf_varchar2_table_300 := NULL,
916 p_qsc_attribute5 IN jtf_varchar2_table_300 := NULL,
917 p_qsc_attribute6 IN jtf_varchar2_table_300 := NULL,
918 p_qsc_attribute7 IN jtf_varchar2_table_300 := NULL,
919 p_qsc_attribute8 IN jtf_varchar2_table_300 := NULL,
920 p_qsc_attribute9 IN jtf_varchar2_table_300 := NULL,
921 p_qsc_attribute10 IN jtf_varchar2_table_300 := NULL,
922 p_qsc_attribute11 IN jtf_varchar2_table_300 := NULL,
923 p_qsc_attribute12 IN jtf_varchar2_table_300 := NULL,
924 p_qsc_attribute13 IN jtf_varchar2_table_300 := NULL,
925 p_qsc_attribute14 IN jtf_varchar2_table_300 := NULL,
926 p_qsc_attribute15 IN jtf_varchar2_table_300 := NULL,
927 p_qsc_attribute16 IN jtf_varchar2_table_300 := NULL,
928 p_qsc_attribute17 IN jtf_varchar2_table_300 := NULL,
929 p_qsc_attribute18 IN jtf_varchar2_table_300 := NULL,
930 p_qsc_attribute19 IN jtf_varchar2_table_300 := NULL,
931 p_qsc_attribute20 IN jtf_varchar2_table_300 := NULL,
932 p_qsc_system_assigned_flag IN jtf_varchar2_table_100 := NULL,
933 p_qsc_credit_rule_id IN jtf_number_table := NULL,
934 p_qsc_object_version_number IN jtf_number_table := NULL,
935 -- price adjustment record
936 p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
937 p_qlpaj_qte_line_index IN jtf_number_table := NULL,
938 p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
939 p_qlpaj_creation_date IN jtf_date_table := NULL,
940 p_qlpaj_created_by IN jtf_number_table := NULL,
941 p_qlpaj_last_update_date IN jtf_date_table := NULL,
942 p_qlpaj_last_updated_by IN jtf_number_table := NULL,
943 p_qlpaj_last_update_login IN jtf_number_table := NULL,
944 p_qlpaj_program_application_id IN jtf_number_table := NULL,
945 p_qlpaj_program_id IN jtf_number_table := NULL,
946 p_qlpaj_program_update_date IN jtf_date_table := NULL,
950 p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
947 p_qlpaj_request_id IN jtf_number_table := NULL,
948 p_qlpaj_quote_header_id IN jtf_number_table := NULL,
949 p_qlpaj_quote_line_id IN jtf_number_table := NULL,
951 p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
952 p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
953 p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
954 p_qlpaj_modified_from IN jtf_number_table := NULL,
955 p_qlpaj_modified_to IN jtf_number_table := NULL,
956 p_qlpaj_operand IN jtf_number_table := NULL,
957 p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
958 p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
959 p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
960 p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
961 p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
962 p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
963 p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
964 p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
965 p_qlpaj_attribute1 IN jtf_varchar2_table_300 := NULL,
966 p_qlpaj_attribute2 IN jtf_varchar2_table_300 := NULL,
967 p_qlpaj_attribute3 IN jtf_varchar2_table_300 := NULL,
968 p_qlpaj_attribute4 IN jtf_varchar2_table_300 := NULL,
969 p_qlpaj_attribute5 IN jtf_varchar2_table_300 := NULL,
970 p_qlpaj_attribute6 IN jtf_varchar2_table_300 := NULL,
971 p_qlpaj_attribute7 IN jtf_varchar2_table_300 := NULL,
972 p_qlpaj_attribute8 IN jtf_varchar2_table_300 := NULL,
973 p_qlpaj_attribute9 IN jtf_varchar2_table_300 := NULL,
974 p_qlpaj_attribute10 IN jtf_varchar2_table_300 := NULL,
975 p_qlpaj_attribute11 IN jtf_varchar2_table_300 := NULL,
976 p_qlpaj_attribute12 IN jtf_varchar2_table_300 := NULL,
977 p_qlpaj_attribute13 IN jtf_varchar2_table_300 := NULL,
978 p_qlpaj_attribute14 IN jtf_varchar2_table_300 := NULL,
979 p_qlpaj_attribute15 IN jtf_varchar2_table_300 := NULL,
980 p_qlpaj_attribute16 IN jtf_varchar2_table_300 := NULL,
981 p_qlpaj_attribute17 IN jtf_varchar2_table_300 := NULL,
982 p_qlpaj_attribute18 IN jtf_varchar2_table_300 := NULL,
983 p_qlpaj_attribute19 IN jtf_varchar2_table_300 := NULL,
984 p_qlpaj_attribute20 IN jtf_varchar2_table_300 := NULL,
985 p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
986 p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
987 p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
988 p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
989 p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
990 p_qlpaj_cost_id IN jtf_number_table := NULL,
991 p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
992 p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
993 p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
994 p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
995 p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
996 p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
997 p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
998 p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
999 p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
1000 p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1001 p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1002 p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1003 p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1004 p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
1005 p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1006 p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1007 p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1008 p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
1009 p_qlpaj_benefit_qty IN jtf_number_table := NULL,
1010 p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
1011 p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1012 p_qlpaj_expiration_date IN jtf_date_table := NULL,
1013 p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
1014 p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
1015 p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
1016 p_qlpaj_redeemed_date IN jtf_date_table := NULL,
1017 p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
1018 p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
1019 p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
1020 p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
1021 p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
1022 p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1023 p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1024 p_qlpaj_shipment_index IN jtf_number_table := NULL,
1025 p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,
1026 p_qlpaj_object_version_number IN jtf_number_table := NULL,
1030 x_return_status OUT NOCOPY VARCHAR2 ,
1027 p_api_version_number IN NUMBER := 1 ,
1028 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1029 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1031 x_msg_count OUT NOCOPY NUMBER ,
1032 x_msg_data OUT NOCOPY VARCHAR2
1033 );
1034
1035 END ASO_Quote_Pub_W1;