[Home] [Help]
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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(
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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:
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,
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,
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,
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,
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,
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,
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,
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;
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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;
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:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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(
1360: x_program_application_id OUT NOCOPY jtf_number_table,
1361: x_program_id OUT NOCOPY jtf_number_table,
1362: x_program_update_date OUT NOCOPY jtf_date_table,
1363: x_org_id OUT NOCOPY jtf_number_table,
1364: x_quote_name OUT NOCOPY jtf_varchar2_table_100,
1365: x_quote_number OUT NOCOPY jtf_number_table,
1366: x_quote_version OUT NOCOPY jtf_number_table,
1367: x_quote_status_id OUT NOCOPY jtf_number_table,
1368: x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
1385: x_accounting_rule_id OUT NOCOPY jtf_number_table,
1386: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1387: x_employee_person_id OUT NOCOPY jtf_number_table,
1388: x_price_list_id OUT NOCOPY jtf_number_table,
1389: x_currency_code OUT NOCOPY jtf_varchar2_table_100,
1390: x_total_list_price OUT NOCOPY jtf_number_table,
1391: x_total_adjusted_amount OUT NOCOPY jtf_number_table,
1392: x_total_adjusted_percent OUT NOCOPY jtf_number_table,
1393: x_total_tax OUT NOCOPY jtf_number_table,
1395: x_surcharge OUT NOCOPY jtf_number_table,
1396: x_total_quote_price OUT NOCOPY jtf_number_table,
1397: x_payment_amount OUT NOCOPY jtf_number_table,
1398: x_exchange_rate OUT NOCOPY jtf_number_table,
1399: x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
1400: x_exchange_rate_date OUT NOCOPY jtf_date_table,
1401: x_contract_id OUT NOCOPY jtf_number_table,
1402: x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
1403: x_order_id OUT NOCOPY jtf_number_table,
1398: x_exchange_rate OUT NOCOPY jtf_number_table,
1399: x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
1400: x_exchange_rate_date OUT NOCOPY jtf_date_table,
1401: x_contract_id OUT NOCOPY jtf_number_table,
1402: x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
1403: x_order_id OUT NOCOPY jtf_number_table,
1404: x_order_number OUT NOCOPY jtf_number_table,
1405: x_ffm_request_id OUT NOCOPY jtf_number_table,
1406: x_qte_contract_id OUT NOCOPY jtf_number_table,
1403: x_order_id OUT NOCOPY jtf_number_table,
1404: x_order_number OUT NOCOPY jtf_number_table,
1405: x_ffm_request_id OUT NOCOPY jtf_number_table,
1406: x_qte_contract_id OUT NOCOPY jtf_number_table,
1407: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1408: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1409: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1410: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1411: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1422: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1423: x_salesrep_first_name OUT NOCOPY jtf_varchar2_table_300,
1424: x_salesrep_last_name OUT NOCOPY jtf_varchar2_table_300,
1425: x_price_list_name OUT NOCOPY jtf_varchar2_table_300,
1426: x_quote_status_code OUT NOCOPY jtf_varchar2_table_100,
1427: x_quote_status OUT NOCOPY jtf_varchar2_table_300,
1428: x_party_name OUT NOCOPY jtf_varchar2_table_300,
1429: x_party_type OUT NOCOPY jtf_varchar2_table_100,
1430: x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
1425: x_price_list_name OUT NOCOPY jtf_varchar2_table_300,
1426: x_quote_status_code OUT NOCOPY jtf_varchar2_table_100,
1427: x_quote_status OUT NOCOPY jtf_varchar2_table_300,
1428: x_party_name OUT NOCOPY jtf_varchar2_table_300,
1429: x_party_type OUT NOCOPY jtf_varchar2_table_100,
1430: x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
1431: x_person_middle_name OUT NOCOPY jtf_varchar2_table_100,
1432: x_person_last_name OUT NOCOPY jtf_varchar2_table_200,
1433: x_marketing_source_name OUT NOCOPY jtf_varchar2_table_200,
1427: x_quote_status OUT NOCOPY jtf_varchar2_table_300,
1428: x_party_name OUT NOCOPY jtf_varchar2_table_300,
1429: x_party_type OUT NOCOPY jtf_varchar2_table_100,
1430: x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
1431: x_person_middle_name OUT NOCOPY jtf_varchar2_table_100,
1432: x_person_last_name OUT NOCOPY jtf_varchar2_table_200,
1433: x_marketing_source_name OUT NOCOPY jtf_varchar2_table_200,
1434: x_marketing_source_code OUT NOCOPY jtf_varchar2_table_200,
1435: x_order_type_name OUT NOCOPY jtf_varchar2_table_300,
1434: x_marketing_source_code OUT NOCOPY jtf_varchar2_table_200,
1435: x_order_type_name OUT NOCOPY jtf_varchar2_table_300,
1436: x_invoice_to_party_name OUT NOCOPY jtf_varchar2_table_300,
1437: x_invoice_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
1438: x_invoice_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
1439: x_invoice_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
1440: x_invoice_to_address1 OUT NOCOPY jtf_varchar2_table_300,
1441: x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1442: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1440: x_invoice_to_address1 OUT NOCOPY jtf_varchar2_table_300,
1441: x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1442: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1443: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1444: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1445: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1446: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1447: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1448: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1441: x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1442: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1443: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1444: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1445: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1446: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1447: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1448: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1449: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1442: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1443: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1444: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1445: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1446: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1447: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1448: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1449: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1450: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
1443: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1444: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1445: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1446: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1447: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1448: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1449: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1450: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
1451: x_resource_id OUT NOCOPY jtf_number_table
1444: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1445: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1446: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1447: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1448: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1449: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1450: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
1451: x_resource_id OUT NOCOPY jtf_number_table
1452: --*/
1445: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1446: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1447: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1448: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1449: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1450: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
1451: x_resource_id OUT NOCOPY jtf_number_table
1452: --*/
1453: );
1446: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1447: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1448: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1449: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1450: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
1451: x_resource_id OUT NOCOPY jtf_number_table
1452: --*/
1453: );
1454:
1456: p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,
1457: x_quote_line_id OUT NOCOPY jtf_number_table
1458:
1459: /*-- The following output parameters are ignored
1460: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1461: x_creation_date OUT NOCOPY jtf_date_table,
1462: x_created_by OUT NOCOPY jtf_number_table,
1463: x_last_update_date OUT NOCOPY jtf_date_table,
1464: x_last_updated_by OUT NOCOPY jtf_number_table,
1468: x_program_id OUT NOCOPY jtf_number_table,
1469: x_program_update_date OUT NOCOPY jtf_date_table,
1470: x_quote_header_id OUT NOCOPY jtf_number_table,
1471: x_org_id OUT NOCOPY jtf_number_table,
1472: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
1473: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
1474: x_line_number OUT NOCOPY jtf_number_table,
1475: x_start_date_active OUT NOCOPY jtf_date_table,
1476: x_end_date_active OUT NOCOPY jtf_date_table,
1469: x_program_update_date OUT NOCOPY jtf_date_table,
1470: x_quote_header_id OUT NOCOPY jtf_number_table,
1471: x_org_id OUT NOCOPY jtf_number_table,
1472: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
1473: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
1474: x_line_number OUT NOCOPY jtf_number_table,
1475: x_start_date_active OUT NOCOPY jtf_date_table,
1476: x_end_date_active OUT NOCOPY jtf_date_table,
1477: x_order_line_type_id OUT NOCOPY jtf_number_table,
1480: x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,
1481: x_organization_id OUT NOCOPY jtf_number_table,
1482: x_inventory_item_id OUT NOCOPY jtf_number_table,
1483: x_quantity OUT NOCOPY jtf_number_table,
1484: x_uom_code OUT NOCOPY jtf_varchar2_table_100,
1485: x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
1486: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
1487: x_price_list_id OUT NOCOPY jtf_number_table,
1488: x_price_list_line_id OUT NOCOPY jtf_number_table,
1481: x_organization_id OUT NOCOPY jtf_number_table,
1482: x_inventory_item_id OUT NOCOPY jtf_number_table,
1483: x_quantity OUT NOCOPY jtf_number_table,
1484: x_uom_code OUT NOCOPY jtf_varchar2_table_100,
1485: x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
1486: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
1487: x_price_list_id OUT NOCOPY jtf_number_table,
1488: x_price_list_line_id OUT NOCOPY jtf_number_table,
1489: x_currency_code OUT NOCOPY jtf_varchar2_table_100,
1485: x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
1486: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
1487: x_price_list_id OUT NOCOPY jtf_number_table,
1488: x_price_list_line_id OUT NOCOPY jtf_number_table,
1489: x_currency_code OUT NOCOPY jtf_varchar2_table_100,
1490: x_line_list_price OUT NOCOPY jtf_number_table,
1491: x_line_adjusted_amount OUT NOCOPY jtf_number_table,
1492: x_line_adjusted_percent OUT NOCOPY jtf_number_table,
1493: x_line_quote_price OUT NOCOPY jtf_number_table,
1491: x_line_adjusted_amount OUT NOCOPY jtf_number_table,
1492: x_line_adjusted_percent OUT NOCOPY jtf_number_table,
1493: x_line_quote_price OUT NOCOPY jtf_number_table,
1494: x_related_item_id OUT NOCOPY jtf_number_table,
1495: x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
1496: x_accounting_rule_id OUT NOCOPY jtf_number_table,
1497: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1498: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
1499: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
1494: x_related_item_id OUT NOCOPY jtf_number_table,
1495: x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
1496: x_accounting_rule_id OUT NOCOPY jtf_number_table,
1497: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1498: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
1499: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
1500: x_minisite_id OUT NOCOPY jtf_number_table,
1501: x_section_id OUT NOCOPY jtf_number_table,
1502: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
1495: x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
1496: x_accounting_rule_id OUT NOCOPY jtf_number_table,
1497: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1498: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
1499: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
1500: x_minisite_id OUT NOCOPY jtf_number_table,
1501: x_section_id OUT NOCOPY jtf_number_table,
1502: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
1503: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
1498: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
1499: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
1500: x_minisite_id OUT NOCOPY jtf_number_table,
1501: x_section_id OUT NOCOPY jtf_number_table,
1502: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
1503: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
1504: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1505: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1506: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1499: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
1500: x_minisite_id OUT NOCOPY jtf_number_table,
1501: x_section_id OUT NOCOPY jtf_number_table,
1502: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
1503: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
1504: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1505: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1506: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1507: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1500: x_minisite_id OUT NOCOPY jtf_number_table,
1501: x_section_id OUT NOCOPY jtf_number_table,
1502: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
1503: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
1504: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1505: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1506: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1507: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1508: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1530: p_qte_line_dtl_tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
1531: x_quote_line_detail_id OUT NOCOPY jtf_number_table
1532:
1533: /*-- The following output parameters are ignored
1534: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1535: x_qte_line_index OUT NOCOPY jtf_number_table,
1536: x_creation_date OUT NOCOPY jtf_date_table,
1537: x_created_by OUT NOCOPY jtf_number_table,
1538: x_last_update_date OUT NOCOPY jtf_date_table,
1545: x_quote_line_id OUT NOCOPY jtf_number_table,
1546: x_config_header_id OUT NOCOPY jtf_number_table,
1547: x_config_revision_num OUT NOCOPY jtf_number_table,
1548: x_config_item_id OUT NOCOPY jtf_number_table,
1549: x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
1550: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
1551: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
1552: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
1553: x_service_duration OUT NOCOPY jtf_number_table,
1546: x_config_header_id OUT NOCOPY jtf_number_table,
1547: x_config_revision_num OUT NOCOPY jtf_number_table,
1548: x_config_item_id OUT NOCOPY jtf_number_table,
1549: x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
1550: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
1551: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
1552: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
1553: x_service_duration OUT NOCOPY jtf_number_table,
1554: x_service_period OUT NOCOPY jtf_varchar2_table_100,
1548: x_config_item_id OUT NOCOPY jtf_number_table,
1549: x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
1550: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
1551: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
1552: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
1553: x_service_duration OUT NOCOPY jtf_number_table,
1554: x_service_period OUT NOCOPY jtf_varchar2_table_100,
1555: x_service_unit_selling OUT NOCOPY jtf_number_table,
1556: x_service_unit_list OUT NOCOPY jtf_number_table,
1550: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
1551: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
1552: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
1553: x_service_duration OUT NOCOPY jtf_number_table,
1554: x_service_period OUT NOCOPY jtf_varchar2_table_100,
1555: x_service_unit_selling OUT NOCOPY jtf_number_table,
1556: x_service_unit_list OUT NOCOPY jtf_number_table,
1557: x_service_number OUT NOCOPY jtf_number_table,
1558: x_unit_percent_base_price OUT NOCOPY jtf_number_table,
1555: x_service_unit_selling OUT NOCOPY jtf_number_table,
1556: x_service_unit_list OUT NOCOPY jtf_number_table,
1557: x_service_number OUT NOCOPY jtf_number_table,
1558: x_unit_percent_base_price OUT NOCOPY jtf_number_table,
1559: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1560: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1561: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1562: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1563: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1571: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1572: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1573: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1574: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1575: x_service_ref_type_code OUT NOCOPY jtf_varchar2_table_100,
1576: x_service_ref_order_number OUT NOCOPY jtf_number_table,
1577: x_service_ref_line_number OUT NOCOPY jtf_number_table,
1578: x_service_ref_qte_line_ind OUT NOCOPY jtf_number_table,
1579: x_service_ref_line_id OUT NOCOPY jtf_number_table,
1579: x_service_ref_line_id OUT NOCOPY jtf_number_table,
1580: x_service_ref_system_id OUT NOCOPY jtf_number_table,
1581: x_service_ref_option_numb OUT NOCOPY jtf_number_table,
1582: x_service_ref_shipment OUT NOCOPY jtf_number_table,
1583: x_return_ref_type OUT NOCOPY jtf_varchar2_table_100,
1584: x_return_ref_header_id OUT NOCOPY jtf_number_table,
1585: x_return_ref_line_id OUT NOCOPY jtf_number_table,
1586: x_return_attribute1 OUT NOCOPY jtf_varchar2_table_300,
1587: x_return_attribute2 OUT NOCOPY jtf_varchar2_table_300,
1597: x_return_attribute15 OUT NOCOPY jtf_varchar2_table_300,
1598: x_return_attribute12 OUT NOCOPY jtf_varchar2_table_300,
1599: x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
1600: x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
1601: x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
1602: x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
1603: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
1604: --*/
1605: );
1598: x_return_attribute12 OUT NOCOPY jtf_varchar2_table_300,
1599: x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
1600: x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
1601: x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
1602: x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
1603: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
1604: --*/
1605: );
1606:
1599: x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
1600: x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
1601: x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
1602: x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
1603: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
1604: --*/
1605: );
1606:
1607: PROCEDURE Set_Line_Rltship_Tbl_Out(
1608: p_qte_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type,
1609: x_line_relationship_id OUT NOCOPY jtf_number_table
1610:
1611: /*-- The following output parameters are ignored
1612: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1613: x_creation_date OUT NOCOPY jtf_date_table,
1614: x_created_by OUT NOCOPY jtf_number_table,
1615: x_last_update_date OUT NOCOPY jtf_date_table,
1616: x_last_updated_by OUT NOCOPY jtf_number_table,
1622: x_quote_line_id OUT NOCOPY jtf_number_table,
1623: x_qte_line_index OUT NOCOPY jtf_number_table,
1624: x_related_quote_line_id OUT NOCOPY jtf_number_table,
1625: x_related_qte_line_index OUT NOCOPY jtf_number_table,
1626: x_relationship_type_code OUT NOCOPY jtf_varchar2_table_100,
1627: x_reciprocal_flag OUT NOCOPY jtf_varchar2_table_100
1628: --*/
1629: );
1630:
1623: x_qte_line_index OUT NOCOPY jtf_number_table,
1624: x_related_quote_line_id OUT NOCOPY jtf_number_table,
1625: x_related_qte_line_index OUT NOCOPY jtf_number_table,
1626: x_relationship_type_code OUT NOCOPY jtf_varchar2_table_100,
1627: x_reciprocal_flag OUT NOCOPY jtf_varchar2_table_100
1628: --*/
1629: );
1630:
1631: PROCEDURE Set_Payment_Tbl_Out(
1632: p_qte_payment_tbl IN ASO_Quote_Pub.Payment_Tbl_Type,
1633: x_payment_id OUT NOCOPY jtf_number_table
1634:
1635: /*-- The following output parameters are ignored
1636: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1637: x_qte_line_index OUT NOCOPY jtf_number_table,
1638: x_shipment_index OUT NOCOPY jtf_number_table,
1639: x_creation_date OUT NOCOPY jtf_date_table,
1640: x_created_by OUT NOCOPY jtf_number_table,
1647: x_program_update_date OUT NOCOPY jtf_date_table,
1648: x_quote_header_id OUT NOCOPY jtf_number_table,
1649: x_quote_line_id OUT NOCOPY jtf_number_table,
1650: x_quote_shipment_id OUT NOCOPY jtf_number_table,
1651: x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,
1652: x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
1653: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
1654: x_payment_term_id OUT NOCOPY jtf_number_table,
1655: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
1651: x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,
1652: x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
1653: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
1654: x_payment_term_id OUT NOCOPY jtf_number_table,
1655: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
1656: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
1657: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
1658: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
1659: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
1652: x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
1653: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
1654: x_payment_term_id OUT NOCOPY jtf_number_table,
1655: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
1656: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
1657: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
1658: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
1659: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
1660: x_payment_amount OUT NOCOPY jtf_number_table,
1654: x_payment_term_id OUT NOCOPY jtf_number_table,
1655: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
1656: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
1657: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
1658: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
1659: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
1660: x_payment_amount OUT NOCOPY jtf_number_table,
1661: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1662: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1657: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
1658: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
1659: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
1660: x_payment_amount OUT NOCOPY jtf_number_table,
1661: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1662: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1663: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1664: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1665: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1673: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1674: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1675: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1676: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1677: x_cust_po_number OUT NOCOPY jtf_varchar2_table_100
1678: --*/
1679: );
1680:
1681: PROCEDURE Set_Shipment_Tbl_Out(
1682: p_qte_shipment_tbl IN ASO_Quote_Pub.Shipment_Tbl_Type,
1683: x_shipment_id OUT NOCOPY jtf_number_table
1684:
1685: /*-- The following output parameters are ignored
1686: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1687: x_qte_line_index OUT NOCOPY jtf_number_table,
1688: x_creation_date OUT NOCOPY jtf_date_table,
1689: x_created_by OUT NOCOPY jtf_number_table,
1690: x_last_update_date OUT NOCOPY jtf_date_table,
1703: x_ship_to_party_id OUT NOCOPY jtf_number_table,
1704: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
1705: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
1706: x_ship_set_id OUT NOCOPY jtf_number_table,
1707: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
1708: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
1709: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
1710: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
1711: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
1704: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
1705: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
1706: x_ship_set_id OUT NOCOPY jtf_number_table,
1707: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
1708: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
1709: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
1710: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
1711: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
1712: x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
1705: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
1706: x_ship_set_id OUT NOCOPY jtf_number_table,
1707: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
1708: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
1709: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
1710: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
1711: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
1712: x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
1713: x_ship_quote_price OUT NOCOPY jtf_number_table,
1706: x_ship_set_id OUT NOCOPY jtf_number_table,
1707: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
1708: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
1709: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
1710: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
1711: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
1712: x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
1713: x_ship_quote_price OUT NOCOPY jtf_number_table,
1714: x_quantity OUT NOCOPY jtf_number_table,
1717: x_reservation_id OUT NOCOPY jtf_number_table,
1718: x_order_line_id OUT NOCOPY jtf_number_table,
1719: x_ship_to_party_name OUT NOCOPY jtf_varchar2_table_300,
1720: x_ship_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
1721: x_ship_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
1722: x_ship_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
1723: x_ship_to_address1 OUT NOCOPY jtf_varchar2_table_300,
1724: x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1725: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1723: x_ship_to_address1 OUT NOCOPY jtf_varchar2_table_300,
1724: x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1725: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1726: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1727: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1728: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1729: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1730: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1731: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1724: x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1725: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1726: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1727: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1728: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1729: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1730: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1731: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1732: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1725: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1726: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1727: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1728: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1729: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1730: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1731: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1732: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1733: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1726: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1727: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1728: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1729: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1730: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1731: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1732: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1733: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1734: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1727: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1728: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1729: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1730: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1731: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1732: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1733: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1734: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1735: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1728: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1729: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1730: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1731: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1732: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1733: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1734: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1735: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1736: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1729: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1730: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1731: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1732: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1733: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1734: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1735: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1736: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1737: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1730: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1731: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1732: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1733: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1734: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1735: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1736: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1737: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1738: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1746: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1747: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1748: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1749: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1750: x_shipment_priority_code OUT NOCOPY jtf_varchar2_table_100,
1751: x_ship_from_org_id OUT NOCOPY jtf_number_table
1752: --*/
1753: );
1754:
1756: p_qte_tax_detail_tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type,
1757: x_tax_detail_id OUT NOCOPY jtf_number_table
1758:
1759: /*-- The following output parameters are ignored
1760: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1761: x_qte_line_index OUT NOCOPY jtf_number_table,
1762: x_shipment_index OUT NOCOPY jtf_number_table,
1763: x_quote_header_id OUT NOCOPY jtf_number_table,
1764: x_quote_line_id OUT NOCOPY jtf_number_table,
1772: x_program_application_id OUT NOCOPY jtf_number_table,
1773: x_program_id OUT NOCOPY jtf_number_table,
1774: x_program_update_date OUT NOCOPY jtf_date_table,
1775: x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
1776: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1777: x_tax_rate OUT NOCOPY jtf_number_table,
1778: x_tax_date OUT NOCOPY jtf_date_table,
1779: x_tax_amount OUT NOCOPY jtf_number_table,
1780: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1776: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1777: x_tax_rate OUT NOCOPY jtf_number_table,
1778: x_tax_date OUT NOCOPY jtf_date_table,
1779: x_tax_amount OUT NOCOPY jtf_number_table,
1780: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1781: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1782: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1783: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1784: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1777: x_tax_rate OUT NOCOPY jtf_number_table,
1778: x_tax_date OUT NOCOPY jtf_date_table,
1779: x_tax_amount OUT NOCOPY jtf_number_table,
1780: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1781: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1782: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1783: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1784: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1785: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1778: x_tax_date OUT NOCOPY jtf_date_table,
1779: x_tax_amount OUT NOCOPY jtf_number_table,
1780: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1781: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1782: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1783: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1784: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1785: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1786: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1779: x_tax_amount OUT NOCOPY jtf_number_table,
1780: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1781: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1782: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1783: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1784: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1785: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1786: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1787: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1803: p_qte_price_adj_tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type,
1804: x_price_adjustment_id OUT NOCOPY jtf_number_table
1805:
1806: /*-- The following output parameters are ignored
1807: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1808: x_qte_line_index OUT NOCOPY jtf_number_table,
1809: x_shipment_index OUT NOCOPY jtf_number_table,
1810: x_creation_date OUT NOCOPY jtf_date_table,
1811: x_created_by OUT NOCOPY jtf_number_table,
1820: x_quote_line_id OUT NOCOPY jtf_number_table,
1821: x_quote_shipment_id OUT NOCOPY jtf_number_table,
1822: x_modifier_header_id OUT NOCOPY jtf_number_table,
1823: x_modifier_line_id OUT NOCOPY jtf_number_table,
1824: x_modifier_line_type_code OUT NOCOPY jtf_varchar2_table_100,
1825: x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
1826: x_modified_from OUT NOCOPY jtf_number_table,
1827: x_modified_to OUT NOCOPY jtf_number_table,
1828: x_operand OUT NOCOPY jtf_number_table,
1821: x_quote_shipment_id OUT NOCOPY jtf_number_table,
1822: x_modifier_header_id OUT NOCOPY jtf_number_table,
1823: x_modifier_line_id OUT NOCOPY jtf_number_table,
1824: x_modifier_line_type_code OUT NOCOPY jtf_varchar2_table_100,
1825: x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
1826: x_modified_from OUT NOCOPY jtf_number_table,
1827: x_modified_to OUT NOCOPY jtf_number_table,
1828: x_operand OUT NOCOPY jtf_number_table,
1829: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1825: x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
1826: x_modified_from OUT NOCOPY jtf_number_table,
1827: x_modified_to OUT NOCOPY jtf_number_table,
1828: x_operand OUT NOCOPY jtf_number_table,
1829: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1830: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1831: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1832: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1833: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1826: x_modified_from OUT NOCOPY jtf_number_table,
1827: x_modified_to OUT NOCOPY jtf_number_table,
1828: x_operand OUT NOCOPY jtf_number_table,
1829: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1830: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1831: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1832: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1833: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1834: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1827: x_modified_to OUT NOCOPY jtf_number_table,
1828: x_operand OUT NOCOPY jtf_number_table,
1829: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1830: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1831: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1832: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1833: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1834: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1835: x_pricing_phase_id OUT NOCOPY jtf_number_table,
1828: x_operand OUT NOCOPY jtf_number_table,
1829: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1830: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1831: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1832: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1833: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1834: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1835: x_pricing_phase_id OUT NOCOPY jtf_number_table,
1836: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1829: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1830: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1831: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1832: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1833: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1834: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1835: x_pricing_phase_id OUT NOCOPY jtf_number_table,
1836: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1837: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1830: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1831: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1832: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1833: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1834: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1835: x_pricing_phase_id OUT NOCOPY jtf_number_table,
1836: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1837: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1838: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1832: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1833: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1834: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1835: x_pricing_phase_id OUT NOCOPY jtf_number_table,
1836: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1837: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1838: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1839: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1840: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1848: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1849: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1850: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1851: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1852: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
1853: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
1854: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
1855: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1856: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1849: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1850: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1851: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1852: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
1853: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
1854: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
1855: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1856: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1857: x_cost_id OUT NOCOPY jtf_number_table,
1850: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1851: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1852: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
1853: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
1854: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
1855: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1856: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1857: x_cost_id OUT NOCOPY jtf_number_table,
1858: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1851: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1852: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
1853: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
1854: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
1855: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1856: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1857: x_cost_id OUT NOCOPY jtf_number_table,
1858: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1859: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1854: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
1855: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1856: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1857: x_cost_id OUT NOCOPY jtf_number_table,
1858: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1859: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1860: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1861: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1862: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1855: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1856: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1857: x_cost_id OUT NOCOPY jtf_number_table,
1858: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1859: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1860: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1861: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1862: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1863: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1856: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1857: x_cost_id OUT NOCOPY jtf_number_table,
1858: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1859: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1860: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1861: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1862: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1863: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1864: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1857: x_cost_id OUT NOCOPY jtf_number_table,
1858: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1859: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1860: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1861: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1862: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1863: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1864: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1865: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1859: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1860: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1861: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1862: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1863: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1864: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1865: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1866: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1867: x_adjusted_amount OUT NOCOPY jtf_number_table,
1860: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1861: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1862: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1863: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1864: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1865: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1866: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1867: x_adjusted_amount OUT NOCOPY jtf_number_table,
1868: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
1861: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1862: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1863: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1864: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1865: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1866: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1867: x_adjusted_amount OUT NOCOPY jtf_number_table,
1868: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
1869: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
1862: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1863: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1864: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1865: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1866: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1867: x_adjusted_amount OUT NOCOPY jtf_number_table,
1868: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
1869: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
1870: x_range_break_quantity OUT NOCOPY jtf_number_table,
1864: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1865: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1866: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1867: x_adjusted_amount OUT NOCOPY jtf_number_table,
1868: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
1869: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
1870: x_range_break_quantity OUT NOCOPY jtf_number_table,
1871: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
1872: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
1865: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1866: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1867: x_adjusted_amount OUT NOCOPY jtf_number_table,
1868: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
1869: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
1870: x_range_break_quantity OUT NOCOPY jtf_number_table,
1871: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
1872: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
1873: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
1869: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
1870: x_range_break_quantity OUT NOCOPY jtf_number_table,
1871: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
1872: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
1873: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
1874: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
1875: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
1876: x_benefit_qty OUT NOCOPY jtf_number_table,
1877: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1871: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
1872: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
1873: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
1874: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
1875: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
1876: x_benefit_qty OUT NOCOPY jtf_number_table,
1877: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1878: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1879: x_expiration_date OUT NOCOPY jtf_date_table,
1873: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
1874: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
1875: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
1876: x_benefit_qty OUT NOCOPY jtf_number_table,
1877: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1878: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1879: x_expiration_date OUT NOCOPY jtf_date_table,
1880: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1881: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1874: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
1875: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
1876: x_benefit_qty OUT NOCOPY jtf_number_table,
1877: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1878: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1879: x_expiration_date OUT NOCOPY jtf_date_table,
1880: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1881: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1882: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1876: x_benefit_qty OUT NOCOPY jtf_number_table,
1877: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1878: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1879: x_expiration_date OUT NOCOPY jtf_date_table,
1880: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1881: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1882: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1883: x_redeemed_date OUT NOCOPY jtf_date_table,
1884: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1877: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1878: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1879: x_expiration_date OUT NOCOPY jtf_date_table,
1880: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1881: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1882: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1883: x_redeemed_date OUT NOCOPY jtf_date_table,
1884: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1885: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1878: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1879: x_expiration_date OUT NOCOPY jtf_date_table,
1880: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1881: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1882: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1883: x_redeemed_date OUT NOCOPY jtf_date_table,
1884: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1885: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1886: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1880: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1881: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1882: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1883: x_redeemed_date OUT NOCOPY jtf_date_table,
1884: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1885: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1886: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1887: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1888: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1881: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1882: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1883: x_redeemed_date OUT NOCOPY jtf_date_table,
1884: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1885: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1886: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1887: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1888: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1889: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1882: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1883: x_redeemed_date OUT NOCOPY jtf_date_table,
1884: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1885: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1886: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1887: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1888: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1889: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1890: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
1883: x_redeemed_date OUT NOCOPY jtf_date_table,
1884: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1885: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1886: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1887: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1888: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1889: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1890: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
1891: --*/
1884: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1885: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1886: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1887: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1888: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1889: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1890: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
1891: --*/
1892: );
1885: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1886: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1887: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1888: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1889: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1890: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
1891: --*/
1892: );
1893:
1886: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1887: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1888: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1889: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1890: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
1891: --*/
1892: );
1893:
1894: PROCEDURE Set_Price_Attributes_Tbl_Out(
1895: p_qte_price_attributes_tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type,
1896: x_price_attribute_id OUT NOCOPY jtf_number_table
1897:
1898: /*-- The following output parameters are ignored
1899: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1900: x_qte_line_index OUT NOCOPY jtf_number_table,
1901: x_creation_date OUT NOCOPY jtf_date_table,
1902: x_created_by OUT NOCOPY jtf_number_table,
1903: x_last_update_date OUT NOCOPY jtf_date_table,
1908: x_program_id OUT NOCOPY jtf_number_table,
1909: x_program_update_date OUT NOCOPY jtf_date_table,
1910: x_quote_header_id OUT NOCOPY jtf_number_table,
1911: x_quote_line_id OUT NOCOPY jtf_number_table,
1912: x_flex_title OUT NOCOPY jtf_varchar2_table_100,
1913: x_pricing_context OUT NOCOPY jtf_varchar2_table_100,
1914: x_pricing_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1915: x_pricing_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1916: x_pricing_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1909: x_program_update_date OUT NOCOPY jtf_date_table,
1910: x_quote_header_id OUT NOCOPY jtf_number_table,
1911: x_quote_line_id OUT NOCOPY jtf_number_table,
1912: x_flex_title OUT NOCOPY jtf_varchar2_table_100,
1913: x_pricing_context OUT NOCOPY jtf_varchar2_table_100,
1914: x_pricing_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1915: x_pricing_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1916: x_pricing_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1917: x_pricing_attribute4 OUT NOCOPY jtf_varchar2_table_200,
2010: x_pricing_attribute97 OUT NOCOPY jtf_varchar2_table_200,
2011: x_pricing_attribute98 OUT NOCOPY jtf_varchar2_table_200,
2012: x_pricing_attribute99 OUT NOCOPY jtf_varchar2_table_200,
2013: x_pricing_attribute100 OUT NOCOPY jtf_varchar2_table_200,
2014: x_context OUT NOCOPY jtf_varchar2_table_100,
2015: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
2016: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
2017: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
2018: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
2035: x_sales_credit_id OUT NOCOPY jtf_number_table
2036:
2037: /*-- The following output parameters are ignored
2038: x_qte_line_index OUT NOCOPY jtf_number_table,
2039: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
2040: x_creation_date OUT NOCOPY jtf_date_table,
2041: x_created_by OUT NOCOPY jtf_number_table,
2042: x_last_updated_by OUT NOCOPY jtf_number_table,
2043: x_last_update_date OUT NOCOPY jtf_date_table,
2055: x_sales_credit_type OUT NOCOPY jtf_varchar2_table_300,
2056: x_resource_group_id OUT NOCOPY jtf_number_table,
2057: x_employee_person_id OUT NOCOPY jtf_number_table,
2058: x_sales_credit_type_id OUT NOCOPY jtf_number_table,
2059: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
2060: x_attribute1 OUT NOCOPY jtf_varchar2_table_300,
2061: x_attribute2 OUT NOCOPY jtf_varchar2_table_300,
2062: x_attribute3 OUT NOCOPY jtf_varchar2_table_300,
2063: x_attribute4 OUT NOCOPY jtf_varchar2_table_300,
2082: x_approver_person_id OUT NOCOPY jtf_number_table,
2083: x_approver_user_id OUT NOCOPY jtf_number_table,
2084: x_notification_id OUT NOCOPY jtf_number_table,
2085: x_approver_sequence OUT NOCOPY jtf_number_table,
2086: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
2087: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
2088: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
2089: x_date_sent OUT NOCOPY jtf_date_table,
2090: x_date_received OUT NOCOPY jtf_date_table
2083: x_approver_user_id OUT NOCOPY jtf_number_table,
2084: x_notification_id OUT NOCOPY jtf_number_table,
2085: x_approver_sequence OUT NOCOPY jtf_number_table,
2086: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
2087: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
2088: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
2089: x_date_sent OUT NOCOPY jtf_date_table,
2090: x_date_received OUT NOCOPY jtf_date_table
2091: );
2131: x_identifier OUT NOCOPY JTF_NUMBER_TABLE,
2132: x_customer_id OUT NOCOPY JTF_NUMBER_TABLE,
2133: x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
2134: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
2135: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2136: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2137: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
2138: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
2139: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2132: x_customer_id OUT NOCOPY JTF_NUMBER_TABLE,
2133: x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
2134: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
2135: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2136: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2137: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
2138: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
2139: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2140: x_request_date_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2191: RETURN ASO_Quote_Pub.Template_Rec_Type;
2192:
2193:
2194: FUNCTION Construct_Trigger_Attr_Tbl(
2195: p_trigger_attribute IN jtf_varchar2_table_100 := NULL
2196: )
2197: RETURN ASO_Defaulting_Int.Attribute_Codes_Tbl_Type;
2198:
2199:
2651: x_num_id OUT NOCOPY JTF_NUMBER_TABLE
2652: );
2653:
2654: FUNCTION Construct_Related_Obj_Tbl(
2655: p_operation_code IN jtf_varchar2_table_100 := NULL,
2656: p_RELATED_OBJECT_ID IN jtf_number_table := NULL,
2657: p_CREATION_DATE IN jtf_date_table := null,
2658: p_CREATED_BY IN jtf_number_table := NULL,
2659: p_LAST_UPDATE_DATE IN jtf_date_table := null,
2667: p_QUOTE_OBJECT_ID IN jtf_number_table := NULL,
2668: p_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
2669: p_OBJECT_ID IN jtf_number_table := NULL,
2670: p_RELATIONSHIP_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
2671: p_RECIPROCAL_FLAG IN jtf_varchar2_table_100 := NULL,
2672: p_QUOTE_OBJECT_CODE IN jtf_number_table := NULL,
2673: p_OBJECT_VERSION_NUMBER IN jtf_number_table := NULL
2674: )
2675: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;