[Home] [Help]
PACKAGE BODY: APPS.ASO_QUOTE_PUB_W1
Source
1 PACKAGE BODY ASO_Quote_Pub_W1 as
2 /* $Header: asovqw2b.pls 120.1 2005/09/13 15:21:47 skulkarn noship $ */
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 END ASO_Quote_Pub_W1;