[Home] [Help]
PACKAGE: APPS.ASO_QUOTE_UTIL_PVT
Source
1 PACKAGE ASO_Quote_Util_PVT as
2 /* $Header: asovqwus.pls 120.5 2005/11/01 14:55:19 skulkarn ship $ */
3
4 procedure debug(p_line in varchar2);
5
6 procedure enable_debug_pvt;
7
8 procedure disable_debug_pvt;
9
10 FUNCTION is_debug_enabled RETURN VARCHAR2;
11
12 FUNCTION Construct_Qte_Header_Rec(
13 p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
14 p_creation_date IN DATE := FND_API.G_MISS_DATE,
15 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
16 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
17 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
18 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
19 p_request_id IN NUMBER := FND_API.G_MISS_NUM,
20 p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
21 p_program_id IN NUMBER := FND_API.G_MISS_NUM,
22 p_program_update_date IN DATE := FND_API.G_MISS_DATE,
23 p_org_id IN NUMBER := FND_API.G_MISS_NUM,
24 p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
25 p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
26 p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
27 p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
28 p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
29 p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
30 p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
31 p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
32 p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
33 p_party_id IN NUMBER := FND_API.G_MISS_NUM,
34 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
35 p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
36 p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
37 p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
38 p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
39 p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
40 p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
41 p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
42 p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
43 p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
44 p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
45 p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
46 p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
47 p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
48 p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
49 p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
50 p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
51 p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
52 p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
53 p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
54 p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
55 p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
56 p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
57 p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
58 p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
59 p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
60 p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
61 p_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
62 p_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
63 p_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
64 p_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
65 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
66 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81 p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
82 p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
83 p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
84 p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85 p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86 p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87 p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88 p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
89 p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
90 p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
91 p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92 p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93 p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
94 p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
95 p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
96 p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
97 p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
98 p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
99 p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
100 p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
101 p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
102 p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
103 p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
104 p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105 p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
106 p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
107 p_order_id IN NUMBER := FND_API.G_MISS_NUM,
108 p_order_number IN NUMBER := FND_API.G_MISS_NUM,
109 p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
110 p_ordered_date IN DATE := FND_API.G_MISS_DATE,
111 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
112 p_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
113 p_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
114 p_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
115 p_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
118 p_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
119 p_display_arithmetic_operator IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
121 p_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
123 p_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
124 p_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
125 p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
127 p_price_updated_date IN DATE := FND_API.G_MISS_DATE,
128 p_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
129 p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
131 p_credit_update_date IN DATE := FND_API.G_MISS_DATE,
132 p_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
133 p_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
134 p_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
135 p_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
136 p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137 p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139 p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140 p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
142 p_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
143 p_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
144 p_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
145 p_end_customer_party_id IN NUMBER := FND_API.G_MISS_NUM,
146 p_end_customer_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
147 p_end_customer_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
148 p_end_customer_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
149 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
150 p_header_paynow_charges IN NUMBER := FND_API.G_MISS_NUM
151 )
152 RETURN ASO_Quote_Pub.Qte_Header_Rec_Type;
153
154 FUNCTION Construct_Qte_Line_Tbl(
155 p_creation_date IN jtf_date_table := NULL,
156 p_created_by IN jtf_number_table := NULL,
157 p_last_updated_by IN jtf_number_table := NULL,
158 p_last_update_date IN jtf_date_table := NULL,
159 p_last_update_login IN jtf_number_table := NULL,
160 p_request_id IN jtf_number_table := NULL,
161 p_program_application_id IN jtf_number_table := NULL,
162 p_program_id IN jtf_number_table := NULL,
163 p_program_update_date IN jtf_date_table := NULL,
164 p_quote_line_id IN jtf_number_table := NULL,
165 p_quote_header_id IN jtf_number_table := NULL,
166 p_org_id IN jtf_number_table := NULL,
167 p_line_number IN jtf_number_table := NULL,
168 p_line_category_code IN jtf_varchar2_table_100 := NULL,
169 p_item_type_code IN jtf_varchar2_table_100 := NULL,
170 p_inventory_item_id IN jtf_number_table := NULL,
171 p_organization_id IN jtf_number_table := NULL,
172 p_quantity IN jtf_number_table := NULL,
173 p_uom_code IN jtf_varchar2_table_100 := NULL,
174 p_start_date_active IN jtf_date_table := NULL,
175 p_end_date_active IN jtf_date_table := NULL,
176 p_order_line_type_id IN jtf_number_table := NULL,
177 p_price_list_id IN jtf_number_table := NULL,
178 p_price_list_line_id IN jtf_number_table := NULL,
179 p_currency_code IN jtf_varchar2_table_100 := NULL,
180 p_line_list_price IN jtf_number_table := NULL,
181 p_line_adjusted_amount IN jtf_number_table := NULL,
182 p_line_adjusted_percent IN jtf_number_table := NULL,
183 p_line_quote_price IN jtf_number_table := NULL,
184 p_related_item_id IN jtf_number_table := NULL,
185 p_item_relationship_type IN jtf_varchar2_table_100 := NULL,
186 p_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
187 p_backorder_flag IN jtf_varchar2_table_100 := NULL,
188 p_selling_price_change IN jtf_varchar2_table_100 := NULL,
189 p_recalculate_flag IN jtf_varchar2_table_100 := NULL,
190 p_attribute_category IN jtf_varchar2_table_100 := NULL,
191 p_attribute1 IN jtf_varchar2_table_300 := NULL,
192 p_attribute2 IN jtf_varchar2_table_300 := NULL,
193 p_attribute3 IN jtf_varchar2_table_300 := NULL,
194 p_attribute4 IN jtf_varchar2_table_300 := NULL,
195 p_attribute5 IN jtf_varchar2_table_300 := NULL,
196 p_attribute6 IN jtf_varchar2_table_300 := NULL,
197 p_attribute7 IN jtf_varchar2_table_300 := NULL,
198 p_attribute8 IN jtf_varchar2_table_300 := NULL,
199 p_attribute9 IN jtf_varchar2_table_300 := NULL,
200 p_attribute10 IN jtf_varchar2_table_300 := NULL,
201 p_attribute11 IN jtf_varchar2_table_300 := NULL,
202 p_attribute12 IN jtf_varchar2_table_300 := NULL,
203 p_attribute13 IN jtf_varchar2_table_300 := NULL,
204 p_attribute14 IN jtf_varchar2_table_300 := NULL,
205 p_attribute15 IN jtf_varchar2_table_300 := NULL,
206 p_accounting_rule_id IN jtf_number_table := NULL,
207 p_ffm_content_name IN jtf_varchar2_table_300 := NULL,
208 p_ffm_content_type IN jtf_varchar2_table_300 := NULL,
209 p_ffm_document_type IN jtf_varchar2_table_300 := NULL,
210 p_ffm_media_id IN jtf_varchar2_table_300 := NULL,
211 p_ffm_media_type IN jtf_varchar2_table_300 := NULL,
212 p_ffm_user_note IN jtf_varchar2_table_300 := NULL,
213 p_invoice_to_party_id IN jtf_number_table := NULL,
214 p_invoice_to_party_site_id IN jtf_number_table := NULL,
215 p_invoicing_rule_id IN jtf_number_table := NULL,
216 p_marketing_source_code_id IN jtf_number_table := NULL,
217 p_operation_code IN jtf_varchar2_table_100 := NULL,
218 p_invoice_to_cust_account_id IN jtf_number_table := NULL,
219 p_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
220 p_minisite_id IN jtf_number_table := NULL,
221 p_section_id IN jtf_number_table := NULL,
222 p_priced_price_list_id IN jtf_number_table := NULL,
223 p_agreement_id IN jtf_number_table := NULL,
224 p_commitment_id IN jtf_number_table := NULL,
225 p_display_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
226 p_invoice_to_cust_party_id IN jtf_number_table := NULL,
227 p_attribute16 IN jtf_varchar2_table_300 := NULL,
228 p_attribute17 IN jtf_varchar2_table_300 := NULL,
229 p_attribute18 IN jtf_varchar2_table_300 := NULL,
230 p_attribute19 IN jtf_varchar2_table_300 := NULL,
231 p_attribute20 IN jtf_varchar2_table_300 := NULL,
232 p_ship_model_complete_flag IN jtf_varchar2_table_100 := NULL,
233 p_charge_periodicity_code IN jtf_varchar2_table_100 := NULL,
234 p_end_customer_party_id IN jtf_number_table := NULL,
235 p_end_customer_party_site_id IN jtf_number_table := NULL,
236 p_end_customer_cust_account_id IN jtf_number_table := NULL,
237 p_end_customer_cust_party_id IN jtf_number_table := NULL,
238 p_object_version_number IN jtf_number_table := NULL,
239 p_line_paynow_charges IN jtf_number_table := NULL,
240 p_line_paynow_tax IN jtf_number_table := NULL,
241 p_line_paynow_subtotal IN jtf_number_table := NULL,
242 p_config_model_type IN jtf_varchar2_table_100 := NULL
243 )
244 RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type;
245
246 FUNCTION Construct_Qte_Line_Rec(
247 p_creation_date IN DATE := FND_API.G_MISS_DATE,
248 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
249 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
250 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
251 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
252 p_request_id IN NUMBER := FND_API.G_MISS_NUM,
253 p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
254 p_program_id IN NUMBER := FND_API.G_MISS_NUM,
255 p_program_update_date IN DATE := FND_API.G_MISS_DATE,
256 p_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
257 p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
258 p_org_id IN NUMBER := FND_API.G_MISS_NUM,
259 p_line_number IN NUMBER := FND_API.G_MISS_NUM,
260 p_line_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
261 p_item_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
262 p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
263 p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
264 p_quantity IN NUMBER := FND_API.G_MISS_NUM,
265 p_uom_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
266 p_start_date_active IN DATE := FND_API.G_MISS_DATE,
267 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
268 p_order_line_type_id IN NUMBER := FND_API.G_MISS_NUM,
269 p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
270 p_price_list_line_id IN NUMBER := FND_API.G_MISS_NUM,
271 p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
272 p_line_list_price IN NUMBER := FND_API.G_MISS_NUM,
273 p_line_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
274 p_line_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
275 p_line_quote_price IN NUMBER := FND_API.G_MISS_NUM,
276 p_related_item_id IN NUMBER := FND_API.G_MISS_NUM,
277 p_item_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
278 p_split_shipment_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
279 p_backorder_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
280 p_selling_price_change IN VARCHAR2 := FND_API.G_MISS_CHAR,
281 p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
282 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
283 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
284 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
285 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298 p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
299 p_ffm_content_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300 p_ffm_content_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
301 p_ffm_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
302 p_ffm_media_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
303 p_ffm_media_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
304 p_ffm_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
305 p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
306 p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
307 p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
308 p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
309 p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
310 p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
311 p_pricing_quantity_uom IN VARCHAR2 := FND_API.G_MISS_CHAR,
312 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
313 p_section_id IN NUMBER := FND_API.G_MISS_NUM,
314 p_priced_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
315 p_agreement_id IN NUMBER := FND_API.G_MISS_NUM,
316 p_commitment_id IN NUMBER := FND_API.G_MISS_NUM,
317 p_display_arithmetic_operator IN VARCHAR2 := FND_API.G_MISS_CHAR,
318 p_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
319 p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320 p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321 p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
322 p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
323 p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
324 p_ship_model_complete_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
325 p_charge_periodicity_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326 p_end_customer_party_id IN NUMBER := FND_API.G_MISS_NUM,
327 p_end_customer_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
328 p_end_customer_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
329 p_end_customer_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
330 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
331 p_line_paynow_charges IN NUMBER := FND_API.G_MISS_NUM,
332 p_line_paynow_tax IN NUMBER := FND_API.G_MISS_NUM,
333 p_line_paynow_subtotal IN NUMBER := FND_API.G_MISS_NUM,
334 p_config_model_type IN VARCHAR2 := FND_API.G_MISS_CHAR
335 )
336 RETURN ASO_Quote_Pub.Qte_Line_Rec_Type;
337
338
339 FUNCTION Construct_Qte_Line_Dtl_Tbl(
340 p_quote_line_detail_id IN jtf_number_table := NULL,
341 p_creation_date IN jtf_date_table := NULL,
342 p_created_by IN jtf_number_table := NULL,
343 p_last_update_date IN jtf_date_table := NULL,
344 p_last_updated_by IN jtf_number_table := NULL,
345 p_last_update_login IN jtf_number_table := NULL,
346 p_request_id IN jtf_number_table := NULL,
347 p_program_application_id IN jtf_number_table := NULL,
348 p_program_id IN jtf_number_table := NULL,
349 p_program_update_date IN jtf_date_table := NULL,
350 p_quote_line_id IN jtf_number_table := NULL,
351 p_config_header_id IN jtf_number_table := NULL,
352 p_config_revision_num IN jtf_number_table := NULL,
353 p_config_item_id IN jtf_number_table := NULL,
354 p_complete_configuration IN jtf_varchar2_table_100 := NULL,
355 p_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
356 p_component_code IN jtf_varchar2_table_1200 := NULL,
357 p_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
358 p_service_duration IN jtf_number_table := NULL,
359 p_service_period IN jtf_varchar2_table_100 := NULL,
360 p_service_unit_selling IN jtf_number_table := NULL,
361 p_service_unit_list IN jtf_number_table := NULL,
362 p_service_number IN jtf_number_table := NULL,
363 p_unit_percent_base_price IN jtf_number_table := NULL,
364 p_attribute_category IN jtf_varchar2_table_100 := NULL,
365 p_attribute1 IN jtf_varchar2_table_300 := NULL,
366 p_attribute2 IN jtf_varchar2_table_300 := NULL,
367 p_attribute3 IN jtf_varchar2_table_300 := NULL,
368 p_attribute4 IN jtf_varchar2_table_300 := NULL,
369 p_attribute5 IN jtf_varchar2_table_300 := NULL,
370 p_attribute6 IN jtf_varchar2_table_300 := NULL,
371 p_attribute7 IN jtf_varchar2_table_300 := NULL,
372 p_attribute8 IN jtf_varchar2_table_300 := NULL,
373 p_attribute9 IN jtf_varchar2_table_300 := NULL,
374 p_attribute10 IN jtf_varchar2_table_300 := NULL,
375 p_attribute11 IN jtf_varchar2_table_300 := NULL,
376 p_attribute12 IN jtf_varchar2_table_300 := NULL,
377 p_attribute13 IN jtf_varchar2_table_300 := NULL,
378 p_attribute14 IN jtf_varchar2_table_300 := NULL,
379 p_attribute15 IN jtf_varchar2_table_300 := NULL,
380 p_service_ref_type_code IN jtf_varchar2_table_100 := NULL,
381 p_service_ref_order_number IN jtf_number_table := NULL,
382 p_service_ref_line_number IN jtf_number_table := NULL,
383 p_service_ref_qte_line_ind IN jtf_number_table := NULL,
384 p_service_ref_line_id IN jtf_number_table := NULL,
385 p_service_ref_system_id IN jtf_number_table := NULL,
386 p_service_ref_option_numb IN jtf_number_table := NULL,
387 p_service_ref_shipment IN jtf_number_table := NULL,
388 p_return_ref_type IN jtf_varchar2_table_100 := NULL,
389 p_return_ref_header_id IN jtf_number_table := NULL,
390 p_return_ref_line_id IN jtf_number_table := NULL,
391 p_return_attribute1 IN jtf_varchar2_table_300 := NULL,
392 p_return_attribute2 IN jtf_varchar2_table_300 := NULL,
393 p_return_attribute3 IN jtf_varchar2_table_300 := NULL,
394 p_return_attribute4 IN jtf_varchar2_table_300 := NULL,
395 p_return_attribute5 IN jtf_varchar2_table_300 := NULL,
396 p_return_attribute6 IN jtf_varchar2_table_300 := NULL,
397 p_return_attribute7 IN jtf_varchar2_table_300 := NULL,
398 p_return_attribute8 IN jtf_varchar2_table_300 := NULL,
399 p_return_attribute9 IN jtf_varchar2_table_300 := NULL,
400 p_return_attribute10 IN jtf_varchar2_table_300 := NULL,
401 p_return_attribute11 IN jtf_varchar2_table_300 := NULL,
402 p_return_attribute12 IN jtf_varchar2_table_300 := NULL,
403 p_return_attribute13 IN jtf_varchar2_table_300 := NULL,
404 p_return_attribute14 IN jtf_varchar2_table_300 := NULL,
405 p_return_attribute15 IN jtf_varchar2_table_300 := NULL,
406 p_operation_code IN jtf_varchar2_table_100 := NULL,
407 p_qte_line_index IN jtf_number_table := NULL,
408 p_return_attr_category IN jtf_varchar2_table_100 := NULL,
409 p_return_reason_code IN jtf_varchar2_table_100 := NULL,
410 p_change_reason_code IN jtf_varchar2_table_100 := NULL,
411 p_attribute16 IN jtf_varchar2_table_300 := NULL,
412 p_attribute17 IN jtf_varchar2_table_300 := NULL,
413 p_attribute18 IN jtf_varchar2_table_300 := NULL,
414 p_attribute19 IN jtf_varchar2_table_300 := NULL,
415 p_attribute20 IN jtf_varchar2_table_300 := NULL,
416 p_top_model_line_id IN jtf_number_table := NULL,
417 p_top_model_line_index IN jtf_number_table := NULL,
418 p_ato_line_id IN jtf_number_table := NULL,
419 p_ato_line_index IN jtf_number_table := NULL,
420 p_component_sequence_id IN jtf_number_table := NULL,
421 p_object_version_number IN jtf_number_table := NULL
422 )
423 RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
424
425 FUNCTION Construct_Qte_Line_Dtl_Rec(
426 p_quote_line_detail_id IN NUMBER := FND_API.G_MISS_NUM,
427 p_creation_date IN DATE := FND_API.G_MISS_DATE,
428 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
429 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
430 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
431 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
432 p_request_id IN NUMBER := FND_API.G_MISS_NUM,
433 p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
434 p_program_id IN NUMBER := FND_API.G_MISS_NUM,
435 p_program_update_date IN DATE := FND_API.G_MISS_DATE,
436 p_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
437 p_config_header_id IN NUMBER := FND_API.G_MISS_NUM,
438 p_config_revision_num IN NUMBER := FND_API.G_MISS_NUM,
439 p_config_item_id IN NUMBER := FND_API.G_MISS_NUM,
440 p_complete_configuration IN VARCHAR2 := FND_API.G_MISS_CHAR,
441 p_valid_configuration_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442 p_component_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
443 p_service_coterminate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
444 p_service_duration IN NUMBER := FND_API.G_MISS_NUM,
445 p_service_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
446 p_service_unit_selling IN NUMBER := FND_API.G_MISS_NUM,
447 p_service_unit_list IN NUMBER := FND_API.G_MISS_NUM,
448 p_service_number IN NUMBER := FND_API.G_MISS_NUM,
449 p_unit_percent_base_price IN NUMBER := FND_API.G_MISS_NUM,
450 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
451 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466 p_service_ref_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
467 p_service_ref_order_number IN NUMBER := FND_API.G_MISS_NUM,
468 p_service_ref_line_number IN NUMBER := FND_API.G_MISS_NUM,
469 p_service_ref_qte_line_ind IN NUMBER := FND_API.G_MISS_NUM,
470 p_service_ref_line_id IN NUMBER := FND_API.G_MISS_NUM,
471 p_service_ref_system_id IN NUMBER := FND_API.G_MISS_NUM,
472 p_service_ref_option_numb IN NUMBER := FND_API.G_MISS_NUM,
473 p_service_ref_shipment IN NUMBER := FND_API.G_MISS_NUM,
474 p_return_ref_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
475 p_return_ref_header_id IN NUMBER := FND_API.G_MISS_NUM,
476 p_return_ref_line_id IN NUMBER := FND_API.G_MISS_NUM,
477 p_return_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
478 p_return_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
479 p_return_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
480 p_return_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
481 p_return_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
482 p_return_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
483 p_return_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
484 p_return_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
485 p_return_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
486 p_return_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
487 p_return_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
488 p_return_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
489 p_return_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
490 p_return_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
491 p_return_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
492 p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
493 p_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
494 p_return_attr_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
495 p_return_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
496 p_change_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
497 p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
498 p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499 p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500 p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501 p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
502 p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
503 p_top_model_line_index IN NUMBER := FND_API.G_MISS_NUM,
504 p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM,
505 p_ato_line_index IN NUMBER := FND_API.G_MISS_NUM,
506 p_component_sequence_id IN NUMBER := FND_API.G_MISS_NUM,
507 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM
508 )
509 RETURN ASO_Quote_Pub.Qte_Line_Dtl_Rec_Type;
510
511 FUNCTION Construct_Line_Rltship_Tbl(
512 p_line_relationship_id IN jtf_number_table := NULL,
513 p_creation_date IN jtf_date_table := NULL,
514 p_created_by IN jtf_number_table := NULL,
515 p_last_updated_by IN jtf_number_table := NULL,
516 p_last_update_date IN jtf_date_table := NULL,
517 p_last_update_login IN jtf_number_table := NULL,
518 p_request_id IN jtf_number_table := NULL,
519 p_program_application_id IN jtf_number_table := NULL,
520 p_program_id IN jtf_number_table := NULL,
521 p_program_update_date IN jtf_date_table := NULL,
522 p_quote_line_id IN jtf_number_table := NULL,
523 p_related_quote_line_id IN jtf_number_table := NULL,
524 p_relationship_type_code IN jtf_varchar2_table_100 := NULL,
525 p_reciprocal_flag IN jtf_varchar2_table_100 := NULL,
526 p_qte_line_index IN jtf_number_table := NULL,
527 p_related_qte_line_index IN jtf_number_table := NULL,
528 p_operation_code IN jtf_varchar2_table_100 := NULL,
529 p_object_version_number IN jtf_number_table := NULL
530 )
531 RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type;
532
533 FUNCTION Construct_Payment_Tbl(
534 p_operation_code IN jtf_varchar2_table_100 := NULL,
535 p_qte_line_index IN jtf_number_table := NULL,
536 p_payment_id IN jtf_number_table := NULL,
537 p_creation_date IN jtf_date_table := NULL,
538 p_created_by IN jtf_number_table := NULL,
539 p_last_update_date IN jtf_date_table := NULL,
540 p_last_updated_by IN jtf_number_table := NULL,
541 p_last_update_login IN jtf_number_table := NULL,
542 p_request_id IN jtf_number_table := NULL,
543 p_program_application_id IN jtf_number_table := NULL,
544 p_program_id IN jtf_number_table := NULL,
545 p_program_update_date IN jtf_date_table := NULL,
546 p_quote_header_id IN jtf_number_table := NULL,
547 p_quote_line_id IN jtf_number_table := NULL,
548 p_payment_type_code IN jtf_varchar2_table_100 := NULL,
549 p_payment_ref_number IN jtf_varchar2_table_300 := NULL,
550 p_payment_option IN jtf_varchar2_table_300 := NULL,
551 p_payment_term_id IN jtf_number_table := NULL,
552 p_credit_card_code IN jtf_varchar2_table_100 := NULL,
553 p_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
554 p_credit_card_exp_date IN jtf_date_table := NULL,
555 p_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
556 p_credit_card_approval_date IN jtf_date_table := NULL,
557 p_payment_amount IN jtf_number_table := NULL,
558 p_attribute_category IN jtf_varchar2_table_100 := NULL,
559 p_attribute1 IN jtf_varchar2_table_300 := NULL,
560 p_attribute2 IN jtf_varchar2_table_300 := NULL,
561 p_attribute3 IN jtf_varchar2_table_300 := NULL,
562 p_attribute4 IN jtf_varchar2_table_300 := NULL,
563 p_attribute5 IN jtf_varchar2_table_300 := NULL,
564 p_attribute6 IN jtf_varchar2_table_300 := NULL,
565 p_attribute7 IN jtf_varchar2_table_300 := NULL,
566 p_attribute8 IN jtf_varchar2_table_300 := NULL,
567 p_attribute9 IN jtf_varchar2_table_300 := NULL,
568 p_attribute10 IN jtf_varchar2_table_300 := NULL,
569 p_attribute11 IN jtf_varchar2_table_300 := NULL,
570 p_attribute12 IN jtf_varchar2_table_300 := NULL,
571 p_attribute13 IN jtf_varchar2_table_300 := NULL,
572 p_attribute14 IN jtf_varchar2_table_300 := NULL,
573 p_attribute15 IN jtf_varchar2_table_300 := NULL,
574 p_shipment_index IN jtf_number_table := NULL,
575 p_quote_shipment_id IN jtf_number_table := NULL,
576 p_cust_po_number IN jtf_varchar2_table_100 := NULL,
577 p_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
578 p_attribute16 IN jtf_varchar2_table_300 := NULL,
579 p_attribute17 IN jtf_varchar2_table_300 := NULL,
580 p_attribute18 IN jtf_varchar2_table_300 := NULL,
581 p_attribute19 IN jtf_varchar2_table_300 := NULL,
582 p_attribute20 IN jtf_varchar2_table_300 := NULL,
583 p_trxn_extension_id IN jtf_number_table := NULL,
584 p_instrument_id IN jtf_number_table := NULL,
585 p_instr_assignment_id IN jtf_number_table := NULL,
586 p_cvv2 IN jtf_varchar2_table_100 := NULL,
587 p_object_version_number IN jtf_number_table := NULL
588
589 )
590 RETURN ASO_Quote_Pub.Payment_Tbl_Type;
591
592 FUNCTION Construct_Payment_Rec(
593 p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
594 p_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
595 p_payment_id IN NUMBER := FND_API.G_MISS_NUM,
596 p_creation_date IN DATE := FND_API.G_MISS_DATE,
597 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
598 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
599 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
600 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
601 p_request_id IN NUMBER := FND_API.G_MISS_NUM,
602 p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
603 p_program_id IN NUMBER := FND_API.G_MISS_NUM,
604 p_program_update_date IN DATE := FND_API.G_MISS_DATE,
605 p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
606 p_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
607 p_payment_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
608 p_payment_ref_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
609 p_payment_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
610 p_payment_term_id IN NUMBER := FND_API.G_MISS_NUM,
611 p_credit_card_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
612 p_credit_card_holder_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
613 p_credit_card_exp_date IN DATE := FND_API.G_MISS_DATE,
614 p_credit_card_approval_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
615 p_credit_card_approval_date IN DATE := FND_API.G_MISS_DATE,
616 p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
617 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
618 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
619 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
620 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
621 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
622 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
623 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
624 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
625 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
626 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
627 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
628 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
629 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
630 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
631 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
632 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
633 p_shipment_index IN NUMBER := FND_API.G_MISS_NUM,
634 p_quote_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
635 p_cust_po_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
636 p_cust_po_line_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
637 p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
638 p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
639 p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
640 p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
641 p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
642 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
643 p_trxn_extension_id IN NUMBER := FND_API.G_MISS_NUM,
644 p_instrument_id IN NUMBER := FND_API.G_MISS_NUM,
645 p_instr_assignment_id IN NUMBER := FND_API.G_MISS_NUM,
646 p_cvv2 IN VARCHAR2 := FND_API.G_MISS_CHAR
647
648 )
649 RETURN ASO_Quote_Pub.Payment_Rec_Type;
650
651
652 FUNCTION Construct_Shipment_Rec(
653 p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
654 p_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
655 p_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
656 p_creation_date IN DATE := FND_API.G_MISS_DATE,
657 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
658 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
659 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
660 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
661 p_request_id IN NUMBER := FND_API.G_MISS_NUM,
662 p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
663 p_program_id IN NUMBER := FND_API.G_MISS_NUM,
664 p_program_update_date IN DATE := FND_API.G_MISS_DATE,
665 p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
666 p_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
667 p_promise_date IN DATE := FND_API.G_MISS_DATE,
668 p_request_date IN DATE := FND_API.G_MISS_DATE,
669 p_schedule_ship_date IN DATE := FND_API.G_MISS_DATE,
670 p_ship_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
671 p_ship_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
672 p_ship_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
673 p_ship_partial_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
674 p_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,
675 p_ship_method_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
676 p_freight_terms_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
677 p_freight_carrier_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
678 p_fob_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
679 p_shipping_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
680 p_packing_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
681 p_quantity IN NUMBER := FND_API.G_MISS_NUM,
682 p_reserved_quantity IN VARCHAR2 := FND_API.G_MISS_CHAR,
683 p_reservation_id IN NUMBER := FND_API.G_MISS_NUM,
684 p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
685 p_ship_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
686 p_ship_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
687 p_ship_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
688 p_ship_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
689 p_ship_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
690 p_ship_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
691 p_ship_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
692 p_ship_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
693 p_ship_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
694 p_ship_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
695 p_ship_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
696 p_ship_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
697 p_ship_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
698 p_ship_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
699 p_ship_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
700 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
701 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
703 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
705 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
707 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
709 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
710 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
711 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
712 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
713 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
714 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
715 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
716 p_ship_quote_price IN NUMBER := FND_API.G_MISS_NUM,
717 p_pricing_quantity IN NUMBER := FND_API.G_MISS_NUM,
718 p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
719 p_ship_from_org_id IN NUMBER := FND_API.G_MISS_NUM,
720 p_ship_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
721 p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
722 p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723 p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
724 p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725 p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
726 p_request_date_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
727 p_demand_class_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
728 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM
729 )
730 RETURN ASO_Quote_Pub.Shipment_Rec_Type;
731
732 FUNCTION Construct_Shipment_Tbl(
733 p_operation_code IN jtf_varchar2_table_100 := NULL,
734 p_qte_line_index IN jtf_number_table := NULL,
735 p_shipment_id IN jtf_number_table := NULL,
736 p_creation_date IN jtf_date_table := NULL,
737 p_created_by IN jtf_number_table := NULL,
738 p_last_update_date IN jtf_date_table := NULL,
739 p_last_updated_by IN jtf_number_table := NULL,
740 p_last_update_login IN jtf_number_table := NULL,
741 p_request_id IN jtf_number_table := NULL,
742 p_program_application_id IN jtf_number_table := NULL,
743 p_program_id IN jtf_number_table := NULL,
744 p_program_update_date IN jtf_date_table := NULL,
745 p_quote_header_id IN jtf_number_table := NULL,
746 p_quote_line_id IN jtf_number_table := NULL,
747 p_promise_date IN jtf_date_table := NULL,
748 p_request_date IN jtf_date_table := NULL,
749 p_schedule_ship_date IN jtf_date_table := NULL,
750 p_ship_to_party_site_id IN jtf_number_table := NULL,
751 p_ship_to_party_id IN jtf_number_table := NULL,
752 p_ship_to_cust_account_id IN jtf_number_table := NULL,
753 p_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
754 p_ship_set_id IN jtf_number_table := NULL,
755 p_ship_method_code IN jtf_varchar2_table_100 := NULL,
756 p_freight_terms_code IN jtf_varchar2_table_100 := NULL,
757 p_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
758 p_fob_code IN jtf_varchar2_table_100 := NULL,
759 p_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
760 p_packing_instructions IN jtf_varchar2_table_2000 := NULL,
761 p_quantity IN jtf_number_table := NULL,
762 p_reserved_quantity IN jtf_varchar2_table_300 := NULL,
763 p_reservation_id IN jtf_number_table := NULL,
764 p_order_line_id IN jtf_number_table := NULL,
765 p_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
766 p_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
767 p_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
768 p_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
769 p_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
770 p_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
771 p_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
772 p_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
773 p_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
774 p_ship_to_country IN jtf_varchar2_table_100 := NULL,
775 p_ship_to_city IN jtf_varchar2_table_100 := NULL,
776 p_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
777 p_ship_to_state IN jtf_varchar2_table_100 := NULL,
778 p_ship_to_province IN jtf_varchar2_table_100 := NULL,
779 p_ship_to_county IN jtf_varchar2_table_100 := NULL,
780 p_attribute_category IN jtf_varchar2_table_100 := NULL,
781 p_attribute1 IN jtf_varchar2_table_300 := NULL,
782 p_attribute2 IN jtf_varchar2_table_300 := NULL,
783 p_attribute3 IN jtf_varchar2_table_300 := NULL,
784 p_attribute4 IN jtf_varchar2_table_300 := NULL,
785 p_attribute5 IN jtf_varchar2_table_300 := NULL,
786 p_attribute6 IN jtf_varchar2_table_300 := NULL,
787 p_attribute7 IN jtf_varchar2_table_300 := NULL,
788 p_attribute8 IN jtf_varchar2_table_300 := NULL,
789 p_attribute9 IN jtf_varchar2_table_300 := NULL,
790 p_attribute10 IN jtf_varchar2_table_300 := NULL,
791 p_attribute11 IN jtf_varchar2_table_300 := NULL,
792 p_attribute12 IN jtf_varchar2_table_300 := NULL,
793 p_attribute13 IN jtf_varchar2_table_300 := NULL,
794 p_attribute14 IN jtf_varchar2_table_300 := NULL,
795 p_attribute15 IN jtf_varchar2_table_300 := NULL,
796 p_ship_quote_price IN jtf_number_table := NULL,
797 p_pricing_quantity IN jtf_number_table := NULL,
798 p_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
799 p_ship_from_org_id IN jtf_number_table := NULL,
800 p_ship_to_cust_party_id IN jtf_number_table := NULL,
801 p_attribute16 IN jtf_varchar2_table_300 := NULL,
802 p_attribute17 IN jtf_varchar2_table_300 := NULL,
803 p_attribute18 IN jtf_varchar2_table_300 := NULL,
804 p_attribute19 IN jtf_varchar2_table_300 := NULL,
805 p_attribute20 IN jtf_varchar2_table_300 := NULL,
806 p_request_date_type IN jtf_varchar2_table_100 := NULL,
807 p_demand_class_code IN jtf_varchar2_table_100 := NULL,
808 p_object_version_number IN jtf_number_table := NULL
809 )
810 RETURN ASO_Quote_Pub.Shipment_Tbl_Type;
811
812 FUNCTION Construct_Tax_Detail_Tbl(
813 p_operation_code IN jtf_varchar2_table_100 := NULL,
814 p_qte_line_index IN jtf_number_table := NULL,
815 p_shipment_index IN jtf_number_table := NULL,
816 p_tax_detail_id IN jtf_number_table := NULL,
817 p_quote_header_id IN jtf_number_table := NULL,
818 p_quote_line_id IN jtf_number_table := NULL,
819 p_quote_shipment_id IN jtf_number_table := NULL,
820 p_creation_date IN jtf_date_table := NULL,
821 p_created_by IN jtf_number_table := NULL,
822 p_last_update_date IN jtf_date_table := NULL,
823 p_last_updated_by IN jtf_number_table := NULL,
824 p_last_update_login IN jtf_number_table := NULL,
825 p_request_id IN jtf_number_table := NULL,
826 p_program_application_id IN jtf_number_table := NULL,
827 p_program_id IN jtf_number_table := NULL,
828 p_program_update_date IN jtf_date_table := NULL,
829 p_orig_tax_code IN jtf_varchar2_table_300 := NULL,
830 p_tax_code IN jtf_varchar2_table_100 := NULL,
831 p_tax_rate IN jtf_number_table := NULL,
832 p_tax_date IN jtf_date_table := NULL,
833 p_tax_amount IN jtf_number_table := NULL,
834 p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
835 p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
836 p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
837 p_attribute_category IN jtf_varchar2_table_100 := NULL,
838 p_attribute1 IN jtf_varchar2_table_300 := NULL,
839 p_attribute2 IN jtf_varchar2_table_300 := NULL,
840 p_attribute3 IN jtf_varchar2_table_300 := NULL,
841 p_attribute4 IN jtf_varchar2_table_300 := NULL,
842 p_attribute5 IN jtf_varchar2_table_300 := NULL,
843 p_attribute6 IN jtf_varchar2_table_300 := NULL,
844 p_attribute7 IN jtf_varchar2_table_300 := NULL,
845 p_attribute8 IN jtf_varchar2_table_300 := NULL,
846 p_attribute9 IN jtf_varchar2_table_300 := NULL,
847 p_attribute10 IN jtf_varchar2_table_300 := NULL,
848 p_attribute11 IN jtf_varchar2_table_300 := NULL,
849 p_attribute12 IN jtf_varchar2_table_300 := NULL,
850 p_attribute13 IN jtf_varchar2_table_300 := NULL,
851 p_attribute14 IN jtf_varchar2_table_300 := NULL,
852 p_attribute15 IN jtf_varchar2_table_300 := NULL,
853 p_attribute16 IN jtf_varchar2_table_300 := NULL,
854 p_attribute17 IN jtf_varchar2_table_300 := NULL,
855 p_attribute18 IN jtf_varchar2_table_300 := NULL,
856 p_attribute19 IN jtf_varchar2_table_300 := NULL,
857 p_attribute20 IN jtf_varchar2_table_300 := NULL,
858 p_object_version_number IN jtf_number_table := NULL,
859 p_tax_rate_id IN jtf_number_table := NULL
860 )
861 RETURN ASO_Quote_Pub.Tax_Detail_Tbl_Type;
862
863 FUNCTION Construct_Tax_Detail_Rec(
864 p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
865 p_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
866 p_shipment_index IN NUMBER := FND_API.G_MISS_NUM,
867 p_tax_detail_id IN NUMBER := FND_API.G_MISS_NUM,
868 p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
869 p_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
870 p_quote_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
871 p_creation_date IN DATE := FND_API.G_MISS_DATE,
872 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
873 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
874 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
875 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
876 p_request_id IN NUMBER := FND_API.G_MISS_NUM,
877 p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
878 p_program_id IN NUMBER := FND_API.G_MISS_NUM,
879 p_program_update_date IN DATE := FND_API.G_MISS_DATE,
880 p_orig_tax_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
881 p_tax_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
882 p_tax_rate IN NUMBER := FND_API.G_MISS_NUM,
883 p_tax_date IN DATE := FND_API.G_MISS_DATE,
884 p_tax_amount IN NUMBER := FND_API.G_MISS_NUM,
885 p_tax_exempt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
886 p_tax_exempt_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
887 p_tax_exempt_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
888 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
889 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
890 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
891 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
892 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
893 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
894 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
895 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
896 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
897 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
898 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
899 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
900 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
901 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
902 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
903 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
904 p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
905 p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
906 p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
907 p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
908 p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
909 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
910 p_tax_rate_id IN NUMBER := FND_API.G_MISS_NUM
911 )
912 RETURN ASO_Quote_Pub.Tax_Detail_Rec_Type;
913
914
915 FUNCTION Construct_Price_Attributes_Tbl(
916 p_operation_code IN jtf_varchar2_table_100 := NULL,
917 p_qte_line_index IN jtf_number_table := NULL,
918 p_price_attribute_id IN jtf_number_table := NULL,
919 p_creation_date IN jtf_date_table := NULL,
920 p_created_by IN jtf_number_table := NULL,
921 p_last_update_date IN jtf_date_table := NULL,
922 p_last_updated_by IN jtf_number_table := NULL,
923 p_last_update_login IN jtf_number_table := NULL,
924 p_request_id IN jtf_number_table := NULL,
925 p_program_application_id IN jtf_number_table := NULL,
926 p_program_id IN jtf_number_table := NULL,
927 p_program_update_date IN jtf_date_table := NULL,
928 p_quote_header_id IN jtf_number_table := NULL,
929 p_quote_line_id IN jtf_number_table := NULL,
930 p_flex_title IN jtf_varchar2_table_100 := NULL,
931 p_pricing_context IN jtf_varchar2_table_100 := NULL,
932 p_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
933 p_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
934 p_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,
935 p_pricing_attribute4 IN jtf_varchar2_table_300 := NULL,
936 p_pricing_attribute5 IN jtf_varchar2_table_300 := NULL,
937 p_pricing_attribute6 IN jtf_varchar2_table_300 := NULL,
938 p_pricing_attribute7 IN jtf_varchar2_table_300 := NULL,
939 p_pricing_attribute8 IN jtf_varchar2_table_300 := NULL,
940 p_pricing_attribute9 IN jtf_varchar2_table_300 := NULL,
941 p_pricing_attribute10 IN jtf_varchar2_table_300 := NULL,
942 p_pricing_attribute11 IN jtf_varchar2_table_300 := NULL,
943 p_pricing_attribute12 IN jtf_varchar2_table_300 := NULL,
944 p_pricing_attribute13 IN jtf_varchar2_table_300 := NULL,
945 p_pricing_attribute14 IN jtf_varchar2_table_300 := NULL,
946 p_pricing_attribute15 IN jtf_varchar2_table_300 := NULL,
947 p_pricing_attribute16 IN jtf_varchar2_table_300 := NULL,
948 p_pricing_attribute17 IN jtf_varchar2_table_300 := NULL,
949 p_pricing_attribute18 IN jtf_varchar2_table_300 := NULL,
950 p_pricing_attribute19 IN jtf_varchar2_table_300 := NULL,
951 p_pricing_attribute20 IN jtf_varchar2_table_300 := NULL,
952 p_pricing_attribute21 IN jtf_varchar2_table_300 := NULL,
953 p_pricing_attribute22 IN jtf_varchar2_table_300 := NULL,
954 p_pricing_attribute23 IN jtf_varchar2_table_300 := NULL,
955 p_pricing_attribute24 IN jtf_varchar2_table_300 := NULL,
956 p_pricing_attribute25 IN jtf_varchar2_table_300 := NULL,
957 p_pricing_attribute26 IN jtf_varchar2_table_300 := NULL,
958 p_pricing_attribute27 IN jtf_varchar2_table_300 := NULL,
959 p_pricing_attribute28 IN jtf_varchar2_table_300 := NULL,
960 p_pricing_attribute29 IN jtf_varchar2_table_300 := NULL,
961 p_pricing_attribute30 IN jtf_varchar2_table_300 := NULL,
962 p_pricing_attribute31 IN jtf_varchar2_table_300 := NULL,
963 p_pricing_attribute32 IN jtf_varchar2_table_300 := NULL,
964 p_pricing_attribute33 IN jtf_varchar2_table_300 := NULL,
965 p_pricing_attribute34 IN jtf_varchar2_table_300 := NULL,
966 p_pricing_attribute35 IN jtf_varchar2_table_300 := NULL,
967 p_pricing_attribute36 IN jtf_varchar2_table_300 := NULL,
968 p_pricing_attribute37 IN jtf_varchar2_table_300 := NULL,
969 p_pricing_attribute38 IN jtf_varchar2_table_300 := NULL,
970 p_pricing_attribute39 IN jtf_varchar2_table_300 := NULL,
971 p_pricing_attribute40 IN jtf_varchar2_table_300 := NULL,
972 p_pricing_attribute41 IN jtf_varchar2_table_300 := NULL,
973 p_pricing_attribute42 IN jtf_varchar2_table_300 := NULL,
974 p_pricing_attribute43 IN jtf_varchar2_table_300 := NULL,
975 p_pricing_attribute44 IN jtf_varchar2_table_300 := NULL,
976 p_pricing_attribute45 IN jtf_varchar2_table_300 := NULL,
977 p_pricing_attribute46 IN jtf_varchar2_table_300 := NULL,
978 p_pricing_attribute47 IN jtf_varchar2_table_300 := NULL,
979 p_pricing_attribute48 IN jtf_varchar2_table_300 := NULL,
980 p_pricing_attribute49 IN jtf_varchar2_table_300 := NULL,
981 p_pricing_attribute50 IN jtf_varchar2_table_300 := NULL,
982 p_pricing_attribute51 IN jtf_varchar2_table_300 := NULL,
983 p_pricing_attribute52 IN jtf_varchar2_table_300 := NULL,
984 p_pricing_attribute53 IN jtf_varchar2_table_300 := NULL,
985 p_pricing_attribute54 IN jtf_varchar2_table_300 := NULL,
986 p_pricing_attribute55 IN jtf_varchar2_table_300 := NULL,
987 p_pricing_attribute56 IN jtf_varchar2_table_300 := NULL,
988 p_pricing_attribute57 IN jtf_varchar2_table_300 := NULL,
989 p_pricing_attribute58 IN jtf_varchar2_table_300 := NULL,
990 p_pricing_attribute59 IN jtf_varchar2_table_300 := NULL,
991 p_pricing_attribute60 IN jtf_varchar2_table_300 := NULL,
992 p_pricing_attribute61 IN jtf_varchar2_table_300 := NULL,
993 p_pricing_attribute62 IN jtf_varchar2_table_300 := NULL,
994 p_pricing_attribute63 IN jtf_varchar2_table_300 := NULL,
995 p_pricing_attribute64 IN jtf_varchar2_table_300 := NULL,
996 p_pricing_attribute65 IN jtf_varchar2_table_300 := NULL,
997 p_pricing_attribute66 IN jtf_varchar2_table_300 := NULL,
998 p_pricing_attribute67 IN jtf_varchar2_table_300 := NULL,
999 p_pricing_attribute68 IN jtf_varchar2_table_300 := NULL,
1000 p_pricing_attribute69 IN jtf_varchar2_table_300 := NULL,
1001 p_pricing_attribute70 IN jtf_varchar2_table_300 := NULL,
1002 p_pricing_attribute71 IN jtf_varchar2_table_300 := NULL,
1003 p_pricing_attribute72 IN jtf_varchar2_table_300 := NULL,
1004 p_pricing_attribute73 IN jtf_varchar2_table_300 := NULL,
1005 p_pricing_attribute74 IN jtf_varchar2_table_300 := NULL,
1006 p_pricing_attribute75 IN jtf_varchar2_table_300 := NULL,
1007 p_pricing_attribute76 IN jtf_varchar2_table_300 := NULL,
1008 p_pricing_attribute77 IN jtf_varchar2_table_300 := NULL,
1009 p_pricing_attribute78 IN jtf_varchar2_table_300 := NULL,
1010 p_pricing_attribute79 IN jtf_varchar2_table_300 := NULL,
1011 p_pricing_attribute80 IN jtf_varchar2_table_300 := NULL,
1012 p_pricing_attribute81 IN jtf_varchar2_table_300 := NULL,
1013 p_pricing_attribute82 IN jtf_varchar2_table_300 := NULL,
1014 p_pricing_attribute83 IN jtf_varchar2_table_300 := NULL,
1015 p_pricing_attribute84 IN jtf_varchar2_table_300 := NULL,
1016 p_pricing_attribute85 IN jtf_varchar2_table_300 := NULL,
1017 p_pricing_attribute86 IN jtf_varchar2_table_300 := NULL,
1018 p_pricing_attribute87 IN jtf_varchar2_table_300 := NULL,
1019 p_pricing_attribute88 IN jtf_varchar2_table_300 := NULL,
1020 p_pricing_attribute89 IN jtf_varchar2_table_300 := NULL,
1021 p_pricing_attribute90 IN jtf_varchar2_table_300 := NULL,
1022 p_pricing_attribute91 IN jtf_varchar2_table_300 := NULL,
1023 p_pricing_attribute92 IN jtf_varchar2_table_300 := NULL,
1024 p_pricing_attribute93 IN jtf_varchar2_table_300 := NULL,
1025 p_pricing_attribute94 IN jtf_varchar2_table_300 := NULL,
1026 p_pricing_attribute95 IN jtf_varchar2_table_300 := NULL,
1027 p_pricing_attribute96 IN jtf_varchar2_table_300 := NULL,
1028 p_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
1029 p_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
1030 p_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
1031 p_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
1032 p_context IN jtf_varchar2_table_100 := NULL,
1033 p_attribute1 IN jtf_varchar2_table_300 := NULL,
1034 p_attribute2 IN jtf_varchar2_table_300 := NULL,
1035 p_attribute3 IN jtf_varchar2_table_300 := NULL,
1036 p_attribute4 IN jtf_varchar2_table_300 := NULL,
1037 p_attribute5 IN jtf_varchar2_table_300 := NULL,
1038 p_attribute6 IN jtf_varchar2_table_300 := NULL,
1039 p_attribute7 IN jtf_varchar2_table_300 := NULL,
1040 p_attribute8 IN jtf_varchar2_table_300 := NULL,
1041 p_attribute9 IN jtf_varchar2_table_300 := NULL,
1042 p_attribute10 IN jtf_varchar2_table_300 := NULL,
1043 p_attribute11 IN jtf_varchar2_table_300 := NULL,
1044 p_attribute12 IN jtf_varchar2_table_300 := NULL,
1045 p_attribute13 IN jtf_varchar2_table_300 := NULL,
1046 p_attribute14 IN jtf_varchar2_table_300 := NULL,
1047 p_attribute15 IN jtf_varchar2_table_300 := NULL,
1048 p_attribute16 IN jtf_varchar2_table_300 := NULL,
1049 p_attribute17 IN jtf_varchar2_table_300 := NULL,
1050 p_attribute18 IN jtf_varchar2_table_300 := NULL,
1051 p_attribute19 IN jtf_varchar2_table_300 := NULL,
1052 p_attribute20 IN jtf_varchar2_table_300 := NULL,
1053 p_object_version_number IN jtf_number_table := NULL
1054 )
1055 RETURN ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1056
1057 FUNCTION Construct_Price_Adj_Tbl(
1058 p_operation_code IN jtf_varchar2_table_100 := NULL,
1059 p_qte_line_index IN jtf_number_table := NULL,
1060 p_price_adjustment_id IN jtf_number_table := NULL,
1061 p_creation_date IN jtf_date_table := NULL,
1062 p_created_by IN jtf_number_table := NULL,
1063 p_last_update_date IN jtf_date_table := NULL,
1064 p_last_updated_by IN jtf_number_table := NULL,
1065 p_last_update_login IN jtf_number_table := NULL,
1066 p_program_application_id IN jtf_number_table := NULL,
1067 p_program_id IN jtf_number_table := NULL,
1068 p_program_update_date IN jtf_date_table := NULL,
1069 p_request_id IN jtf_number_table := NULL,
1070 p_quote_header_id IN jtf_number_table := NULL,
1071 p_quote_line_id IN jtf_number_table := NULL,
1072 p_modifier_header_id IN jtf_number_table := NULL,
1073 p_modifier_line_id IN jtf_number_table := NULL,
1074 p_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
1075 p_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
1076 p_modified_from IN jtf_number_table := NULL,
1077 p_modified_to IN jtf_number_table := NULL,
1078 p_operand IN jtf_number_table := NULL,
1079 p_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
1080 p_automatic_flag IN jtf_varchar2_table_100 := NULL,
1081 p_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
1082 p_updated_flag IN jtf_varchar2_table_100 := NULL,
1083 p_applied_flag IN jtf_varchar2_table_100 := NULL,
1084 p_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1085 p_pricing_phase_id IN jtf_number_table := NULL,
1086 p_attribute_category IN jtf_varchar2_table_100 := NULL,
1087 p_attribute1 IN jtf_varchar2_table_300 := NULL,
1088 p_attribute2 IN jtf_varchar2_table_300 := NULL,
1089 p_attribute3 IN jtf_varchar2_table_300 := NULL,
1090 p_attribute4 IN jtf_varchar2_table_300 := NULL,
1091 p_attribute5 IN jtf_varchar2_table_300 := NULL,
1092 p_attribute6 IN jtf_varchar2_table_300 := NULL,
1093 p_attribute7 IN jtf_varchar2_table_300 := NULL,
1094 p_attribute8 IN jtf_varchar2_table_300 := NULL,
1095 p_attribute9 IN jtf_varchar2_table_300 := NULL,
1096 p_attribute10 IN jtf_varchar2_table_300 := NULL,
1097 p_attribute11 IN jtf_varchar2_table_300 := NULL,
1098 p_attribute12 IN jtf_varchar2_table_300 := NULL,
1099 p_attribute13 IN jtf_varchar2_table_300 := NULL,
1100 p_attribute14 IN jtf_varchar2_table_300 := NULL,
1101 p_attribute15 IN jtf_varchar2_table_300 := NULL,
1102 p_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
1103 p_change_sequence IN jtf_varchar2_table_100 := NULL,
1104 p_update_allowed IN jtf_varchar2_table_100 := NULL,
1105 p_change_reason_code IN jtf_varchar2_table_100 := NULL,
1106 p_change_reason_text IN jtf_varchar2_table_2000 := NULL,
1107 p_cost_id IN jtf_number_table := NULL,
1108 p_tax_code IN jtf_varchar2_table_100 := NULL,
1109 p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1110 p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1111 p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1112 p_parent_adjustment_id IN jtf_number_table := NULL,
1113 p_invoiced_flag IN jtf_varchar2_table_100 := NULL,
1114 p_estimated_flag IN jtf_varchar2_table_100 := NULL,
1115 p_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
1116 p_split_action_code IN jtf_varchar2_table_100 := NULL,
1117 p_adjusted_amount IN jtf_number_table := NULL,
1118 p_charge_type_code IN jtf_varchar2_table_100 := NULL,
1119 p_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1120 p_range_break_quantity IN jtf_number_table := NULL,
1121 p_accrual_conv_rate IN jtf_number_table := NULL,
1122 p_pricing_group_sequence IN jtf_number_table := NULL,
1123 p_accrual_flag IN jtf_varchar2_table_100 := NULL,
1124 p_list_line_no IN jtf_varchar2_table_300 := NULL,
1125 p_source_system_code IN jtf_varchar2_table_100 := NULL,
1126 p_benefit_qty IN jtf_number_table := NULL,
1127 p_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
1128 p_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1129 p_expiration_date IN jtf_date_table := NULL,
1130 p_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
1131 p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
1132 p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
1133 p_redeemed_date IN jtf_date_table := NULL,
1134 p_redeemed_flag IN jtf_varchar2_table_100 := NULL,
1135 p_modifier_level_code IN jtf_varchar2_table_100 := NULL,
1136 p_price_break_type_code IN jtf_varchar2_table_100 := NULL,
1137 p_substitution_attribute IN jtf_varchar2_table_100 := NULL,
1138 p_proration_type_code IN jtf_varchar2_table_100 := NULL,
1139 p_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1140 p_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1141 p_shipment_index IN jtf_number_table := NULL,
1142 p_quote_shipment_id IN jtf_number_table := NULL,
1143 p_attribute16 IN jtf_varchar2_table_300 := NULL,
1144 p_attribute17 IN jtf_varchar2_table_300 := NULL,
1145 p_attribute18 IN jtf_varchar2_table_300 := NULL,
1146 p_attribute19 IN jtf_varchar2_table_300 := NULL,
1147 p_attribute20 IN jtf_varchar2_table_300 := NULL,
1148 p_object_version_number IN jtf_number_table := NULL
1149 )
1150 RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type;
1151
1152 FUNCTION Construct_Sales_Credit_Tbl(
1153 p_operation_code IN jtf_varchar2_table_100 := NULL,
1154 p_qte_line_index IN jtf_number_table := NULL,
1155 p_sales_credit_id IN jtf_number_table := NULL,
1156 p_creation_date IN jtf_date_table := NULL,
1157 p_created_by IN jtf_number_table := NULL,
1158 p_last_updated_by IN jtf_varchar2_table_300 := NULL,
1159 p_last_update_date IN jtf_date_table := NULL,
1160 p_last_update_login IN jtf_number_table := NULL,
1161 p_request_id IN jtf_number_table := NULL,
1162 p_program_application_id IN jtf_number_table := NULL,
1163 p_program_id IN jtf_number_table := NULL,
1164 p_program_update_date IN jtf_date_table := NULL,
1165 p_quote_header_id IN jtf_number_table := NULL,
1166 p_quote_line_id IN jtf_number_table := NULL,
1167 p_percent IN jtf_number_table := NULL,
1168 p_resource_id IN jtf_number_table := NULL,
1169 p_first_name IN jtf_varchar2_table_300 := NULL,
1170 p_last_name IN jtf_varchar2_table_300 := NULL,
1171 p_sales_credit_type IN jtf_varchar2_table_300 := NULL,
1172 p_resource_group_id IN jtf_number_table := NULL,
1173 p_employee_person_id IN jtf_number_table := NULL,
1174 p_sales_credit_type_id IN jtf_number_table := NULL,
1175 p_attribute_category IN jtf_varchar2_table_100 := NULL,
1176 p_attribute1 IN jtf_varchar2_table_300 := NULL,
1177 p_attribute2 IN jtf_varchar2_table_300 := NULL,
1178 p_attribute3 IN jtf_varchar2_table_300 := NULL,
1179 p_attribute4 IN jtf_varchar2_table_300 := NULL,
1180 p_attribute5 IN jtf_varchar2_table_300 := NULL,
1181 p_attribute6 IN jtf_varchar2_table_300 := NULL,
1182 p_attribute7 IN jtf_varchar2_table_300 := NULL,
1183 p_attribute8 IN jtf_varchar2_table_300 := NULL,
1184 p_attribute9 IN jtf_varchar2_table_300 := NULL,
1185 p_attribute10 IN jtf_varchar2_table_300 := NULL,
1186 p_attribute11 IN jtf_varchar2_table_300 := NULL,
1187 p_attribute12 IN jtf_varchar2_table_300 := NULL,
1188 p_attribute13 IN jtf_varchar2_table_300 := NULL,
1189 p_attribute14 IN jtf_varchar2_table_300 := NULL,
1190 p_attribute15 IN jtf_varchar2_table_300 := NULL,
1191 p_system_assigned_flag IN jtf_varchar2_table_100 := NULL,
1192 p_credit_rule_id IN jtf_number_table := NULL,
1193 p_attribute16 IN jtf_varchar2_table_300 := NULL,
1194 p_attribute17 IN jtf_varchar2_table_300 := NULL,
1195 p_attribute18 IN jtf_varchar2_table_300 := NULL,
1196 p_attribute19 IN jtf_varchar2_table_300 := NULL,
1197 p_attribute20 IN jtf_varchar2_table_300 := NULL,
1198 p_object_version_number IN jtf_number_table := NULL
1199 )
1200 RETURN ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1201
1202 FUNCTION Construct_Opp_Qte_In_Rec(
1203 p_opportunity_id IN NUMBER := FND_API.G_MISS_NUM,
1204 p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
1205 p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1206 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1207 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1208 p_sold_to_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1209 p_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
1210 p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
1211 p_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
1212 p_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1213 p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
1214 p_agreement_id IN NUMBER := FND_API.G_MISS_NUM,
1215 p_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
1216 p_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
1217 p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1218 p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
1219 p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
1220 p_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
1221 p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1222 p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1223 p_price_updated_date IN DATE := FND_API.G_MISS_DATE,
1224 p_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
1225 p_org_id IN NUMBER := FND_API.G_MISS_NUM
1226 )
1227 RETURN ASO_Opp_Qte_Pub.Opp_Qte_In_Rec_Type;
1228
1229 FUNCTION Construct_Qte_Access_Tbl(
1230 p_access_id IN jtf_number_table := NULL,
1231 p_quote_number IN jtf_number_table := NULL,
1232 p_resource_id IN jtf_number_table := NULL,
1233 p_resource_grp_id IN jtf_number_table := NULL,
1234 p_created_by IN jtf_number_table := NULL,
1235 p_creation_date IN jtf_date_table := NULL,
1236 p_last_updated_by IN jtf_number_table := NULL,
1237 p_last_update_login IN jtf_number_table := NULL,
1238 p_last_update_date IN jtf_date_table := NULL,
1239 p_request_id IN jtf_number_table := NULL,
1240 p_program_application_id IN jtf_number_table := NULL,
1241 p_program_id IN jtf_number_table := NULL,
1242 p_program_update_date IN jtf_date_table := NULL,
1243 p_keep_flag IN jtf_varchar2_table_100 := NULL,
1244 p_update_access_flag IN jtf_varchar2_table_100 := NULL,
1245 p_created_by_tap_flag IN jtf_varchar2_table_100 := NULL,
1246 p_role_id IN jtf_number_table := NULL,
1247 p_territory_id IN jtf_number_table := NULL,
1248 p_territory_source_flag IN jtf_varchar2_table_100 := NULL,
1249 p_attribute_category IN jtf_varchar2_table_100 := NULL,
1250 p_attribute1 IN jtf_varchar2_table_300 := NULL,
1251 p_attribute2 IN jtf_varchar2_table_300 := NULL,
1252 p_attribute3 IN jtf_varchar2_table_300 := NULL,
1253 p_attribute4 IN jtf_varchar2_table_300 := NULL,
1254 p_attribute5 IN jtf_varchar2_table_300 := NULL,
1255 p_attribute6 IN jtf_varchar2_table_300 := NULL,
1256 p_attribute7 IN jtf_varchar2_table_300 := NULL,
1257 p_attribute8 IN jtf_varchar2_table_300 := NULL,
1258 p_attribute9 IN jtf_varchar2_table_300 := NULL,
1259 p_attribute10 IN jtf_varchar2_table_300 := NULL,
1260 p_attribute11 IN jtf_varchar2_table_300 := NULL,
1261 p_attribute12 IN jtf_varchar2_table_300 := NULL,
1262 p_attribute13 IN jtf_varchar2_table_300 := NULL,
1263 p_attribute14 IN jtf_varchar2_table_300 := NULL,
1264 p_attribute15 IN jtf_varchar2_table_300 := NULL,
1265 p_attribute16 IN jtf_varchar2_table_300 := NULL,
1266 p_attribute17 IN jtf_varchar2_table_300 := NULL,
1267 p_attribute18 IN jtf_varchar2_table_300 := NULL,
1268 p_attribute19 IN jtf_varchar2_table_300 := NULL,
1269 p_attribute20 IN jtf_varchar2_table_300 := NULL,
1270 p_object_version_number IN jtf_number_table := NULL,
1271 p_batch_price_flag IN jtf_varchar2_table_100 := NULL,
1272 p_operation_code IN jtf_varchar2_table_100 := NULL
1273 )
1274 RETURN ASO_QUOTE_PUB.Qte_Access_Tbl_Type;
1275
1276 FUNCTION Construct_Copy_Qte_Hdr_Rec(
1277 p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
1278 p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1279 p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
1280 p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1281 p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
1282 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1283 p_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
1284 p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1285 p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1286 p_price_updated_date IN DATE := FND_API.G_MISS_DATE,
1287 p_tax_updated_date IN DATE := FND_API.G_MISS_DATE
1288 )
1289 RETURN ASO_Copy_Quote_Pub.Copy_Quote_Header_Rec_Type;
1290
1291 FUNCTION Construct_Instance_Tbl(
1292 p_instance_id IN jtf_number_table := NULL,
1293 p_price_list_id IN jtf_number_table := NULL
1294 )
1295 RETURN ASO_Quote_Headers_PVT.Instance_Tbl_Type;
1296
1297 PROCEDURE Set_Control_Rec_W(
1298 p_last_update_date DATE := FND_API.G_MISS_DATE,
1299 p_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1300 p_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
1301 p_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
1302 p_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
1303 p_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1304 p_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1305 p_functionality_code VARCHAR2 := FND_API.G_MISS_CHAR,
1306 p_copy_task_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1307 p_copy_notes_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1308 p_copy_att_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1309 p_deactivate_all VARCHAR2 := FND_API.G_MISS_CHAR,
1310 p_price_mode VARCHAR2 := FND_API.G_MISS_CHAR,
1311 p_dependency_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1312 p_defaulting_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1313 p_defaulting_fwk_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1314 p_application_type_code VARCHAR2 := FND_API.G_MISS_CHAR,
1315 x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
1316 );
1317
1318 PROCEDURE Set_Submit_Control_Rec_W(
1319 p_book_flag IN VARCHAR2 := FND_API.G_FALSE,
1320 p_reserve_flag IN VARCHAR2 := FND_API.G_FALSE,
1321 p_calculate_price IN VARCHAR2 := FND_API.G_FALSE,
1322 p_server_id IN NUMBER := FND_API.G_MISS_NUM,
1323 x_Submit_control_rec OUT NOCOPY ASO_Quote_Pub.Submit_Control_Rec_Type
1324 );
1325
1326 PROCEDURE Set_Copy_Quote_Control_Rec_W(
1327 p_copy_header_only VARCHAR2 := FND_API.G_MISS_CHAR,
1328 p_new_version VARCHAR2 := FND_API.G_MISS_CHAR,
1329 p_copy_note VARCHAR2 := FND_API.G_MISS_CHAR,
1330 p_copy_task VARCHAR2 := FND_API.G_MISS_CHAR,
1331 p_copy_attachment VARCHAR2 := FND_API.G_MISS_CHAR,
1332 p_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
1333 p_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
1334 p_price_mode VARCHAR2 := FND_API.G_MISS_CHAR,
1335 p_calc_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1336 p_calculate_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1337 x_copy_quote_control_rec OUT NOCOPY ASO_Copy_Quote_Pub.Copy_Quote_Control_Rec_Type
1338 );
1339
1340 PROCEDURE Set_Order_Header_Rec_Out(
1341 p_order_header_rec IN ASO_Quote_Pub.Order_Header_Rec_Type,
1342 x_order_number OUT NOCOPY NUMBER ,
1343 x_order_header_id OUT NOCOPY NUMBER ,
1344 x_order_request_id OUT NOCOPY NUMBER ,
1345 x_contract_id OUT NOCOPY NUMBER ,
1346 x_status OUT NOCOPY VARCHAR2
1347 );
1348
1349 PROCEDURE Set_Qte_Header_Tbl_Out(
1350 p_qte_header_tbl IN ASO_Quote_Pub.Qte_Header_Tbl_Type,
1351 x_quote_header_id OUT NOCOPY jtf_number_table,
1352 x_last_update_date OUT NOCOPY jtf_date_table
1353
1354 /*-- The following output parameters are ignored
1355 x_creation_date OUT NOCOPY jtf_date_table,
1356 x_created_by OUT NOCOPY jtf_number_table,
1357 x_last_updated_by OUT NOCOPY jtf_number_table,
1358 x_last_update_login OUT NOCOPY jtf_number_table,
1359 x_request_id OUT NOCOPY jtf_number_table,
1360 x_program_application_id OUT NOCOPY jtf_number_table,
1361 x_program_id OUT NOCOPY jtf_number_table,
1362 x_program_update_date OUT NOCOPY jtf_date_table,
1363 x_org_id OUT NOCOPY jtf_number_table,
1364 x_quote_name OUT NOCOPY jtf_varchar2_table_100,
1365 x_quote_number OUT NOCOPY jtf_number_table,
1366 x_quote_version OUT NOCOPY jtf_number_table,
1367 x_quote_status_id OUT NOCOPY jtf_number_table,
1368 x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
1369 x_quote_expiration_date OUT NOCOPY jtf_date_table,
1370 x_price_frozen_date OUT NOCOPY jtf_date_table,
1371 x_quote_password OUT NOCOPY jtf_varchar2_table_300,
1372 x_original_system_reference OUT NOCOPY jtf_varchar2_table_300,
1373 x_party_id OUT NOCOPY jtf_number_table,
1374 x_cust_account_id OUT NOCOPY jtf_number_table,
1375 x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,
1376 x_org_contact_id OUT NOCOPY jtf_number_table,
1377 x_phone_id OUT NOCOPY jtf_number_table,
1378 x_invoice_to_party_site_id OUT NOCOPY jtf_number_table,
1379 x_invoice_to_party_id OUT NOCOPY jtf_number_table,
1380 x_orig_mktg_source_code_id OUT NOCOPY jtf_number_table,
1381 x_marketing_source_code_id OUT NOCOPY jtf_number_table,
1382 x_order_type_id OUT NOCOPY jtf_number_table,
1383 x_quote_category_code OUT NOCOPY jtf_varchar2_table_300,
1384 x_ordered_date OUT NOCOPY jtf_date_table,
1385 x_accounting_rule_id OUT NOCOPY jtf_number_table,
1386 x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1387 x_employee_person_id OUT NOCOPY jtf_number_table,
1388 x_price_list_id OUT NOCOPY jtf_number_table,
1389 x_currency_code OUT NOCOPY jtf_varchar2_table_100,
1390 x_total_list_price OUT NOCOPY jtf_number_table,
1391 x_total_adjusted_amount OUT NOCOPY jtf_number_table,
1392 x_total_adjusted_percent OUT NOCOPY jtf_number_table,
1393 x_total_tax OUT NOCOPY jtf_number_table,
1394 x_total_shipping_charge OUT NOCOPY jtf_number_table,
1395 x_surcharge OUT NOCOPY jtf_number_table,
1396 x_total_quote_price OUT NOCOPY jtf_number_table,
1397 x_payment_amount OUT NOCOPY jtf_number_table,
1398 x_exchange_rate OUT NOCOPY jtf_number_table,
1399 x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
1400 x_exchange_rate_date OUT NOCOPY jtf_date_table,
1401 x_contract_id OUT NOCOPY jtf_number_table,
1402 x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
1403 x_order_id OUT NOCOPY jtf_number_table,
1404 x_order_number OUT NOCOPY jtf_number_table,
1405 x_ffm_request_id OUT NOCOPY jtf_number_table,
1406 x_qte_contract_id OUT NOCOPY jtf_number_table,
1407 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1408 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1409 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1410 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1411 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1412 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1413 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1414 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1415 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1416 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1417 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1418 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1419 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1420 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1421 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1422 x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1423 x_salesrep_first_name OUT NOCOPY jtf_varchar2_table_300,
1424 x_salesrep_last_name OUT NOCOPY jtf_varchar2_table_300,
1425 x_price_list_name OUT NOCOPY jtf_varchar2_table_300,
1426 x_quote_status_code OUT NOCOPY jtf_varchar2_table_100,
1427 x_quote_status OUT NOCOPY jtf_varchar2_table_300,
1428 x_party_name OUT NOCOPY jtf_varchar2_table_300,
1429 x_party_type OUT NOCOPY jtf_varchar2_table_100,
1430 x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
1431 x_person_middle_name OUT NOCOPY jtf_varchar2_table_100,
1432 x_person_last_name OUT NOCOPY jtf_varchar2_table_200,
1433 x_marketing_source_name OUT NOCOPY jtf_varchar2_table_200,
1434 x_marketing_source_code OUT NOCOPY jtf_varchar2_table_200,
1435 x_order_type_name OUT NOCOPY jtf_varchar2_table_300,
1436 x_invoice_to_party_name OUT NOCOPY jtf_varchar2_table_300,
1437 x_invoice_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
1438 x_invoice_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
1439 x_invoice_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
1440 x_invoice_to_address1 OUT NOCOPY jtf_varchar2_table_300,
1441 x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1442 x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1443 x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1444 x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1445 x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1446 x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1447 x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1448 x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1449 x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1450 x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
1451 x_resource_id OUT NOCOPY jtf_number_table
1452 --*/
1453 );
1454
1455 PROCEDURE Set_Qte_Line_Tbl_Out(
1456 p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,
1457 x_quote_line_id OUT NOCOPY jtf_number_table
1458
1459 /*-- The following output parameters are ignored
1460 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1461 x_creation_date OUT NOCOPY jtf_date_table,
1462 x_created_by OUT NOCOPY jtf_number_table,
1463 x_last_update_date OUT NOCOPY jtf_date_table,
1464 x_last_updated_by OUT NOCOPY jtf_number_table,
1465 x_last_update_login OUT NOCOPY jtf_number_table,
1466 x_request_id OUT NOCOPY jtf_number_table,
1467 x_program_application_id OUT NOCOPY jtf_number_table,
1468 x_program_id OUT NOCOPY jtf_number_table,
1469 x_program_update_date OUT NOCOPY jtf_date_table,
1470 x_quote_header_id OUT NOCOPY jtf_number_table,
1471 x_org_id OUT NOCOPY jtf_number_table,
1472 x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
1473 x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
1474 x_line_number OUT NOCOPY jtf_number_table,
1475 x_start_date_active OUT NOCOPY jtf_date_table,
1476 x_end_date_active OUT NOCOPY jtf_date_table,
1477 x_order_line_type_id OUT NOCOPY jtf_number_table,
1478 x_invoice_to_party_site_id OUT NOCOPY jtf_number_table,
1479 x_invoice_to_party_id OUT NOCOPY jtf_number_table,
1480 x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,
1481 x_organization_id OUT NOCOPY jtf_number_table,
1482 x_inventory_item_id OUT NOCOPY jtf_number_table,
1483 x_quantity OUT NOCOPY jtf_number_table,
1484 x_uom_code OUT NOCOPY jtf_varchar2_table_100,
1485 x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
1486 x_marketing_source_code_id OUT NOCOPY jtf_number_table,
1487 x_price_list_id OUT NOCOPY jtf_number_table,
1488 x_price_list_line_id OUT NOCOPY jtf_number_table,
1489 x_currency_code OUT NOCOPY jtf_varchar2_table_100,
1490 x_line_list_price OUT NOCOPY jtf_number_table,
1491 x_line_adjusted_amount OUT NOCOPY jtf_number_table,
1492 x_line_adjusted_percent OUT NOCOPY jtf_number_table,
1493 x_line_quote_price OUT NOCOPY jtf_number_table,
1494 x_related_item_id OUT NOCOPY jtf_number_table,
1495 x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
1496 x_accounting_rule_id OUT NOCOPY jtf_number_table,
1497 x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1498 x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
1499 x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
1500 x_minisite_id OUT NOCOPY jtf_number_table,
1501 x_section_id OUT NOCOPY jtf_number_table,
1502 x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
1503 x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
1504 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1505 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1506 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1507 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1508 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1509 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1510 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1511 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1512 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1513 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1514 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1515 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1516 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1517 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1518 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1519 x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1520 x_ffm_content_name OUT NOCOPY jtf_varchar2_table_300,
1521 x_ffm_document_type OUT NOCOPY jtf_varchar2_table_300,
1522 x_ffm_media_type OUT NOCOPY jtf_varchar2_table_300,
1523 x_ffm_media_id OUT NOCOPY jtf_varchar2_table_300,
1524 x_ffm_content_type OUT NOCOPY jtf_varchar2_table_300,
1525 x_ffm_user_note OUT NOCOPY jtf_varchar2_table_300
1526 --*/
1527 );
1528
1529 PROCEDURE Set_Qte_Line_Dtl_Tbl_Out(
1530 p_qte_line_dtl_tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
1531 x_quote_line_detail_id OUT NOCOPY jtf_number_table
1532
1533 /*-- The following output parameters are ignored
1534 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1535 x_qte_line_index OUT NOCOPY jtf_number_table,
1536 x_creation_date OUT NOCOPY jtf_date_table,
1537 x_created_by OUT NOCOPY jtf_number_table,
1538 x_last_update_date OUT NOCOPY jtf_date_table,
1539 x_last_updated_by OUT NOCOPY jtf_number_table,
1540 x_last_update_login OUT NOCOPY jtf_number_table,
1541 x_request_id OUT NOCOPY jtf_number_table,
1542 x_program_application_id OUT NOCOPY jtf_number_table,
1543 x_program_id OUT NOCOPY jtf_number_table,
1544 x_program_update_date OUT NOCOPY jtf_date_table,
1545 x_quote_line_id OUT NOCOPY jtf_number_table,
1546 x_config_header_id OUT NOCOPY jtf_number_table,
1547 x_config_revision_num OUT NOCOPY jtf_number_table,
1548 x_config_item_id OUT NOCOPY jtf_number_table,
1549 x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
1550 x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
1551 x_component_code OUT NOCOPY jtf_varchar2_table_1200,
1552 x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
1553 x_service_duration OUT NOCOPY jtf_number_table,
1554 x_service_period OUT NOCOPY jtf_varchar2_table_100,
1555 x_service_unit_selling OUT NOCOPY jtf_number_table,
1556 x_service_unit_list OUT NOCOPY jtf_number_table,
1557 x_service_number OUT NOCOPY jtf_number_table,
1558 x_unit_percent_base_price OUT NOCOPY jtf_number_table,
1559 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1560 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1561 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1562 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1563 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1564 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1565 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1566 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1567 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1568 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1569 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1570 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1571 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1572 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1573 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1574 x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1575 x_service_ref_type_code OUT NOCOPY jtf_varchar2_table_100,
1576 x_service_ref_order_number OUT NOCOPY jtf_number_table,
1577 x_service_ref_line_number OUT NOCOPY jtf_number_table,
1578 x_service_ref_qte_line_ind OUT NOCOPY jtf_number_table,
1579 x_service_ref_line_id OUT NOCOPY jtf_number_table,
1580 x_service_ref_system_id OUT NOCOPY jtf_number_table,
1581 x_service_ref_option_numb OUT NOCOPY jtf_number_table,
1582 x_service_ref_shipment OUT NOCOPY jtf_number_table,
1583 x_return_ref_type OUT NOCOPY jtf_varchar2_table_100,
1584 x_return_ref_header_id OUT NOCOPY jtf_number_table,
1585 x_return_ref_line_id OUT NOCOPY jtf_number_table,
1586 x_return_attribute1 OUT NOCOPY jtf_varchar2_table_300,
1587 x_return_attribute2 OUT NOCOPY jtf_varchar2_table_300,
1588 x_return_attribute3 OUT NOCOPY jtf_varchar2_table_300,
1589 x_return_attribute4 OUT NOCOPY jtf_varchar2_table_300,
1590 x_return_attribute5 OUT NOCOPY jtf_varchar2_table_300,
1591 x_return_attribute6 OUT NOCOPY jtf_varchar2_table_300,
1592 x_return_attribute7 OUT NOCOPY jtf_varchar2_table_300,
1593 x_return_attribute8 OUT NOCOPY jtf_varchar2_table_300,
1594 x_return_attribute9 OUT NOCOPY jtf_varchar2_table_300,
1595 x_return_attribute10 OUT NOCOPY jtf_varchar2_table_300,
1596 x_return_attribute11 OUT NOCOPY jtf_varchar2_table_300,
1597 x_return_attribute15 OUT NOCOPY jtf_varchar2_table_300,
1598 x_return_attribute12 OUT NOCOPY jtf_varchar2_table_300,
1599 x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
1600 x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
1601 x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
1602 x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
1603 x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
1604 --*/
1605 );
1606
1607 PROCEDURE Set_Line_Rltship_Tbl_Out(
1608 p_qte_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type,
1609 x_line_relationship_id OUT NOCOPY jtf_number_table
1610
1611 /*-- The following output parameters are ignored
1612 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1613 x_creation_date OUT NOCOPY jtf_date_table,
1614 x_created_by OUT NOCOPY jtf_number_table,
1615 x_last_update_date OUT NOCOPY jtf_date_table,
1616 x_last_updated_by OUT NOCOPY jtf_number_table,
1617 x_last_update_login OUT NOCOPY jtf_number_table,
1618 x_request_id OUT NOCOPY jtf_number_table,
1619 x_program_application_id OUT NOCOPY jtf_number_table,
1620 x_program_id OUT NOCOPY jtf_number_table,
1621 x_program_update_date OUT NOCOPY jtf_date_table,
1622 x_quote_line_id OUT NOCOPY jtf_number_table,
1623 x_qte_line_index OUT NOCOPY jtf_number_table,
1624 x_related_quote_line_id OUT NOCOPY jtf_number_table,
1625 x_related_qte_line_index OUT NOCOPY jtf_number_table,
1626 x_relationship_type_code OUT NOCOPY jtf_varchar2_table_100,
1627 x_reciprocal_flag OUT NOCOPY jtf_varchar2_table_100
1628 --*/
1629 );
1630
1631 PROCEDURE Set_Payment_Tbl_Out(
1632 p_qte_payment_tbl IN ASO_Quote_Pub.Payment_Tbl_Type,
1633 x_payment_id OUT NOCOPY jtf_number_table
1634
1635 /*-- The following output parameters are ignored
1636 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1637 x_qte_line_index OUT NOCOPY jtf_number_table,
1638 x_shipment_index OUT NOCOPY jtf_number_table,
1639 x_creation_date OUT NOCOPY jtf_date_table,
1640 x_created_by OUT NOCOPY jtf_number_table,
1641 x_last_update_date OUT NOCOPY jtf_date_table,
1642 x_last_updated_by OUT NOCOPY jtf_number_table,
1643 x_last_update_login OUT NOCOPY jtf_number_table,
1644 x_request_id OUT NOCOPY jtf_number_table,
1645 x_program_application_id OUT NOCOPY jtf_number_table,
1646 x_program_id OUT NOCOPY jtf_number_table,
1647 x_program_update_date OUT NOCOPY jtf_date_table,
1648 x_quote_header_id OUT NOCOPY jtf_number_table,
1649 x_quote_line_id OUT NOCOPY jtf_number_table,
1650 x_quote_shipment_id OUT NOCOPY jtf_number_table,
1651 x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,
1652 x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
1653 x_payment_option OUT NOCOPY jtf_varchar2_table_300,
1654 x_payment_term_id OUT NOCOPY jtf_number_table,
1655 x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
1656 x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
1657 x_credit_card_exp_date OUT NOCOPY jtf_date_table,
1658 x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
1659 x_credit_card_approval_date OUT NOCOPY jtf_date_table,
1660 x_payment_amount OUT NOCOPY jtf_number_table,
1661 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1662 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1663 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1664 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1665 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1666 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1667 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1668 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1669 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1670 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1671 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1672 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1673 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1674 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1675 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1676 x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1677 x_cust_po_number OUT NOCOPY jtf_varchar2_table_100
1678 --*/
1679 );
1680
1681 PROCEDURE Set_Shipment_Tbl_Out(
1682 p_qte_shipment_tbl IN ASO_Quote_Pub.Shipment_Tbl_Type,
1683 x_shipment_id OUT NOCOPY jtf_number_table
1684
1685 /*-- The following output parameters are ignored
1686 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1687 x_qte_line_index OUT NOCOPY jtf_number_table,
1688 x_creation_date OUT NOCOPY jtf_date_table,
1689 x_created_by OUT NOCOPY jtf_number_table,
1690 x_last_update_date OUT NOCOPY jtf_date_table,
1691 x_last_updated_by OUT NOCOPY jtf_number_table,
1692 x_last_update_login OUT NOCOPY jtf_number_table,
1693 x_request_id OUT NOCOPY jtf_number_table,
1694 x_program_application_id OUT NOCOPY jtf_number_table,
1695 x_program_id OUT NOCOPY jtf_number_table,
1696 x_program_update_date OUT NOCOPY jtf_date_table,
1697 x_quote_header_id OUT NOCOPY jtf_number_table,
1698 x_quote_line_id OUT NOCOPY jtf_number_table,
1699 x_promise_date OUT NOCOPY jtf_date_table,
1700 x_request_date OUT NOCOPY jtf_date_table,
1701 x_schedule_ship_date OUT NOCOPY jtf_date_table,
1702 x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
1703 x_ship_to_party_id OUT NOCOPY jtf_number_table,
1704 x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
1705 x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
1706 x_ship_set_id OUT NOCOPY jtf_number_table,
1707 x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
1708 x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
1709 x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
1710 x_fob_code OUT NOCOPY jtf_varchar2_table_100,
1711 x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
1712 x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
1713 x_ship_quote_price OUT NOCOPY jtf_number_table,
1714 x_quantity OUT NOCOPY jtf_number_table,
1715 x_pricing_quantity OUT NOCOPY jtf_number_table,
1716 x_reserved_quantity OUT NOCOPY jtf_varchar2_table_300,
1717 x_reservation_id OUT NOCOPY jtf_number_table,
1718 x_order_line_id OUT NOCOPY jtf_number_table,
1719 x_ship_to_party_name OUT NOCOPY jtf_varchar2_table_300,
1720 x_ship_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
1721 x_ship_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
1722 x_ship_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
1723 x_ship_to_address1 OUT NOCOPY jtf_varchar2_table_300,
1724 x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1725 x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1726 x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1727 x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1728 x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1729 x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1730 x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1731 x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1732 x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1733 x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1734 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1735 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1736 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1737 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1738 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1739 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1740 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1741 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1742 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1743 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1744 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1745 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1746 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1747 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1748 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1749 x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1750 x_shipment_priority_code OUT NOCOPY jtf_varchar2_table_100,
1751 x_ship_from_org_id OUT NOCOPY jtf_number_table
1752 --*/
1753 );
1754
1755 PROCEDURE Set_Tax_Detail_Tbl_Out(
1756 p_qte_tax_detail_tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type,
1757 x_tax_detail_id OUT NOCOPY jtf_number_table
1758
1759 /*-- The following output parameters are ignored
1760 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1761 x_qte_line_index OUT NOCOPY jtf_number_table,
1762 x_shipment_index OUT NOCOPY jtf_number_table,
1763 x_quote_header_id OUT NOCOPY jtf_number_table,
1764 x_quote_line_id OUT NOCOPY jtf_number_table,
1765 x_quote_shipment_id OUT NOCOPY jtf_number_table,
1766 x_creation_date OUT NOCOPY jtf_date_table,
1767 x_created_by OUT NOCOPY jtf_number_table,
1768 x_last_update_date OUT NOCOPY jtf_date_table,
1769 x_last_updated_by OUT NOCOPY jtf_number_table,
1770 x_last_update_login OUT NOCOPY jtf_number_table,
1771 x_request_id OUT NOCOPY jtf_number_table,
1772 x_program_application_id OUT NOCOPY jtf_number_table,
1773 x_program_id OUT NOCOPY jtf_number_table,
1774 x_program_update_date OUT NOCOPY jtf_date_table,
1775 x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
1776 x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1777 x_tax_rate OUT NOCOPY jtf_number_table,
1778 x_tax_date OUT NOCOPY jtf_date_table,
1779 x_tax_amount OUT NOCOPY jtf_number_table,
1780 x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1781 x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1782 x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1783 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1784 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1785 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1786 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1787 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1788 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1789 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1790 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1791 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1792 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1793 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1794 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1795 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1796 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1797 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1798 x_attribute15 OUT NOCOPY jtf_varchar2_table_200
1799 --*/
1800 );
1801
1802 PROCEDURE Set_Price_Adj_Tbl_Out(
1803 p_qte_price_adj_tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type,
1804 x_price_adjustment_id OUT NOCOPY jtf_number_table
1805
1806 /*-- The following output parameters are ignored
1807 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1808 x_qte_line_index OUT NOCOPY jtf_number_table,
1809 x_shipment_index OUT NOCOPY jtf_number_table,
1810 x_creation_date OUT NOCOPY jtf_date_table,
1811 x_created_by OUT NOCOPY jtf_number_table,
1812 x_last_update_date OUT NOCOPY jtf_date_table,
1813 x_last_updated_by OUT NOCOPY jtf_number_table,
1814 x_last_update_login OUT NOCOPY jtf_number_table,
1815 x_program_application_id OUT NOCOPY jtf_number_table,
1816 x_program_id OUT NOCOPY jtf_number_table,
1817 x_program_update_date OUT NOCOPY jtf_date_table,
1818 x_request_id OUT NOCOPY jtf_number_table,
1819 x_quote_header_id OUT NOCOPY jtf_number_table,
1820 x_quote_line_id OUT NOCOPY jtf_number_table,
1821 x_quote_shipment_id OUT NOCOPY jtf_number_table,
1822 x_modifier_header_id OUT NOCOPY jtf_number_table,
1823 x_modifier_line_id OUT NOCOPY jtf_number_table,
1824 x_modifier_line_type_code OUT NOCOPY jtf_varchar2_table_100,
1825 x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
1826 x_modified_from OUT NOCOPY jtf_number_table,
1827 x_modified_to OUT NOCOPY jtf_number_table,
1828 x_operand OUT NOCOPY jtf_number_table,
1829 x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1830 x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1831 x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1832 x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1833 x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1834 x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1835 x_pricing_phase_id OUT NOCOPY jtf_number_table,
1836 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1837 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1838 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1839 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1840 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1841 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1842 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1843 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1844 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1845 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1846 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1847 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1848 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1849 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1850 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1851 x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1852 x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
1853 x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
1854 x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
1855 x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1856 x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1857 x_cost_id OUT NOCOPY jtf_number_table,
1858 x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1859 x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1860 x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1861 x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1862 x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1863 x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1864 x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1865 x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1866 x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1867 x_adjusted_amount OUT NOCOPY jtf_number_table,
1868 x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
1869 x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
1870 x_range_break_quantity OUT NOCOPY jtf_number_table,
1871 x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
1872 x_pricing_group_sequence OUT NOCOPY jtf_number_table,
1873 x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
1874 x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
1875 x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
1876 x_benefit_qty OUT NOCOPY jtf_number_table,
1877 x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1878 x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1879 x_expiration_date OUT NOCOPY jtf_date_table,
1880 x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1881 x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1882 x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1883 x_redeemed_date OUT NOCOPY jtf_date_table,
1884 x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1885 x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1886 x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1887 x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1888 x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1889 x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1890 x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
1891 --*/
1892 );
1893
1894 PROCEDURE Set_Price_Attributes_Tbl_Out(
1895 p_qte_price_attributes_tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type,
1896 x_price_attribute_id OUT NOCOPY jtf_number_table
1897
1898 /*-- The following output parameters are ignored
1899 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1900 x_qte_line_index OUT NOCOPY jtf_number_table,
1901 x_creation_date OUT NOCOPY jtf_date_table,
1902 x_created_by OUT NOCOPY jtf_number_table,
1903 x_last_update_date OUT NOCOPY jtf_date_table,
1904 x_last_updated_by OUT NOCOPY jtf_number_table,
1905 x_last_update_login OUT NOCOPY jtf_number_table,
1906 x_request_id OUT NOCOPY jtf_number_table,
1907 x_program_application_id OUT NOCOPY jtf_number_table,
1908 x_program_id OUT NOCOPY jtf_number_table,
1909 x_program_update_date OUT NOCOPY jtf_date_table,
1910 x_quote_header_id OUT NOCOPY jtf_number_table,
1911 x_quote_line_id OUT NOCOPY jtf_number_table,
1912 x_flex_title OUT NOCOPY jtf_varchar2_table_100,
1913 x_pricing_context OUT NOCOPY jtf_varchar2_table_100,
1914 x_pricing_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1915 x_pricing_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1916 x_pricing_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1917 x_pricing_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1918 x_pricing_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1919 x_pricing_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1920 x_pricing_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1921 x_pricing_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1922 x_pricing_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1923 x_pricing_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1924 x_pricing_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1925 x_pricing_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1926 x_pricing_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1927 x_pricing_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1928 x_pricing_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1929 x_pricing_attribute16 OUT NOCOPY jtf_varchar2_table_200,
1930 x_pricing_attribute17 OUT NOCOPY jtf_varchar2_table_200,
1931 x_pricing_attribute18 OUT NOCOPY jtf_varchar2_table_200,
1932 x_pricing_attribute19 OUT NOCOPY jtf_varchar2_table_200,
1933 x_pricing_attribute20 OUT NOCOPY jtf_varchar2_table_200,
1934 x_pricing_attribute21 OUT NOCOPY jtf_varchar2_table_200,
1935 x_pricing_attribute22 OUT NOCOPY jtf_varchar2_table_200,
1936 x_pricing_attribute23 OUT NOCOPY jtf_varchar2_table_200,
1937 x_pricing_attribute24 OUT NOCOPY jtf_varchar2_table_200,
1938 x_pricing_attribute25 OUT NOCOPY jtf_varchar2_table_200,
1939 x_pricing_attribute26 OUT NOCOPY jtf_varchar2_table_200,
1940 x_pricing_attribute27 OUT NOCOPY jtf_varchar2_table_200,
1941 x_pricing_attribute28 OUT NOCOPY jtf_varchar2_table_200,
1942 x_pricing_attribute29 OUT NOCOPY jtf_varchar2_table_200,
1943 x_pricing_attribute30 OUT NOCOPY jtf_varchar2_table_200,
1944 x_pricing_attribute31 OUT NOCOPY jtf_varchar2_table_200,
1945 x_pricing_attribute32 OUT NOCOPY jtf_varchar2_table_200,
1946 x_pricing_attribute33 OUT NOCOPY jtf_varchar2_table_200,
1947 x_pricing_attribute34 OUT NOCOPY jtf_varchar2_table_200,
1948 x_pricing_attribute35 OUT NOCOPY jtf_varchar2_table_200,
1949 x_pricing_attribute36 OUT NOCOPY jtf_varchar2_table_200,
1950 x_pricing_attribute37 OUT NOCOPY jtf_varchar2_table_200,
1951 x_pricing_attribute38 OUT NOCOPY jtf_varchar2_table_200,
1952 x_pricing_attribute39 OUT NOCOPY jtf_varchar2_table_200,
1953 x_pricing_attribute40 OUT NOCOPY jtf_varchar2_table_200,
1954 x_pricing_attribute41 OUT NOCOPY jtf_varchar2_table_200,
1955 x_pricing_attribute42 OUT NOCOPY jtf_varchar2_table_200,
1956 x_pricing_attribute43 OUT NOCOPY jtf_varchar2_table_200,
1957 x_pricing_attribute44 OUT NOCOPY jtf_varchar2_table_200,
1958 x_pricing_attribute45 OUT NOCOPY jtf_varchar2_table_200,
1959 x_pricing_attribute46 OUT NOCOPY jtf_varchar2_table_200,
1960 x_pricing_attribute47 OUT NOCOPY jtf_varchar2_table_200,
1961 x_pricing_attribute48 OUT NOCOPY jtf_varchar2_table_200,
1962 x_pricing_attribute49 OUT NOCOPY jtf_varchar2_table_200,
1963 x_pricing_attribute50 OUT NOCOPY jtf_varchar2_table_200,
1964 x_pricing_attribute51 OUT NOCOPY jtf_varchar2_table_200,
1965 x_pricing_attribute52 OUT NOCOPY jtf_varchar2_table_200,
1966 x_pricing_attribute53 OUT NOCOPY jtf_varchar2_table_200,
1967 x_pricing_attribute54 OUT NOCOPY jtf_varchar2_table_200,
1968 x_pricing_attribute55 OUT NOCOPY jtf_varchar2_table_200,
1969 x_pricing_attribute56 OUT NOCOPY jtf_varchar2_table_200,
1970 x_pricing_attribute57 OUT NOCOPY jtf_varchar2_table_200,
1971 x_pricing_attribute58 OUT NOCOPY jtf_varchar2_table_200,
1972 x_pricing_attribute59 OUT NOCOPY jtf_varchar2_table_200,
1973 x_pricing_attribute60 OUT NOCOPY jtf_varchar2_table_200,
1974 x_pricing_attribute61 OUT NOCOPY jtf_varchar2_table_200,
1975 x_pricing_attribute62 OUT NOCOPY jtf_varchar2_table_200,
1976 x_pricing_attribute63 OUT NOCOPY jtf_varchar2_table_200,
1977 x_pricing_attribute64 OUT NOCOPY jtf_varchar2_table_200,
1978 x_pricing_attribute65 OUT NOCOPY jtf_varchar2_table_200,
1979 x_pricing_attribute66 OUT NOCOPY jtf_varchar2_table_200,
1980 x_pricing_attribute67 OUT NOCOPY jtf_varchar2_table_200,
1981 x_pricing_attribute68 OUT NOCOPY jtf_varchar2_table_200,
1982 x_pricing_attribute69 OUT NOCOPY jtf_varchar2_table_200,
1983 x_pricing_attribute70 OUT NOCOPY jtf_varchar2_table_200,
1984 x_pricing_attribute71 OUT NOCOPY jtf_varchar2_table_200,
1985 x_pricing_attribute72 OUT NOCOPY jtf_varchar2_table_200,
1986 x_pricing_attribute73 OUT NOCOPY jtf_varchar2_table_200,
1987 x_pricing_attribute74 OUT NOCOPY jtf_varchar2_table_200,
1988 x_pricing_attribute75 OUT NOCOPY jtf_varchar2_table_200,
1989 x_pricing_attribute76 OUT NOCOPY jtf_varchar2_table_200,
1990 x_pricing_attribute77 OUT NOCOPY jtf_varchar2_table_200,
1991 x_pricing_attribute78 OUT NOCOPY jtf_varchar2_table_200,
1992 x_pricing_attribute79 OUT NOCOPY jtf_varchar2_table_200,
1993 x_pricing_attribute80 OUT NOCOPY jtf_varchar2_table_200,
1994 x_pricing_attribute81 OUT NOCOPY jtf_varchar2_table_200,
1995 x_pricing_attribute82 OUT NOCOPY jtf_varchar2_table_200,
1996 x_pricing_attribute83 OUT NOCOPY jtf_varchar2_table_200,
1997 x_pricing_attribute84 OUT NOCOPY jtf_varchar2_table_200,
1998 x_pricing_attribute85 OUT NOCOPY jtf_varchar2_table_200,
1999 x_pricing_attribute86 OUT NOCOPY jtf_varchar2_table_200,
2000 x_pricing_attribute87 OUT NOCOPY jtf_varchar2_table_200,
2001 x_pricing_attribute88 OUT NOCOPY jtf_varchar2_table_200,
2002 x_pricing_attribute89 OUT NOCOPY jtf_varchar2_table_200,
2003 x_pricing_attribute90 OUT NOCOPY jtf_varchar2_table_200,
2004 x_pricing_attribute91 OUT NOCOPY jtf_varchar2_table_200,
2005 x_pricing_attribute92 OUT NOCOPY jtf_varchar2_table_200,
2006 x_pricing_attribute93 OUT NOCOPY jtf_varchar2_table_200,
2007 x_pricing_attribute94 OUT NOCOPY jtf_varchar2_table_200,
2008 x_pricing_attribute95 OUT NOCOPY jtf_varchar2_table_200,
2009 x_pricing_attribute96 OUT NOCOPY jtf_varchar2_table_200,
2010 x_pricing_attribute97 OUT NOCOPY jtf_varchar2_table_200,
2011 x_pricing_attribute98 OUT NOCOPY jtf_varchar2_table_200,
2012 x_pricing_attribute99 OUT NOCOPY jtf_varchar2_table_200,
2013 x_pricing_attribute100 OUT NOCOPY jtf_varchar2_table_200,
2014 x_context OUT NOCOPY jtf_varchar2_table_100,
2015 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
2016 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
2017 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
2018 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
2019 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
2020 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
2021 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
2022 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
2023 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
2024 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
2025 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
2026 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
2027 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
2028 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
2029 x_attribute15 OUT NOCOPY jtf_varchar2_table_200
2030 --*/
2031 );
2032
2033 PROCEDURE Set_Sales_Credit_Tbl_Out(
2034 p_qte_sales_credit_tbl IN ASO_Quote_Pub.Sales_Credit_Tbl_Type,
2035 x_sales_credit_id OUT NOCOPY jtf_number_table
2036
2037 /*-- The following output parameters are ignored
2038 x_qte_line_index OUT NOCOPY jtf_number_table,
2039 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
2040 x_creation_date OUT NOCOPY jtf_date_table,
2041 x_created_by OUT NOCOPY jtf_number_table,
2042 x_last_updated_by OUT NOCOPY jtf_number_table,
2043 x_last_update_date OUT NOCOPY jtf_date_table,
2044 x_last_update_login OUT NOCOPY jtf_number_table,
2045 x_request_id OUT NOCOPY jtf_number_table,
2046 x_program_application_id OUT NOCOPY jtf_number_table,
2047 x_program_id OUT NOCOPY jtf_number_table,
2048 x_program_update_date OUT NOCOPY jtf_date_table,
2049 x_quote_header_id OUT NOCOPY jtf_number_table,
2050 x_quote_line_id OUT NOCOPY jtf_number_table,
2051 x_percent OUT NOCOPY jtf_number_table,
2052 x_resource_id OUT NOCOPY jtf_number_table,
2053 x_first_name OUT NOCOPY jtf_varchar2_table_300,
2054 x_last_name OUT NOCOPY jtf_varchar2_table_300,
2055 x_sales_credit_type OUT NOCOPY jtf_varchar2_table_300,
2056 x_resource_group_id OUT NOCOPY jtf_number_table,
2057 x_employee_person_id OUT NOCOPY jtf_number_table,
2058 x_sales_credit_type_id OUT NOCOPY jtf_number_table,
2059 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
2060 x_attribute1 OUT NOCOPY jtf_varchar2_table_300,
2061 x_attribute2 OUT NOCOPY jtf_varchar2_table_300,
2062 x_attribute3 OUT NOCOPY jtf_varchar2_table_300,
2063 x_attribute4 OUT NOCOPY jtf_varchar2_table_300,
2064 x_attribute5 OUT NOCOPY jtf_varchar2_table_300,
2065 x_attribute6 OUT NOCOPY jtf_varchar2_table_300,
2066 x_attribute7 OUT NOCOPY jtf_varchar2_table_300,
2067 x_attribute8 OUT NOCOPY jtf_varchar2_table_300,
2068 x_attribute9 OUT NOCOPY jtf_varchar2_table_300,
2069 x_attribute10 OUT NOCOPY jtf_varchar2_table_300,
2070 x_attribute11 OUT NOCOPY jtf_varchar2_table_300,
2071 x_attribute12 OUT NOCOPY jtf_varchar2_table_300,
2072 x_attribute13 OUT NOCOPY jtf_varchar2_table_300,
2073 x_attribute14 OUT NOCOPY jtf_varchar2_table_300,
2074 x_attribute15 OUT NOCOPY jtf_varchar2_table_300
2075 --*/
2076 );
2077
2078 PROCEDURE Set_Approvers_List_Tbl_Out(
2079 p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,
2080 x_approval_det_id OUT NOCOPY jtf_number_table,
2081 x_object_approval_id OUT NOCOPY jtf_number_table,
2082 x_approver_person_id OUT NOCOPY jtf_number_table,
2083 x_approver_user_id OUT NOCOPY jtf_number_table,
2084 x_notification_id OUT NOCOPY jtf_number_table,
2085 x_approver_sequence OUT NOCOPY jtf_number_table,
2086 x_approver_status OUT NOCOPY jtf_varchar2_table_100,
2087 x_approver_name OUT NOCOPY jtf_varchar2_table_100,
2088 x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
2089 x_date_sent OUT NOCOPY jtf_date_table,
2090 x_date_received OUT NOCOPY jtf_date_table
2091 );
2092
2093 PROCEDURE Set_Rules_List_Tbl_Out(
2094 p_qte_rules_list_tbl IN ASO_Apr_Pub.Rules_List_Tbl_Type,
2095 x_rule_id OUT NOCOPY jtf_number_table,
2096 x_object_approval_id OUT NOCOPY jtf_number_table,
2097 x_rule_action_id OUT NOCOPY jtf_number_table,
2098 x_rule_description OUT NOCOPY jtf_varchar2_table_300,
2099 x_approval_level OUT NOCOPY jtf_varchar2_table_300
2100 );
2101
2102 PROCEDURE Set_Opp_Qte_Out_Rec_Out(
2103 p_opp_qte_out_rec IN ASO_Opp_Qte_Pub.Opp_Qte_Out_Rec_Type,
2104 x_quote_header_id OUT NOCOPY NUMBER ,
2105 x_quote_number OUT NOCOPY NUMBER ,
2106 x_related_object_id OUT NOCOPY NUMBER ,
2107 x_cust_account_id OUT NOCOPY NUMBER ,
2108 x_party_id OUT NOCOPY NUMBER ,
2109 x_currency_code OUT NOCOPY VARCHAR2
2110 );
2111
2112 PROCEDURE Set_Qte_Access_Tbl_Out(
2113 p_qte_access_tbl IN ASO_Quote_Pub.Qte_Access_Tbl_Type,
2114 x_access_id OUT NOCOPY jtf_number_table
2115 );
2116
2117 PROCEDURE Set_Template_Tbl_Out(
2118 p_template_tbl IN ASO_Quote_Pub.Template_Tbl_Type,
2119 x_template_id OUT NOCOPY jtf_number_table
2120 );
2121
2122 PROCEDURE Set_Atp_Tbl_Out (
2123 p_atp_tbl IN ASO_ATP_INT.Atp_Tbl_Typ,
2124 x_inventory_item_id OUT NOCOPY JTF_NUMBER_TABLE,
2125 x_inventory_item_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
2126 x_inventory_item_description OUT NOCOPY JTF_VARCHAR2_TABLE_300,
2127 x_padded_concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_300,
2128 x_source_organization_id OUT NOCOPY JTF_NUMBER_TABLE,
2129 x_source_organization_code OUT NOCOPY JTF_VARCHAR2_TABLE_300,
2130 x_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
2131 x_identifier OUT NOCOPY JTF_NUMBER_TABLE,
2132 x_customer_id OUT NOCOPY JTF_NUMBER_TABLE,
2133 x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
2134 x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
2135 x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2136 x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2137 x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
2138 x_ship_date OUT NOCOPY JTF_DATE_TABLE,
2139 x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2140 x_request_date_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2141 x_error_code OUT NOCOPY JTF_NUMBER_TABLE,
2142 x_message OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2143 x_request_date_type OUT NOCOPY jtf_varchar2_table_300,
2144 x_request_date_type_meaning OUT NOCOPY jtf_varchar2_table_300,
2145 x_demand_class_code OUT NOCOPY jtf_varchar2_table_300,
2146 x_demand_class_meaning OUT NOCOPY jtf_varchar2_table_300,
2147 x_ship_set_name OUT NOCOPY jtf_varchar2_table_300,
2148 x_arrival_set_name OUT NOCOPY jtf_varchar2_table_300,
2149 x_line_number OUT NOCOPY jtf_varchar2_table_800,
2150 x_group_ship_date OUT NOCOPY jtf_date_table,
2151 x_requested_arrival_date OUT NOCOPY jtf_date_table,
2152 x_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
2153 x_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
2154 x_quantity_on_hand OUT NOCOPY jtf_number_table,
2155 x_quote_header_id OUT NOCOPY jtf_number_table,
2156 x_calling_module OUT NOCOPY jtf_number_table,
2157 x_quote_number OUT NOCOPY jtf_number_table,
2158 x_ato_line_id OUT NOCOPY jtf_number_table,
2159 x_ref_line_id OUT NOCOPY jtf_number_table,
2160 x_top_model_line_id OUT NOCOPY jtf_number_table,
2161 x_action OUT NOCOPY jtf_number_table,
2162 x_arrival_date OUT NOCOPY jtf_date_table,
2163 x_organization_id OUT NOCOPY jtf_number_table,
2164 x_component_code OUT NOCOPY jtf_varchar2_table_1200,
2165 x_component_sequence_id OUT NOCOPY jtf_number_table,
2166 x_included_item_flag OUT NOCOPY jtf_number_table,
2167 x_cascade_model_info_to_comp OUT NOCOPY jtf_number_table,
2168 x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
2169 x_country OUT NOCOPY jtf_varchar2_table_600,
2170 x_state OUT NOCOPY jtf_varchar2_table_600,
2171 x_city OUT NOCOPY jtf_varchar2_table_600,
2172 x_postal_code OUT NOCOPY jtf_varchar2_table_600,
2173 x_match_item_id OUT NOCOPY jtf_number_table
2174 );
2175
2176
2177 PROCEDURE setOrgIdForNotifUserId(
2178 p_apvl_orgid IN NUMBER,
2179 p_apvl_notifId IN NUMBER,
2180 p_login_userid IN NUMBER,
2181 x_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2182 );
2183 FUNCTION Construct_Template_Tbl(
2184 p_template_id IN jtf_number_table := NULL
2185 )
2186 RETURN ASO_Quote_Pub.Template_Tbl_Type;
2187
2188 FUNCTION Construct_Template_Rec(
2189 p_template_id IN NUMBER := FND_API.G_MISS_NUM
2190 )
2191 RETURN ASO_Quote_Pub.Template_Rec_Type;
2192
2193
2194 FUNCTION Construct_Trigger_Attr_Tbl(
2195 p_trigger_attribute IN jtf_varchar2_table_100 := NULL
2196 )
2197 RETURN ASO_Defaulting_Int.Attribute_Codes_Tbl_Type;
2198
2199
2200 FUNCTION Construct_Hdr_Misc_Rec(
2201 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR
2202 )
2203 RETURN ASO_Defaulting_Int.Header_Misc_Rec_Type;
2204
2205
2206 FUNCTION Construct_Ln_Misc_Rec(
2207 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR
2208 )
2209 RETURN ASO_Defaulting_Int.Line_Misc_Rec_Type;
2210
2211
2212 PROCEDURE Set_Qte_header_rec_Out(
2213 p_qte_header_rec IN ASO_Quote_Pub.Qte_header_rec_Type,
2214 x_q_quote_header_id OUT NOCOPY NUMBER,
2215 x_q_creation_date OUT NOCOPY DATE,
2216 x_q_created_by OUT NOCOPY NUMBER,
2217 x_q_last_updated_by OUT NOCOPY NUMBER,
2218 x_q_last_update_date OUT NOCOPY DATE,
2219 x_q_last_update_login OUT NOCOPY NUMBER,
2220 x_q_request_id OUT NOCOPY NUMBER,
2221 x_q_program_application_id OUT NOCOPY NUMBER,
2222 x_q_program_id OUT NOCOPY NUMBER,
2223 x_q_program_update_date OUT NOCOPY DATE,
2224 x_q_org_id OUT NOCOPY NUMBER,
2225 x_q_quote_name OUT NOCOPY VARCHAR2,
2226 x_q_quote_number OUT NOCOPY NUMBER,
2227 x_q_quote_version OUT NOCOPY NUMBER,
2228 x_q_quote_status_id OUT NOCOPY NUMBER,
2229 x_q_quote_source_code OUT NOCOPY VARCHAR2,
2230 x_q_quote_expiration_date OUT NOCOPY DATE,
2231 x_q_price_frozen_date OUT NOCOPY DATE,
2232 x_q_quote_password OUT NOCOPY VARCHAR2,
2233 x_q_original_system_reference OUT NOCOPY VARCHAR2,
2234 x_q_party_id OUT NOCOPY NUMBER,
2235 x_q_cust_account_id OUT NOCOPY NUMBER,
2236 x_q_invoice_to_cust_acct_id OUT NOCOPY NUMBER,
2237 x_q_org_contact_id OUT NOCOPY NUMBER,
2238 x_q_party_name OUT NOCOPY VARCHAR2,
2239 x_q_party_type OUT NOCOPY VARCHAR2,
2240 x_q_person_first_name OUT NOCOPY VARCHAR2,
2241 x_q_person_last_name OUT NOCOPY VARCHAR2,
2242 x_q_person_middle_name OUT NOCOPY VARCHAR2,
2243 x_q_phone_id OUT NOCOPY NUMBER,
2244 x_q_price_list_id OUT NOCOPY NUMBER,
2245 x_q_price_list_name OUT NOCOPY VARCHAR2,
2246 x_q_currency_code OUT NOCOPY VARCHAR2,
2247 x_q_total_list_price OUT NOCOPY NUMBER,
2248 x_q_total_adjusted_amount OUT NOCOPY NUMBER,
2249 x_q_total_adjusted_percent OUT NOCOPY NUMBER,
2250 x_q_total_tax OUT NOCOPY NUMBER,
2251 x_q_total_shipping_charge OUT NOCOPY NUMBER,
2252 x_q_surcharge OUT NOCOPY NUMBER,
2253 x_q_total_quote_price OUT NOCOPY NUMBER,
2254 x_q_payment_amount OUT NOCOPY NUMBER,
2255 x_q_accounting_rule_id OUT NOCOPY NUMBER,
2256 x_q_exchange_rate OUT NOCOPY NUMBER,
2257 x_q_exchange_type_code OUT NOCOPY VARCHAR2,
2258 x_q_exchange_rate_date OUT NOCOPY DATE,
2259 x_q_quote_category_code OUT NOCOPY VARCHAR2,
2260 x_q_quote_status_code OUT NOCOPY VARCHAR2,
2261 x_q_quote_status OUT NOCOPY VARCHAR2,
2262 x_q_employee_person_id OUT NOCOPY NUMBER,
2263 x_q_sales_channel_code OUT NOCOPY VARCHAR2,
2264 x_q_salesrep_first_name OUT NOCOPY VARCHAR2,
2265 x_q_salesrep_last_name OUT NOCOPY VARCHAR2,
2266 x_q_attribute_category OUT NOCOPY VARCHAR2,
2267 x_q_attribute1 OUT NOCOPY VARCHAR2,
2268 x_q_attribute10 OUT NOCOPY VARCHAR2,
2269 x_q_attribute11 OUT NOCOPY VARCHAR2,
2270 x_q_attribute12 OUT NOCOPY VARCHAR2,
2271 x_q_attribute13 OUT NOCOPY VARCHAR2,
2272 x_q_attribute14 OUT NOCOPY VARCHAR2,
2273 x_q_attribute15 OUT NOCOPY VARCHAR2,
2274 x_q_attribute16 OUT NOCOPY VARCHAR2,
2275 x_q_attribute17 OUT NOCOPY VARCHAR2,
2276 x_q_attribute18 OUT NOCOPY VARCHAR2,
2277 x_q_attribute19 OUT NOCOPY VARCHAR2,
2278 x_q_attribute20 OUT NOCOPY VARCHAR2,
2279 x_q_attribute2 OUT NOCOPY VARCHAR2,
2280 x_q_attribute3 OUT NOCOPY VARCHAR2,
2281 x_q_attribute4 OUT NOCOPY VARCHAR2,
2282 x_q_attribute5 OUT NOCOPY VARCHAR2,
2283 x_q_attribute6 OUT NOCOPY VARCHAR2,
2284 x_q_attribute7 OUT NOCOPY VARCHAR2,
2285 x_q_attribute8 OUT NOCOPY VARCHAR2,
2286 x_q_attribute9 OUT NOCOPY VARCHAR2,
2287 x_q_contract_id OUT NOCOPY NUMBER,
2288 x_q_qte_contract_id OUT NOCOPY NUMBER,
2289 x_q_ffm_request_id OUT NOCOPY NUMBER,
2290 x_q_invoice_to_address1 OUT NOCOPY VARCHAR2,
2291 x_q_invoice_to_address2 OUT NOCOPY VARCHAR2,
2292 x_q_invoice_to_address3 OUT NOCOPY VARCHAR2,
2293 x_q_invoice_to_address4 OUT NOCOPY VARCHAR2,
2294 x_q_invoice_to_city OUT NOCOPY VARCHAR2,
2295 x_q_invoice_to_cont_first_name OUT NOCOPY VARCHAR2,
2296 x_q_invoice_to_cont_last_name OUT NOCOPY VARCHAR2,
2297 x_q_invoice_to_cont_mid_name OUT NOCOPY VARCHAR2,
2298 x_q_invoice_to_country_code OUT NOCOPY VARCHAR2,
2299 x_q_invoice_to_country OUT NOCOPY VARCHAR2,
2300 x_q_invoice_to_county OUT NOCOPY VARCHAR2,
2301 x_q_invoice_to_party_id OUT NOCOPY NUMBER,
2302 x_q_invoice_to_party_name OUT NOCOPY VARCHAR2,
2303 x_q_invoice_to_party_site_id OUT NOCOPY NUMBER,
2304 x_q_invoice_to_postal_code OUT NOCOPY VARCHAR2,
2305 x_q_invoice_to_province OUT NOCOPY VARCHAR2,
2306 x_q_invoice_to_state OUT NOCOPY VARCHAR2,
2307 x_q_invoicing_rule_id OUT NOCOPY NUMBER,
2308 x_q_marketing_source_code_id OUT NOCOPY NUMBER,
2309 x_q_marketing_source_code OUT NOCOPY VARCHAR2,
2310 x_q_marketing_source_name OUT NOCOPY VARCHAR2,
2311 x_q_orig_mktg_source_code_id OUT NOCOPY NUMBER,
2312 x_q_order_type_id OUT NOCOPY NUMBER,
2313 x_q_order_id OUT NOCOPY NUMBER,
2314 x_q_order_number OUT NOCOPY NUMBER,
2315 x_q_order_type_name OUT NOCOPY VARCHAR2,
2316 x_q_ordered_date OUT NOCOPY DATE,
2317 x_q_resource_id OUT NOCOPY NUMBER,
2318 x_q_contract_template_id OUT NOCOPY NUMBER,
2319 x_q_contract_template_maj_ver OUT NOCOPY NUMBER,
2320 x_q_contract_requester_id OUT NOCOPY NUMBER,
2321 x_q_contract_approval_level OUT NOCOPY VARCHAR2,
2322 x_q_publish_flag OUT NOCOPY VARCHAR2,
2323 x_q_resource_grp_id OUT NOCOPY NUMBER,
2324 x_q_sold_to_party_site_id OUT NOCOPY NUMBER,
2325 x_q_display_arithmetic_op OUT NOCOPY VARCHAR2,
2326 x_q_quote_description OUT NOCOPY VARCHAR2,
2327 x_q_quote_type OUT NOCOPY VARCHAR2,
2328 x_q_minisite_id OUT NOCOPY NUMBER,
2329 x_q_cust_party_id OUT NOCOPY NUMBER,
2330 x_q_invoice_to_cust_party_id OUT NOCOPY NUMBER,
2331 x_q_pricing_status_indicator OUT NOCOPY VARCHAR2,
2332 x_q_tax_status_indicator OUT NOCOPY VARCHAR2,
2333 x_q_price_updated_date OUT NOCOPY DATE,
2334 x_q_tax_updated_date OUT NOCOPY DATE,
2335 x_q_recalculate_flag OUT NOCOPY VARCHAR2,
2336 x_q_price_request_id OUT NOCOPY NUMBER,
2337 x_q_credit_update_date OUT NOCOPY DATE,
2338 x_q_customer_name_and_title OUT NOCOPY VARCHAR2,
2339 x_q_customer_signature_date OUT NOCOPY DATE,
2340 x_q_supplier_name_and_title OUT NOCOPY VARCHAR2,
2341 x_q_supplier_signature_date OUT NOCOPY DATE,
2342 x_q_end_cust_party_id OUT NOCOPY NUMBER,
2343 x_q_end_cust_party_site_id OUT NOCOPY NUMBER,
2344 x_q_end_cust_cust_account_id OUT NOCOPY NUMBER,
2345 x_q_end_cust_cust_party_id OUT NOCOPY NUMBER,
2346 x_q_automatic_price_flag OUT NOCOPY VARCHAR2,
2347 x_q_automatic_tax_flag OUT NOCOPY VARCHAR2,
2348 x_q_assistance_requested OUT NOCOPY VARCHAR2,
2349 x_q_assistance_reason_code OUT NOCOPY VARCHAR2,
2350 x_q_object_version_number OUT NOCOPY NUMBER,
2351 x_q_header_paynow_charges OUT NOCOPY NUMBER
2352 );
2353
2354
2355 PROCEDURE Set_Shipment_rec_Out(
2356 p_shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type,
2357 x_qs_operation_code OUT NOCOPY VARCHAR2,
2358 x_qs_qte_line_index OUT NOCOPY NUMBER,
2359 x_qs_shipment_id OUT NOCOPY NUMBER,
2360 x_qs_creation_date OUT NOCOPY DATE,
2361 x_qs_created_by OUT NOCOPY NUMBER,
2362 x_qs_last_update_date OUT NOCOPY DATE,
2363 x_qs_last_updated_by OUT NOCOPY NUMBER,
2364 x_qs_last_update_login OUT NOCOPY NUMBER,
2365 x_qs_request_id OUT NOCOPY NUMBER,
2366 x_qs_program_application_id OUT NOCOPY NUMBER,
2367 x_qs_program_id OUT NOCOPY NUMBER,
2368 x_qs_program_update_date OUT NOCOPY DATE,
2369 x_qs_quote_header_id OUT NOCOPY NUMBER,
2370 x_qs_quote_line_id OUT NOCOPY NUMBER,
2371 x_qs_promise_date OUT NOCOPY DATE,
2372 x_qs_request_date OUT NOCOPY DATE,
2373 x_qs_schedule_ship_date OUT NOCOPY DATE,
2374 x_qs_ship_to_party_site_id OUT NOCOPY NUMBER,
2375 x_qs_ship_to_party_id OUT NOCOPY NUMBER,
2376 x_qs_ship_to_cust_account_id OUT NOCOPY NUMBER,
2377 x_qs_ship_partial_flag OUT NOCOPY VARCHAR2,
2378 x_qs_ship_set_id OUT NOCOPY NUMBER,
2379 x_qs_ship_method_code OUT NOCOPY VARCHAR2,
2380 x_qs_freight_terms_code OUT NOCOPY VARCHAR2,
2381 x_qs_freight_carrier_code OUT NOCOPY VARCHAR2,
2382 x_qs_fob_code OUT NOCOPY VARCHAR2,
2383 x_qs_shipping_instructions OUT NOCOPY VARCHAR2,
2384 x_qs_packing_instructions OUT NOCOPY VARCHAR2,
2385 x_qs_quantity OUT NOCOPY NUMBER,
2386 x_qs_reserved_quantity OUT NOCOPY VARCHAR2,
2387 x_qs_reservation_id OUT NOCOPY NUMBER,
2388 x_qs_order_line_id OUT NOCOPY NUMBER,
2389 x_qs_ship_to_party_name OUT NOCOPY VARCHAR2,
2390 x_qs_ship_to_cont_first_name OUT NOCOPY VARCHAR2,
2391 x_qs_ship_to_cont_mid_name OUT NOCOPY VARCHAR2,
2392 x_qs_ship_to_cont_last_name OUT NOCOPY VARCHAR2,
2393 x_qs_ship_to_address1 OUT NOCOPY VARCHAR2,
2394 x_qs_ship_to_address2 OUT NOCOPY VARCHAR2,
2395 x_qs_ship_to_address3 OUT NOCOPY VARCHAR2,
2396 x_qs_ship_to_address4 OUT NOCOPY VARCHAR2,
2397 x_qs_ship_to_country_code OUT NOCOPY VARCHAR2,
2398 x_qs_ship_to_country OUT NOCOPY VARCHAR2,
2399 x_qs_ship_to_city OUT NOCOPY VARCHAR2,
2400 x_qs_ship_to_postal_code OUT NOCOPY VARCHAR2,
2401 x_qs_ship_to_state OUT NOCOPY VARCHAR2,
2402 x_qs_ship_to_province OUT NOCOPY VARCHAR2,
2403 x_qs_ship_to_county OUT NOCOPY VARCHAR2,
2404 x_qs_attribute_category OUT NOCOPY VARCHAR2,
2405 x_qs_attribute1 OUT NOCOPY VARCHAR2,
2406 x_qs_attribute2 OUT NOCOPY VARCHAR2,
2407 x_qs_attribute3 OUT NOCOPY VARCHAR2,
2408 x_qs_attribute4 OUT NOCOPY VARCHAR2,
2409 x_qs_attribute5 OUT NOCOPY VARCHAR2,
2410 x_qs_attribute6 OUT NOCOPY VARCHAR2,
2411 x_qs_attribute7 OUT NOCOPY VARCHAR2,
2412 x_qs_attribute8 OUT NOCOPY VARCHAR2,
2413 x_qs_attribute9 OUT NOCOPY VARCHAR2,
2414 x_qs_attribute10 OUT NOCOPY VARCHAR2,
2415 x_qs_attribute11 OUT NOCOPY VARCHAR2,
2416 x_qs_attribute12 OUT NOCOPY VARCHAR2,
2417 x_qs_attribute13 OUT NOCOPY VARCHAR2,
2418 x_qs_attribute14 OUT NOCOPY VARCHAR2,
2419 x_qs_attribute15 OUT NOCOPY VARCHAR2,
2420 x_qs_attribute16 OUT NOCOPY VARCHAR2,
2421 x_qs_attribute17 OUT NOCOPY VARCHAR2,
2422 x_qs_attribute18 OUT NOCOPY VARCHAR2,
2423 x_qs_attribute19 OUT NOCOPY VARCHAR2,
2424 x_qs_attribute20 OUT NOCOPY VARCHAR2,
2425 x_qs_ship_quote_price OUT NOCOPY NUMBER,
2426 x_qs_pricing_quantity OUT NOCOPY NUMBER,
2427 x_qs_shipment_priority_code OUT NOCOPY VARCHAR2,
2428 x_qs_ship_from_org_id OUT NOCOPY NUMBER,
2429 x_qs_ship_to_cust_party_id OUT NOCOPY NUMBER,
2430 x_qs_request_date_type OUT NOCOPY VARCHAR2,
2431 x_qs_demand_class_code OUT NOCOPY VARCHAR2,
2432 x_qs_object_version_number OUT NOCOPY NUMBER
2433 );
2434
2435 PROCEDURE Set_Payment_rec_Out(
2436 p_payment_rec IN ASO_Quote_Pub.Payment_rec_Type,
2437 x_qp_operation_code OUT NOCOPY VARCHAR2,
2438 x_qp_qte_line_index OUT NOCOPY NUMBER,
2439 x_qp_payment_id OUT NOCOPY NUMBER,
2440 x_qp_creation_date OUT NOCOPY DATE,
2441 x_qp_created_by OUT NOCOPY NUMBER,
2442 x_qp_last_update_date OUT NOCOPY DATE,
2443 x_qp_last_updated_by OUT NOCOPY NUMBER,
2444 x_qp_last_update_login OUT NOCOPY NUMBER,
2445 x_qp_request_id OUT NOCOPY NUMBER,
2446 x_qp_program_application_id OUT NOCOPY NUMBER,
2447 x_qp_program_id OUT NOCOPY NUMBER,
2448 x_qp_program_update_date OUT NOCOPY DATE,
2449 x_qp_quote_header_id OUT NOCOPY NUMBER,
2450 x_qp_quote_line_id OUT NOCOPY NUMBER,
2451 x_qp_payment_type_code OUT NOCOPY VARCHAR2,
2452 x_qp_payment_ref_number OUT NOCOPY VARCHAR2,
2453 x_qp_payment_option OUT NOCOPY VARCHAR2,
2454 x_qp_payment_term_id OUT NOCOPY NUMBER,
2455 x_qp_credit_card_code OUT NOCOPY VARCHAR2,
2456 x_qp_credit_card_holder_name OUT NOCOPY VARCHAR2,
2457 x_qp_credit_card_exp_date OUT NOCOPY DATE,
2458 x_qp_credit_card_aprv_code OUT NOCOPY VARCHAR2,
2459 x_qp_credit_card_aprv_date OUT NOCOPY DATE,
2460 x_qp_payment_amount OUT NOCOPY NUMBER,
2461 x_qp_attribute_category OUT NOCOPY VARCHAR2,
2462 x_qp_attribute1 OUT NOCOPY VARCHAR2,
2463 x_qp_attribute2 OUT NOCOPY VARCHAR2,
2464 x_qp_attribute3 OUT NOCOPY VARCHAR2,
2465 x_qp_attribute4 OUT NOCOPY VARCHAR2,
2466 x_qp_attribute5 OUT NOCOPY VARCHAR2,
2467 x_qp_attribute6 OUT NOCOPY VARCHAR2,
2468 x_qp_attribute7 OUT NOCOPY VARCHAR2,
2469 x_qp_attribute8 OUT NOCOPY VARCHAR2,
2470 x_qp_attribute9 OUT NOCOPY VARCHAR2,
2471 x_qp_attribute10 OUT NOCOPY VARCHAR2,
2472 x_qp_attribute11 OUT NOCOPY VARCHAR2,
2473 x_qp_attribute12 OUT NOCOPY VARCHAR2,
2474 x_qp_attribute13 OUT NOCOPY VARCHAR2,
2475 x_qp_attribute14 OUT NOCOPY VARCHAR2,
2476 x_qp_attribute15 OUT NOCOPY VARCHAR2,
2477 x_qp_attribute16 OUT NOCOPY VARCHAR2,
2478 x_qp_attribute17 OUT NOCOPY VARCHAR2,
2479 x_qp_attribute18 OUT NOCOPY VARCHAR2,
2480 x_qp_attribute19 OUT NOCOPY VARCHAR2,
2481 x_qp_attribute20 OUT NOCOPY VARCHAR2,
2482 x_qp_shipment_index OUT NOCOPY NUMBER,
2483 x_qp_quote_shipment_id OUT NOCOPY NUMBER,
2484 x_qp_cust_po_number OUT NOCOPY VARCHAR2,
2485 x_qp_cust_po_line_number OUT NOCOPY VARCHAR2,
2486 x_qp_object_version_number OUT NOCOPY NUMBER,
2487 x_qp_trxn_extension_id OUT NOCOPY NUMBER,
2488 x_qp_instrument_id OUT NOCOPY NUMBER,
2489 x_qp_instr_assignment_id OUT NOCOPY NUMBER,
2490 x_qp_cvv2 OUT NOCOPY VARCHAR2
2491 );
2492
2493
2494 PROCEDURE Set_Tax_detail_rec_Out(
2495 p_tax_detail_rec IN ASO_Quote_Pub.Tax_detail_rec_Type,
2496 x_qt_operation_code OUT NOCOPY VARCHAR2,
2497 x_qt_qte_line_index OUT NOCOPY NUMBER,
2498 x_qt_shipment_index OUT NOCOPY NUMBER,
2499 x_qt_tax_detail_id OUT NOCOPY NUMBER,
2500 x_qt_quote_header_id OUT NOCOPY NUMBER,
2501 x_qt_quote_line_id OUT NOCOPY NUMBER,
2502 x_qt_quote_shipment_id OUT NOCOPY NUMBER,
2503 x_qt_creation_date OUT NOCOPY DATE,
2504 x_qt_created_by OUT NOCOPY NUMBER,
2505 x_qt_last_update_date OUT NOCOPY DATE,
2506 x_qt_last_updated_by OUT NOCOPY NUMBER,
2507 x_qt_last_update_login OUT NOCOPY NUMBER,
2508 x_qt_request_id OUT NOCOPY NUMBER,
2509 x_qt_program_application_id OUT NOCOPY NUMBER,
2510 x_qt_program_id OUT NOCOPY NUMBER,
2511 x_qt_program_update_date OUT NOCOPY DATE,
2512 x_qt_orig_tax_code OUT NOCOPY VARCHAR2,
2513 x_qt_tax_code OUT NOCOPY VARCHAR2,
2514 x_qt_tax_rate OUT NOCOPY NUMBER,
2515 x_qt_tax_date OUT NOCOPY DATE,
2516 x_qt_tax_amount OUT NOCOPY NUMBER,
2517 x_qt_tax_exempt_flag OUT NOCOPY VARCHAR2,
2518 x_qt_tax_exempt_number OUT NOCOPY VARCHAR2,
2519 x_qt_tax_exempt_reason_code OUT NOCOPY VARCHAR2,
2520 x_qt_attribute_category OUT NOCOPY VARCHAR2,
2521 x_qt_attribute1 OUT NOCOPY VARCHAR2,
2522 x_qt_attribute2 OUT NOCOPY VARCHAR2,
2523 x_qt_attribute3 OUT NOCOPY VARCHAR2,
2524 x_qt_attribute4 OUT NOCOPY VARCHAR2,
2525 x_qt_attribute5 OUT NOCOPY VARCHAR2,
2526 x_qt_attribute6 OUT NOCOPY VARCHAR2,
2527 x_qt_attribute7 OUT NOCOPY VARCHAR2,
2528 x_qt_attribute8 OUT NOCOPY VARCHAR2,
2529 x_qt_attribute9 OUT NOCOPY VARCHAR2,
2530 x_qt_attribute10 OUT NOCOPY VARCHAR2,
2531 x_qt_attribute11 OUT NOCOPY VARCHAR2,
2532 x_qt_attribute12 OUT NOCOPY VARCHAR2,
2533 x_qt_attribute13 OUT NOCOPY VARCHAR2,
2534 x_qt_attribute14 OUT NOCOPY VARCHAR2,
2535 x_qt_attribute15 OUT NOCOPY VARCHAR2,
2536 x_qt_attribute16 OUT NOCOPY VARCHAR2,
2537 x_qt_attribute17 OUT NOCOPY VARCHAR2,
2538 x_qt_attribute18 OUT NOCOPY VARCHAR2,
2539 x_qt_attribute19 OUT NOCOPY VARCHAR2,
2540 x_qt_attribute20 OUT NOCOPY VARCHAR2,
2541 x_qt_object_version_number OUT NOCOPY NUMBER,
2542 x_qt_tax_rate_id OUT NOCOPY NUMBER
2543 );
2544
2545
2546 PROCEDURE Set_Qte_line_rec_Out(
2547 p_qte_line_rec IN ASO_Quote_Pub.Qte_line_rec_Type,
2548 x_ql_creation_date OUT NOCOPY DATE,
2549 x_ql_created_by OUT NOCOPY NUMBER,
2550 x_ql_last_updated_by OUT NOCOPY NUMBER,
2551 x_ql_last_update_date OUT NOCOPY DATE,
2552 x_ql_last_update_login OUT NOCOPY NUMBER,
2553 x_ql_request_id OUT NOCOPY NUMBER,
2554 x_ql_program_application_id OUT NOCOPY NUMBER,
2555 x_ql_program_id OUT NOCOPY NUMBER,
2556 x_ql_program_update_date OUT NOCOPY DATE,
2557 x_ql_quote_line_id OUT NOCOPY NUMBER,
2558 x_ql_quote_header_id OUT NOCOPY NUMBER,
2559 x_ql_org_id OUT NOCOPY NUMBER,
2560 x_ql_line_number OUT NOCOPY NUMBER,
2561 x_ql_line_category_code OUT NOCOPY VARCHAR2,
2562 x_ql_item_type_code OUT NOCOPY VARCHAR2,
2563 x_ql_inventory_item_id OUT NOCOPY NUMBER,
2564 x_ql_organization_id OUT NOCOPY NUMBER,
2565 x_ql_quantity OUT NOCOPY NUMBER,
2566 x_ql_uom_code OUT NOCOPY VARCHAR2,
2567 x_ql_start_date_active OUT NOCOPY VARCHAR2,
2568 x_ql_end_date_active OUT NOCOPY VARCHAR2,
2569 x_ql_order_line_type_id OUT NOCOPY NUMBER,
2570 x_ql_price_list_id OUT NOCOPY NUMBER,
2571 x_ql_price_list_line_id OUT NOCOPY NUMBER,
2572 x_ql_currency_code OUT NOCOPY VARCHAR2,
2573 x_ql_line_list_price OUT NOCOPY NUMBER,
2574 x_ql_line_adjusted_amount OUT NOCOPY NUMBER,
2575 x_ql_line_adjusted_percent OUT NOCOPY NUMBER,
2576 x_ql_line_quote_price OUT NOCOPY NUMBER,
2577 x_ql_related_item_id OUT NOCOPY NUMBER,
2578 x_ql_item_relationship_type OUT NOCOPY VARCHAR2,
2579 x_ql_split_shipment_flag OUT NOCOPY VARCHAR2,
2580 x_ql_backorder_flag OUT NOCOPY VARCHAR2,
2581 x_ql_selling_price_change OUT NOCOPY VARCHAR2,
2582 x_ql_recalculate_flag OUT NOCOPY VARCHAR2,
2583 x_ql_attribute_category OUT NOCOPY VARCHAR2,
2584 x_ql_attribute1 OUT NOCOPY VARCHAR2,
2585 x_ql_attribute2 OUT NOCOPY VARCHAR2,
2586 x_ql_attribute3 OUT NOCOPY VARCHAR2,
2587 x_ql_attribute4 OUT NOCOPY VARCHAR2,
2588 x_ql_attribute5 OUT NOCOPY VARCHAR2,
2589 x_ql_attribute6 OUT NOCOPY VARCHAR2,
2590 x_ql_attribute7 OUT NOCOPY VARCHAR2,
2591 x_ql_attribute8 OUT NOCOPY VARCHAR2,
2592 x_ql_attribute9 OUT NOCOPY VARCHAR2,
2593 x_ql_attribute10 OUT NOCOPY VARCHAR2,
2594 x_ql_attribute11 OUT NOCOPY VARCHAR2,
2595 x_ql_attribute12 OUT NOCOPY VARCHAR2,
2596 x_ql_attribute13 OUT NOCOPY VARCHAR2,
2597 x_ql_attribute14 OUT NOCOPY VARCHAR2,
2598 x_ql_attribute15 OUT NOCOPY VARCHAR2,
2599 x_ql_attribute16 OUT NOCOPY VARCHAR2,
2600 x_ql_attribute17 OUT NOCOPY VARCHAR2,
2601 x_ql_attribute18 OUT NOCOPY VARCHAR2,
2602 x_ql_attribute19 OUT NOCOPY VARCHAR2,
2603 x_ql_attribute20 OUT NOCOPY VARCHAR2,
2604 x_ql_accounting_rule_id OUT NOCOPY NUMBER,
2605 x_ql_ffm_content_name OUT NOCOPY VARCHAR2,
2606 x_ql_ffm_content_type OUT NOCOPY VARCHAR2,
2607 x_ql_ffm_document_type OUT NOCOPY VARCHAR2,
2608 x_ql_ffm_media_id OUT NOCOPY VARCHAR2,
2609 x_ql_ffm_media_type OUT NOCOPY VARCHAR2,
2610 x_ql_ffm_user_note OUT NOCOPY VARCHAR2,
2611 x_ql_invoice_to_party_id OUT NOCOPY NUMBER,
2612 x_ql_invoice_to_party_site_id OUT NOCOPY NUMBER,
2613 x_ql_invoicing_rule_id OUT NOCOPY NUMBER,
2614 x_ql_marketing_source_code_id OUT NOCOPY NUMBER,
2615 x_ql_operation_code OUT NOCOPY VARCHAR2,
2616 x_ql_invoice_to_cust_acct_id OUT NOCOPY NUMBER,
2617 x_ql_pricing_quantity_uom OUT NOCOPY VARCHAR2,
2618 x_ql_minisite_id OUT NOCOPY NUMBER,
2619 x_ql_section_id OUT NOCOPY NUMBER,
2620 x_ql_priced_price_list_id OUT NOCOPY NUMBER,
2621 x_ql_agreement_id OUT NOCOPY NUMBER,
2622 x_ql_commitment_id OUT NOCOPY NUMBER,
2623 x_ql_display_arithmetic_op OUT NOCOPY VARCHAR2,
2624 x_ql_invoice_to_cust_party_id OUT NOCOPY NUMBER,
2625 x_ql_ship_model_complete_flag OUT NOCOPY VARCHAR2,
2626 x_ql_charge_periodicity_code OUT NOCOPY VARCHAR2,
2627 x_ql_end_cust_party_id OUT NOCOPY NUMBER,
2628 x_ql_end_cust_party_site_id OUT NOCOPY NUMBER,
2629 x_ql_end_cust_cust_account_id OUT NOCOPY NUMBER,
2630 x_ql_end_cust_cust_party_id OUT NOCOPY NUMBER,
2631 x_ql_object_version_number OUT NOCOPY NUMBER,
2632 x_ql_line_paynow_charges OUT NOCOPY NUMBER,
2633 x_ql_line_paynow_tax OUT NOCOPY NUMBER,
2634 x_ql_line_paynow_subtotal OUT NOCOPY NUMBER,
2635 x_ql_config_model_type OUT NOCOPY VARCHAR2
2636 );
2637
2638 PROCEDURE Set_Def_Control_Rec_W(
2639 p_dc_override_Trigger_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2640 p_dc_dependency_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2641 p_dc_defaulting_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2642 p_dc_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2643 p_dc_defaulting_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2644 p_dc_last_update_date IN DATE := FND_API.G_MISS_DATE,
2645 p_dc_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
2646 x_def_control_rec OUT NOCOPY ASO_Defaulting_Int.Control_Rec_Type
2647 );
2648
2649 PROCEDURE Set_num_Tbl_Out (
2650 p_num_tbl IN ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE,
2651 x_num_id OUT NOCOPY JTF_NUMBER_TABLE
2652 );
2653
2654 FUNCTION Construct_Related_Obj_Tbl(
2655 p_operation_code IN jtf_varchar2_table_100 := NULL,
2656 p_RELATED_OBJECT_ID IN jtf_number_table := NULL,
2657 p_CREATION_DATE IN jtf_date_table := null,
2658 p_CREATED_BY IN jtf_number_table := NULL,
2659 p_LAST_UPDATE_DATE IN jtf_date_table := null,
2660 p_LAST_UPDATED_BY IN jtf_number_table := NULL,
2661 p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL,
2662 p_REQUEST_ID IN jtf_number_table := NULL,
2663 p_PROGRAM_APPLICATION_ID IN jtf_number_table := NULL,
2664 p_PROGRAM_ID IN jtf_number_table := NULL,
2665 p_PROGRAM_UPDATE_DATE IN jtf_date_table := null,
2666 p_QUOTE_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
2667 p_QUOTE_OBJECT_ID IN jtf_number_table := NULL,
2668 p_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
2669 p_OBJECT_ID IN jtf_number_table := NULL,
2670 p_RELATIONSHIP_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
2671 p_RECIPROCAL_FLAG IN jtf_varchar2_table_100 := NULL,
2672 p_QUOTE_OBJECT_CODE IN jtf_number_table := NULL,
2673 p_OBJECT_VERSION_NUMBER IN jtf_number_table := NULL
2674 )
2675 RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
2676
2677
2678 PROCEDURE Set_Related_Obj_Tbl_Out(
2679 p_rel_obj_tbl IN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type,
2680 x_related_object_id OUT NOCOPY jtf_number_table
2681 );
2682
2683
2684 END ASO_Quote_Util_PVT;