[Home] [Help]
PACKAGE BODY: APPS.ASO_DEFAULTING_INT_W
Source
1 PACKAGE BODY Aso_Defaulting_Int_W AS
2 /* $Header: asovqwdb.pls 120.4 2005/11/01 14:55:04 skulkarn noship $ */
3 -- Start of Comments
4 -- Package name : Aso_Defaulting_Int_W
5
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'Aso_Defaulting_Int_W';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asovqwdb.pls';
9
10 PROCEDURE Default_Entity (
11 p_api_version IN NUMBER := 1,
12 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
13 p_commit IN VARCHAR2 := FND_API.G_FALSE,
14 p_dc_override_Trigger_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
15 p_dc_dependency_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
16 p_dc_defaulting_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
17 p_dc_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
18 p_dc_defaulting_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
19 p_dc_last_update_date IN DATE := FND_API.G_MISS_DATE,
20 p_dc_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
21 p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
22 p_trigger_attribute IN jtf_varchar2_table_100 := NULL,
23 p_op_opportunity_id IN NUMBER := FND_API.G_MISS_NUM ,
24 p_op_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
25 p_op_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
26 p_op_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
27 p_op_resource_id IN NUMBER := FND_API.G_MISS_NUM ,
28 p_op_sold_to_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
29 p_op_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
30 p_op_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
31 p_op_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM ,
32 p_op_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
33 p_op_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
34 p_op_agreement_id IN NUMBER := FND_API.G_MISS_NUM ,
35 p_op_contract_template_id IN NUMBER := FND_API.G_MISS_NUM ,
36 p_op_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM ,
37 p_op_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
38 p_op_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
39 p_op_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
40 p_op_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
41 p_op_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
42 p_op_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
43 p_op_price_updated_date IN DATE := FND_API.G_MISS_DATE,
44 p_op_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
45 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
46 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
47 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
48 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
49 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
50 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
51 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
52 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
53 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
54 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
55 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
56 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
57 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
58 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
59 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
60 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
62 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
63 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
64 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
65 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
66 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
67 p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
68 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
69 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
70 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
71 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
72 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
73 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
74 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
75 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
76 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
77 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
78 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
79 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
80 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
81 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
82 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
83 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
84 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
85 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
86 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
87 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
88 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
89 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
90 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
91 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
92 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
93 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
94 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
95 p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
96 p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
97 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
98 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
104 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
105 p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106 p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107 p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108 p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109 p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
119 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
120 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
121 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
127 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
128 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
131 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
132 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
133 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
134 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
135 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
136 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
137 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
139 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
140 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
142 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
143 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
144 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
145 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
146 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
147 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
148 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
149 p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
150 p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
151 p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
152 p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
153 p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
154 p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
155 p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
156 p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
157 p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
158 p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
159 p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
160 p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
161 p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
162 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
163 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
164 p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
165 p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
166 p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
167 p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
168 p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
169 p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
170 p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
171 p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
172 p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
173 p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
177 p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
174 p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
175 p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
176 p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
178 p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
179 p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
180 p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
181 p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
182 p_q_header_paynow_charges IN NUMBER := FND_API.G_MISS_NUM,
183 p_q_mis_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184 p_qs_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
185 p_qs_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
186 p_qs_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
187 p_qs_creation_date IN DATE := FND_API.G_MISS_DATE,
188 p_qs_created_by IN NUMBER := FND_API.G_MISS_NUM,
189 p_qs_last_update_date IN DATE := FND_API.G_MISS_DATE,
190 p_qs_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
191 p_qs_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
192 p_qs_request_id IN NUMBER := FND_API.G_MISS_NUM,
193 p_qs_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
194 p_qs_program_id IN NUMBER := FND_API.G_MISS_NUM,
195 p_qs_program_update_date IN DATE := FND_API.G_MISS_DATE,
196 p_qs_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
197 p_qs_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
198 p_qs_promise_date IN DATE := FND_API.G_MISS_DATE,
199 p_qs_request_date IN DATE := FND_API.G_MISS_DATE,
200 p_qs_schedule_ship_date IN DATE := FND_API.G_MISS_DATE,
201 p_qs_ship_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
202 p_qs_ship_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
203 p_qs_ship_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
204 p_qs_ship_partial_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
205 p_qs_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,
206 p_qs_ship_method_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
207 p_qs_freight_terms_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
208 p_qs_freight_carrier_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
209 p_qs_fob_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
210 p_qs_shipping_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
211 p_qs_packing_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
212 p_qs_quantity IN NUMBER := FND_API.G_MISS_NUM,
213 p_qs_reserved_quantity IN VARCHAR2 := FND_API.G_MISS_CHAR,
214 p_qs_reservation_id IN NUMBER := FND_API.G_MISS_NUM,
215 p_qs_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
216 p_qs_ship_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
217 p_qs_ship_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
218 p_qs_ship_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
219 p_qs_ship_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
220 p_qs_ship_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221 p_qs_ship_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222 p_qs_ship_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223 p_qs_ship_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224 p_qs_ship_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
225 p_qs_ship_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
226 p_qs_ship_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
227 p_qs_ship_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
228 p_qs_ship_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
229 p_qs_ship_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
230 p_qs_ship_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
231 p_qs_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
232 p_qs_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
233 p_qs_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
234 p_qs_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
235 p_qs_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
236 p_qs_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
237 p_qs_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
238 p_qs_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239 p_qs_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240 p_qs_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241 p_qs_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
242 p_qs_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
243 p_qs_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
244 p_qs_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
245 p_qs_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
246 p_qs_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
247 p_qs_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
248 p_qs_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
249 p_qs_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
253 p_qs_pricing_quantity IN NUMBER := FND_API.G_MISS_NUM,
250 p_qs_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
251 p_qs_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
252 p_qs_ship_quote_price IN NUMBER := FND_API.G_MISS_NUM,
254 p_qs_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
255 p_qs_ship_from_org_id IN NUMBER := FND_API.G_MISS_NUM,
256 p_qs_ship_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
257 p_qs_request_date_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
258 p_qs_demand_class_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
259 p_qs_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
260 p_qp_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
261 p_qp_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
262 p_qp_payment_id IN NUMBER := FND_API.G_MISS_NUM,
263 p_qp_creation_date IN DATE := FND_API.G_MISS_DATE,
264 p_qp_created_by IN NUMBER := FND_API.G_MISS_NUM,
265 p_qp_last_update_date IN DATE := FND_API.G_MISS_DATE,
266 p_qp_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
267 p_qp_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
268 p_qp_request_id IN NUMBER := FND_API.G_MISS_NUM,
269 p_qp_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
270 p_qp_program_id IN NUMBER := FND_API.G_MISS_NUM,
271 p_qp_program_update_date IN DATE := FND_API.G_MISS_DATE,
272 p_qp_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
273 p_qp_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
274 p_qp_payment_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
275 p_qp_payment_ref_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
276 p_qp_payment_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
277 p_qp_payment_term_id IN NUMBER := FND_API.G_MISS_NUM,
278 p_qp_credit_card_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
279 p_qp_credit_card_holder_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
280 p_qp_credit_card_exp_date IN DATE := FND_API.G_MISS_DATE,
281 p_qp_credit_card_aprv_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
282 p_qp_credit_card_aprv_date IN DATE := FND_API.G_MISS_DATE,
283 p_qp_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
284 p_qp_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
285 p_qp_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286 p_qp_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287 p_qp_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288 p_qp_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289 p_qp_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290 p_qp_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291 p_qp_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292 p_qp_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293 p_qp_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294 p_qp_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295 p_qp_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296 p_qp_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297 p_qp_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298 p_qp_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299 p_qp_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
300 p_qp_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
301 p_qp_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
302 p_qp_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
303 p_qp_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
304 p_qp_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
305 p_qp_shipment_index IN NUMBER := FND_API.G_MISS_NUM,
306 p_qp_quote_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
307 p_qp_cust_po_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
308 p_qp_cust_po_line_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
309 p_qp_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
310 p_qp_trxn_extension_id IN NUMBER := FND_API.G_MISS_NUM,
311 p_qp_instrument_id IN NUMBER := FND_API.G_MISS_NUM,
312 p_qp_instr_assignment_id IN NUMBER := FND_API.G_MISS_NUM,
313 p_qp_cvv2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314 p_qt_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
318 p_qt_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
315 p_qt_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
316 p_qt_shipment_index IN NUMBER := FND_API.G_MISS_NUM,
317 p_qt_tax_detail_id IN NUMBER := FND_API.G_MISS_NUM,
319 p_qt_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
320 p_qt_quote_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
321 p_qt_creation_date IN DATE := FND_API.G_MISS_DATE,
322 p_qt_created_by IN NUMBER := FND_API.G_MISS_NUM,
323 p_qt_last_update_date IN DATE := FND_API.G_MISS_DATE,
324 p_qt_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
325 p_qt_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
326 p_qt_request_id IN NUMBER := FND_API.G_MISS_NUM,
327 p_qt_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
328 p_qt_program_id IN NUMBER := FND_API.G_MISS_NUM,
329 p_qt_program_update_date IN DATE := FND_API.G_MISS_DATE,
330 p_qt_orig_tax_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
331 p_qt_tax_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
332 p_qt_tax_rate IN NUMBER := FND_API.G_MISS_NUM,
333 p_qt_tax_date IN DATE := FND_API.G_MISS_DATE,
334 p_qt_tax_amount IN NUMBER := FND_API.G_MISS_NUM,
335 p_qt_tax_exempt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
336 p_qt_tax_exempt_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
337 p_qt_tax_exempt_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
338 p_qt_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
339 p_qt_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
340 p_qt_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
341 p_qt_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
342 p_qt_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
343 p_qt_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
344 p_qt_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345 p_qt_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346 p_qt_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347 p_qt_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
351 p_qt_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348 p_qt_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349 p_qt_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350 p_qt_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
352 p_qt_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
353 p_qt_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
354 p_qt_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
355 p_qt_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
356 p_qt_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
357 p_qt_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
358 p_qt_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
359 p_qt_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
360 p_qt_tax_rate_id IN NUMBER := FND_API.G_MISS_NUM,
361 p_ql_creation_date IN DATE := FND_API.G_MISS_DATE,
362 p_ql_created_by IN NUMBER := FND_API.G_MISS_NUM,
363 p_ql_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
364 p_ql_last_update_date IN DATE := FND_API.G_MISS_DATE,
365 p_ql_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
366 p_ql_request_id IN NUMBER := FND_API.G_MISS_NUM,
367 p_ql_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
368 p_ql_program_id IN NUMBER := FND_API.G_MISS_NUM,
369 p_ql_program_update_date IN DATE := FND_API.G_MISS_DATE,
370 p_ql_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
371 p_ql_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
372 p_ql_org_id IN NUMBER := FND_API.G_MISS_NUM,
373 p_ql_line_number IN NUMBER := FND_API.G_MISS_NUM,
374 p_ql_line_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
375 p_ql_item_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376 p_ql_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
377 p_ql_organization_id IN NUMBER := FND_API.G_MISS_NUM,
378 p_ql_quantity IN NUMBER := FND_API.G_MISS_NUM,
379 p_ql_uom_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
380 p_ql_start_date_active IN DATE := FND_API.G_MISS_DATE,
381 p_ql_end_date_active IN DATE := FND_API.G_MISS_DATE,
382 p_ql_order_line_type_id IN NUMBER := FND_API.G_MISS_NUM,
383 p_ql_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
384 p_ql_price_list_line_id IN NUMBER := FND_API.G_MISS_NUM,
385 p_ql_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
386 p_ql_line_list_price IN NUMBER := FND_API.G_MISS_NUM,
387 p_ql_line_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
388 p_ql_line_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
389 p_ql_line_quote_price IN NUMBER := FND_API.G_MISS_NUM,
390 p_ql_related_item_id IN NUMBER := FND_API.G_MISS_NUM,
391 p_ql_item_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
392 p_ql_split_shipment_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
393 p_ql_backorder_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
394 p_ql_selling_price_change IN VARCHAR2 := FND_API.G_MISS_CHAR,
398 p_ql_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
395 p_ql_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
396 p_ql_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
397 p_ql_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
399 p_ql_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
400 p_ql_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
401 p_ql_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
402 p_ql_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
403 p_ql_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
404 p_ql_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
405 p_ql_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
406 p_ql_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
407 p_ql_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
408 p_ql_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
409 p_ql_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
410 p_ql_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
411 p_ql_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
412 p_ql_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
413 p_ql_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
414 p_ql_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
415 p_ql_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
416 p_ql_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
417 p_ql_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
418 p_ql_ffm_content_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
419 p_ql_ffm_content_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
420 p_ql_ffm_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421 p_ql_ffm_media_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
425 p_ql_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
422 p_ql_ffm_media_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
423 p_ql_ffm_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
424 p_ql_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
426 p_ql_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
427 p_ql_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
428 p_ql_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
429 p_ql_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
430 p_ql_pricing_quantity_uom IN VARCHAR2 := FND_API.G_MISS_CHAR,
431 p_ql_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
432 p_ql_section_id IN NUMBER := FND_API.G_MISS_NUM,
433 p_ql_priced_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
434 p_ql_agreement_id IN NUMBER := FND_API.G_MISS_NUM,
435 p_ql_commitment_id IN NUMBER := FND_API.G_MISS_NUM,
436 p_ql_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
437 p_ql_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
438 p_ql_ship_model_complete_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
439 p_ql_charge_periodicity_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
440 p_ql_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
441 p_ql_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
442 p_ql_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
443 p_ql_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
444 p_ql_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
445 p_ql_line_paynow_charges IN NUMBER := FND_API.G_MISS_NUM,
446 p_ql_line_paynow_tax IN NUMBER := FND_API.G_MISS_NUM,
447 p_ql_line_paynow_subtotal IN NUMBER := FND_API.G_MISS_NUM,
448 p_ql_config_model_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
449 p_qln_mis_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453 p_qls_creation_date IN DATE := FND_API.G_MISS_DATE,
450 p_qls_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
451 p_qls_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
452 p_qls_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
454 p_qls_created_by IN NUMBER := FND_API.G_MISS_NUM,
455 p_qls_last_update_date IN DATE := FND_API.G_MISS_DATE,
456 p_qls_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
457 p_qls_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
458 p_qls_request_id IN NUMBER := FND_API.G_MISS_NUM,
459 p_qls_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
460 p_qls_program_id IN NUMBER := FND_API.G_MISS_NUM,
461 p_qls_program_update_date IN DATE := FND_API.G_MISS_DATE,
462 p_qls_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
463 p_qls_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
464 p_qls_promise_date IN DATE := FND_API.G_MISS_DATE,
465 p_qls_request_date IN DATE := FND_API.G_MISS_DATE,
466 p_qls_schedule_ship_date IN DATE := FND_API.G_MISS_DATE,
467 p_qls_ship_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
468 p_qls_ship_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
469 p_qls_ship_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
470 p_qls_ship_partial_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
471 p_qls_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,
472 p_qls_ship_method_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
473 p_qls_freight_terms_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
474 p_qls_freight_carrier_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
475 p_qls_fob_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
476 p_qls_shipping_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
477 p_qls_packing_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
478 p_qls_quantity IN NUMBER := FND_API.G_MISS_NUM,
479 p_qls_reserved_quantity IN VARCHAR2 := FND_API.G_MISS_CHAR,
480 p_qls_reservation_id IN NUMBER := FND_API.G_MISS_NUM,
481 p_qls_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
482 p_qls_ship_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
483 p_qls_ship_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
484 p_qls_ship_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
485 p_qls_ship_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
486 p_qls_ship_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
487 p_qls_ship_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
488 p_qls_ship_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
489 p_qls_ship_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
490 p_qls_ship_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
491 p_qls_ship_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
492 p_qls_ship_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
493 p_qls_ship_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
494 p_qls_ship_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
495 p_qls_ship_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
496 p_qls_ship_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
497 p_qls_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
498 p_qls_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499 p_qls_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500 p_qls_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501 p_qls_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
502 p_qls_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
506 p_qls_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
503 p_qls_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
504 p_qls_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
505 p_qls_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
507 p_qls_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
508 p_qls_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
509 p_qls_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
510 p_qls_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
511 p_qls_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
512 p_qls_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
513 p_qls_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
514 p_qls_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
515 p_qls_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
516 p_qls_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
517 p_qls_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
518 p_qls_ship_quote_price IN NUMBER := FND_API.G_MISS_NUM,
519 p_qls_pricing_quantity IN NUMBER := FND_API.G_MISS_NUM,
520 p_qls_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
521 p_qls_ship_from_org_id IN NUMBER := FND_API.G_MISS_NUM,
522 p_qls_ship_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
523 p_qls_request_date_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
524 p_qls_demand_class_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
525 p_qls_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
526 p_qlp_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
527 p_qlp_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
528 p_qlp_payment_id IN NUMBER := FND_API.G_MISS_NUM,
529 p_qlp_creation_date IN DATE := FND_API.G_MISS_DATE,
530 p_qlp_created_by IN NUMBER := FND_API.G_MISS_NUM,
531 p_qlp_last_update_date IN DATE := FND_API.G_MISS_DATE,
532 p_qlp_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
533 p_qlp_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
534 p_qlp_request_id IN NUMBER := FND_API.G_MISS_NUM,
535 p_qlp_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
536 p_qlp_program_id IN NUMBER := FND_API.G_MISS_NUM,
537 p_qlp_program_update_date IN DATE := FND_API.G_MISS_DATE,
538 p_qlp_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
539 p_qlp_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
540 p_qlp_payment_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
541 p_qlp_payment_ref_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
542 p_qlp_payment_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
543 p_qlp_payment_term_id IN NUMBER := FND_API.G_MISS_NUM,
544 p_qlp_credit_card_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
545 p_qlp_credit_card_holder_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
546 p_qlp_credit_card_exp_date IN DATE := FND_API.G_MISS_DATE,
547 p_qlp_credit_card_aprv_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
548 p_qlp_credit_card_aprv_date IN DATE := FND_API.G_MISS_DATE,
549 p_qlp_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
550 p_qlp_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
551 p_qlp_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
552 p_qlp_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
553 p_qlp_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
554 p_qlp_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
555 p_qlp_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
556 p_qlp_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
557 p_qlp_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
558 p_qlp_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
559 p_qlp_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
560 p_qlp_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
561 p_qlp_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
562 p_qlp_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
563 p_qlp_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
567 p_qlp_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
564 p_qlp_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
565 p_qlp_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
566 p_qlp_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
568 p_qlp_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
569 p_qlp_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
570 p_qlp_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
571 p_qlp_shipment_index IN NUMBER := FND_API.G_MISS_NUM,
572 p_qlp_quote_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
573 p_qlp_cust_po_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
574 p_qlp_cust_po_line_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
575 p_qlp_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
576 p_qlp_trxn_extension_id IN NUMBER := FND_API.G_MISS_NUM,
577 p_qlp_instrument_id IN NUMBER := FND_API.G_MISS_NUM,
578 p_qlp_instr_assignment_id IN NUMBER := FND_API.G_MISS_NUM,
579 p_qlp_cvv2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
580 p_qlt_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
581 p_qlt_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
582 p_qlt_shipment_index IN NUMBER := FND_API.G_MISS_NUM,
583 p_qlt_tax_detail_id IN NUMBER := FND_API.G_MISS_NUM,
584 p_qlt_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
585 p_qlt_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
586 p_qlt_quote_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
587 p_qlt_creation_date IN DATE := FND_API.G_MISS_DATE,
588 p_qlt_created_by IN NUMBER := FND_API.G_MISS_NUM,
592 p_qlt_request_id IN NUMBER := FND_API.G_MISS_NUM,
589 p_qlt_last_update_date IN DATE := FND_API.G_MISS_DATE,
590 p_qlt_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
591 p_qlt_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
593 p_qlt_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
594 p_qlt_program_id IN NUMBER := FND_API.G_MISS_NUM,
595 p_qlt_program_update_date IN DATE := FND_API.G_MISS_DATE,
596 p_qlt_orig_tax_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
600 p_qlt_tax_amount IN NUMBER := FND_API.G_MISS_NUM,
597 p_qlt_tax_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
598 p_qlt_tax_rate IN NUMBER := FND_API.G_MISS_NUM,
599 p_qlt_tax_date IN DATE := FND_API.G_MISS_DATE,
601 p_qlt_tax_exempt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
602 p_qlt_tax_exempt_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
603 p_qlt_tax_exempt_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
604 p_qlt_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
605 p_qlt_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
606 p_qlt_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
607 p_qlt_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
608 p_qlt_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
612 p_qlt_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
609 p_qlt_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
610 p_qlt_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
611 p_qlt_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
613 p_qlt_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
614 p_qlt_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
615 p_qlt_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
616 p_qlt_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
617 p_qlt_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
618 p_qlt_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
619 p_qlt_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
620 p_qlt_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
621 p_qlt_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
622 p_qlt_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
623 p_qlt_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
624 p_qlt_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
625 p_qlt_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
626 p_qlt_tax_rate_id IN NUMBER := FND_API.G_MISS_NUM,
627 x_q_quote_header_id OUT NOCOPY NUMBER,
628 x_q_creation_date OUT NOCOPY DATE,
629 x_q_created_by OUT NOCOPY NUMBER,
630 x_q_last_updated_by OUT NOCOPY NUMBER,
631 x_q_last_update_date OUT NOCOPY DATE,
632 x_q_last_update_login OUT NOCOPY NUMBER,
633 x_q_request_id OUT NOCOPY NUMBER,
634 x_q_program_application_id OUT NOCOPY NUMBER,
635 x_q_program_id OUT NOCOPY NUMBER,
636 x_q_program_update_date OUT NOCOPY DATE,
637 x_q_org_id OUT NOCOPY NUMBER,
638 x_q_quote_name OUT NOCOPY VARCHAR2,
639 x_q_quote_number OUT NOCOPY NUMBER,
640 x_q_quote_version OUT NOCOPY NUMBER,
641 x_q_quote_status_id OUT NOCOPY NUMBER,
642 x_q_quote_source_code OUT NOCOPY VARCHAR2,
643 x_q_quote_expiration_date OUT NOCOPY DATE,
644 x_q_price_frozen_date OUT NOCOPY DATE,
645 x_q_quote_password OUT NOCOPY VARCHAR2,
646 x_q_original_system_reference OUT NOCOPY VARCHAR2,
647 x_q_party_id OUT NOCOPY NUMBER,
648 x_q_cust_account_id OUT NOCOPY NUMBER,
649 x_q_invoice_to_cust_acct_id OUT NOCOPY NUMBER,
650 x_q_org_contact_id OUT NOCOPY NUMBER,
651 x_q_party_name OUT NOCOPY VARCHAR2,
652 x_q_party_type OUT NOCOPY VARCHAR2,
653 x_q_person_first_name OUT NOCOPY VARCHAR2,
654 x_q_person_last_name OUT NOCOPY VARCHAR2,
655 x_q_person_middle_name OUT NOCOPY VARCHAR2,
656 x_q_phone_id OUT NOCOPY NUMBER,
657 x_q_price_list_id OUT NOCOPY NUMBER,
658 x_q_price_list_name OUT NOCOPY VARCHAR2,
659 x_q_currency_code OUT NOCOPY VARCHAR2,
660 x_q_total_list_price OUT NOCOPY NUMBER,
661 x_q_total_adjusted_amount OUT NOCOPY NUMBER,
662 x_q_total_adjusted_percent OUT NOCOPY NUMBER,
663 x_q_total_tax OUT NOCOPY NUMBER,
664 x_q_total_shipping_charge OUT NOCOPY NUMBER,
665 x_q_surcharge OUT NOCOPY NUMBER,
666 x_q_total_quote_price OUT NOCOPY NUMBER,
667 x_q_payment_amount OUT NOCOPY NUMBER,
668 x_q_accounting_rule_id OUT NOCOPY NUMBER,
669 x_q_exchange_rate OUT NOCOPY NUMBER,
673 x_q_quote_status_code OUT NOCOPY VARCHAR2,
670 x_q_exchange_type_code OUT NOCOPY VARCHAR2,
671 x_q_exchange_rate_date OUT NOCOPY DATE,
672 x_q_quote_category_code OUT NOCOPY VARCHAR2,
674 x_q_quote_status OUT NOCOPY VARCHAR2,
675 x_q_employee_person_id OUT NOCOPY NUMBER,
679 x_q_attribute_category OUT NOCOPY VARCHAR2,
676 x_q_sales_channel_code OUT NOCOPY VARCHAR2,
677 x_q_salesrep_first_name OUT NOCOPY VARCHAR2,
678 x_q_salesrep_last_name OUT NOCOPY VARCHAR2,
680 x_q_attribute1 OUT NOCOPY VARCHAR2,
681 x_q_attribute10 OUT NOCOPY VARCHAR2,
682 x_q_attribute11 OUT NOCOPY VARCHAR2,
683 x_q_attribute12 OUT NOCOPY VARCHAR2,
684 x_q_attribute13 OUT NOCOPY VARCHAR2,
685 x_q_attribute14 OUT NOCOPY VARCHAR2,
686 x_q_attribute15 OUT NOCOPY VARCHAR2,
687 x_q_attribute16 OUT NOCOPY VARCHAR2,
688 x_q_attribute17 OUT NOCOPY VARCHAR2,
689 x_q_attribute18 OUT NOCOPY VARCHAR2,
690 x_q_attribute19 OUT NOCOPY VARCHAR2,
691 x_q_attribute20 OUT NOCOPY VARCHAR2,
692 x_q_attribute2 OUT NOCOPY VARCHAR2,
693 x_q_attribute3 OUT NOCOPY VARCHAR2,
694 x_q_attribute4 OUT NOCOPY VARCHAR2,
695 x_q_attribute5 OUT NOCOPY VARCHAR2,
696 x_q_attribute6 OUT NOCOPY VARCHAR2,
697 x_q_attribute7 OUT NOCOPY VARCHAR2,
698 x_q_attribute8 OUT NOCOPY VARCHAR2,
699 x_q_attribute9 OUT NOCOPY VARCHAR2,
700 x_q_contract_id OUT NOCOPY NUMBER,
701 x_q_qte_contract_id OUT NOCOPY NUMBER,
702 x_q_ffm_request_id OUT NOCOPY NUMBER,
703 x_q_invoice_to_address1 OUT NOCOPY VARCHAR2,
704 x_q_invoice_to_address2 OUT NOCOPY VARCHAR2,
705 x_q_invoice_to_address3 OUT NOCOPY VARCHAR2,
706 x_q_invoice_to_address4 OUT NOCOPY VARCHAR2,
707 x_q_invoice_to_city OUT NOCOPY VARCHAR2,
708 x_q_invoice_to_cont_first_name OUT NOCOPY VARCHAR2,
709 x_q_invoice_to_cont_last_name OUT NOCOPY VARCHAR2,
710 x_q_invoice_to_cont_mid_name OUT NOCOPY VARCHAR2,
711 x_q_invoice_to_country_code OUT NOCOPY VARCHAR2,
712 x_q_invoice_to_country OUT NOCOPY VARCHAR2,
713 x_q_invoice_to_county OUT NOCOPY VARCHAR2,
714 x_q_invoice_to_party_id OUT NOCOPY NUMBER,
715 x_q_invoice_to_party_name OUT NOCOPY VARCHAR2,
716 x_q_invoice_to_party_site_id OUT NOCOPY NUMBER,
717 x_q_invoice_to_postal_code OUT NOCOPY VARCHAR2,
718 x_q_invoice_to_province OUT NOCOPY VARCHAR2,
719 x_q_invoice_to_state OUT NOCOPY VARCHAR2,
720 x_q_invoicing_rule_id OUT NOCOPY NUMBER,
721 x_q_marketing_source_code_id OUT NOCOPY NUMBER,
722 x_q_marketing_source_code OUT NOCOPY VARCHAR2,
723 x_q_marketing_source_name OUT NOCOPY VARCHAR2,
724 x_q_orig_mktg_source_code_id OUT NOCOPY NUMBER,
725 x_q_order_type_id OUT NOCOPY NUMBER,
726 x_q_order_id OUT NOCOPY NUMBER,
727 x_q_order_number OUT NOCOPY NUMBER,
728 x_q_order_type_name OUT NOCOPY VARCHAR2,
729 x_q_ordered_date OUT NOCOPY DATE,
730 x_q_resource_id OUT NOCOPY NUMBER,
731 x_q_contract_template_id OUT NOCOPY NUMBER,
735 x_q_publish_flag OUT NOCOPY VARCHAR2,
732 x_q_contract_template_maj_ver OUT NOCOPY NUMBER,
733 x_q_contract_requester_id OUT NOCOPY NUMBER,
734 x_q_contract_approval_level OUT NOCOPY VARCHAR2,
736 x_q_resource_grp_id OUT NOCOPY NUMBER,
737 x_q_sold_to_party_site_id OUT NOCOPY NUMBER,
738 x_q_display_arithmetic_op OUT NOCOPY VARCHAR2,
739 x_q_quote_description OUT NOCOPY VARCHAR2,
740 x_q_quote_type OUT NOCOPY VARCHAR2,
741 x_q_minisite_id OUT NOCOPY NUMBER,
742 x_q_cust_party_id OUT NOCOPY NUMBER,
743 x_q_invoice_to_cust_party_id OUT NOCOPY NUMBER,
744 x_q_pricing_status_indicator OUT NOCOPY VARCHAR2,
745 x_q_tax_status_indicator OUT NOCOPY VARCHAR2,
746 x_q_price_updated_date OUT NOCOPY DATE,
747 x_q_tax_updated_date OUT NOCOPY DATE,
748 x_q_recalculate_flag OUT NOCOPY VARCHAR2,
749 x_q_price_request_id OUT NOCOPY NUMBER,
750 x_q_credit_update_date OUT NOCOPY DATE,
751 x_q_customer_name_and_title OUT NOCOPY VARCHAR2,
752 x_q_customer_signature_date OUT NOCOPY DATE,
753 x_q_supplier_name_and_title OUT NOCOPY VARCHAR2,
754 x_q_supplier_signature_date OUT NOCOPY DATE,
755 x_q_end_cust_party_id OUT NOCOPY NUMBER,
756 x_q_end_cust_party_site_id OUT NOCOPY NUMBER,
757 x_q_end_cust_cust_account_id OUT NOCOPY NUMBER,
758 x_q_end_cust_cust_party_id OUT NOCOPY NUMBER,
759 x_q_automatic_price_flag OUT NOCOPY VARCHAR2,
760 x_q_automatic_tax_flag OUT NOCOPY VARCHAR2,
761 x_q_assistance_requested OUT NOCOPY VARCHAR2,
762 x_q_assistance_reason_code OUT NOCOPY VARCHAR2,
763 x_q_object_version_number OUT NOCOPY NUMBER,
764 x_q_header_paynow_charges OUT NOCOPY NUMBER,
765 x_q_mis_attribute1 OUT NOCOPY VARCHAR2,
766 x_qs_operation_code OUT NOCOPY VARCHAR2,
767 x_qs_qte_line_index OUT NOCOPY NUMBER,
768 x_qs_shipment_id OUT NOCOPY NUMBER,
769 x_qs_creation_date OUT NOCOPY DATE,
770 x_qs_created_by OUT NOCOPY NUMBER,
771 x_qs_last_update_date OUT NOCOPY DATE,
772 x_qs_last_updated_by OUT NOCOPY NUMBER,
773 x_qs_last_update_login OUT NOCOPY NUMBER,
774 x_qs_request_id OUT NOCOPY NUMBER,
775 x_qs_program_application_id OUT NOCOPY NUMBER,
776 x_qs_program_id OUT NOCOPY NUMBER,
777 x_qs_program_update_date OUT NOCOPY DATE,
778 x_qs_quote_header_id OUT NOCOPY NUMBER,
779 x_qs_quote_line_id OUT NOCOPY NUMBER,
780 x_qs_promise_date OUT NOCOPY DATE,
781 x_qs_request_date OUT NOCOPY DATE,
782 x_qs_schedule_ship_date OUT NOCOPY DATE,
783 x_qs_ship_to_party_site_id OUT NOCOPY NUMBER,
784 x_qs_ship_to_party_id OUT NOCOPY NUMBER,
785 x_qs_ship_to_cust_account_id OUT NOCOPY NUMBER,
786 x_qs_ship_partial_flag OUT NOCOPY VARCHAR2,
787 x_qs_ship_set_id OUT NOCOPY NUMBER,
788 x_qs_ship_method_code OUT NOCOPY VARCHAR2,
789 x_qs_freight_terms_code OUT NOCOPY VARCHAR2,
790 x_qs_freight_carrier_code OUT NOCOPY VARCHAR2,
791 x_qs_fob_code OUT NOCOPY VARCHAR2,
792 x_qs_shipping_instructions OUT NOCOPY VARCHAR2,
793 x_qs_packing_instructions OUT NOCOPY VARCHAR2,
794 x_qs_quantity OUT NOCOPY NUMBER,
795 x_qs_reserved_quantity OUT NOCOPY VARCHAR2,
796 x_qs_reservation_id OUT NOCOPY NUMBER,
797 x_qs_order_line_id OUT NOCOPY NUMBER,
798 x_qs_ship_to_party_name OUT NOCOPY VARCHAR2,
799 x_qs_ship_to_cont_first_name OUT NOCOPY VARCHAR2,
800 x_qs_ship_to_cont_mid_name OUT NOCOPY VARCHAR2,
801 x_qs_ship_to_cont_last_name OUT NOCOPY VARCHAR2,
802 x_qs_ship_to_address1 OUT NOCOPY VARCHAR2,
803 x_qs_ship_to_address2 OUT NOCOPY VARCHAR2,
804 x_qs_ship_to_address3 OUT NOCOPY VARCHAR2,
805 x_qs_ship_to_address4 OUT NOCOPY VARCHAR2,
806 x_qs_ship_to_country_code OUT NOCOPY VARCHAR2,
807 x_qs_ship_to_country OUT NOCOPY VARCHAR2,
808 x_qs_ship_to_city OUT NOCOPY VARCHAR2,
809 x_qs_ship_to_postal_code OUT NOCOPY VARCHAR2,
810 x_qs_ship_to_state OUT NOCOPY VARCHAR2,
811 x_qs_ship_to_province OUT NOCOPY VARCHAR2,
812 x_qs_ship_to_county OUT NOCOPY VARCHAR2,
813 x_qs_attribute_category OUT NOCOPY VARCHAR2,
814 x_qs_attribute1 OUT NOCOPY VARCHAR2,
815 x_qs_attribute2 OUT NOCOPY VARCHAR2,
816 x_qs_attribute3 OUT NOCOPY VARCHAR2,
817 x_qs_attribute4 OUT NOCOPY VARCHAR2,
818 x_qs_attribute5 OUT NOCOPY VARCHAR2,
819 x_qs_attribute6 OUT NOCOPY VARCHAR2,
820 x_qs_attribute7 OUT NOCOPY VARCHAR2,
821 x_qs_attribute8 OUT NOCOPY VARCHAR2,
822 x_qs_attribute9 OUT NOCOPY VARCHAR2,
823 x_qs_attribute10 OUT NOCOPY VARCHAR2,
824 x_qs_attribute11 OUT NOCOPY VARCHAR2,
825 x_qs_attribute12 OUT NOCOPY VARCHAR2,
826 x_qs_attribute13 OUT NOCOPY VARCHAR2,
827 x_qs_attribute14 OUT NOCOPY VARCHAR2,
828 x_qs_attribute15 OUT NOCOPY VARCHAR2,
829 x_qs_attribute16 OUT NOCOPY VARCHAR2,
830 x_qs_attribute17 OUT NOCOPY VARCHAR2,
834 x_qs_ship_quote_price OUT NOCOPY NUMBER,
831 x_qs_attribute18 OUT NOCOPY VARCHAR2,
832 x_qs_attribute19 OUT NOCOPY VARCHAR2,
833 x_qs_attribute20 OUT NOCOPY VARCHAR2,
835 x_qs_pricing_quantity OUT NOCOPY NUMBER,
836 x_qs_shipment_priority_code OUT NOCOPY VARCHAR2,
837 x_qs_ship_from_org_id OUT NOCOPY NUMBER,
838 x_qs_ship_to_cust_party_id OUT NOCOPY NUMBER,
839 x_qs_request_date_type OUT NOCOPY VARCHAR2,
840 x_qs_demand_class_code OUT NOCOPY VARCHAR2,
841 x_qs_object_version_number OUT NOCOPY NUMBER,
842 x_qp_operation_code OUT NOCOPY VARCHAR2,
843 x_qp_qte_line_index OUT NOCOPY NUMBER,
844 x_qp_payment_id OUT NOCOPY NUMBER,
845 x_qp_creation_date OUT NOCOPY DATE,
846 x_qp_created_by OUT NOCOPY NUMBER,
847 x_qp_last_update_date OUT NOCOPY DATE,
848 x_qp_last_updated_by OUT NOCOPY NUMBER,
849 x_qp_last_update_login OUT NOCOPY NUMBER,
850 x_qp_request_id OUT NOCOPY NUMBER,
851 x_qp_program_application_id OUT NOCOPY NUMBER,
852 x_qp_program_id OUT NOCOPY NUMBER,
853 x_qp_program_update_date OUT NOCOPY DATE,
854 x_qp_quote_header_id OUT NOCOPY NUMBER,
855 x_qp_quote_line_id OUT NOCOPY NUMBER,
856 x_qp_payment_type_code OUT NOCOPY VARCHAR2,
857 x_qp_payment_ref_number OUT NOCOPY VARCHAR2,
858 x_qp_payment_option OUT NOCOPY VARCHAR2,
859 x_qp_payment_term_id OUT NOCOPY NUMBER,
860 x_qp_credit_card_code OUT NOCOPY VARCHAR2,
861 x_qp_credit_card_holder_name OUT NOCOPY VARCHAR2,
862 x_qp_credit_card_exp_date OUT NOCOPY DATE,
863 x_qp_credit_card_aprv_code OUT NOCOPY VARCHAR2,
864 x_qp_credit_card_aprv_date OUT NOCOPY DATE,
865 x_qp_payment_amount OUT NOCOPY NUMBER,
866 x_qp_attribute_category OUT NOCOPY VARCHAR2,
867 x_qp_attribute1 OUT NOCOPY VARCHAR2,
868 x_qp_attribute2 OUT NOCOPY VARCHAR2,
869 x_qp_attribute3 OUT NOCOPY VARCHAR2,
870 x_qp_attribute4 OUT NOCOPY VARCHAR2,
871 x_qp_attribute5 OUT NOCOPY VARCHAR2,
872 x_qp_attribute6 OUT NOCOPY VARCHAR2,
873 x_qp_attribute7 OUT NOCOPY VARCHAR2,
874 x_qp_attribute8 OUT NOCOPY VARCHAR2,
875 x_qp_attribute9 OUT NOCOPY VARCHAR2,
876 x_qp_attribute10 OUT NOCOPY VARCHAR2,
877 x_qp_attribute11 OUT NOCOPY VARCHAR2,
878 x_qp_attribute12 OUT NOCOPY VARCHAR2,
879 x_qp_attribute13 OUT NOCOPY VARCHAR2,
880 x_qp_attribute14 OUT NOCOPY VARCHAR2,
881 x_qp_attribute15 OUT NOCOPY VARCHAR2,
882 x_qp_attribute16 OUT NOCOPY VARCHAR2,
883 x_qp_attribute17 OUT NOCOPY VARCHAR2,
884 x_qp_attribute18 OUT NOCOPY VARCHAR2,
885 x_qp_attribute19 OUT NOCOPY VARCHAR2,
886 x_qp_attribute20 OUT NOCOPY VARCHAR2,
887 x_qp_shipment_index OUT NOCOPY NUMBER,
888 x_qp_quote_shipment_id OUT NOCOPY NUMBER,
889 x_qp_cust_po_number OUT NOCOPY VARCHAR2,
890 x_qp_cust_po_line_number OUT NOCOPY VARCHAR2,
891 x_qp_object_version_number OUT NOCOPY NUMBER,
892 x_qp_trxn_extension_id OUT NOCOPY NUMBER,
893 x_qp_instrument_id OUT NOCOPY NUMBER,
894 x_qp_instr_assignment_id OUT NOCOPY NUMBER,
895 x_qp_cvv2 OUT NOCOPY VARCHAR2,
896 x_qt_operation_code OUT NOCOPY VARCHAR2,
897 x_qt_qte_line_index OUT NOCOPY NUMBER,
901 x_qt_quote_line_id OUT NOCOPY NUMBER,
898 x_qt_shipment_index OUT NOCOPY NUMBER,
899 x_qt_tax_detail_id OUT NOCOPY NUMBER,
900 x_qt_quote_header_id OUT NOCOPY NUMBER,
902 x_qt_quote_shipment_id OUT NOCOPY NUMBER,
903 x_qt_creation_date OUT NOCOPY DATE,
904 x_qt_created_by OUT NOCOPY NUMBER,
905 x_qt_last_update_date OUT NOCOPY DATE,
906 x_qt_last_updated_by OUT NOCOPY NUMBER,
907 x_qt_last_update_login OUT NOCOPY NUMBER,
908 x_qt_request_id OUT NOCOPY NUMBER,
909 x_qt_program_application_id OUT NOCOPY NUMBER,
910 x_qt_program_id OUT NOCOPY NUMBER,
911 x_qt_program_update_date OUT NOCOPY DATE,
912 x_qt_orig_tax_code OUT NOCOPY VARCHAR2,
913 x_qt_tax_code OUT NOCOPY VARCHAR2,
914 x_qt_tax_rate OUT NOCOPY NUMBER,
915 x_qt_tax_date OUT NOCOPY DATE,
916 x_qt_tax_amount OUT NOCOPY NUMBER,
917 x_qt_tax_exempt_flag OUT NOCOPY VARCHAR2,
918 x_qt_tax_exempt_number OUT NOCOPY VARCHAR2,
919 x_qt_tax_exempt_reason_code OUT NOCOPY VARCHAR2,
920 x_qt_attribute_category OUT NOCOPY VARCHAR2,
921 x_qt_attribute1 OUT NOCOPY VARCHAR2,
922 x_qt_attribute2 OUT NOCOPY VARCHAR2,
923 x_qt_attribute3 OUT NOCOPY VARCHAR2,
924 x_qt_attribute4 OUT NOCOPY VARCHAR2,
925 x_qt_attribute5 OUT NOCOPY VARCHAR2,
926 x_qt_attribute6 OUT NOCOPY VARCHAR2,
927 x_qt_attribute7 OUT NOCOPY VARCHAR2,
928 x_qt_attribute8 OUT NOCOPY VARCHAR2,
929 x_qt_attribute9 OUT NOCOPY VARCHAR2,
933 x_qt_attribute13 OUT NOCOPY VARCHAR2,
930 x_qt_attribute10 OUT NOCOPY VARCHAR2,
931 x_qt_attribute11 OUT NOCOPY VARCHAR2,
932 x_qt_attribute12 OUT NOCOPY VARCHAR2,
934 x_qt_attribute14 OUT NOCOPY VARCHAR2,
935 x_qt_attribute15 OUT NOCOPY VARCHAR2,
936 x_qt_attribute16 OUT NOCOPY VARCHAR2,
937 x_qt_attribute17 OUT NOCOPY VARCHAR2,
938 x_qt_attribute18 OUT NOCOPY VARCHAR2,
939 x_qt_attribute19 OUT NOCOPY VARCHAR2,
940 x_qt_attribute20 OUT NOCOPY VARCHAR2,
941 x_qt_object_version_number OUT NOCOPY NUMBER,
942 x_qt_tax_rate_id OUT NOCOPY NUMBER,
943 x_ql_creation_date OUT NOCOPY DATE,
944 x_ql_created_by OUT NOCOPY NUMBER,
945 x_ql_last_updated_by OUT NOCOPY NUMBER,
946 x_ql_last_update_date OUT NOCOPY DATE,
947 x_ql_last_update_login OUT NOCOPY NUMBER,
948 x_ql_request_id OUT NOCOPY NUMBER,
949 x_ql_program_application_id OUT NOCOPY NUMBER,
950 x_ql_program_id OUT NOCOPY NUMBER,
951 x_ql_program_update_date OUT NOCOPY DATE,
952 x_ql_quote_line_id OUT NOCOPY NUMBER,
953 x_ql_quote_header_id OUT NOCOPY NUMBER,
954 x_ql_org_id OUT NOCOPY NUMBER,
955 x_ql_line_number OUT NOCOPY NUMBER,
956 x_ql_line_category_code OUT NOCOPY VARCHAR2,
957 x_ql_item_type_code OUT NOCOPY VARCHAR2,
958 x_ql_inventory_item_id OUT NOCOPY NUMBER,
959 x_ql_organization_id OUT NOCOPY NUMBER,
960 x_ql_quantity OUT NOCOPY NUMBER,
961 x_ql_uom_code OUT NOCOPY VARCHAR2,
962 x_ql_start_date_active OUT NOCOPY DATE,
963 x_ql_end_date_active OUT NOCOPY DATE,
964 x_ql_order_line_type_id OUT NOCOPY NUMBER,
965 x_ql_price_list_id OUT NOCOPY NUMBER,
966 x_ql_price_list_line_id OUT NOCOPY NUMBER,
967 x_ql_currency_code OUT NOCOPY VARCHAR2,
968 x_ql_line_list_price OUT NOCOPY NUMBER,
969 x_ql_line_adjusted_amount OUT NOCOPY NUMBER,
970 x_ql_line_adjusted_percent OUT NOCOPY NUMBER,
971 x_ql_line_quote_price OUT NOCOPY NUMBER,
972 x_ql_related_item_id OUT NOCOPY NUMBER,
973 x_ql_item_relationship_type OUT NOCOPY VARCHAR2,
974 x_ql_split_shipment_flag OUT NOCOPY VARCHAR2,
975 x_ql_backorder_flag OUT NOCOPY VARCHAR2,
976 x_ql_selling_price_change OUT NOCOPY VARCHAR2,
977 x_ql_recalculate_flag OUT NOCOPY VARCHAR2,
978 x_ql_attribute_category OUT NOCOPY VARCHAR2,
979 x_ql_attribute1 OUT NOCOPY VARCHAR2,
980 x_ql_attribute2 OUT NOCOPY VARCHAR2,
981 x_ql_attribute3 OUT NOCOPY VARCHAR2,
982 x_ql_attribute4 OUT NOCOPY VARCHAR2,
983 x_ql_attribute5 OUT NOCOPY VARCHAR2,
984 x_ql_attribute6 OUT NOCOPY VARCHAR2,
985 x_ql_attribute7 OUT NOCOPY VARCHAR2,
986 x_ql_attribute8 OUT NOCOPY VARCHAR2,
987 x_ql_attribute9 OUT NOCOPY VARCHAR2,
988 x_ql_attribute10 OUT NOCOPY VARCHAR2,
989 x_ql_attribute11 OUT NOCOPY VARCHAR2,
990 x_ql_attribute12 OUT NOCOPY VARCHAR2,
991 x_ql_attribute13 OUT NOCOPY VARCHAR2,
992 x_ql_attribute14 OUT NOCOPY VARCHAR2,
993 x_ql_attribute15 OUT NOCOPY VARCHAR2,
994 x_ql_attribute16 OUT NOCOPY VARCHAR2,
995 x_ql_attribute17 OUT NOCOPY VARCHAR2,
996 x_ql_attribute18 OUT NOCOPY VARCHAR2,
997 x_ql_attribute19 OUT NOCOPY VARCHAR2,
998 x_ql_attribute20 OUT NOCOPY VARCHAR2,
999 x_ql_accounting_rule_id OUT NOCOPY NUMBER,
1000 x_ql_ffm_content_name OUT NOCOPY VARCHAR2,
1001 x_ql_ffm_content_type OUT NOCOPY VARCHAR2,
1002 x_ql_ffm_document_type OUT NOCOPY VARCHAR2,
1003 x_ql_ffm_media_id OUT NOCOPY VARCHAR2,
1004 x_ql_ffm_media_type OUT NOCOPY VARCHAR2,
1005 x_ql_ffm_user_note OUT NOCOPY VARCHAR2,
1006 x_ql_invoice_to_party_id OUT NOCOPY NUMBER,
1007 x_ql_invoice_to_party_site_id OUT NOCOPY NUMBER,
1008 x_ql_invoicing_rule_id OUT NOCOPY NUMBER,
1009 x_ql_marketing_source_code_id OUT NOCOPY NUMBER,
1010 x_ql_operation_code OUT NOCOPY VARCHAR2,
1011 x_ql_invoice_to_cust_acct_id OUT NOCOPY NUMBER,
1012 x_ql_pricing_quantity_uom OUT NOCOPY VARCHAR2,
1013 x_ql_minisite_id OUT NOCOPY NUMBER,
1014 x_ql_section_id OUT NOCOPY NUMBER,
1015 x_ql_priced_price_list_id OUT NOCOPY NUMBER,
1016 x_ql_agreement_id OUT NOCOPY NUMBER,
1017 x_ql_commitment_id OUT NOCOPY NUMBER,
1018 x_ql_display_arithmetic_op OUT NOCOPY VARCHAR2,
1019 x_ql_invoice_to_cust_party_id OUT NOCOPY NUMBER,
1020 x_ql_ship_model_complete_flag OUT NOCOPY VARCHAR2,
1021 x_ql_charge_periodicity_code OUT NOCOPY VARCHAR2,
1022 x_ql_end_cust_party_id OUT NOCOPY NUMBER,
1023 x_ql_end_cust_party_site_id OUT NOCOPY NUMBER,
1024 x_ql_end_cust_cust_account_id OUT NOCOPY NUMBER,
1025 x_ql_end_cust_cust_party_id OUT NOCOPY NUMBER,
1026 x_ql_object_version_number OUT NOCOPY NUMBER,
1027 x_ql_line_paynow_charges OUT NOCOPY NUMBER,
1028 x_ql_line_paynow_tax OUT NOCOPY NUMBER,
1029 x_ql_line_paynow_subtotal OUT NOCOPY NUMBER,
1030 x_ql_config_model_type OUT NOCOPY VARCHAR2,
1031 x_qln_mis_attribute1 OUT NOCOPY VARCHAR2,
1032 x_qls_operation_code OUT NOCOPY VARCHAR2,
1033 x_qls_qte_line_index OUT NOCOPY NUMBER,
1034 x_qls_shipment_id OUT NOCOPY NUMBER,
1035 x_qls_creation_date OUT NOCOPY DATE,
1036 x_qls_created_by OUT NOCOPY NUMBER,
1037 x_qls_last_update_date OUT NOCOPY DATE,
1038 x_qls_last_updated_by OUT NOCOPY NUMBER,
1039 x_qls_last_update_login OUT NOCOPY NUMBER,
1040 x_qls_request_id OUT NOCOPY NUMBER,
1041 x_qls_program_application_id OUT NOCOPY NUMBER,
1042 x_qls_program_id OUT NOCOPY NUMBER,
1043 x_qls_program_update_date OUT NOCOPY DATE,
1044 x_qls_quote_header_id OUT NOCOPY NUMBER,
1045 x_qls_quote_line_id OUT NOCOPY NUMBER,
1046 x_qls_promise_date OUT NOCOPY DATE,
1047 x_qls_request_date OUT NOCOPY DATE,
1048 x_qls_schedule_ship_date OUT NOCOPY DATE,
1049 x_qls_ship_to_party_site_id OUT NOCOPY NUMBER,
1050 x_qls_ship_to_party_id OUT NOCOPY NUMBER,
1051 x_qls_ship_to_cust_account_id OUT NOCOPY NUMBER,
1052 x_qls_ship_partial_flag OUT NOCOPY VARCHAR2,
1056 x_qls_freight_carrier_code OUT NOCOPY VARCHAR2,
1053 x_qls_ship_set_id OUT NOCOPY NUMBER,
1054 x_qls_ship_method_code OUT NOCOPY VARCHAR2,
1055 x_qls_freight_terms_code OUT NOCOPY VARCHAR2,
1057 x_qls_fob_code OUT NOCOPY VARCHAR2,
1058 x_qls_shipping_instructions OUT NOCOPY VARCHAR2,
1059 x_qls_packing_instructions OUT NOCOPY VARCHAR2,
1060 x_qls_quantity OUT NOCOPY NUMBER,
1061 x_qls_reserved_quantity OUT NOCOPY VARCHAR2,
1062 x_qls_reservation_id OUT NOCOPY NUMBER,
1063 x_qls_order_line_id OUT NOCOPY NUMBER,
1064 x_qls_ship_to_party_name OUT NOCOPY VARCHAR2,
1065 x_qls_ship_to_cont_first_name OUT NOCOPY VARCHAR2,
1066 x_qls_ship_to_cont_mid_name OUT NOCOPY VARCHAR2,
1067 x_qls_ship_to_cont_last_name OUT NOCOPY VARCHAR2,
1068 x_qls_ship_to_address1 OUT NOCOPY VARCHAR2,
1069 x_qls_ship_to_address2 OUT NOCOPY VARCHAR2,
1070 x_qls_ship_to_address3 OUT NOCOPY VARCHAR2,
1071 x_qls_ship_to_address4 OUT NOCOPY VARCHAR2,
1072 x_qls_ship_to_country_code OUT NOCOPY VARCHAR2,
1073 x_qls_ship_to_country OUT NOCOPY VARCHAR2,
1074 x_qls_ship_to_city OUT NOCOPY VARCHAR2,
1075 x_qls_ship_to_postal_code OUT NOCOPY VARCHAR2,
1076 x_qls_ship_to_state OUT NOCOPY VARCHAR2,
1077 x_qls_ship_to_province OUT NOCOPY VARCHAR2,
1078 x_qls_ship_to_county OUT NOCOPY VARCHAR2,
1079 x_qls_attribute_category OUT NOCOPY VARCHAR2,
1080 x_qls_attribute1 OUT NOCOPY VARCHAR2,
1081 x_qls_attribute2 OUT NOCOPY VARCHAR2,
1082 x_qls_attribute3 OUT NOCOPY VARCHAR2,
1083 x_qls_attribute4 OUT NOCOPY VARCHAR2,
1084 x_qls_attribute5 OUT NOCOPY VARCHAR2,
1085 x_qls_attribute6 OUT NOCOPY VARCHAR2,
1086 x_qls_attribute7 OUT NOCOPY VARCHAR2,
1087 x_qls_attribute8 OUT NOCOPY VARCHAR2,
1088 x_qls_attribute9 OUT NOCOPY VARCHAR2,
1089 x_qls_attribute10 OUT NOCOPY VARCHAR2,
1090 x_qls_attribute11 OUT NOCOPY VARCHAR2,
1091 x_qls_attribute12 OUT NOCOPY VARCHAR2,
1092 x_qls_attribute13 OUT NOCOPY VARCHAR2,
1093 x_qls_attribute14 OUT NOCOPY VARCHAR2,
1094 x_qls_attribute15 OUT NOCOPY VARCHAR2,
1095 x_qls_attribute16 OUT NOCOPY VARCHAR2,
1096 x_qls_attribute17 OUT NOCOPY VARCHAR2,
1097 x_qls_attribute18 OUT NOCOPY VARCHAR2,
1098 x_qls_attribute19 OUT NOCOPY VARCHAR2,
1099 x_qls_attribute20 OUT NOCOPY VARCHAR2,
1100 x_qls_ship_quote_price OUT NOCOPY NUMBER,
1101 x_qls_pricing_quantity OUT NOCOPY NUMBER,
1102 x_qls_shipment_priority_code OUT NOCOPY VARCHAR2,
1103 x_qls_ship_from_org_id OUT NOCOPY NUMBER,
1104 x_qls_ship_to_cust_party_id OUT NOCOPY NUMBER,
1105 x_qls_request_date_type OUT NOCOPY VARCHAR2,
1106 x_qls_demand_class_code OUT NOCOPY VARCHAR2,
1107 x_qls_object_version_number OUT NOCOPY NUMBER,
1111 x_qlp_creation_date OUT NOCOPY DATE,
1108 x_qlp_operation_code OUT NOCOPY VARCHAR2,
1109 x_qlp_qte_line_index OUT NOCOPY NUMBER,
1110 x_qlp_payment_id OUT NOCOPY NUMBER,
1112 x_qlp_created_by OUT NOCOPY NUMBER,
1113 x_qlp_last_update_date OUT NOCOPY DATE,
1114 x_qlp_last_updated_by OUT NOCOPY NUMBER,
1115 x_qlp_last_update_login OUT NOCOPY NUMBER,
1116 x_qlp_request_id OUT NOCOPY NUMBER,
1117 x_qlp_program_application_id OUT NOCOPY NUMBER,
1118 x_qlp_program_id OUT NOCOPY NUMBER,
1119 x_qlp_program_update_date OUT NOCOPY DATE,
1120 x_qlp_quote_header_id OUT NOCOPY NUMBER,
1121 x_qlp_quote_line_id OUT NOCOPY NUMBER,
1122 x_qlp_payment_type_code OUT NOCOPY VARCHAR2,
1123 x_qlp_payment_ref_number OUT NOCOPY VARCHAR2,
1124 x_qlp_payment_option OUT NOCOPY VARCHAR2,
1125 x_qlp_payment_term_id OUT NOCOPY NUMBER,
1126 x_qlp_credit_card_code OUT NOCOPY VARCHAR2,
1127 x_qlp_credit_card_holder_name OUT NOCOPY VARCHAR2,
1128 x_qlp_credit_card_exp_date OUT NOCOPY DATE,
1129 x_qlp_credit_card_aprv_code OUT NOCOPY VARCHAR2,
1130 x_qlp_credit_card_aprv_date OUT NOCOPY DATE,
1134 x_qlp_attribute2 OUT NOCOPY VARCHAR2,
1131 x_qlp_payment_amount OUT NOCOPY NUMBER,
1132 x_qlp_attribute_category OUT NOCOPY VARCHAR2,
1133 x_qlp_attribute1 OUT NOCOPY VARCHAR2,
1135 x_qlp_attribute3 OUT NOCOPY VARCHAR2,
1136 x_qlp_attribute4 OUT NOCOPY VARCHAR2,
1137 x_qlp_attribute5 OUT NOCOPY VARCHAR2,
1138 x_qlp_attribute6 OUT NOCOPY VARCHAR2,
1139 x_qlp_attribute7 OUT NOCOPY VARCHAR2,
1140 x_qlp_attribute8 OUT NOCOPY VARCHAR2,
1141 x_qlp_attribute9 OUT NOCOPY VARCHAR2,
1142 x_qlp_attribute10 OUT NOCOPY VARCHAR2,
1143 x_qlp_attribute11 OUT NOCOPY VARCHAR2,
1144 x_qlp_attribute12 OUT NOCOPY VARCHAR2,
1145 x_qlp_attribute13 OUT NOCOPY VARCHAR2,
1146 x_qlp_attribute14 OUT NOCOPY VARCHAR2,
1147 x_qlp_attribute15 OUT NOCOPY VARCHAR2,
1148 x_qlp_attribute16 OUT NOCOPY VARCHAR2,
1149 x_qlp_attribute17 OUT NOCOPY VARCHAR2,
1150 x_qlp_attribute18 OUT NOCOPY VARCHAR2,
1151 x_qlp_attribute19 OUT NOCOPY VARCHAR2,
1152 x_qlp_attribute20 OUT NOCOPY VARCHAR2,
1153 x_qlp_shipment_index OUT NOCOPY NUMBER,
1154 x_qlp_quote_shipment_id OUT NOCOPY NUMBER,
1155 x_qlp_cust_po_number OUT NOCOPY VARCHAR2,
1156 x_qlp_cust_po_line_number OUT NOCOPY VARCHAR2,
1157 x_qlp_object_version_number OUT NOCOPY NUMBER,
1158 x_qlp_trxn_extension_id OUT NOCOPY NUMBER,
1159 x_qlp_instrument_id OUT NOCOPY NUMBER,
1160 x_qlp_instr_assignment_id OUT NOCOPY NUMBER,
1161 x_qlp_cvv2 OUT NOCOPY VARCHAR2,
1162 x_qlt_operation_code OUT NOCOPY VARCHAR2,
1163 x_qlt_qte_line_index OUT NOCOPY NUMBER,
1164 x_qlt_shipment_index OUT NOCOPY NUMBER,
1165 x_qlt_tax_detail_id OUT NOCOPY NUMBER,
1166 x_qlt_quote_header_id OUT NOCOPY NUMBER,
1167 x_qlt_quote_line_id OUT NOCOPY NUMBER,
1168 x_qlt_quote_shipment_id OUT NOCOPY NUMBER,
1169 x_qlt_creation_date OUT NOCOPY DATE,
1170 x_qlt_created_by OUT NOCOPY NUMBER,
1171 x_qlt_last_update_date OUT NOCOPY DATE,
1172 x_qlt_last_updated_by OUT NOCOPY NUMBER,
1173 x_qlt_last_update_login OUT NOCOPY NUMBER,
1174 x_qlt_request_id OUT NOCOPY NUMBER,
1175 x_qlt_program_application_id OUT NOCOPY NUMBER,
1176 x_qlt_program_id OUT NOCOPY NUMBER,
1177 x_qlt_program_update_date OUT NOCOPY DATE,
1178 x_qlt_orig_tax_code OUT NOCOPY VARCHAR2,
1179 x_qlt_tax_code OUT NOCOPY VARCHAR2,
1180 x_qlt_tax_rate OUT NOCOPY NUMBER,
1181 x_qlt_tax_date OUT NOCOPY DATE,
1182 x_qlt_tax_amount OUT NOCOPY NUMBER,
1183 x_qlt_tax_exempt_flag OUT NOCOPY VARCHAR2,
1184 x_qlt_tax_exempt_number OUT NOCOPY VARCHAR2,
1185 x_qlt_tax_exempt_reason_code OUT NOCOPY VARCHAR2,
1186 x_qlt_attribute_category OUT NOCOPY VARCHAR2,
1187 x_qlt_attribute1 OUT NOCOPY VARCHAR2,
1188 x_qlt_attribute2 OUT NOCOPY VARCHAR2,
1189 x_qlt_attribute3 OUT NOCOPY VARCHAR2,
1190 x_qlt_attribute4 OUT NOCOPY VARCHAR2,
1194 x_qlt_attribute8 OUT NOCOPY VARCHAR2,
1191 x_qlt_attribute5 OUT NOCOPY VARCHAR2,
1192 x_qlt_attribute6 OUT NOCOPY VARCHAR2,
1193 x_qlt_attribute7 OUT NOCOPY VARCHAR2,
1195 x_qlt_attribute9 OUT NOCOPY VARCHAR2,
1196 x_qlt_attribute10 OUT NOCOPY VARCHAR2,
1197 x_qlt_attribute11 OUT NOCOPY VARCHAR2,
1198 x_qlt_attribute12 OUT NOCOPY VARCHAR2,
1199 x_qlt_attribute13 OUT NOCOPY VARCHAR2,
1200 x_qlt_attribute14 OUT NOCOPY VARCHAR2,
1201 x_qlt_attribute15 OUT NOCOPY VARCHAR2,
1202 x_qlt_attribute16 OUT NOCOPY VARCHAR2,
1203 x_qlt_attribute17 OUT NOCOPY VARCHAR2,
1204 x_qlt_attribute18 OUT NOCOPY VARCHAR2,
1205 x_qlt_attribute19 OUT NOCOPY VARCHAR2,
1206 x_qlt_attribute20 OUT NOCOPY VARCHAR2,
1207 x_qlt_object_version_number OUT NOCOPY NUMBER,
1208 x_qlt_tax_rate_id OUT NOCOPY NUMBER,
1209 x_changed_flag OUT NOCOPY VARCHAR2,
1210 x_return_status OUT NOCOPY VARCHAR2,
1211 x_msg_count OUT NOCOPY NUMBER,
1212 x_msg_data OUT NOCOPY VARCHAR2
1213 ) is
1214 l_control_rec ASO_Defaulting_Int.Control_Rec_Type := ASO_Defaulting_Int.G_Miss_Control_Rec;
1215 l_trigger_attribute_tbl ASO_Defaulting_Int.Attribute_codes_tbl_type := ASO_Defaulting_Int.G_MISS_ATTRIBUTE_CODES_TBL;
1216 l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1220 lx_header_Misc_Rec ASO_Defaulting_Int.Header_Misc_Rec_Type := ASO_Defaulting_Int.G_Miss_Header_Misc_Rec;
1217 lx_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1218 l_opp_qte_in_rec ASO_Opp_Qte_Pub.Opp_Qte_In_Rec_Type := ASO_Opp_Qte_Pub.G_Miss_Opp_Qte_In_Rec;
1219 l_header_Misc_Rec ASO_Defaulting_Int.Header_Misc_Rec_Type := ASO_Defaulting_Int.G_Miss_Header_Misc_Rec;
1221 l_hd_payment_rec ASO_Quote_Pub.payment_rec_type := ASO_Quote_Pub.G_MISS_payment_Rec;
1222 lx_hd_payment_rec ASO_Quote_Pub.payment_rec_type := ASO_Quote_Pub.G_MISS_payment_Rec;
1223 l_hd_shipment_rec ASO_Quote_Pub.shipment_rec_type := ASO_Quote_Pub.G_MISS_shipment_Rec;
1224 lx_hd_shipment_rec ASO_Quote_Pub.shipment_rec_type := ASO_Quote_Pub.G_MISS_shipment_Rec;
1225 l_hd_tax_rec ASO_Quote_Pub.tax_detail_rec_type := ASO_Quote_Pub.G_MISS_tax_detail_Rec;
1226 lx_hd_tax_rec ASO_Quote_Pub.tax_detail_rec_type := ASO_Quote_Pub.G_MISS_tax_detail_Rec;
1227 l_qte_line_rec ASO_Quote_Pub.qte_line_rec_type := ASO_Quote_Pub.G_MISS_qte_line_Rec;
1228 lx_qte_line_rec ASO_Quote_Pub.qte_line_rec_type := ASO_Quote_Pub.G_MISS_qte_line_Rec;
1229 l_ln_Misc_Rec ASO_Defaulting_Int.Line_Misc_Rec_Type := ASO_Defaulting_Int.G_Miss_Line_Misc_Rec;
1230 lx_ln_Misc_Rec ASO_Defaulting_Int.Line_Misc_Rec_Type := ASO_Defaulting_Int.G_Miss_Line_Misc_Rec;
1231 l_ln_payment_rec ASO_Quote_Pub.payment_rec_type := ASO_Quote_Pub.G_MISS_payment_Rec;
1232 lx_ln_payment_rec ASO_Quote_Pub.payment_rec_type := ASO_Quote_Pub.G_MISS_payment_Rec;
1233 l_ln_shipment_rec ASO_Quote_Pub.shipment_rec_type := ASO_Quote_Pub.G_MISS_shipment_Rec;
1234 lx_ln_shipment_rec ASO_Quote_Pub.shipment_rec_type := ASO_Quote_Pub.G_MISS_shipment_Rec;
1235 l_ln_tax_rec ASO_Quote_Pub.tax_detail_rec_type := ASO_Quote_Pub.G_MISS_tax_detail_Rec;
1236 lx_ln_tax_rec ASO_Quote_Pub.tax_detail_rec_type := ASO_Quote_Pub.G_MISS_tax_detail_Rec;
1237
1238 Begin
1239
1240
1241 ASO_QUOTE_UTIL_PVT.Set_Def_Control_Rec_W(
1245 p_dc_application_type_code => p_dc_application_type_code,
1242 p_dc_override_Trigger_Flag => p_dc_override_Trigger_Flag ,
1243 p_dc_dependency_Flag => p_dc_dependency_Flag,
1244 p_dc_defaulting_Flag => p_dc_defaulting_Flag,
1246 p_dc_defaulting_flow_code => p_dc_defaulting_flow_code,
1247 p_dc_last_update_date => p_dc_last_update_date,
1248 p_dc_object_version_number => p_dc_object_version_number,
1249 x_def_control_rec => l_control_rec
1250 );
1251
1252 l_trigger_attribute_tbl := ASO_QUOTE_UTIL_PVT.Construct_Trigger_Attr_Tbl(
1253 p_trigger_attribute => p_trigger_attribute
1254 );
1255
1256 l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
1257 p_quote_header_id => p_q_quote_header_id,
1258 p_creation_date => p_q_creation_date ,
1259 p_created_by => p_q_created_by ,
1260 p_last_updated_by => p_q_last_updated_by ,
1261 p_last_update_date => p_q_last_update_date ,
1262 p_last_update_login => p_q_last_update_login ,
1263 p_request_id => p_q_request_id ,
1264 p_program_application_id => p_q_program_application_id ,
1265 p_program_id => p_q_program_id ,
1266 p_program_update_date => p_q_program_update_date ,
1267 p_org_id => p_q_org_id ,
1268 p_quote_name => p_q_quote_name ,
1269 p_quote_number => p_q_quote_number ,
1270 p_quote_version => p_q_quote_version ,
1271 p_quote_status_id => p_q_quote_status_id ,
1272 p_quote_source_code => p_q_quote_source_code ,
1273 p_quote_expiration_date => p_q_quote_expiration_date ,
1274 p_price_frozen_date => p_q_price_frozen_date ,
1275 p_quote_password => p_q_quote_password ,
1276 p_original_system_reference => p_q_original_system_reference ,
1277 p_party_id => p_q_party_id ,
1278 p_cust_account_id => p_q_cust_account_id ,
1279 p_invoice_to_cust_account_id => p_q_invoice_to_cust_acct_id ,
1280 p_org_contact_id => p_q_org_contact_id ,
1281 p_party_name => p_q_party_name ,
1282 p_party_type => p_q_party_type ,
1283 p_person_first_name => p_q_person_first_name ,
1284 p_person_last_name => p_q_person_last_name ,
1285 p_person_middle_name => p_q_person_middle_name ,
1286 p_phone_id => p_q_phone_id ,
1287 p_price_list_id => p_q_price_list_id ,
1288 p_price_list_name => p_q_price_list_name ,
1289 p_currency_code => p_q_currency_code ,
1290 p_total_list_price => p_q_total_list_price ,
1291 p_total_adjusted_amount => p_q_total_adjusted_amount ,
1292 p_total_adjusted_percent => p_q_total_adjusted_percent ,
1293 p_total_tax => p_q_total_tax ,
1294 p_total_shipping_charge => p_q_total_shipping_charge ,
1295 p_surcharge => p_q_surcharge ,
1296 p_total_quote_price => p_q_total_quote_price ,
1297 p_payment_amount => p_q_payment_amount ,
1298 p_accounting_rule_id => p_q_accounting_rule_id ,
1299 p_exchange_rate => p_q_exchange_rate ,
1300 p_exchange_type_code => p_q_exchange_type_code ,
1301 p_exchange_rate_date => p_q_exchange_rate_date ,
1302 p_quote_category_code => p_q_quote_category_code ,
1303 p_quote_status_code => p_q_quote_status_code ,
1304 p_quote_status => p_q_quote_status ,
1305 p_employee_person_id => p_q_employee_person_id ,
1306 p_sales_channel_code => p_q_sales_channel_code ,
1307 p_salesrep_first_name => p_q_salesrep_first_name ,
1308 p_salesrep_last_name => p_q_salesrep_last_name ,
1309 p_attribute_category => p_q_attribute_category ,
1310 p_attribute1 => p_q_attribute1 ,
1311 p_attribute10 => p_q_attribute10 ,
1312 p_attribute11 => p_q_attribute11 ,
1313 p_attribute12 => p_q_attribute12 ,
1314 p_attribute13 => p_q_attribute13 ,
1315 p_attribute14 => p_q_attribute14 ,
1316 p_attribute15 => p_q_attribute15 ,
1317 p_attribute16 => p_q_attribute16 ,
1318 p_attribute17 => p_q_attribute17 ,
1319 p_attribute18 => p_q_attribute18 ,
1320 p_attribute19 => p_q_attribute19 ,
1321 p_attribute20 => p_q_attribute20 ,
1322 p_attribute2 => p_q_attribute2 ,
1323 p_attribute3 => p_q_attribute3 ,
1324 p_attribute4 => p_q_attribute4 ,
1325 p_attribute5 => p_q_attribute5 ,
1326 p_attribute6 => p_q_attribute6 ,
1327 p_attribute7 => p_q_attribute7 ,
1328 p_attribute8 => p_q_attribute8 ,
1329 p_attribute9 => p_q_attribute9 ,
1333 p_invoice_to_address1 => p_q_invoice_to_address1 ,
1330 p_contract_id => p_q_contract_id ,
1331 p_qte_contract_id => p_q_qte_contract_id ,
1332 p_ffm_request_id => p_q_ffm_request_id ,
1334 p_invoice_to_address2 => p_q_invoice_to_address2 ,
1335 p_invoice_to_address3 => p_q_invoice_to_address3 ,
1336 p_invoice_to_address4 => p_q_invoice_to_address4 ,
1340 p_invoice_to_cont_mid_name => p_q_invoice_to_cont_mid_name ,
1337 p_invoice_to_city => p_q_invoice_to_city ,
1338 p_invoice_to_cont_first_name => p_q_invoice_to_cont_first_name,
1339 p_invoice_to_cont_last_name => p_q_invoice_to_cont_last_name ,
1341 p_invoice_to_country_code => p_q_invoice_to_country_code ,
1342 p_invoice_to_country => p_q_invoice_to_country ,
1343 p_invoice_to_county => p_q_invoice_to_county ,
1344 p_invoice_to_party_id => p_q_invoice_to_party_id ,
1345 p_invoice_to_party_name => p_q_invoice_to_party_name ,
1346 p_invoice_to_party_site_id => p_q_invoice_to_party_site_id ,
1347 p_invoice_to_postal_code => p_q_invoice_to_postal_code ,
1348 p_invoice_to_province => p_q_invoice_to_province ,
1349 p_invoice_to_state => p_q_invoice_to_state ,
1350 p_invoicing_rule_id => p_q_invoicing_rule_id ,
1351 p_marketing_source_code_id => p_q_marketing_source_code_id ,
1352 p_marketing_source_code => p_q_marketing_source_code ,
1353 p_marketing_source_name => p_q_marketing_source_name ,
1354 p_orig_mktg_source_code_id => p_q_orig_mktg_source_code_id ,
1355 p_order_type_id => p_q_order_type_id ,
1356 p_order_id => p_q_order_id ,
1357 p_order_number => p_q_order_number ,
1358 p_order_type_name => p_q_order_type_name ,
1359 p_ordered_date => p_q_ordered_date ,
1360 p_resource_id => p_q_resource_id ,
1361 p_contract_template_id => p_q_contract_template_id ,
1362 p_contract_template_maj_ver => p_q_contract_template_maj_ver ,
1363 p_contract_requester_id => p_q_contract_requester_id ,
1364 p_contract_approval_level => p_q_contract_approval_level ,
1365 p_publish_flag => p_q_publish_flag ,
1366 p_resource_grp_id => p_q_resource_grp_id ,
1370 p_quote_type => p_q_quote_type ,
1367 p_sold_to_party_site_id => p_q_sold_to_party_site_id ,
1368 p_display_arithmetic_operator => p_q_display_arithmetic_op ,
1369 p_quote_description => p_q_quote_description ,
1371 p_minisite_id => p_q_minisite_id ,
1372 p_cust_party_id => p_q_cust_party_id ,
1373 p_invoice_to_cust_party_id => p_q_invoice_to_cust_party_id ,
1374 p_pricing_status_indicator => p_q_pricing_status_indicator ,
1375 p_tax_status_indicator => p_q_tax_status_indicator ,
1376 p_price_updated_date => p_q_price_updated_date ,
1377 p_tax_updated_date => p_q_tax_updated_date ,
1378 p_recalculate_flag => p_q_recalculate_flag ,
1379 p_price_request_id => p_q_price_request_id ,
1380 p_customer_name_and_title => p_q_customer_name_and_title,
1381 p_customer_signature_date => p_q_customer_signature_date,
1382 p_supplier_name_and_title => p_q_supplier_name_and_title,
1383 p_supplier_signature_date => p_q_supplier_signature_date,
1384 p_credit_update_date => p_q_credit_update_date ,
1385 p_automatic_price_flag => p_q_automatic_price_flag,
1386 p_automatic_tax_flag => p_q_automatic_tax_flag,
1387 p_assistance_requested => p_q_assistance_requested,
1388 p_assistance_reason_code => p_q_assistance_reason_code,
1389 p_end_customer_party_id => p_q_end_cust_party_id,
1390 p_end_customer_party_site_id => p_q_end_cust_party_site_id,
1391 p_end_customer_cust_account_id => p_q_end_cust_cust_account_id,
1392 p_end_customer_cust_party_id => p_q_end_cust_cust_party_id,
1393 p_object_version_number => p_q_object_version_number,
1394 p_header_paynow_charges => p_q_header_paynow_charges
1395 );
1396
1397 l_opp_qte_in_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Opp_Qte_In_Rec(
1398 p_opportunity_id => p_op_opportunity_id,
1399 p_quote_number => p_op_quote_number,
1400 p_quote_name => p_op_quote_name,
1401 p_cust_account_id => p_op_cust_account_id,
1402 p_resource_id => p_op_resource_id,
1403 p_sold_to_contact_id => p_op_sold_to_contact_id,
1404 p_sold_to_party_site_id => p_op_sold_to_party_site_id,
1405 p_price_list_id => p_op_price_list_id,
1406 p_resource_grp_id => p_op_resource_grp_id,
1407 p_channel_code => p_op_channel_code,
1408 p_order_type_id => p_op_order_type_id,
1409 p_agreement_id => p_op_agreement_id,
1410 p_contract_template_id => p_op_contract_template_id,
1411 p_contract_template_maj_ver => p_op_contract_template_maj_ver,
1412 p_currency_code => p_op_currency_code,
1413 p_marketing_source_code_id => p_op_marketing_source_code_id,
1414 p_quote_expiration_date => p_op_quote_expiration_date,
1415 p_cust_party_id => p_op_cust_party_id,
1416 p_pricing_status_indicator => p_op_pricing_status_indicator,
1417 p_tax_status_indicator => p_op_tax_status_indicator,
1418 p_price_updated_date => p_op_price_updated_date,
1419 p_tax_updated_date => p_op_tax_updated_date
1420 );
1421
1422
1423 l_header_Misc_Rec := ASO_QUOTE_UTIL_PVT.Construct_Hdr_Misc_Rec(
1424 p_attribute1 => p_q_mis_attribute1
1425 );
1426
1430 p_payment_id => p_qp_payment_id ,
1427 l_hd_payment_rec := ASO_QUOTE_UTIL_PVT.Construct_Payment_rec(
1428 p_operation_code => p_qp_operation_code ,
1429 p_qte_line_index => p_qp_qte_line_index ,
1431 p_creation_date => p_qp_creation_date ,
1432 p_created_by => p_qp_created_by ,
1433 p_last_update_date => p_qp_last_update_date ,
1434 p_last_updated_by => p_qp_last_updated_by ,
1435 p_last_update_login => p_qp_last_update_login ,
1436 p_request_id => p_qp_request_id ,
1437 p_program_application_id => p_qp_program_application_id ,
1438 p_program_id => p_qp_program_id ,
1439 p_program_update_date => p_qp_program_update_date ,
1440 p_quote_header_id => p_qp_quote_header_id ,
1441 p_quote_line_id => p_qp_quote_line_id ,
1442 p_payment_type_code => p_qp_payment_type_code ,
1443 p_payment_ref_number => p_qp_payment_ref_number ,
1444 p_payment_option => p_qp_payment_option ,
1445 p_payment_term_id => p_qp_payment_term_id ,
1446 p_credit_card_code => p_qp_credit_card_code ,
1447 p_credit_card_holder_name => p_qp_credit_card_holder_name ,
1448 p_credit_card_exp_date => p_qp_credit_card_exp_date ,
1449 p_credit_card_approval_code => p_qp_credit_card_aprv_code ,
1450 p_credit_card_approval_date => p_qp_credit_card_aprv_date ,
1451 p_payment_amount => p_qp_payment_amount ,
1452 p_attribute_category => p_qp_attribute_category ,
1453 p_attribute1 => p_qp_attribute1 ,
1454 p_attribute2 => p_qp_attribute2 ,
1455 p_attribute3 => p_qp_attribute3 ,
1459 p_attribute7 => p_qp_attribute7 ,
1456 p_attribute4 => p_qp_attribute4 ,
1457 p_attribute5 => p_qp_attribute5 ,
1458 p_attribute6 => p_qp_attribute6 ,
1460 p_attribute8 => p_qp_attribute8 ,
1461 p_attribute9 => p_qp_attribute9 ,
1462 p_attribute10 => p_qp_attribute10 ,
1463 p_attribute11 => p_qp_attribute11 ,
1464 p_attribute12 => p_qp_attribute12 ,
1465 p_attribute13 => p_qp_attribute13 ,
1466 p_attribute14 => p_qp_attribute14 ,
1467 p_attribute15 => p_qp_attribute15 ,
1468 p_attribute16 => p_qp_attribute16 ,
1469 p_attribute17 => p_qp_attribute17 ,
1470 p_attribute18 => p_qp_attribute18 ,
1471 p_attribute19 => p_qp_attribute19 ,
1472 p_attribute20 => p_qp_attribute20 ,
1473 p_shipment_index => p_qp_shipment_index ,
1474 p_quote_shipment_id => p_qp_quote_shipment_id ,
1475 p_cust_po_number => p_qp_cust_po_number ,
1476 p_cust_po_line_number => p_qp_cust_po_line_number ,
1477 p_object_version_number => p_qp_object_version_number);
1478
1479 l_hd_shipment_rec := ASO_QUOTE_UTIL_PVT.Construct_Shipment_rec(
1480 p_operation_code => p_qs_operation_code ,
1481 p_qte_line_index => p_qs_qte_line_index ,
1482 p_shipment_id => p_qs_shipment_id ,
1483 p_creation_date => p_qs_creation_date ,
1484 p_created_by => p_qs_created_by ,
1485 p_last_update_date => p_qs_last_update_date ,
1486 p_last_updated_by => p_qs_last_updated_by ,
1487 p_last_update_login => p_qs_last_update_login ,
1488 p_request_id => p_qs_request_id ,
1489 p_program_application_id => p_qs_program_application_id,
1490 p_program_id => p_qs_program_id ,
1491 p_program_update_date => p_qs_program_update_date ,
1492 p_quote_header_id => p_qs_quote_header_id ,
1493 p_quote_line_id => p_qs_quote_line_id ,
1494 p_promise_date => p_qs_promise_date ,
1495 p_request_date => p_qs_request_date ,
1496 p_schedule_ship_date => p_qs_schedule_ship_date ,
1497 p_ship_to_party_site_id => p_qs_ship_to_party_site_id ,
1498 p_ship_to_party_id => p_qs_ship_to_party_id ,
1499 p_ship_to_cust_account_id => p_qs_ship_to_cust_account_id ,
1500 p_ship_partial_flag => p_qs_ship_partial_flag ,
1501 p_ship_set_id => p_qs_ship_set_id ,
1502 p_ship_method_code => p_qs_ship_method_code ,
1503 p_freight_terms_code => p_qs_freight_terms_code ,
1504 p_freight_carrier_code => p_qs_freight_carrier_code ,
1505 p_fob_code => p_qs_fob_code ,
1506 p_shipping_instructions => p_qs_shipping_instructions ,
1507 p_packing_instructions => p_qs_packing_instructions ,
1508 p_quantity => p_qs_quantity ,
1509 p_reserved_quantity => p_qs_reserved_quantity ,
1510 p_reservation_id => p_qs_reservation_id ,
1511 p_order_line_id => p_qs_order_line_id ,
1512 p_ship_to_party_name => p_qs_ship_to_party_name ,
1513 p_ship_to_cont_first_name => p_qs_ship_to_cont_first_name ,
1514 p_ship_to_cont_mid_name => p_qs_ship_to_cont_mid_name ,
1515 p_ship_to_cont_last_name => p_qs_ship_to_cont_last_name ,
1516 p_ship_to_address1 => p_qs_ship_to_address1 ,
1517 p_ship_to_address2 => p_qs_ship_to_address2 ,
1518 p_ship_to_address3 => p_qs_ship_to_address3 ,
1519 p_ship_to_address4 => p_qs_ship_to_address4 ,
1520 p_ship_to_country_code => p_qs_ship_to_country_code ,
1521 p_ship_to_country => p_qs_ship_to_country ,
1522 p_ship_to_city => p_qs_ship_to_city ,
1523 p_ship_to_postal_code => p_qs_ship_to_postal_code ,
1524 p_ship_to_state => p_qs_ship_to_state ,
1525 p_ship_to_province => p_qs_ship_to_province ,
1526 p_ship_to_county => p_qs_ship_to_county ,
1527 p_attribute_category => p_qs_attribute_category ,
1528 p_attribute1 => p_qs_attribute1 ,
1529 p_attribute2 => p_qs_attribute2 ,
1530 p_attribute3 => p_qs_attribute3 ,
1531 p_attribute4 => p_qs_attribute4 ,
1532 p_attribute5 => p_qs_attribute5 ,
1533 p_attribute6 => p_qs_attribute6 ,
1534 p_attribute7 => p_qs_attribute7 ,
1535 p_attribute8 => p_qs_attribute8 ,
1536 p_attribute9 => p_qs_attribute9 ,
1537 p_attribute10 => p_qs_attribute10 ,
1538 p_attribute11 => p_qs_attribute11 ,
1539 p_attribute12 => p_qs_attribute12 ,
1540 p_attribute13 => p_qs_attribute13 ,
1541 p_attribute14 => p_qs_attribute14 ,
1542 p_attribute15 => p_qs_attribute15 ,
1543 p_attribute16 => p_qs_attribute16 ,
1544 p_attribute17 => p_qs_attribute17 ,
1548 p_ship_quote_price => p_qs_ship_quote_price ,
1545 p_attribute18 => p_qs_attribute18 ,
1546 p_attribute19 => p_qs_attribute19 ,
1547 p_attribute20 => p_qs_attribute20 ,
1549 p_pricing_quantity => p_qs_pricing_quantity ,
1550 p_shipment_priority_code => p_qs_shipment_priority_code,
1551 p_ship_from_org_id => p_qs_ship_from_org_id ,
1552 p_ship_to_cust_party_id => p_qs_ship_to_cust_party_id ,
1553 p_request_date_type => p_qs_request_date_type ,
1554 p_demand_class_code => p_qs_demand_class_code ,
1555 p_object_version_number => p_qs_object_version_number
1556 );
1557
1558 l_hd_tax_rec := ASO_QUOTE_UTIL_PVT.Construct_Tax_Detail_rec(
1559 p_operation_code => p_qt_operation_code ,
1560 p_qte_line_index => p_qt_qte_line_index ,
1561 p_shipment_index => p_qt_shipment_index ,
1562 p_tax_detail_id => p_qt_tax_detail_id ,
1563 p_quote_header_id => p_qt_quote_header_id ,
1564 p_quote_line_id => p_qt_quote_line_id ,
1565 p_quote_shipment_id => p_qt_quote_shipment_id ,
1566 p_creation_date => p_qt_creation_date ,
1567 p_created_by => p_qt_created_by ,
1568 p_last_update_date => p_qt_last_update_date ,
1569 p_last_updated_by => p_qt_last_updated_by ,
1570 p_last_update_login => p_qt_last_update_login ,
1571 p_request_id => p_qt_request_id ,
1572 p_program_application_id => p_qt_program_application_id,
1573 p_program_id => p_qt_program_id ,
1574 p_program_update_date => p_qt_program_update_date ,
1575 p_orig_tax_code => p_qt_orig_tax_code ,
1576 p_tax_code => p_qt_tax_code ,
1577 p_tax_rate => p_qt_tax_rate ,
1578 p_tax_date => p_qt_tax_date ,
1579 p_tax_amount => p_qt_tax_amount ,
1580 p_tax_exempt_flag => p_qt_tax_exempt_flag ,
1581 p_tax_exempt_number => p_qt_tax_exempt_number ,
1582 p_tax_exempt_reason_code => p_qt_tax_exempt_reason_code,
1583 p_attribute_category => p_qt_attribute_category ,
1584 p_attribute1 => p_qt_attribute1 ,
1585 p_attribute2 => p_qt_attribute2 ,
1586 p_attribute3 => p_qt_attribute3 ,
1587 p_attribute4 => p_qt_attribute4 ,
1588 p_attribute5 => p_qt_attribute5 ,
1589 p_attribute6 => p_qt_attribute6 ,
1590 p_attribute7 => p_qt_attribute7 ,
1591 p_attribute8 => p_qt_attribute8 ,
1592 p_attribute9 => p_qt_attribute9 ,
1593 p_attribute10 => p_qt_attribute10 ,
1594 p_attribute11 => p_qt_attribute11 ,
1595 p_attribute12 => p_qt_attribute12 ,
1596 p_attribute13 => p_qt_attribute13 ,
1597 p_attribute14 => p_qt_attribute14 ,
1598 p_attribute15 => p_qt_attribute15 ,
1599 p_attribute16 => p_qt_attribute16 ,
1600 p_attribute17 => p_qt_attribute17 ,
1601 p_attribute18 => p_qt_attribute18 ,
1602 p_attribute19 => p_qt_attribute19 ,
1603 p_attribute20 => p_qt_attribute20 ,
1604 p_object_version_number => p_qt_object_version_number ,
1605 p_tax_rate_id => p_qt_tax_rate_id
1606 );
1607
1608 l_qte_line_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Line_Rec(
1609 p_creation_date => p_ql_creation_date,
1610 p_created_by => p_ql_created_by,
1611 p_last_updated_by => p_ql_last_updated_by,
1612 p_last_update_date => p_ql_last_update_date,
1613 p_last_update_login => p_ql_last_update_login,
1614 p_request_id => p_ql_request_id,
1615 p_program_application_id => p_ql_program_application_id,
1616 p_program_id => p_ql_program_id,
1617 p_program_update_date => p_ql_program_update_date,
1618 p_quote_line_id => p_ql_quote_line_id,
1619 p_quote_header_id => p_ql_quote_header_id,
1620 p_org_id => p_ql_org_id,
1621 p_line_number => p_ql_line_number,
1622 p_line_category_code => p_ql_line_category_code,
1623 p_item_type_code => p_ql_item_type_code,
1627 p_uom_code => p_ql_uom_code,
1624 p_inventory_item_id => p_ql_inventory_item_id,
1625 p_organization_id => p_ql_organization_id,
1626 p_quantity => p_ql_quantity,
1628 p_start_date_active => p_ql_start_date_active,
1629 p_end_date_active => p_ql_end_date_active,
1630 p_order_line_type_id => p_ql_order_line_type_id,
1631 p_price_list_id => p_ql_price_list_id,
1632 p_price_list_line_id => p_ql_price_list_line_id,
1633 p_currency_code => p_ql_currency_code,
1634 p_line_list_price => p_ql_line_list_price,
1635 p_line_adjusted_amount => p_ql_line_adjusted_amount,
1636 p_line_adjusted_percent => p_ql_line_adjusted_percent,
1637 p_line_quote_price => p_ql_line_quote_price,
1638 p_related_item_id => p_ql_related_item_id,
1639 p_item_relationship_type => p_ql_item_relationship_type,
1640 p_split_shipment_flag => p_ql_split_shipment_flag,
1641 p_backorder_flag => p_ql_backorder_flag,
1642 p_selling_price_change => p_ql_selling_price_change,
1643 p_recalculate_flag => p_ql_recalculate_flag,
1644 p_attribute_category => p_ql_attribute_category,
1645 p_attribute1 => p_ql_attribute1,
1646 p_attribute2 => p_ql_attribute2,
1647 p_attribute3 => p_ql_attribute3,
1648 p_attribute4 => p_ql_attribute4,
1649 p_attribute5 => p_ql_attribute5,
1650 p_attribute6 => p_ql_attribute6,
1651 p_attribute7 => p_ql_attribute7,
1652 p_attribute8 => p_ql_attribute8,
1653 p_attribute9 => p_ql_attribute9,
1654 p_attribute10 => p_ql_attribute10,
1655 p_attribute11 => p_ql_attribute11,
1656 p_attribute12 => p_ql_attribute12,
1657 p_attribute13 => p_ql_attribute13,
1658 p_attribute14 => p_ql_attribute14,
1659 p_attribute15 => p_ql_attribute15,
1660 p_attribute16 => p_ql_attribute16,
1661 p_attribute17 => p_ql_attribute17,
1662 p_attribute18 => p_ql_attribute18,
1663 p_attribute19 => p_ql_attribute19,
1664 p_attribute20 => p_ql_attribute20,
1665 p_accounting_rule_id => p_ql_accounting_rule_id,
1666 p_ffm_content_name => p_ql_ffm_content_name,
1667 p_ffm_content_type => p_ql_ffm_content_type,
1668 p_ffm_document_type => p_ql_ffm_document_type,
1669 p_ffm_media_id => p_ql_ffm_media_id,
1670 p_ffm_media_type => p_ql_ffm_media_type,
1671 p_ffm_user_note => p_ql_ffm_user_note,
1672 p_invoice_to_party_id => p_ql_invoice_to_party_id,
1673 p_invoice_to_party_site_id => p_ql_invoice_to_party_site_id,
1674 p_invoicing_rule_id => p_ql_invoicing_rule_id,
1675 p_marketing_source_code_id => p_ql_marketing_source_code_id,
1676 p_operation_code => p_ql_operation_code,
1677 p_invoice_to_cust_account_id => p_ql_invoice_to_cust_acct_id,
1678 p_pricing_quantity_uom => p_ql_pricing_quantity_uom,
1679 p_minisite_id => p_ql_minisite_id,
1680 p_section_id => p_ql_section_id,
1681 p_priced_price_list_id => p_ql_priced_price_list_id,
1682 p_agreement_id => p_ql_agreement_id,
1683 p_commitment_id => p_ql_commitment_id,
1684 p_display_arithmetic_operator => p_ql_display_arithmetic_op,
1685 p_invoice_to_cust_party_id => p_ql_invoice_to_cust_party_id,
1686 p_ship_model_complete_flag => p_ql_ship_model_complete_flag,
1687 p_charge_periodicity_code => p_ql_charge_periodicity_code,
1688 p_end_customer_party_id => p_ql_end_cust_party_id,
1689 p_end_customer_party_site_id => p_ql_end_cust_party_site_id,
1690 p_end_customer_cust_account_id => p_ql_end_cust_cust_account_id,
1691 p_end_customer_cust_party_id => p_ql_end_cust_cust_party_id,
1692 p_object_version_number => p_ql_object_version_number,
1693 p_line_paynow_charges => p_ql_line_paynow_charges,
1694 p_line_paynow_tax => p_ql_line_paynow_tax,
1695 p_line_paynow_subtotal => p_ql_line_paynow_subtotal,
1696 p_config_model_type => p_ql_config_model_type
1697 );
1698 l_ln_Misc_Rec := ASO_QUOTE_UTIL_PVT.Construct_Ln_Misc_Rec(
1699 p_attribute1 => p_qln_mis_attribute1
1700 );
1701
1702 l_ln_payment_rec := ASO_QUOTE_UTIL_PVT.Construct_Payment_rec(
1703 p_operation_code => p_qlp_operation_code ,
1704 p_qte_line_index => p_qlp_qte_line_index ,
1705 p_payment_id => p_qlp_payment_id ,
1706 p_creation_date => p_qlp_creation_date ,
1707 p_created_by => p_qlp_created_by ,
1708 p_last_update_date => p_qlp_last_update_date ,
1709 p_last_updated_by => p_qlp_last_updated_by ,
1710 p_last_update_login => p_qlp_last_update_login ,
1711 p_request_id => p_qlp_request_id ,
1712 p_program_application_id => p_qlp_program_application_id ,
1713 p_program_id => p_qlp_program_id ,
1714 p_program_update_date => p_qlp_program_update_date ,
1718 p_payment_ref_number => p_qlp_payment_ref_number ,
1715 p_quote_header_id => p_qlp_quote_header_id ,
1716 p_quote_line_id => p_qlp_quote_line_id ,
1717 p_payment_type_code => p_qlp_payment_type_code ,
1719 p_payment_option => p_qlp_payment_option ,
1720 p_payment_term_id => p_qlp_payment_term_id ,
1721 p_credit_card_code => p_qlp_credit_card_code ,
1722 p_credit_card_holder_name => p_qlp_credit_card_holder_name ,
1723 p_credit_card_exp_date => p_qlp_credit_card_exp_date ,
1724 p_credit_card_approval_code => p_qlp_credit_card_aprv_code ,
1725 p_credit_card_approval_date => p_qlp_credit_card_aprv_date ,
1726 p_payment_amount => p_qlp_payment_amount ,
1727 p_attribute_category => p_qlp_attribute_category ,
1728 p_attribute1 => p_qlp_attribute1 ,
1729 p_attribute2 => p_qlp_attribute2 ,
1730 p_attribute3 => p_qlp_attribute3 ,
1731 p_attribute4 => p_qlp_attribute4 ,
1732 p_attribute5 => p_qlp_attribute5 ,
1733 p_attribute6 => p_qlp_attribute6 ,
1734 p_attribute7 => p_qlp_attribute7 ,
1735 p_attribute8 => p_qlp_attribute8 ,
1736 p_attribute9 => p_qlp_attribute9 ,
1737 p_attribute10 => p_qlp_attribute10 ,
1738 p_attribute11 => p_qlp_attribute11 ,
1739 p_attribute12 => p_qlp_attribute12 ,
1740 p_attribute13 => p_qlp_attribute13 ,
1741 p_attribute14 => p_qlp_attribute14 ,
1742 p_attribute15 => p_qlp_attribute15 ,
1743 p_attribute16 => p_qlp_attribute16 ,
1744 p_attribute17 => p_qlp_attribute17 ,
1745 p_attribute18 => p_qlp_attribute18 ,
1746 p_attribute19 => p_qlp_attribute19 ,
1747 p_attribute20 => p_qlp_attribute20 ,
1748 p_shipment_index => p_qlp_shipment_index ,
1749 p_quote_shipment_id => p_qlp_quote_shipment_id ,
1750 p_cust_po_number => p_qlp_cust_po_number ,
1751 p_cust_po_line_number => p_qlp_cust_po_line_number ,
1752 p_object_version_number => p_qlp_object_version_number);
1753
1754 l_ln_shipment_rec := ASO_QUOTE_UTIL_PVT.Construct_Shipment_rec(
1755 p_operation_code => p_qls_operation_code ,
1756 p_qte_line_index => p_qls_qte_line_index ,
1757 p_shipment_id => p_qls_shipment_id ,
1758 p_creation_date => p_qls_creation_date ,
1759 p_created_by => p_qls_created_by ,
1760 p_last_update_date => p_qls_last_update_date ,
1761 p_last_updated_by => p_qls_last_updated_by ,
1762 p_last_update_login => p_qls_last_update_login ,
1763 p_request_id => p_qls_request_id ,
1764 p_program_application_id => p_qls_program_application_id,
1765 p_program_id => p_qls_program_id ,
1766 p_program_update_date => p_qls_program_update_date ,
1767 p_quote_header_id => p_qls_quote_header_id ,
1768 p_quote_line_id => p_qls_quote_line_id ,
1769 p_promise_date => p_qls_promise_date ,
1770 p_request_date => p_qls_request_date ,
1771 p_schedule_ship_date => p_qls_schedule_ship_date ,
1772 p_ship_to_party_site_id => p_qls_ship_to_party_site_id ,
1773 p_ship_to_party_id => p_qls_ship_to_party_id ,
1774 p_ship_to_cust_account_id => p_qls_ship_to_cust_account_id ,
1775 p_ship_partial_flag => p_qls_ship_partial_flag ,
1776 p_ship_set_id => p_qls_ship_set_id ,
1777 p_ship_method_code => p_qls_ship_method_code ,
1778 p_freight_terms_code => p_qls_freight_terms_code ,
1779 p_freight_carrier_code => p_qls_freight_carrier_code ,
1780 p_fob_code => p_qls_fob_code ,
1781 p_shipping_instructions => p_qls_shipping_instructions ,
1782 p_packing_instructions => p_qls_packing_instructions ,
1783 p_quantity => p_qls_quantity ,
1784 p_reserved_quantity => p_qls_reserved_quantity ,
1785 p_reservation_id => p_qls_reservation_id ,
1786 p_order_line_id => p_qls_order_line_id ,
1787 p_ship_to_party_name => p_qls_ship_to_party_name ,
1788 p_ship_to_cont_first_name => p_qls_ship_to_cont_first_name ,
1789 p_ship_to_cont_mid_name => p_qls_ship_to_cont_mid_name ,
1790 p_ship_to_cont_last_name => p_qls_ship_to_cont_last_name ,
1791 p_ship_to_address1 => p_qls_ship_to_address1 ,
1792 p_ship_to_address2 => p_qls_ship_to_address2 ,
1793 p_ship_to_address3 => p_qls_ship_to_address3 ,
1794 p_ship_to_address4 => p_qls_ship_to_address4 ,
1795 p_ship_to_country_code => p_qls_ship_to_country_code ,
1796 p_ship_to_country => p_qls_ship_to_country ,
1797 p_ship_to_city => p_qls_ship_to_city ,
1798 p_ship_to_postal_code => p_qls_ship_to_postal_code ,
1799 p_ship_to_state => p_qls_ship_to_state ,
1800 p_ship_to_province => p_qls_ship_to_province ,
1801 p_ship_to_county => p_qls_ship_to_county ,
1805 p_attribute3 => p_qls_attribute3 ,
1802 p_attribute_category => p_qls_attribute_category ,
1803 p_attribute1 => p_qls_attribute1 ,
1804 p_attribute2 => p_qls_attribute2 ,
1806 p_attribute4 => p_qls_attribute4 ,
1807 p_attribute5 => p_qls_attribute5 ,
1808 p_attribute6 => p_qls_attribute6 ,
1809 p_attribute7 => p_qls_attribute7 ,
1810 p_attribute8 => p_qls_attribute8 ,
1811 p_attribute9 => p_qls_attribute9 ,
1812 p_attribute10 => p_qls_attribute10 ,
1813 p_attribute11 => p_qls_attribute11 ,
1814 p_attribute12 => p_qls_attribute12 ,
1815 p_attribute13 => p_qls_attribute13 ,
1816 p_attribute14 => p_qls_attribute14 ,
1817 p_attribute15 => p_qls_attribute15 ,
1818 p_attribute16 => p_qls_attribute16 ,
1819 p_attribute17 => p_qls_attribute17 ,
1820 p_attribute18 => p_qls_attribute18 ,
1821 p_attribute19 => p_qls_attribute19 ,
1822 p_attribute20 => p_qls_attribute20 ,
1823 p_ship_quote_price => p_qls_ship_quote_price ,
1824 p_pricing_quantity => p_qls_pricing_quantity ,
1825 p_shipment_priority_code => p_qls_shipment_priority_code,
1826 p_ship_from_org_id => p_qls_ship_from_org_id ,
1827 p_ship_to_cust_party_id => p_qls_ship_to_cust_party_id ,
1828 p_request_date_type => p_qls_request_date_type ,
1829 p_demand_class_code => p_qls_demand_class_code ,
1830 p_object_version_number => p_qls_object_version_number
1831 );
1832
1833 l_ln_tax_rec := ASO_QUOTE_UTIL_PVT.Construct_Tax_Detail_rec(
1834 p_operation_code => p_qlt_operation_code ,
1835 p_qte_line_index => p_qlt_qte_line_index ,
1836 p_shipment_index => p_qlt_shipment_index ,
1837 p_tax_detail_id => p_qlt_tax_detail_id ,
1838 p_quote_header_id => p_qlt_quote_header_id ,
1839 p_quote_line_id => p_qlt_quote_line_id ,
1840 p_quote_shipment_id => p_qlt_quote_shipment_id ,
1841 p_creation_date => p_qlt_creation_date ,
1842 p_created_by => p_qlt_created_by ,
1843 p_last_update_date => p_qlt_last_update_date ,
1844 p_last_updated_by => p_qlt_last_updated_by ,
1845 p_last_update_login => p_qlt_last_update_login ,
1846 p_request_id => p_qlt_request_id ,
1847 p_program_application_id => p_qlt_program_application_id,
1848 p_program_id => p_qlt_program_id ,
1849 p_program_update_date => p_qlt_program_update_date ,
1850 p_orig_tax_code => p_qlt_orig_tax_code ,
1851 p_tax_code => p_qlt_tax_code ,
1852 p_tax_rate => p_qlt_tax_rate ,
1853 p_tax_date => p_qlt_tax_date ,
1854 p_tax_amount => p_qlt_tax_amount ,
1855 p_tax_exempt_flag => p_qlt_tax_exempt_flag ,
1856 p_tax_exempt_number => p_qlt_tax_exempt_number ,
1857 p_tax_exempt_reason_code => p_qlt_tax_exempt_reason_code,
1858 p_attribute_category => p_qlt_attribute_category ,
1859 p_attribute1 => p_qlt_attribute1 ,
1860 p_attribute2 => p_qlt_attribute2 ,
1861 p_attribute3 => p_qlt_attribute3 ,
1862 p_attribute4 => p_qlt_attribute4 ,
1863 p_attribute5 => p_qlt_attribute5 ,
1864 p_attribute6 => p_qlt_attribute6 ,
1865 p_attribute7 => p_qlt_attribute7 ,
1866 p_attribute8 => p_qlt_attribute8 ,
1867 p_attribute9 => p_qlt_attribute9 ,
1868 p_attribute10 => p_qlt_attribute10 ,
1869 p_attribute11 => p_qlt_attribute11 ,
1870 p_attribute12 => p_qlt_attribute12 ,
1871 p_attribute13 => p_qlt_attribute13 ,
1872 p_attribute14 => p_qlt_attribute14 ,
1873 p_attribute15 => p_qlt_attribute15 ,
1874 p_attribute16 => p_qlt_attribute16 ,
1875 p_attribute17 => p_qlt_attribute17 ,
1876 p_attribute18 => p_qlt_attribute18 ,
1877 p_attribute19 => p_qlt_attribute19 ,
1878 p_attribute20 => p_qlt_attribute20 ,
1879 p_object_version_number => p_qlt_object_version_number ,
1880 p_tax_rate_id => p_qlt_tax_rate_id
1881 );
1882
1883 Aso_Defaulting_Int.Default_Entity (
1884 P_API_VERSION => p_api_version,
1885 P_INIT_MSG_LIST => p_init_msg_list,
1886 P_COMMIT => p_commit,
1887 P_CONTROL_REC => l_control_rec,
1888 P_DATABASE_OBJECT_NAME => p_database_object_name,
1889 P_TRIGGER_ATTRIBUTES_TBL => l_trigger_attribute_tbl,
1890 P_QUOTE_HEADER_REC => l_qte_header_rec,
1891 P_OPP_QTE_HEADER_REC => l_opp_qte_in_rec,
1892 P_HEADER_MISC_REC => l_header_Misc_Rec,
1893 P_HEADER_SHIPMENT_REC => l_hd_shipment_rec,
1894 P_HEADER_PAYMENT_REC => l_hd_payment_rec,
1895 P_HEADER_TAX_DETAIL_REC => l_hd_tax_rec,
1899 P_LINE_PAYMENT_REC => l_ln_payment_rec,
1896 P_QUOTE_LINE_REC => l_qte_line_rec,
1897 P_LINE_MISC_REC => l_ln_Misc_Rec,
1898 P_LINE_SHIPMENT_REC => l_ln_shipment_rec,
1900 P_LINE_TAX_DETAIL_REC => l_ln_tax_rec,
1901 X_QUOTE_HEADER_REC => lx_qte_header_rec,
1902 X_HEADER_MISC_REC => lx_header_Misc_Rec,
1903 X_HEADER_SHIPMENT_REC => lx_hd_shipment_rec,
1904 X_HEADER_PAYMENT_REC => lx_hd_payment_rec,
1905 X_HEADER_TAX_DETAIL_REC => lx_hd_tax_rec,
1906 X_QUOTE_LINE_REC => lx_qte_line_rec,
1907 X_LINE_MISC_REC => lx_ln_Misc_Rec,
1908 X_LINE_SHIPMENT_REC => lx_ln_shipment_rec,
1909 X_LINE_PAYMENT_REC => lx_ln_payment_rec,
1910 X_LINE_TAX_DETAIL_REC => lx_ln_tax_rec,
1911 X_CHANGED_FLAG => x_changed_flag,
1912 X_RETURN_STATUS => x_return_status,
1913 X_MSG_COUNT => x_msg_count,
1914 X_MSG_DATA => x_msg_data
1915 );
1916
1917
1918 ASO_QUOTE_UTIL_PVT.Set_Qte_header_rec_Out(
1919 p_qte_header_rec => lx_qte_header_rec,
1920 x_q_quote_header_id => x_q_quote_header_id,
1921 x_q_creation_date => x_q_creation_date,
1922 x_q_created_by => x_q_created_by,
1923 x_q_last_updated_by => x_q_last_updated_by,
1924 x_q_last_update_date => x_q_last_update_date,
1925 x_q_last_update_login => x_q_last_update_login,
1926 x_q_request_id => x_q_request_id,
1927 x_q_program_application_id => x_q_program_application_id,
1928 x_q_program_id => x_q_program_id,
1929 x_q_program_update_date => x_q_program_update_date,
1930 x_q_org_id => x_q_org_id,
1931 x_q_quote_name => x_q_quote_name,
1932 x_q_quote_number => x_q_quote_number,
1933 x_q_quote_version => x_q_quote_version,
1934 x_q_quote_status_id => x_q_quote_status_id,
1935 x_q_quote_source_code => x_q_quote_source_code,
1936 x_q_quote_expiration_date => x_q_quote_expiration_date,
1937 x_q_price_frozen_date => x_q_price_frozen_date,
1938 x_q_quote_password => x_q_quote_password,
1939 x_q_original_system_reference => x_q_original_system_reference,
1940 x_q_party_id => x_q_party_id,
1941 x_q_cust_account_id => x_q_cust_account_id,
1942 x_q_invoice_to_cust_acct_id => x_q_invoice_to_cust_acct_id,
1943 x_q_org_contact_id => x_q_org_contact_id,
1944 x_q_party_name => x_q_party_name,
1945 x_q_party_type => x_q_party_type,
1946 x_q_person_first_name => x_q_person_first_name,
1947 x_q_person_last_name => x_q_person_last_name,
1948 x_q_person_middle_name => x_q_person_middle_name,
1949 x_q_phone_id => x_q_phone_id,
1950 x_q_price_list_id => x_q_price_list_id,
1951 x_q_price_list_name => x_q_price_list_name,
1952 x_q_currency_code => x_q_currency_code,
1953 x_q_total_list_price => x_q_total_list_price,
1954 x_q_total_adjusted_amount => x_q_total_adjusted_amount,
1955 x_q_total_adjusted_percent => x_q_total_adjusted_percent,
1956 x_q_total_tax => x_q_total_tax,
1957 x_q_total_shipping_charge => x_q_total_shipping_charge,
1958 x_q_surcharge => x_q_surcharge,
1959 x_q_total_quote_price => x_q_total_quote_price,
1960 x_q_payment_amount => x_q_payment_amount,
1961 x_q_accounting_rule_id => x_q_accounting_rule_id,
1962 x_q_exchange_rate => x_q_exchange_rate,
1963 x_q_exchange_type_code => x_q_exchange_type_code,
1964 x_q_exchange_rate_date => x_q_exchange_rate_date,
1965 x_q_quote_category_code => x_q_quote_category_code,
1966 x_q_quote_status_code => x_q_quote_status_code,
1967 x_q_quote_status => x_q_quote_status,
1968 x_q_employee_person_id => x_q_employee_person_id,
1969 x_q_sales_channel_code => x_q_sales_channel_code,
1970 x_q_salesrep_first_name => x_q_salesrep_first_name,
1971 x_q_salesrep_last_name => x_q_salesrep_last_name,
1972 x_q_attribute_category => x_q_attribute_category,
1973 x_q_attribute1 => x_q_attribute1,
1974 x_q_attribute10 => x_q_attribute10,
1975 x_q_attribute11 => x_q_attribute11,
1976 x_q_attribute12 => x_q_attribute12,
1977 x_q_attribute13 => x_q_attribute13,
1978 x_q_attribute14 => x_q_attribute14,
1979 x_q_attribute15 => x_q_attribute15,
1980 x_q_attribute16 => x_q_attribute16,
1981 x_q_attribute17 => x_q_attribute17,
1982 x_q_attribute18 => x_q_attribute19,
1983 x_q_attribute19 => x_q_attribute19,
1984 x_q_attribute20 => x_q_attribute20,
1985 x_q_attribute2 => x_q_attribute2,
1986 x_q_attribute3 => x_q_attribute3,
1987 x_q_attribute4 => x_q_attribute4,
1991 x_q_attribute8 => x_q_attribute8,
1988 x_q_attribute5 => x_q_attribute5,
1989 x_q_attribute6 => x_q_attribute6,
1990 x_q_attribute7 => x_q_attribute7,
1992 x_q_attribute9 => x_q_attribute8,
1993 x_q_contract_id => x_q_contract_id,
1994 x_q_qte_contract_id => x_q_qte_contract_id,
1995 x_q_ffm_request_id => x_q_ffm_request_id,
1996 x_q_invoice_to_address1 => x_q_invoice_to_address1,
1997 x_q_invoice_to_address2 => x_q_invoice_to_address2,
1998 x_q_invoice_to_address3 => x_q_invoice_to_address3,
1999 x_q_invoice_to_address4 => x_q_invoice_to_address4,
2000 x_q_invoice_to_city => x_q_invoice_to_city,
2001 x_q_invoice_to_cont_first_name => x_q_invoice_to_cont_first_name,
2002 x_q_invoice_to_cont_last_name => x_q_invoice_to_cont_last_name,
2003 x_q_invoice_to_cont_mid_name => x_q_invoice_to_cont_mid_name,
2004 x_q_invoice_to_country_code => x_q_invoice_to_country_code,
2005 x_q_invoice_to_country => x_q_invoice_to_country_code,
2006 x_q_invoice_to_county => x_q_invoice_to_county,
2007 x_q_invoice_to_party_id => x_q_invoice_to_party_id,
2008 x_q_invoice_to_party_name => x_q_invoice_to_party_name,
2009 x_q_invoice_to_party_site_id => x_q_invoice_to_party_site_id,
2010 x_q_invoice_to_postal_code => x_q_invoice_to_postal_code,
2011 x_q_invoice_to_province => x_q_invoice_to_province,
2012 x_q_invoice_to_state => x_q_invoice_to_state,
2013 x_q_invoicing_rule_id => x_q_invoicing_rule_id,
2014 x_q_marketing_source_code_id => x_q_marketing_source_code_id,
2015 x_q_marketing_source_code => x_q_marketing_source_code,
2016 x_q_marketing_source_name => x_q_marketing_source_name,
2017 x_q_orig_mktg_source_code_id => x_q_orig_mktg_source_code_id,
2018 x_q_order_type_id => x_q_order_type_id,
2019 x_q_order_id => x_q_order_id,
2020 x_q_order_number => x_q_order_number,
2021 x_q_order_type_name => x_q_order_type_name,
2022 x_q_ordered_date => x_q_ordered_date,
2023 x_q_resource_id => x_q_resource_id,
2024 x_q_contract_template_id => x_q_contract_template_id,
2025 x_q_contract_template_maj_ver => x_q_contract_template_maj_ver,
2026 x_q_contract_requester_id => x_q_contract_requester_id,
2027 x_q_contract_approval_level => x_q_contract_approval_level,
2028 x_q_publish_flag => x_q_publish_flag,
2029 x_q_resource_grp_id => x_q_resource_grp_id,
2030 x_q_sold_to_party_site_id => x_q_sold_to_party_site_id,
2031 x_q_display_arithmetic_op => x_q_display_arithmetic_op,
2032 x_q_quote_description => x_q_quote_description,
2033 x_q_quote_type => x_q_quote_type,
2034 x_q_minisite_id => x_q_minisite_id,
2035 x_q_cust_party_id => x_q_cust_party_id,
2036 x_q_invoice_to_cust_party_id => x_q_invoice_to_cust_party_id,
2037 x_q_pricing_status_indicator => x_q_pricing_status_indicator,
2038 x_q_tax_status_indicator => x_q_tax_status_indicator,
2039 x_q_price_updated_date => x_q_price_updated_date,
2040 x_q_tax_updated_date => x_q_tax_updated_date,
2041 x_q_recalculate_flag => x_q_recalculate_flag,
2042 x_q_price_request_id => x_q_price_request_id,
2043 x_q_credit_update_date => x_q_credit_update_date,
2044 x_q_customer_name_and_title => x_q_customer_name_and_title,
2045 x_q_customer_signature_date => x_q_customer_signature_date,
2046 x_q_supplier_name_and_title => x_q_supplier_name_and_title,
2047 x_q_supplier_signature_date => x_q_supplier_signature_date,
2048 x_q_end_cust_party_id => x_q_end_cust_party_id,
2049 x_q_end_cust_party_site_id => x_q_end_cust_party_site_id,
2050 x_q_end_cust_cust_account_id => x_q_end_cust_cust_account_id,
2051 x_q_end_cust_cust_party_id => x_q_end_cust_cust_party_id,
2052 x_q_automatic_price_flag => x_q_automatic_price_flag,
2053 x_q_automatic_tax_flag => x_q_automatic_tax_flag,
2054 x_q_assistance_requested => x_q_assistance_requested,
2055 x_q_assistance_reason_code => x_q_assistance_reason_code,
2056 x_q_object_version_number => x_q_object_version_number,
2057 x_q_header_paynow_charges => x_q_header_paynow_charges
2058 );
2059
2060 ASO_QUOTE_UTIL_PVT.Set_Shipment_rec_Out(
2061 p_shipment_rec => lx_hd_shipment_rec,
2062 x_qs_operation_code => x_qs_operation_code,
2063 x_qs_qte_line_index => x_qs_qte_line_index,
2064 x_qs_shipment_id => x_qs_shipment_id,
2065 x_qs_creation_date => x_qs_creation_date,
2066 x_qs_created_by => x_qs_created_by,
2067 x_qs_last_update_date => x_qs_last_update_date,
2068 x_qs_last_updated_by => x_qs_last_updated_by,
2069 x_qs_last_update_login => x_qs_last_update_login,
2070 x_qs_request_id => x_qs_request_id,
2071 x_qs_program_application_id => x_qs_program_application_id,
2072 x_qs_program_id => x_qs_program_id,
2073 x_qs_program_update_date => x_qs_program_update_date,
2077 x_qs_request_date => x_qs_request_date,
2074 x_qs_quote_header_id => x_qs_quote_header_id,
2075 x_qs_quote_line_id => x_qs_quote_line_id,
2076 x_qs_promise_date => x_qs_promise_date,
2078 x_qs_schedule_ship_date => x_qs_schedule_ship_date,
2079 x_qs_ship_to_party_site_id => x_qs_ship_to_party_site_id,
2080 x_qs_ship_to_party_id => x_qs_ship_to_party_id,
2081 x_qs_ship_to_cust_account_id => x_qs_ship_to_cust_account_id,
2082 x_qs_ship_partial_flag => x_qs_ship_partial_flag,
2083 x_qs_ship_set_id => x_qs_ship_set_id,
2084 x_qs_ship_method_code => x_qs_ship_method_code,
2085 x_qs_freight_terms_code => x_qs_freight_terms_code,
2086 x_qs_freight_carrier_code => x_qs_freight_carrier_code,
2087 x_qs_fob_code => x_qs_fob_code,
2088 x_qs_shipping_instructions => x_qs_shipping_instructions,
2089 x_qs_packing_instructions => x_qs_packing_instructions,
2090 x_qs_quantity => x_qs_quantity,
2091 x_qs_reserved_quantity => x_qs_reserved_quantity,
2092 x_qs_reservation_id => x_qs_reservation_id,
2093 x_qs_order_line_id => x_qs_order_line_id,
2094 x_qs_ship_to_party_name => x_qs_ship_to_party_name,
2095 x_qs_ship_to_cont_first_name => x_qs_ship_to_cont_first_name,
2096 x_qs_ship_to_cont_mid_name => x_qs_ship_to_cont_mid_name,
2097 x_qs_ship_to_cont_last_name => x_qs_ship_to_cont_last_name,
2098 x_qs_ship_to_address1 => x_qs_ship_to_address1,
2099 x_qs_ship_to_address2 => x_qs_ship_to_address2,
2100 x_qs_ship_to_address3 => x_qs_ship_to_address3,
2101 x_qs_ship_to_address4 => x_qs_ship_to_address4,
2102 x_qs_ship_to_country_code => x_qs_ship_to_country_code,
2103 x_qs_ship_to_country => x_qs_ship_to_country,
2104 x_qs_ship_to_city => x_qs_ship_to_city,
2105 x_qs_ship_to_postal_code => x_qs_ship_to_postal_code,
2106 x_qs_ship_to_state => x_qs_ship_to_state,
2107 x_qs_ship_to_province => x_qs_ship_to_province,
2108 x_qs_ship_to_county => x_qs_ship_to_county,
2109 x_qs_attribute_category => x_qs_attribute_category,
2110 x_qs_attribute1 => x_qs_attribute1,
2111 x_qs_attribute2 => x_qs_attribute2,
2112 x_qs_attribute3 => x_qs_attribute3,
2113 x_qs_attribute4 => x_qs_attribute4,
2114 x_qs_attribute5 => x_qs_attribute5,
2115 x_qs_attribute6 => x_qs_attribute6,
2116 x_qs_attribute7 => x_qs_attribute7,
2117 x_qs_attribute8 => x_qs_attribute8,
2118 x_qs_attribute9 => x_qs_attribute9,
2119 x_qs_attribute10 => x_qs_attribute10,
2120 x_qs_attribute11 => x_qs_attribute11,
2121 x_qs_attribute12 => x_qs_attribute12,
2122 x_qs_attribute13 => x_qs_attribute13,
2123 x_qs_attribute14 => x_qs_attribute14,
2124 x_qs_attribute15 => x_qs_attribute15,
2125 x_qs_attribute16 => x_qs_attribute16,
2126 x_qs_attribute17 => x_qs_attribute17,
2127 x_qs_attribute18 => x_qs_attribute18,
2128 x_qs_attribute19 => x_qs_attribute19,
2129 x_qs_attribute20 => x_qs_attribute20,
2130 x_qs_ship_quote_price => x_qs_ship_quote_price,
2131 x_qs_pricing_quantity => x_qs_pricing_quantity,
2132 x_qs_shipment_priority_code => x_qs_shipment_priority_code,
2133 x_qs_ship_from_org_id => x_qs_ship_from_org_id,
2134 x_qs_ship_to_cust_party_id => x_qs_ship_to_cust_party_id,
2135 x_qs_request_date_type => x_qs_request_date_type,
2136 x_qs_demand_class_code => x_qs_demand_class_code,
2137 x_qs_object_version_number => x_qs_object_version_number
2138 );
2139
2140 ASO_QUOTE_UTIL_PVT.Set_Payment_rec_Out(
2141 p_payment_rec => lx_hd_payment_rec,
2142 x_qp_operation_code => x_qp_operation_code,
2143 x_qp_qte_line_index => x_qp_qte_line_index,
2144 x_qp_payment_id => x_qp_payment_id,
2145 x_qp_creation_date => x_qp_creation_date,
2146 x_qp_created_by => x_qp_created_by,
2147 x_qp_last_update_date => x_qp_last_update_date,
2148 x_qp_last_updated_by => x_qp_last_updated_by,
2149 x_qp_last_update_login => x_qp_last_update_login,
2150 x_qp_request_id => x_qp_request_id,
2151 x_qp_program_application_id => x_qp_program_application_id,
2152 x_qp_program_id => x_qp_program_id,
2153 x_qp_program_update_date => x_qp_program_update_date,
2154 x_qp_quote_header_id => x_qp_quote_header_id,
2155 x_qp_quote_line_id => x_qp_quote_line_id,
2156 x_qp_payment_type_code => x_qp_payment_type_code,
2157 x_qp_payment_ref_number => x_qp_payment_ref_number,
2158 x_qp_payment_option => x_qp_payment_option,
2159 x_qp_payment_term_id => x_qp_payment_term_id,
2160 x_qp_credit_card_code => x_qp_credit_card_code,
2161 x_qp_credit_card_holder_name => x_qp_credit_card_holder_name,
2162 x_qp_credit_card_exp_date => x_qp_credit_card_exp_date,
2163 x_qp_credit_card_aprv_code => x_qp_credit_card_aprv_code,
2164 x_qp_credit_card_aprv_date => x_qp_credit_card_aprv_date,
2168 x_qp_attribute2 => x_qp_attribute2,
2165 x_qp_payment_amount => x_qp_payment_amount,
2166 x_qp_attribute_category => x_qp_attribute_category,
2167 x_qp_attribute1 => x_qp_attribute1,
2169 x_qp_attribute3 => x_qp_attribute3,
2170 x_qp_attribute4 => x_qp_attribute4,
2171 x_qp_attribute5 => x_qp_attribute5,
2172 x_qp_attribute6 => x_qp_attribute6,
2173 x_qp_attribute7 => x_qp_attribute7,
2174 x_qp_attribute8 => x_qp_attribute8,
2175 x_qp_attribute9 => x_qp_attribute9,
2176 x_qp_attribute10 => x_qp_attribute10,
2177 x_qp_attribute11 => x_qp_attribute11,
2178 x_qp_attribute12 => x_qp_attribute12,
2179 x_qp_attribute13 => x_qp_attribute13,
2180 x_qp_attribute14 => x_qp_attribute14,
2181 x_qp_attribute15 => x_qp_attribute15,
2182 x_qp_attribute16 => x_qp_attribute16,
2183 x_qp_attribute17 => x_qp_attribute17,
2184 x_qp_attribute18 => x_qp_attribute18,
2185 x_qp_attribute19 => x_qp_attribute19,
2186 x_qp_attribute20 => x_qp_attribute20,
2187 x_qp_shipment_index => x_qp_shipment_index,
2188 x_qp_quote_shipment_id => x_qp_quote_shipment_id,
2189 x_qp_cust_po_number => x_qp_cust_po_number,
2190 x_qp_cust_po_line_number => x_qp_cust_po_line_number,
2191 x_qp_object_version_number => x_qp_object_version_number,
2192 x_qp_trxn_extension_id => x_qp_trxn_extension_id,
2193 x_qp_instrument_id => x_qp_instrument_id,
2194 x_qp_instr_assignment_id => x_qp_instr_assignment_id,
2195 x_qp_cvv2 => x_qp_cvv2
2196 );
2197
2198 ASO_QUOTE_UTIL_PVT.Set_Tax_detail_rec_Out(
2199 p_tax_detail_rec => lx_hd_tax_rec,
2200 x_qt_operation_code => x_qt_operation_code,
2201 x_qt_qte_line_index => x_qt_qte_line_index,
2202 x_qt_shipment_index => x_qt_shipment_index,
2203 x_qt_tax_detail_id => x_qt_tax_detail_id,
2204 x_qt_quote_header_id => x_qt_quote_header_id,
2205 x_qt_quote_line_id => x_qt_quote_line_id,
2206 x_qt_quote_shipment_id => x_qt_quote_shipment_id,
2207 x_qt_creation_date => x_qt_creation_date,
2208 x_qt_created_by => x_qt_created_by,
2209 x_qt_last_update_date => x_qt_last_update_date,
2210 x_qt_last_updated_by => x_qt_last_updated_by,
2211 x_qt_last_update_login => x_qt_last_update_login,
2212 x_qt_request_id => x_qt_request_id,
2213 x_qt_program_application_id => x_qt_program_application_id,
2214 x_qt_program_id => x_qt_program_id,
2215 x_qt_program_update_date => x_qt_program_update_date,
2216 x_qt_orig_tax_code => x_qt_orig_tax_code,
2217 x_qt_tax_code => x_qt_tax_code,
2218 x_qt_tax_rate => x_qt_tax_rate,
2219 x_qt_tax_date => x_qt_tax_date,
2220 x_qt_tax_amount => x_qt_tax_amount,
2221 x_qt_tax_exempt_flag => x_qt_tax_exempt_flag,
2222 x_qt_tax_exempt_number => x_qt_tax_exempt_number,
2223 x_qt_tax_exempt_reason_code => x_qt_tax_exempt_reason_code,
2224 x_qt_attribute_category => x_qt_attribute_category,
2225 x_qt_attribute1 => x_qt_attribute1,
2226 x_qt_attribute2 => x_qt_attribute2,
2227 x_qt_attribute3 => x_qt_attribute3,
2228 x_qt_attribute4 => x_qt_attribute4,
2229 x_qt_attribute5 => x_qt_attribute5,
2230 x_qt_attribute6 => x_qt_attribute6,
2231 x_qt_attribute7 => x_qt_attribute7,
2232 x_qt_attribute8 => x_qt_attribute8,
2233 x_qt_attribute9 => x_qt_attribute9,
2234 x_qt_attribute10 => x_qt_attribute10,
2235 x_qt_attribute11 => x_qt_attribute11,
2236 x_qt_attribute12 => x_qt_attribute12,
2237 x_qt_attribute13 => x_qt_attribute13,
2238 x_qt_attribute14 => x_qt_attribute14,
2239 x_qt_attribute15 => x_qt_attribute15,
2240 x_qt_attribute16 => x_qt_attribute16,
2241 x_qt_attribute17 => x_qt_attribute17,
2242 x_qt_attribute18 => x_qt_attribute18,
2243 x_qt_attribute19 => x_qt_attribute19,
2244 x_qt_attribute20 => x_qt_attribute20,
2245 x_qt_object_version_number => x_qt_object_version_number,
2246 x_qt_tax_rate_id => x_qt_tax_rate_id
2247 );
2248
2249 ASO_QUOTE_UTIL_PVT.Set_Qte_line_rec_Out(
2250 p_qte_line_rec => lx_qte_line_rec,
2251 x_ql_creation_date => x_ql_creation_date,
2252 x_ql_created_by => x_ql_created_by,
2253 x_ql_last_updated_by => x_ql_last_updated_by,
2254 x_ql_last_update_date => x_ql_last_update_date,
2255 x_ql_last_update_login => x_ql_last_update_login,
2256 x_ql_request_id => x_ql_request_id,
2257 x_ql_program_application_id => x_ql_program_application_id,
2261 x_ql_quote_header_id => x_ql_quote_header_id,
2258 x_ql_program_id => x_ql_program_id,
2259 x_ql_program_update_date => x_ql_program_update_date,
2260 x_ql_quote_line_id => x_ql_quote_line_id,
2262 x_ql_org_id => x_ql_org_id,
2263 x_ql_line_number => x_ql_line_number,
2264 x_ql_line_category_code => x_ql_line_category_code,
2265 x_ql_item_type_code => x_ql_item_type_code,
2266 x_ql_inventory_item_id => x_ql_inventory_item_id,
2267 x_ql_organization_id => x_ql_organization_id,
2268 x_ql_quantity => x_ql_quantity,
2269 x_ql_uom_code => x_ql_uom_code,
2270 x_ql_start_date_active => x_ql_start_date_active,
2271 x_ql_end_date_active => x_ql_start_date_active,
2272 x_ql_order_line_type_id => x_ql_order_line_type_id,
2273 x_ql_price_list_id => x_ql_price_list_id,
2274 x_ql_price_list_line_id => x_ql_price_list_line_id,
2275 x_ql_currency_code => x_ql_currency_code,
2276 x_ql_line_list_price => x_ql_line_list_price,
2277 x_ql_line_adjusted_amount => x_ql_line_adjusted_amount,
2278 x_ql_line_adjusted_percent => x_ql_line_adjusted_percent,
2279 x_ql_line_quote_price => x_ql_line_quote_price,
2280 x_ql_related_item_id => x_ql_related_item_id,
2281 x_ql_item_relationship_type => x_ql_item_relationship_type,
2282 x_ql_split_shipment_flag => x_ql_split_shipment_flag,
2283 x_ql_backorder_flag => x_ql_backorder_flag,
2284 x_ql_selling_price_change => x_ql_selling_price_change,
2285 x_ql_recalculate_flag => x_ql_recalculate_flag,
2286 x_ql_attribute_category => x_ql_attribute_category,
2287 x_ql_attribute1 => x_ql_attribute1,
2288 x_ql_attribute2 => x_ql_attribute2,
2289 x_ql_attribute3 => x_ql_attribute3,
2290 x_ql_attribute4 => x_ql_attribute4,
2291 x_ql_attribute5 => x_ql_attribute5,
2292 x_ql_attribute6 => x_ql_attribute6,
2293 x_ql_attribute7 => x_ql_attribute7,
2294 x_ql_attribute8 => x_ql_attribute8,
2295 x_ql_attribute9 => x_ql_attribute9,
2296 x_ql_attribute10 => x_ql_attribute10,
2297 x_ql_attribute11 => x_ql_attribute11,
2298 x_ql_attribute12 => x_ql_attribute12,
2299 x_ql_attribute13 => x_ql_attribute13,
2300 x_ql_attribute14 => x_ql_attribute14,
2301 x_ql_attribute15 => x_ql_attribute15,
2302 x_ql_attribute16 => x_ql_attribute16,
2303 x_ql_attribute17 => x_ql_attribute17,
2304 x_ql_attribute18 => x_ql_attribute18,
2305 x_ql_attribute19 => x_ql_attribute19,
2306 x_ql_attribute20 => x_ql_attribute20,
2307 x_ql_accounting_rule_id => x_ql_accounting_rule_id,
2308 x_ql_ffm_content_name => x_ql_ffm_content_name,
2309 x_ql_ffm_content_type => x_ql_ffm_content_type,
2310 x_ql_ffm_document_type => x_ql_ffm_document_type,
2311 x_ql_ffm_media_id => x_ql_ffm_media_id,
2312 x_ql_ffm_media_type => x_ql_ffm_media_type,
2313 x_ql_ffm_user_note => x_ql_ffm_user_note,
2314 x_ql_invoice_to_party_id => x_ql_invoice_to_party_id,
2315 x_ql_invoice_to_party_site_id => x_ql_invoice_to_party_site_id,
2316 x_ql_invoicing_rule_id => x_ql_invoicing_rule_id,
2317 x_ql_marketing_source_code_id => x_ql_marketing_source_code_id,
2318 x_ql_operation_code => x_ql_operation_code,
2319 x_ql_invoice_to_cust_acct_id => x_ql_invoice_to_cust_acct_id,
2320 x_ql_pricing_quantity_uom => x_ql_pricing_quantity_uom,
2321 x_ql_minisite_id => x_ql_minisite_id,
2322 x_ql_section_id => x_ql_section_id,
2323 x_ql_priced_price_list_id => x_ql_priced_price_list_id,
2324 x_ql_agreement_id => x_ql_agreement_id,
2325 x_ql_commitment_id => x_ql_commitment_id,
2326 x_ql_display_arithmetic_op => x_ql_display_arithmetic_op,
2327 x_ql_invoice_to_cust_party_id => x_ql_invoice_to_cust_party_id,
2328 x_ql_ship_model_complete_flag => x_ql_ship_model_complete_flag,
2329 x_ql_charge_periodicity_code => x_ql_charge_periodicity_code,
2330 x_ql_end_cust_party_id => x_ql_end_cust_party_id,
2331 x_ql_end_cust_party_site_id => x_ql_end_cust_party_id,
2332 x_ql_end_cust_cust_account_id => x_ql_end_cust_cust_account_id,
2333 x_ql_end_cust_cust_party_id => x_ql_end_cust_cust_party_id,
2334 x_ql_object_version_number => x_ql_object_version_number,
2335 x_ql_line_paynow_charges => x_ql_line_paynow_charges,
2336 x_ql_line_paynow_tax => x_ql_line_paynow_tax,
2337 x_ql_line_paynow_subtotal => x_ql_line_paynow_subtotal,
2338 x_ql_config_model_type => x_ql_config_model_type
2339 );
2340
2341 ASO_QUOTE_UTIL_PVT.Set_Shipment_rec_Out(
2342 p_shipment_rec => lx_ln_shipment_rec,
2343 x_qs_operation_code => x_qls_operation_code,
2344 x_qs_qte_line_index => x_qls_qte_line_index,
2348 x_qs_last_update_date => x_qls_last_update_date,
2345 x_qs_shipment_id => x_qls_shipment_id,
2346 x_qs_creation_date => x_qls_creation_date,
2347 x_qs_created_by => x_qls_created_by,
2349 x_qs_last_updated_by => x_qls_last_updated_by,
2350 x_qs_last_update_login => x_qls_last_update_login,
2351 x_qs_request_id => x_qls_request_id,
2352 x_qs_program_application_id => x_qls_program_application_id,
2353 x_qs_program_id => x_qls_program_id,
2354 x_qs_program_update_date => x_qls_program_update_date,
2355 x_qs_quote_header_id => x_qls_quote_header_id,
2356 x_qs_quote_line_id => x_qls_quote_line_id,
2357 x_qs_promise_date => x_qls_promise_date,
2358 x_qs_request_date => x_qls_request_date,
2359 x_qs_schedule_ship_date => x_qls_schedule_ship_date,
2360 x_qs_ship_to_party_site_id => x_qls_ship_to_party_site_id,
2361 x_qs_ship_to_party_id => x_qls_ship_to_party_id,
2362 x_qs_ship_to_cust_account_id => x_qls_ship_to_cust_account_id,
2363 x_qs_ship_partial_flag => x_qls_ship_partial_flag,
2364 x_qs_ship_set_id => x_qls_ship_set_id,
2365 x_qs_ship_method_code => x_qls_ship_method_code,
2366 x_qs_freight_terms_code => x_qls_freight_terms_code,
2367 x_qs_freight_carrier_code => x_qls_freight_carrier_code,
2368 x_qs_fob_code => x_qls_fob_code,
2369 x_qs_shipping_instructions => x_qls_shipping_instructions,
2370 x_qs_packing_instructions => x_qls_packing_instructions,
2371 x_qs_quantity => x_qls_quantity,
2372 x_qs_reserved_quantity => x_qls_reserved_quantity,
2373 x_qs_reservation_id => x_qls_reservation_id,
2374 x_qs_order_line_id => x_qls_order_line_id,
2375 x_qs_ship_to_party_name => x_qls_ship_to_party_name,
2376 x_qs_ship_to_cont_first_name => x_qls_ship_to_cont_first_name,
2377 x_qs_ship_to_cont_mid_name => x_qls_ship_to_cont_mid_name,
2378 x_qs_ship_to_cont_last_name => x_qls_ship_to_cont_last_name,
2379 x_qs_ship_to_address1 => x_qls_ship_to_address1,
2380 x_qs_ship_to_address2 => x_qls_ship_to_address2,
2381 x_qs_ship_to_address3 => x_qls_ship_to_address3,
2382 x_qs_ship_to_address4 => x_qls_ship_to_address4,
2383 x_qs_ship_to_country_code => x_qls_ship_to_country_code,
2384 x_qs_ship_to_country => x_qls_ship_to_country,
2385 x_qs_ship_to_city => x_qls_ship_to_city,
2386 x_qs_ship_to_postal_code => x_qls_ship_to_postal_code,
2387 x_qs_ship_to_state => x_qls_ship_to_state,
2388 x_qs_ship_to_province => x_qls_ship_to_province,
2389 x_qs_ship_to_county => x_qls_ship_to_county,
2390 x_qs_attribute_category => x_qls_attribute_category,
2391 x_qs_attribute1 => x_qls_attribute1,
2392 x_qs_attribute2 => x_qls_attribute2,
2393 x_qs_attribute3 => x_qls_attribute3,
2394 x_qs_attribute4 => x_qls_attribute4,
2395 x_qs_attribute5 => x_qls_attribute5,
2396 x_qs_attribute6 => x_qls_attribute6,
2397 x_qs_attribute7 => x_qls_attribute7,
2398 x_qs_attribute8 => x_qls_attribute8,
2399 x_qs_attribute9 => x_qls_attribute9,
2400 x_qs_attribute10 => x_qls_attribute10,
2401 x_qs_attribute11 => x_qls_attribute11,
2402 x_qs_attribute12 => x_qls_attribute12,
2403 x_qs_attribute13 => x_qls_attribute13,
2404 x_qs_attribute14 => x_qls_attribute14,
2405 x_qs_attribute15 => x_qls_attribute15,
2406 x_qs_attribute16 => x_qls_attribute16,
2407 x_qs_attribute17 => x_qls_attribute17,
2408 x_qs_attribute18 => x_qls_attribute18,
2409 x_qs_attribute19 => x_qls_attribute19,
2410 x_qs_attribute20 => x_qls_attribute20,
2411 x_qs_ship_quote_price => x_qls_ship_quote_price,
2412 x_qs_pricing_quantity => x_qls_pricing_quantity,
2413 x_qs_shipment_priority_code => x_qls_shipment_priority_code,
2414 x_qs_ship_from_org_id => x_qls_ship_from_org_id,
2415 x_qs_ship_to_cust_party_id => x_qls_ship_to_cust_party_id,
2416 x_qs_request_date_type => x_qls_request_date_type,
2417 x_qs_demand_class_code => x_qls_demand_class_code,
2418 x_qs_object_version_number => x_qls_object_version_number
2419 );
2420
2421 ASO_QUOTE_UTIL_PVT.Set_Payment_rec_Out(
2422 p_payment_rec => lx_ln_payment_rec,
2423 x_qp_operation_code => x_qlp_operation_code,
2424 x_qp_qte_line_index => x_qlp_qte_line_index,
2425 x_qp_payment_id => x_qlp_payment_id,
2426 x_qp_creation_date => x_qlp_creation_date,
2427 x_qp_created_by => x_qlp_created_by,
2428 x_qp_last_update_date => x_qlp_last_update_date,
2429 x_qp_last_updated_by => x_qlp_last_updated_by,
2430 x_qp_last_update_login => x_qlp_last_update_login,
2431 x_qp_request_id => x_qlp_request_id,
2432 x_qp_program_application_id => x_qlp_program_application_id,
2433 x_qp_program_id => x_qlp_program_id,
2434 x_qp_program_update_date => x_qlp_program_update_date,
2438 x_qp_payment_ref_number => x_qlp_payment_ref_number,
2435 x_qp_quote_header_id => x_qlp_quote_header_id,
2436 x_qp_quote_line_id => x_qlp_quote_line_id,
2437 x_qp_payment_type_code => x_qlp_payment_type_code,
2439 x_qp_payment_option => x_qlp_payment_option,
2440 x_qp_payment_term_id => x_qlp_payment_term_id,
2441 x_qp_credit_card_code => x_qlp_credit_card_code,
2442 x_qp_credit_card_holder_name => x_qlp_credit_card_holder_name,
2443 x_qp_credit_card_exp_date => x_qlp_credit_card_exp_date,
2444 x_qp_credit_card_aprv_code => x_qlp_credit_card_aprv_code,
2445 x_qp_credit_card_aprv_date => x_qlp_credit_card_aprv_date,
2446 x_qp_payment_amount => x_qlp_payment_amount,
2447 x_qp_attribute_category => x_qlp_attribute_category,
2448 x_qp_attribute1 => x_qlp_attribute1,
2449 x_qp_attribute2 => x_qlp_attribute2,
2450 x_qp_attribute3 => x_qlp_attribute3,
2451 x_qp_attribute4 => x_qlp_attribute4,
2452 x_qp_attribute5 => x_qlp_attribute5,
2453 x_qp_attribute6 => x_qlp_attribute6,
2454 x_qp_attribute7 => x_qlp_attribute7,
2455 x_qp_attribute8 => x_qlp_attribute8,
2456 x_qp_attribute9 => x_qlp_attribute9,
2457 x_qp_attribute10 => x_qlp_attribute10,
2458 x_qp_attribute11 => x_qlp_attribute11,
2459 x_qp_attribute12 => x_qlp_attribute12,
2460 x_qp_attribute13 => x_qlp_attribute13,
2461 x_qp_attribute14 => x_qlp_attribute14,
2462 x_qp_attribute15 => x_qlp_attribute15,
2463 x_qp_attribute16 => x_qlp_attribute16,
2464 x_qp_attribute17 => x_qlp_attribute17,
2465 x_qp_attribute18 => x_qlp_attribute18,
2466 x_qp_attribute19 => x_qlp_attribute19,
2467 x_qp_attribute20 => x_qlp_attribute20,
2468 x_qp_shipment_index => x_qlp_shipment_index,
2469 x_qp_quote_shipment_id => x_qlp_quote_shipment_id,
2470 x_qp_cust_po_number => x_qlp_cust_po_number,
2471 x_qp_cust_po_line_number => x_qlp_cust_po_line_number,
2472 x_qp_object_version_number => x_qlp_object_version_number,
2473 x_qp_trxn_extension_id => x_qlp_trxn_extension_id,
2474 x_qp_instrument_id => x_qlp_instrument_id,
2475 x_qp_instr_assignment_id => x_qlp_instr_assignment_id,
2476 x_qp_cvv2 => x_qlp_cvv2
2477
2478 );
2479
2480 ASO_QUOTE_UTIL_PVT.Set_Tax_detail_rec_Out(
2481 p_tax_detail_rec => lx_ln_tax_rec,
2482 x_qt_operation_code => x_qlt_operation_code,
2483 x_qt_qte_line_index => x_qlt_qte_line_index,
2484 x_qt_shipment_index => x_qlt_shipment_index,
2485 x_qt_tax_detail_id => x_qlt_tax_detail_id,
2486 x_qt_quote_header_id => x_qlt_quote_header_id,
2487 x_qt_quote_line_id => x_qlt_quote_line_id,
2488 x_qt_quote_shipment_id => x_qlt_quote_shipment_id,
2489 x_qt_creation_date => x_qlt_creation_date,
2490 x_qt_created_by => x_qlt_created_by,
2491 x_qt_last_update_date => x_qlt_last_update_date,
2492 x_qt_last_updated_by => x_qlt_last_updated_by,
2493 x_qt_last_update_login => x_qlt_last_update_login,
2494 x_qt_request_id => x_qlt_request_id,
2495 x_qt_program_application_id => x_qlt_program_application_id,
2496 x_qt_program_id => x_qlt_program_id,
2497 x_qt_program_update_date => x_qlt_program_update_date,
2498 x_qt_orig_tax_code => x_qlt_orig_tax_code,
2499 x_qt_tax_code => x_qlt_tax_code,
2500 x_qt_tax_rate => x_qlt_tax_rate,
2501 x_qt_tax_date => x_qlt_tax_date,
2502 x_qt_tax_amount => x_qlt_tax_amount,
2503 x_qt_tax_exempt_flag => x_qlt_tax_exempt_flag,
2504 x_qt_tax_exempt_number => x_qlt_tax_exempt_number,
2505 x_qt_tax_exempt_reason_code => x_qlt_tax_exempt_reason_code,
2506 x_qt_attribute_category => x_qlt_attribute_category,
2507 x_qt_attribute1 => x_qlt_attribute1,
2508 x_qt_attribute2 => x_qlt_attribute2,
2509 x_qt_attribute3 => x_qlt_attribute3,
2510 x_qt_attribute4 => x_qlt_attribute4,
2511 x_qt_attribute5 => x_qlt_attribute5,
2512 x_qt_attribute6 => x_qlt_attribute6,
2513 x_qt_attribute7 => x_qlt_attribute7,
2514 x_qt_attribute8 => x_qlt_attribute8,
2515 x_qt_attribute9 => x_qlt_attribute9,
2516 x_qt_attribute10 => x_qlt_attribute10,
2517 x_qt_attribute11 => x_qlt_attribute11,
2518 x_qt_attribute12 => x_qlt_attribute12,
2519 x_qt_attribute13 => x_qlt_attribute13,
2520 x_qt_attribute14 => x_qlt_attribute14,
2521 x_qt_attribute15 => x_qlt_attribute15,
2522 x_qt_attribute16 => x_qlt_attribute16,
2523 x_qt_attribute17 => x_qlt_attribute17,
2524 x_qt_attribute18 => x_qlt_attribute18,
2525 x_qt_attribute19 => x_qlt_attribute19,
2526 x_qt_attribute20 => x_qlt_attribute20,
2527 x_qt_object_version_number => x_qlt_object_version_number,
2528 x_qt_tax_rate_id => x_qlt_tax_rate_id
2529 );
2530
2531 x_q_mis_attribute1 := FND_API.G_MISS_CHAR;
2532 x_qln_mis_attribute1 := FND_API.G_MISS_CHAR;
2533
2534
2535 end Default_Entity;
2536
2537 END Aso_Defaulting_Int_W;
2538