[Home] [Help]
PACKAGE BODY: APPS.ASO_QUOTE_PUB_W1
Source
1 PACKAGE BODY ASO_Quote_Pub_W1 as
2 /* $Header: asovqw2b.pls 120.1.12010000.6 2010/04/19 04:10:11 cazhou ship $ */
3 -- Start of Comments
4 -- Package name : ASO_QUOTE_PUB_W
5 -- Purpose : Rosetta wrappers for ASO Quote Public API
6 -- History : Created on 12/02/01
7 -- NOTE :
8 -- END of Comments
9 ROSETTA_G_MISTAKE_DATE DATE := TO_DATE('01/01/+4713', 'MM/DD/SYYYY');
10 ROSETTA_G_MISS_NUM NUMBER := 0-1962.0724;
11
12 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_QUOTE_PUB_W2';
13 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ASOVQW2B.PLS';
14
15 FUNCTION rosetta_g_miss_num_map(n number) RETURN number as
16 a number := fnd_api.g_miss_num;
17 b number := 0-1962.0724;
18 BEGIN
19 IF n=a THEN RETURN b; END IF;
20 IF n=b THEN RETURN a; END IF;
21 RETURN n;
22 END;
23 PROCEDURE Check_Atp (
24 /* OUT parameters for quote line record ASO_ATP_INT.Atp_Tbl_Typ */
25 x_atp_inventory_item_id OUT NOCOPY jtf_number_table,
26 x_atp_inventory_item_name OUT NOCOPY jtf_varchar2_table_300,
27 x_inventory_item_description OUT NOCOPY JTF_VARCHAR2_TABLE_300,
28 x_padded_concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_300,
29 x_atp_source_organization_id OUT NOCOPY jtf_number_table,
30 x_atp_source_organization_code OUT NOCOPY jtf_varchar2_table_300,
31 x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
32 x_atp_identifier OUT NOCOPY jtf_number_table,
33 x_atp_customer_id OUT NOCOPY jtf_number_table,
34 x_atp_customer_site_id OUT NOCOPY jtf_number_table,
35 x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
36 x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
37 x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
38 x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
39 x_atp_ship_date OUT NOCOPY jtf_date_table,
40 x_atp_available_quantity OUT NOCOPY jtf_number_table,
41 x_atp_request_date_quantity OUT NOCOPY jtf_number_table,
42 x_atp_error_code OUT NOCOPY jtf_number_table,
43 x_atp_message OUT NOCOPY jtf_varchar2_table_2000,
44
45 x_atp_request_date_type OUT NOCOPY jtf_varchar2_table_300,
46 x_atp_req_date_type_meaning OUT NOCOPY jtf_varchar2_table_300,
47 x_atp_demand_class_code OUT NOCOPY jtf_varchar2_table_300,
48 x_atp_demand_class_meaning OUT NOCOPY jtf_varchar2_table_300,
49 x_atp_ship_set_name OUT NOCOPY jtf_varchar2_table_300,
50 x_atp_arrival_set_name OUT NOCOPY jtf_varchar2_table_300,
51 x_atp_line_number OUT NOCOPY jtf_varchar2_table_800,
52 x_atp_group_ship_date OUT NOCOPY jtf_date_table,
53 x_atp_requested_arrival_date OUT NOCOPY jtf_date_table,
54 x_atp_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
55 x_atp_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
56 x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
57 x_atp_quote_header_id OUT NOCOPY jtf_number_table,
58 x_atp_calling_module OUT NOCOPY jtf_number_table,
59 x_atp_quote_number OUT NOCOPY jtf_number_table,
60 x_atp_ato_line_id OUT NOCOPY jtf_number_table,
61 x_atp_ref_line_id OUT NOCOPY jtf_number_table,
62 x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
63 x_atp_action OUT NOCOPY jtf_number_table,
64 x_atp_arrival_date OUT NOCOPY jtf_date_table,
65 x_atp_organization_id OUT NOCOPY jtf_number_table,
66 x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
67 x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
68 x_atp_included_item_flag OUT NOCOPY jtf_number_table,
69 x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,
70 x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,
71 x_atp_country OUT NOCOPY jtf_varchar2_table_600,
72 x_atp_state OUT NOCOPY jtf_varchar2_table_600,
73 x_atp_city OUT NOCOPY jtf_varchar2_table_600,
74 x_atp_postal_code OUT NOCOPY jtf_varchar2_table_600,
75 x_atp_match_item_id OUT NOCOPY jtf_number_table,
76
77 /* parameters for the quote header record */
78 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
79 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
80 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
81 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
82 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
83 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
84 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
85 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
86 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
87 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
88 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
89 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
90 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
91 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
92 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
93 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
95 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
96 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
97 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
98 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
99 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
100 p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
101 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
102 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
104 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
106 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
107 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
108 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
109 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
110 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
111 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
112 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
113 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
114 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
115 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
116 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
117 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
118 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
119 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
120 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
121 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
123 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
127 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
128 p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139 p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140 p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142 p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
152 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
153 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
154 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
159 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
160 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
161 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
162 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
163 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
164 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
165 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
166 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
167 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
168 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
169 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
170 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
171 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
172 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
173 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
174 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
175 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
176 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
177 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
178 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
179 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
180 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
181 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
182 p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
183 p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
184 p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
185 p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
186 p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187 p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
188 p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
189 p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
190 p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
191 p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
192 p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
193 p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
194 p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
195 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
196 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
197 p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
198 p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
199 p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200 p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
201 p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
202 p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
203 p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
204 p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
205 p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
206 p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
207 p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
208 p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
209 p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
210 p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
211 p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
212 p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
213 p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
214 p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
215
216 /* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */
217 p_ql_creation_date IN jtf_date_table := NULL,
218 p_ql_created_by IN jtf_number_table := NULL,
219 p_ql_last_updated_by IN jtf_number_table := NULL,
220 p_ql_last_update_date IN jtf_date_table := NULL,
221 p_ql_last_update_login IN jtf_number_table := NULL,
222 p_ql_request_id IN jtf_number_table := NULL,
223 p_ql_program_application_id IN jtf_number_table := NULL,
224 p_ql_program_id IN jtf_number_table := NULL,
225 p_ql_program_update_date IN jtf_date_table := NULL,
226 p_ql_quote_line_id IN jtf_number_table := NULL,
227 p_ql_quote_header_id IN jtf_number_table := NULL,
228 p_ql_org_id IN jtf_number_table := NULL,
229 p_ql_line_number IN jtf_number_table := NULL,
230 p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
231 p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
232 p_ql_inventory_item_id IN jtf_number_table := NULL,
233 p_ql_organization_id IN jtf_number_table := NULL,
234 p_ql_quantity IN jtf_number_table := NULL,
235 p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
236 p_ql_start_date_active IN jtf_date_table := NULL,
237 p_ql_end_date_active IN jtf_date_table := NULL,
238 p_ql_order_line_type_id IN jtf_number_table := NULL,
239 p_ql_price_list_id IN jtf_number_table := NULL,
240 p_ql_price_list_line_id IN jtf_number_table := NULL,
241 p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
242 p_ql_line_list_price IN jtf_number_table := NULL,
243 p_ql_line_adjusted_amount IN jtf_number_table := NULL,
244 p_ql_line_adjusted_percent IN jtf_number_table := NULL,
245 p_ql_line_quote_price IN jtf_number_table := NULL,
246 p_ql_related_item_id IN jtf_number_table := NULL,
247 p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
248 p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
249 p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
250 p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
251 p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
252 p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
253 p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
254 p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
255 p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
256 p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,
257 p_ql_attribute5 IN jtf_varchar2_table_300 := NULL,
258 p_ql_attribute6 IN jtf_varchar2_table_300 := NULL,
259 p_ql_attribute7 IN jtf_varchar2_table_300 := NULL,
260 p_ql_attribute8 IN jtf_varchar2_table_300 := NULL,
261 p_ql_attribute9 IN jtf_varchar2_table_300 := NULL,
262 p_ql_attribute10 IN jtf_varchar2_table_300 := NULL,
263 p_ql_attribute11 IN jtf_varchar2_table_300 := NULL,
264 p_ql_attribute12 IN jtf_varchar2_table_300 := NULL,
265 p_ql_attribute13 IN jtf_varchar2_table_300 := NULL,
266 p_ql_attribute14 IN jtf_varchar2_table_300 := NULL,
267 p_ql_attribute15 IN jtf_varchar2_table_300 := NULL,
268 p_ql_attribute16 IN jtf_varchar2_table_300 := NULL,
269 p_ql_attribute17 IN jtf_varchar2_table_300 := NULL,
270 p_ql_attribute18 IN jtf_varchar2_table_300 := NULL,
271 p_ql_attribute19 IN jtf_varchar2_table_300 := NULL,
272 p_ql_attribute20 IN jtf_varchar2_table_300 := NULL,
273 p_ql_accounting_rule_id IN jtf_number_table := NULL,
274 p_ql_ffm_content_name IN jtf_varchar2_table_300 := NULL,
275 p_ql_ffm_content_type IN jtf_varchar2_table_300 := NULL,
276 p_ql_ffm_document_type IN jtf_varchar2_table_300 := NULL,
277 p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
278 p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
279 p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
280 p_ql_invoice_to_party_id IN jtf_number_table := NULL,
281 p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
282 p_ql_invoicing_rule_id IN jtf_number_table := NULL,
283 p_ql_marketing_source_code_id IN jtf_number_table := NULL,
284 p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
285 p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
286 p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
287 p_ql_minisite_id IN jtf_number_table := NULL,
288 p_ql_section_id IN jtf_number_table := NULL,
289 p_ql_priced_price_list_id IN jtf_number_table := NULL,
290 p_ql_agreement_id IN jtf_number_table := NULL,
291 p_ql_commitment_id IN jtf_number_table := NULL,
292 p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
293 p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
294
295 /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
296 p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
297 p_qls_qte_line_index IN jtf_number_table := NULL,
298 p_qls_shipment_id IN jtf_number_table := NULL,
299 p_qls_creation_date IN jtf_date_table := NULL,
300 p_qls_created_by IN jtf_number_table := NULL,
301 p_qls_last_update_date IN jtf_date_table := NULL,
302 p_qls_last_updated_by IN jtf_number_table := NULL,
303 p_qls_last_update_login IN jtf_number_table := NULL,
304 p_qls_request_id IN jtf_number_table := NULL,
305 p_qls_program_application_id IN jtf_number_table := NULL,
306 p_qls_program_id IN jtf_number_table := NULL,
307 p_qls_program_update_date IN jtf_date_table := NULL,
308 p_qls_quote_header_id IN jtf_number_table := NULL,
309 p_qls_quote_line_id IN jtf_number_table := NULL,
310 p_qls_promise_date IN jtf_date_table := NULL,
311 p_qls_request_date IN jtf_date_table := NULL,
312 p_qls_schedule_ship_date IN jtf_date_table := NULL,
313 p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
314 p_qls_ship_to_party_id IN jtf_number_table := NULL,
315 p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
316 p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
317 p_qls_ship_set_id IN jtf_number_table := NULL,
318 p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
319 p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
320 p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
321 p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
322 p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
323 p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
324 p_qls_quantity IN jtf_number_table := NULL,
325 p_qls_reserved_quantity IN jtf_varchar2_table_300 := NULL,
326 p_qls_reservation_id IN jtf_number_table := NULL,
327 p_qls_order_line_id IN jtf_number_table := NULL,
328 p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
329 p_qls_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
330 p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
331 p_qls_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
332 p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
333 p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
334 p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
335 p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
336 p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
337 p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
338 p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
339 p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
340 p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
341 p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
342 p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
343 p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
344 p_qls_attribute1 IN jtf_varchar2_table_300 := NULL,
345 p_qls_attribute2 IN jtf_varchar2_table_300 := NULL,
346 p_qls_attribute3 IN jtf_varchar2_table_300 := NULL,
347 p_qls_attribute4 IN jtf_varchar2_table_300 := NULL,
348 p_qls_attribute5 IN jtf_varchar2_table_300 := NULL,
349 p_qls_attribute6 IN jtf_varchar2_table_300 := NULL,
350 p_qls_attribute7 IN jtf_varchar2_table_300 := NULL,
351 p_qls_attribute8 IN jtf_varchar2_table_300 := NULL,
352 p_qls_attribute9 IN jtf_varchar2_table_300 := NULL,
353 p_qls_attribute10 IN jtf_varchar2_table_300 := NULL,
354 p_qls_attribute11 IN jtf_varchar2_table_300 := NULL,
355 p_qls_attribute12 IN jtf_varchar2_table_300 := NULL,
356 p_qls_attribute13 IN jtf_varchar2_table_300 := NULL,
357 p_qls_attribute14 IN jtf_varchar2_table_300 := NULL,
358 p_qls_attribute15 IN jtf_varchar2_table_300 := NULL,
359 p_qls_attribute16 IN jtf_varchar2_table_300 := NULL,
360 p_qls_attribute17 IN jtf_varchar2_table_300 := NULL,
361 p_qls_attribute18 IN jtf_varchar2_table_300 := NULL,
362 p_qls_attribute19 IN jtf_varchar2_table_300 := NULL,
363 p_qls_attribute20 IN jtf_varchar2_table_300 := NULL,
364 p_qls_ship_quote_price IN jtf_number_table := NULL,
365 p_qls_pricing_quantity IN jtf_number_table := NULL,
366 p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
367 p_qls_ship_from_org_id IN jtf_number_table := NULL,
368 p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
369 p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
370 p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
371 p_qls_object_version_number IN jtf_number_table := NULL,
372 /* Standard IN parameters */
373 P_API_VERSION_NUMBER IN NUMBER := 1,
374 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,
375 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
376
377 /* Standard OUT parameters */
378 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
379 X_MSG_COUNT OUT NOCOPY NUMBER,
380 X_MSG_DATA OUT NOCOPY VARCHAR2
381 )
382
383 IS
384
385 l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
386 := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
387
388 l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type
389 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
390
391 l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type
392 := ASO_QUOTE_PUB.G_MISS_Shipment_TBL;
393
394 lx_ln_atp_tbl ASO_ATP_INT.Atp_Tbl_Typ;
395
396 l_ship_site_use_id JTF_NUMBER_TABLE := NULL;
397
398 l_qls_ship_to_party_site_id JTF_NUMBER_TABLE := NULL;
399 l_qls_ship_to_cust_account_id JTF_NUMBER_TABLE := NULL;
400 ddindx binary_integer;
401 indx binary_integer;
402 l_debug VARCHAR2(1);
403
404 CURSOR Get_Site_Use_Id (l_party_site_id NUMBER) IS
405 SELECT csua.site_use_id
406 FROM HZ_PARTY_SITES ps,
407 HZ_CUST_ACCT_SITES_ALL casa,
408 HZ_CUST_SITE_USES_ALL csua
409 WHERE ps.party_site_id = casa.party_site_id
410 AND casa.cust_acct_site_id = csua.cust_acct_site_id
411 AND ps.party_site_id = l_party_site_id;
412
413 BEGIN
414 l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
415 IF l_debug = 'Y' THEN
416 ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
417 END IF;
418 l_qls_ship_to_party_site_id := p_qls_ship_to_party_site_id;
419 l_qls_ship_to_cust_account_id := p_qls_ship_to_cust_account_id;
420 l_ship_site_use_id := JTF_NUMBER_TABLE();
421
422 -- Workaround: set ship_to_party_site_id to ship_to_site_use_id: this is
423 -- because of a bug in ASO ATP
424 IF l_qls_ship_to_party_site_id IS NOT NULL AND l_qls_ship_to_party_site_id.count > 0
425 THEN
426 l_ship_site_use_id.extend(l_qls_ship_to_party_site_id.count);
427 ddindx := l_qls_ship_to_party_site_id.first;
428 indx := 1;
429 WHILE true LOOP
430 OPEN Get_Site_Use_Id(p_qls_ship_to_party_site_id(ddindx));
431 FETCH Get_Site_Use_Id
432 INTO l_ship_site_use_id(indx);
433 IF Get_Site_Use_Id%FOUND
434 THEN
435 l_qls_ship_to_party_site_id(indx) := l_ship_site_use_id(indx);
436 ELSE
437 l_qls_ship_to_party_site_id(indx) := NULL;
438 l_qls_ship_to_cust_account_id(indx) := NULL;
439 END IF;
440 CLOSE Get_Site_Use_Id;
441
442 indx := indx+1;
443 IF l_qls_ship_to_party_site_id.last = ddindx
444 THEN EXIT;
445 END IF;
446 ddindx := l_qls_ship_to_party_site_id.next(ddindx);
447 END LOOP;
448 END IF;
449 -- Construct the quote header record
450 l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
451 p_quote_header_id => p_q_quote_header_id ,
452 p_creation_date => p_q_creation_date ,
453 p_created_by => p_q_created_by ,
454 p_last_updated_by => p_q_last_updated_by ,
455 p_last_update_date => p_q_last_update_date ,
456 p_last_update_login => p_q_last_update_login ,
457 p_request_id => p_q_request_id ,
458 p_program_application_id => p_q_program_application_id ,
459 p_program_id => p_q_program_id ,
460 p_program_update_date => p_q_program_update_date ,
461 p_org_id => p_q_org_id ,
462 p_quote_name => p_q_quote_name ,
463 p_quote_number => p_q_quote_number ,
464 p_quote_version => p_q_quote_version ,
465 p_quote_status_id => p_q_quote_status_id ,
466 p_quote_source_code => p_q_quote_source_code ,
467 p_quote_expiration_date => p_q_quote_expiration_date ,
468 p_price_frozen_date => p_q_price_frozen_date ,
469 p_quote_password => p_q_quote_password ,
470 p_original_system_reference => p_q_original_system_reference ,
471 p_party_id => p_q_party_id ,
472 p_cust_account_id => p_q_cust_account_id ,
473 p_invoice_to_cust_account_id => p_q_invoice_to_cust_acct_id ,
474 p_org_contact_id => p_q_org_contact_id ,
475 p_party_name => p_q_party_name ,
476 p_party_type => p_q_party_type ,
477 p_person_first_name => p_q_person_first_name ,
478 p_person_last_name => p_q_person_last_name ,
479 p_person_middle_name => p_q_person_middle_name ,
480 p_phone_id => p_q_phone_id ,
481 p_price_list_id => p_q_price_list_id ,
482 p_price_list_name => p_q_price_list_name ,
483 p_currency_code => p_q_currency_code ,
484 p_total_list_price => p_q_total_list_price ,
485 p_total_adjusted_amount => p_q_total_adjusted_amount ,
486 p_total_adjusted_percent => p_q_total_adjusted_percent ,
487 p_total_tax => p_q_total_tax ,
488 p_total_shipping_charge => p_q_total_shipping_charge ,
489 p_surcharge => p_q_surcharge ,
490 p_total_quote_price => p_q_total_quote_price ,
491 p_payment_amount => p_q_payment_amount ,
492 p_accounting_rule_id => p_q_accounting_rule_id ,
493 p_exchange_rate => p_q_exchange_rate ,
494 p_exchange_type_code => p_q_exchange_type_code ,
495 p_exchange_rate_date => p_q_exchange_rate_date ,
496 p_quote_category_code => p_q_quote_category_code ,
497 p_quote_status_code => p_q_quote_status_code ,
498 p_quote_status => p_q_quote_status ,
499 p_employee_person_id => p_q_employee_person_id ,
500 p_sales_channel_code => p_q_sales_channel_code ,
501 p_salesrep_first_name => p_q_salesrep_first_name ,
502 p_salesrep_last_name => p_q_salesrep_last_name ,
503 p_attribute_category => p_q_attribute_category ,
504 p_attribute1 => p_q_attribute1 ,
505 p_attribute10 => p_q_attribute10 ,
506 p_attribute11 => p_q_attribute11 ,
507 p_attribute12 => p_q_attribute12 ,
508 p_attribute13 => p_q_attribute13 ,
509 p_attribute14 => p_q_attribute14 ,
510 p_attribute15 => p_q_attribute15 ,
511 p_attribute16 => p_q_attribute16 ,
512 p_attribute17 => p_q_attribute17 ,
513 p_attribute18 => p_q_attribute18 ,
514 p_attribute19 => p_q_attribute19 ,
515 p_attribute20 => p_q_attribute20 ,
516 p_attribute2 => p_q_attribute2 ,
517 p_attribute3 => p_q_attribute3 ,
518 p_attribute4 => p_q_attribute4 ,
519 p_attribute5 => p_q_attribute5 ,
520 p_attribute6 => p_q_attribute6 ,
521 p_attribute7 => p_q_attribute7 ,
522 p_attribute8 => p_q_attribute8 ,
523 p_attribute9 => p_q_attribute9 ,
524 p_contract_id => p_q_contract_id ,
525 p_qte_contract_id => p_q_qte_contract_id ,
526 p_ffm_request_id => p_q_ffm_request_id ,
527 p_invoice_to_address1 => p_q_invoice_to_address1 ,
528 p_invoice_to_address2 => p_q_invoice_to_address2 ,
529 p_invoice_to_address3 => p_q_invoice_to_address3 ,
530 p_invoice_to_address4 => p_q_invoice_to_address4 ,
531 p_invoice_to_city => p_q_invoice_to_city ,
532 p_invoice_to_cont_first_name => p_q_invoice_to_cont_first_name,
533 p_invoice_to_cont_last_name => p_q_invoice_to_cont_last_name ,
534 p_invoice_to_cont_mid_name => p_q_invoice_to_cont_mid_name ,
535 p_invoice_to_country_code => p_q_invoice_to_country_code ,
536 p_invoice_to_country => p_q_invoice_to_country ,
537 p_invoice_to_county => p_q_invoice_to_county ,
538 p_invoice_to_party_id => p_q_invoice_to_party_id ,
539 p_invoice_to_party_name => p_q_invoice_to_party_name ,
540 p_invoice_to_party_site_id => p_q_invoice_to_party_site_id ,
541 p_invoice_to_postal_code => p_q_invoice_to_postal_code ,
542 p_invoice_to_province => p_q_invoice_to_province ,
543 p_invoice_to_state => p_q_invoice_to_state ,
544 p_invoicing_rule_id => p_q_invoicing_rule_id ,
545 p_marketing_source_code_id => p_q_marketing_source_code_id ,
546 p_marketing_source_code => p_q_marketing_source_code ,
547 p_marketing_source_name => p_q_marketing_source_name ,
548 p_orig_mktg_source_code_id => p_q_orig_mktg_source_code_id ,
549 p_order_type_id => p_q_order_type_id ,
550 p_order_id => p_q_order_id ,
551 p_order_number => p_q_order_number ,
552 p_order_type_name => p_q_order_type_name ,
553 p_ordered_date => p_q_ordered_date ,
554 p_resource_id => p_q_resource_id ,
555 p_contract_template_id => p_q_contract_template_id ,
556 p_contract_template_maj_ver => p_q_contract_template_maj_ver ,
557 p_contract_requester_id => p_q_contract_requester_id ,
558 p_contract_approval_level => p_q_contract_approval_level ,
559 p_publish_flag => p_q_publish_flag ,
560 p_resource_grp_id => p_q_resource_grp_id ,
561 p_sold_to_party_site_id => p_q_sold_to_party_site_id ,
562 p_display_arithmetic_operator => p_q_display_arithmetic_op ,
563 p_quote_description => p_q_quote_description ,
564 p_quote_type => p_q_quote_type ,
565 p_minisite_id => p_q_minisite_id ,
566 p_cust_party_id => p_q_cust_party_id ,
567 p_invoice_to_cust_party_id => p_q_invoice_to_cust_party_id ,
568 p_pricing_status_indicator => p_q_pricing_status_indicator ,
569 p_tax_status_indicator => p_q_tax_status_indicator ,
570 p_price_updated_date => p_q_price_updated_date ,
571 p_tax_updated_date => p_q_tax_updated_date ,
572 p_recalculate_flag => p_q_recalculate_flag ,
573 p_price_request_id => p_q_price_request_id ,
574 p_customer_name_and_title => p_q_customer_name_and_title,
575 p_customer_signature_date => p_q_customer_signature_date,
576 p_supplier_name_and_title => p_q_supplier_name_and_title,
577 p_supplier_signature_date => p_q_supplier_signature_date,
578 p_credit_update_date => p_q_credit_update_date ,
579 p_automatic_price_flag => p_q_automatic_price_flag,
580 p_automatic_tax_flag => p_q_automatic_tax_flag,
581 p_assistance_requested => p_q_assistance_requested,
582 p_assistance_reason_code => p_q_assistance_reason_code,
583 p_end_customer_party_id => p_q_end_cust_party_id,
584 p_end_customer_party_site_id => p_q_end_cust_party_site_id,
585 p_end_customer_cust_account_id => p_q_end_cust_cust_account_id,
586 p_end_customer_cust_party_id => p_q_end_cust_cust_party_id,
587 p_object_version_number => p_q_object_version_number
588 );
589
590 -- Construct l_qte_line_tbl table
591 l_qte_line_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Qte_Line_Tbl (
592 p_creation_date => p_ql_creation_date ,
593 p_created_by => p_ql_created_by ,
594 p_last_updated_by => p_ql_last_updated_by ,
595 p_last_update_date => p_ql_last_update_date ,
596 p_last_update_login => p_ql_last_update_login ,
597 p_request_id => p_ql_request_id ,
598 p_program_application_id => p_ql_program_application_id ,
599 p_program_id => p_ql_program_id ,
600 p_program_update_date => p_ql_program_update_date ,
601 p_quote_line_id => p_ql_quote_line_id ,
602 p_quote_header_id => p_ql_quote_header_id ,
603 p_org_id => p_ql_org_id ,
604 p_line_number => p_ql_line_number ,
605 p_line_category_code => p_ql_line_category_code ,
606 p_item_type_code => p_ql_item_type_code ,
607 p_inventory_item_id => p_ql_inventory_item_id ,
608 p_organization_id => p_ql_organization_id ,
609 p_quantity => p_ql_quantity ,
610 p_uom_code => p_ql_uom_code ,
611 p_start_date_active => p_ql_start_date_active ,
612 p_end_date_active => p_ql_end_date_active ,
613 p_order_line_type_id => p_ql_order_line_type_id ,
614 p_price_list_id => p_ql_price_list_id ,
615 p_price_list_line_id => p_ql_price_list_line_id ,
616 p_currency_code => p_ql_currency_code ,
617 p_line_list_price => p_ql_line_list_price ,
618 p_line_adjusted_amount => p_ql_line_adjusted_amount ,
619 p_line_adjusted_percent => p_ql_line_adjusted_percent ,
620 p_line_quote_price => p_ql_line_quote_price ,
621 p_related_item_id => p_ql_related_item_id ,
622 p_item_relationship_type => p_ql_item_relationship_type ,
623 p_split_shipment_flag => p_ql_split_shipment_flag ,
624 p_backorder_flag => p_ql_backorder_flag ,
625 p_selling_price_change => p_ql_selling_price_change ,
626 p_recalculate_flag => p_ql_recalculate_flag ,
627 p_attribute_category => p_ql_attribute_category ,
628 p_attribute1 => p_ql_attribute1 ,
629 p_attribute2 => p_ql_attribute2 ,
630 p_attribute3 => p_ql_attribute3 ,
631 p_attribute4 => p_ql_attribute4 ,
632 p_attribute5 => p_ql_attribute5 ,
633 p_attribute6 => p_ql_attribute6 ,
634 p_attribute7 => p_ql_attribute7 ,
635 p_attribute8 => p_ql_attribute8 ,
636 p_attribute9 => p_ql_attribute9 ,
637 p_attribute10 => p_ql_attribute10 ,
638 p_attribute11 => p_ql_attribute11 ,
639 p_attribute12 => p_ql_attribute12 ,
640 p_attribute13 => p_ql_attribute13 ,
641 p_attribute14 => p_ql_attribute14 ,
642 p_attribute15 => p_ql_attribute15 ,
643 p_attribute16 => p_ql_attribute16 ,
644 p_attribute17 => p_ql_attribute17 ,
645 p_attribute18 => p_ql_attribute18 ,
646 p_attribute19 => p_ql_attribute19 ,
647 p_attribute20 => p_ql_attribute20 ,
648 p_accounting_rule_id => p_ql_accounting_rule_id ,
649 p_ffm_content_name => p_ql_ffm_content_name ,
650 p_ffm_content_type => p_ql_ffm_content_type ,
651 p_ffm_document_type => p_ql_ffm_document_type ,
652 p_ffm_media_id => p_ql_ffm_media_id ,
653 p_ffm_media_type => p_ql_ffm_media_type ,
654 p_ffm_user_note => p_ql_ffm_user_note ,
655 p_invoice_to_party_id => p_ql_invoice_to_party_id ,
656 p_invoice_to_party_site_id => p_ql_invoice_to_party_site_id,
657 p_invoicing_rule_id => p_ql_invoicing_rule_id ,
658 p_marketing_source_code_id => p_ql_marketing_source_code_id,
659 p_operation_code => p_ql_operation_code ,
660 p_invoice_to_cust_account_id => p_ql_invoice_to_cust_acct_id,
661 p_pricing_quantity_uom => p_ql_pricing_quantity_uom ,
662 p_minisite_id => p_ql_minisite_id ,
663 p_section_id => p_ql_section_id ,
664 p_priced_price_list_id => p_ql_priced_price_list_id ,
665 p_agreement_id => p_ql_agreement_id ,
666 p_commitment_id => p_ql_commitment_id ,
667 p_display_arithmetic_operator => p_ql_display_arithmetic_op,
668 p_invoice_to_cust_party_id => p_ql_invoice_to_cust_party_id
669 );
670
671 -- Construct l_ln_shipment_tbl
672 l_ln_shipment_tbl := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Shipment_Tbl(
673 p_operation_code => p_qls_operation_code ,
674 p_qte_line_index => p_qls_qte_line_index ,
675 p_shipment_id => p_qls_shipment_id ,
676 p_creation_date => p_qls_creation_date ,
677 p_created_by => p_qls_created_by ,
678 p_last_update_date => p_qls_last_update_date ,
679 p_last_updated_by => p_qls_last_updated_by ,
680 p_last_update_login => p_qls_last_update_login ,
681 p_request_id => p_qls_request_id ,
682 p_program_application_id => p_qls_program_application_id,
683 p_program_id => p_qls_program_id ,
684 p_program_update_date => p_qls_program_update_date ,
685 p_quote_header_id => p_qls_quote_header_id ,
686 p_quote_line_id => p_qls_quote_line_id ,
687 p_promise_date => p_qls_promise_date ,
688 p_request_date => p_qls_request_date ,
689 p_schedule_ship_date => p_qls_schedule_ship_date ,
690 p_ship_to_party_site_id => l_qls_ship_to_party_site_id ,
691 p_ship_to_party_id => p_qls_ship_to_party_id ,
692 p_ship_to_cust_account_id => l_qls_ship_to_cust_account_id ,
693 p_ship_partial_flag => p_qls_ship_partial_flag ,
694 p_ship_set_id => p_qls_ship_set_id ,
695 p_ship_method_code => p_qls_ship_method_code ,
696 p_freight_terms_code => p_qls_freight_terms_code ,
697 p_freight_carrier_code => p_qls_freight_carrier_code ,
698 p_fob_code => p_qls_fob_code ,
699 p_shipping_instructions => p_qls_shipping_instructions ,
700 p_packing_instructions => p_qls_packing_instructions ,
701 p_quantity => p_qls_quantity ,
702 p_reserved_quantity => p_qls_reserved_quantity ,
703 p_reservation_id => p_qls_reservation_id ,
704 p_order_line_id => p_qls_order_line_id ,
705 p_ship_to_party_name => p_qls_ship_to_party_name ,
706 p_ship_to_cont_first_name => p_qls_ship_to_cont_first_name ,
707 p_ship_to_cont_mid_name => p_qls_ship_to_cont_mid_name ,
708 p_ship_to_cont_last_name => p_qls_ship_to_cont_last_name ,
709 p_ship_to_address1 => p_qls_ship_to_address1 ,
710 p_ship_to_address2 => p_qls_ship_to_address2 ,
711 p_ship_to_address3 => p_qls_ship_to_address3 ,
712 p_ship_to_address4 => p_qls_ship_to_address4 ,
713 p_ship_to_country_code => p_qls_ship_to_country_code ,
714 p_ship_to_country => p_qls_ship_to_country ,
715 p_ship_to_city => p_qls_ship_to_city ,
716 p_ship_to_postal_code => p_qls_ship_to_postal_code ,
717 p_ship_to_state => p_qls_ship_to_state ,
718 p_ship_to_province => p_qls_ship_to_province ,
719 p_ship_to_county => p_qls_ship_to_county ,
720 p_attribute_category => p_qls_attribute_category ,
721 p_attribute1 => p_qls_attribute1 ,
722 p_attribute2 => p_qls_attribute2 ,
723 p_attribute3 => p_qls_attribute3 ,
724 p_attribute4 => p_qls_attribute4 ,
725 p_attribute5 => p_qls_attribute5 ,
726 p_attribute6 => p_qls_attribute6 ,
727 p_attribute7 => p_qls_attribute7 ,
728 p_attribute8 => p_qls_attribute8 ,
729 p_attribute9 => p_qls_attribute9 ,
730 p_attribute10 => p_qls_attribute10 ,
731 p_attribute11 => p_qls_attribute11 ,
732 p_attribute12 => p_qls_attribute12 ,
733 p_attribute13 => p_qls_attribute13 ,
734 p_attribute14 => p_qls_attribute14 ,
735 p_attribute15 => p_qls_attribute15 ,
736 p_attribute16 => p_qls_attribute16 ,
737 p_attribute17 => p_qls_attribute17 ,
738 p_attribute18 => p_qls_attribute18 ,
739 p_attribute19 => p_qls_attribute19 ,
740 p_attribute20 => p_qls_attribute20 ,
741 p_ship_quote_price => p_qls_ship_quote_price ,
742 p_pricing_quantity => p_qls_pricing_quantity ,
743 p_shipment_priority_code => p_qls_shipment_priority_code,
744 p_ship_from_org_id => p_qls_ship_from_org_id ,
745 p_ship_to_cust_party_id => p_qls_ship_to_cust_party_id,
746 p_request_date_type => p_qls_request_date_type,
747 p_demand_class_code => p_qls_demand_class_code,
748 p_object_version_number => p_qls_object_version_number
749
750
751 );
752
753 -- Call ASO API
754 IF l_debug = 'Y'
755 THEN ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_ATP_INT.Check_Atp');
756 END IF;
757 ASO_ATP_INT.Check_Atp(
758 P_API_VERSION_NUMBER => P_API_VERSION_NUMBER,
759 P_INIT_MSG_LIST => P_INIT_MSG_LIST,
760 p_qte_header_rec => l_qte_header_rec,
761 p_qte_line_tbl => l_qte_line_tbl,
762 p_shipment_tbl => l_ln_shipment_tbl,
763 X_RETURN_STATUS => X_RETURN_STATUS,
764 X_MSG_COUNT => X_MSG_COUNT,
765 X_MSG_DATA => X_MSG_DATA,
766 X_ATP_TBL => lx_ln_atp_tbl
767 );
768 IF l_debug = 'Y'
769 THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_ATP_INT.Check_Atp');
770 END IF;
771
772 -- Copy the data back from the local OUT lx_ln_atp_tbl parameter
773 ASO_QUOTE_UTIL_PVT.Set_Atp_Tbl_Out(
774 p_atp_tbl => lx_ln_atp_tbl,
775 x_inventory_item_id => x_atp_inventory_item_id,
776 x_inventory_item_name => x_atp_inventory_item_name,
777 x_inventory_item_description => x_inventory_item_description,
778 x_padded_concatenated_segments => x_padded_concatenated_segments,
779 x_source_organization_id => x_atp_source_organization_id,
780 x_source_organization_code => x_atp_source_organization_code,
781 x_source_organization_name => x_atp_source_organization_name,
782 x_identifier => x_atp_identifier,
783 x_customer_id => x_atp_customer_id,
784 x_customer_site_id => x_atp_customer_site_id,
785 x_quantity_ordered => x_atp_quantity_ordered,
786 x_quantity_uom => x_atp_quantity_uom,
787 x_uom_meaning => x_atp_uom_meaning,
788 x_requested_ship_date => x_atp_requested_ship_date,
789 x_ship_date => x_atp_ship_date,
790 x_available_quantity => x_atp_available_quantity,
791 x_request_date_quantity => x_atp_request_date_quantity,
792 x_error_code => x_atp_error_code,
793 x_message => x_atp_message,
794 x_request_date_type =>x_atp_request_date_type ,
795 x_request_date_type_meaning =>x_atp_req_date_type_meaning,
796 x_demand_class_code =>x_atp_demand_class_code,
797 x_demand_class_meaning =>x_atp_demand_class_meaning,
798 x_ship_set_name =>x_atp_ship_set_name,
799 x_arrival_set_name =>x_atp_arrival_set_name ,
800 x_line_number =>x_atp_line_number,
801 x_group_ship_date => x_atp_group_ship_date,
802 x_requested_arrival_date =>x_atp_requested_arrival_date ,
803 x_ship_method_code =>x_atp_ship_method_code ,
804 x_ship_method_meaning =>x_atp_ship_method_meaning ,
805 x_quantity_on_hand =>x_atp_quantity_on_hand ,
806 x_quote_header_id =>x_atp_quote_header_id ,
807 x_calling_module =>x_atp_calling_module ,
808 x_quote_number =>x_atp_quote_number ,
809 x_ato_line_id =>x_atp_ato_line_id ,
810 x_ref_line_id =>x_atp_ref_line_id ,
811 x_top_model_line_id =>x_atp_top_model_line_id ,
812 x_action =>x_atp_action,
813 x_arrival_date =>x_atp_arrival_date ,
814 x_organization_id =>x_atp_organization_id ,
815 x_component_code =>x_atp_component_code ,
816 x_component_sequence_id =>x_atp_component_sequence_id ,
817 x_included_item_flag =>x_atp_included_item_flag ,
818 x_cascade_model_info_to_comp =>x_atp_cascade_mdl_info_to_comp ,
819 x_ship_to_party_site_id =>x_atp_ship_to_party_site_id ,
820 x_country =>x_atp_country ,
821 x_state =>x_atp_state,
822 x_city =>x_atp_city ,
823 x_postal_code =>x_atp_postal_code ,
824 x_match_item_id =>x_atp_match_item_id
825 );
826 IF l_debug = 'Y' THEN
827 ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
828 END IF;
829 END Check_Atp;
830
831 Procedure Get_Payment_Channel_Attribs (
832 p_instr_channel_code IN VARCHAR2,
833 x_instr_secCode_Use OUT NOCOPY VARCHAR2,
834 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
835 X_MSG_COUNT OUT NOCOPY NUMBER,
836 X_MSG_DATA OUT NOCOPY VARCHAR2)
837 IS
838 l_debug varchar2(1);
839 lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
840 lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
841
842 BEGIN
843 l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
844 IF l_debug = 'Y' THEN
845 ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
846 END IF;
847
848 IF l_debug = 'Y' THEN
849 ASO_QUOTE_UTIL_PVT.Debug('Before Calling IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs');
850 ASO_QUOTE_UTIL_PVT.Debug('Payment Channel Code is : '||p_instr_channel_code);
851 END IF;
852
853 IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
854 (
855 p_api_version => 1.0,
856 p_init_msg_list => FND_API.G_FALSE,
857 x_return_status => x_return_status,
858 x_msg_count => x_msg_count,
859 x_msg_data => x_msg_data,
860 p_channel_code => p_instr_channel_code,
861 x_channel_attrib_uses => lx_channel_attrib_uses,
862 x_response => lx_response);
863
864
865 IF l_debug = 'Y' THEN
866 ASO_QUOTE_UTIL_PVT.Debug('After Calling IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs');
867 ASO_QUOTE_UTIL_PVT.Debug('Return Status: '||x_return_status);
868 ASO_QUOTE_UTIL_PVT.Debug('SecCode Use : '||lx_channel_attrib_uses.Instr_SecCode_Use);
869 ASO_QUOTE_UTIL_PVT.Debug('x_response.result_code: '|| to_char(lx_response.result_code));
870 ASO_QUOTE_UTIL_PVT.Debug('x_response.result_category:'|| to_char(lx_response.result_category));
871 ASO_QUOTE_UTIL_PVT.Debug('_response.result_message: '|| to_char(lx_response.result_message));
872 END IF;
873
874 -- Assign the output value
875 x_instr_secCode_Use := lx_channel_attrib_uses.Instr_SecCode_Use;
876
877
878 IF l_debug = 'Y' THEN
879 ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
880 END IF;
881
882 END Get_Payment_Channel_Attribs;
883
884 PROCEDURE Validate_Model_Configuration
885 (
886 x_return_status OUT NOCOPY VARCHAR2,
887 x_msg_count OUT NOCOPY VARCHAR2,
888 x_msg_data OUT NOCOPY VARCHAR2,
889 x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
890 x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
891 x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
892 x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
893 p_quote_header_id IN NUMBER :=FND_API.G_MISS_NUM,
894 p_quote_line_id IN NUMBER :=FND_API.G_MISS_NUM,
895 p_update_quote IN VARCHAR2 := FND_API.G_MISS_CHAR,
896 p_config_effective_date IN DATE :=FND_API.G_MISS_DATE,
897 p_config_model_lookup_date IN DATE :=FND_API.G_MISS_DATE
898 )
899 IS
900 l_debug VARCHAR2(1);
901 lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;
902
903 BEGIN
904
905 l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
906
907 IF l_debug = 'Y' THEN
908 ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
909 END IF;
910
911
912 ASO_QUOTE_PUB.validate_model_configuration
913 (
914 P_Api_Version_Number => 1.0,
915 P_Init_Msg_List => FND_API.G_TRUE,
916 P_Commit => FND_API.G_FALSE,
917 P_Quote_header_id => p_quote_header_id,
918 p_Quote_line_id => p_quote_line_id,
919 P_UPDATE_QUOTE => p_update_quote,
920 P_CONFIG_EFFECTIVE_DATE => p_config_effective_date,
921 P_config_model_lookup_DATE => p_config_model_lookup_date,
922 X_Config_tbl => lx_config_tbl,
923 X_Return_Status => x_return_status,
924 X_Msg_Count => x_msg_count,
925 X_Msg_Data => x_msg_data
926 );
927
928 ASO_QUOTE_UTIL_PVT.Set_Config_Valid_Table_Out
929 (
930 p_config_table => lx_config_tbl,
931 x_quote_line_id => x_quote_line_id,
932 x_changed_flag => x_changed_flag,
933 x_valid_flag => x_valid_flag,
934 x_complete_flag => x_complete_flag
935 );
936
937 IF l_debug = 'Y'
938 THEN
939 ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_quote_pub.validate_model_configuration');
940 ASO_QUOTE_UTIL_PVT.Debug('x_return_status:'|| x_return_status);
941 ASO_QUOTE_UTIL_PVT.Debug('x_return_status:'|| x_msg_data);
942 END IF;
943 END Validate_Model_Configuration;
944
945
946 PROCEDURE Copy_From_Quote(
947 x_quote_header_id OUT NOCOPY NUMBER,
948 x_quote_number OUT NOCOPY NUMBER,
949 p_cq_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
950 p_cq_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
951 p_cq_quote_number IN NUMBER := FND_API.G_MISS_NUM,
952 p_cq_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
953 p_cq_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
954 p_cq_resource_id IN NUMBER := FND_API.G_MISS_NUM,
955 p_cq_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
956 p_cq_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
957 p_cq_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
958 p_cq_price_updated_date IN DATE := FND_API.G_MISS_DATE,
959 p_cq_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
960 p_cc_copy_header_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
961 p_cc_new_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
962 p_cc_copy_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
963 p_cc_copy_task IN VARCHAR2 := FND_API.G_MISS_CHAR,
964 p_cc_copy_attachment IN VARCHAR2 := FND_API.G_MISS_CHAR,
965 p_cc_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
966 p_cc_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
967 p_cc_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
968 p_cc_calc_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
969 p_cc_calculate_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
970 p_cc_copy_shipping IN VARCHAR2 := FND_API.G_MISS_CHAR,
971 p_cc_copy_billing IN VARCHAR2 := FND_API.G_MISS_CHAR,
972 p_cc_copy_payment IN VARCHAR2 := FND_API.G_MISS_CHAR,
973 p_cc_copy_sales_supplement IN VARCHAR2 := FND_API.G_MISS_CHAR,
974 p_cc_copy_sales_credit IN VARCHAR2 := FND_API.G_MISS_CHAR,
975 p_cc_copy_flexfield IN VARCHAR2 := FND_API.G_MISS_CHAR,
976 p_cc_copy_contract_terms IN VARCHAR2 := FND_API.G_MISS_CHAR,
977 p_cc_copy_end_customer IN VARCHAR2 := FND_API.G_MISS_CHAR,
978 p_cc_copy_sales_team IN VARCHAR2 := FND_API.G_MISS_CHAR,
979 p_cc_copy_line_shipping IN VARCHAR2 := FND_API.G_MISS_CHAR,
980 p_cc_copy_line_billing IN VARCHAR2 := FND_API.G_MISS_CHAR,
981 p_cc_copy_line_end_customer IN VARCHAR2 := FND_API.G_MISS_CHAR,
982 p_cc_copy_line_payment IN VARCHAR2 := FND_API.G_MISS_CHAR,
983 p_cc_copy_line_sales_supp IN VARCHAR2 := FND_API.G_MISS_CHAR,
984 p_cc_copy_line_flexfield IN VARCHAR2 := FND_API.G_MISS_CHAR,
985 p_cc_copy_line_attachment IN VARCHAR2 := FND_API.G_MISS_CHAR,
986 p_cc_copy_line_sales_credit IN VARCHAR2 := FND_API.G_MISS_CHAR,
987 p_cc_copy_to_same_customer IN VARCHAR2 := FND_API.G_MISS_CHAR,
988 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
989 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
990 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
991 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
992 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
993 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
994 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
995 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
996 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
997 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
998 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
999 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1000 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
1001 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
1002 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
1003 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1004 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
1005 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
1006 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
1008 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
1009 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1010 p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
1011 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1012 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1014 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1015 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1016 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1017 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
1018 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
1019 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1020 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1021 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
1022 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
1023 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
1024 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
1025 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
1026 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
1027 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
1028 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
1029 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
1030 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
1031 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1032 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
1033 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1034 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1035 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
1036 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
1037 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1038 p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1039 p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1040 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1041 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1042 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1043 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1044 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1045 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1046 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1047 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1048 p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1049 p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1050 p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1051 p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1052 p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1053 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1054 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1055 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1056 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1057 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1058 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1059 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1060 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1061 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
1062 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
1063 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
1064 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1065 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1066 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1067 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1068 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
1069 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1070 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1071 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1072 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1073 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
1074 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
1075 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
1076 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1077 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
1078 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
1082 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
1083 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
1086 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
1087 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
1088 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
1089 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1090 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
1091 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1092 p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
1093 p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
1094 p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
1095 p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
1096 p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1097 p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
1098 p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
1099 p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
1100 p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1101 p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1102 p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
1103 p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
1104 p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
1105 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1106 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1107 p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
1108 p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
1109 p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1110 p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
1111 p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
1112 p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
1113 p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
1114 p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
1115 p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
1116 p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
1117 p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
1118 p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1119 p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
1120 p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1121 p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1122 p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
1123 p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1124 p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
1125 p_q_header_paynow_charges IN NUMBER := FND_API.G_MISS_NUM,
1126 -- hd shipment record
1127 p_qs_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1128 p_qs_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
1129 p_qs_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
1130 p_qs_creation_date IN DATE := FND_API.G_MISS_DATE,
1131 p_qs_created_by IN NUMBER := FND_API.G_MISS_NUM,
1132 p_qs_last_update_date IN DATE := FND_API.G_MISS_DATE,
1133 p_qs_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1134 p_qs_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1135 p_qs_request_id IN NUMBER := FND_API.G_MISS_NUM,
1136 p_qs_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
1137 p_qs_program_id IN NUMBER := FND_API.G_MISS_NUM,
1138 p_qs_program_update_date IN DATE := FND_API.G_MISS_DATE,
1139 p_qs_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
1140 p_qs_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
1141 p_qs_promise_date IN DATE := FND_API.G_MISS_DATE,
1142 p_qs_request_date IN DATE := FND_API.G_MISS_DATE,
1143 p_qs_schedule_ship_date IN DATE := FND_API.G_MISS_DATE,
1144 p_qs_ship_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
1145 p_qs_ship_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
1146 p_qs_ship_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1147 p_qs_ship_partial_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1148 p_qs_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,
1149 p_qs_ship_method_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1150 p_qs_freight_terms_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1151 p_qs_freight_carrier_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1152 p_qs_fob_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1153 p_qs_shipping_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
1154 p_qs_packing_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
1155 p_qs_quantity IN NUMBER := FND_API.G_MISS_NUM,
1156 p_qs_reserved_quantity IN VARCHAR2 := FND_API.G_MISS_CHAR,
1157 p_qs_reservation_id IN NUMBER := FND_API.G_MISS_NUM,
1158 p_qs_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
1159 p_qs_ship_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1160 p_qs_ship_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1161 p_qs_ship_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1162 p_qs_ship_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1163 p_qs_ship_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1164 p_qs_ship_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1165 p_qs_ship_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1166 p_qs_ship_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1167 p_qs_ship_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1168 p_qs_ship_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
1169 p_qs_ship_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
1170 p_qs_ship_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1171 p_qs_ship_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
1172 p_qs_ship_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
1173 p_qs_ship_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
1174 p_qs_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1175 p_qs_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1176 p_qs_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1177 p_qs_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1178 p_qs_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1179 p_qs_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1180 p_qs_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1181 p_qs_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1182 p_qs_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1183 p_qs_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1184 p_qs_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1185 p_qs_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1186 p_qs_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1187 p_qs_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1188 p_qs_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1189 p_qs_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1190 p_qs_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1191 p_qs_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1192 p_qs_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1193 p_qs_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1194 p_qs_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1195 p_qs_ship_quote_price IN NUMBER := FND_API.G_MISS_NUM,
1196 p_qs_pricing_quantity IN NUMBER := FND_API.G_MISS_NUM,
1197 p_qs_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1198 p_qs_ship_from_org_id IN NUMBER := FND_API.G_MISS_NUM,
1199 p_qs_ship_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
1200 p_qs_request_date_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1201 p_qs_demand_class_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1202 p_qs_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
1203 -- hd payment record
1204 p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
1205 p_qp_qte_line_index IN jtf_number_table := NULL,
1206 p_qp_payment_id IN jtf_number_table := NULL,
1207 p_qp_creation_date IN jtf_date_table := NULL,
1208 p_qp_created_by IN jtf_number_table := NULL,
1209 p_qp_last_update_date IN jtf_date_table := NULL,
1210 p_qp_last_updated_by IN jtf_number_table := NULL,
1211 p_qp_last_update_login IN jtf_number_table := NULL,
1212 p_qp_request_id IN jtf_number_table := NULL,
1213 p_qp_program_application_id IN jtf_number_table := NULL,
1214 p_qp_program_id IN jtf_number_table := NULL,
1215 p_qp_program_update_date IN jtf_date_table := NULL,
1216 p_qp_quote_header_id IN jtf_number_table := NULL,
1217 p_qp_quote_line_id IN jtf_number_table := NULL,
1218 p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
1219 p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
1220 p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
1221 p_qp_payment_term_id IN jtf_number_table := NULL,
1222 p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
1223 p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
1224 p_qp_credit_card_exp_date IN jtf_date_table := NULL,
1225 p_qp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
1226 p_qp_credit_card_aprv_date IN jtf_date_table := NULL,
1227 p_qp_payment_amount IN jtf_number_table := NULL,
1228 p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,
1229 p_qp_attribute1 IN jtf_varchar2_table_300 := NULL,
1230 p_qp_attribute2 IN jtf_varchar2_table_300 := NULL,
1231 p_qp_attribute3 IN jtf_varchar2_table_300 := NULL,
1232 p_qp_attribute4 IN jtf_varchar2_table_300 := NULL,
1233 p_qp_attribute5 IN jtf_varchar2_table_300 := NULL,
1234 p_qp_attribute6 IN jtf_varchar2_table_300 := NULL,
1235 p_qp_attribute7 IN jtf_varchar2_table_300 := NULL,
1236 p_qp_attribute8 IN jtf_varchar2_table_300 := NULL,
1237 p_qp_attribute9 IN jtf_varchar2_table_300 := NULL,
1238 p_qp_attribute10 IN jtf_varchar2_table_300 := NULL,
1239 p_qp_attribute11 IN jtf_varchar2_table_300 := NULL,
1240 p_qp_attribute12 IN jtf_varchar2_table_300 := NULL,
1241 p_qp_attribute13 IN jtf_varchar2_table_300 := NULL,
1242 p_qp_attribute14 IN jtf_varchar2_table_300 := NULL,
1243 p_qp_attribute15 IN jtf_varchar2_table_300 := NULL,
1244 p_qp_attribute16 IN jtf_varchar2_table_300 := NULL,
1245 p_qp_attribute17 IN jtf_varchar2_table_300 := NULL,
1246 p_qp_attribute18 IN jtf_varchar2_table_300 := NULL,
1247 p_qp_attribute19 IN jtf_varchar2_table_300 := NULL,
1248 p_qp_attribute20 IN jtf_varchar2_table_300 := NULL,
1249 p_qp_shipment_index IN jtf_number_table := NULL,
1250 p_qp_quote_shipment_id IN jtf_number_table := NULL,
1251 p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
1252 p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
1253 p_qp_trxn_extension_id IN jtf_number_table := NULL,
1254 p_qp_instrument_id IN jtf_number_table := NULL,
1255 p_qp_instr_assignment_id IN jtf_number_table := NULL,
1256 p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
1257 p_qp_object_version_number IN jtf_number_table := NULL,
1258 -- hd price attributes
1259 p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
1260 p_qpa_qte_line_index IN jtf_number_table := NULL,
1261 p_qpa_price_attribute_id IN jtf_number_table := NULL,
1262 p_qpa_creation_date IN jtf_date_table := NULL,
1263 p_qpa_created_by IN jtf_number_table := NULL,
1264 p_qpa_last_update_date IN jtf_date_table := NULL,
1265 p_qpa_last_updated_by IN jtf_number_table := NULL,
1266 p_qpa_last_update_login IN jtf_number_table := NULL,
1267 p_qpa_request_id IN jtf_number_table := NULL,
1268 p_qpa_program_application_id IN jtf_number_table := NULL,
1269 p_qpa_program_id IN jtf_number_table := NULL,
1270 p_qpa_program_update_date IN jtf_date_table := NULL,
1271 p_qpa_quote_header_id IN jtf_number_table := NULL,
1272 p_qpa_quote_line_id IN jtf_number_table := NULL,
1273 p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
1274 p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
1275 p_qpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
1276 p_qpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
1277 p_qpa_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,
1278 p_qpa_pricing_attribute4 IN jtf_varchar2_table_300 := NULL,
1279 p_qpa_pricing_attribute5 IN jtf_varchar2_table_300 := NULL,
1280 p_qpa_pricing_attribute6 IN jtf_varchar2_table_300 := NULL,
1281 p_qpa_pricing_attribute7 IN jtf_varchar2_table_300 := NULL,
1282 p_qpa_pricing_attribute8 IN jtf_varchar2_table_300 := NULL,
1283 p_qpa_pricing_attribute9 IN jtf_varchar2_table_300 := NULL,
1284 p_qpa_pricing_attribute10 IN jtf_varchar2_table_300 := NULL,
1285 p_qpa_pricing_attribute11 IN jtf_varchar2_table_300 := NULL,
1286 p_qpa_pricing_attribute12 IN jtf_varchar2_table_300 := NULL,
1287 p_qpa_pricing_attribute13 IN jtf_varchar2_table_300 := NULL,
1288 p_qpa_pricing_attribute14 IN jtf_varchar2_table_300 := NULL,
1289 p_qpa_pricing_attribute15 IN jtf_varchar2_table_300 := NULL,
1290 p_qpa_pricing_attribute16 IN jtf_varchar2_table_300 := NULL,
1291 p_qpa_pricing_attribute17 IN jtf_varchar2_table_300 := NULL,
1292 p_qpa_pricing_attribute18 IN jtf_varchar2_table_300 := NULL,
1293 p_qpa_pricing_attribute19 IN jtf_varchar2_table_300 := NULL,
1294 p_qpa_pricing_attribute20 IN jtf_varchar2_table_300 := NULL,
1295 p_qpa_pricing_attribute21 IN jtf_varchar2_table_300 := NULL,
1296 p_qpa_pricing_attribute22 IN jtf_varchar2_table_300 := NULL,
1297 p_qpa_pricing_attribute23 IN jtf_varchar2_table_300 := NULL,
1298 p_qpa_pricing_attribute24 IN jtf_varchar2_table_300 := NULL,
1299 p_qpa_pricing_attribute25 IN jtf_varchar2_table_300 := NULL,
1300 p_qpa_pricing_attribute26 IN jtf_varchar2_table_300 := NULL,
1301 p_qpa_pricing_attribute27 IN jtf_varchar2_table_300 := NULL,
1302 p_qpa_pricing_attribute28 IN jtf_varchar2_table_300 := NULL,
1303 p_qpa_pricing_attribute29 IN jtf_varchar2_table_300 := NULL,
1304 p_qpa_pricing_attribute30 IN jtf_varchar2_table_300 := NULL,
1305 p_qpa_pricing_attribute31 IN jtf_varchar2_table_300 := NULL,
1306 p_qpa_pricing_attribute32 IN jtf_varchar2_table_300 := NULL,
1307 p_qpa_pricing_attribute33 IN jtf_varchar2_table_300 := NULL,
1308 p_qpa_pricing_attribute34 IN jtf_varchar2_table_300 := NULL,
1309 p_qpa_pricing_attribute35 IN jtf_varchar2_table_300 := NULL,
1310 p_qpa_pricing_attribute36 IN jtf_varchar2_table_300 := NULL,
1311 p_qpa_pricing_attribute37 IN jtf_varchar2_table_300 := NULL,
1312 p_qpa_pricing_attribute38 IN jtf_varchar2_table_300 := NULL,
1313 p_qpa_pricing_attribute39 IN jtf_varchar2_table_300 := NULL,
1314 p_qpa_pricing_attribute40 IN jtf_varchar2_table_300 := NULL,
1315 p_qpa_pricing_attribute41 IN jtf_varchar2_table_300 := NULL,
1316 p_qpa_pricing_attribute42 IN jtf_varchar2_table_300 := NULL,
1317 p_qpa_pricing_attribute43 IN jtf_varchar2_table_300 := NULL,
1318 p_qpa_pricing_attribute44 IN jtf_varchar2_table_300 := NULL,
1319 p_qpa_pricing_attribute45 IN jtf_varchar2_table_300 := NULL,
1320 p_qpa_pricing_attribute46 IN jtf_varchar2_table_300 := NULL,
1321 p_qpa_pricing_attribute47 IN jtf_varchar2_table_300 := NULL,
1322 p_qpa_pricing_attribute48 IN jtf_varchar2_table_300 := NULL,
1323 p_qpa_pricing_attribute49 IN jtf_varchar2_table_300 := NULL,
1324 p_qpa_pricing_attribute50 IN jtf_varchar2_table_300 := NULL,
1325 p_qpa_pricing_attribute51 IN jtf_varchar2_table_300 := NULL,
1326 p_qpa_pricing_attribute52 IN jtf_varchar2_table_300 := NULL,
1327 p_qpa_pricing_attribute53 IN jtf_varchar2_table_300 := NULL,
1328 p_qpa_pricing_attribute54 IN jtf_varchar2_table_300 := NULL,
1329 p_qpa_pricing_attribute55 IN jtf_varchar2_table_300 := NULL,
1330 p_qpa_pricing_attribute56 IN jtf_varchar2_table_300 := NULL,
1331 p_qpa_pricing_attribute57 IN jtf_varchar2_table_300 := NULL,
1332 p_qpa_pricing_attribute58 IN jtf_varchar2_table_300 := NULL,
1333 p_qpa_pricing_attribute59 IN jtf_varchar2_table_300 := NULL,
1334 p_qpa_pricing_attribute60 IN jtf_varchar2_table_300 := NULL,
1335 p_qpa_pricing_attribute61 IN jtf_varchar2_table_300 := NULL,
1336 p_qpa_pricing_attribute62 IN jtf_varchar2_table_300 := NULL,
1337 p_qpa_pricing_attribute63 IN jtf_varchar2_table_300 := NULL,
1338 p_qpa_pricing_attribute64 IN jtf_varchar2_table_300 := NULL,
1339 p_qpa_pricing_attribute65 IN jtf_varchar2_table_300 := NULL,
1340 p_qpa_pricing_attribute66 IN jtf_varchar2_table_300 := NULL,
1341 p_qpa_pricing_attribute67 IN jtf_varchar2_table_300 := NULL,
1342 p_qpa_pricing_attribute68 IN jtf_varchar2_table_300 := NULL,
1343 p_qpa_pricing_attribute69 IN jtf_varchar2_table_300 := NULL,
1344 p_qpa_pricing_attribute70 IN jtf_varchar2_table_300 := NULL,
1345 p_qpa_pricing_attribute71 IN jtf_varchar2_table_300 := NULL,
1346 p_qpa_pricing_attribute72 IN jtf_varchar2_table_300 := NULL,
1347 p_qpa_pricing_attribute73 IN jtf_varchar2_table_300 := NULL,
1348 p_qpa_pricing_attribute74 IN jtf_varchar2_table_300 := NULL,
1349 p_qpa_pricing_attribute75 IN jtf_varchar2_table_300 := NULL,
1350 p_qpa_pricing_attribute76 IN jtf_varchar2_table_300 := NULL,
1351 p_qpa_pricing_attribute77 IN jtf_varchar2_table_300 := NULL,
1352 p_qpa_pricing_attribute78 IN jtf_varchar2_table_300 := NULL,
1353 p_qpa_pricing_attribute79 IN jtf_varchar2_table_300 := NULL,
1354 p_qpa_pricing_attribute80 IN jtf_varchar2_table_300 := NULL,
1355 p_qpa_pricing_attribute81 IN jtf_varchar2_table_300 := NULL,
1356 p_qpa_pricing_attribute82 IN jtf_varchar2_table_300 := NULL,
1357 p_qpa_pricing_attribute83 IN jtf_varchar2_table_300 := NULL,
1358 p_qpa_pricing_attribute84 IN jtf_varchar2_table_300 := NULL,
1359 p_qpa_pricing_attribute85 IN jtf_varchar2_table_300 := NULL,
1360 p_qpa_pricing_attribute86 IN jtf_varchar2_table_300 := NULL,
1361 p_qpa_pricing_attribute87 IN jtf_varchar2_table_300 := NULL,
1362 p_qpa_pricing_attribute88 IN jtf_varchar2_table_300 := NULL,
1363 p_qpa_pricing_attribute89 IN jtf_varchar2_table_300 := NULL,
1364 p_qpa_pricing_attribute90 IN jtf_varchar2_table_300 := NULL,
1365 p_qpa_pricing_attribute91 IN jtf_varchar2_table_300 := NULL,
1366 p_qpa_pricing_attribute92 IN jtf_varchar2_table_300 := NULL,
1367 p_qpa_pricing_attribute93 IN jtf_varchar2_table_300 := NULL,
1368 p_qpa_pricing_attribute94 IN jtf_varchar2_table_300 := NULL,
1369 p_qpa_pricing_attribute95 IN jtf_varchar2_table_300 := NULL,
1370 p_qpa_pricing_attribute96 IN jtf_varchar2_table_300 := NULL,
1371 p_qpa_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
1372 p_qpa_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
1373 p_qpa_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
1374 p_qpa_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
1375 p_qpa_context IN jtf_varchar2_table_100 := NULL,
1376 p_qpa_attribute1 IN jtf_varchar2_table_300 := NULL,
1377 p_qpa_attribute2 IN jtf_varchar2_table_300 := NULL,
1378 p_qpa_attribute3 IN jtf_varchar2_table_300 := NULL,
1379 p_qpa_attribute4 IN jtf_varchar2_table_300 := NULL,
1380 p_qpa_attribute5 IN jtf_varchar2_table_300 := NULL,
1381 p_qpa_attribute6 IN jtf_varchar2_table_300 := NULL,
1382 p_qpa_attribute7 IN jtf_varchar2_table_300 := NULL,
1383 p_qpa_attribute8 IN jtf_varchar2_table_300 := NULL,
1384 p_qpa_attribute9 IN jtf_varchar2_table_300 := NULL,
1385 p_qpa_attribute10 IN jtf_varchar2_table_300 := NULL,
1386 p_qpa_attribute11 IN jtf_varchar2_table_300 := NULL,
1387 p_qpa_attribute12 IN jtf_varchar2_table_300 := NULL,
1388 p_qpa_attribute13 IN jtf_varchar2_table_300 := NULL,
1389 p_qpa_attribute14 IN jtf_varchar2_table_300 := NULL,
1390 p_qpa_attribute15 IN jtf_varchar2_table_300 := NULL,
1391 p_qpa_attribute16 IN jtf_varchar2_table_300 := NULL,
1392 p_qpa_attribute17 IN jtf_varchar2_table_300 := NULL,
1393 p_qpa_attribute18 IN jtf_varchar2_table_300 := NULL,
1394 p_qpa_attribute19 IN jtf_varchar2_table_300 := NULL,
1395 p_qpa_attribute20 IN jtf_varchar2_table_300 := NULL,
1396 p_qpa_object_version_number IN jtf_number_table := NULL,
1397 --hd tax details
1398 p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
1399 p_qt_qte_line_index IN jtf_number_table := NULL,
1400 p_qt_shipment_index IN jtf_number_table := NULL,
1401 p_qt_tax_detail_id IN jtf_number_table := NULL,
1402 p_qt_quote_header_id IN jtf_number_table := NULL,
1403 p_qt_quote_line_id IN jtf_number_table := NULL,
1404 p_qt_quote_shipment_id IN jtf_number_table := NULL,
1405 p_qt_creation_date IN jtf_date_table := NULL,
1406 p_qt_created_by IN jtf_number_table := NULL,
1407 p_qt_last_update_date IN jtf_date_table := NULL,
1408 p_qt_last_updated_by IN jtf_number_table := NULL,
1409 p_qt_last_update_login IN jtf_number_table := NULL,
1410 p_qt_request_id IN jtf_number_table := NULL,
1411 p_qt_program_application_id IN jtf_number_table := NULL,
1412 p_qt_program_id IN jtf_number_table := NULL,
1413 p_qt_program_update_date IN jtf_date_table := NULL,
1414 p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
1415 p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
1416 p_qt_tax_rate IN jtf_number_table := NULL,
1417 p_qt_tax_date IN jtf_date_table := NULL,
1418 p_qt_tax_amount IN jtf_number_table := NULL,
1419 p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1420 p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1421 p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1422 p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
1423 p_qt_attribute1 IN jtf_varchar2_table_300 := NULL,
1424 p_qt_attribute2 IN jtf_varchar2_table_300 := NULL,
1425 p_qt_attribute3 IN jtf_varchar2_table_300 := NULL,
1426 p_qt_attribute4 IN jtf_varchar2_table_300 := NULL,
1427 p_qt_attribute5 IN jtf_varchar2_table_300 := NULL,
1428 p_qt_attribute6 IN jtf_varchar2_table_300 := NULL,
1429 p_qt_attribute7 IN jtf_varchar2_table_300 := NULL,
1430 p_qt_attribute8 IN jtf_varchar2_table_300 := NULL,
1431 p_qt_attribute9 IN jtf_varchar2_table_300 := NULL,
1432 p_qt_attribute10 IN jtf_varchar2_table_300 := NULL,
1433 p_qt_attribute11 IN jtf_varchar2_table_300 := NULL,
1434 p_qt_attribute12 IN jtf_varchar2_table_300 := NULL,
1435 p_qt_attribute13 IN jtf_varchar2_table_300 := NULL,
1436 p_qt_attribute14 IN jtf_varchar2_table_300 := NULL,
1437 p_qt_attribute15 IN jtf_varchar2_table_300 := NULL,
1438 p_qt_attribute16 IN jtf_varchar2_table_300 := NULL,
1439 p_qt_attribute17 IN jtf_varchar2_table_300 := NULL,
1440 p_qt_attribute18 IN jtf_varchar2_table_300 := NULL,
1441 p_qt_attribute19 IN jtf_varchar2_table_300 := NULL,
1442 p_qt_attribute20 IN jtf_varchar2_table_300 := NULL,
1443 p_qt_object_version_number IN jtf_number_table := NULL,
1444 p_qt_tax_rate_id IN jtf_number_table := NULL,
1445 -- qh sales credit recore
1446 p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
1447 p_qsc_qte_line_index IN jtf_number_table := NULL,
1448 p_qsc_sales_credit_id IN jtf_number_table := NULL,
1449 p_qsc_creation_date IN jtf_date_table := NULL,
1450 p_qsc_created_by IN jtf_number_table := NULL,
1451 p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
1452 p_qsc_last_update_date IN jtf_date_table := NULL,
1453 p_qsc_last_update_login IN jtf_number_table := NULL,
1454 p_qsc_request_id IN jtf_number_table := NULL,
1455 p_qsc_program_application_id IN jtf_number_table := NULL,
1456 p_qsc_program_id IN jtf_number_table := NULL,
1457 p_qsc_program_update_date IN jtf_date_table := NULL,
1458 p_qsc_quote_header_id IN jtf_number_table := NULL,
1459 p_qsc_quote_line_id IN jtf_number_table := NULL,
1460 p_qsc_percent IN jtf_number_table := NULL,
1461 p_qsc_resource_id IN jtf_number_table := NULL,
1462 p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
1463 p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
1464 p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
1465 p_qsc_resource_group_id IN jtf_number_table := NULL,
1466 p_qsc_employee_person_id IN jtf_number_table := NULL,
1467 p_qsc_sales_credit_type_id IN jtf_number_table := NULL,
1468 p_qsc_attribute_category IN jtf_varchar2_table_100 := NULL,
1469 p_qsc_attribute1 IN jtf_varchar2_table_300 := NULL,
1470 p_qsc_attribute2 IN jtf_varchar2_table_300 := NULL,
1471 p_qsc_attribute3 IN jtf_varchar2_table_300 := NULL,
1472 p_qsc_attribute4 IN jtf_varchar2_table_300 := NULL,
1473 p_qsc_attribute5 IN jtf_varchar2_table_300 := NULL,
1474 p_qsc_attribute6 IN jtf_varchar2_table_300 := NULL,
1475 p_qsc_attribute7 IN jtf_varchar2_table_300 := NULL,
1476 p_qsc_attribute8 IN jtf_varchar2_table_300 := NULL,
1477 p_qsc_attribute9 IN jtf_varchar2_table_300 := NULL,
1478 p_qsc_attribute10 IN jtf_varchar2_table_300 := NULL,
1479 p_qsc_attribute11 IN jtf_varchar2_table_300 := NULL,
1480 p_qsc_attribute12 IN jtf_varchar2_table_300 := NULL,
1481 p_qsc_attribute13 IN jtf_varchar2_table_300 := NULL,
1482 p_qsc_attribute14 IN jtf_varchar2_table_300 := NULL,
1483 p_qsc_attribute15 IN jtf_varchar2_table_300 := NULL,
1484 p_qsc_attribute16 IN jtf_varchar2_table_300 := NULL,
1485 p_qsc_attribute17 IN jtf_varchar2_table_300 := NULL,
1486 p_qsc_attribute18 IN jtf_varchar2_table_300 := NULL,
1487 p_qsc_attribute19 IN jtf_varchar2_table_300 := NULL,
1488 p_qsc_attribute20 IN jtf_varchar2_table_300 := NULL,
1489 p_qsc_system_assigned_flag IN jtf_varchar2_table_100 := NULL,
1490 p_qsc_credit_rule_id IN jtf_number_table := NULL,
1491 p_qsc_object_version_number IN jtf_number_table := NULL,
1492 -- price adjustment record
1493 p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
1494 p_qlpaj_qte_line_index IN jtf_number_table := NULL,
1495 p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
1496 p_qlpaj_creation_date IN jtf_date_table := NULL,
1497 p_qlpaj_created_by IN jtf_number_table := NULL,
1498 p_qlpaj_last_update_date IN jtf_date_table := NULL,
1499 p_qlpaj_last_updated_by IN jtf_number_table := NULL,
1500 p_qlpaj_last_update_login IN jtf_number_table := NULL,
1501 p_qlpaj_program_application_id IN jtf_number_table := NULL,
1502 p_qlpaj_program_id IN jtf_number_table := NULL,
1503 p_qlpaj_program_update_date IN jtf_date_table := NULL,
1504 p_qlpaj_request_id IN jtf_number_table := NULL,
1505 p_qlpaj_quote_header_id IN jtf_number_table := NULL,
1506 p_qlpaj_quote_line_id IN jtf_number_table := NULL,
1507 p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
1508 p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
1509 p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
1510 p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
1511 p_qlpaj_modified_from IN jtf_number_table := NULL,
1512 p_qlpaj_modified_to IN jtf_number_table := NULL,
1513 p_qlpaj_operand IN jtf_number_table := NULL,
1514 p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
1515 p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
1516 p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
1517 p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
1518 p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
1519 p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1520 p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
1521 p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
1522 p_qlpaj_attribute1 IN jtf_varchar2_table_300 := NULL,
1523 p_qlpaj_attribute2 IN jtf_varchar2_table_300 := NULL,
1524 p_qlpaj_attribute3 IN jtf_varchar2_table_300 := NULL,
1525 p_qlpaj_attribute4 IN jtf_varchar2_table_300 := NULL,
1526 p_qlpaj_attribute5 IN jtf_varchar2_table_300 := NULL,
1527 p_qlpaj_attribute6 IN jtf_varchar2_table_300 := NULL,
1528 p_qlpaj_attribute7 IN jtf_varchar2_table_300 := NULL,
1529 p_qlpaj_attribute8 IN jtf_varchar2_table_300 := NULL,
1530 p_qlpaj_attribute9 IN jtf_varchar2_table_300 := NULL,
1531 p_qlpaj_attribute10 IN jtf_varchar2_table_300 := NULL,
1532 p_qlpaj_attribute11 IN jtf_varchar2_table_300 := NULL,
1533 p_qlpaj_attribute12 IN jtf_varchar2_table_300 := NULL,
1534 p_qlpaj_attribute13 IN jtf_varchar2_table_300 := NULL,
1535 p_qlpaj_attribute14 IN jtf_varchar2_table_300 := NULL,
1536 p_qlpaj_attribute15 IN jtf_varchar2_table_300 := NULL,
1537 p_qlpaj_attribute16 IN jtf_varchar2_table_300 := NULL,
1538 p_qlpaj_attribute17 IN jtf_varchar2_table_300 := NULL,
1539 p_qlpaj_attribute18 IN jtf_varchar2_table_300 := NULL,
1540 p_qlpaj_attribute19 IN jtf_varchar2_table_300 := NULL,
1541 p_qlpaj_attribute20 IN jtf_varchar2_table_300 := NULL,
1542 p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
1543 p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
1544 p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
1545 p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
1546 p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
1547 p_qlpaj_cost_id IN jtf_number_table := NULL,
1548 p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
1549 p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1550 p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1551 p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1552 p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
1553 p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
1554 p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
1555 p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
1556 p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
1557 p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1558 p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1559 p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1560 p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1561 p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
1562 p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1563 p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1564 p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1565 p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
1566 p_qlpaj_benefit_qty IN jtf_number_table := NULL,
1567 p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
1568 p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1569 p_qlpaj_expiration_date IN jtf_date_table := NULL,
1570 p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
1571 p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
1572 p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
1573 p_qlpaj_redeemed_date IN jtf_date_table := NULL,
1574 p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
1575 p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
1576 p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
1577 p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
1578 p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
1579 p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1580 p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1581 p_qlpaj_shipment_index IN jtf_number_table := NULL,
1582 p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,
1583 p_qlpaj_object_version_number IN jtf_number_table := NULL,
1584 p_api_version_number IN NUMBER := 1 ,
1585 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1586 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1587 x_return_status OUT NOCOPY VARCHAR2 ,
1588 x_msg_count OUT NOCOPY NUMBER ,
1589 x_msg_data OUT NOCOPY VARCHAR2
1590 )
1591 IS
1592 l_api_name CONSTANT VARCHAR2(30) := 'copy_from_quote';
1593 l_api_version CONSTANT NUMBER := 1.0;
1594
1595 l_copy_qte_control_rec ASO_Copy_Quote_Pub.Copy_Quote_Control_Rec_Type
1596 := ASO_Copy_Quote_Pub.G_Miss_Copy_Quote_Control_Rec;
1597
1598 l_copy_qte_hdr_rec ASO_Copy_Quote_Pub.Copy_Quote_Header_Rec_Type
1599 := ASO_Copy_Quote_Pub.G_Miss_Copy_Quote_Header_Rec;
1600
1601 l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1602 := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
1603 l_hd_payment_tbl ASO_Quote_Pub.Payment_tbl_Type
1604 := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
1605 l_hd_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_TBL_Type
1606 := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
1607 l_hd_shipment_rec ASO_Quote_Pub.Shipment_Rec_Type
1608 := ASO_Quote_Pub.G_MISS_SHIPMENT_REC;
1609 l_hd_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type
1610 := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
1611 l_price_adjustment_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type
1612 := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
1613 l_hd_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type
1614 := ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
1615
1616 l_debug VARCHAR2(1);
1617
1618 BEGIN
1619 SAVEPOINT Copy_Quote_Pvt;
1620 l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;
1621 IF l_debug = 'Y' THEN
1622 ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1623 END IF;
1624 -- standard call to check for call compatibility
1625 IF NOT FND_API.Compatible_API_Call (l_api_version,
1626 p_api_version_number,
1627 l_api_name,
1628 G_PKG_NAME )
1629 THEN
1630 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1631 END IF;
1632
1633 -- initialize message list if p_init_msg_list is set to TRUE
1634 IF FND_API.to_Boolean(p_init_msg_list) THEN
1635 FND_MSG_PUB.initialize;
1636 END IF;
1637
1638 -- initialize API return status to success
1639 x_return_status := FND_API.G_RET_STS_SUCCESS;
1640
1641 IF l_debug = 'Y' THEN
1642 ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.copy_from_quote(+)');
1643 END IF;
1644
1645 -- begin API body
1646
1647 l_copy_qte_hdr_rec := ASO_QUOTE_UTIL_PVT.CONSTRUCT_Copy_Qte_Hdr_Rec(
1648 p_quote_header_id => p_cq_quote_header_id,
1649 p_quote_name => p_cq_quote_name,
1650 p_quote_number => p_cq_quote_number,
1651 p_quote_source_code => p_cq_quote_source_code,
1652 p_quote_expiration_date => p_cq_quote_expiration_date,
1653 p_resource_id => p_cq_resource_id,
1654 p_resource_grp_id => p_cq_resource_grp_id,
1655 p_pricing_status_indicator => p_cq_pricing_status_indicator,
1656 p_tax_status_indicator => p_cq_tax_status_indicator,
1657 p_price_updated_date => p_cq_price_updated_date,
1658 p_tax_updated_date => p_cq_tax_updated_date);
1659
1660 ASO_QUOTE_UTIL_PVT.Set_Copy_Quote_Control_Rec_W(
1661 p_copy_header_only => p_cc_copy_header_only,
1662 p_new_version => p_cc_new_version,
1663 p_copy_note => p_cc_copy_note,
1664 p_copy_task => p_cc_copy_task,
1665 p_copy_attachment => p_cc_copy_attachment,
1666 p_pricing_request_type => p_cc_pricing_request_type,
1667 p_header_pricing_event => p_cc_header_pricing_event,
1668 p_price_mode => p_cc_price_mode ,
1669 p_calc_freight_charge_flag => p_cc_calc_freight_charge_flag,
1670 p_calculate_tax_flag => p_cc_calculate_tax_flag ,
1671 p_Copy_Shipping => p_cc_copy_shipping,
1672 p_Copy_Billing => p_cc_copy_billing,
1673 p_Copy_Payment => p_cc_copy_payment,
1674 p_Copy_End_Customer => p_cc_copy_end_customer,
1675 p_Copy_Sales_Supplement => p_cc_copy_sales_supplement,
1676 p_Copy_Flexfield => p_cc_copy_flexfield,
1677 p_Copy_Sales_Credit => p_cc_copy_sales_credit,
1678 p_Copy_Contract_Terms => p_cc_copy_contract_terms,
1679 p_Copy_Sales_Team => p_cc_copy_sales_team,
1680 p_Copy_Line_Shipping => p_cc_copy_line_shipping,
1681 p_Copy_Line_Billing => p_cc_copy_line_billing,
1682 p_Copy_Line_Payment => p_cc_copy_line_payment,
1683 p_Copy_Line_End_Customer => p_cc_copy_line_end_customer,
1684 p_Copy_Line_Sales_Supplement => p_cc_copy_line_sales_supp,
1685 p_Copy_Line_Attachment => p_cc_copy_line_attachment,
1686 p_Copy_Line_Flexfield => p_cc_copy_line_flexfield,
1687 p_Copy_Line_Sales_Credit => p_cc_copy_line_sales_credit,
1688 p_Copy_To_Same_Customer => p_cc_copy_to_same_customer,
1689 x_copy_quote_control_rec => l_copy_qte_control_rec);
1690
1691 l_qte_header_rec := ASO_QUOTE_UTIL_PVT.Construct_Qte_Header_Rec(
1692 p_quote_header_id => p_q_quote_header_id ,
1693 p_creation_date => p_q_creation_date ,
1694 p_created_by => p_q_created_by ,
1695 p_last_updated_by => p_q_last_updated_by ,
1696 p_last_update_date => p_q_last_update_date ,
1697 p_last_update_login => p_q_last_update_login ,
1698 p_request_id => p_q_request_id ,
1699 p_program_application_id => p_q_program_application_id ,
1700 p_program_id => p_q_program_id ,
1701 p_program_update_date => p_q_program_update_date ,
1702 p_org_id => p_q_org_id ,
1703 p_quote_name => p_q_quote_name ,
1704 p_quote_number => p_q_quote_number ,
1705 p_quote_version => p_q_quote_version ,
1706 p_quote_status_id => p_q_quote_status_id ,
1707 p_quote_source_code => p_q_quote_source_code ,
1708 p_quote_expiration_date => p_q_quote_expiration_date ,
1709 p_price_frozen_date => p_q_price_frozen_date ,
1710 p_quote_password => p_q_quote_password ,
1711 p_original_system_reference => p_q_original_system_reference ,
1712 p_party_id => p_q_party_id ,
1713 p_cust_account_id => p_q_cust_account_id ,
1714 p_invoice_to_cust_account_id => p_q_invoice_to_cust_acct_id ,
1715 p_org_contact_id => p_q_org_contact_id ,
1716 p_party_name => p_q_party_name ,
1717 p_party_type => p_q_party_type ,
1718 p_person_first_name => p_q_person_first_name ,
1719 p_person_last_name => p_q_person_last_name ,
1720 p_person_middle_name => p_q_person_middle_name ,
1721 p_phone_id => p_q_phone_id ,
1722 p_price_list_id => p_q_price_list_id ,
1723 p_price_list_name => p_q_price_list_name ,
1724 p_currency_code => p_q_currency_code ,
1725 p_total_list_price => p_q_total_list_price ,
1726 p_total_adjusted_amount => p_q_total_adjusted_amount ,
1727 p_total_adjusted_percent => p_q_total_adjusted_percent ,
1728 p_total_tax => p_q_total_tax ,
1729 p_total_shipping_charge => p_q_total_shipping_charge ,
1730 p_surcharge => p_q_surcharge ,
1731 p_total_quote_price => p_q_total_quote_price ,
1732 p_payment_amount => p_q_payment_amount ,
1733 p_accounting_rule_id => p_q_accounting_rule_id ,
1734 p_exchange_rate => p_q_exchange_rate ,
1735 p_exchange_type_code => p_q_exchange_type_code ,
1736 p_exchange_rate_date => p_q_exchange_rate_date ,
1737 p_quote_category_code => p_q_quote_category_code ,
1738 p_quote_status_code => p_q_quote_status_code ,
1739 p_quote_status => p_q_quote_status ,
1740 p_employee_person_id => p_q_employee_person_id ,
1741 p_sales_channel_code => p_q_sales_channel_code ,
1742 p_salesrep_first_name => p_q_salesrep_first_name ,
1743 p_salesrep_last_name => p_q_salesrep_last_name ,
1744 p_attribute_category => p_q_attribute_category ,
1745 p_attribute1 => p_q_attribute1 ,
1746 p_attribute10 => p_q_attribute10 ,
1747 p_attribute11 => p_q_attribute11 ,
1748 p_attribute12 => p_q_attribute12 ,
1749 p_attribute13 => p_q_attribute13 ,
1750 p_attribute14 => p_q_attribute14 ,
1751 p_attribute15 => p_q_attribute15 ,
1752 p_attribute16 => p_q_attribute16 ,
1753 p_attribute17 => p_q_attribute17 ,
1754 p_attribute18 => p_q_attribute18 ,
1755 p_attribute19 => p_q_attribute19 ,
1756 p_attribute20 => p_q_attribute20 ,
1757 p_attribute2 => p_q_attribute2 ,
1758 p_attribute3 => p_q_attribute3 ,
1759 p_attribute4 => p_q_attribute4 ,
1760 p_attribute5 => p_q_attribute5 ,
1761 p_attribute6 => p_q_attribute6 ,
1762 p_attribute7 => p_q_attribute7 ,
1763 p_attribute8 => p_q_attribute8 ,
1764 p_attribute9 => p_q_attribute9 ,
1765 p_contract_id => p_q_contract_id ,
1766 p_qte_contract_id => p_q_qte_contract_id ,
1767 p_ffm_request_id => p_q_ffm_request_id ,
1768 p_invoice_to_address1 => p_q_invoice_to_address1 ,
1769 p_invoice_to_address2 => p_q_invoice_to_address2 ,
1770 p_invoice_to_address3 => p_q_invoice_to_address3 ,
1771 p_invoice_to_address4 => p_q_invoice_to_address4 ,
1772 p_invoice_to_city => p_q_invoice_to_city ,
1773 p_invoice_to_cont_first_name => p_q_invoice_to_cont_first_name,
1774 p_invoice_to_cont_last_name => p_q_invoice_to_cont_last_name ,
1775 p_invoice_to_cont_mid_name => p_q_invoice_to_cont_mid_name ,
1776 p_invoice_to_country_code => p_q_invoice_to_country_code ,
1777 p_invoice_to_country => p_q_invoice_to_country ,
1778 p_invoice_to_county => p_q_invoice_to_county ,
1779 p_invoice_to_party_id => p_q_invoice_to_party_id ,
1780 p_invoice_to_party_name => p_q_invoice_to_party_name ,
1781 p_invoice_to_party_site_id => p_q_invoice_to_party_site_id ,
1782 p_invoice_to_postal_code => p_q_invoice_to_postal_code ,
1783 p_invoice_to_province => p_q_invoice_to_province ,
1784 p_invoice_to_state => p_q_invoice_to_state ,
1785 p_invoicing_rule_id => p_q_invoicing_rule_id ,
1786 p_marketing_source_code_id => p_q_marketing_source_code_id ,
1787 p_marketing_source_code => p_q_marketing_source_code ,
1788 p_marketing_source_name => p_q_marketing_source_name ,
1789 p_orig_mktg_source_code_id => p_q_orig_mktg_source_code_id ,
1790 p_order_type_id => p_q_order_type_id ,
1791 p_order_id => p_q_order_id ,
1792 p_order_number => p_q_order_number ,
1793 p_order_type_name => p_q_order_type_name ,
1794 p_ordered_date => p_q_ordered_date ,
1795 p_resource_id => p_q_resource_id ,
1796 p_contract_template_id => p_q_contract_template_id ,
1797 p_contract_template_maj_ver => p_q_contract_template_maj_ver ,
1798 p_contract_requester_id => p_q_contract_requester_id ,
1799 p_contract_approval_level => p_q_contract_approval_level ,
1800 p_publish_flag => p_q_publish_flag ,
1801 p_resource_grp_id => p_q_resource_grp_id ,
1802 p_sold_to_party_site_id => p_q_sold_to_party_site_id ,
1803 p_display_arithmetic_operator => p_q_display_arithmetic_op ,
1804 p_quote_description => p_q_quote_description ,
1805 p_quote_type => p_q_quote_type ,
1806 p_minisite_id => p_q_minisite_id ,
1807 p_cust_party_id => p_q_cust_party_id ,
1808 p_invoice_to_cust_party_id => p_q_invoice_to_cust_party_id ,
1809 p_pricing_status_indicator => p_q_pricing_status_indicator ,
1810 p_tax_status_indicator => p_q_tax_status_indicator ,
1811 p_price_updated_date => p_q_price_updated_date ,
1812 p_tax_updated_date => p_q_tax_updated_date ,
1813 p_recalculate_flag => p_q_recalculate_flag ,
1814 p_price_request_id => p_q_price_request_id ,
1815 p_customer_name_and_title => p_q_customer_name_and_title,
1816 p_customer_signature_date => p_q_customer_signature_date,
1817 p_supplier_name_and_title => p_q_supplier_name_and_title,
1818 p_supplier_signature_date => p_q_supplier_signature_date,
1819 p_credit_update_date => p_q_credit_update_date ,
1820 p_automatic_price_flag => p_q_automatic_price_flag,
1821 p_automatic_tax_flag => p_q_automatic_tax_flag,
1822 p_assistance_requested => p_q_assistance_requested,
1823 p_assistance_reason_code => p_q_assistance_reason_code,
1824 p_end_customer_party_id => p_q_end_cust_party_id,
1825 p_end_customer_party_site_id => p_q_end_cust_party_site_id,
1826 p_end_customer_cust_account_id => p_q_end_cust_cust_account_id,
1827 p_end_customer_cust_party_id => p_q_end_cust_cust_party_id,
1828 p_object_version_number => p_q_object_version_number,
1829 p_header_paynow_charges => p_q_header_paynow_charges
1830 );
1831
1832 -- set header price attribute
1833 l_hd_price_attributes_tbl := ASO_QUOTE_UTIL_PVT.Construct_Price_Attributes_Tbl(
1834 p_operation_code => p_qpa_operation_code ,
1835 p_qte_line_index => p_qpa_qte_line_index ,
1836 p_price_attribute_id => p_qpa_price_attribute_id ,
1837 p_creation_date => p_qpa_creation_date ,
1838 p_created_by => p_qpa_created_by ,
1839 p_last_update_date => p_qpa_last_update_date ,
1840 p_last_updated_by => p_qpa_last_updated_by ,
1841 p_last_update_login => p_qpa_last_update_login ,
1842 p_request_id => p_qpa_request_id ,
1843 p_program_application_id => p_qpa_program_application_id,
1844 p_program_id => p_qpa_program_id ,
1845 p_program_update_date => p_qpa_program_update_date ,
1846 p_quote_header_id => p_qpa_quote_header_id ,
1847 p_quote_line_id => p_qpa_quote_line_id ,
1848 p_flex_title => p_qpa_flex_title ,
1849 p_pricing_context => p_qpa_pricing_context ,
1850 p_pricing_attribute1 => p_qpa_pricing_attribute1 ,
1851 p_pricing_attribute2 => p_qpa_pricing_attribute2 ,
1852 p_pricing_attribute3 => p_qpa_pricing_attribute3 ,
1853 p_pricing_attribute4 => p_qpa_pricing_attribute4 ,
1854 p_pricing_attribute5 => p_qpa_pricing_attribute5 ,
1855 p_pricing_attribute6 => p_qpa_pricing_attribute6 ,
1856 p_pricing_attribute7 => p_qpa_pricing_attribute7 ,
1857 p_pricing_attribute8 => p_qpa_pricing_attribute8 ,
1858 p_pricing_attribute9 => p_qpa_pricing_attribute9 ,
1859 p_pricing_attribute10 => p_qpa_pricing_attribute10 ,
1860 p_pricing_attribute11 => p_qpa_pricing_attribute11 ,
1861 p_pricing_attribute12 => p_qpa_pricing_attribute12 ,
1862 p_pricing_attribute13 => p_qpa_pricing_attribute13 ,
1863 p_pricing_attribute14 => p_qpa_pricing_attribute14 ,
1864 p_pricing_attribute15 => p_qpa_pricing_attribute15 ,
1865 p_pricing_attribute16 => p_qpa_pricing_attribute16 ,
1866 p_pricing_attribute17 => p_qpa_pricing_attribute17 ,
1867 p_pricing_attribute18 => p_qpa_pricing_attribute18 ,
1868 p_pricing_attribute19 => p_qpa_pricing_attribute19 ,
1869 p_pricing_attribute20 => p_qpa_pricing_attribute20 ,
1870 p_pricing_attribute21 => p_qpa_pricing_attribute21 ,
1871 p_pricing_attribute22 => p_qpa_pricing_attribute22 ,
1872 p_pricing_attribute23 => p_qpa_pricing_attribute23 ,
1873 p_pricing_attribute24 => p_qpa_pricing_attribute24 ,
1874 p_pricing_attribute25 => p_qpa_pricing_attribute25 ,
1875 p_pricing_attribute26 => p_qpa_pricing_attribute26 ,
1876 p_pricing_attribute27 => p_qpa_pricing_attribute27 ,
1877 p_pricing_attribute28 => p_qpa_pricing_attribute28 ,
1878 p_pricing_attribute29 => p_qpa_pricing_attribute29 ,
1879 p_pricing_attribute30 => p_qpa_pricing_attribute30 ,
1880 p_pricing_attribute31 => p_qpa_pricing_attribute31 ,
1881 p_pricing_attribute32 => p_qpa_pricing_attribute32 ,
1882 p_pricing_attribute33 => p_qpa_pricing_attribute33 ,
1883 p_pricing_attribute34 => p_qpa_pricing_attribute34 ,
1884 p_pricing_attribute35 => p_qpa_pricing_attribute35 ,
1885 p_pricing_attribute36 => p_qpa_pricing_attribute36 ,
1886 p_pricing_attribute37 => p_qpa_pricing_attribute37 ,
1887 p_pricing_attribute38 => p_qpa_pricing_attribute38 ,
1888 p_pricing_attribute39 => p_qpa_pricing_attribute39 ,
1889 p_pricing_attribute40 => p_qpa_pricing_attribute40 ,
1890 p_pricing_attribute41 => p_qpa_pricing_attribute41 ,
1891 p_pricing_attribute42 => p_qpa_pricing_attribute42 ,
1892 p_pricing_attribute43 => p_qpa_pricing_attribute43 ,
1893 p_pricing_attribute44 => p_qpa_pricing_attribute44 ,
1894 p_pricing_attribute45 => p_qpa_pricing_attribute45 ,
1895 p_pricing_attribute46 => p_qpa_pricing_attribute46 ,
1896 p_pricing_attribute47 => p_qpa_pricing_attribute47 ,
1897 p_pricing_attribute48 => p_qpa_pricing_attribute48 ,
1898 p_pricing_attribute49 => p_qpa_pricing_attribute49 ,
1899 p_pricing_attribute50 => p_qpa_pricing_attribute50 ,
1900 p_pricing_attribute51 => p_qpa_pricing_attribute51 ,
1901 p_pricing_attribute52 => p_qpa_pricing_attribute52 ,
1902 p_pricing_attribute53 => p_qpa_pricing_attribute53 ,
1903 p_pricing_attribute54 => p_qpa_pricing_attribute54 ,
1904 p_pricing_attribute55 => p_qpa_pricing_attribute55 ,
1905 p_pricing_attribute56 => p_qpa_pricing_attribute56 ,
1906 p_pricing_attribute57 => p_qpa_pricing_attribute57 ,
1907 p_pricing_attribute58 => p_qpa_pricing_attribute58 ,
1908 p_pricing_attribute59 => p_qpa_pricing_attribute59 ,
1909 p_pricing_attribute60 => p_qpa_pricing_attribute60 ,
1910 p_pricing_attribute61 => p_qpa_pricing_attribute61 ,
1911 p_pricing_attribute62 => p_qpa_pricing_attribute62 ,
1912 p_pricing_attribute63 => p_qpa_pricing_attribute63 ,
1913 p_pricing_attribute64 => p_qpa_pricing_attribute64 ,
1914 p_pricing_attribute65 => p_qpa_pricing_attribute65 ,
1915 p_pricing_attribute66 => p_qpa_pricing_attribute66 ,
1916 p_pricing_attribute67 => p_qpa_pricing_attribute67 ,
1917 p_pricing_attribute68 => p_qpa_pricing_attribute68 ,
1918 p_pricing_attribute69 => p_qpa_pricing_attribute69 ,
1919 p_pricing_attribute70 => p_qpa_pricing_attribute70 ,
1920 p_pricing_attribute71 => p_qpa_pricing_attribute71 ,
1921 p_pricing_attribute72 => p_qpa_pricing_attribute72 ,
1922 p_pricing_attribute73 => p_qpa_pricing_attribute73 ,
1923 p_pricing_attribute74 => p_qpa_pricing_attribute74 ,
1924 p_pricing_attribute75 => p_qpa_pricing_attribute75 ,
1925 p_pricing_attribute76 => p_qpa_pricing_attribute76 ,
1926 p_pricing_attribute77 => p_qpa_pricing_attribute77 ,
1927 p_pricing_attribute78 => p_qpa_pricing_attribute78 ,
1928 p_pricing_attribute79 => p_qpa_pricing_attribute79 ,
1929 p_pricing_attribute80 => p_qpa_pricing_attribute80 ,
1930 p_pricing_attribute81 => p_qpa_pricing_attribute81 ,
1931 p_pricing_attribute82 => p_qpa_pricing_attribute82 ,
1932 p_pricing_attribute83 => p_qpa_pricing_attribute83 ,
1933 p_pricing_attribute84 => p_qpa_pricing_attribute84 ,
1934 p_pricing_attribute85 => p_qpa_pricing_attribute85 ,
1935 p_pricing_attribute86 => p_qpa_pricing_attribute86 ,
1936 p_pricing_attribute87 => p_qpa_pricing_attribute87 ,
1937 p_pricing_attribute88 => p_qpa_pricing_attribute88 ,
1938 p_pricing_attribute89 => p_qpa_pricing_attribute89 ,
1939 p_pricing_attribute90 => p_qpa_pricing_attribute90 ,
1940 p_pricing_attribute91 => p_qpa_pricing_attribute91 ,
1941 p_pricing_attribute92 => p_qpa_pricing_attribute92 ,
1942 p_pricing_attribute93 => p_qpa_pricing_attribute93 ,
1943 p_pricing_attribute94 => p_qpa_pricing_attribute94 ,
1944 p_pricing_attribute95 => p_qpa_pricing_attribute95 ,
1945 p_pricing_attribute96 => p_qpa_pricing_attribute96 ,
1946 p_pricing_attribute97 => p_qpa_pricing_attribute97 ,
1947 p_pricing_attribute98 => p_qpa_pricing_attribute98 ,
1948 p_pricing_attribute99 => p_qpa_pricing_attribute99 ,
1949 p_pricing_attribute100 => p_qpa_pricing_attribute100 ,
1950 p_context => p_qpa_context ,
1951 p_attribute1 => p_qpa_attribute1 ,
1952 p_attribute2 => p_qpa_attribute2 ,
1953 p_attribute3 => p_qpa_attribute3 ,
1954 p_attribute4 => p_qpa_attribute4 ,
1955 p_attribute5 => p_qpa_attribute5 ,
1956 p_attribute6 => p_qpa_attribute6 ,
1957 p_attribute7 => p_qpa_attribute7 ,
1958 p_attribute8 => p_qpa_attribute8 ,
1959 p_attribute9 => p_qpa_attribute9 ,
1960 p_attribute10 => p_qpa_attribute10 ,
1961 p_attribute11 => p_qpa_attribute11 ,
1962 p_attribute12 => p_qpa_attribute12 ,
1963 p_attribute13 => p_qpa_attribute13 ,
1964 p_attribute14 => p_qpa_attribute14 ,
1965 p_attribute15 => p_qpa_attribute15 ,
1966 p_attribute16 => p_qpa_attribute16 ,
1967 p_attribute17 => p_qpa_attribute17 ,
1968 p_attribute18 => p_qpa_attribute18 ,
1969 p_attribute19 => p_qpa_attribute19 ,
1970 p_attribute20 => p_qpa_attribute20 ,
1971 p_object_version_number => p_qpa_object_version_number);
1972
1973 -- set header payment tbl
1974 l_hd_payment_tbl := ASO_QUOTE_UTIL_PVT.Construct_Payment_Tbl(
1975 p_operation_code => p_qp_operation_code ,
1976 p_qte_line_index => p_qp_qte_line_index ,
1977 p_payment_id => p_qp_payment_id ,
1978 p_creation_date => p_qp_creation_date ,
1979 p_created_by => p_qp_created_by ,
1980 p_last_update_date => p_qp_last_update_date ,
1981 p_last_updated_by => p_qp_last_updated_by ,
1982 p_last_update_login => p_qp_last_update_login ,
1983 p_request_id => p_qp_request_id ,
1984 p_program_application_id => p_qp_program_application_id ,
1985 p_program_id => p_qp_program_id ,
1986 p_program_update_date => p_qp_program_update_date ,
1987 p_quote_header_id => p_qp_quote_header_id ,
1988 p_quote_line_id => p_qp_quote_line_id ,
1989 p_payment_type_code => p_qp_payment_type_code ,
1990 p_payment_ref_number => p_qp_payment_ref_number ,
1991 p_payment_option => p_qp_payment_option ,
1992 p_payment_term_id => p_qp_payment_term_id ,
1993 p_credit_card_code => p_qp_credit_card_code ,
1994 p_credit_card_holder_name => p_qp_credit_card_holder_name ,
1995 p_credit_card_exp_date => p_qp_credit_card_exp_date ,
1996 p_credit_card_approval_code => p_qp_credit_card_aprv_code ,
1997 p_credit_card_approval_date => p_qp_credit_card_aprv_date ,
1998 p_payment_amount => p_qp_payment_amount ,
1999 p_attribute_category => p_qp_attribute_category ,
2000 p_attribute1 => p_qp_attribute1 ,
2001 p_attribute2 => p_qp_attribute2 ,
2002 p_attribute3 => p_qp_attribute3 ,
2003 p_attribute4 => p_qp_attribute4 ,
2004 p_attribute5 => p_qp_attribute5 ,
2005 p_attribute6 => p_qp_attribute6 ,
2006 p_attribute7 => p_qp_attribute7 ,
2007 p_attribute8 => p_qp_attribute8 ,
2008 p_attribute9 => p_qp_attribute9 ,
2009 p_attribute10 => p_qp_attribute10 ,
2010 p_attribute11 => p_qp_attribute11 ,
2011 p_attribute12 => p_qp_attribute12 ,
2012 p_attribute13 => p_qp_attribute13 ,
2013 p_attribute14 => p_qp_attribute14 ,
2014 p_attribute15 => p_qp_attribute15 ,
2015 p_attribute16 => p_qp_attribute16 ,
2016 p_attribute17 => p_qp_attribute17 ,
2017 p_attribute18 => p_qp_attribute18 ,
2018 p_attribute19 => p_qp_attribute19 ,
2019 p_attribute20 => p_qp_attribute20 ,
2020 p_shipment_index => p_qp_shipment_index ,
2021 p_quote_shipment_id => p_qp_quote_shipment_id ,
2022 p_cust_po_number => p_qp_cust_po_number ,
2023 p_cust_po_line_number => p_qp_cust_po_line_number ,
2024 p_trxn_extension_id => p_qp_trxn_extension_id ,
2025 p_instrument_id => p_qp_instrument_id ,
2026 p_instr_assignment_id => p_qp_instr_assignment_id ,
2027 p_cvv2 => p_qp_cvv2 ,
2028 p_object_version_number => p_qp_object_version_number);
2029
2030
2031 -- set header shipment
2032 l_hd_shipment_rec := ASO_QUOTE_UTIL_PVT.Construct_Shipment_rec(
2033 p_operation_code => p_qs_operation_code ,
2034 p_qte_line_index => p_qs_qte_line_index ,
2035 p_shipment_id => p_qs_shipment_id ,
2036 p_creation_date => p_qs_creation_date ,
2037 p_created_by => p_qs_created_by ,
2038 p_last_update_date => p_qs_last_update_date ,
2039 p_last_updated_by => p_qs_last_updated_by ,
2040 p_last_update_login => p_qs_last_update_login ,
2041 p_request_id => p_qs_request_id ,
2042 p_program_application_id => p_qs_program_application_id,
2043 p_program_id => p_qs_program_id ,
2044 p_program_update_date => p_qs_program_update_date ,
2045 p_quote_header_id => p_qs_quote_header_id ,
2046 p_quote_line_id => p_qs_quote_line_id ,
2047 p_promise_date => p_qs_promise_date ,
2048 p_request_date => p_qs_request_date ,
2049 p_schedule_ship_date => p_qs_schedule_ship_date ,
2050 p_ship_to_party_site_id => p_qs_ship_to_party_site_id ,
2051 p_ship_to_party_id => p_qs_ship_to_party_id ,
2052 p_ship_to_cust_account_id => p_qs_ship_to_cust_account_id ,
2053 p_ship_partial_flag => p_qs_ship_partial_flag ,
2054 p_ship_set_id => p_qs_ship_set_id ,
2055 p_ship_method_code => p_qs_ship_method_code ,
2056 p_freight_terms_code => p_qs_freight_terms_code ,
2057 p_freight_carrier_code => p_qs_freight_carrier_code ,
2058 p_fob_code => p_qs_fob_code ,
2059 p_shipping_instructions => p_qs_shipping_instructions ,
2060 p_packing_instructions => p_qs_packing_instructions ,
2061 p_quantity => p_qs_quantity ,
2062 p_reserved_quantity => p_qs_reserved_quantity ,
2063 p_reservation_id => p_qs_reservation_id ,
2064 p_order_line_id => p_qs_order_line_id ,
2065 p_ship_to_party_name => p_qs_ship_to_party_name ,
2066 p_ship_to_cont_first_name => p_qs_ship_to_cont_first_name ,
2067 p_ship_to_cont_mid_name => p_qs_ship_to_cont_mid_name ,
2068 p_ship_to_cont_last_name => p_qs_ship_to_cont_last_name ,
2069 p_ship_to_address1 => p_qs_ship_to_address1 ,
2070 p_ship_to_address2 => p_qs_ship_to_address2 ,
2071 p_ship_to_address3 => p_qs_ship_to_address3 ,
2072 p_ship_to_address4 => p_qs_ship_to_address4 ,
2073 p_ship_to_country_code => p_qs_ship_to_country_code ,
2074 p_ship_to_country => p_qs_ship_to_country ,
2075 p_ship_to_city => p_qs_ship_to_city ,
2076 p_ship_to_postal_code => p_qs_ship_to_postal_code ,
2077 p_ship_to_state => p_qs_ship_to_state ,
2078 p_ship_to_province => p_qs_ship_to_province ,
2079 p_ship_to_county => p_qs_ship_to_county ,
2080 p_attribute_category => p_qs_attribute_category ,
2081 p_attribute1 => p_qs_attribute1 ,
2082 p_attribute2 => p_qs_attribute2 ,
2083 p_attribute3 => p_qs_attribute3 ,
2084 p_attribute4 => p_qs_attribute4 ,
2085 p_attribute5 => p_qs_attribute5 ,
2086 p_attribute6 => p_qs_attribute6 ,
2087 p_attribute7 => p_qs_attribute7 ,
2088 p_attribute8 => p_qs_attribute8 ,
2089 p_attribute9 => p_qs_attribute9 ,
2090 p_attribute10 => p_qs_attribute10 ,
2091 p_attribute11 => p_qs_attribute11 ,
2092 p_attribute12 => p_qs_attribute12 ,
2093 p_attribute13 => p_qs_attribute13 ,
2094 p_attribute14 => p_qs_attribute14 ,
2095 p_attribute15 => p_qs_attribute15 ,
2096 p_attribute16 => p_qs_attribute16 ,
2097 p_attribute17 => p_qs_attribute17 ,
2098 p_attribute18 => p_qs_attribute18 ,
2099 p_attribute19 => p_qs_attribute19 ,
2100 p_attribute20 => p_qs_attribute20 ,
2101 p_ship_quote_price => p_qs_ship_quote_price ,
2102 p_pricing_quantity => p_qs_pricing_quantity ,
2103 p_shipment_priority_code => p_qs_shipment_priority_code,
2104 p_ship_from_org_id => p_qs_ship_from_org_id ,
2105 p_ship_to_cust_party_id => p_qs_ship_to_cust_party_id ,
2106 p_request_date_type => p_qs_request_date_type ,
2107 p_demand_class_code => p_qs_demand_class_code ,
2108 p_object_version_number => p_qs_object_version_number
2109 );
2110
2111
2112 -- set header tax detail
2113 l_hd_tax_detail_tbl := ASO_QUOTE_UTIL_PVT.Construct_Tax_Detail_Tbl(
2114 p_operation_code => p_qt_operation_code ,
2115 p_qte_line_index => p_qt_qte_line_index ,
2116 p_shipment_index => p_qt_shipment_index ,
2117 p_tax_detail_id => p_qt_tax_detail_id ,
2118 p_quote_header_id => p_qt_quote_header_id ,
2119 p_quote_line_id => p_qt_quote_line_id ,
2120 p_quote_shipment_id => p_qt_quote_shipment_id ,
2121 p_creation_date => p_qt_creation_date ,
2122 p_created_by => p_qt_created_by ,
2123 p_last_update_date => p_qt_last_update_date ,
2124 p_last_updated_by => p_qt_last_updated_by ,
2125 p_last_update_login => p_qt_last_update_login ,
2126 p_request_id => p_qt_request_id ,
2127 p_program_application_id => p_qt_program_application_id,
2128 p_program_id => p_qt_program_id ,
2129 p_program_update_date => p_qt_program_update_date ,
2130 p_orig_tax_code => p_qt_orig_tax_code ,
2131 p_tax_code => p_qt_tax_code ,
2132 p_tax_rate => p_qt_tax_rate ,
2133 p_tax_date => p_qt_tax_date ,
2134 p_tax_amount => p_qt_tax_amount ,
2135 p_tax_exempt_flag => p_qt_tax_exempt_flag ,
2136 p_tax_exempt_number => p_qt_tax_exempt_number ,
2137 p_tax_exempt_reason_code => p_qt_tax_exempt_reason_code,
2138 p_attribute_category => p_qt_attribute_category ,
2139 p_attribute1 => p_qt_attribute1 ,
2140 p_attribute2 => p_qt_attribute2 ,
2141 p_attribute3 => p_qt_attribute3 ,
2142 p_attribute4 => p_qt_attribute4 ,
2143 p_attribute5 => p_qt_attribute5 ,
2144 p_attribute6 => p_qt_attribute6 ,
2145 p_attribute7 => p_qt_attribute7 ,
2146 p_attribute8 => p_qt_attribute8 ,
2147 p_attribute9 => p_qt_attribute9 ,
2148 p_attribute10 => p_qt_attribute10 ,
2149 p_attribute11 => p_qt_attribute11 ,
2150 p_attribute12 => p_qt_attribute12 ,
2151 p_attribute13 => p_qt_attribute13 ,
2152 p_attribute14 => p_qt_attribute14 ,
2153 p_attribute15 => p_qt_attribute15 ,
2154 p_attribute16 => p_qt_attribute16 ,
2155 p_attribute17 => p_qt_attribute17 ,
2156 p_attribute18 => p_qt_attribute18 ,
2157 p_attribute19 => p_qt_attribute19 ,
2158 p_attribute20 => p_qt_attribute20 ,
2159 p_object_version_number => p_qt_object_version_number ,
2160 p_tax_rate_id => p_qt_tax_rate_id);
2161
2162 -- set header sales credit
2163 l_hd_sales_credit_tbl := ASO_QUOTE_UTIL_PVT.Construct_Sales_Credit_Tbl(
2164 p_operation_code => p_qsc_operation_code ,
2165 p_qte_line_index => p_qsc_qte_line_index ,
2166 p_sales_credit_id => p_qsc_sales_credit_id ,
2167 p_creation_date => p_qsc_creation_date ,
2168 p_created_by => p_qsc_created_by ,
2169 p_last_updated_by => p_qsc_last_updated_by ,
2170 p_last_update_date => p_qsc_last_update_date ,
2171 p_last_update_login => p_qsc_last_update_login ,
2172 p_request_id => p_qsc_request_id ,
2173 p_program_application_id => p_qsc_program_application_id,
2174 p_program_id => p_qsc_program_id ,
2175 p_program_update_date => p_qsc_program_update_date ,
2176 p_quote_header_id => p_qsc_quote_header_id ,
2177 p_quote_line_id => p_qsc_quote_line_id ,
2178 p_percent => p_qsc_percent ,
2179 p_resource_id => p_qsc_resource_id ,
2180 p_first_name => p_qsc_first_name ,
2181 p_last_name => p_qsc_last_name ,
2182 p_sales_credit_type => p_qsc_sales_credit_type ,
2183 p_resource_group_id => p_qsc_resource_group_id ,
2184 p_employee_person_id => p_qsc_employee_person_id ,
2185 p_sales_credit_type_id => p_qsc_sales_credit_type_id ,
2186 p_attribute_category => p_qsc_attribute_category ,
2187 p_attribute1 => p_qsc_attribute1 ,
2188 p_attribute2 => p_qsc_attribute2 ,
2189 p_attribute3 => p_qsc_attribute3 ,
2190 p_attribute4 => p_qsc_attribute4 ,
2191 p_attribute5 => p_qsc_attribute5 ,
2192 p_attribute6 => p_qsc_attribute6 ,
2193 p_attribute7 => p_qsc_attribute7 ,
2194 p_attribute8 => p_qsc_attribute8 ,
2195 p_attribute9 => p_qsc_attribute9 ,
2196 p_attribute10 => p_qsc_attribute10 ,
2197 p_attribute11 => p_qsc_attribute11 ,
2198 p_attribute12 => p_qsc_attribute12 ,
2199 p_attribute13 => p_qsc_attribute13 ,
2200 p_attribute14 => p_qsc_attribute14 ,
2201 p_attribute15 => p_qsc_attribute15 ,
2202 p_attribute16 => p_qsc_attribute16 ,
2203 p_attribute17 => p_qsc_attribute17 ,
2204 p_attribute18 => p_qsc_attribute18 ,
2205 p_attribute19 => p_qsc_attribute19 ,
2206 p_attribute20 => p_qsc_attribute20 ,
2207 p_system_assigned_flag => p_qsc_system_assigned_flag ,
2208 p_credit_rule_id => p_qsc_credit_rule_id ,
2209 p_object_version_number => p_qsc_object_version_number);
2210
2211 -- set price adjustment tbl
2212 l_price_adjustment_tbl := ASO_QUOTE_UTIL_PVT.Construct_Price_Adj_Tbl(
2213 p_operation_code => p_qlpaj_operation_code ,
2214 p_qte_line_index => p_qlpaj_qte_line_index ,
2215 p_price_adjustment_id => p_qlpaj_price_adjustment_id ,
2216 p_creation_date => p_qlpaj_creation_date ,
2217 p_created_by => p_qlpaj_created_by ,
2218 p_last_update_date => p_qlpaj_last_update_date ,
2219 p_last_updated_by => p_qlpaj_last_updated_by ,
2220 p_last_update_login => p_qlpaj_last_update_login ,
2221 p_program_application_id => p_qlpaj_program_application_id,
2222 p_program_id => p_qlpaj_program_id ,
2223 p_program_update_date => p_qlpaj_program_update_date ,
2224 p_request_id => p_qlpaj_request_id ,
2225 p_quote_header_id => p_qlpaj_quote_header_id ,
2226 p_quote_line_id => p_qlpaj_quote_line_id ,
2227 p_modifier_header_id => p_qlpaj_modifier_header_id ,
2228 p_modifier_line_id => p_qlpaj_modifier_line_id ,
2229 p_mod_line_type_code => p_qlpaj_mod_line_type_code ,
2230 p_mod_mech_type_code => p_qlpaj_mod_mech_type_code ,
2231 p_modified_from => p_qlpaj_modified_from ,
2232 p_modified_to => p_qlpaj_modified_to ,
2233 p_operand => p_qlpaj_operand ,
2234 p_arithmetic_operator => p_qlpaj_arithmetic_operator ,
2235 p_automatic_flag => p_qlpaj_automatic_flag ,
2236 p_update_allowable_flag => p_qlpaj_update_allowable_flag ,
2237 p_updated_flag => p_qlpaj_updated_flag ,
2238 p_applied_flag => p_qlpaj_applied_flag ,
2239 p_on_invoice_flag => p_qlpaj_on_invoice_flag ,
2240 p_pricing_phase_id => p_qlpaj_pricing_phase_id ,
2241 p_attribute_category => p_qlpaj_attribute_category ,
2242 p_attribute1 => p_qlpaj_attribute1 ,
2243 p_attribute2 => p_qlpaj_attribute2 ,
2244 p_attribute3 => p_qlpaj_attribute3 ,
2245 p_attribute4 => p_qlpaj_attribute4 ,
2246 p_attribute5 => p_qlpaj_attribute5 ,
2247 p_attribute6 => p_qlpaj_attribute6 ,
2248 p_attribute7 => p_qlpaj_attribute7 ,
2249 p_attribute8 => p_qlpaj_attribute8 ,
2250 p_attribute9 => p_qlpaj_attribute9 ,
2251 p_attribute10 => p_qlpaj_attribute10 ,
2252 p_attribute11 => p_qlpaj_attribute11 ,
2253 p_attribute12 => p_qlpaj_attribute12 ,
2254 p_attribute13 => p_qlpaj_attribute13 ,
2255 p_attribute14 => p_qlpaj_attribute14 ,
2256 p_attribute15 => p_qlpaj_attribute15 ,
2257 p_attribute16 => p_qlpaj_attribute16 ,
2258 p_attribute17 => p_qlpaj_attribute17 ,
2259 p_attribute18 => p_qlpaj_attribute18 ,
2260 p_attribute19 => p_qlpaj_attribute19 ,
2261 p_attribute20 => p_qlpaj_attribute20 ,
2262 p_orig_sys_discount_ref => p_qlpaj_orig_sys_discount_ref ,
2263 p_change_sequence => p_qlpaj_change_sequence ,
2264 p_update_allowed => p_qlpaj_update_allowed ,
2265 p_change_reason_code => p_qlpaj_change_reason_code ,
2266 p_change_reason_text => p_qlpaj_change_reason_text ,
2267 p_cost_id => p_qlpaj_cost_id ,
2268 p_tax_code => p_qlpaj_tax_code ,
2269 p_tax_exempt_flag => p_qlpaj_tax_exempt_flag ,
2270 p_tax_exempt_number => p_qlpaj_tax_exempt_number ,
2271 p_tax_exempt_reason_code => p_qlpaj_tax_exempt_reason_code,
2272 p_parent_adjustment_id => p_qlpaj_parent_adjustment_id ,
2273 p_invoiced_flag => p_qlpaj_invoiced_flag ,
2274 p_estimated_flag => p_qlpaj_estimated_flag ,
2275 p_inc_in_sales_perfce => p_qlpaj_inc_in_sales_perfce ,
2276 p_split_action_code => p_qlpaj_split_action_code ,
2277 p_adjusted_amount => p_qlpaj_adjusted_amount ,
2278 p_charge_type_code => p_qlpaj_charge_type_code ,
2279 p_charge_subtype_code => p_qlpaj_charge_subtype_code ,
2280 p_range_break_quantity => p_qlpaj_range_break_quantity ,
2281 p_accrual_conv_rate => p_qlpaj_accrual_conv_rate ,
2282 p_pricing_group_sequence => p_qlpaj_pricing_group_sequence,
2283 p_accrual_flag => p_qlpaj_accrual_flag ,
2284 p_list_line_no => p_qlpaj_list_line_no ,
2285 p_source_system_code => p_qlpaj_source_system_code ,
2286 p_benefit_qty => p_qlpaj_benefit_qty ,
2287 p_benefit_uom_code => p_qlpaj_benefit_uom_code ,
2288 p_print_on_invoice_flag => p_qlpaj_print_on_invoice_flag ,
2289 p_expiration_date => p_qlpaj_expiration_date ,
2290 p_rebate_trans_type_code => p_qlpaj_rebate_trans_type_code,
2291 p_rebate_trans_reference => p_qlpaj_rebate_trans_reference,
2292 p_rebate_pay_system_code => p_qlpaj_rebate_pay_system_code,
2293 p_redeemed_date => p_qlpaj_redeemed_date ,
2294 p_redeemed_flag => p_qlpaj_redeemed_flag ,
2295 p_modifier_level_code => p_qlpaj_modifier_level_code ,
2296 p_price_break_type_code => p_qlpaj_price_break_type_code ,
2297 p_substitution_attribute => p_qlpaj_substitution_attribute,
2298 p_proration_type_code => p_qlpaj_proration_type_code ,
2299 p_include_on_ret_flag => p_qlpaj_include_on_ret_flag ,
2300 p_credit_or_charge_flag => p_qlpaj_credit_or_charge_flag ,
2301 p_shipment_index => p_qlpaj_shipment_index ,
2302 p_quote_shipment_id => p_qlpaj_quote_shipment_id ,
2303 p_object_version_number => p_qlpaj_object_version_number);
2304 -- Call ASO API
2305 IF l_debug = 'Y' THEN
2306 ASO_QUOTE_UTIL_PVT.Debug('Begin calling ASO_Copy_Quote_Pub.Copy_Quote');
2307 END IF;
2308
2309 ASO_Copy_Quote_Pub.Copy_Quote(
2310 p_api_Version_Number => 1.0,
2311 p_init_msg_list => FND_API.G_FALSE,
2312 p_commit => FND_API.G_FALSE,
2313 p_copy_quote_header_rec => l_copy_qte_hdr_rec,
2314 p_copy_quote_control_rec => l_copy_qte_control_rec,
2315 P_Qte_Header_Rec => l_qte_header_rec,
2316 P_hd_Shipment_Rec => l_hd_shipment_rec,
2317 P_hd_Payment_Tbl => l_hd_payment_tbl,
2318 P_hd_Tax_Detail_Tbl => l_hd_tax_detail_tbl,
2319 x_qte_header_id => x_quote_header_id,
2320 x_qte_number => x_quote_number,
2321 x_return_status => x_return_status,
2322 x_msg_count => x_msg_count,
2323 x_msg_data => x_msg_data);
2324 IF l_debug = 'Y' THEN
2325 ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_Copy_Quote_Pub.Copy_Quote');
2326 END IF;
2327
2328 IF FND_API.To_Boolean( p_commit ) THEN
2329 COMMIT WORK;
2330 END IF;
2331
2332 IF l_debug = 'Y' THEN
2333 ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.copy_quote(+)');
2334 END IF;
2335 -- standard call to get message count and if count is 1, get message info.
2336 FND_MSG_PUB.Count_And_Get
2337 ( p_encoded => FND_API.G_FALSE,
2338 p_count => x_msg_count,
2339 p_data => x_msg_data
2340 );
2341
2342 IF l_debug = 'Y' THEN
2343 ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
2344 END IF;
2345
2346 EXCEPTION
2347 WHEN FND_API.G_EXC_ERROR THEN
2348 ROLLBACK TO Copy_Quote_Pvt;
2349 x_return_status := FND_API.G_RET_STS_ERROR;
2350 FND_MSG_PUB.Count_And_Get
2351 ( p_encoded => FND_API.G_FALSE,
2352 p_count => x_msg_count,
2353 p_data => x_msg_data
2354 );
2355 IF l_debug = 'Y' THEN
2356 ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
2357 END IF;
2358 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2359 ROLLBACK TO Copy_Quote_Pvt;
2360 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2361 FND_MSG_PUB.Count_And_Get
2362 ( p_encoded => FND_API.G_FALSE,
2363 p_count => x_msg_count,
2364 p_data => x_msg_data
2365 );
2366 IF l_debug = 'Y' THEN
2367 ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
2368 END IF;
2369 WHEN OTHERS THEN
2370 ROLLBACK TO Copy_Quote_Pvt;
2371 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2372 FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2373 FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2374 FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2375 FND_MESSAGE.Set_Token('REASON', SQLERRM);
2376 FND_MSG_PUB.Add;
2377 IF FND_MSG_PUB.Check_Msg_Level
2378 (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2379 THEN FND_MSG_PUB.Add_Exc_Msg
2380 (G_PKG_NAME,
2381 l_api_name
2382 );
2383 END IF;
2384 FND_MSG_PUB.Count_And_Get
2385 ( p_encoded => FND_API.G_FALSE,
2386 p_count => x_msg_count,
2387 p_data => x_msg_data
2388 );
2389 IF l_debug = 'Y' THEN
2390 ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
2391 END IF;
2392
2393 END Copy_From_Quote;
2394
2395 END ASO_Quote_Pub_W1;