[Home] [Help]
PACKAGE: APPS.ASO_QUOTE_UTIL_PVT
Source
1 PACKAGE ASO_Quote_Util_PVT AUTHID CURRENT_USER as
2 /* $Header: asovqwus.pls 120.5.12010000.3 2010/03/31 23:32:30 cazhou 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 p_Copy_Shipping VARCHAR2 := FND_API.G_TRUE,
1338 p_Copy_Billing VARCHAR2 := FND_API.G_TRUE,
1339 p_Copy_Payment VARCHAR2 := FND_API.G_TRUE,
1340 p_Copy_End_Customer VARCHAR2 := FND_API.G_TRUE,
1341 p_Copy_Sales_Supplement VARCHAR2 := FND_API.G_TRUE,
1342 p_Copy_Flexfield VARCHAR2 := FND_API.G_TRUE,
1343 p_Copy_Sales_Credit VARCHAR2 := FND_API.G_TRUE,
1344 p_Copy_Contract_Terms VARCHAR2 := FND_API.G_TRUE,
1345 p_Copy_Sales_Team VARCHAR2 := FND_API.G_TRUE,
1346 p_Copy_Line_Shipping VARCHAR2 := FND_API.G_TRUE,
1347 p_Copy_Line_Billing VARCHAR2 := FND_API.G_TRUE,
1348 p_Copy_Line_Payment VARCHAR2 := FND_API.G_TRUE,
1349 p_Copy_Line_End_Customer VARCHAR2 := FND_API.G_TRUE,
1350 p_Copy_Line_Sales_Supplement VARCHAR2 := FND_API.G_TRUE,
1351 p_Copy_Line_Attachment VARCHAR2 := FND_API.G_TRUE,
1352 p_Copy_Line_Flexfield VARCHAR2 := FND_API.G_TRUE,
1353 p_Copy_Line_Sales_Credit VARCHAR2 := FND_API.G_TRUE,
1354 p_Copy_To_Same_Customer VARCHAR2 := FND_API.G_TRUE,
1355 x_copy_quote_control_rec OUT NOCOPY ASO_Copy_Quote_Pub.Copy_Quote_Control_Rec_Type
1356 );
1357
1358 PROCEDURE Set_Order_Header_Rec_Out(
1359 p_order_header_rec IN ASO_Quote_Pub.Order_Header_Rec_Type,
1360 x_order_number OUT NOCOPY NUMBER ,
1361 x_order_header_id OUT NOCOPY NUMBER ,
1362 x_order_request_id OUT NOCOPY NUMBER ,
1363 x_contract_id OUT NOCOPY NUMBER ,
1364 x_status OUT NOCOPY VARCHAR2
1365 );
1366
1367 PROCEDURE Set_Qte_Header_Tbl_Out(
1368 p_qte_header_tbl IN ASO_Quote_Pub.Qte_Header_Tbl_Type,
1369 x_quote_header_id OUT NOCOPY jtf_number_table,
1370 x_last_update_date OUT NOCOPY jtf_date_table
1371
1372 /*-- The following output parameters are ignored
1373 x_creation_date OUT NOCOPY jtf_date_table,
1374 x_created_by OUT NOCOPY jtf_number_table,
1375 x_last_updated_by OUT NOCOPY jtf_number_table,
1376 x_last_update_login OUT NOCOPY jtf_number_table,
1377 x_request_id OUT NOCOPY jtf_number_table,
1378 x_program_application_id OUT NOCOPY jtf_number_table,
1379 x_program_id OUT NOCOPY jtf_number_table,
1380 x_program_update_date OUT NOCOPY jtf_date_table,
1381 x_org_id OUT NOCOPY jtf_number_table,
1382 x_quote_name OUT NOCOPY jtf_varchar2_table_100,
1383 x_quote_number OUT NOCOPY jtf_number_table,
1384 x_quote_version OUT NOCOPY jtf_number_table,
1385 x_quote_status_id OUT NOCOPY jtf_number_table,
1386 x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
1387 x_quote_expiration_date OUT NOCOPY jtf_date_table,
1388 x_price_frozen_date OUT NOCOPY jtf_date_table,
1389 x_quote_password OUT NOCOPY jtf_varchar2_table_300,
1390 x_original_system_reference OUT NOCOPY jtf_varchar2_table_300,
1391 x_party_id OUT NOCOPY jtf_number_table,
1392 x_cust_account_id OUT NOCOPY jtf_number_table,
1393 x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,
1394 x_org_contact_id OUT NOCOPY jtf_number_table,
1395 x_phone_id OUT NOCOPY jtf_number_table,
1396 x_invoice_to_party_site_id OUT NOCOPY jtf_number_table,
1397 x_invoice_to_party_id OUT NOCOPY jtf_number_table,
1398 x_orig_mktg_source_code_id OUT NOCOPY jtf_number_table,
1399 x_marketing_source_code_id OUT NOCOPY jtf_number_table,
1400 x_order_type_id OUT NOCOPY jtf_number_table,
1401 x_quote_category_code OUT NOCOPY jtf_varchar2_table_300,
1402 x_ordered_date OUT NOCOPY jtf_date_table,
1403 x_accounting_rule_id OUT NOCOPY jtf_number_table,
1404 x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1405 x_employee_person_id OUT NOCOPY jtf_number_table,
1406 x_price_list_id OUT NOCOPY jtf_number_table,
1407 x_currency_code OUT NOCOPY jtf_varchar2_table_100,
1408 x_total_list_price OUT NOCOPY jtf_number_table,
1409 x_total_adjusted_amount OUT NOCOPY jtf_number_table,
1410 x_total_adjusted_percent OUT NOCOPY jtf_number_table,
1411 x_total_tax OUT NOCOPY jtf_number_table,
1412 x_total_shipping_charge OUT NOCOPY jtf_number_table,
1413 x_surcharge OUT NOCOPY jtf_number_table,
1414 x_total_quote_price OUT NOCOPY jtf_number_table,
1415 x_payment_amount OUT NOCOPY jtf_number_table,
1416 x_exchange_rate OUT NOCOPY jtf_number_table,
1417 x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
1418 x_exchange_rate_date OUT NOCOPY jtf_date_table,
1419 x_contract_id OUT NOCOPY jtf_number_table,
1420 x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
1421 x_order_id OUT NOCOPY jtf_number_table,
1422 x_order_number OUT NOCOPY jtf_number_table,
1423 x_ffm_request_id OUT NOCOPY jtf_number_table,
1424 x_qte_contract_id OUT NOCOPY jtf_number_table,
1425 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1426 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1427 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1428 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1429 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1430 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1431 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1432 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1433 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1434 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1435 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1436 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1437 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1438 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1439 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1440 x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1441 x_salesrep_first_name OUT NOCOPY jtf_varchar2_table_300,
1442 x_salesrep_last_name OUT NOCOPY jtf_varchar2_table_300,
1443 x_price_list_name OUT NOCOPY jtf_varchar2_table_300,
1444 x_quote_status_code OUT NOCOPY jtf_varchar2_table_100,
1445 x_quote_status OUT NOCOPY jtf_varchar2_table_300,
1446 x_party_name OUT NOCOPY jtf_varchar2_table_300,
1447 x_party_type OUT NOCOPY jtf_varchar2_table_100,
1448 x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
1449 x_person_middle_name OUT NOCOPY jtf_varchar2_table_100,
1450 x_person_last_name OUT NOCOPY jtf_varchar2_table_200,
1451 x_marketing_source_name OUT NOCOPY jtf_varchar2_table_200,
1452 x_marketing_source_code OUT NOCOPY jtf_varchar2_table_200,
1453 x_order_type_name OUT NOCOPY jtf_varchar2_table_300,
1454 x_invoice_to_party_name OUT NOCOPY jtf_varchar2_table_300,
1455 x_invoice_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
1456 x_invoice_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
1457 x_invoice_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
1458 x_invoice_to_address1 OUT NOCOPY jtf_varchar2_table_300,
1459 x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1460 x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1461 x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1462 x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1463 x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1464 x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1465 x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1466 x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1467 x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1468 x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
1469 x_resource_id OUT NOCOPY jtf_number_table
1470 --*/
1471 );
1472
1473 PROCEDURE Set_Qte_Line_Tbl_Out(
1474 p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,
1475 x_quote_line_id OUT NOCOPY jtf_number_table
1476
1477 /*-- The following output parameters are ignored
1478 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1479 x_creation_date OUT NOCOPY jtf_date_table,
1480 x_created_by OUT NOCOPY jtf_number_table,
1481 x_last_update_date OUT NOCOPY jtf_date_table,
1482 x_last_updated_by OUT NOCOPY jtf_number_table,
1483 x_last_update_login OUT NOCOPY jtf_number_table,
1484 x_request_id OUT NOCOPY jtf_number_table,
1485 x_program_application_id OUT NOCOPY jtf_number_table,
1486 x_program_id OUT NOCOPY jtf_number_table,
1487 x_program_update_date OUT NOCOPY jtf_date_table,
1488 x_quote_header_id OUT NOCOPY jtf_number_table,
1489 x_org_id OUT NOCOPY jtf_number_table,
1490 x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
1491 x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
1492 x_line_number OUT NOCOPY jtf_number_table,
1493 x_start_date_active OUT NOCOPY jtf_date_table,
1494 x_end_date_active OUT NOCOPY jtf_date_table,
1495 x_order_line_type_id OUT NOCOPY jtf_number_table,
1496 x_invoice_to_party_site_id OUT NOCOPY jtf_number_table,
1497 x_invoice_to_party_id OUT NOCOPY jtf_number_table,
1498 x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,
1499 x_organization_id OUT NOCOPY jtf_number_table,
1500 x_inventory_item_id OUT NOCOPY jtf_number_table,
1501 x_quantity OUT NOCOPY jtf_number_table,
1502 x_uom_code OUT NOCOPY jtf_varchar2_table_100,
1503 x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
1504 x_marketing_source_code_id OUT NOCOPY jtf_number_table,
1505 x_price_list_id OUT NOCOPY jtf_number_table,
1506 x_price_list_line_id OUT NOCOPY jtf_number_table,
1507 x_currency_code OUT NOCOPY jtf_varchar2_table_100,
1508 x_line_list_price OUT NOCOPY jtf_number_table,
1509 x_line_adjusted_amount OUT NOCOPY jtf_number_table,
1510 x_line_adjusted_percent OUT NOCOPY jtf_number_table,
1511 x_line_quote_price OUT NOCOPY jtf_number_table,
1512 x_related_item_id OUT NOCOPY jtf_number_table,
1513 x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
1514 x_accounting_rule_id OUT NOCOPY jtf_number_table,
1515 x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1516 x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
1517 x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
1518 x_minisite_id OUT NOCOPY jtf_number_table,
1519 x_section_id OUT NOCOPY jtf_number_table,
1520 x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
1521 x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
1522 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1523 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1524 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1525 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1526 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1527 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1528 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1529 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1530 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1531 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1532 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1533 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1534 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1535 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1536 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1537 x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1538 x_ffm_content_name OUT NOCOPY jtf_varchar2_table_300,
1539 x_ffm_document_type OUT NOCOPY jtf_varchar2_table_300,
1540 x_ffm_media_type OUT NOCOPY jtf_varchar2_table_300,
1541 x_ffm_media_id OUT NOCOPY jtf_varchar2_table_300,
1542 x_ffm_content_type OUT NOCOPY jtf_varchar2_table_300,
1543 x_ffm_user_note OUT NOCOPY jtf_varchar2_table_300
1544 --*/
1545 );
1546
1547 PROCEDURE Set_Qte_Line_Dtl_Tbl_Out(
1548 p_qte_line_dtl_tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
1549 x_quote_line_detail_id OUT NOCOPY jtf_number_table
1550
1551 /*-- The following output parameters are ignored
1552 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1553 x_qte_line_index OUT NOCOPY jtf_number_table,
1554 x_creation_date OUT NOCOPY jtf_date_table,
1555 x_created_by OUT NOCOPY jtf_number_table,
1556 x_last_update_date OUT NOCOPY jtf_date_table,
1557 x_last_updated_by OUT NOCOPY jtf_number_table,
1558 x_last_update_login OUT NOCOPY jtf_number_table,
1559 x_request_id OUT NOCOPY jtf_number_table,
1560 x_program_application_id OUT NOCOPY jtf_number_table,
1561 x_program_id OUT NOCOPY jtf_number_table,
1562 x_program_update_date OUT NOCOPY jtf_date_table,
1563 x_quote_line_id OUT NOCOPY jtf_number_table,
1564 x_config_header_id OUT NOCOPY jtf_number_table,
1565 x_config_revision_num OUT NOCOPY jtf_number_table,
1566 x_config_item_id OUT NOCOPY jtf_number_table,
1567 x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
1568 x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
1569 x_component_code OUT NOCOPY jtf_varchar2_table_1200,
1570 x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
1571 x_service_duration OUT NOCOPY jtf_number_table,
1572 x_service_period OUT NOCOPY jtf_varchar2_table_100,
1573 x_service_unit_selling OUT NOCOPY jtf_number_table,
1574 x_service_unit_list OUT NOCOPY jtf_number_table,
1575 x_service_number OUT NOCOPY jtf_number_table,
1576 x_unit_percent_base_price OUT NOCOPY jtf_number_table,
1577 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1578 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1579 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1580 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1581 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1582 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1583 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1584 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1585 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1586 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1587 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1588 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1589 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1590 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1591 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1592 x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1593 x_service_ref_type_code OUT NOCOPY jtf_varchar2_table_100,
1594 x_service_ref_order_number OUT NOCOPY jtf_number_table,
1595 x_service_ref_line_number OUT NOCOPY jtf_number_table,
1596 x_service_ref_qte_line_ind OUT NOCOPY jtf_number_table,
1597 x_service_ref_line_id OUT NOCOPY jtf_number_table,
1598 x_service_ref_system_id OUT NOCOPY jtf_number_table,
1599 x_service_ref_option_numb OUT NOCOPY jtf_number_table,
1600 x_service_ref_shipment OUT NOCOPY jtf_number_table,
1601 x_return_ref_type OUT NOCOPY jtf_varchar2_table_100,
1602 x_return_ref_header_id OUT NOCOPY jtf_number_table,
1603 x_return_ref_line_id OUT NOCOPY jtf_number_table,
1604 x_return_attribute1 OUT NOCOPY jtf_varchar2_table_300,
1605 x_return_attribute2 OUT NOCOPY jtf_varchar2_table_300,
1606 x_return_attribute3 OUT NOCOPY jtf_varchar2_table_300,
1607 x_return_attribute4 OUT NOCOPY jtf_varchar2_table_300,
1608 x_return_attribute5 OUT NOCOPY jtf_varchar2_table_300,
1609 x_return_attribute6 OUT NOCOPY jtf_varchar2_table_300,
1610 x_return_attribute7 OUT NOCOPY jtf_varchar2_table_300,
1611 x_return_attribute8 OUT NOCOPY jtf_varchar2_table_300,
1612 x_return_attribute9 OUT NOCOPY jtf_varchar2_table_300,
1613 x_return_attribute10 OUT NOCOPY jtf_varchar2_table_300,
1614 x_return_attribute11 OUT NOCOPY jtf_varchar2_table_300,
1615 x_return_attribute15 OUT NOCOPY jtf_varchar2_table_300,
1616 x_return_attribute12 OUT NOCOPY jtf_varchar2_table_300,
1617 x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
1618 x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
1619 x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
1620 x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
1621 x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
1622 --*/
1623 );
1624
1625 PROCEDURE Set_Line_Rltship_Tbl_Out(
1626 p_qte_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type,
1627 x_line_relationship_id OUT NOCOPY jtf_number_table
1628
1629 /*-- The following output parameters are ignored
1630 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1631 x_creation_date OUT NOCOPY jtf_date_table,
1632 x_created_by OUT NOCOPY jtf_number_table,
1633 x_last_update_date OUT NOCOPY jtf_date_table,
1634 x_last_updated_by OUT NOCOPY jtf_number_table,
1635 x_last_update_login OUT NOCOPY jtf_number_table,
1636 x_request_id OUT NOCOPY jtf_number_table,
1637 x_program_application_id OUT NOCOPY jtf_number_table,
1638 x_program_id OUT NOCOPY jtf_number_table,
1639 x_program_update_date OUT NOCOPY jtf_date_table,
1640 x_quote_line_id OUT NOCOPY jtf_number_table,
1641 x_qte_line_index OUT NOCOPY jtf_number_table,
1642 x_related_quote_line_id OUT NOCOPY jtf_number_table,
1643 x_related_qte_line_index OUT NOCOPY jtf_number_table,
1644 x_relationship_type_code OUT NOCOPY jtf_varchar2_table_100,
1645 x_reciprocal_flag OUT NOCOPY jtf_varchar2_table_100
1646 --*/
1647 );
1648
1649 PROCEDURE Set_Payment_Tbl_Out(
1650 p_qte_payment_tbl IN ASO_Quote_Pub.Payment_Tbl_Type,
1651 x_payment_id OUT NOCOPY jtf_number_table
1652
1653 /*-- The following output parameters are ignored
1654 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1655 x_qte_line_index OUT NOCOPY jtf_number_table,
1656 x_shipment_index OUT NOCOPY jtf_number_table,
1657 x_creation_date OUT NOCOPY jtf_date_table,
1658 x_created_by OUT NOCOPY jtf_number_table,
1659 x_last_update_date OUT NOCOPY jtf_date_table,
1660 x_last_updated_by OUT NOCOPY jtf_number_table,
1661 x_last_update_login OUT NOCOPY jtf_number_table,
1662 x_request_id OUT NOCOPY jtf_number_table,
1663 x_program_application_id OUT NOCOPY jtf_number_table,
1664 x_program_id OUT NOCOPY jtf_number_table,
1665 x_program_update_date OUT NOCOPY jtf_date_table,
1666 x_quote_header_id OUT NOCOPY jtf_number_table,
1667 x_quote_line_id OUT NOCOPY jtf_number_table,
1668 x_quote_shipment_id OUT NOCOPY jtf_number_table,
1669 x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,
1670 x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
1671 x_payment_option OUT NOCOPY jtf_varchar2_table_300,
1672 x_payment_term_id OUT NOCOPY jtf_number_table,
1673 x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
1674 x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
1675 x_credit_card_exp_date OUT NOCOPY jtf_date_table,
1676 x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
1677 x_credit_card_approval_date OUT NOCOPY jtf_date_table,
1678 x_payment_amount OUT NOCOPY jtf_number_table,
1679 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1680 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1681 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1682 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1683 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1684 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1685 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1686 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1687 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1688 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1689 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1690 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1691 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1692 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1693 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1694 x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1695 x_cust_po_number OUT NOCOPY jtf_varchar2_table_100
1696 --*/
1697 );
1698
1699 PROCEDURE Set_Shipment_Tbl_Out(
1700 p_qte_shipment_tbl IN ASO_Quote_Pub.Shipment_Tbl_Type,
1701 x_shipment_id OUT NOCOPY jtf_number_table
1702
1703 /*-- The following output parameters are ignored
1704 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1705 x_qte_line_index OUT NOCOPY jtf_number_table,
1706 x_creation_date OUT NOCOPY jtf_date_table,
1707 x_created_by OUT NOCOPY jtf_number_table,
1708 x_last_update_date OUT NOCOPY jtf_date_table,
1709 x_last_updated_by OUT NOCOPY jtf_number_table,
1710 x_last_update_login OUT NOCOPY jtf_number_table,
1711 x_request_id OUT NOCOPY jtf_number_table,
1712 x_program_application_id OUT NOCOPY jtf_number_table,
1713 x_program_id OUT NOCOPY jtf_number_table,
1714 x_program_update_date OUT NOCOPY jtf_date_table,
1715 x_quote_header_id OUT NOCOPY jtf_number_table,
1716 x_quote_line_id OUT NOCOPY jtf_number_table,
1717 x_promise_date OUT NOCOPY jtf_date_table,
1718 x_request_date OUT NOCOPY jtf_date_table,
1719 x_schedule_ship_date OUT NOCOPY jtf_date_table,
1720 x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
1721 x_ship_to_party_id OUT NOCOPY jtf_number_table,
1722 x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
1723 x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
1724 x_ship_set_id OUT NOCOPY jtf_number_table,
1725 x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
1726 x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
1727 x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
1728 x_fob_code OUT NOCOPY jtf_varchar2_table_100,
1729 x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
1730 x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
1731 x_ship_quote_price OUT NOCOPY jtf_number_table,
1732 x_quantity OUT NOCOPY jtf_number_table,
1733 x_pricing_quantity OUT NOCOPY jtf_number_table,
1734 x_reserved_quantity OUT NOCOPY jtf_varchar2_table_300,
1735 x_reservation_id OUT NOCOPY jtf_number_table,
1736 x_order_line_id OUT NOCOPY jtf_number_table,
1737 x_ship_to_party_name OUT NOCOPY jtf_varchar2_table_300,
1738 x_ship_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
1739 x_ship_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
1740 x_ship_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
1741 x_ship_to_address1 OUT NOCOPY jtf_varchar2_table_300,
1742 x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1743 x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1744 x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1745 x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1746 x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1747 x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1748 x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1749 x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1750 x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1751 x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1752 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1753 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1754 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1755 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1756 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1757 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1758 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1759 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1760 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1761 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1762 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1763 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1764 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1765 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1766 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1767 x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1768 x_shipment_priority_code OUT NOCOPY jtf_varchar2_table_100,
1769 x_ship_from_org_id OUT NOCOPY jtf_number_table
1770 --*/
1771 );
1772
1773 PROCEDURE Set_Tax_Detail_Tbl_Out(
1774 p_qte_tax_detail_tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type,
1775 x_tax_detail_id OUT NOCOPY jtf_number_table
1776
1777 /*-- The following output parameters are ignored
1778 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1779 x_qte_line_index OUT NOCOPY jtf_number_table,
1780 x_shipment_index OUT NOCOPY jtf_number_table,
1781 x_quote_header_id OUT NOCOPY jtf_number_table,
1782 x_quote_line_id OUT NOCOPY jtf_number_table,
1783 x_quote_shipment_id OUT NOCOPY jtf_number_table,
1784 x_creation_date OUT NOCOPY jtf_date_table,
1785 x_created_by OUT NOCOPY jtf_number_table,
1786 x_last_update_date OUT NOCOPY jtf_date_table,
1787 x_last_updated_by OUT NOCOPY jtf_number_table,
1788 x_last_update_login OUT NOCOPY jtf_number_table,
1789 x_request_id OUT NOCOPY jtf_number_table,
1790 x_program_application_id OUT NOCOPY jtf_number_table,
1791 x_program_id OUT NOCOPY jtf_number_table,
1792 x_program_update_date OUT NOCOPY jtf_date_table,
1793 x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
1794 x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1795 x_tax_rate OUT NOCOPY jtf_number_table,
1796 x_tax_date OUT NOCOPY jtf_date_table,
1797 x_tax_amount OUT NOCOPY jtf_number_table,
1798 x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1799 x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1800 x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1801 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1802 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1803 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1804 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1805 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1806 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1807 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1808 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1809 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1810 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1811 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1812 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1813 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1814 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1815 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1816 x_attribute15 OUT NOCOPY jtf_varchar2_table_200
1817 --*/
1818 );
1819
1820 PROCEDURE Set_Price_Adj_Tbl_Out(
1821 p_qte_price_adj_tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type,
1822 x_price_adjustment_id OUT NOCOPY jtf_number_table
1823
1824 /*-- The following output parameters are ignored
1825 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1826 x_qte_line_index OUT NOCOPY jtf_number_table,
1827 x_shipment_index OUT NOCOPY jtf_number_table,
1828 x_creation_date OUT NOCOPY jtf_date_table,
1829 x_created_by OUT NOCOPY jtf_number_table,
1830 x_last_update_date OUT NOCOPY jtf_date_table,
1831 x_last_updated_by OUT NOCOPY jtf_number_table,
1832 x_last_update_login OUT NOCOPY jtf_number_table,
1833 x_program_application_id OUT NOCOPY jtf_number_table,
1834 x_program_id OUT NOCOPY jtf_number_table,
1835 x_program_update_date OUT NOCOPY jtf_date_table,
1836 x_request_id OUT NOCOPY jtf_number_table,
1837 x_quote_header_id OUT NOCOPY jtf_number_table,
1838 x_quote_line_id OUT NOCOPY jtf_number_table,
1839 x_quote_shipment_id OUT NOCOPY jtf_number_table,
1840 x_modifier_header_id OUT NOCOPY jtf_number_table,
1841 x_modifier_line_id OUT NOCOPY jtf_number_table,
1842 x_modifier_line_type_code OUT NOCOPY jtf_varchar2_table_100,
1843 x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
1844 x_modified_from OUT NOCOPY jtf_number_table,
1845 x_modified_to OUT NOCOPY jtf_number_table,
1846 x_operand OUT NOCOPY jtf_number_table,
1847 x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1848 x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1849 x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1850 x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1851 x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1852 x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1853 x_pricing_phase_id OUT NOCOPY jtf_number_table,
1854 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1855 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1856 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1857 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1858 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1859 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1860 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1861 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1862 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1863 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1864 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1865 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1866 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1867 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1868 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1869 x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1870 x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
1871 x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
1872 x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
1873 x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1874 x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1875 x_cost_id OUT NOCOPY jtf_number_table,
1876 x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1877 x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1878 x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1879 x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1880 x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1881 x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1882 x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1883 x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1884 x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1885 x_adjusted_amount OUT NOCOPY jtf_number_table,
1886 x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
1887 x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
1888 x_range_break_quantity OUT NOCOPY jtf_number_table,
1889 x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
1890 x_pricing_group_sequence OUT NOCOPY jtf_number_table,
1891 x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
1892 x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
1893 x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
1894 x_benefit_qty OUT NOCOPY jtf_number_table,
1895 x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1896 x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1897 x_expiration_date OUT NOCOPY jtf_date_table,
1898 x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1899 x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1900 x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1901 x_redeemed_date OUT NOCOPY jtf_date_table,
1902 x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1903 x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1904 x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1905 x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1906 x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1907 x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1908 x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
1909 --*/
1910 );
1911
1912 PROCEDURE Set_Price_Attributes_Tbl_Out(
1913 p_qte_price_attributes_tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type,
1914 x_price_attribute_id OUT NOCOPY jtf_number_table
1915
1916 /*-- The following output parameters are ignored
1917 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1918 x_qte_line_index OUT NOCOPY jtf_number_table,
1919 x_creation_date OUT NOCOPY jtf_date_table,
1920 x_created_by OUT NOCOPY jtf_number_table,
1921 x_last_update_date OUT NOCOPY jtf_date_table,
1922 x_last_updated_by OUT NOCOPY jtf_number_table,
1923 x_last_update_login OUT NOCOPY jtf_number_table,
1924 x_request_id OUT NOCOPY jtf_number_table,
1925 x_program_application_id OUT NOCOPY jtf_number_table,
1926 x_program_id OUT NOCOPY jtf_number_table,
1927 x_program_update_date OUT NOCOPY jtf_date_table,
1928 x_quote_header_id OUT NOCOPY jtf_number_table,
1929 x_quote_line_id OUT NOCOPY jtf_number_table,
1930 x_flex_title OUT NOCOPY jtf_varchar2_table_100,
1931 x_pricing_context OUT NOCOPY jtf_varchar2_table_100,
1932 x_pricing_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1933 x_pricing_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1934 x_pricing_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1935 x_pricing_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1936 x_pricing_attribute5 OUT NOCOPY jtf_varchar2_table_200,
1937 x_pricing_attribute6 OUT NOCOPY jtf_varchar2_table_200,
1938 x_pricing_attribute7 OUT NOCOPY jtf_varchar2_table_200,
1939 x_pricing_attribute8 OUT NOCOPY jtf_varchar2_table_200,
1940 x_pricing_attribute9 OUT NOCOPY jtf_varchar2_table_200,
1941 x_pricing_attribute10 OUT NOCOPY jtf_varchar2_table_200,
1942 x_pricing_attribute11 OUT NOCOPY jtf_varchar2_table_200,
1943 x_pricing_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1944 x_pricing_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1945 x_pricing_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1946 x_pricing_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1947 x_pricing_attribute16 OUT NOCOPY jtf_varchar2_table_200,
1948 x_pricing_attribute17 OUT NOCOPY jtf_varchar2_table_200,
1949 x_pricing_attribute18 OUT NOCOPY jtf_varchar2_table_200,
1950 x_pricing_attribute19 OUT NOCOPY jtf_varchar2_table_200,
1951 x_pricing_attribute20 OUT NOCOPY jtf_varchar2_table_200,
1952 x_pricing_attribute21 OUT NOCOPY jtf_varchar2_table_200,
1953 x_pricing_attribute22 OUT NOCOPY jtf_varchar2_table_200,
1954 x_pricing_attribute23 OUT NOCOPY jtf_varchar2_table_200,
1955 x_pricing_attribute24 OUT NOCOPY jtf_varchar2_table_200,
1956 x_pricing_attribute25 OUT NOCOPY jtf_varchar2_table_200,
1957 x_pricing_attribute26 OUT NOCOPY jtf_varchar2_table_200,
1958 x_pricing_attribute27 OUT NOCOPY jtf_varchar2_table_200,
1959 x_pricing_attribute28 OUT NOCOPY jtf_varchar2_table_200,
1960 x_pricing_attribute29 OUT NOCOPY jtf_varchar2_table_200,
1961 x_pricing_attribute30 OUT NOCOPY jtf_varchar2_table_200,
1962 x_pricing_attribute31 OUT NOCOPY jtf_varchar2_table_200,
1963 x_pricing_attribute32 OUT NOCOPY jtf_varchar2_table_200,
1964 x_pricing_attribute33 OUT NOCOPY jtf_varchar2_table_200,
1965 x_pricing_attribute34 OUT NOCOPY jtf_varchar2_table_200,
1966 x_pricing_attribute35 OUT NOCOPY jtf_varchar2_table_200,
1967 x_pricing_attribute36 OUT NOCOPY jtf_varchar2_table_200,
1968 x_pricing_attribute37 OUT NOCOPY jtf_varchar2_table_200,
1969 x_pricing_attribute38 OUT NOCOPY jtf_varchar2_table_200,
1970 x_pricing_attribute39 OUT NOCOPY jtf_varchar2_table_200,
1971 x_pricing_attribute40 OUT NOCOPY jtf_varchar2_table_200,
1972 x_pricing_attribute41 OUT NOCOPY jtf_varchar2_table_200,
1973 x_pricing_attribute42 OUT NOCOPY jtf_varchar2_table_200,
1974 x_pricing_attribute43 OUT NOCOPY jtf_varchar2_table_200,
1975 x_pricing_attribute44 OUT NOCOPY jtf_varchar2_table_200,
1976 x_pricing_attribute45 OUT NOCOPY jtf_varchar2_table_200,
1977 x_pricing_attribute46 OUT NOCOPY jtf_varchar2_table_200,
1978 x_pricing_attribute47 OUT NOCOPY jtf_varchar2_table_200,
1979 x_pricing_attribute48 OUT NOCOPY jtf_varchar2_table_200,
1980 x_pricing_attribute49 OUT NOCOPY jtf_varchar2_table_200,
1981 x_pricing_attribute50 OUT NOCOPY jtf_varchar2_table_200,
1982 x_pricing_attribute51 OUT NOCOPY jtf_varchar2_table_200,
1983 x_pricing_attribute52 OUT NOCOPY jtf_varchar2_table_200,
1984 x_pricing_attribute53 OUT NOCOPY jtf_varchar2_table_200,
1985 x_pricing_attribute54 OUT NOCOPY jtf_varchar2_table_200,
1986 x_pricing_attribute55 OUT NOCOPY jtf_varchar2_table_200,
1987 x_pricing_attribute56 OUT NOCOPY jtf_varchar2_table_200,
1988 x_pricing_attribute57 OUT NOCOPY jtf_varchar2_table_200,
1989 x_pricing_attribute58 OUT NOCOPY jtf_varchar2_table_200,
1990 x_pricing_attribute59 OUT NOCOPY jtf_varchar2_table_200,
1991 x_pricing_attribute60 OUT NOCOPY jtf_varchar2_table_200,
1992 x_pricing_attribute61 OUT NOCOPY jtf_varchar2_table_200,
1993 x_pricing_attribute62 OUT NOCOPY jtf_varchar2_table_200,
1994 x_pricing_attribute63 OUT NOCOPY jtf_varchar2_table_200,
1995 x_pricing_attribute64 OUT NOCOPY jtf_varchar2_table_200,
1996 x_pricing_attribute65 OUT NOCOPY jtf_varchar2_table_200,
1997 x_pricing_attribute66 OUT NOCOPY jtf_varchar2_table_200,
1998 x_pricing_attribute67 OUT NOCOPY jtf_varchar2_table_200,
1999 x_pricing_attribute68 OUT NOCOPY jtf_varchar2_table_200,
2000 x_pricing_attribute69 OUT NOCOPY jtf_varchar2_table_200,
2001 x_pricing_attribute70 OUT NOCOPY jtf_varchar2_table_200,
2002 x_pricing_attribute71 OUT NOCOPY jtf_varchar2_table_200,
2003 x_pricing_attribute72 OUT NOCOPY jtf_varchar2_table_200,
2004 x_pricing_attribute73 OUT NOCOPY jtf_varchar2_table_200,
2005 x_pricing_attribute74 OUT NOCOPY jtf_varchar2_table_200,
2006 x_pricing_attribute75 OUT NOCOPY jtf_varchar2_table_200,
2007 x_pricing_attribute76 OUT NOCOPY jtf_varchar2_table_200,
2008 x_pricing_attribute77 OUT NOCOPY jtf_varchar2_table_200,
2009 x_pricing_attribute78 OUT NOCOPY jtf_varchar2_table_200,
2010 x_pricing_attribute79 OUT NOCOPY jtf_varchar2_table_200,
2011 x_pricing_attribute80 OUT NOCOPY jtf_varchar2_table_200,
2012 x_pricing_attribute81 OUT NOCOPY jtf_varchar2_table_200,
2013 x_pricing_attribute82 OUT NOCOPY jtf_varchar2_table_200,
2014 x_pricing_attribute83 OUT NOCOPY jtf_varchar2_table_200,
2015 x_pricing_attribute84 OUT NOCOPY jtf_varchar2_table_200,
2016 x_pricing_attribute85 OUT NOCOPY jtf_varchar2_table_200,
2017 x_pricing_attribute86 OUT NOCOPY jtf_varchar2_table_200,
2018 x_pricing_attribute87 OUT NOCOPY jtf_varchar2_table_200,
2019 x_pricing_attribute88 OUT NOCOPY jtf_varchar2_table_200,
2020 x_pricing_attribute89 OUT NOCOPY jtf_varchar2_table_200,
2021 x_pricing_attribute90 OUT NOCOPY jtf_varchar2_table_200,
2022 x_pricing_attribute91 OUT NOCOPY jtf_varchar2_table_200,
2023 x_pricing_attribute92 OUT NOCOPY jtf_varchar2_table_200,
2024 x_pricing_attribute93 OUT NOCOPY jtf_varchar2_table_200,
2025 x_pricing_attribute94 OUT NOCOPY jtf_varchar2_table_200,
2026 x_pricing_attribute95 OUT NOCOPY jtf_varchar2_table_200,
2027 x_pricing_attribute96 OUT NOCOPY jtf_varchar2_table_200,
2028 x_pricing_attribute97 OUT NOCOPY jtf_varchar2_table_200,
2029 x_pricing_attribute98 OUT NOCOPY jtf_varchar2_table_200,
2030 x_pricing_attribute99 OUT NOCOPY jtf_varchar2_table_200,
2031 x_pricing_attribute100 OUT NOCOPY jtf_varchar2_table_200,
2032 x_context OUT NOCOPY jtf_varchar2_table_100,
2033 x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
2034 x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
2035 x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
2036 x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
2037 x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
2038 x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
2039 x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
2040 x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
2041 x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
2042 x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
2043 x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
2044 x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
2045 x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
2046 x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
2047 x_attribute15 OUT NOCOPY jtf_varchar2_table_200
2048 --*/
2049 );
2050
2051 PROCEDURE Set_Sales_Credit_Tbl_Out(
2052 p_qte_sales_credit_tbl IN ASO_Quote_Pub.Sales_Credit_Tbl_Type,
2053 x_sales_credit_id OUT NOCOPY jtf_number_table
2054
2055 /*-- The following output parameters are ignored
2056 x_qte_line_index OUT NOCOPY jtf_number_table,
2057 x_operation_code OUT NOCOPY jtf_varchar2_table_100,
2058 x_creation_date OUT NOCOPY jtf_date_table,
2059 x_created_by OUT NOCOPY jtf_number_table,
2060 x_last_updated_by OUT NOCOPY jtf_number_table,
2061 x_last_update_date OUT NOCOPY jtf_date_table,
2062 x_last_update_login OUT NOCOPY jtf_number_table,
2063 x_request_id OUT NOCOPY jtf_number_table,
2064 x_program_application_id OUT NOCOPY jtf_number_table,
2065 x_program_id OUT NOCOPY jtf_number_table,
2066 x_program_update_date OUT NOCOPY jtf_date_table,
2067 x_quote_header_id OUT NOCOPY jtf_number_table,
2068 x_quote_line_id OUT NOCOPY jtf_number_table,
2069 x_percent OUT NOCOPY jtf_number_table,
2070 x_resource_id OUT NOCOPY jtf_number_table,
2071 x_first_name OUT NOCOPY jtf_varchar2_table_300,
2072 x_last_name OUT NOCOPY jtf_varchar2_table_300,
2073 x_sales_credit_type OUT NOCOPY jtf_varchar2_table_300,
2074 x_resource_group_id OUT NOCOPY jtf_number_table,
2075 x_employee_person_id OUT NOCOPY jtf_number_table,
2076 x_sales_credit_type_id OUT NOCOPY jtf_number_table,
2077 x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
2078 x_attribute1 OUT NOCOPY jtf_varchar2_table_300,
2079 x_attribute2 OUT NOCOPY jtf_varchar2_table_300,
2080 x_attribute3 OUT NOCOPY jtf_varchar2_table_300,
2081 x_attribute4 OUT NOCOPY jtf_varchar2_table_300,
2082 x_attribute5 OUT NOCOPY jtf_varchar2_table_300,
2083 x_attribute6 OUT NOCOPY jtf_varchar2_table_300,
2084 x_attribute7 OUT NOCOPY jtf_varchar2_table_300,
2085 x_attribute8 OUT NOCOPY jtf_varchar2_table_300,
2086 x_attribute9 OUT NOCOPY jtf_varchar2_table_300,
2087 x_attribute10 OUT NOCOPY jtf_varchar2_table_300,
2088 x_attribute11 OUT NOCOPY jtf_varchar2_table_300,
2089 x_attribute12 OUT NOCOPY jtf_varchar2_table_300,
2090 x_attribute13 OUT NOCOPY jtf_varchar2_table_300,
2091 x_attribute14 OUT NOCOPY jtf_varchar2_table_300,
2092 x_attribute15 OUT NOCOPY jtf_varchar2_table_300
2093 --*/
2094 );
2095
2096 PROCEDURE Set_Approvers_List_Tbl_Out(
2097 p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,
2098 x_approval_det_id OUT NOCOPY jtf_number_table,
2099 x_object_approval_id OUT NOCOPY jtf_number_table,
2100 x_approver_person_id OUT NOCOPY jtf_number_table,
2101 x_approver_user_id OUT NOCOPY jtf_number_table,
2102 x_notification_id OUT NOCOPY jtf_number_table,
2103 x_approver_sequence OUT NOCOPY jtf_number_table,
2104 x_approver_status OUT NOCOPY jtf_varchar2_table_100,
2105 x_approver_name OUT NOCOPY jtf_varchar2_table_100,
2106 x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
2107 x_date_sent OUT NOCOPY jtf_date_table,
2108 x_date_received OUT NOCOPY jtf_date_table
2109 );
2110
2111 PROCEDURE Set_Rules_List_Tbl_Out(
2112 p_qte_rules_list_tbl IN ASO_Apr_Pub.Rules_List_Tbl_Type,
2113 x_rule_id OUT NOCOPY jtf_number_table,
2114 x_object_approval_id OUT NOCOPY jtf_number_table,
2115 x_rule_action_id OUT NOCOPY jtf_number_table,
2116 x_rule_description OUT NOCOPY jtf_varchar2_table_300,
2117 x_approval_level OUT NOCOPY jtf_varchar2_table_300
2118 );
2119
2120 PROCEDURE Set_Opp_Qte_Out_Rec_Out(
2121 p_opp_qte_out_rec IN ASO_Opp_Qte_Pub.Opp_Qte_Out_Rec_Type,
2122 x_quote_header_id OUT NOCOPY NUMBER ,
2123 x_quote_number OUT NOCOPY NUMBER ,
2124 x_related_object_id OUT NOCOPY NUMBER ,
2125 x_cust_account_id OUT NOCOPY NUMBER ,
2126 x_party_id OUT NOCOPY NUMBER ,
2127 x_currency_code OUT NOCOPY VARCHAR2
2128 );
2129
2130 PROCEDURE Set_Qte_Access_Tbl_Out(
2131 p_qte_access_tbl IN ASO_Quote_Pub.Qte_Access_Tbl_Type,
2132 x_access_id OUT NOCOPY jtf_number_table
2133 );
2134
2135 PROCEDURE Set_Template_Tbl_Out(
2136 p_template_tbl IN ASO_Quote_Pub.Template_Tbl_Type,
2137 x_template_id OUT NOCOPY jtf_number_table
2138 );
2139
2140 PROCEDURE Set_Atp_Tbl_Out (
2141 p_atp_tbl IN ASO_ATP_INT.Atp_Tbl_Typ,
2142 x_inventory_item_id OUT NOCOPY JTF_NUMBER_TABLE,
2143 x_inventory_item_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
2144 x_inventory_item_description OUT NOCOPY JTF_VARCHAR2_TABLE_300,
2145 x_padded_concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_300,
2146 x_source_organization_id OUT NOCOPY JTF_NUMBER_TABLE,
2147 x_source_organization_code OUT NOCOPY JTF_VARCHAR2_TABLE_300,
2148 x_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
2149 x_identifier OUT NOCOPY JTF_NUMBER_TABLE,
2150 x_customer_id OUT NOCOPY JTF_NUMBER_TABLE,
2151 x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
2152 x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
2153 x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2154 x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2155 x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
2156 x_ship_date OUT NOCOPY JTF_DATE_TABLE,
2157 x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2158 x_request_date_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2159 x_error_code OUT NOCOPY JTF_NUMBER_TABLE,
2160 x_message OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2161 x_request_date_type OUT NOCOPY jtf_varchar2_table_300,
2162 x_request_date_type_meaning OUT NOCOPY jtf_varchar2_table_300,
2163 x_demand_class_code OUT NOCOPY jtf_varchar2_table_300,
2164 x_demand_class_meaning OUT NOCOPY jtf_varchar2_table_300,
2165 x_ship_set_name OUT NOCOPY jtf_varchar2_table_300,
2166 x_arrival_set_name OUT NOCOPY jtf_varchar2_table_300,
2167 x_line_number OUT NOCOPY jtf_varchar2_table_800,
2168 x_group_ship_date OUT NOCOPY jtf_date_table,
2169 x_requested_arrival_date OUT NOCOPY jtf_date_table,
2170 x_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
2171 x_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
2172 x_quantity_on_hand OUT NOCOPY jtf_number_table,
2173 x_quote_header_id OUT NOCOPY jtf_number_table,
2174 x_calling_module OUT NOCOPY jtf_number_table,
2175 x_quote_number OUT NOCOPY jtf_number_table,
2176 x_ato_line_id OUT NOCOPY jtf_number_table,
2177 x_ref_line_id OUT NOCOPY jtf_number_table,
2178 x_top_model_line_id OUT NOCOPY jtf_number_table,
2179 x_action OUT NOCOPY jtf_number_table,
2180 x_arrival_date OUT NOCOPY jtf_date_table,
2181 x_organization_id OUT NOCOPY jtf_number_table,
2182 x_component_code OUT NOCOPY jtf_varchar2_table_1200,
2183 x_component_sequence_id OUT NOCOPY jtf_number_table,
2184 x_included_item_flag OUT NOCOPY jtf_number_table,
2185 x_cascade_model_info_to_comp OUT NOCOPY jtf_number_table,
2186 x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
2187 x_country OUT NOCOPY jtf_varchar2_table_600,
2188 x_state OUT NOCOPY jtf_varchar2_table_600,
2189 x_city OUT NOCOPY jtf_varchar2_table_600,
2190 x_postal_code OUT NOCOPY jtf_varchar2_table_600,
2191 x_match_item_id OUT NOCOPY jtf_number_table
2192 );
2193
2194
2195 PROCEDURE setOrgIdForNotifUserId(
2196 p_apvl_orgid IN NUMBER,
2197 p_apvl_notifId IN NUMBER,
2198 p_login_userid IN NUMBER,
2199 x_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2200 );
2201 FUNCTION Construct_Template_Tbl(
2202 p_template_id IN jtf_number_table := NULL
2203 )
2204 RETURN ASO_Quote_Pub.Template_Tbl_Type;
2205
2206 FUNCTION Construct_Template_Rec(
2207 p_template_id IN NUMBER := FND_API.G_MISS_NUM
2208 )
2209 RETURN ASO_Quote_Pub.Template_Rec_Type;
2210
2211
2212 FUNCTION Construct_Trigger_Attr_Tbl(
2213 p_trigger_attribute IN jtf_varchar2_table_100 := NULL
2214 )
2215 RETURN ASO_Defaulting_Int.Attribute_Codes_Tbl_Type;
2216
2217
2218 FUNCTION Construct_Hdr_Misc_Rec(
2219 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR
2220 )
2221 RETURN ASO_Defaulting_Int.Header_Misc_Rec_Type;
2222
2223
2224 FUNCTION Construct_Ln_Misc_Rec(
2225 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR
2226 )
2227 RETURN ASO_Defaulting_Int.Line_Misc_Rec_Type;
2228
2229
2230 PROCEDURE Set_Qte_header_rec_Out(
2231 p_qte_header_rec IN ASO_Quote_Pub.Qte_header_rec_Type,
2232 x_q_quote_header_id OUT NOCOPY NUMBER,
2233 x_q_creation_date OUT NOCOPY DATE,
2234 x_q_created_by OUT NOCOPY NUMBER,
2235 x_q_last_updated_by OUT NOCOPY NUMBER,
2236 x_q_last_update_date OUT NOCOPY DATE,
2237 x_q_last_update_login OUT NOCOPY NUMBER,
2238 x_q_request_id OUT NOCOPY NUMBER,
2239 x_q_program_application_id OUT NOCOPY NUMBER,
2240 x_q_program_id OUT NOCOPY NUMBER,
2241 x_q_program_update_date OUT NOCOPY DATE,
2242 x_q_org_id OUT NOCOPY NUMBER,
2243 x_q_quote_name OUT NOCOPY VARCHAR2,
2244 x_q_quote_number OUT NOCOPY NUMBER,
2245 x_q_quote_version OUT NOCOPY NUMBER,
2246 x_q_quote_status_id OUT NOCOPY NUMBER,
2247 x_q_quote_source_code OUT NOCOPY VARCHAR2,
2248 x_q_quote_expiration_date OUT NOCOPY DATE,
2249 x_q_price_frozen_date OUT NOCOPY DATE,
2250 x_q_quote_password OUT NOCOPY VARCHAR2,
2251 x_q_original_system_reference OUT NOCOPY VARCHAR2,
2252 x_q_party_id OUT NOCOPY NUMBER,
2253 x_q_cust_account_id OUT NOCOPY NUMBER,
2254 x_q_invoice_to_cust_acct_id OUT NOCOPY NUMBER,
2255 x_q_org_contact_id OUT NOCOPY NUMBER,
2256 x_q_party_name OUT NOCOPY VARCHAR2,
2257 x_q_party_type OUT NOCOPY VARCHAR2,
2258 x_q_person_first_name OUT NOCOPY VARCHAR2,
2259 x_q_person_last_name OUT NOCOPY VARCHAR2,
2260 x_q_person_middle_name OUT NOCOPY VARCHAR2,
2261 x_q_phone_id OUT NOCOPY NUMBER,
2262 x_q_price_list_id OUT NOCOPY NUMBER,
2263 x_q_price_list_name OUT NOCOPY VARCHAR2,
2264 x_q_currency_code OUT NOCOPY VARCHAR2,
2265 x_q_total_list_price OUT NOCOPY NUMBER,
2266 x_q_total_adjusted_amount OUT NOCOPY NUMBER,
2267 x_q_total_adjusted_percent OUT NOCOPY NUMBER,
2268 x_q_total_tax OUT NOCOPY NUMBER,
2269 x_q_total_shipping_charge OUT NOCOPY NUMBER,
2270 x_q_surcharge OUT NOCOPY NUMBER,
2271 x_q_total_quote_price OUT NOCOPY NUMBER,
2272 x_q_payment_amount OUT NOCOPY NUMBER,
2273 x_q_accounting_rule_id OUT NOCOPY NUMBER,
2274 x_q_exchange_rate OUT NOCOPY NUMBER,
2275 x_q_exchange_type_code OUT NOCOPY VARCHAR2,
2276 x_q_exchange_rate_date OUT NOCOPY DATE,
2277 x_q_quote_category_code OUT NOCOPY VARCHAR2,
2278 x_q_quote_status_code OUT NOCOPY VARCHAR2,
2279 x_q_quote_status OUT NOCOPY VARCHAR2,
2280 x_q_employee_person_id OUT NOCOPY NUMBER,
2281 x_q_sales_channel_code OUT NOCOPY VARCHAR2,
2282 x_q_salesrep_first_name OUT NOCOPY VARCHAR2,
2283 x_q_salesrep_last_name OUT NOCOPY VARCHAR2,
2284 x_q_attribute_category OUT NOCOPY VARCHAR2,
2285 x_q_attribute1 OUT NOCOPY VARCHAR2,
2286 x_q_attribute10 OUT NOCOPY VARCHAR2,
2287 x_q_attribute11 OUT NOCOPY VARCHAR2,
2288 x_q_attribute12 OUT NOCOPY VARCHAR2,
2289 x_q_attribute13 OUT NOCOPY VARCHAR2,
2290 x_q_attribute14 OUT NOCOPY VARCHAR2,
2291 x_q_attribute15 OUT NOCOPY VARCHAR2,
2292 x_q_attribute16 OUT NOCOPY VARCHAR2,
2293 x_q_attribute17 OUT NOCOPY VARCHAR2,
2294 x_q_attribute18 OUT NOCOPY VARCHAR2,
2295 x_q_attribute19 OUT NOCOPY VARCHAR2,
2296 x_q_attribute20 OUT NOCOPY VARCHAR2,
2297 x_q_attribute2 OUT NOCOPY VARCHAR2,
2298 x_q_attribute3 OUT NOCOPY VARCHAR2,
2299 x_q_attribute4 OUT NOCOPY VARCHAR2,
2300 x_q_attribute5 OUT NOCOPY VARCHAR2,
2301 x_q_attribute6 OUT NOCOPY VARCHAR2,
2302 x_q_attribute7 OUT NOCOPY VARCHAR2,
2303 x_q_attribute8 OUT NOCOPY VARCHAR2,
2304 x_q_attribute9 OUT NOCOPY VARCHAR2,
2305 x_q_contract_id OUT NOCOPY NUMBER,
2306 x_q_qte_contract_id OUT NOCOPY NUMBER,
2307 x_q_ffm_request_id OUT NOCOPY NUMBER,
2308 x_q_invoice_to_address1 OUT NOCOPY VARCHAR2,
2309 x_q_invoice_to_address2 OUT NOCOPY VARCHAR2,
2310 x_q_invoice_to_address3 OUT NOCOPY VARCHAR2,
2311 x_q_invoice_to_address4 OUT NOCOPY VARCHAR2,
2312 x_q_invoice_to_city OUT NOCOPY VARCHAR2,
2313 x_q_invoice_to_cont_first_name OUT NOCOPY VARCHAR2,
2314 x_q_invoice_to_cont_last_name OUT NOCOPY VARCHAR2,
2315 x_q_invoice_to_cont_mid_name OUT NOCOPY VARCHAR2,
2316 x_q_invoice_to_country_code OUT NOCOPY VARCHAR2,
2317 x_q_invoice_to_country OUT NOCOPY VARCHAR2,
2318 x_q_invoice_to_county OUT NOCOPY VARCHAR2,
2319 x_q_invoice_to_party_id OUT NOCOPY NUMBER,
2320 x_q_invoice_to_party_name OUT NOCOPY VARCHAR2,
2321 x_q_invoice_to_party_site_id OUT NOCOPY NUMBER,
2322 x_q_invoice_to_postal_code OUT NOCOPY VARCHAR2,
2323 x_q_invoice_to_province OUT NOCOPY VARCHAR2,
2324 x_q_invoice_to_state OUT NOCOPY VARCHAR2,
2325 x_q_invoicing_rule_id OUT NOCOPY NUMBER,
2326 x_q_marketing_source_code_id OUT NOCOPY NUMBER,
2327 x_q_marketing_source_code OUT NOCOPY VARCHAR2,
2328 x_q_marketing_source_name OUT NOCOPY VARCHAR2,
2329 x_q_orig_mktg_source_code_id OUT NOCOPY NUMBER,
2330 x_q_order_type_id OUT NOCOPY NUMBER,
2331 x_q_order_id OUT NOCOPY NUMBER,
2332 x_q_order_number OUT NOCOPY NUMBER,
2333 x_q_order_type_name OUT NOCOPY VARCHAR2,
2334 x_q_ordered_date OUT NOCOPY DATE,
2335 x_q_resource_id OUT NOCOPY NUMBER,
2336 x_q_contract_template_id OUT NOCOPY NUMBER,
2337 x_q_contract_template_maj_ver OUT NOCOPY NUMBER,
2338 x_q_contract_requester_id OUT NOCOPY NUMBER,
2339 x_q_contract_approval_level OUT NOCOPY VARCHAR2,
2340 x_q_publish_flag OUT NOCOPY VARCHAR2,
2341 x_q_resource_grp_id OUT NOCOPY NUMBER,
2342 x_q_sold_to_party_site_id OUT NOCOPY NUMBER,
2343 x_q_display_arithmetic_op OUT NOCOPY VARCHAR2,
2344 x_q_quote_description OUT NOCOPY VARCHAR2,
2345 x_q_quote_type OUT NOCOPY VARCHAR2,
2346 x_q_minisite_id OUT NOCOPY NUMBER,
2347 x_q_cust_party_id OUT NOCOPY NUMBER,
2348 x_q_invoice_to_cust_party_id OUT NOCOPY NUMBER,
2349 x_q_pricing_status_indicator OUT NOCOPY VARCHAR2,
2350 x_q_tax_status_indicator OUT NOCOPY VARCHAR2,
2351 x_q_price_updated_date OUT NOCOPY DATE,
2352 x_q_tax_updated_date OUT NOCOPY DATE,
2353 x_q_recalculate_flag OUT NOCOPY VARCHAR2,
2354 x_q_price_request_id OUT NOCOPY NUMBER,
2355 x_q_credit_update_date OUT NOCOPY DATE,
2356 x_q_customer_name_and_title OUT NOCOPY VARCHAR2,
2357 x_q_customer_signature_date OUT NOCOPY DATE,
2358 x_q_supplier_name_and_title OUT NOCOPY VARCHAR2,
2359 x_q_supplier_signature_date OUT NOCOPY DATE,
2360 x_q_end_cust_party_id OUT NOCOPY NUMBER,
2361 x_q_end_cust_party_site_id OUT NOCOPY NUMBER,
2362 x_q_end_cust_cust_account_id OUT NOCOPY NUMBER,
2363 x_q_end_cust_cust_party_id OUT NOCOPY NUMBER,
2364 x_q_automatic_price_flag OUT NOCOPY VARCHAR2,
2365 x_q_automatic_tax_flag OUT NOCOPY VARCHAR2,
2366 x_q_assistance_requested OUT NOCOPY VARCHAR2,
2367 x_q_assistance_reason_code OUT NOCOPY VARCHAR2,
2368 x_q_object_version_number OUT NOCOPY NUMBER,
2369 x_q_header_paynow_charges OUT NOCOPY NUMBER
2370 );
2371
2372
2373 PROCEDURE Set_Shipment_rec_Out(
2374 p_shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type,
2375 x_qs_operation_code OUT NOCOPY VARCHAR2,
2376 x_qs_qte_line_index OUT NOCOPY NUMBER,
2377 x_qs_shipment_id OUT NOCOPY NUMBER,
2378 x_qs_creation_date OUT NOCOPY DATE,
2379 x_qs_created_by OUT NOCOPY NUMBER,
2380 x_qs_last_update_date OUT NOCOPY DATE,
2381 x_qs_last_updated_by OUT NOCOPY NUMBER,
2382 x_qs_last_update_login OUT NOCOPY NUMBER,
2383 x_qs_request_id OUT NOCOPY NUMBER,
2384 x_qs_program_application_id OUT NOCOPY NUMBER,
2385 x_qs_program_id OUT NOCOPY NUMBER,
2386 x_qs_program_update_date OUT NOCOPY DATE,
2387 x_qs_quote_header_id OUT NOCOPY NUMBER,
2388 x_qs_quote_line_id OUT NOCOPY NUMBER,
2389 x_qs_promise_date OUT NOCOPY DATE,
2390 x_qs_request_date OUT NOCOPY DATE,
2391 x_qs_schedule_ship_date OUT NOCOPY DATE,
2392 x_qs_ship_to_party_site_id OUT NOCOPY NUMBER,
2393 x_qs_ship_to_party_id OUT NOCOPY NUMBER,
2394 x_qs_ship_to_cust_account_id OUT NOCOPY NUMBER,
2395 x_qs_ship_partial_flag OUT NOCOPY VARCHAR2,
2396 x_qs_ship_set_id OUT NOCOPY NUMBER,
2397 x_qs_ship_method_code OUT NOCOPY VARCHAR2,
2398 x_qs_freight_terms_code OUT NOCOPY VARCHAR2,
2399 x_qs_freight_carrier_code OUT NOCOPY VARCHAR2,
2400 x_qs_fob_code OUT NOCOPY VARCHAR2,
2401 x_qs_shipping_instructions OUT NOCOPY VARCHAR2,
2402 x_qs_packing_instructions OUT NOCOPY VARCHAR2,
2403 x_qs_quantity OUT NOCOPY NUMBER,
2404 x_qs_reserved_quantity OUT NOCOPY VARCHAR2,
2405 x_qs_reservation_id OUT NOCOPY NUMBER,
2406 x_qs_order_line_id OUT NOCOPY NUMBER,
2407 x_qs_ship_to_party_name OUT NOCOPY VARCHAR2,
2408 x_qs_ship_to_cont_first_name OUT NOCOPY VARCHAR2,
2409 x_qs_ship_to_cont_mid_name OUT NOCOPY VARCHAR2,
2410 x_qs_ship_to_cont_last_name OUT NOCOPY VARCHAR2,
2411 x_qs_ship_to_address1 OUT NOCOPY VARCHAR2,
2412 x_qs_ship_to_address2 OUT NOCOPY VARCHAR2,
2413 x_qs_ship_to_address3 OUT NOCOPY VARCHAR2,
2414 x_qs_ship_to_address4 OUT NOCOPY VARCHAR2,
2415 x_qs_ship_to_country_code OUT NOCOPY VARCHAR2,
2416 x_qs_ship_to_country OUT NOCOPY VARCHAR2,
2417 x_qs_ship_to_city OUT NOCOPY VARCHAR2,
2418 x_qs_ship_to_postal_code OUT NOCOPY VARCHAR2,
2419 x_qs_ship_to_state OUT NOCOPY VARCHAR2,
2420 x_qs_ship_to_province OUT NOCOPY VARCHAR2,
2421 x_qs_ship_to_county OUT NOCOPY VARCHAR2,
2422 x_qs_attribute_category OUT NOCOPY VARCHAR2,
2423 x_qs_attribute1 OUT NOCOPY VARCHAR2,
2424 x_qs_attribute2 OUT NOCOPY VARCHAR2,
2425 x_qs_attribute3 OUT NOCOPY VARCHAR2,
2426 x_qs_attribute4 OUT NOCOPY VARCHAR2,
2427 x_qs_attribute5 OUT NOCOPY VARCHAR2,
2428 x_qs_attribute6 OUT NOCOPY VARCHAR2,
2429 x_qs_attribute7 OUT NOCOPY VARCHAR2,
2430 x_qs_attribute8 OUT NOCOPY VARCHAR2,
2431 x_qs_attribute9 OUT NOCOPY VARCHAR2,
2432 x_qs_attribute10 OUT NOCOPY VARCHAR2,
2433 x_qs_attribute11 OUT NOCOPY VARCHAR2,
2434 x_qs_attribute12 OUT NOCOPY VARCHAR2,
2435 x_qs_attribute13 OUT NOCOPY VARCHAR2,
2436 x_qs_attribute14 OUT NOCOPY VARCHAR2,
2437 x_qs_attribute15 OUT NOCOPY VARCHAR2,
2438 x_qs_attribute16 OUT NOCOPY VARCHAR2,
2439 x_qs_attribute17 OUT NOCOPY VARCHAR2,
2440 x_qs_attribute18 OUT NOCOPY VARCHAR2,
2441 x_qs_attribute19 OUT NOCOPY VARCHAR2,
2442 x_qs_attribute20 OUT NOCOPY VARCHAR2,
2443 x_qs_ship_quote_price OUT NOCOPY NUMBER,
2444 x_qs_pricing_quantity OUT NOCOPY NUMBER,
2445 x_qs_shipment_priority_code OUT NOCOPY VARCHAR2,
2446 x_qs_ship_from_org_id OUT NOCOPY NUMBER,
2447 x_qs_ship_to_cust_party_id OUT NOCOPY NUMBER,
2448 x_qs_request_date_type OUT NOCOPY VARCHAR2,
2449 x_qs_demand_class_code OUT NOCOPY VARCHAR2,
2450 x_qs_object_version_number OUT NOCOPY NUMBER
2451 );
2452
2453 PROCEDURE Set_Payment_rec_Out(
2454 p_payment_rec IN ASO_Quote_Pub.Payment_rec_Type,
2455 x_qp_operation_code OUT NOCOPY VARCHAR2,
2456 x_qp_qte_line_index OUT NOCOPY NUMBER,
2457 x_qp_payment_id OUT NOCOPY NUMBER,
2458 x_qp_creation_date OUT NOCOPY DATE,
2459 x_qp_created_by OUT NOCOPY NUMBER,
2460 x_qp_last_update_date OUT NOCOPY DATE,
2461 x_qp_last_updated_by OUT NOCOPY NUMBER,
2462 x_qp_last_update_login OUT NOCOPY NUMBER,
2463 x_qp_request_id OUT NOCOPY NUMBER,
2464 x_qp_program_application_id OUT NOCOPY NUMBER,
2465 x_qp_program_id OUT NOCOPY NUMBER,
2466 x_qp_program_update_date OUT NOCOPY DATE,
2467 x_qp_quote_header_id OUT NOCOPY NUMBER,
2468 x_qp_quote_line_id OUT NOCOPY NUMBER,
2469 x_qp_payment_type_code OUT NOCOPY VARCHAR2,
2470 x_qp_payment_ref_number OUT NOCOPY VARCHAR2,
2471 x_qp_payment_option OUT NOCOPY VARCHAR2,
2472 x_qp_payment_term_id OUT NOCOPY NUMBER,
2473 x_qp_credit_card_code OUT NOCOPY VARCHAR2,
2474 x_qp_credit_card_holder_name OUT NOCOPY VARCHAR2,
2475 x_qp_credit_card_exp_date OUT NOCOPY DATE,
2476 x_qp_credit_card_aprv_code OUT NOCOPY VARCHAR2,
2477 x_qp_credit_card_aprv_date OUT NOCOPY DATE,
2478 x_qp_payment_amount OUT NOCOPY NUMBER,
2479 x_qp_attribute_category OUT NOCOPY VARCHAR2,
2480 x_qp_attribute1 OUT NOCOPY VARCHAR2,
2481 x_qp_attribute2 OUT NOCOPY VARCHAR2,
2482 x_qp_attribute3 OUT NOCOPY VARCHAR2,
2483 x_qp_attribute4 OUT NOCOPY VARCHAR2,
2484 x_qp_attribute5 OUT NOCOPY VARCHAR2,
2485 x_qp_attribute6 OUT NOCOPY VARCHAR2,
2486 x_qp_attribute7 OUT NOCOPY VARCHAR2,
2487 x_qp_attribute8 OUT NOCOPY VARCHAR2,
2488 x_qp_attribute9 OUT NOCOPY VARCHAR2,
2489 x_qp_attribute10 OUT NOCOPY VARCHAR2,
2490 x_qp_attribute11 OUT NOCOPY VARCHAR2,
2491 x_qp_attribute12 OUT NOCOPY VARCHAR2,
2492 x_qp_attribute13 OUT NOCOPY VARCHAR2,
2493 x_qp_attribute14 OUT NOCOPY VARCHAR2,
2494 x_qp_attribute15 OUT NOCOPY VARCHAR2,
2495 x_qp_attribute16 OUT NOCOPY VARCHAR2,
2496 x_qp_attribute17 OUT NOCOPY VARCHAR2,
2497 x_qp_attribute18 OUT NOCOPY VARCHAR2,
2498 x_qp_attribute19 OUT NOCOPY VARCHAR2,
2499 x_qp_attribute20 OUT NOCOPY VARCHAR2,
2500 x_qp_shipment_index OUT NOCOPY NUMBER,
2501 x_qp_quote_shipment_id OUT NOCOPY NUMBER,
2502 x_qp_cust_po_number OUT NOCOPY VARCHAR2,
2503 x_qp_cust_po_line_number OUT NOCOPY VARCHAR2,
2504 x_qp_object_version_number OUT NOCOPY NUMBER,
2505 x_qp_trxn_extension_id OUT NOCOPY NUMBER,
2506 x_qp_instrument_id OUT NOCOPY NUMBER,
2507 x_qp_instr_assignment_id OUT NOCOPY NUMBER,
2508 x_qp_cvv2 OUT NOCOPY VARCHAR2
2509 );
2510
2511
2512 PROCEDURE Set_Tax_detail_rec_Out(
2513 p_tax_detail_rec IN ASO_Quote_Pub.Tax_detail_rec_Type,
2514 x_qt_operation_code OUT NOCOPY VARCHAR2,
2515 x_qt_qte_line_index OUT NOCOPY NUMBER,
2516 x_qt_shipment_index OUT NOCOPY NUMBER,
2517 x_qt_tax_detail_id OUT NOCOPY NUMBER,
2518 x_qt_quote_header_id OUT NOCOPY NUMBER,
2519 x_qt_quote_line_id OUT NOCOPY NUMBER,
2520 x_qt_quote_shipment_id OUT NOCOPY NUMBER,
2521 x_qt_creation_date OUT NOCOPY DATE,
2522 x_qt_created_by OUT NOCOPY NUMBER,
2523 x_qt_last_update_date OUT NOCOPY DATE,
2524 x_qt_last_updated_by OUT NOCOPY NUMBER,
2525 x_qt_last_update_login OUT NOCOPY NUMBER,
2526 x_qt_request_id OUT NOCOPY NUMBER,
2527 x_qt_program_application_id OUT NOCOPY NUMBER,
2528 x_qt_program_id OUT NOCOPY NUMBER,
2529 x_qt_program_update_date OUT NOCOPY DATE,
2530 x_qt_orig_tax_code OUT NOCOPY VARCHAR2,
2531 x_qt_tax_code OUT NOCOPY VARCHAR2,
2532 x_qt_tax_rate OUT NOCOPY NUMBER,
2533 x_qt_tax_date OUT NOCOPY DATE,
2534 x_qt_tax_amount OUT NOCOPY NUMBER,
2535 x_qt_tax_exempt_flag OUT NOCOPY VARCHAR2,
2536 x_qt_tax_exempt_number OUT NOCOPY VARCHAR2,
2537 x_qt_tax_exempt_reason_code OUT NOCOPY VARCHAR2,
2538 x_qt_attribute_category OUT NOCOPY VARCHAR2,
2539 x_qt_attribute1 OUT NOCOPY VARCHAR2,
2540 x_qt_attribute2 OUT NOCOPY VARCHAR2,
2541 x_qt_attribute3 OUT NOCOPY VARCHAR2,
2542 x_qt_attribute4 OUT NOCOPY VARCHAR2,
2543 x_qt_attribute5 OUT NOCOPY VARCHAR2,
2544 x_qt_attribute6 OUT NOCOPY VARCHAR2,
2545 x_qt_attribute7 OUT NOCOPY VARCHAR2,
2546 x_qt_attribute8 OUT NOCOPY VARCHAR2,
2547 x_qt_attribute9 OUT NOCOPY VARCHAR2,
2548 x_qt_attribute10 OUT NOCOPY VARCHAR2,
2549 x_qt_attribute11 OUT NOCOPY VARCHAR2,
2550 x_qt_attribute12 OUT NOCOPY VARCHAR2,
2551 x_qt_attribute13 OUT NOCOPY VARCHAR2,
2552 x_qt_attribute14 OUT NOCOPY VARCHAR2,
2553 x_qt_attribute15 OUT NOCOPY VARCHAR2,
2554 x_qt_attribute16 OUT NOCOPY VARCHAR2,
2555 x_qt_attribute17 OUT NOCOPY VARCHAR2,
2556 x_qt_attribute18 OUT NOCOPY VARCHAR2,
2557 x_qt_attribute19 OUT NOCOPY VARCHAR2,
2558 x_qt_attribute20 OUT NOCOPY VARCHAR2,
2559 x_qt_object_version_number OUT NOCOPY NUMBER,
2560 x_qt_tax_rate_id OUT NOCOPY NUMBER
2561 );
2562
2563
2564 PROCEDURE Set_Qte_line_rec_Out(
2565 p_qte_line_rec IN ASO_Quote_Pub.Qte_line_rec_Type,
2566 x_ql_creation_date OUT NOCOPY DATE,
2567 x_ql_created_by OUT NOCOPY NUMBER,
2568 x_ql_last_updated_by OUT NOCOPY NUMBER,
2569 x_ql_last_update_date OUT NOCOPY DATE,
2570 x_ql_last_update_login OUT NOCOPY NUMBER,
2571 x_ql_request_id OUT NOCOPY NUMBER,
2572 x_ql_program_application_id OUT NOCOPY NUMBER,
2573 x_ql_program_id OUT NOCOPY NUMBER,
2574 x_ql_program_update_date OUT NOCOPY DATE,
2575 x_ql_quote_line_id OUT NOCOPY NUMBER,
2576 x_ql_quote_header_id OUT NOCOPY NUMBER,
2577 x_ql_org_id OUT NOCOPY NUMBER,
2578 x_ql_line_number OUT NOCOPY NUMBER,
2579 x_ql_line_category_code OUT NOCOPY VARCHAR2,
2580 x_ql_item_type_code OUT NOCOPY VARCHAR2,
2581 x_ql_inventory_item_id OUT NOCOPY NUMBER,
2582 x_ql_organization_id OUT NOCOPY NUMBER,
2583 x_ql_quantity OUT NOCOPY NUMBER,
2584 x_ql_uom_code OUT NOCOPY VARCHAR2,
2585 x_ql_start_date_active OUT NOCOPY VARCHAR2,
2586 x_ql_end_date_active OUT NOCOPY VARCHAR2,
2587 x_ql_order_line_type_id OUT NOCOPY NUMBER,
2588 x_ql_price_list_id OUT NOCOPY NUMBER,
2589 x_ql_price_list_line_id OUT NOCOPY NUMBER,
2590 x_ql_currency_code OUT NOCOPY VARCHAR2,
2591 x_ql_line_list_price OUT NOCOPY NUMBER,
2592 x_ql_line_adjusted_amount OUT NOCOPY NUMBER,
2593 x_ql_line_adjusted_percent OUT NOCOPY NUMBER,
2594 x_ql_line_quote_price OUT NOCOPY NUMBER,
2595 x_ql_related_item_id OUT NOCOPY NUMBER,
2596 x_ql_item_relationship_type OUT NOCOPY VARCHAR2,
2597 x_ql_split_shipment_flag OUT NOCOPY VARCHAR2,
2598 x_ql_backorder_flag OUT NOCOPY VARCHAR2,
2599 x_ql_selling_price_change OUT NOCOPY VARCHAR2,
2600 x_ql_recalculate_flag OUT NOCOPY VARCHAR2,
2601 x_ql_attribute_category OUT NOCOPY VARCHAR2,
2602 x_ql_attribute1 OUT NOCOPY VARCHAR2,
2603 x_ql_attribute2 OUT NOCOPY VARCHAR2,
2604 x_ql_attribute3 OUT NOCOPY VARCHAR2,
2605 x_ql_attribute4 OUT NOCOPY VARCHAR2,
2606 x_ql_attribute5 OUT NOCOPY VARCHAR2,
2607 x_ql_attribute6 OUT NOCOPY VARCHAR2,
2608 x_ql_attribute7 OUT NOCOPY VARCHAR2,
2609 x_ql_attribute8 OUT NOCOPY VARCHAR2,
2610 x_ql_attribute9 OUT NOCOPY VARCHAR2,
2611 x_ql_attribute10 OUT NOCOPY VARCHAR2,
2612 x_ql_attribute11 OUT NOCOPY VARCHAR2,
2613 x_ql_attribute12 OUT NOCOPY VARCHAR2,
2614 x_ql_attribute13 OUT NOCOPY VARCHAR2,
2615 x_ql_attribute14 OUT NOCOPY VARCHAR2,
2616 x_ql_attribute15 OUT NOCOPY VARCHAR2,
2617 x_ql_attribute16 OUT NOCOPY VARCHAR2,
2618 x_ql_attribute17 OUT NOCOPY VARCHAR2,
2619 x_ql_attribute18 OUT NOCOPY VARCHAR2,
2620 x_ql_attribute19 OUT NOCOPY VARCHAR2,
2621 x_ql_attribute20 OUT NOCOPY VARCHAR2,
2622 x_ql_accounting_rule_id OUT NOCOPY NUMBER,
2623 x_ql_ffm_content_name OUT NOCOPY VARCHAR2,
2624 x_ql_ffm_content_type OUT NOCOPY VARCHAR2,
2625 x_ql_ffm_document_type OUT NOCOPY VARCHAR2,
2626 x_ql_ffm_media_id OUT NOCOPY VARCHAR2,
2627 x_ql_ffm_media_type OUT NOCOPY VARCHAR2,
2628 x_ql_ffm_user_note OUT NOCOPY VARCHAR2,
2629 x_ql_invoice_to_party_id OUT NOCOPY NUMBER,
2630 x_ql_invoice_to_party_site_id OUT NOCOPY NUMBER,
2631 x_ql_invoicing_rule_id OUT NOCOPY NUMBER,
2632 x_ql_marketing_source_code_id OUT NOCOPY NUMBER,
2633 x_ql_operation_code OUT NOCOPY VARCHAR2,
2634 x_ql_invoice_to_cust_acct_id OUT NOCOPY NUMBER,
2635 x_ql_pricing_quantity_uom OUT NOCOPY VARCHAR2,
2636 x_ql_minisite_id OUT NOCOPY NUMBER,
2637 x_ql_section_id OUT NOCOPY NUMBER,
2638 x_ql_priced_price_list_id OUT NOCOPY NUMBER,
2639 x_ql_agreement_id OUT NOCOPY NUMBER,
2640 x_ql_commitment_id OUT NOCOPY NUMBER,
2641 x_ql_display_arithmetic_op OUT NOCOPY VARCHAR2,
2642 x_ql_invoice_to_cust_party_id OUT NOCOPY NUMBER,
2643 x_ql_ship_model_complete_flag OUT NOCOPY VARCHAR2,
2644 x_ql_charge_periodicity_code OUT NOCOPY VARCHAR2,
2645 x_ql_end_cust_party_id OUT NOCOPY NUMBER,
2646 x_ql_end_cust_party_site_id OUT NOCOPY NUMBER,
2647 x_ql_end_cust_cust_account_id OUT NOCOPY NUMBER,
2648 x_ql_end_cust_cust_party_id OUT NOCOPY NUMBER,
2649 x_ql_object_version_number OUT NOCOPY NUMBER,
2650 x_ql_line_paynow_charges OUT NOCOPY NUMBER,
2651 x_ql_line_paynow_tax OUT NOCOPY NUMBER,
2652 x_ql_line_paynow_subtotal OUT NOCOPY NUMBER,
2653 x_ql_config_model_type OUT NOCOPY VARCHAR2
2654 );
2655
2656 PROCEDURE Set_Def_Control_Rec_W(
2657 p_dc_override_Trigger_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2658 p_dc_dependency_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2659 p_dc_defaulting_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2660 p_dc_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2661 p_dc_defaulting_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2662 p_dc_last_update_date IN DATE := FND_API.G_MISS_DATE,
2663 p_dc_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
2664 x_def_control_rec OUT NOCOPY ASO_Defaulting_Int.Control_Rec_Type
2665 );
2666
2667 PROCEDURE Set_Config_Valid_Table_Out(
2668 p_config_table IN ASO_QUOTE_PUB.Config_Vaild_Tbl_Type,
2669 x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
2670 x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2671 x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2672 x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
2673 );
2674
2675 PROCEDURE Set_num_Tbl_Out (
2676 p_num_tbl IN ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE,
2677 x_num_id OUT NOCOPY JTF_NUMBER_TABLE
2678 );
2679
2680 FUNCTION Construct_Related_Obj_Tbl(
2681 p_operation_code IN jtf_varchar2_table_100 := NULL,
2682 p_RELATED_OBJECT_ID IN jtf_number_table := NULL,
2683 p_CREATION_DATE IN jtf_date_table := null,
2684 p_CREATED_BY IN jtf_number_table := NULL,
2685 p_LAST_UPDATE_DATE IN jtf_date_table := null,
2686 p_LAST_UPDATED_BY IN jtf_number_table := NULL,
2687 p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL,
2688 p_REQUEST_ID IN jtf_number_table := NULL,
2689 p_PROGRAM_APPLICATION_ID IN jtf_number_table := NULL,
2690 p_PROGRAM_ID IN jtf_number_table := NULL,
2691 p_PROGRAM_UPDATE_DATE IN jtf_date_table := null,
2692 p_QUOTE_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
2693 p_QUOTE_OBJECT_ID IN jtf_number_table := NULL,
2694 p_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
2695 p_OBJECT_ID IN jtf_number_table := NULL,
2696 p_RELATIONSHIP_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
2697 p_RECIPROCAL_FLAG IN jtf_varchar2_table_100 := NULL,
2698 p_QUOTE_OBJECT_CODE IN jtf_number_table := NULL,
2699 p_OBJECT_VERSION_NUMBER IN jtf_number_table := NULL
2700 )
2701 RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
2702
2703
2704 PROCEDURE Set_Related_Obj_Tbl_Out(
2705 p_rel_obj_tbl IN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type,
2706 x_related_object_id OUT NOCOPY jtf_number_table
2707 );
2708
2709
2710 END ASO_Quote_Util_PVT;