1 PACKAGE ASO_Quote_Pub_W1 as
2 /* $Header: asovqw2s.pls 120.1 2005/09/13 15:21:31 skulkarn noship $ */
3
4
5 PROCEDURE Check_Atp
6 (
7 /* OUT parameters for quote line record ASO_ATP_INT.Atp_Tbl_Typ */
8 x_atp_inventory_item_id OUT NOCOPY jtf_number_table,
9 x_atp_inventory_item_name OUT NOCOPY jtf_varchar2_table_300,
10 x_inventory_item_description OUT NOCOPY JTF_VARCHAR2_TABLE_300,
11 x_padded_concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_300,
12 x_atp_source_organization_id OUT NOCOPY jtf_number_table,
13 x_atp_source_organization_code OUT NOCOPY jtf_varchar2_table_300,
14 x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
15 x_atp_identifier OUT NOCOPY jtf_number_table,
16 x_atp_customer_id OUT NOCOPY jtf_number_table,
17 x_atp_customer_site_id OUT NOCOPY jtf_number_table,
18 x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
19 x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
20 x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
21 x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
22 x_atp_ship_date OUT NOCOPY jtf_date_table,
23 x_atp_available_quantity OUT NOCOPY jtf_number_table,
24 x_atp_request_date_quantity OUT NOCOPY jtf_number_table,
25 x_atp_error_code OUT NOCOPY jtf_number_table,
26 x_atp_message OUT NOCOPY jtf_varchar2_table_2000,
27
28 x_atp_request_date_type OUT NOCOPY jtf_varchar2_table_300,
29 x_atp_req_date_type_meaning OUT NOCOPY jtf_varchar2_table_300,
30 x_atp_demand_class_code OUT NOCOPY jtf_varchar2_table_300,
31 x_atp_demand_class_meaning OUT NOCOPY jtf_varchar2_table_300,
32 x_atp_ship_set_name OUT NOCOPY jtf_varchar2_table_300,
33 x_atp_arrival_set_name OUT NOCOPY jtf_varchar2_table_300,
34 x_atp_line_number OUT NOCOPY jtf_varchar2_table_800,
35 x_atp_group_ship_date OUT NOCOPY jtf_date_table,
36 x_atp_requested_arrival_date OUT NOCOPY jtf_date_table,
37 x_atp_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
38 x_atp_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
39 x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
40 x_atp_quote_header_id OUT NOCOPY jtf_number_table,
41 x_atp_calling_module OUT NOCOPY jtf_number_table,
42 x_atp_quote_number OUT NOCOPY jtf_number_table,
43 x_atp_ato_line_id OUT NOCOPY jtf_number_table,
44 x_atp_ref_line_id OUT NOCOPY jtf_number_table,
45 x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
46 x_atp_action OUT NOCOPY jtf_number_table,
47 x_atp_arrival_date OUT NOCOPY jtf_date_table,
48 x_atp_organization_id OUT NOCOPY jtf_number_table,
49 x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
50 x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
51 x_atp_included_item_flag OUT NOCOPY jtf_number_table,
52 x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,
53 x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,
54 x_atp_country OUT NOCOPY jtf_varchar2_table_600,
55 x_atp_state OUT NOCOPY jtf_varchar2_table_600,
56 x_atp_city OUT NOCOPY jtf_varchar2_table_600,
57 x_atp_postal_code OUT NOCOPY jtf_varchar2_table_600,
58 x_atp_match_item_id OUT NOCOPY jtf_number_table,
59 /* Parameters for quote header record */
60 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
61 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
62 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
63 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
64 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
65 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
66 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
67 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
68 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
69 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
70 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
71 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
72 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
73 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
74 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
75 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
77 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
78 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
79 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
80 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
81 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
82 p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
83 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
84 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
85 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
86 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
87 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
88 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
90 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
91 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
94 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
95 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
96 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
97 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
98 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
99 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
100 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
101 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
102 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
103 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
104 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
105 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
106 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
109 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
110 p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111 p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
112 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
113 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121 p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123 p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
134 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
135 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
136 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
142 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
143 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
145 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
146 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
147 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
148 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
149 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
150 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
152 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
153 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
154 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
155 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
156 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
158 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
159 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
160 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
161 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
162 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
163 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
164 p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
165 p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
166 p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
167 p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
168 p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
169 p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
170 p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
171 p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
172 p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
173 p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
174 p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
175 p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
176 p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
177 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
178 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
179 p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
180 p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
181 p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
182 p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
183 p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
184 p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
185 p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
186 p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
187 p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
188 p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
189 p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
190 p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
191 p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
192 p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
193 p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
194 p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
195 p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
196 p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
197
198 /* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */
199 p_ql_creation_date IN jtf_date_table := NULL,
200 p_ql_created_by IN jtf_number_table := NULL,
201 p_ql_last_updated_by IN jtf_number_table := NULL,
202 p_ql_last_update_date IN jtf_date_table := NULL,
203 p_ql_last_update_login IN jtf_number_table := NULL,
204 p_ql_request_id IN jtf_number_table := NULL,
205 p_ql_program_application_id IN jtf_number_table := NULL,
206 p_ql_program_id IN jtf_number_table := NULL,
207 p_ql_program_update_date IN jtf_date_table := NULL,
208 p_ql_quote_line_id IN jtf_number_table := NULL,
209 p_ql_quote_header_id IN jtf_number_table := NULL,
210 p_ql_org_id IN jtf_number_table := NULL,
211 p_ql_line_number IN jtf_number_table := NULL,
212 p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
213 p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
214 p_ql_inventory_item_id IN jtf_number_table := NULL,
215 p_ql_organization_id IN jtf_number_table := NULL,
216 p_ql_quantity IN jtf_number_table := NULL,
217 p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
218 p_ql_start_date_active IN jtf_date_table := NULL,
219 p_ql_end_date_active IN jtf_date_table := NULL,
220 p_ql_order_line_type_id IN jtf_number_table := NULL,
221 p_ql_price_list_id IN jtf_number_table := NULL,
222 p_ql_price_list_line_id IN jtf_number_table := NULL,
223 p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
224 p_ql_line_list_price IN jtf_number_table := NULL,
225 p_ql_line_adjusted_amount IN jtf_number_table := NULL,
226 p_ql_line_adjusted_percent IN jtf_number_table := NULL,
227 p_ql_line_quote_price IN jtf_number_table := NULL,
228 p_ql_related_item_id IN jtf_number_table := NULL,
229 p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
230 p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
231 p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
232 p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
233 p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
234 p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
235 p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
236 p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
237 p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
238 p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,
239 p_ql_attribute5 IN jtf_varchar2_table_300 := NULL,
240 p_ql_attribute6 IN jtf_varchar2_table_300 := NULL,
241 p_ql_attribute7 IN jtf_varchar2_table_300 := NULL,
242 p_ql_attribute8 IN jtf_varchar2_table_300 := NULL,
243 p_ql_attribute9 IN jtf_varchar2_table_300 := NULL,
244 p_ql_attribute10 IN jtf_varchar2_table_300 := NULL,
245 p_ql_attribute11 IN jtf_varchar2_table_300 := NULL,
246 p_ql_attribute12 IN jtf_varchar2_table_300 := NULL,
247 p_ql_attribute13 IN jtf_varchar2_table_300 := NULL,
248 p_ql_attribute14 IN jtf_varchar2_table_300 := NULL,
249 p_ql_attribute15 IN jtf_varchar2_table_300 := NULL,
250 p_ql_attribute16 IN jtf_varchar2_table_300 := NULL,
251 p_ql_attribute17 IN jtf_varchar2_table_300 := NULL,
252 p_ql_attribute18 IN jtf_varchar2_table_300 := NULL,
253 p_ql_attribute19 IN jtf_varchar2_table_300 := NULL,
254 p_ql_attribute20 IN jtf_varchar2_table_300 := NULL,
255 p_ql_accounting_rule_id IN jtf_number_table := NULL,
256 p_ql_ffm_content_name IN jtf_varchar2_table_300 := NULL,
257 p_ql_ffm_content_type IN jtf_varchar2_table_300 := NULL,
258 p_ql_ffm_document_type IN jtf_varchar2_table_300 := NULL,
259 p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
260 p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
261 p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
262 p_ql_invoice_to_party_id IN jtf_number_table := NULL,
263 p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
264 p_ql_invoicing_rule_id IN jtf_number_table := NULL,
265 p_ql_marketing_source_code_id IN jtf_number_table := NULL,
266 p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
267 p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
268 p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
269 p_ql_minisite_id IN jtf_number_table := NULL,
270 p_ql_section_id IN jtf_number_table := NULL,
271 p_ql_priced_price_list_id IN jtf_number_table := NULL,
272 p_ql_agreement_id IN jtf_number_table := NULL,
273 p_ql_commitment_id IN jtf_number_table := NULL,
274 p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
275 p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
276
277 /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
278 p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
279 p_qls_qte_line_index IN jtf_number_table := NULL,
280 p_qls_shipment_id IN jtf_number_table := NULL,
284 p_qls_last_updated_by IN jtf_number_table := NULL,
281 p_qls_creation_date IN jtf_date_table := NULL,
282 p_qls_created_by IN jtf_number_table := NULL,
283 p_qls_last_update_date IN jtf_date_table := NULL,
285 p_qls_last_update_login IN jtf_number_table := NULL,
286 p_qls_request_id IN jtf_number_table := NULL,
287 p_qls_program_application_id IN jtf_number_table := NULL,
288 p_qls_program_id IN jtf_number_table := NULL,
289 p_qls_program_update_date IN jtf_date_table := NULL,
290 p_qls_quote_header_id IN jtf_number_table := NULL,
291 p_qls_quote_line_id IN jtf_number_table := NULL,
292 p_qls_promise_date IN jtf_date_table := NULL,
293 p_qls_request_date IN jtf_date_table := NULL,
294 p_qls_schedule_ship_date IN jtf_date_table := NULL,
295 p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
296 p_qls_ship_to_party_id IN jtf_number_table := NULL,
297 p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
298 p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
299 p_qls_ship_set_id IN jtf_number_table := NULL,
300 p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
301 p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
302 p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
303 p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
304 p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
305 p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
306 p_qls_quantity IN jtf_number_table := NULL,
307 p_qls_reserved_quantity IN jtf_varchar2_table_300 := NULL,
308 p_qls_reservation_id IN jtf_number_table := NULL,
309 p_qls_order_line_id IN jtf_number_table := NULL,
310 p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
311 p_qls_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
312 p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
313 p_qls_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
314 p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
315 p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
316 p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
317 p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
318 p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
319 p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
320 p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
321 p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
322 p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
323 p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
324 p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
325 p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
326 p_qls_attribute1 IN jtf_varchar2_table_300 := NULL,
327 p_qls_attribute2 IN jtf_varchar2_table_300 := NULL,
328 p_qls_attribute3 IN jtf_varchar2_table_300 := NULL,
329 p_qls_attribute4 IN jtf_varchar2_table_300 := NULL,
330 p_qls_attribute5 IN jtf_varchar2_table_300 := NULL,
331 p_qls_attribute6 IN jtf_varchar2_table_300 := NULL,
332 p_qls_attribute7 IN jtf_varchar2_table_300 := NULL,
333 p_qls_attribute8 IN jtf_varchar2_table_300 := NULL,
334 p_qls_attribute9 IN jtf_varchar2_table_300 := NULL,
335 p_qls_attribute10 IN jtf_varchar2_table_300 := NULL,
336 p_qls_attribute11 IN jtf_varchar2_table_300 := NULL,
337 p_qls_attribute12 IN jtf_varchar2_table_300 := NULL,
338 p_qls_attribute13 IN jtf_varchar2_table_300 := NULL,
339 p_qls_attribute14 IN jtf_varchar2_table_300 := NULL,
340 p_qls_attribute15 IN jtf_varchar2_table_300 := NULL,
341 p_qls_attribute16 IN jtf_varchar2_table_300 := NULL,
342 p_qls_attribute17 IN jtf_varchar2_table_300 := NULL,
343 p_qls_attribute18 IN jtf_varchar2_table_300 := NULL,
344 p_qls_attribute19 IN jtf_varchar2_table_300 := NULL,
345 p_qls_attribute20 IN jtf_varchar2_table_300 := NULL,
346 p_qls_ship_quote_price IN jtf_number_table := NULL,
347 p_qls_pricing_quantity IN jtf_number_table := NULL,
348 p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
349 p_qls_ship_from_org_id IN jtf_number_table := NULL,
350 p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
351 p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
352 p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
353 p_qls_object_version_number IN jtf_number_table := NULL,
354 /* Standard IN parameters */
355 P_API_VERSION_NUMBER IN NUMBER := 1,
356 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,
357 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
358
359 /* Standard OUT parameters */
360 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
361 X_MSG_COUNT OUT NOCOPY NUMBER,
362 X_MSG_DATA OUT NOCOPY VARCHAR2
363 );
364
365 Procedure Get_Payment_Channel_Attribs (
366 p_instr_channel_code IN VARCHAR2,
367 x_instr_secCode_Use OUT NOCOPY VARCHAR2,
368 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
369 X_MSG_COUNT OUT NOCOPY NUMBER,
370 X_MSG_DATA OUT NOCOPY VARCHAR2
371 );
372 END ASO_Quote_Pub_W1;
[Home] [Help]