[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(
1378: x_program_application_id OUT NOCOPY jtf_number_table,
1379: x_program_id OUT NOCOPY jtf_number_table,
1380: x_program_update_date OUT NOCOPY jtf_date_table,
1381: x_org_id OUT NOCOPY jtf_number_table,
1382: x_quote_name OUT NOCOPY jtf_varchar2_table_100,
1383: x_quote_number OUT NOCOPY jtf_number_table,
1384: x_quote_version OUT NOCOPY jtf_number_table,
1385: x_quote_status_id OUT NOCOPY jtf_number_table,
1386: x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
1403: x_accounting_rule_id OUT NOCOPY jtf_number_table,
1404: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1405: x_employee_person_id OUT NOCOPY jtf_number_table,
1406: x_price_list_id OUT NOCOPY jtf_number_table,
1407: x_currency_code OUT NOCOPY jtf_varchar2_table_100,
1408: x_total_list_price OUT NOCOPY jtf_number_table,
1409: x_total_adjusted_amount OUT NOCOPY jtf_number_table,
1410: x_total_adjusted_percent OUT NOCOPY jtf_number_table,
1411: x_total_tax OUT NOCOPY jtf_number_table,
1413: x_surcharge OUT NOCOPY jtf_number_table,
1414: x_total_quote_price OUT NOCOPY jtf_number_table,
1415: x_payment_amount OUT NOCOPY jtf_number_table,
1416: x_exchange_rate OUT NOCOPY jtf_number_table,
1417: x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
1418: x_exchange_rate_date OUT NOCOPY jtf_date_table,
1419: x_contract_id OUT NOCOPY jtf_number_table,
1420: x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
1421: x_order_id OUT NOCOPY jtf_number_table,
1416: x_exchange_rate OUT NOCOPY jtf_number_table,
1417: x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
1418: x_exchange_rate_date OUT NOCOPY jtf_date_table,
1419: x_contract_id OUT NOCOPY jtf_number_table,
1420: x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
1421: x_order_id OUT NOCOPY jtf_number_table,
1422: x_order_number OUT NOCOPY jtf_number_table,
1423: x_ffm_request_id OUT NOCOPY jtf_number_table,
1424: x_qte_contract_id OUT NOCOPY jtf_number_table,
1421: x_order_id OUT NOCOPY jtf_number_table,
1422: x_order_number OUT NOCOPY jtf_number_table,
1423: x_ffm_request_id OUT NOCOPY jtf_number_table,
1424: x_qte_contract_id OUT NOCOPY jtf_number_table,
1425: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1426: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1427: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1428: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1429: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1440: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1441: x_salesrep_first_name OUT NOCOPY jtf_varchar2_table_300,
1442: x_salesrep_last_name OUT NOCOPY jtf_varchar2_table_300,
1443: x_price_list_name OUT NOCOPY jtf_varchar2_table_300,
1444: x_quote_status_code OUT NOCOPY jtf_varchar2_table_100,
1445: x_quote_status OUT NOCOPY jtf_varchar2_table_300,
1446: x_party_name OUT NOCOPY jtf_varchar2_table_300,
1447: x_party_type OUT NOCOPY jtf_varchar2_table_100,
1448: x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
1443: x_price_list_name OUT NOCOPY jtf_varchar2_table_300,
1444: x_quote_status_code OUT NOCOPY jtf_varchar2_table_100,
1445: x_quote_status OUT NOCOPY jtf_varchar2_table_300,
1446: x_party_name OUT NOCOPY jtf_varchar2_table_300,
1447: x_party_type OUT NOCOPY jtf_varchar2_table_100,
1448: x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
1449: x_person_middle_name OUT NOCOPY jtf_varchar2_table_100,
1450: x_person_last_name OUT NOCOPY jtf_varchar2_table_200,
1451: x_marketing_source_name OUT NOCOPY jtf_varchar2_table_200,
1445: x_quote_status OUT NOCOPY jtf_varchar2_table_300,
1446: x_party_name OUT NOCOPY jtf_varchar2_table_300,
1447: x_party_type OUT NOCOPY jtf_varchar2_table_100,
1448: x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
1449: x_person_middle_name OUT NOCOPY jtf_varchar2_table_100,
1450: x_person_last_name OUT NOCOPY jtf_varchar2_table_200,
1451: x_marketing_source_name OUT NOCOPY jtf_varchar2_table_200,
1452: x_marketing_source_code OUT NOCOPY jtf_varchar2_table_200,
1453: x_order_type_name OUT NOCOPY jtf_varchar2_table_300,
1452: x_marketing_source_code OUT NOCOPY jtf_varchar2_table_200,
1453: x_order_type_name OUT NOCOPY jtf_varchar2_table_300,
1454: x_invoice_to_party_name OUT NOCOPY jtf_varchar2_table_300,
1455: x_invoice_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
1456: x_invoice_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
1457: x_invoice_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
1458: x_invoice_to_address1 OUT NOCOPY jtf_varchar2_table_300,
1459: x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1460: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1458: x_invoice_to_address1 OUT NOCOPY jtf_varchar2_table_300,
1459: x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1460: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1461: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1462: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1463: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1464: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1465: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1466: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1459: x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1460: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1461: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1462: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1463: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1464: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1465: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1466: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1467: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1460: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1461: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1462: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1463: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1464: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1465: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1466: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1467: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1468: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
1461: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1462: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1463: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1464: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1465: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1466: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1467: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1468: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
1469: x_resource_id OUT NOCOPY jtf_number_table
1462: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1463: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1464: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1465: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1466: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1467: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1468: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
1469: x_resource_id OUT NOCOPY jtf_number_table
1470: --*/
1463: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
1464: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1465: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1466: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1467: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1468: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
1469: x_resource_id OUT NOCOPY jtf_number_table
1470: --*/
1471: );
1464: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
1465: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1466: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
1467: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
1468: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
1469: x_resource_id OUT NOCOPY jtf_number_table
1470: --*/
1471: );
1472:
1474: p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,
1475: x_quote_line_id OUT NOCOPY jtf_number_table
1476:
1477: /*-- The following output parameters are ignored
1478: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1479: x_creation_date OUT NOCOPY jtf_date_table,
1480: x_created_by OUT NOCOPY jtf_number_table,
1481: x_last_update_date OUT NOCOPY jtf_date_table,
1482: x_last_updated_by OUT NOCOPY jtf_number_table,
1486: x_program_id OUT NOCOPY jtf_number_table,
1487: x_program_update_date OUT NOCOPY jtf_date_table,
1488: x_quote_header_id OUT NOCOPY jtf_number_table,
1489: x_org_id OUT NOCOPY jtf_number_table,
1490: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
1491: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
1492: x_line_number OUT NOCOPY jtf_number_table,
1493: x_start_date_active OUT NOCOPY jtf_date_table,
1494: x_end_date_active OUT NOCOPY jtf_date_table,
1487: x_program_update_date OUT NOCOPY jtf_date_table,
1488: x_quote_header_id OUT NOCOPY jtf_number_table,
1489: x_org_id OUT NOCOPY jtf_number_table,
1490: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
1491: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
1492: x_line_number OUT NOCOPY jtf_number_table,
1493: x_start_date_active OUT NOCOPY jtf_date_table,
1494: x_end_date_active OUT NOCOPY jtf_date_table,
1495: x_order_line_type_id OUT NOCOPY jtf_number_table,
1498: x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,
1499: x_organization_id OUT NOCOPY jtf_number_table,
1500: x_inventory_item_id OUT NOCOPY jtf_number_table,
1501: x_quantity OUT NOCOPY jtf_number_table,
1502: x_uom_code OUT NOCOPY jtf_varchar2_table_100,
1503: x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
1504: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
1505: x_price_list_id OUT NOCOPY jtf_number_table,
1506: x_price_list_line_id OUT NOCOPY jtf_number_table,
1499: x_organization_id OUT NOCOPY jtf_number_table,
1500: x_inventory_item_id OUT NOCOPY jtf_number_table,
1501: x_quantity OUT NOCOPY jtf_number_table,
1502: x_uom_code OUT NOCOPY jtf_varchar2_table_100,
1503: x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
1504: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
1505: x_price_list_id OUT NOCOPY jtf_number_table,
1506: x_price_list_line_id OUT NOCOPY jtf_number_table,
1507: x_currency_code OUT NOCOPY jtf_varchar2_table_100,
1503: x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
1504: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
1505: x_price_list_id OUT NOCOPY jtf_number_table,
1506: x_price_list_line_id OUT NOCOPY jtf_number_table,
1507: x_currency_code OUT NOCOPY jtf_varchar2_table_100,
1508: x_line_list_price OUT NOCOPY jtf_number_table,
1509: x_line_adjusted_amount OUT NOCOPY jtf_number_table,
1510: x_line_adjusted_percent OUT NOCOPY jtf_number_table,
1511: x_line_quote_price OUT NOCOPY jtf_number_table,
1509: x_line_adjusted_amount OUT NOCOPY jtf_number_table,
1510: x_line_adjusted_percent OUT NOCOPY jtf_number_table,
1511: x_line_quote_price OUT NOCOPY jtf_number_table,
1512: x_related_item_id OUT NOCOPY jtf_number_table,
1513: x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
1514: x_accounting_rule_id OUT NOCOPY jtf_number_table,
1515: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1516: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
1517: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
1512: x_related_item_id OUT NOCOPY jtf_number_table,
1513: x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
1514: x_accounting_rule_id OUT NOCOPY jtf_number_table,
1515: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1516: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
1517: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
1518: x_minisite_id OUT NOCOPY jtf_number_table,
1519: x_section_id OUT NOCOPY jtf_number_table,
1520: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
1513: x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
1514: x_accounting_rule_id OUT NOCOPY jtf_number_table,
1515: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
1516: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
1517: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
1518: x_minisite_id OUT NOCOPY jtf_number_table,
1519: x_section_id OUT NOCOPY jtf_number_table,
1520: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
1521: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
1516: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
1517: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
1518: x_minisite_id OUT NOCOPY jtf_number_table,
1519: x_section_id OUT NOCOPY jtf_number_table,
1520: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
1521: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
1522: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1523: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1524: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1517: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
1518: x_minisite_id OUT NOCOPY jtf_number_table,
1519: x_section_id OUT NOCOPY jtf_number_table,
1520: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
1521: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
1522: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1523: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1524: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1525: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1518: x_minisite_id OUT NOCOPY jtf_number_table,
1519: x_section_id OUT NOCOPY jtf_number_table,
1520: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
1521: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
1522: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1523: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1524: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1525: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1526: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1548: p_qte_line_dtl_tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
1549: x_quote_line_detail_id OUT NOCOPY jtf_number_table
1550:
1551: /*-- The following output parameters are ignored
1552: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1553: x_qte_line_index OUT NOCOPY jtf_number_table,
1554: x_creation_date OUT NOCOPY jtf_date_table,
1555: x_created_by OUT NOCOPY jtf_number_table,
1556: x_last_update_date OUT NOCOPY jtf_date_table,
1563: x_quote_line_id OUT NOCOPY jtf_number_table,
1564: x_config_header_id OUT NOCOPY jtf_number_table,
1565: x_config_revision_num OUT NOCOPY jtf_number_table,
1566: x_config_item_id OUT NOCOPY jtf_number_table,
1567: x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
1568: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
1569: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
1570: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
1571: x_service_duration OUT NOCOPY jtf_number_table,
1564: x_config_header_id OUT NOCOPY jtf_number_table,
1565: x_config_revision_num OUT NOCOPY jtf_number_table,
1566: x_config_item_id OUT NOCOPY jtf_number_table,
1567: x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
1568: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
1569: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
1570: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
1571: x_service_duration OUT NOCOPY jtf_number_table,
1572: x_service_period OUT NOCOPY jtf_varchar2_table_100,
1566: x_config_item_id OUT NOCOPY jtf_number_table,
1567: x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
1568: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
1569: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
1570: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
1571: x_service_duration OUT NOCOPY jtf_number_table,
1572: x_service_period OUT NOCOPY jtf_varchar2_table_100,
1573: x_service_unit_selling OUT NOCOPY jtf_number_table,
1574: x_service_unit_list OUT NOCOPY jtf_number_table,
1568: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
1569: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
1570: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
1571: x_service_duration OUT NOCOPY jtf_number_table,
1572: x_service_period OUT NOCOPY jtf_varchar2_table_100,
1573: x_service_unit_selling OUT NOCOPY jtf_number_table,
1574: x_service_unit_list OUT NOCOPY jtf_number_table,
1575: x_service_number OUT NOCOPY jtf_number_table,
1576: x_unit_percent_base_price OUT NOCOPY jtf_number_table,
1573: x_service_unit_selling OUT NOCOPY jtf_number_table,
1574: x_service_unit_list OUT NOCOPY jtf_number_table,
1575: x_service_number OUT NOCOPY jtf_number_table,
1576: x_unit_percent_base_price OUT NOCOPY jtf_number_table,
1577: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1578: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1579: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1580: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1581: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1589: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1590: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1591: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1592: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1593: x_service_ref_type_code OUT NOCOPY jtf_varchar2_table_100,
1594: x_service_ref_order_number OUT NOCOPY jtf_number_table,
1595: x_service_ref_line_number OUT NOCOPY jtf_number_table,
1596: x_service_ref_qte_line_ind OUT NOCOPY jtf_number_table,
1597: x_service_ref_line_id OUT NOCOPY jtf_number_table,
1597: x_service_ref_line_id OUT NOCOPY jtf_number_table,
1598: x_service_ref_system_id OUT NOCOPY jtf_number_table,
1599: x_service_ref_option_numb OUT NOCOPY jtf_number_table,
1600: x_service_ref_shipment OUT NOCOPY jtf_number_table,
1601: x_return_ref_type OUT NOCOPY jtf_varchar2_table_100,
1602: x_return_ref_header_id OUT NOCOPY jtf_number_table,
1603: x_return_ref_line_id OUT NOCOPY jtf_number_table,
1604: x_return_attribute1 OUT NOCOPY jtf_varchar2_table_300,
1605: x_return_attribute2 OUT NOCOPY jtf_varchar2_table_300,
1615: x_return_attribute15 OUT NOCOPY jtf_varchar2_table_300,
1616: x_return_attribute12 OUT NOCOPY jtf_varchar2_table_300,
1617: x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
1618: x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
1619: x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
1620: x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
1621: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
1622: --*/
1623: );
1616: x_return_attribute12 OUT NOCOPY jtf_varchar2_table_300,
1617: x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
1618: x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
1619: x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
1620: x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
1621: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
1622: --*/
1623: );
1624:
1617: x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
1618: x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
1619: x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
1620: x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
1621: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
1622: --*/
1623: );
1624:
1625: PROCEDURE Set_Line_Rltship_Tbl_Out(
1626: p_qte_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type,
1627: x_line_relationship_id OUT NOCOPY jtf_number_table
1628:
1629: /*-- The following output parameters are ignored
1630: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1631: x_creation_date OUT NOCOPY jtf_date_table,
1632: x_created_by OUT NOCOPY jtf_number_table,
1633: x_last_update_date OUT NOCOPY jtf_date_table,
1634: x_last_updated_by OUT NOCOPY jtf_number_table,
1640: x_quote_line_id OUT NOCOPY jtf_number_table,
1641: x_qte_line_index OUT NOCOPY jtf_number_table,
1642: x_related_quote_line_id OUT NOCOPY jtf_number_table,
1643: x_related_qte_line_index OUT NOCOPY jtf_number_table,
1644: x_relationship_type_code OUT NOCOPY jtf_varchar2_table_100,
1645: x_reciprocal_flag OUT NOCOPY jtf_varchar2_table_100
1646: --*/
1647: );
1648:
1641: x_qte_line_index OUT NOCOPY jtf_number_table,
1642: x_related_quote_line_id OUT NOCOPY jtf_number_table,
1643: x_related_qte_line_index OUT NOCOPY jtf_number_table,
1644: x_relationship_type_code OUT NOCOPY jtf_varchar2_table_100,
1645: x_reciprocal_flag OUT NOCOPY jtf_varchar2_table_100
1646: --*/
1647: );
1648:
1649: PROCEDURE Set_Payment_Tbl_Out(
1650: p_qte_payment_tbl IN ASO_Quote_Pub.Payment_Tbl_Type,
1651: x_payment_id OUT NOCOPY jtf_number_table
1652:
1653: /*-- The following output parameters are ignored
1654: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1655: x_qte_line_index OUT NOCOPY jtf_number_table,
1656: x_shipment_index OUT NOCOPY jtf_number_table,
1657: x_creation_date OUT NOCOPY jtf_date_table,
1658: x_created_by OUT NOCOPY jtf_number_table,
1665: x_program_update_date OUT NOCOPY jtf_date_table,
1666: x_quote_header_id OUT NOCOPY jtf_number_table,
1667: x_quote_line_id OUT NOCOPY jtf_number_table,
1668: x_quote_shipment_id OUT NOCOPY jtf_number_table,
1669: x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,
1670: x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
1671: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
1672: x_payment_term_id OUT NOCOPY jtf_number_table,
1673: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
1669: x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,
1670: x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
1671: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
1672: x_payment_term_id OUT NOCOPY jtf_number_table,
1673: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
1674: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
1675: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
1676: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
1677: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
1670: x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
1671: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
1672: x_payment_term_id OUT NOCOPY jtf_number_table,
1673: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
1674: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
1675: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
1676: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
1677: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
1678: x_payment_amount OUT NOCOPY jtf_number_table,
1672: x_payment_term_id OUT NOCOPY jtf_number_table,
1673: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
1674: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
1675: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
1676: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
1677: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
1678: x_payment_amount OUT NOCOPY jtf_number_table,
1679: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1680: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1675: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
1676: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
1677: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
1678: x_payment_amount OUT NOCOPY jtf_number_table,
1679: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1680: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1681: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1682: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1683: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1691: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1692: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1693: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1694: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1695: x_cust_po_number OUT NOCOPY jtf_varchar2_table_100
1696: --*/
1697: );
1698:
1699: PROCEDURE Set_Shipment_Tbl_Out(
1700: p_qte_shipment_tbl IN ASO_Quote_Pub.Shipment_Tbl_Type,
1701: x_shipment_id OUT NOCOPY jtf_number_table
1702:
1703: /*-- The following output parameters are ignored
1704: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1705: x_qte_line_index OUT NOCOPY jtf_number_table,
1706: x_creation_date OUT NOCOPY jtf_date_table,
1707: x_created_by OUT NOCOPY jtf_number_table,
1708: x_last_update_date OUT NOCOPY jtf_date_table,
1721: x_ship_to_party_id OUT NOCOPY jtf_number_table,
1722: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
1723: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
1724: x_ship_set_id OUT NOCOPY jtf_number_table,
1725: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
1726: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
1727: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
1728: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
1729: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
1722: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
1723: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
1724: x_ship_set_id OUT NOCOPY jtf_number_table,
1725: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
1726: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
1727: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
1728: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
1729: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
1730: x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
1723: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
1724: x_ship_set_id OUT NOCOPY jtf_number_table,
1725: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
1726: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
1727: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
1728: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
1729: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
1730: x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
1731: x_ship_quote_price OUT NOCOPY jtf_number_table,
1724: x_ship_set_id OUT NOCOPY jtf_number_table,
1725: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
1726: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
1727: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
1728: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
1729: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
1730: x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
1731: x_ship_quote_price OUT NOCOPY jtf_number_table,
1732: x_quantity OUT NOCOPY jtf_number_table,
1735: x_reservation_id OUT NOCOPY jtf_number_table,
1736: x_order_line_id OUT NOCOPY jtf_number_table,
1737: x_ship_to_party_name OUT NOCOPY jtf_varchar2_table_300,
1738: x_ship_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
1739: x_ship_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
1740: x_ship_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
1741: x_ship_to_address1 OUT NOCOPY jtf_varchar2_table_300,
1742: x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1743: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1741: x_ship_to_address1 OUT NOCOPY jtf_varchar2_table_300,
1742: x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1743: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1744: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1745: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1746: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1747: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1748: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1749: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1742: x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
1743: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1744: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1745: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1746: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1747: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1748: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1749: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1750: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1743: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
1744: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1745: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1746: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1747: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1748: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1749: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1750: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1751: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1744: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
1745: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1746: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1747: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1748: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1749: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1750: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1751: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1752: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1745: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
1746: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1747: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1748: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1749: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1750: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1751: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1752: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1753: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1746: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
1747: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1748: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1749: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1750: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1751: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1752: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1753: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1754: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1747: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
1748: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1749: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1750: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1751: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1752: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1753: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1754: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1755: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1748: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
1749: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
1750: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
1751: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
1752: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1753: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1754: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1755: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1756: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1764: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1765: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1766: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1767: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1768: x_shipment_priority_code OUT NOCOPY jtf_varchar2_table_100,
1769: x_ship_from_org_id OUT NOCOPY jtf_number_table
1770: --*/
1771: );
1772:
1774: p_qte_tax_detail_tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type,
1775: x_tax_detail_id OUT NOCOPY jtf_number_table
1776:
1777: /*-- The following output parameters are ignored
1778: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1779: x_qte_line_index OUT NOCOPY jtf_number_table,
1780: x_shipment_index OUT NOCOPY jtf_number_table,
1781: x_quote_header_id OUT NOCOPY jtf_number_table,
1782: x_quote_line_id OUT NOCOPY jtf_number_table,
1790: x_program_application_id OUT NOCOPY jtf_number_table,
1791: x_program_id OUT NOCOPY jtf_number_table,
1792: x_program_update_date OUT NOCOPY jtf_date_table,
1793: x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
1794: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1795: x_tax_rate OUT NOCOPY jtf_number_table,
1796: x_tax_date OUT NOCOPY jtf_date_table,
1797: x_tax_amount OUT NOCOPY jtf_number_table,
1798: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1794: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1795: x_tax_rate OUT NOCOPY jtf_number_table,
1796: x_tax_date OUT NOCOPY jtf_date_table,
1797: x_tax_amount OUT NOCOPY jtf_number_table,
1798: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1799: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1800: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1801: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1802: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1795: x_tax_rate OUT NOCOPY jtf_number_table,
1796: x_tax_date OUT NOCOPY jtf_date_table,
1797: x_tax_amount OUT NOCOPY jtf_number_table,
1798: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1799: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1800: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1801: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1802: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1803: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1796: x_tax_date OUT NOCOPY jtf_date_table,
1797: x_tax_amount OUT NOCOPY jtf_number_table,
1798: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1799: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1800: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1801: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1802: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1803: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1804: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1797: x_tax_amount OUT NOCOPY jtf_number_table,
1798: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1799: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1800: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1801: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1802: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1803: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1804: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1805: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1821: p_qte_price_adj_tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type,
1822: x_price_adjustment_id OUT NOCOPY jtf_number_table
1823:
1824: /*-- The following output parameters are ignored
1825: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1826: x_qte_line_index OUT NOCOPY jtf_number_table,
1827: x_shipment_index OUT NOCOPY jtf_number_table,
1828: x_creation_date OUT NOCOPY jtf_date_table,
1829: x_created_by OUT NOCOPY jtf_number_table,
1838: x_quote_line_id OUT NOCOPY jtf_number_table,
1839: x_quote_shipment_id OUT NOCOPY jtf_number_table,
1840: x_modifier_header_id OUT NOCOPY jtf_number_table,
1841: x_modifier_line_id OUT NOCOPY jtf_number_table,
1842: x_modifier_line_type_code OUT NOCOPY jtf_varchar2_table_100,
1843: x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
1844: x_modified_from OUT NOCOPY jtf_number_table,
1845: x_modified_to OUT NOCOPY jtf_number_table,
1846: x_operand OUT NOCOPY jtf_number_table,
1839: x_quote_shipment_id OUT NOCOPY jtf_number_table,
1840: x_modifier_header_id OUT NOCOPY jtf_number_table,
1841: x_modifier_line_id OUT NOCOPY jtf_number_table,
1842: x_modifier_line_type_code OUT NOCOPY jtf_varchar2_table_100,
1843: x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
1844: x_modified_from OUT NOCOPY jtf_number_table,
1845: x_modified_to OUT NOCOPY jtf_number_table,
1846: x_operand OUT NOCOPY jtf_number_table,
1847: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1843: x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
1844: x_modified_from OUT NOCOPY jtf_number_table,
1845: x_modified_to OUT NOCOPY jtf_number_table,
1846: x_operand OUT NOCOPY jtf_number_table,
1847: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1848: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1849: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1850: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1851: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1844: x_modified_from OUT NOCOPY jtf_number_table,
1845: x_modified_to OUT NOCOPY jtf_number_table,
1846: x_operand OUT NOCOPY jtf_number_table,
1847: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1848: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1849: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1850: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1851: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1852: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1845: x_modified_to OUT NOCOPY jtf_number_table,
1846: x_operand OUT NOCOPY jtf_number_table,
1847: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1848: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1849: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1850: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1851: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1852: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1853: x_pricing_phase_id OUT NOCOPY jtf_number_table,
1846: x_operand OUT NOCOPY jtf_number_table,
1847: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1848: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1849: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1850: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1851: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1852: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1853: x_pricing_phase_id OUT NOCOPY jtf_number_table,
1854: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1847: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
1848: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1849: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1850: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1851: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1852: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1853: x_pricing_phase_id OUT NOCOPY jtf_number_table,
1854: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1855: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1848: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
1849: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
1850: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1851: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1852: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1853: x_pricing_phase_id OUT NOCOPY jtf_number_table,
1854: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1855: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1856: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1850: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
1851: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
1852: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1853: x_pricing_phase_id OUT NOCOPY jtf_number_table,
1854: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
1855: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1856: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1857: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1858: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
1866: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
1867: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1868: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1869: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1870: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
1871: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
1872: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
1873: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1874: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1867: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
1868: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1869: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1870: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
1871: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
1872: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
1873: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1874: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1875: x_cost_id OUT NOCOPY jtf_number_table,
1868: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
1869: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1870: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
1871: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
1872: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
1873: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1874: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1875: x_cost_id OUT NOCOPY jtf_number_table,
1876: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1869: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
1870: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
1871: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
1872: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
1873: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1874: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1875: x_cost_id OUT NOCOPY jtf_number_table,
1876: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1877: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1872: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
1873: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1874: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1875: x_cost_id OUT NOCOPY jtf_number_table,
1876: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1877: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1878: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1879: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1880: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1873: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
1874: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1875: x_cost_id OUT NOCOPY jtf_number_table,
1876: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1877: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1878: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1879: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1880: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1881: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1874: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
1875: x_cost_id OUT NOCOPY jtf_number_table,
1876: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1877: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1878: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1879: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1880: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1881: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1882: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1875: x_cost_id OUT NOCOPY jtf_number_table,
1876: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
1877: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1878: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1879: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1880: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1881: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1882: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1883: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1877: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
1878: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1879: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1880: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1881: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1882: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1883: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1884: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1885: x_adjusted_amount OUT NOCOPY jtf_number_table,
1878: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
1879: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1880: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1881: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1882: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1883: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1884: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1885: x_adjusted_amount OUT NOCOPY jtf_number_table,
1886: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
1879: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
1880: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1881: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1882: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1883: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1884: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1885: x_adjusted_amount OUT NOCOPY jtf_number_table,
1886: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
1887: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
1880: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
1881: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
1882: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1883: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1884: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1885: x_adjusted_amount OUT NOCOPY jtf_number_table,
1886: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
1887: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
1888: x_range_break_quantity OUT NOCOPY jtf_number_table,
1882: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
1883: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1884: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1885: x_adjusted_amount OUT NOCOPY jtf_number_table,
1886: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
1887: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
1888: x_range_break_quantity OUT NOCOPY jtf_number_table,
1889: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
1890: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
1883: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
1884: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
1885: x_adjusted_amount OUT NOCOPY jtf_number_table,
1886: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
1887: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
1888: x_range_break_quantity OUT NOCOPY jtf_number_table,
1889: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
1890: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
1891: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
1887: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
1888: x_range_break_quantity OUT NOCOPY jtf_number_table,
1889: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
1890: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
1891: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
1892: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
1893: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
1894: x_benefit_qty OUT NOCOPY jtf_number_table,
1895: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1889: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
1890: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
1891: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
1892: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
1893: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
1894: x_benefit_qty OUT NOCOPY jtf_number_table,
1895: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1896: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1897: x_expiration_date OUT NOCOPY jtf_date_table,
1891: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
1892: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
1893: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
1894: x_benefit_qty OUT NOCOPY jtf_number_table,
1895: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1896: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1897: x_expiration_date OUT NOCOPY jtf_date_table,
1898: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1899: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1892: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
1893: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
1894: x_benefit_qty OUT NOCOPY jtf_number_table,
1895: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1896: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1897: x_expiration_date OUT NOCOPY jtf_date_table,
1898: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1899: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1900: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1894: x_benefit_qty OUT NOCOPY jtf_number_table,
1895: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1896: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1897: x_expiration_date OUT NOCOPY jtf_date_table,
1898: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1899: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1900: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1901: x_redeemed_date OUT NOCOPY jtf_date_table,
1902: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1895: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
1896: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1897: x_expiration_date OUT NOCOPY jtf_date_table,
1898: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1899: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1900: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1901: x_redeemed_date OUT NOCOPY jtf_date_table,
1902: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1903: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1896: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
1897: x_expiration_date OUT NOCOPY jtf_date_table,
1898: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1899: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1900: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1901: x_redeemed_date OUT NOCOPY jtf_date_table,
1902: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1903: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1904: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1898: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
1899: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1900: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1901: x_redeemed_date OUT NOCOPY jtf_date_table,
1902: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1903: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1904: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1905: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1906: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1899: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
1900: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1901: x_redeemed_date OUT NOCOPY jtf_date_table,
1902: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1903: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1904: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1905: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1906: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1907: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1900: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
1901: x_redeemed_date OUT NOCOPY jtf_date_table,
1902: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1903: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1904: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1905: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1906: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1907: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1908: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
1901: x_redeemed_date OUT NOCOPY jtf_date_table,
1902: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1903: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1904: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1905: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1906: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1907: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1908: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
1909: --*/
1902: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
1903: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1904: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1905: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1906: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1907: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1908: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
1909: --*/
1910: );
1903: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
1904: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1905: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1906: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1907: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1908: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
1909: --*/
1910: );
1911:
1904: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
1905: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
1906: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
1907: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
1908: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
1909: --*/
1910: );
1911:
1912: PROCEDURE Set_Price_Attributes_Tbl_Out(
1913: p_qte_price_attributes_tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type,
1914: x_price_attribute_id OUT NOCOPY jtf_number_table
1915:
1916: /*-- The following output parameters are ignored
1917: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
1918: x_qte_line_index OUT NOCOPY jtf_number_table,
1919: x_creation_date OUT NOCOPY jtf_date_table,
1920: x_created_by OUT NOCOPY jtf_number_table,
1921: x_last_update_date OUT NOCOPY jtf_date_table,
1926: x_program_id OUT NOCOPY jtf_number_table,
1927: x_program_update_date OUT NOCOPY jtf_date_table,
1928: x_quote_header_id OUT NOCOPY jtf_number_table,
1929: x_quote_line_id OUT NOCOPY jtf_number_table,
1930: x_flex_title OUT NOCOPY jtf_varchar2_table_100,
1931: x_pricing_context OUT NOCOPY jtf_varchar2_table_100,
1932: x_pricing_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1933: x_pricing_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1934: x_pricing_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1927: x_program_update_date OUT NOCOPY jtf_date_table,
1928: x_quote_header_id OUT NOCOPY jtf_number_table,
1929: x_quote_line_id OUT NOCOPY jtf_number_table,
1930: x_flex_title OUT NOCOPY jtf_varchar2_table_100,
1931: x_pricing_context OUT NOCOPY jtf_varchar2_table_100,
1932: x_pricing_attribute1 OUT NOCOPY jtf_varchar2_table_200,
1933: x_pricing_attribute2 OUT NOCOPY jtf_varchar2_table_200,
1934: x_pricing_attribute3 OUT NOCOPY jtf_varchar2_table_200,
1935: x_pricing_attribute4 OUT NOCOPY jtf_varchar2_table_200,
2028: x_pricing_attribute97 OUT NOCOPY jtf_varchar2_table_200,
2029: x_pricing_attribute98 OUT NOCOPY jtf_varchar2_table_200,
2030: x_pricing_attribute99 OUT NOCOPY jtf_varchar2_table_200,
2031: x_pricing_attribute100 OUT NOCOPY jtf_varchar2_table_200,
2032: x_context OUT NOCOPY jtf_varchar2_table_100,
2033: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
2034: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
2035: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
2036: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
2053: x_sales_credit_id OUT NOCOPY jtf_number_table
2054:
2055: /*-- The following output parameters are ignored
2056: x_qte_line_index OUT NOCOPY jtf_number_table,
2057: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
2058: x_creation_date OUT NOCOPY jtf_date_table,
2059: x_created_by OUT NOCOPY jtf_number_table,
2060: x_last_updated_by OUT NOCOPY jtf_number_table,
2061: x_last_update_date OUT NOCOPY jtf_date_table,
2073: x_sales_credit_type OUT NOCOPY jtf_varchar2_table_300,
2074: x_resource_group_id OUT NOCOPY jtf_number_table,
2075: x_employee_person_id OUT NOCOPY jtf_number_table,
2076: x_sales_credit_type_id OUT NOCOPY jtf_number_table,
2077: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
2078: x_attribute1 OUT NOCOPY jtf_varchar2_table_300,
2079: x_attribute2 OUT NOCOPY jtf_varchar2_table_300,
2080: x_attribute3 OUT NOCOPY jtf_varchar2_table_300,
2081: x_attribute4 OUT NOCOPY jtf_varchar2_table_300,
2100: x_approver_person_id OUT NOCOPY jtf_number_table,
2101: x_approver_user_id OUT NOCOPY jtf_number_table,
2102: x_notification_id OUT NOCOPY jtf_number_table,
2103: x_approver_sequence OUT NOCOPY jtf_number_table,
2104: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
2105: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
2106: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
2107: x_date_sent OUT NOCOPY jtf_date_table,
2108: x_date_received OUT NOCOPY jtf_date_table
2101: x_approver_user_id OUT NOCOPY jtf_number_table,
2102: x_notification_id OUT NOCOPY jtf_number_table,
2103: x_approver_sequence OUT NOCOPY jtf_number_table,
2104: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
2105: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
2106: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
2107: x_date_sent OUT NOCOPY jtf_date_table,
2108: x_date_received OUT NOCOPY jtf_date_table
2109: );
2149: x_identifier OUT NOCOPY JTF_NUMBER_TABLE,
2150: x_customer_id OUT NOCOPY JTF_NUMBER_TABLE,
2151: x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
2152: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
2153: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2154: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2155: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
2156: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
2157: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2150: x_customer_id OUT NOCOPY JTF_NUMBER_TABLE,
2151: x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
2152: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
2153: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2154: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2155: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
2156: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
2157: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2158: x_request_date_quantity OUT NOCOPY JTF_NUMBER_TABLE,
2209: RETURN ASO_Quote_Pub.Template_Rec_Type;
2210:
2211:
2212: FUNCTION Construct_Trigger_Attr_Tbl(
2213: p_trigger_attribute IN jtf_varchar2_table_100 := NULL
2214: )
2215: RETURN ASO_Defaulting_Int.Attribute_Codes_Tbl_Type;
2216:
2217:
2666:
2667: PROCEDURE Set_Config_Valid_Table_Out(
2668: p_config_table IN ASO_QUOTE_PUB.Config_Vaild_Tbl_Type,
2669: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
2670: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2671: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2672: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
2673: );
2674:
2667: PROCEDURE Set_Config_Valid_Table_Out(
2668: p_config_table IN ASO_QUOTE_PUB.Config_Vaild_Tbl_Type,
2669: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
2670: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2671: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2672: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
2673: );
2674:
2675: PROCEDURE Set_num_Tbl_Out (
2668: p_config_table IN ASO_QUOTE_PUB.Config_Vaild_Tbl_Type,
2669: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
2670: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2671: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2672: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
2673: );
2674:
2675: PROCEDURE Set_num_Tbl_Out (
2676: p_num_tbl IN ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE,
2677: x_num_id OUT NOCOPY JTF_NUMBER_TABLE
2678: );
2679:
2680: FUNCTION Construct_Related_Obj_Tbl(
2681: p_operation_code IN jtf_varchar2_table_100 := NULL,
2682: p_RELATED_OBJECT_ID IN jtf_number_table := NULL,
2683: p_CREATION_DATE IN jtf_date_table := null,
2684: p_CREATED_BY IN jtf_number_table := NULL,
2685: p_LAST_UPDATE_DATE IN jtf_date_table := null,
2693: p_QUOTE_OBJECT_ID IN jtf_number_table := NULL,
2694: p_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
2695: p_OBJECT_ID IN jtf_number_table := NULL,
2696: p_RELATIONSHIP_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
2697: p_RECIPROCAL_FLAG IN jtf_varchar2_table_100 := NULL,
2698: p_QUOTE_OBJECT_CODE IN jtf_number_table := NULL,
2699: p_OBJECT_VERSION_NUMBER IN jtf_number_table := NULL
2700: )
2701: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;