[Home] [Help]
1089: p_quote_line_id IN jtf_number_table := NULL,
1090: p_quote_header_id IN jtf_number_table := NULL,
1091: p_org_id IN jtf_number_table := NULL,
1092: p_line_number IN jtf_number_table := NULL,
1093: p_line_category_code IN jtf_varchar2_table_100 := NULL,
1094: p_item_type_code IN jtf_varchar2_table_100 := NULL,
1095: p_inventory_item_id IN jtf_number_table := NULL,
1096: p_organization_id IN jtf_number_table := NULL,
1097: p_quantity IN jtf_number_table := NULL,
1090: p_quote_header_id IN jtf_number_table := NULL,
1091: p_org_id IN jtf_number_table := NULL,
1092: p_line_number IN jtf_number_table := NULL,
1093: p_line_category_code IN jtf_varchar2_table_100 := NULL,
1094: p_item_type_code IN jtf_varchar2_table_100 := NULL,
1095: p_inventory_item_id IN jtf_number_table := NULL,
1096: p_organization_id IN jtf_number_table := NULL,
1097: p_quantity IN jtf_number_table := NULL,
1098: p_uom_code IN jtf_varchar2_table_100 := NULL,
1094: p_item_type_code IN jtf_varchar2_table_100 := NULL,
1095: p_inventory_item_id IN jtf_number_table := NULL,
1096: p_organization_id IN jtf_number_table := NULL,
1097: p_quantity IN jtf_number_table := NULL,
1098: p_uom_code IN jtf_varchar2_table_100 := NULL,
1099: p_start_date_active IN jtf_date_table := NULL,
1100: p_end_date_active IN jtf_date_table := NULL,
1101: p_order_line_type_id IN jtf_number_table := NULL,
1102: p_price_list_id IN jtf_number_table := NULL,
1100: p_end_date_active IN jtf_date_table := NULL,
1101: p_order_line_type_id IN jtf_number_table := NULL,
1102: p_price_list_id IN jtf_number_table := NULL,
1103: p_price_list_line_id IN jtf_number_table := NULL,
1104: p_currency_code IN jtf_varchar2_table_100 := NULL,
1105: p_line_list_price IN jtf_number_table := NULL,
1106: p_line_adjusted_amount IN jtf_number_table := NULL,
1107: p_line_adjusted_percent IN jtf_number_table := NULL,
1108: p_line_quote_price IN jtf_number_table := NULL,
1106: p_line_adjusted_amount IN jtf_number_table := NULL,
1107: p_line_adjusted_percent IN jtf_number_table := NULL,
1108: p_line_quote_price IN jtf_number_table := NULL,
1109: p_related_item_id IN jtf_number_table := NULL,
1110: p_item_relationship_type IN jtf_varchar2_table_100 := NULL,
1111: p_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
1112: p_backorder_flag IN jtf_varchar2_table_100 := NULL,
1113: p_selling_price_change IN jtf_varchar2_table_100 := NULL,
1114: p_recalculate_flag IN jtf_varchar2_table_100 := NULL,
1107: p_line_adjusted_percent IN jtf_number_table := NULL,
1108: p_line_quote_price IN jtf_number_table := NULL,
1109: p_related_item_id IN jtf_number_table := NULL,
1110: p_item_relationship_type IN jtf_varchar2_table_100 := NULL,
1111: p_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
1112: p_backorder_flag IN jtf_varchar2_table_100 := NULL,
1113: p_selling_price_change IN jtf_varchar2_table_100 := NULL,
1114: p_recalculate_flag IN jtf_varchar2_table_100 := NULL,
1115: p_attribute_category IN jtf_varchar2_table_100 := NULL,
1108: p_line_quote_price IN jtf_number_table := NULL,
1109: p_related_item_id IN jtf_number_table := NULL,
1110: p_item_relationship_type IN jtf_varchar2_table_100 := NULL,
1111: p_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
1112: p_backorder_flag IN jtf_varchar2_table_100 := NULL,
1113: p_selling_price_change IN jtf_varchar2_table_100 := NULL,
1114: p_recalculate_flag IN jtf_varchar2_table_100 := NULL,
1115: p_attribute_category IN jtf_varchar2_table_100 := NULL,
1116: p_attribute1 IN jtf_varchar2_table_300 := NULL,
1109: p_related_item_id IN jtf_number_table := NULL,
1110: p_item_relationship_type IN jtf_varchar2_table_100 := NULL,
1111: p_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
1112: p_backorder_flag IN jtf_varchar2_table_100 := NULL,
1113: p_selling_price_change IN jtf_varchar2_table_100 := NULL,
1114: p_recalculate_flag IN jtf_varchar2_table_100 := NULL,
1115: p_attribute_category IN jtf_varchar2_table_100 := NULL,
1116: p_attribute1 IN jtf_varchar2_table_300 := NULL,
1117: p_attribute2 IN jtf_varchar2_table_300 := NULL,
1110: p_item_relationship_type IN jtf_varchar2_table_100 := NULL,
1111: p_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
1112: p_backorder_flag IN jtf_varchar2_table_100 := NULL,
1113: p_selling_price_change IN jtf_varchar2_table_100 := NULL,
1114: p_recalculate_flag IN jtf_varchar2_table_100 := NULL,
1115: p_attribute_category IN jtf_varchar2_table_100 := NULL,
1116: p_attribute1 IN jtf_varchar2_table_300 := NULL,
1117: p_attribute2 IN jtf_varchar2_table_300 := NULL,
1118: p_attribute3 IN jtf_varchar2_table_300 := NULL,
1111: p_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
1112: p_backorder_flag IN jtf_varchar2_table_100 := NULL,
1113: p_selling_price_change IN jtf_varchar2_table_100 := NULL,
1114: p_recalculate_flag IN jtf_varchar2_table_100 := NULL,
1115: p_attribute_category IN jtf_varchar2_table_100 := NULL,
1116: p_attribute1 IN jtf_varchar2_table_300 := NULL,
1117: p_attribute2 IN jtf_varchar2_table_300 := NULL,
1118: p_attribute3 IN jtf_varchar2_table_300 := NULL,
1119: p_attribute4 IN jtf_varchar2_table_300 := NULL,
1138: p_invoice_to_party_id IN jtf_number_table := NULL,
1139: p_invoice_to_party_site_id IN jtf_number_table := NULL,
1140: p_invoicing_rule_id IN jtf_number_table := NULL,
1141: p_marketing_source_code_id IN jtf_number_table := NULL,
1142: p_operation_code IN jtf_varchar2_table_100 := NULL,
1143: p_invoice_to_cust_account_id IN jtf_number_table := NULL,
1144: p_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
1145: p_minisite_id IN jtf_number_table := NULL,
1146: p_section_id IN jtf_number_table := NULL,
1140: p_invoicing_rule_id IN jtf_number_table := NULL,
1141: p_marketing_source_code_id IN jtf_number_table := NULL,
1142: p_operation_code IN jtf_varchar2_table_100 := NULL,
1143: p_invoice_to_cust_account_id IN jtf_number_table := NULL,
1144: p_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
1145: p_minisite_id IN jtf_number_table := NULL,
1146: p_section_id IN jtf_number_table := NULL,
1147: p_priced_price_list_id IN jtf_number_table := NULL,
1148: p_agreement_id IN jtf_number_table := NULL,
1146: p_section_id IN jtf_number_table := NULL,
1147: p_priced_price_list_id IN jtf_number_table := NULL,
1148: p_agreement_id IN jtf_number_table := NULL,
1149: p_commitment_id IN jtf_number_table := NULL,
1150: p_display_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
1151: p_invoice_to_cust_party_id IN jtf_number_table := NULL,
1152: p_attribute16 IN jtf_varchar2_table_300 := NULL,
1153: p_attribute17 IN jtf_varchar2_table_300 := NULL,
1154: p_attribute18 IN jtf_varchar2_table_300 := NULL,
1153: p_attribute17 IN jtf_varchar2_table_300 := NULL,
1154: p_attribute18 IN jtf_varchar2_table_300 := NULL,
1155: p_attribute19 IN jtf_varchar2_table_300 := NULL,
1156: p_attribute20 IN jtf_varchar2_table_300 := NULL,
1157: p_ship_model_complete_flag IN jtf_varchar2_table_100 := NULL,
1158: p_charge_periodicity_code IN jtf_varchar2_table_100 := NULL,
1159: p_end_customer_party_id IN jtf_number_table := NULL,
1160: p_end_customer_party_site_id IN jtf_number_table := NULL,
1161: p_end_customer_cust_account_id IN jtf_number_table := NULL,
1154: p_attribute18 IN jtf_varchar2_table_300 := NULL,
1155: p_attribute19 IN jtf_varchar2_table_300 := NULL,
1156: p_attribute20 IN jtf_varchar2_table_300 := NULL,
1157: p_ship_model_complete_flag IN jtf_varchar2_table_100 := NULL,
1158: p_charge_periodicity_code IN jtf_varchar2_table_100 := NULL,
1159: p_end_customer_party_id IN jtf_number_table := NULL,
1160: p_end_customer_party_site_id IN jtf_number_table := NULL,
1161: p_end_customer_cust_account_id IN jtf_number_table := NULL,
1162: p_end_customer_cust_party_id IN jtf_number_table := NULL,
1163: p_object_version_number IN jtf_number_table := NULL,
1164: p_line_paynow_charges IN jtf_number_table := NULL,
1165: p_line_paynow_tax IN jtf_number_table := NULL,
1166: p_line_paynow_subtotal IN jtf_number_table := NULL,
1167: p_config_model_type IN jtf_varchar2_table_100 := NULL
1168: )
1169: RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type
1170: IS
1171: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
1975: p_quote_line_id IN jtf_number_table := NULL,
1976: p_config_header_id IN jtf_number_table := NULL,
1977: p_config_revision_num IN jtf_number_table := NULL,
1978: p_config_item_id IN jtf_number_table := NULL,
1979: p_complete_configuration IN jtf_varchar2_table_100 := NULL,
1980: p_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
1981: p_component_code IN jtf_varchar2_table_1200 := NULL,
1982: p_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
1983: p_service_duration IN jtf_number_table := NULL,
1976: p_config_header_id IN jtf_number_table := NULL,
1977: p_config_revision_num IN jtf_number_table := NULL,
1978: p_config_item_id IN jtf_number_table := NULL,
1979: p_complete_configuration IN jtf_varchar2_table_100 := NULL,
1980: p_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
1981: p_component_code IN jtf_varchar2_table_1200 := NULL,
1982: p_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
1983: p_service_duration IN jtf_number_table := NULL,
1984: p_service_period IN jtf_varchar2_table_100 := NULL,
1978: p_config_item_id IN jtf_number_table := NULL,
1979: p_complete_configuration IN jtf_varchar2_table_100 := NULL,
1980: p_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
1981: p_component_code IN jtf_varchar2_table_1200 := NULL,
1982: p_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
1983: p_service_duration IN jtf_number_table := NULL,
1984: p_service_period IN jtf_varchar2_table_100 := NULL,
1985: p_service_unit_selling IN jtf_number_table := NULL,
1986: p_service_unit_list IN jtf_number_table := NULL,
1980: p_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
1981: p_component_code IN jtf_varchar2_table_1200 := NULL,
1982: p_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
1983: p_service_duration IN jtf_number_table := NULL,
1984: p_service_period IN jtf_varchar2_table_100 := NULL,
1985: p_service_unit_selling IN jtf_number_table := NULL,
1986: p_service_unit_list IN jtf_number_table := NULL,
1987: p_service_number IN jtf_number_table := NULL,
1988: p_unit_percent_base_price IN jtf_number_table := NULL,
1985: p_service_unit_selling IN jtf_number_table := NULL,
1986: p_service_unit_list IN jtf_number_table := NULL,
1987: p_service_number IN jtf_number_table := NULL,
1988: p_unit_percent_base_price IN jtf_number_table := NULL,
1989: p_attribute_category IN jtf_varchar2_table_100 := NULL,
1990: p_attribute1 IN jtf_varchar2_table_300 := NULL,
1991: p_attribute2 IN jtf_varchar2_table_300 := NULL,
1992: p_attribute3 IN jtf_varchar2_table_300 := NULL,
1993: p_attribute4 IN jtf_varchar2_table_300 := NULL,
2001: p_attribute12 IN jtf_varchar2_table_300 := NULL,
2002: p_attribute13 IN jtf_varchar2_table_300 := NULL,
2003: p_attribute14 IN jtf_varchar2_table_300 := NULL,
2004: p_attribute15 IN jtf_varchar2_table_300 := NULL,
2005: p_service_ref_type_code IN jtf_varchar2_table_100 := NULL,
2006: p_service_ref_order_number IN jtf_number_table := NULL,
2007: p_service_ref_line_number IN jtf_number_table := NULL,
2008: p_service_ref_qte_line_ind IN jtf_number_table := NULL,
2009: p_service_ref_line_id IN jtf_number_table := NULL,
2009: p_service_ref_line_id IN jtf_number_table := NULL,
2010: p_service_ref_system_id IN jtf_number_table := NULL,
2011: p_service_ref_option_numb IN jtf_number_table := NULL,
2012: p_service_ref_shipment IN jtf_number_table := NULL,
2013: p_return_ref_type IN jtf_varchar2_table_100 := NULL,
2014: p_return_ref_header_id IN jtf_number_table := NULL,
2015: p_return_ref_line_id IN jtf_number_table := NULL,
2016: p_return_attribute1 IN jtf_varchar2_table_300 := NULL,
2017: p_return_attribute2 IN jtf_varchar2_table_300 := NULL,
2027: p_return_attribute12 IN jtf_varchar2_table_300 := NULL,
2028: p_return_attribute13 IN jtf_varchar2_table_300 := NULL,
2029: p_return_attribute14 IN jtf_varchar2_table_300 := NULL,
2030: p_return_attribute15 IN jtf_varchar2_table_300 := NULL,
2031: p_operation_code IN jtf_varchar2_table_100 := NULL,
2032: p_qte_line_index IN jtf_number_table := NULL,
2033: p_return_attr_category IN jtf_varchar2_table_100 := NULL,
2034: p_return_reason_code IN jtf_varchar2_table_100 := NULL,
2035: p_change_reason_code IN jtf_varchar2_table_100 := NULL,
2029: p_return_attribute14 IN jtf_varchar2_table_300 := NULL,
2030: p_return_attribute15 IN jtf_varchar2_table_300 := NULL,
2031: p_operation_code IN jtf_varchar2_table_100 := NULL,
2032: p_qte_line_index IN jtf_number_table := NULL,
2033: p_return_attr_category IN jtf_varchar2_table_100 := NULL,
2034: p_return_reason_code IN jtf_varchar2_table_100 := NULL,
2035: p_change_reason_code IN jtf_varchar2_table_100 := NULL,
2036: p_attribute16 IN jtf_varchar2_table_300 := NULL,
2037: p_attribute17 IN jtf_varchar2_table_300 := NULL,
2030: p_return_attribute15 IN jtf_varchar2_table_300 := NULL,
2031: p_operation_code IN jtf_varchar2_table_100 := NULL,
2032: p_qte_line_index IN jtf_number_table := NULL,
2033: p_return_attr_category IN jtf_varchar2_table_100 := NULL,
2034: p_return_reason_code IN jtf_varchar2_table_100 := NULL,
2035: p_change_reason_code IN jtf_varchar2_table_100 := NULL,
2036: p_attribute16 IN jtf_varchar2_table_300 := NULL,
2037: p_attribute17 IN jtf_varchar2_table_300 := NULL,
2038: p_attribute18 IN jtf_varchar2_table_300 := NULL,
2031: p_operation_code IN jtf_varchar2_table_100 := NULL,
2032: p_qte_line_index IN jtf_number_table := NULL,
2033: p_return_attr_category IN jtf_varchar2_table_100 := NULL,
2034: p_return_reason_code IN jtf_varchar2_table_100 := NULL,
2035: p_change_reason_code IN jtf_varchar2_table_100 := NULL,
2036: p_attribute16 IN jtf_varchar2_table_300 := NULL,
2037: p_attribute17 IN jtf_varchar2_table_300 := NULL,
2038: p_attribute18 IN jtf_varchar2_table_300 := NULL,
2039: p_attribute19 IN jtf_varchar2_table_300 := NULL,
2471: p_program_id IN jtf_number_table := NULL,
2472: p_program_update_date IN jtf_date_table := NULL,
2473: p_quote_line_id IN jtf_number_table := NULL,
2474: p_related_quote_line_id IN jtf_number_table := NULL,
2475: p_relationship_type_code IN jtf_varchar2_table_100 := NULL,
2476: p_reciprocal_flag IN jtf_varchar2_table_100 := NULL,
2477: p_qte_line_index IN jtf_number_table := NULL,
2478: p_related_qte_line_index IN jtf_number_table := NULL,
2479: p_operation_code IN jtf_varchar2_table_100 := NULL,
2472: p_program_update_date IN jtf_date_table := NULL,
2473: p_quote_line_id IN jtf_number_table := NULL,
2474: p_related_quote_line_id IN jtf_number_table := NULL,
2475: p_relationship_type_code IN jtf_varchar2_table_100 := NULL,
2476: p_reciprocal_flag IN jtf_varchar2_table_100 := NULL,
2477: p_qte_line_index IN jtf_number_table := NULL,
2478: p_related_qte_line_index IN jtf_number_table := NULL,
2479: p_operation_code IN jtf_varchar2_table_100 := NULL,
2480: p_object_version_number IN jtf_number_table := NULL
2475: p_relationship_type_code IN jtf_varchar2_table_100 := NULL,
2476: p_reciprocal_flag IN jtf_varchar2_table_100 := NULL,
2477: p_qte_line_index IN jtf_number_table := NULL,
2478: p_related_qte_line_index IN jtf_number_table := NULL,
2479: p_operation_code IN jtf_varchar2_table_100 := NULL,
2480: p_object_version_number IN jtf_number_table := NULL
2481: )
2482: RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type
2483: IS
2615:
2616:
2617: -- there IS total 43 fields here IN line
2618: FUNCTION Construct_Payment_Tbl(
2619: p_operation_code IN jtf_varchar2_table_100 := NULL,
2620: p_qte_line_index IN jtf_number_table := NULL,
2621: p_payment_id IN jtf_number_table := NULL,
2622: p_creation_date IN jtf_date_table := NULL,
2623: p_created_by IN jtf_number_table := NULL,
2629: p_program_id IN jtf_number_table := NULL,
2630: p_program_update_date IN jtf_date_table := NULL,
2631: p_quote_header_id IN jtf_number_table := NULL,
2632: p_quote_line_id IN jtf_number_table := NULL,
2633: p_payment_type_code IN jtf_varchar2_table_100 := NULL,
2634: p_payment_ref_number IN jtf_varchar2_table_300 := NULL,
2635: p_payment_option IN jtf_varchar2_table_300 := NULL,
2636: p_payment_term_id IN jtf_number_table := NULL,
2637: p_credit_card_code IN jtf_varchar2_table_100 := NULL,
2633: p_payment_type_code IN jtf_varchar2_table_100 := NULL,
2634: p_payment_ref_number IN jtf_varchar2_table_300 := NULL,
2635: p_payment_option IN jtf_varchar2_table_300 := NULL,
2636: p_payment_term_id IN jtf_number_table := NULL,
2637: p_credit_card_code IN jtf_varchar2_table_100 := NULL,
2638: p_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
2639: p_credit_card_exp_date IN jtf_date_table := NULL,
2640: p_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
2641: p_credit_card_approval_date IN jtf_date_table := NULL,
2634: p_payment_ref_number IN jtf_varchar2_table_300 := NULL,
2635: p_payment_option IN jtf_varchar2_table_300 := NULL,
2636: p_payment_term_id IN jtf_number_table := NULL,
2637: p_credit_card_code IN jtf_varchar2_table_100 := NULL,
2638: p_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
2639: p_credit_card_exp_date IN jtf_date_table := NULL,
2640: p_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
2641: p_credit_card_approval_date IN jtf_date_table := NULL,
2642: p_payment_amount IN jtf_number_table := NULL,
2636: p_payment_term_id IN jtf_number_table := NULL,
2637: p_credit_card_code IN jtf_varchar2_table_100 := NULL,
2638: p_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
2639: p_credit_card_exp_date IN jtf_date_table := NULL,
2640: p_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
2641: p_credit_card_approval_date IN jtf_date_table := NULL,
2642: p_payment_amount IN jtf_number_table := NULL,
2643: p_attribute_category IN jtf_varchar2_table_100 := NULL,
2644: p_attribute1 IN jtf_varchar2_table_300 := NULL,
2639: p_credit_card_exp_date IN jtf_date_table := NULL,
2640: p_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
2641: p_credit_card_approval_date IN jtf_date_table := NULL,
2642: p_payment_amount IN jtf_number_table := NULL,
2643: p_attribute_category IN jtf_varchar2_table_100 := NULL,
2644: p_attribute1 IN jtf_varchar2_table_300 := NULL,
2645: p_attribute2 IN jtf_varchar2_table_300 := NULL,
2646: p_attribute3 IN jtf_varchar2_table_300 := NULL,
2647: p_attribute4 IN jtf_varchar2_table_300 := NULL,
2657: p_attribute14 IN jtf_varchar2_table_300 := NULL,
2658: p_attribute15 IN jtf_varchar2_table_300 := NULL,
2659: p_shipment_index IN jtf_number_table := NULL,
2660: p_quote_shipment_id IN jtf_number_table := NULL,
2661: p_cust_po_number IN jtf_varchar2_table_100 := NULL,
2662: p_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
2663: p_attribute16 IN jtf_varchar2_table_300 := NULL,
2664: p_attribute17 IN jtf_varchar2_table_300 := NULL,
2665: p_attribute18 IN jtf_varchar2_table_300 := NULL,
2658: p_attribute15 IN jtf_varchar2_table_300 := NULL,
2659: p_shipment_index IN jtf_number_table := NULL,
2660: p_quote_shipment_id IN jtf_number_table := NULL,
2661: p_cust_po_number IN jtf_varchar2_table_100 := NULL,
2662: p_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
2663: p_attribute16 IN jtf_varchar2_table_300 := NULL,
2664: p_attribute17 IN jtf_varchar2_table_300 := NULL,
2665: p_attribute18 IN jtf_varchar2_table_300 := NULL,
2666: p_attribute19 IN jtf_varchar2_table_300 := NULL,
2667: p_attribute20 IN jtf_varchar2_table_300 := NULL,
2668: p_trxn_extension_id IN jtf_number_table := NULL,
2669: p_instrument_id IN jtf_number_table := NULL,
2670: p_instr_assignment_id IN jtf_number_table := NULL,
2671: p_cvv2 IN jtf_varchar2_table_100 := NULL,
2672: p_object_version_number IN jtf_number_table := NULL
2673:
2674: )
2675: RETURN ASO_Quote_Pub.Payment_Tbl_Type
3511:
3512:
3513: -- there IS total 67 fields here IN line
3514: FUNCTION Construct_Shipment_Tbl(
3515: p_operation_code IN jtf_varchar2_table_100 := NULL,
3516: p_qte_line_index IN jtf_number_table := NULL,
3517: p_shipment_id IN jtf_number_table := NULL,
3518: p_creation_date IN jtf_date_table := NULL,
3519: p_created_by IN jtf_number_table := NULL,
3533: p_ship_to_party_id IN jtf_number_table := NULL,
3534: p_ship_to_cust_account_id IN jtf_number_table := NULL,
3535: p_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
3536: p_ship_set_id IN jtf_number_table := NULL,
3537: p_ship_method_code IN jtf_varchar2_table_100 := NULL,
3538: p_freight_terms_code IN jtf_varchar2_table_100 := NULL,
3539: p_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
3540: p_fob_code IN jtf_varchar2_table_100 := NULL,
3541: p_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
3534: p_ship_to_cust_account_id IN jtf_number_table := NULL,
3535: p_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
3536: p_ship_set_id IN jtf_number_table := NULL,
3537: p_ship_method_code IN jtf_varchar2_table_100 := NULL,
3538: p_freight_terms_code IN jtf_varchar2_table_100 := NULL,
3539: p_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
3540: p_fob_code IN jtf_varchar2_table_100 := NULL,
3541: p_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
3542: p_packing_instructions IN jtf_varchar2_table_2000 := NULL,
3535: p_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
3536: p_ship_set_id IN jtf_number_table := NULL,
3537: p_ship_method_code IN jtf_varchar2_table_100 := NULL,
3538: p_freight_terms_code IN jtf_varchar2_table_100 := NULL,
3539: p_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
3540: p_fob_code IN jtf_varchar2_table_100 := NULL,
3541: p_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
3542: p_packing_instructions IN jtf_varchar2_table_2000 := NULL,
3543: p_quantity IN jtf_number_table := NULL,
3536: p_ship_set_id IN jtf_number_table := NULL,
3537: p_ship_method_code IN jtf_varchar2_table_100 := NULL,
3538: p_freight_terms_code IN jtf_varchar2_table_100 := NULL,
3539: p_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
3540: p_fob_code IN jtf_varchar2_table_100 := NULL,
3541: p_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
3542: p_packing_instructions IN jtf_varchar2_table_2000 := NULL,
3543: p_quantity IN jtf_number_table := NULL,
3544: p_reserved_quantity IN jtf_varchar2_table_300 := NULL,
3544: p_reserved_quantity IN jtf_varchar2_table_300 := NULL,
3545: p_reservation_id IN jtf_number_table := NULL,
3546: p_order_line_id IN jtf_number_table := NULL,
3547: p_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
3548: p_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
3549: p_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
3550: p_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
3551: p_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
3552: p_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
3545: p_reservation_id IN jtf_number_table := NULL,
3546: p_order_line_id IN jtf_number_table := NULL,
3547: p_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
3548: p_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
3549: p_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
3550: p_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
3551: p_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
3552: p_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
3553: p_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
3546: p_order_line_id IN jtf_number_table := NULL,
3547: p_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
3548: p_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
3549: p_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
3550: p_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
3551: p_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
3552: p_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
3553: p_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
3554: p_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
3551: p_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
3552: p_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
3553: p_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
3554: p_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
3555: p_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
3556: p_ship_to_country IN jtf_varchar2_table_100 := NULL,
3557: p_ship_to_city IN jtf_varchar2_table_100 := NULL,
3558: p_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
3559: p_ship_to_state IN jtf_varchar2_table_100 := NULL,
3552: p_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
3553: p_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
3554: p_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
3555: p_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
3556: p_ship_to_country IN jtf_varchar2_table_100 := NULL,
3557: p_ship_to_city IN jtf_varchar2_table_100 := NULL,
3558: p_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
3559: p_ship_to_state IN jtf_varchar2_table_100 := NULL,
3560: p_ship_to_province IN jtf_varchar2_table_100 := NULL,
3553: p_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
3554: p_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
3555: p_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
3556: p_ship_to_country IN jtf_varchar2_table_100 := NULL,
3557: p_ship_to_city IN jtf_varchar2_table_100 := NULL,
3558: p_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
3559: p_ship_to_state IN jtf_varchar2_table_100 := NULL,
3560: p_ship_to_province IN jtf_varchar2_table_100 := NULL,
3561: p_ship_to_county IN jtf_varchar2_table_100 := NULL,
3554: p_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
3555: p_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
3556: p_ship_to_country IN jtf_varchar2_table_100 := NULL,
3557: p_ship_to_city IN jtf_varchar2_table_100 := NULL,
3558: p_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
3559: p_ship_to_state IN jtf_varchar2_table_100 := NULL,
3560: p_ship_to_province IN jtf_varchar2_table_100 := NULL,
3561: p_ship_to_county IN jtf_varchar2_table_100 := NULL,
3562: p_attribute_category IN jtf_varchar2_table_100 := NULL,
3555: p_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
3556: p_ship_to_country IN jtf_varchar2_table_100 := NULL,
3557: p_ship_to_city IN jtf_varchar2_table_100 := NULL,
3558: p_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
3559: p_ship_to_state IN jtf_varchar2_table_100 := NULL,
3560: p_ship_to_province IN jtf_varchar2_table_100 := NULL,
3561: p_ship_to_county IN jtf_varchar2_table_100 := NULL,
3562: p_attribute_category IN jtf_varchar2_table_100 := NULL,
3563: p_attribute1 IN jtf_varchar2_table_300 := NULL,
3556: p_ship_to_country IN jtf_varchar2_table_100 := NULL,
3557: p_ship_to_city IN jtf_varchar2_table_100 := NULL,
3558: p_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
3559: p_ship_to_state IN jtf_varchar2_table_100 := NULL,
3560: p_ship_to_province IN jtf_varchar2_table_100 := NULL,
3561: p_ship_to_county IN jtf_varchar2_table_100 := NULL,
3562: p_attribute_category IN jtf_varchar2_table_100 := NULL,
3563: p_attribute1 IN jtf_varchar2_table_300 := NULL,
3564: p_attribute2 IN jtf_varchar2_table_300 := NULL,
3557: p_ship_to_city IN jtf_varchar2_table_100 := NULL,
3558: p_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
3559: p_ship_to_state IN jtf_varchar2_table_100 := NULL,
3560: p_ship_to_province IN jtf_varchar2_table_100 := NULL,
3561: p_ship_to_county IN jtf_varchar2_table_100 := NULL,
3562: p_attribute_category IN jtf_varchar2_table_100 := NULL,
3563: p_attribute1 IN jtf_varchar2_table_300 := NULL,
3564: p_attribute2 IN jtf_varchar2_table_300 := NULL,
3565: p_attribute3 IN jtf_varchar2_table_300 := NULL,
3558: p_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
3559: p_ship_to_state IN jtf_varchar2_table_100 := NULL,
3560: p_ship_to_province IN jtf_varchar2_table_100 := NULL,
3561: p_ship_to_county IN jtf_varchar2_table_100 := NULL,
3562: p_attribute_category IN jtf_varchar2_table_100 := NULL,
3563: p_attribute1 IN jtf_varchar2_table_300 := NULL,
3564: p_attribute2 IN jtf_varchar2_table_300 := NULL,
3565: p_attribute3 IN jtf_varchar2_table_300 := NULL,
3566: p_attribute4 IN jtf_varchar2_table_300 := NULL,
3576: p_attribute14 IN jtf_varchar2_table_300 := NULL,
3577: p_attribute15 IN jtf_varchar2_table_300 := NULL,
3578: p_ship_quote_price IN jtf_number_table := NULL,
3579: p_pricing_quantity IN jtf_number_table := NULL,
3580: p_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
3581: p_ship_from_org_id IN jtf_number_table := NULL,
3582: p_ship_to_cust_party_id IN jtf_number_table := NULL,
3583: p_attribute16 IN jtf_varchar2_table_300 := NULL,
3584: p_attribute17 IN jtf_varchar2_table_300 := NULL,
3584: p_attribute17 IN jtf_varchar2_table_300 := NULL,
3585: p_attribute18 IN jtf_varchar2_table_300 := NULL,
3586: p_attribute19 IN jtf_varchar2_table_300 := NULL,
3587: p_attribute20 IN jtf_varchar2_table_300 := NULL,
3588: p_request_date_type IN jtf_varchar2_table_100 := NULL,
3589: p_demand_class_code IN jtf_varchar2_table_100 := NULL,
3590: p_object_version_number IN jtf_number_table := NULL
3591:
3592: )
3585: p_attribute18 IN jtf_varchar2_table_300 := NULL,
3586: p_attribute19 IN jtf_varchar2_table_300 := NULL,
3587: p_attribute20 IN jtf_varchar2_table_300 := NULL,
3588: p_request_date_type IN jtf_varchar2_table_100 := NULL,
3589: p_demand_class_code IN jtf_varchar2_table_100 := NULL,
3590: p_object_version_number IN jtf_number_table := NULL
3591:
3592: )
3593: RETURN ASO_Quote_Pub.Shipment_Tbl_Type
3955:
3956:
3957: -- there IS total 40 fields here IN line
3958: FUNCTION Construct_Tax_Detail_Tbl(
3959: p_operation_code IN jtf_varchar2_table_100 := NULL,
3960: p_qte_line_index IN jtf_number_table := NULL,
3961: p_shipment_index IN jtf_number_table := NULL,
3962: p_tax_detail_id IN jtf_number_table := NULL,
3963: p_quote_header_id IN jtf_number_table := NULL,
3972: p_program_application_id IN jtf_number_table := NULL,
3973: p_program_id IN jtf_number_table := NULL,
3974: p_program_update_date IN jtf_date_table := NULL,
3975: p_orig_tax_code IN jtf_varchar2_table_300 := NULL,
3976: p_tax_code IN jtf_varchar2_table_100 := NULL,
3977: p_tax_rate IN jtf_number_table := NULL,
3978: p_tax_date IN jtf_date_table := NULL,
3979: p_tax_amount IN jtf_number_table := NULL,
3980: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
3976: p_tax_code IN jtf_varchar2_table_100 := NULL,
3977: p_tax_rate IN jtf_number_table := NULL,
3978: p_tax_date IN jtf_date_table := NULL,
3979: p_tax_amount IN jtf_number_table := NULL,
3980: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
3981: p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
3982: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
3983: p_attribute_category IN jtf_varchar2_table_100 := NULL,
3984: p_attribute1 IN jtf_varchar2_table_300 := NULL,
3977: p_tax_rate IN jtf_number_table := NULL,
3978: p_tax_date IN jtf_date_table := NULL,
3979: p_tax_amount IN jtf_number_table := NULL,
3980: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
3981: p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
3982: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
3983: p_attribute_category IN jtf_varchar2_table_100 := NULL,
3984: p_attribute1 IN jtf_varchar2_table_300 := NULL,
3985: p_attribute2 IN jtf_varchar2_table_300 := NULL,
3978: p_tax_date IN jtf_date_table := NULL,
3979: p_tax_amount IN jtf_number_table := NULL,
3980: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
3981: p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
3982: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
3983: p_attribute_category IN jtf_varchar2_table_100 := NULL,
3984: p_attribute1 IN jtf_varchar2_table_300 := NULL,
3985: p_attribute2 IN jtf_varchar2_table_300 := NULL,
3986: p_attribute3 IN jtf_varchar2_table_300 := NULL,
3979: p_tax_amount IN jtf_number_table := NULL,
3980: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
3981: p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
3982: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
3983: p_attribute_category IN jtf_varchar2_table_100 := NULL,
3984: p_attribute1 IN jtf_varchar2_table_300 := NULL,
3985: p_attribute2 IN jtf_varchar2_table_300 := NULL,
3986: p_attribute3 IN jtf_varchar2_table_300 := NULL,
3987: p_attribute4 IN jtf_varchar2_table_300 := NULL,
4487:
4488:
4489: -- there IS total 132 fields here IN line
4490: FUNCTION Construct_Price_Attributes_Tbl(
4491: p_operation_code IN jtf_varchar2_table_100 := NULL,
4492: p_qte_line_index IN jtf_number_table := NULL,
4493: p_price_attribute_id IN jtf_number_table := NULL,
4494: p_creation_date IN jtf_date_table := NULL,
4495: p_created_by IN jtf_number_table := NULL,
4501: p_program_id IN jtf_number_table := NULL,
4502: p_program_update_date IN jtf_date_table := NULL,
4503: p_quote_header_id IN jtf_number_table := NULL,
4504: p_quote_line_id IN jtf_number_table := NULL,
4505: p_flex_title IN jtf_varchar2_table_100 := NULL,
4506: p_pricing_context IN jtf_varchar2_table_100 := NULL,
4507: p_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
4508: p_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
4509: p_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,
4502: p_program_update_date IN jtf_date_table := NULL,
4503: p_quote_header_id IN jtf_number_table := NULL,
4504: p_quote_line_id IN jtf_number_table := NULL,
4505: p_flex_title IN jtf_varchar2_table_100 := NULL,
4506: p_pricing_context IN jtf_varchar2_table_100 := NULL,
4507: p_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
4508: p_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
4509: p_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,
4510: p_pricing_attribute4 IN jtf_varchar2_table_300 := NULL,
4603: p_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
4604: p_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
4605: p_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
4606: p_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
4607: p_context IN jtf_varchar2_table_100 := NULL,
4608: p_attribute1 IN jtf_varchar2_table_300 := NULL,
4609: p_attribute2 IN jtf_varchar2_table_300 := NULL,
4610: p_attribute3 IN jtf_varchar2_table_300 := NULL,
4611: p_attribute4 IN jtf_varchar2_table_300 := NULL,
5120:
5121:
5122: -- there IS total 85 fields here IN line
5123: FUNCTION Construct_Price_Adj_Tbl(
5124: p_operation_code IN jtf_varchar2_table_100 := NULL,
5125: p_qte_line_index IN jtf_number_table := NULL,
5126: p_price_adjustment_id IN jtf_number_table := NULL,
5127: p_creation_date IN jtf_date_table := NULL,
5128: p_created_by IN jtf_number_table := NULL,
5136: p_quote_header_id IN jtf_number_table := NULL,
5137: p_quote_line_id IN jtf_number_table := NULL,
5138: p_modifier_header_id IN jtf_number_table := NULL,
5139: p_modifier_line_id IN jtf_number_table := NULL,
5140: p_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
5141: p_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
5142: p_modified_from IN jtf_number_table := NULL,
5143: p_modified_to IN jtf_number_table := NULL,
5144: p_operand IN jtf_number_table := NULL,
5137: p_quote_line_id IN jtf_number_table := NULL,
5138: p_modifier_header_id IN jtf_number_table := NULL,
5139: p_modifier_line_id IN jtf_number_table := NULL,
5140: p_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
5141: p_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
5142: p_modified_from IN jtf_number_table := NULL,
5143: p_modified_to IN jtf_number_table := NULL,
5144: p_operand IN jtf_number_table := NULL,
5145: p_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
5141: p_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
5142: p_modified_from IN jtf_number_table := NULL,
5143: p_modified_to IN jtf_number_table := NULL,
5144: p_operand IN jtf_number_table := NULL,
5145: p_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
5146: p_automatic_flag IN jtf_varchar2_table_100 := NULL,
5147: p_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
5148: p_updated_flag IN jtf_varchar2_table_100 := NULL,
5149: p_applied_flag IN jtf_varchar2_table_100 := NULL,
5142: p_modified_from IN jtf_number_table := NULL,
5143: p_modified_to IN jtf_number_table := NULL,
5144: p_operand IN jtf_number_table := NULL,
5145: p_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
5146: p_automatic_flag IN jtf_varchar2_table_100 := NULL,
5147: p_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
5148: p_updated_flag IN jtf_varchar2_table_100 := NULL,
5149: p_applied_flag IN jtf_varchar2_table_100 := NULL,
5150: p_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5143: p_modified_to IN jtf_number_table := NULL,
5144: p_operand IN jtf_number_table := NULL,
5145: p_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
5146: p_automatic_flag IN jtf_varchar2_table_100 := NULL,
5147: p_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
5148: p_updated_flag IN jtf_varchar2_table_100 := NULL,
5149: p_applied_flag IN jtf_varchar2_table_100 := NULL,
5150: p_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5151: p_pricing_phase_id IN jtf_number_table := NULL,
5144: p_operand IN jtf_number_table := NULL,
5145: p_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
5146: p_automatic_flag IN jtf_varchar2_table_100 := NULL,
5147: p_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
5148: p_updated_flag IN jtf_varchar2_table_100 := NULL,
5149: p_applied_flag IN jtf_varchar2_table_100 := NULL,
5150: p_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5151: p_pricing_phase_id IN jtf_number_table := NULL,
5152: p_attribute_category IN jtf_varchar2_table_100 := NULL,
5145: p_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
5146: p_automatic_flag IN jtf_varchar2_table_100 := NULL,
5147: p_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
5148: p_updated_flag IN jtf_varchar2_table_100 := NULL,
5149: p_applied_flag IN jtf_varchar2_table_100 := NULL,
5150: p_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5151: p_pricing_phase_id IN jtf_number_table := NULL,
5152: p_attribute_category IN jtf_varchar2_table_100 := NULL,
5153: p_attribute1 IN jtf_varchar2_table_300 := NULL,
5146: p_automatic_flag IN jtf_varchar2_table_100 := NULL,
5147: p_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
5148: p_updated_flag IN jtf_varchar2_table_100 := NULL,
5149: p_applied_flag IN jtf_varchar2_table_100 := NULL,
5150: p_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5151: p_pricing_phase_id IN jtf_number_table := NULL,
5152: p_attribute_category IN jtf_varchar2_table_100 := NULL,
5153: p_attribute1 IN jtf_varchar2_table_300 := NULL,
5154: p_attribute2 IN jtf_varchar2_table_300 := NULL,
5148: p_updated_flag IN jtf_varchar2_table_100 := NULL,
5149: p_applied_flag IN jtf_varchar2_table_100 := NULL,
5150: p_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5151: p_pricing_phase_id IN jtf_number_table := NULL,
5152: p_attribute_category IN jtf_varchar2_table_100 := NULL,
5153: p_attribute1 IN jtf_varchar2_table_300 := NULL,
5154: p_attribute2 IN jtf_varchar2_table_300 := NULL,
5155: p_attribute3 IN jtf_varchar2_table_300 := NULL,
5156: p_attribute4 IN jtf_varchar2_table_300 := NULL,
5164: p_attribute12 IN jtf_varchar2_table_300 := NULL,
5165: p_attribute13 IN jtf_varchar2_table_300 := NULL,
5166: p_attribute14 IN jtf_varchar2_table_300 := NULL,
5167: p_attribute15 IN jtf_varchar2_table_300 := NULL,
5168: p_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
5169: p_change_sequence IN jtf_varchar2_table_100 := NULL,
5170: p_update_allowed IN jtf_varchar2_table_100 := NULL,
5171: p_change_reason_code IN jtf_varchar2_table_100 := NULL,
5172: p_change_reason_text IN jtf_varchar2_table_2000 := NULL,
5165: p_attribute13 IN jtf_varchar2_table_300 := NULL,
5166: p_attribute14 IN jtf_varchar2_table_300 := NULL,
5167: p_attribute15 IN jtf_varchar2_table_300 := NULL,
5168: p_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
5169: p_change_sequence IN jtf_varchar2_table_100 := NULL,
5170: p_update_allowed IN jtf_varchar2_table_100 := NULL,
5171: p_change_reason_code IN jtf_varchar2_table_100 := NULL,
5172: p_change_reason_text IN jtf_varchar2_table_2000 := NULL,
5173: p_cost_id IN jtf_number_table := NULL,
5166: p_attribute14 IN jtf_varchar2_table_300 := NULL,
5167: p_attribute15 IN jtf_varchar2_table_300 := NULL,
5168: p_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
5169: p_change_sequence IN jtf_varchar2_table_100 := NULL,
5170: p_update_allowed IN jtf_varchar2_table_100 := NULL,
5171: p_change_reason_code IN jtf_varchar2_table_100 := NULL,
5172: p_change_reason_text IN jtf_varchar2_table_2000 := NULL,
5173: p_cost_id IN jtf_number_table := NULL,
5174: p_tax_code IN jtf_varchar2_table_100 := NULL,
5167: p_attribute15 IN jtf_varchar2_table_300 := NULL,
5168: p_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
5169: p_change_sequence IN jtf_varchar2_table_100 := NULL,
5170: p_update_allowed IN jtf_varchar2_table_100 := NULL,
5171: p_change_reason_code IN jtf_varchar2_table_100 := NULL,
5172: p_change_reason_text IN jtf_varchar2_table_2000 := NULL,
5173: p_cost_id IN jtf_number_table := NULL,
5174: p_tax_code IN jtf_varchar2_table_100 := NULL,
5175: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
5170: p_update_allowed IN jtf_varchar2_table_100 := NULL,
5171: p_change_reason_code IN jtf_varchar2_table_100 := NULL,
5172: p_change_reason_text IN jtf_varchar2_table_2000 := NULL,
5173: p_cost_id IN jtf_number_table := NULL,
5174: p_tax_code IN jtf_varchar2_table_100 := NULL,
5175: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
5176: p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
5177: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
5178: p_parent_adjustment_id IN jtf_number_table := NULL,
5171: p_change_reason_code IN jtf_varchar2_table_100 := NULL,
5172: p_change_reason_text IN jtf_varchar2_table_2000 := NULL,
5173: p_cost_id IN jtf_number_table := NULL,
5174: p_tax_code IN jtf_varchar2_table_100 := NULL,
5175: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
5176: p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
5177: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
5178: p_parent_adjustment_id IN jtf_number_table := NULL,
5179: p_invoiced_flag IN jtf_varchar2_table_100 := NULL,
5172: p_change_reason_text IN jtf_varchar2_table_2000 := NULL,
5173: p_cost_id IN jtf_number_table := NULL,
5174: p_tax_code IN jtf_varchar2_table_100 := NULL,
5175: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
5176: p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
5177: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
5178: p_parent_adjustment_id IN jtf_number_table := NULL,
5179: p_invoiced_flag IN jtf_varchar2_table_100 := NULL,
5180: p_estimated_flag IN jtf_varchar2_table_100 := NULL,
5173: p_cost_id IN jtf_number_table := NULL,
5174: p_tax_code IN jtf_varchar2_table_100 := NULL,
5175: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
5176: p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
5177: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
5178: p_parent_adjustment_id IN jtf_number_table := NULL,
5179: p_invoiced_flag IN jtf_varchar2_table_100 := NULL,
5180: p_estimated_flag IN jtf_varchar2_table_100 := NULL,
5181: p_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
5175: p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
5176: p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
5177: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
5178: p_parent_adjustment_id IN jtf_number_table := NULL,
5179: p_invoiced_flag IN jtf_varchar2_table_100 := NULL,
5180: p_estimated_flag IN jtf_varchar2_table_100 := NULL,
5181: p_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
5182: p_split_action_code IN jtf_varchar2_table_100 := NULL,
5183: p_adjusted_amount IN jtf_number_table := NULL,
5176: p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
5177: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
5178: p_parent_adjustment_id IN jtf_number_table := NULL,
5179: p_invoiced_flag IN jtf_varchar2_table_100 := NULL,
5180: p_estimated_flag IN jtf_varchar2_table_100 := NULL,
5181: p_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
5182: p_split_action_code IN jtf_varchar2_table_100 := NULL,
5183: p_adjusted_amount IN jtf_number_table := NULL,
5184: p_charge_type_code IN jtf_varchar2_table_100 := NULL,
5177: p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
5178: p_parent_adjustment_id IN jtf_number_table := NULL,
5179: p_invoiced_flag IN jtf_varchar2_table_100 := NULL,
5180: p_estimated_flag IN jtf_varchar2_table_100 := NULL,
5181: p_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
5182: p_split_action_code IN jtf_varchar2_table_100 := NULL,
5183: p_adjusted_amount IN jtf_number_table := NULL,
5184: p_charge_type_code IN jtf_varchar2_table_100 := NULL,
5185: p_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
5178: p_parent_adjustment_id IN jtf_number_table := NULL,
5179: p_invoiced_flag IN jtf_varchar2_table_100 := NULL,
5180: p_estimated_flag IN jtf_varchar2_table_100 := NULL,
5181: p_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
5182: p_split_action_code IN jtf_varchar2_table_100 := NULL,
5183: p_adjusted_amount IN jtf_number_table := NULL,
5184: p_charge_type_code IN jtf_varchar2_table_100 := NULL,
5185: p_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
5186: p_range_break_quantity IN jtf_number_table := NULL,
5180: p_estimated_flag IN jtf_varchar2_table_100 := NULL,
5181: p_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
5182: p_split_action_code IN jtf_varchar2_table_100 := NULL,
5183: p_adjusted_amount IN jtf_number_table := NULL,
5184: p_charge_type_code IN jtf_varchar2_table_100 := NULL,
5185: p_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
5186: p_range_break_quantity IN jtf_number_table := NULL,
5187: p_accrual_conv_rate IN jtf_number_table := NULL,
5188: p_pricing_group_sequence IN jtf_number_table := NULL,
5181: p_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
5182: p_split_action_code IN jtf_varchar2_table_100 := NULL,
5183: p_adjusted_amount IN jtf_number_table := NULL,
5184: p_charge_type_code IN jtf_varchar2_table_100 := NULL,
5185: p_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
5186: p_range_break_quantity IN jtf_number_table := NULL,
5187: p_accrual_conv_rate IN jtf_number_table := NULL,
5188: p_pricing_group_sequence IN jtf_number_table := NULL,
5189: p_accrual_flag IN jtf_varchar2_table_100 := NULL,
5185: p_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
5186: p_range_break_quantity IN jtf_number_table := NULL,
5187: p_accrual_conv_rate IN jtf_number_table := NULL,
5188: p_pricing_group_sequence IN jtf_number_table := NULL,
5189: p_accrual_flag IN jtf_varchar2_table_100 := NULL,
5190: p_list_line_no IN jtf_varchar2_table_300 := NULL,
5191: p_source_system_code IN jtf_varchar2_table_100 := NULL,
5192: p_benefit_qty IN jtf_number_table := NULL,
5193: p_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
5187: p_accrual_conv_rate IN jtf_number_table := NULL,
5188: p_pricing_group_sequence IN jtf_number_table := NULL,
5189: p_accrual_flag IN jtf_varchar2_table_100 := NULL,
5190: p_list_line_no IN jtf_varchar2_table_300 := NULL,
5191: p_source_system_code IN jtf_varchar2_table_100 := NULL,
5192: p_benefit_qty IN jtf_number_table := NULL,
5193: p_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
5194: p_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5195: p_expiration_date IN jtf_date_table := NULL,
5189: p_accrual_flag IN jtf_varchar2_table_100 := NULL,
5190: p_list_line_no IN jtf_varchar2_table_300 := NULL,
5191: p_source_system_code IN jtf_varchar2_table_100 := NULL,
5192: p_benefit_qty IN jtf_number_table := NULL,
5193: p_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
5194: p_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5195: p_expiration_date IN jtf_date_table := NULL,
5196: p_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
5197: p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
5190: p_list_line_no IN jtf_varchar2_table_300 := NULL,
5191: p_source_system_code IN jtf_varchar2_table_100 := NULL,
5192: p_benefit_qty IN jtf_number_table := NULL,
5193: p_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
5194: p_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5195: p_expiration_date IN jtf_date_table := NULL,
5196: p_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
5197: p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
5198: p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
5192: p_benefit_qty IN jtf_number_table := NULL,
5193: p_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
5194: p_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5195: p_expiration_date IN jtf_date_table := NULL,
5196: p_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
5197: p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
5198: p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
5199: p_redeemed_date IN jtf_date_table := NULL,
5200: p_redeemed_flag IN jtf_varchar2_table_100 := NULL,
5193: p_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
5194: p_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5195: p_expiration_date IN jtf_date_table := NULL,
5196: p_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
5197: p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
5198: p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
5199: p_redeemed_date IN jtf_date_table := NULL,
5200: p_redeemed_flag IN jtf_varchar2_table_100 := NULL,
5201: p_modifier_level_code IN jtf_varchar2_table_100 := NULL,
5194: p_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
5195: p_expiration_date IN jtf_date_table := NULL,
5196: p_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
5197: p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
5198: p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
5199: p_redeemed_date IN jtf_date_table := NULL,
5200: p_redeemed_flag IN jtf_varchar2_table_100 := NULL,
5201: p_modifier_level_code IN jtf_varchar2_table_100 := NULL,
5202: p_price_break_type_code IN jtf_varchar2_table_100 := NULL,
5196: p_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
5197: p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
5198: p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
5199: p_redeemed_date IN jtf_date_table := NULL,
5200: p_redeemed_flag IN jtf_varchar2_table_100 := NULL,
5201: p_modifier_level_code IN jtf_varchar2_table_100 := NULL,
5202: p_price_break_type_code IN jtf_varchar2_table_100 := NULL,
5203: p_substitution_attribute IN jtf_varchar2_table_100 := NULL,
5204: p_proration_type_code IN jtf_varchar2_table_100 := NULL,
5197: p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
5198: p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
5199: p_redeemed_date IN jtf_date_table := NULL,
5200: p_redeemed_flag IN jtf_varchar2_table_100 := NULL,
5201: p_modifier_level_code IN jtf_varchar2_table_100 := NULL,
5202: p_price_break_type_code IN jtf_varchar2_table_100 := NULL,
5203: p_substitution_attribute IN jtf_varchar2_table_100 := NULL,
5204: p_proration_type_code IN jtf_varchar2_table_100 := NULL,
5205: p_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
5198: p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
5199: p_redeemed_date IN jtf_date_table := NULL,
5200: p_redeemed_flag IN jtf_varchar2_table_100 := NULL,
5201: p_modifier_level_code IN jtf_varchar2_table_100 := NULL,
5202: p_price_break_type_code IN jtf_varchar2_table_100 := NULL,
5203: p_substitution_attribute IN jtf_varchar2_table_100 := NULL,
5204: p_proration_type_code IN jtf_varchar2_table_100 := NULL,
5205: p_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
5206: p_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
5199: p_redeemed_date IN jtf_date_table := NULL,
5200: p_redeemed_flag IN jtf_varchar2_table_100 := NULL,
5201: p_modifier_level_code IN jtf_varchar2_table_100 := NULL,
5202: p_price_break_type_code IN jtf_varchar2_table_100 := NULL,
5203: p_substitution_attribute IN jtf_varchar2_table_100 := NULL,
5204: p_proration_type_code IN jtf_varchar2_table_100 := NULL,
5205: p_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
5206: p_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
5207: p_shipment_index IN jtf_number_table := NULL,
5200: p_redeemed_flag IN jtf_varchar2_table_100 := NULL,
5201: p_modifier_level_code IN jtf_varchar2_table_100 := NULL,
5202: p_price_break_type_code IN jtf_varchar2_table_100 := NULL,
5203: p_substitution_attribute IN jtf_varchar2_table_100 := NULL,
5204: p_proration_type_code IN jtf_varchar2_table_100 := NULL,
5205: p_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
5206: p_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
5207: p_shipment_index IN jtf_number_table := NULL,
5208: p_quote_shipment_id IN jtf_number_table := NULL,
5201: p_modifier_level_code IN jtf_varchar2_table_100 := NULL,
5202: p_price_break_type_code IN jtf_varchar2_table_100 := NULL,
5203: p_substitution_attribute IN jtf_varchar2_table_100 := NULL,
5204: p_proration_type_code IN jtf_varchar2_table_100 := NULL,
5205: p_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
5206: p_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
5207: p_shipment_index IN jtf_number_table := NULL,
5208: p_quote_shipment_id IN jtf_number_table := NULL,
5209: p_attribute16 IN jtf_varchar2_table_300 := NULL,
5202: p_price_break_type_code IN jtf_varchar2_table_100 := NULL,
5203: p_substitution_attribute IN jtf_varchar2_table_100 := NULL,
5204: p_proration_type_code IN jtf_varchar2_table_100 := NULL,
5205: p_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
5206: p_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
5207: p_shipment_index IN jtf_number_table := NULL,
5208: p_quote_shipment_id IN jtf_number_table := NULL,
5209: p_attribute16 IN jtf_varchar2_table_300 := NULL,
5210: p_attribute17 IN jtf_varchar2_table_300 := NULL,
5634:
5635:
5636: -- there IS total 38 fields here IN line
5637: FUNCTION Construct_Sales_Credit_Tbl(
5638: p_operation_code IN jtf_varchar2_table_100 := NULL,
5639: p_qte_line_index IN jtf_number_table := NULL,
5640: p_sales_credit_id IN jtf_number_table := NULL,
5641: p_creation_date IN jtf_date_table := NULL,
5642: p_created_by IN jtf_number_table := NULL,
5656: p_sales_credit_type IN jtf_varchar2_table_300 := NULL,
5657: p_resource_group_id IN jtf_number_table := NULL,
5658: p_employee_person_id IN jtf_number_table := NULL,
5659: p_sales_credit_type_id IN jtf_number_table := NULL,
5660: p_attribute_category IN jtf_varchar2_table_100 := NULL,
5661: p_attribute1 IN jtf_varchar2_table_300 := NULL,
5662: p_attribute2 IN jtf_varchar2_table_300 := NULL,
5663: p_attribute3 IN jtf_varchar2_table_300 := NULL,
5664: p_attribute4 IN jtf_varchar2_table_300 := NULL,
5672: p_attribute12 IN jtf_varchar2_table_300 := NULL,
5673: p_attribute13 IN jtf_varchar2_table_300 := NULL,
5674: p_attribute14 IN jtf_varchar2_table_300 := NULL,
5675: p_attribute15 IN jtf_varchar2_table_300 := NULL,
5676: p_system_assigned_flag IN jtf_varchar2_table_100 := NULL,
5677: p_credit_rule_id IN jtf_number_table := NULL,
5678: p_attribute16 IN jtf_varchar2_table_300 := NULL,
5679: p_attribute17 IN jtf_varchar2_table_300 := NULL,
5680: p_attribute18 IN jtf_varchar2_table_300 := NULL,
6064: p_request_id IN jtf_number_table := NULL,
6065: p_program_application_id IN jtf_number_table := NULL,
6066: p_program_id IN jtf_number_table := NULL,
6067: p_program_update_date IN jtf_date_table := NULL,
6068: p_keep_flag IN jtf_varchar2_table_100 := NULL,
6069: p_update_access_flag IN jtf_varchar2_table_100 := NULL,
6070: p_created_by_tap_flag IN jtf_varchar2_table_100 := NULL,
6071: p_role_id IN jtf_number_table := NULL,
6072: p_territory_id IN jtf_number_table := NULL,
6065: p_program_application_id IN jtf_number_table := NULL,
6066: p_program_id IN jtf_number_table := NULL,
6067: p_program_update_date IN jtf_date_table := NULL,
6068: p_keep_flag IN jtf_varchar2_table_100 := NULL,
6069: p_update_access_flag IN jtf_varchar2_table_100 := NULL,
6070: p_created_by_tap_flag IN jtf_varchar2_table_100 := NULL,
6071: p_role_id IN jtf_number_table := NULL,
6072: p_territory_id IN jtf_number_table := NULL,
6073: p_territory_source_flag IN jtf_varchar2_table_100 := NULL,
6066: p_program_id IN jtf_number_table := NULL,
6067: p_program_update_date IN jtf_date_table := NULL,
6068: p_keep_flag IN jtf_varchar2_table_100 := NULL,
6069: p_update_access_flag IN jtf_varchar2_table_100 := NULL,
6070: p_created_by_tap_flag IN jtf_varchar2_table_100 := NULL,
6071: p_role_id IN jtf_number_table := NULL,
6072: p_territory_id IN jtf_number_table := NULL,
6073: p_territory_source_flag IN jtf_varchar2_table_100 := NULL,
6074: p_attribute_category IN jtf_varchar2_table_100 := NULL,
6069: p_update_access_flag IN jtf_varchar2_table_100 := NULL,
6070: p_created_by_tap_flag IN jtf_varchar2_table_100 := NULL,
6071: p_role_id IN jtf_number_table := NULL,
6072: p_territory_id IN jtf_number_table := NULL,
6073: p_territory_source_flag IN jtf_varchar2_table_100 := NULL,
6074: p_attribute_category IN jtf_varchar2_table_100 := NULL,
6075: p_attribute1 IN jtf_varchar2_table_300 := NULL,
6076: p_attribute2 IN jtf_varchar2_table_300 := NULL,
6077: p_attribute3 IN jtf_varchar2_table_300 := NULL,
6070: p_created_by_tap_flag IN jtf_varchar2_table_100 := NULL,
6071: p_role_id IN jtf_number_table := NULL,
6072: p_territory_id IN jtf_number_table := NULL,
6073: p_territory_source_flag IN jtf_varchar2_table_100 := NULL,
6074: p_attribute_category IN jtf_varchar2_table_100 := NULL,
6075: p_attribute1 IN jtf_varchar2_table_300 := NULL,
6076: p_attribute2 IN jtf_varchar2_table_300 := NULL,
6077: p_attribute3 IN jtf_varchar2_table_300 := NULL,
6078: p_attribute4 IN jtf_varchar2_table_300 := NULL,
6092: p_attribute18 IN jtf_varchar2_table_300 := NULL,
6093: p_attribute19 IN jtf_varchar2_table_300 := NULL,
6094: p_attribute20 IN jtf_varchar2_table_300 := NULL,
6095: p_object_version_number IN jtf_number_table := NULL,
6096: p_batch_price_flag IN jtf_varchar2_table_100 := NULL,
6097: p_operation_code IN jtf_varchar2_table_100 := NULL
6098: )
6099: RETURN ASO_QUOTE_PUB.Qte_Access_Tbl_Type
6100: IS
6093: p_attribute19 IN jtf_varchar2_table_300 := NULL,
6094: p_attribute20 IN jtf_varchar2_table_300 := NULL,
6095: p_object_version_number IN jtf_number_table := NULL,
6096: p_batch_price_flag IN jtf_varchar2_table_100 := NULL,
6097: p_operation_code IN jtf_varchar2_table_100 := NULL
6098: )
6099: RETURN ASO_QUOTE_PUB.Qte_Access_Tbl_Type
6100: IS
6101: l_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type;
6601: x_program_application_id OUT NOCOPY jtf_number_table,
6602: x_program_id OUT NOCOPY jtf_number_table,
6603: x_program_update_date OUT NOCOPY jtf_date_table,
6604: x_org_id OUT NOCOPY jtf_number_table,
6605: x_quote_name OUT NOCOPY jtf_varchar2_table_100,
6606: x_quote_number OUT NOCOPY jtf_number_table,
6607: x_quote_version OUT NOCOPY jtf_number_table,
6608: x_quote_status_id OUT NOCOPY jtf_number_table,
6609: x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
6626: x_accounting_rule_id OUT NOCOPY jtf_number_table,
6627: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
6628: x_employee_person_id OUT NOCOPY jtf_number_table,
6629: x_price_list_id OUT NOCOPY jtf_number_table,
6630: x_currency_code OUT NOCOPY jtf_varchar2_table_100,
6631: x_total_list_price OUT NOCOPY jtf_number_table,
6632: x_total_adjusted_amount OUT NOCOPY jtf_number_table,
6633: x_total_adjusted_percent OUT NOCOPY jtf_number_table,
6634: x_total_tax OUT NOCOPY jtf_number_table,
6636: x_surcharge OUT NOCOPY jtf_number_table,
6637: x_total_quote_price OUT NOCOPY jtf_number_table,
6638: x_payment_amount OUT NOCOPY jtf_number_table,
6639: x_exchange_rate OUT NOCOPY jtf_number_table,
6640: x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
6641: x_exchange_rate_date OUT NOCOPY jtf_date_table,
6642: x_contract_id OUT NOCOPY jtf_number_table,
6643: x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
6644: x_order_id OUT NOCOPY jtf_number_table,
6639: x_exchange_rate OUT NOCOPY jtf_number_table,
6640: x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
6641: x_exchange_rate_date OUT NOCOPY jtf_date_table,
6642: x_contract_id OUT NOCOPY jtf_number_table,
6643: x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
6644: x_order_id OUT NOCOPY jtf_number_table,
6645: x_order_number OUT NOCOPY jtf_number_table,
6646: x_ffm_request_id OUT NOCOPY jtf_number_table,
6647: x_qte_contract_id OUT NOCOPY jtf_number_table,
6644: x_order_id OUT NOCOPY jtf_number_table,
6645: x_order_number OUT NOCOPY jtf_number_table,
6646: x_ffm_request_id OUT NOCOPY jtf_number_table,
6647: x_qte_contract_id OUT NOCOPY jtf_number_table,
6648: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
6649: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
6650: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
6651: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
6652: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
6663: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
6664: x_salesrep_first_name OUT NOCOPY jtf_varchar2_table_300,
6665: x_salesrep_last_name OUT NOCOPY jtf_varchar2_table_300,
6666: x_price_list_name OUT NOCOPY jtf_varchar2_table_300,
6667: x_quote_status_code OUT NOCOPY jtf_varchar2_table_100,
6668: x_quote_status OUT NOCOPY jtf_varchar2_table_300,
6669: x_party_name OUT NOCOPY jtf_varchar2_table_300,
6670: x_party_type OUT NOCOPY jtf_varchar2_table_100,
6671: x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
6666: x_price_list_name OUT NOCOPY jtf_varchar2_table_300,
6667: x_quote_status_code OUT NOCOPY jtf_varchar2_table_100,
6668: x_quote_status OUT NOCOPY jtf_varchar2_table_300,
6669: x_party_name OUT NOCOPY jtf_varchar2_table_300,
6670: x_party_type OUT NOCOPY jtf_varchar2_table_100,
6671: x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
6672: x_person_middle_name OUT NOCOPY jtf_varchar2_table_100,
6673: x_person_last_name OUT NOCOPY jtf_varchar2_table_200,
6674: x_marketing_source_name OUT NOCOPY jtf_varchar2_table_200,
6668: x_quote_status OUT NOCOPY jtf_varchar2_table_300,
6669: x_party_name OUT NOCOPY jtf_varchar2_table_300,
6670: x_party_type OUT NOCOPY jtf_varchar2_table_100,
6671: x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
6672: x_person_middle_name OUT NOCOPY jtf_varchar2_table_100,
6673: x_person_last_name OUT NOCOPY jtf_varchar2_table_200,
6674: x_marketing_source_name OUT NOCOPY jtf_varchar2_table_200,
6675: x_marketing_source_code OUT NOCOPY jtf_varchar2_table_200,
6676: x_order_type_name OUT NOCOPY jtf_varchar2_table_300,
6675: x_marketing_source_code OUT NOCOPY jtf_varchar2_table_200,
6676: x_order_type_name OUT NOCOPY jtf_varchar2_table_300,
6677: x_invoice_to_party_name OUT NOCOPY jtf_varchar2_table_300,
6678: x_invoice_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
6679: x_invoice_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
6680: x_invoice_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
6681: x_invoice_to_address1 OUT NOCOPY jtf_varchar2_table_300,
6682: x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
6683: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
6681: x_invoice_to_address1 OUT NOCOPY jtf_varchar2_table_300,
6682: x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
6683: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
6684: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
6685: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
6686: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
6687: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6688: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6689: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6682: x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
6683: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
6684: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
6685: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
6686: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
6687: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6688: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6689: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6690: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
6683: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
6684: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
6685: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
6686: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
6687: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6688: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6689: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6690: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
6691: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
6684: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
6685: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
6686: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
6687: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6688: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6689: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6690: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
6691: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
6692: x_resource_id OUT NOCOPY jtf_number_table
6685: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
6686: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
6687: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6688: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6689: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6690: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
6691: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
6692: x_resource_id OUT NOCOPY jtf_number_table
6693: --*/
6686: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
6687: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6688: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6689: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6690: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
6691: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
6692: x_resource_id OUT NOCOPY jtf_number_table
6693: --*/
6694: )
6687: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6688: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6689: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6690: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
6691: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
6692: x_resource_id OUT NOCOPY jtf_number_table
6693: --*/
6694: )
6695: AS
6707: x_program_application_id := jtf_number_table();
6708: x_program_id := jtf_number_table();
6709: x_program_update_date := jtf_date_table();
6710: x_org_id := jtf_number_table();
6711: x_quote_name := jtf_varchar2_table_100();
6712: x_quote_number := jtf_number_table();
6713: x_quote_version := jtf_number_table();
6714: x_quote_status_id := jtf_number_table();
6715: x_quote_source_code := jtf_varchar2_table_300();
6732: x_accounting_rule_id := jtf_number_table();
6733: x_invoicing_rule_id := jtf_number_table();
6734: x_employee_person_id := jtf_number_table();
6735: x_price_list_id := jtf_number_table();
6736: x_currency_code := jtf_varchar2_table_100();
6737: x_total_list_price := jtf_number_table();
6738: x_total_adjusted_amount := jtf_number_table();
6739: x_total_adjusted_percent := jtf_number_table();
6740: x_total_tax := jtf_number_table();
6742: x_surcharge := jtf_number_table();
6743: x_total_quote_price := jtf_number_table();
6744: x_payment_amount := jtf_number_table();
6745: x_exchange_rate := jtf_number_table();
6746: x_exchange_type_code := jtf_varchar2_table_100();
6747: x_exchange_rate_date := jtf_date_table();
6748: x_contract_id := jtf_number_table();
6749: x_sales_channel_code := jtf_varchar2_table_100();
6750: x_order_id := jtf_number_table();
6745: x_exchange_rate := jtf_number_table();
6746: x_exchange_type_code := jtf_varchar2_table_100();
6747: x_exchange_rate_date := jtf_date_table();
6748: x_contract_id := jtf_number_table();
6749: x_sales_channel_code := jtf_varchar2_table_100();
6750: x_order_id := jtf_number_table();
6751: x_order_number := jtf_number_table();
6752: x_ffm_request_id := jtf_number_table();
6753: x_qte_contract_id := jtf_number_table();
6750: x_order_id := jtf_number_table();
6751: x_order_number := jtf_number_table();
6752: x_ffm_request_id := jtf_number_table();
6753: x_qte_contract_id := jtf_number_table();
6754: x_attribute_category := jtf_varchar2_table_100();
6755: x_attribute1 := jtf_varchar2_table_200();
6756: x_attribute2 := jtf_varchar2_table_200();
6757: x_attribute3 := jtf_varchar2_table_200();
6758: x_attribute4 := jtf_varchar2_table_200();
6769: x_attribute15 := jtf_varchar2_table_200();
6770: x_salesrep_first_name := jtf_varchar2_table_300();
6771: x_salesrep_last_name := jtf_varchar2_table_300();
6772: x_price_list_name := jtf_varchar2_table_300();
6773: x_quote_status_code := jtf_varchar2_table_100();
6774: x_quote_status := jtf_varchar2_table_300();
6775: x_party_name := jtf_varchar2_table_300();
6776: x_party_type := jtf_varchar2_table_100();
6777: x_person_first_name := jtf_varchar2_table_200();
6772: x_price_list_name := jtf_varchar2_table_300();
6773: x_quote_status_code := jtf_varchar2_table_100();
6774: x_quote_status := jtf_varchar2_table_300();
6775: x_party_name := jtf_varchar2_table_300();
6776: x_party_type := jtf_varchar2_table_100();
6777: x_person_first_name := jtf_varchar2_table_200();
6778: x_person_middle_name := jtf_varchar2_table_100();
6779: x_person_last_name := jtf_varchar2_table_200();
6780: x_marketing_source_name := jtf_varchar2_table_200();
6774: x_quote_status := jtf_varchar2_table_300();
6775: x_party_name := jtf_varchar2_table_300();
6776: x_party_type := jtf_varchar2_table_100();
6777: x_person_first_name := jtf_varchar2_table_200();
6778: x_person_middle_name := jtf_varchar2_table_100();
6779: x_person_last_name := jtf_varchar2_table_200();
6780: x_marketing_source_name := jtf_varchar2_table_200();
6781: x_marketing_source_code := jtf_varchar2_table_200();
6782: x_order_type_name := jtf_varchar2_table_300();
6781: x_marketing_source_code := jtf_varchar2_table_200();
6782: x_order_type_name := jtf_varchar2_table_300();
6783: x_invoice_to_party_name := jtf_varchar2_table_300();
6784: x_invoice_to_cont_first_name := jtf_varchar2_table_200();
6785: x_invoice_to_cont_mid_name := jtf_varchar2_table_100();
6786: x_invoice_to_cont_last_name := jtf_varchar2_table_200();
6787: x_invoice_to_address1 := jtf_varchar2_table_300();
6788: x_invoice_to_address2 := jtf_varchar2_table_300();
6789: x_invoice_to_address3 := jtf_varchar2_table_300();
6787: x_invoice_to_address1 := jtf_varchar2_table_300();
6788: x_invoice_to_address2 := jtf_varchar2_table_300();
6789: x_invoice_to_address3 := jtf_varchar2_table_300();
6790: x_invoice_to_address4 := jtf_varchar2_table_300();
6791: x_invoice_to_country_code := jtf_varchar2_table_100();
6792: x_invoice_to_country := jtf_varchar2_table_100();
6793: x_invoice_to_city := jtf_varchar2_table_100();
6794: x_invoice_to_postal_code := jtf_varchar2_table_100();
6795: x_invoice_to_state := jtf_varchar2_table_100();
6788: x_invoice_to_address2 := jtf_varchar2_table_300();
6789: x_invoice_to_address3 := jtf_varchar2_table_300();
6790: x_invoice_to_address4 := jtf_varchar2_table_300();
6791: x_invoice_to_country_code := jtf_varchar2_table_100();
6792: x_invoice_to_country := jtf_varchar2_table_100();
6793: x_invoice_to_city := jtf_varchar2_table_100();
6794: x_invoice_to_postal_code := jtf_varchar2_table_100();
6795: x_invoice_to_state := jtf_varchar2_table_100();
6796: x_invoice_to_province := jtf_varchar2_table_100();
6789: x_invoice_to_address3 := jtf_varchar2_table_300();
6790: x_invoice_to_address4 := jtf_varchar2_table_300();
6791: x_invoice_to_country_code := jtf_varchar2_table_100();
6792: x_invoice_to_country := jtf_varchar2_table_100();
6793: x_invoice_to_city := jtf_varchar2_table_100();
6794: x_invoice_to_postal_code := jtf_varchar2_table_100();
6795: x_invoice_to_state := jtf_varchar2_table_100();
6796: x_invoice_to_province := jtf_varchar2_table_100();
6797: x_invoice_to_county := jtf_varchar2_table_100();
6790: x_invoice_to_address4 := jtf_varchar2_table_300();
6791: x_invoice_to_country_code := jtf_varchar2_table_100();
6792: x_invoice_to_country := jtf_varchar2_table_100();
6793: x_invoice_to_city := jtf_varchar2_table_100();
6794: x_invoice_to_postal_code := jtf_varchar2_table_100();
6795: x_invoice_to_state := jtf_varchar2_table_100();
6796: x_invoice_to_province := jtf_varchar2_table_100();
6797: x_invoice_to_county := jtf_varchar2_table_100();
6798: x_resource_id := jtf_number_table();
6791: x_invoice_to_country_code := jtf_varchar2_table_100();
6792: x_invoice_to_country := jtf_varchar2_table_100();
6793: x_invoice_to_city := jtf_varchar2_table_100();
6794: x_invoice_to_postal_code := jtf_varchar2_table_100();
6795: x_invoice_to_state := jtf_varchar2_table_100();
6796: x_invoice_to_province := jtf_varchar2_table_100();
6797: x_invoice_to_county := jtf_varchar2_table_100();
6798: x_resource_id := jtf_number_table();
6799: --*/
6792: x_invoice_to_country := jtf_varchar2_table_100();
6793: x_invoice_to_city := jtf_varchar2_table_100();
6794: x_invoice_to_postal_code := jtf_varchar2_table_100();
6795: x_invoice_to_state := jtf_varchar2_table_100();
6796: x_invoice_to_province := jtf_varchar2_table_100();
6797: x_invoice_to_county := jtf_varchar2_table_100();
6798: x_resource_id := jtf_number_table();
6799: --*/
6800:
6793: x_invoice_to_city := jtf_varchar2_table_100();
6794: x_invoice_to_postal_code := jtf_varchar2_table_100();
6795: x_invoice_to_state := jtf_varchar2_table_100();
6796: x_invoice_to_province := jtf_varchar2_table_100();
6797: x_invoice_to_county := jtf_varchar2_table_100();
6798: x_resource_id := jtf_number_table();
6799: --*/
6800:
6801: IF p_qte_header_tbl.count > 0 THEN
7023: p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,
7024: x_quote_line_id OUT NOCOPY jtf_number_table
7025:
7026: /*-- The following output parameters are ignored
7027: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7028: x_creation_date OUT NOCOPY jtf_date_table,
7029: x_created_by OUT NOCOPY jtf_number_table,
7030: x_last_update_date OUT NOCOPY jtf_date_table,
7031: x_last_updated_by OUT NOCOPY jtf_number_table,
7035: x_program_id OUT NOCOPY jtf_number_table,
7036: x_program_update_date OUT NOCOPY jtf_date_table,
7037: x_quote_header_id OUT NOCOPY jtf_number_table,
7038: x_org_id OUT NOCOPY jtf_number_table,
7039: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
7040: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
7041: x_line_number OUT NOCOPY jtf_number_table,
7042: x_start_date_active OUT NOCOPY jtf_date_table,
7043: x_end_date_active OUT NOCOPY jtf_date_table,
7036: x_program_update_date OUT NOCOPY jtf_date_table,
7037: x_quote_header_id OUT NOCOPY jtf_number_table,
7038: x_org_id OUT NOCOPY jtf_number_table,
7039: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
7040: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
7041: x_line_number OUT NOCOPY jtf_number_table,
7042: x_start_date_active OUT NOCOPY jtf_date_table,
7043: x_end_date_active OUT NOCOPY jtf_date_table,
7044: x_order_line_type_id OUT NOCOPY jtf_number_table,
7047: x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,
7048: x_organization_id OUT NOCOPY jtf_number_table,
7049: x_inventory_item_id OUT NOCOPY jtf_number_table,
7050: x_quantity OUT NOCOPY jtf_number_table,
7051: x_uom_code OUT NOCOPY jtf_varchar2_table_100,
7052: x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
7053: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
7054: x_price_list_id OUT NOCOPY jtf_number_table,
7055: x_price_list_line_id OUT NOCOPY jtf_number_table,
7048: x_organization_id OUT NOCOPY jtf_number_table,
7049: x_inventory_item_id OUT NOCOPY jtf_number_table,
7050: x_quantity OUT NOCOPY jtf_number_table,
7051: x_uom_code OUT NOCOPY jtf_varchar2_table_100,
7052: x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
7053: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
7054: x_price_list_id OUT NOCOPY jtf_number_table,
7055: x_price_list_line_id OUT NOCOPY jtf_number_table,
7056: x_currency_code OUT NOCOPY jtf_varchar2_table_100,
7052: x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
7053: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
7054: x_price_list_id OUT NOCOPY jtf_number_table,
7055: x_price_list_line_id OUT NOCOPY jtf_number_table,
7056: x_currency_code OUT NOCOPY jtf_varchar2_table_100,
7057: x_line_list_price OUT NOCOPY jtf_number_table,
7058: x_line_adjusted_amount OUT NOCOPY jtf_number_table,
7059: x_line_adjusted_percent OUT NOCOPY jtf_number_table,
7060: x_line_quote_price OUT NOCOPY jtf_number_table,
7058: x_line_adjusted_amount OUT NOCOPY jtf_number_table,
7059: x_line_adjusted_percent OUT NOCOPY jtf_number_table,
7060: x_line_quote_price OUT NOCOPY jtf_number_table,
7061: x_related_item_id OUT NOCOPY jtf_number_table,
7062: x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
7063: x_accounting_rule_id OUT NOCOPY jtf_number_table,
7064: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
7065: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
7066: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
7061: x_related_item_id OUT NOCOPY jtf_number_table,
7062: x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
7063: x_accounting_rule_id OUT NOCOPY jtf_number_table,
7064: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
7065: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
7066: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
7067: x_minisite_id OUT NOCOPY jtf_number_table,
7068: x_section_id OUT NOCOPY jtf_number_table,
7069: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
7062: x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
7063: x_accounting_rule_id OUT NOCOPY jtf_number_table,
7064: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
7065: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
7066: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
7067: x_minisite_id OUT NOCOPY jtf_number_table,
7068: x_section_id OUT NOCOPY jtf_number_table,
7069: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
7070: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
7065: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
7066: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
7067: x_minisite_id OUT NOCOPY jtf_number_table,
7068: x_section_id OUT NOCOPY jtf_number_table,
7069: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
7070: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
7071: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7072: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7073: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7066: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
7067: x_minisite_id OUT NOCOPY jtf_number_table,
7068: x_section_id OUT NOCOPY jtf_number_table,
7069: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
7070: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
7071: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7072: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7073: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7074: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
7067: x_minisite_id OUT NOCOPY jtf_number_table,
7068: x_section_id OUT NOCOPY jtf_number_table,
7069: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
7070: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
7071: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7072: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7073: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7074: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
7075: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
7097: BEGIN
7098: x_quote_line_id := jtf_number_table();
7099:
7100: /*-- The following output parameters are ignored
7101: x_operation_code := jtf_varchar2_table_100();
7102: x_creation_date := jtf_date_table();
7103: x_created_by := jtf_number_table();
7104: x_last_update_date := jtf_date_table();
7105: x_last_updated_by := jtf_number_table();
7109: x_program_id := jtf_number_table();
7110: x_program_update_date := jtf_date_table();
7111: x_quote_header_id := jtf_number_table();
7112: x_org_id := jtf_number_table();
7113: x_line_category_code := jtf_varchar2_table_100();
7114: x_item_type_code := jtf_varchar2_table_100();
7115: x_line_number := jtf_number_table();
7116: x_start_date_active := jtf_date_table();
7117: x_end_date_active := jtf_date_table();
7110: x_program_update_date := jtf_date_table();
7111: x_quote_header_id := jtf_number_table();
7112: x_org_id := jtf_number_table();
7113: x_line_category_code := jtf_varchar2_table_100();
7114: x_item_type_code := jtf_varchar2_table_100();
7115: x_line_number := jtf_number_table();
7116: x_start_date_active := jtf_date_table();
7117: x_end_date_active := jtf_date_table();
7118: x_order_line_type_id := jtf_number_table();
7121: x_invoice_to_cust_account_id := jtf_number_table();
7122: x_organization_id := jtf_number_table();
7123: x_inventory_item_id := jtf_number_table();
7124: x_quantity := jtf_number_table();
7125: x_uom_code := jtf_varchar2_table_100();
7126: x_pricing_quantity_uom := jtf_varchar2_table_100();
7127: x_marketing_source_code_id := jtf_number_table();
7128: x_price_list_id := jtf_number_table();
7129: x_price_list_line_id := jtf_number_table();
7122: x_organization_id := jtf_number_table();
7123: x_inventory_item_id := jtf_number_table();
7124: x_quantity := jtf_number_table();
7125: x_uom_code := jtf_varchar2_table_100();
7126: x_pricing_quantity_uom := jtf_varchar2_table_100();
7127: x_marketing_source_code_id := jtf_number_table();
7128: x_price_list_id := jtf_number_table();
7129: x_price_list_line_id := jtf_number_table();
7130: x_currency_code := jtf_varchar2_table_100();
7126: x_pricing_quantity_uom := jtf_varchar2_table_100();
7127: x_marketing_source_code_id := jtf_number_table();
7128: x_price_list_id := jtf_number_table();
7129: x_price_list_line_id := jtf_number_table();
7130: x_currency_code := jtf_varchar2_table_100();
7131: x_line_list_price := jtf_number_table();
7132: x_line_adjusted_amount := jtf_number_table();
7133: x_line_adjusted_percent := jtf_number_table();
7134: x_line_quote_price := jtf_number_table();
7132: x_line_adjusted_amount := jtf_number_table();
7133: x_line_adjusted_percent := jtf_number_table();
7134: x_line_quote_price := jtf_number_table();
7135: x_related_item_id := jtf_number_table();
7136: x_item_relationship_type := jtf_varchar2_table_100();
7137: x_accounting_rule_id := jtf_number_table();
7138: x_invoicing_rule_id := jtf_number_table();
7139: x_split_shipment_flag := jtf_varchar2_table_100();
7140: x_backorder_flag := jtf_varchar2_table_100();
7135: x_related_item_id := jtf_number_table();
7136: x_item_relationship_type := jtf_varchar2_table_100();
7137: x_accounting_rule_id := jtf_number_table();
7138: x_invoicing_rule_id := jtf_number_table();
7139: x_split_shipment_flag := jtf_varchar2_table_100();
7140: x_backorder_flag := jtf_varchar2_table_100();
7141: x_minisite_id := jtf_number_table();
7142: x_section_id := jtf_number_table();
7143: x_selling_price_change := jtf_varchar2_table_100();
7136: x_item_relationship_type := jtf_varchar2_table_100();
7137: x_accounting_rule_id := jtf_number_table();
7138: x_invoicing_rule_id := jtf_number_table();
7139: x_split_shipment_flag := jtf_varchar2_table_100();
7140: x_backorder_flag := jtf_varchar2_table_100();
7141: x_minisite_id := jtf_number_table();
7142: x_section_id := jtf_number_table();
7143: x_selling_price_change := jtf_varchar2_table_100();
7144: x_recalculate_flag := jtf_varchar2_table_100();
7139: x_split_shipment_flag := jtf_varchar2_table_100();
7140: x_backorder_flag := jtf_varchar2_table_100();
7141: x_minisite_id := jtf_number_table();
7142: x_section_id := jtf_number_table();
7143: x_selling_price_change := jtf_varchar2_table_100();
7144: x_recalculate_flag := jtf_varchar2_table_100();
7145: x_attribute_category := jtf_varchar2_table_100();
7146: x_attribute1 := jtf_varchar2_table_200();
7147: x_attribute2 := jtf_varchar2_table_200();
7140: x_backorder_flag := jtf_varchar2_table_100();
7141: x_minisite_id := jtf_number_table();
7142: x_section_id := jtf_number_table();
7143: x_selling_price_change := jtf_varchar2_table_100();
7144: x_recalculate_flag := jtf_varchar2_table_100();
7145: x_attribute_category := jtf_varchar2_table_100();
7146: x_attribute1 := jtf_varchar2_table_200();
7147: x_attribute2 := jtf_varchar2_table_200();
7148: x_attribute3 := jtf_varchar2_table_200();
7141: x_minisite_id := jtf_number_table();
7142: x_section_id := jtf_number_table();
7143: x_selling_price_change := jtf_varchar2_table_100();
7144: x_recalculate_flag := jtf_varchar2_table_100();
7145: x_attribute_category := jtf_varchar2_table_100();
7146: x_attribute1 := jtf_varchar2_table_200();
7147: x_attribute2 := jtf_varchar2_table_200();
7148: x_attribute3 := jtf_varchar2_table_200();
7149: x_attribute4 := jtf_varchar2_table_200();
7327: p_qte_line_dtl_tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
7328: x_quote_line_detail_id OUT NOCOPY jtf_number_table
7329:
7330: /*-- The following output parameters are ignored
7331: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7332: x_qte_line_index OUT NOCOPY jtf_number_table,
7333: x_creation_date OUT NOCOPY jtf_date_table,
7334: x_created_by OUT NOCOPY jtf_number_table,
7335: x_last_update_date OUT NOCOPY jtf_date_table,
7342: x_quote_line_id OUT NOCOPY jtf_number_table,
7343: x_config_header_id OUT NOCOPY jtf_number_table,
7344: x_config_revision_num OUT NOCOPY jtf_number_table,
7345: x_config_item_id OUT NOCOPY jtf_number_table,
7346: x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
7347: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
7348: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
7349: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
7350: x_service_duration OUT NOCOPY jtf_number_table,
7343: x_config_header_id OUT NOCOPY jtf_number_table,
7344: x_config_revision_num OUT NOCOPY jtf_number_table,
7345: x_config_item_id OUT NOCOPY jtf_number_table,
7346: x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
7347: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
7348: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
7349: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
7350: x_service_duration OUT NOCOPY jtf_number_table,
7351: x_service_period OUT NOCOPY jtf_varchar2_table_100,
7345: x_config_item_id OUT NOCOPY jtf_number_table,
7346: x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
7347: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
7348: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
7349: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
7350: x_service_duration OUT NOCOPY jtf_number_table,
7351: x_service_period OUT NOCOPY jtf_varchar2_table_100,
7352: x_service_unit_selling OUT NOCOPY jtf_number_table,
7353: x_service_unit_list OUT NOCOPY jtf_number_table,
7347: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
7348: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
7349: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
7350: x_service_duration OUT NOCOPY jtf_number_table,
7351: x_service_period OUT NOCOPY jtf_varchar2_table_100,
7352: x_service_unit_selling OUT NOCOPY jtf_number_table,
7353: x_service_unit_list OUT NOCOPY jtf_number_table,
7354: x_service_number OUT NOCOPY jtf_number_table,
7355: x_unit_percent_base_price OUT NOCOPY jtf_number_table,
7352: x_service_unit_selling OUT NOCOPY jtf_number_table,
7353: x_service_unit_list OUT NOCOPY jtf_number_table,
7354: x_service_number OUT NOCOPY jtf_number_table,
7355: x_unit_percent_base_price OUT NOCOPY jtf_number_table,
7356: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7357: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7358: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7359: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
7360: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
7368: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
7369: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
7370: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
7371: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
7372: x_service_ref_type_code OUT NOCOPY jtf_varchar2_table_100,
7373: x_service_ref_order_number OUT NOCOPY jtf_number_table,
7374: x_service_ref_line_number OUT NOCOPY jtf_number_table,
7375: x_service_ref_qte_line_ind OUT NOCOPY jtf_number_table,
7376: x_service_ref_line_id OUT NOCOPY jtf_number_table,
7376: x_service_ref_line_id OUT NOCOPY jtf_number_table,
7377: x_service_ref_system_id OUT NOCOPY jtf_number_table,
7378: x_service_ref_option_numb OUT NOCOPY jtf_number_table,
7379: x_service_ref_shipment OUT NOCOPY jtf_number_table,
7380: x_return_ref_type OUT NOCOPY jtf_varchar2_table_100,
7381: x_return_ref_header_id OUT NOCOPY jtf_number_table,
7382: x_return_ref_line_id OUT NOCOPY jtf_number_table,
7383: x_return_attribute1 OUT NOCOPY jtf_varchar2_table_300,
7384: x_return_attribute2 OUT NOCOPY jtf_varchar2_table_300,
7394: x_return_attribute15 OUT NOCOPY jtf_varchar2_table_300,
7395: x_return_attribute12 OUT NOCOPY jtf_varchar2_table_300,
7396: x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
7397: x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
7398: x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
7399: x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
7400: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
7401: --*/
7402: )
7395: x_return_attribute12 OUT NOCOPY jtf_varchar2_table_300,
7396: x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
7397: x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
7398: x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
7399: x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
7400: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
7401: --*/
7402: )
7403: AS
7396: x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
7397: x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
7398: x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
7399: x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
7400: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
7401: --*/
7402: )
7403: AS
7404: ddindx binary_integer; indx binary_integer;
7405: BEGIN
7406: x_quote_line_detail_id := jtf_number_table();
7407:
7408: /*-- The following output parameters are ignored
7409: x_operation_code := jtf_varchar2_table_100();
7410: x_qte_line_index := jtf_number_table();
7411: x_creation_date := jtf_date_table();
7412: x_created_by := jtf_number_table();
7413: x_last_update_date := jtf_date_table();
7420: x_quote_line_id := jtf_number_table();
7421: x_config_header_id := jtf_number_table();
7422: x_config_revision_num := jtf_number_table();
7423: x_config_item_id := jtf_number_table();
7424: x_complete_configuration:= jtf_varchar2_table_100();
7425: x_valid_configuration_flag := jtf_varchar2_table_100();
7426: x_component_code := jtf_varchar2_table_1200();
7427: x_service_coterminate_flag := jtf_varchar2_table_100();
7428: x_service_duration := jtf_number_table();
7421: x_config_header_id := jtf_number_table();
7422: x_config_revision_num := jtf_number_table();
7423: x_config_item_id := jtf_number_table();
7424: x_complete_configuration:= jtf_varchar2_table_100();
7425: x_valid_configuration_flag := jtf_varchar2_table_100();
7426: x_component_code := jtf_varchar2_table_1200();
7427: x_service_coterminate_flag := jtf_varchar2_table_100();
7428: x_service_duration := jtf_number_table();
7429: x_service_period := jtf_varchar2_table_100();
7423: x_config_item_id := jtf_number_table();
7424: x_complete_configuration:= jtf_varchar2_table_100();
7425: x_valid_configuration_flag := jtf_varchar2_table_100();
7426: x_component_code := jtf_varchar2_table_1200();
7427: x_service_coterminate_flag := jtf_varchar2_table_100();
7428: x_service_duration := jtf_number_table();
7429: x_service_period := jtf_varchar2_table_100();
7430: x_service_unit_selling := jtf_number_table();
7431: x_service_unit_list:= jtf_number_table();
7425: x_valid_configuration_flag := jtf_varchar2_table_100();
7426: x_component_code := jtf_varchar2_table_1200();
7427: x_service_coterminate_flag := jtf_varchar2_table_100();
7428: x_service_duration := jtf_number_table();
7429: x_service_period := jtf_varchar2_table_100();
7430: x_service_unit_selling := jtf_number_table();
7431: x_service_unit_list:= jtf_number_table();
7432: x_service_number := jtf_number_table();
7433: x_unit_percent_base_price := jtf_number_table();
7430: x_service_unit_selling := jtf_number_table();
7431: x_service_unit_list:= jtf_number_table();
7432: x_service_number := jtf_number_table();
7433: x_unit_percent_base_price := jtf_number_table();
7434: x_attribute_category := jtf_varchar2_table_100();
7435: x_attribute1 := jtf_varchar2_table_200();
7436: x_attribute2 := jtf_varchar2_table_200();
7437: x_attribute3 := jtf_varchar2_table_200();
7438: x_attribute4 := jtf_varchar2_table_200();
7446: x_attribute12 := jtf_varchar2_table_200();
7447: x_attribute13 := jtf_varchar2_table_200();
7448: x_attribute14 := jtf_varchar2_table_200();
7449: x_attribute15 := jtf_varchar2_table_200();
7450: x_service_ref_type_code := jtf_varchar2_table_100();
7451: x_service_ref_order_number := jtf_number_table();
7452: x_service_ref_line_number := jtf_number_table();
7453: x_service_ref_qte_line_ind := jtf_number_table();
7454: x_service_ref_line_id := jtf_number_table();
7454: x_service_ref_line_id := jtf_number_table();
7455: x_service_ref_system_id := jtf_number_table();
7456: x_service_ref_option_numb := jtf_number_table();
7457: x_service_ref_shipment:= jtf_number_table();
7458: x_return_ref_type := jtf_varchar2_table_100();
7459: x_return_ref_header_id := jtf_number_table();
7460: x_return_ref_line_id := jtf_number_table();
7461: x_return_attribute1 := jtf_varchar2_table_300();
7462: x_return_attribute2 := jtf_varchar2_table_300();
7472: x_return_attribute15 := jtf_varchar2_table_300();
7473: x_return_attribute12 := jtf_varchar2_table_300();
7474: x_return_attribute13 := jtf_varchar2_table_300();
7475: x_return_attribute14 := jtf_varchar2_table_300();
7476: x_return_attr_category := jtf_varchar2_table_100();
7477: x_return_reason_code := jtf_varchar2_table_100();
7478: x_change_reason_code := jtf_varchar2_table_100();
7479: --*/
7480:
7473: x_return_attribute12 := jtf_varchar2_table_300();
7474: x_return_attribute13 := jtf_varchar2_table_300();
7475: x_return_attribute14 := jtf_varchar2_table_300();
7476: x_return_attr_category := jtf_varchar2_table_100();
7477: x_return_reason_code := jtf_varchar2_table_100();
7478: x_change_reason_code := jtf_varchar2_table_100();
7479: --*/
7480:
7481: IF p_qte_line_dtl_tbl.count > 0 THEN
7474: x_return_attribute13 := jtf_varchar2_table_300();
7475: x_return_attribute14 := jtf_varchar2_table_300();
7476: x_return_attr_category := jtf_varchar2_table_100();
7477: x_return_reason_code := jtf_varchar2_table_100();
7478: x_change_reason_code := jtf_varchar2_table_100();
7479: --*/
7480:
7481: IF p_qte_line_dtl_tbl.count > 0 THEN
7482: x_quote_line_detail_id.extend(p_qte_line_dtl_tbl.count);
7647: p_qte_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type,
7648: x_line_relationship_id OUT NOCOPY jtf_number_table
7649:
7650: /*-- The following output parameters are ignored
7651: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7652: x_creation_date OUT NOCOPY jtf_date_table,
7653: x_created_by OUT NOCOPY jtf_number_table,
7654: x_last_update_date OUT NOCOPY jtf_date_table,
7655: x_last_updated_by OUT NOCOPY jtf_number_table,
7661: x_quote_line_id OUT NOCOPY jtf_number_table,
7662: x_qte_line_index OUT NOCOPY jtf_number_table,
7663: x_related_quote_line_id OUT NOCOPY jtf_number_table,
7664: x_related_qte_line_index OUT NOCOPY jtf_number_table,
7665: x_relationship_type_code OUT NOCOPY jtf_varchar2_table_100,
7666: x_reciprocal_flag OUT NOCOPY jtf_varchar2_table_100
7667: --*/
7668: )
7669: AS
7662: x_qte_line_index OUT NOCOPY jtf_number_table,
7663: x_related_quote_line_id OUT NOCOPY jtf_number_table,
7664: x_related_qte_line_index OUT NOCOPY jtf_number_table,
7665: x_relationship_type_code OUT NOCOPY jtf_varchar2_table_100,
7666: x_reciprocal_flag OUT NOCOPY jtf_varchar2_table_100
7667: --*/
7668: )
7669: AS
7670: ddindx binary_integer; indx binary_integer;
7671: BEGIN
7672: x_line_relationship_id := jtf_number_table();
7673:
7674: /*-- The following output parameters are ignored
7675: x_operation_code := jtf_varchar2_table_100();
7676: x_creation_date := jtf_date_table();
7677: x_created_by := jtf_number_table();
7678: x_last_update_date := jtf_date_table();
7679: x_last_updated_by := jtf_number_table();
7685: x_quote_line_id := jtf_number_table();
7686: x_qte_line_index := jtf_number_table();
7687: x_related_quote_line_id := jtf_number_table();
7688: x_related_qte_line_index := jtf_number_table();
7689: x_relationship_type_code := jtf_varchar2_table_100();
7690: x_reciprocal_flag := jtf_varchar2_table_100();
7691: --*/
7692:
7693: IF p_qte_line_rltship_tbl.count > 0 THEN
7686: x_qte_line_index := jtf_number_table();
7687: x_related_quote_line_id := jtf_number_table();
7688: x_related_qte_line_index := jtf_number_table();
7689: x_relationship_type_code := jtf_varchar2_table_100();
7690: x_reciprocal_flag := jtf_varchar2_table_100();
7691: --*/
7692:
7693: IF p_qte_line_rltship_tbl.count > 0 THEN
7694: x_line_relationship_id.extend(p_qte_line_rltship_tbl.count);
7751: p_qte_payment_tbl IN ASO_Quote_Pub.Payment_Tbl_Type,
7752: x_payment_id OUT NOCOPY jtf_number_table
7753:
7754: /*-- The following output parameters are ignored
7755: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7756: x_qte_line_index OUT NOCOPY jtf_number_table,
7757: x_shipment_index OUT NOCOPY jtf_number_table,
7758: x_creation_date OUT NOCOPY jtf_date_table,
7759: x_created_by OUT NOCOPY jtf_number_table,
7766: x_program_update_date OUT NOCOPY jtf_date_table,
7767: x_quote_header_id OUT NOCOPY jtf_number_table,
7768: x_quote_line_id OUT NOCOPY jtf_number_table,
7769: x_quote_shipment_id OUT NOCOPY jtf_number_table,
7770: x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,
7771: x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
7772: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
7773: x_payment_term_id OUT NOCOPY jtf_number_table,
7774: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
7770: x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,
7771: x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
7772: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
7773: x_payment_term_id OUT NOCOPY jtf_number_table,
7774: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
7775: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
7776: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
7777: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
7778: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
7771: x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
7772: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
7773: x_payment_term_id OUT NOCOPY jtf_number_table,
7774: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
7775: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
7776: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
7777: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
7778: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
7779: x_payment_amount OUT NOCOPY jtf_number_table,
7773: x_payment_term_id OUT NOCOPY jtf_number_table,
7774: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
7775: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
7776: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
7777: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
7778: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
7779: x_payment_amount OUT NOCOPY jtf_number_table,
7780: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7781: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7776: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
7777: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
7778: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
7779: x_payment_amount OUT NOCOPY jtf_number_table,
7780: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7781: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7782: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7783: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
7784: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
7792: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
7793: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
7794: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
7795: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
7796: x_cust_po_number OUT NOCOPY jtf_varchar2_table_100
7797: --*/
7798: )
7799: AS
7800: ddindx binary_integer; indx binary_integer;
7801: BEGIN
7802: x_payment_id := jtf_number_table();
7803:
7804: /*-- The following output parameters are ignored
7805: x_operation_code := jtf_varchar2_table_100();
7806: x_qte_line_index := jtf_number_table();
7807: x_shipment_index := jtf_number_table();
7808: x_creation_date := jtf_date_table();
7809: x_created_by := jtf_number_table();
7816: x_program_update_date := jtf_date_table();
7817: x_quote_header_id := jtf_number_table();
7818: x_quote_line_id := jtf_number_table();
7819: x_quote_shipment_id := jtf_number_table();
7820: x_payment_type_code := jtf_varchar2_table_100();
7821: x_payment_ref_number := jtf_varchar2_table_300();
7822: x_payment_option := jtf_varchar2_table_300();
7823: x_payment_term_id := jtf_number_table();
7824: x_credit_card_code := jtf_varchar2_table_100();
7820: x_payment_type_code := jtf_varchar2_table_100();
7821: x_payment_ref_number := jtf_varchar2_table_300();
7822: x_payment_option := jtf_varchar2_table_300();
7823: x_payment_term_id := jtf_number_table();
7824: x_credit_card_code := jtf_varchar2_table_100();
7825: x_credit_card_holder_name := jtf_varchar2_table_100();
7826: x_credit_card_exp_date := jtf_date_table();
7827: x_credit_card_approval_code := jtf_varchar2_table_100();
7828: x_credit_card_approval_date := jtf_date_table();
7821: x_payment_ref_number := jtf_varchar2_table_300();
7822: x_payment_option := jtf_varchar2_table_300();
7823: x_payment_term_id := jtf_number_table();
7824: x_credit_card_code := jtf_varchar2_table_100();
7825: x_credit_card_holder_name := jtf_varchar2_table_100();
7826: x_credit_card_exp_date := jtf_date_table();
7827: x_credit_card_approval_code := jtf_varchar2_table_100();
7828: x_credit_card_approval_date := jtf_date_table();
7829: x_payment_amount := jtf_number_table();
7823: x_payment_term_id := jtf_number_table();
7824: x_credit_card_code := jtf_varchar2_table_100();
7825: x_credit_card_holder_name := jtf_varchar2_table_100();
7826: x_credit_card_exp_date := jtf_date_table();
7827: x_credit_card_approval_code := jtf_varchar2_table_100();
7828: x_credit_card_approval_date := jtf_date_table();
7829: x_payment_amount := jtf_number_table();
7830: x_attribute_category := jtf_varchar2_table_100();
7831: x_attribute1 := jtf_varchar2_table_200();
7826: x_credit_card_exp_date := jtf_date_table();
7827: x_credit_card_approval_code := jtf_varchar2_table_100();
7828: x_credit_card_approval_date := jtf_date_table();
7829: x_payment_amount := jtf_number_table();
7830: x_attribute_category := jtf_varchar2_table_100();
7831: x_attribute1 := jtf_varchar2_table_200();
7832: x_attribute2 := jtf_varchar2_table_200();
7833: x_attribute3 := jtf_varchar2_table_200();
7834: x_attribute4 := jtf_varchar2_table_200();
7842: x_attribute12 := jtf_varchar2_table_200();
7843: x_attribute13 := jtf_varchar2_table_200();
7844: x_attribute14 := jtf_varchar2_table_200();
7845: x_attribute15 := jtf_varchar2_table_200();
7846: x_cust_po_number := jtf_varchar2_table_100();
7847: --*/
7848: IF p_qte_payment_tbl.count > 0 THEN
7849: x_payment_id.extend(p_qte_payment_tbl.count);
7850:
7958: p_qte_shipment_tbl IN ASO_Quote_Pub.Shipment_Tbl_Type,
7959: x_shipment_id OUT NOCOPY jtf_number_table
7960:
7961: /*-- The following output parameters are ignored
7962: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7963: x_qte_line_index OUT NOCOPY jtf_number_table,
7964: x_creation_date OUT NOCOPY jtf_date_table,
7965: x_created_by OUT NOCOPY jtf_number_table,
7966: x_last_update_date OUT NOCOPY jtf_date_table,
7979: x_ship_to_party_id OUT NOCOPY jtf_number_table,
7980: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
7981: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
7982: x_ship_set_id OUT NOCOPY jtf_number_table,
7983: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
7984: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
7985: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
7986: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
7987: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
7980: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
7981: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
7982: x_ship_set_id OUT NOCOPY jtf_number_table,
7983: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
7984: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
7985: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
7986: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
7987: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
7988: x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
7981: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
7982: x_ship_set_id OUT NOCOPY jtf_number_table,
7983: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
7984: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
7985: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
7986: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
7987: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
7988: x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
7989: x_ship_quote_price OUT NOCOPY jtf_number_table,
7982: x_ship_set_id OUT NOCOPY jtf_number_table,
7983: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
7984: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
7985: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
7986: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
7987: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
7988: x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
7989: x_ship_quote_price OUT NOCOPY jtf_number_table,
7990: x_quantity OUT NOCOPY jtf_number_table,
7993: x_reservation_id OUT NOCOPY jtf_number_table,
7994: x_order_line_id OUT NOCOPY jtf_number_table,
7995: x_ship_to_party_name OUT NOCOPY jtf_varchar2_table_300,
7996: x_ship_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
7997: x_ship_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
7998: x_ship_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
7999: x_ship_to_address1 OUT NOCOPY jtf_varchar2_table_300,
8000: x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
8001: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
7999: x_ship_to_address1 OUT NOCOPY jtf_varchar2_table_300,
8000: x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
8001: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
8002: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
8003: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
8004: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
8005: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
8006: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
8007: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
8000: x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
8001: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
8002: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
8003: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
8004: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
8005: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
8006: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
8007: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
8008: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
8001: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
8002: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
8003: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
8004: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
8005: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
8006: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
8007: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
8008: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
8009: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
8002: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
8003: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
8004: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
8005: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
8006: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
8007: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
8008: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
8009: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
8010: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8003: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
8004: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
8005: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
8006: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
8007: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
8008: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
8009: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
8010: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8011: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8004: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
8005: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
8006: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
8007: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
8008: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
8009: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
8010: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8011: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8012: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8005: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
8006: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
8007: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
8008: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
8009: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
8010: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8011: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8012: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8013: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8006: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
8007: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
8008: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
8009: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
8010: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8011: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8012: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8013: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8014: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
8022: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
8023: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
8024: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
8025: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
8026: x_shipment_priority_code OUT NOCOPY jtf_varchar2_table_100,
8027: x_ship_from_org_id OUT NOCOPY jtf_number_table
8028: --*/
8029: )
8030: AS
8032: BEGIN
8033: x_shipment_id := jtf_number_table();
8034:
8035: /*-- The following output parameters are ignored
8036: x_operation_code := jtf_varchar2_table_100();
8037: x_qte_line_index := jtf_number_table();
8038: x_creation_date := jtf_date_table();
8039: x_created_by := jtf_number_table();
8040: x_last_update_date := jtf_date_table();
8053: x_ship_to_party_id := jtf_number_table();
8054: x_ship_to_cust_account_id := jtf_number_table();
8055: x_ship_partial_flag := jtf_varchar2_table_300();
8056: x_ship_set_id := jtf_number_table();
8057: x_ship_method_code := jtf_varchar2_table_100();
8058: x_freight_terms_code := jtf_varchar2_table_100();
8059: x_freight_carrier_code := jtf_varchar2_table_100();
8060: x_fob_code := jtf_varchar2_table_100();
8061: x_shipping_instructions := jtf_varchar2_table_2000();
8054: x_ship_to_cust_account_id := jtf_number_table();
8055: x_ship_partial_flag := jtf_varchar2_table_300();
8056: x_ship_set_id := jtf_number_table();
8057: x_ship_method_code := jtf_varchar2_table_100();
8058: x_freight_terms_code := jtf_varchar2_table_100();
8059: x_freight_carrier_code := jtf_varchar2_table_100();
8060: x_fob_code := jtf_varchar2_table_100();
8061: x_shipping_instructions := jtf_varchar2_table_2000();
8062: x_packing_instructions := jtf_varchar2_table_2000();
8055: x_ship_partial_flag := jtf_varchar2_table_300();
8056: x_ship_set_id := jtf_number_table();
8057: x_ship_method_code := jtf_varchar2_table_100();
8058: x_freight_terms_code := jtf_varchar2_table_100();
8059: x_freight_carrier_code := jtf_varchar2_table_100();
8060: x_fob_code := jtf_varchar2_table_100();
8061: x_shipping_instructions := jtf_varchar2_table_2000();
8062: x_packing_instructions := jtf_varchar2_table_2000();
8063: x_ship_quote_price := jtf_number_table();
8056: x_ship_set_id := jtf_number_table();
8057: x_ship_method_code := jtf_varchar2_table_100();
8058: x_freight_terms_code := jtf_varchar2_table_100();
8059: x_freight_carrier_code := jtf_varchar2_table_100();
8060: x_fob_code := jtf_varchar2_table_100();
8061: x_shipping_instructions := jtf_varchar2_table_2000();
8062: x_packing_instructions := jtf_varchar2_table_2000();
8063: x_ship_quote_price := jtf_number_table();
8064: x_quantity := jtf_number_table();
8067: x_reservation_id := jtf_number_table();
8068: x_order_line_id := jtf_number_table();
8069: x_ship_to_party_name := jtf_varchar2_table_300();
8070: x_ship_to_cont_first_name := jtf_varchar2_table_200();
8071: x_ship_to_cont_mid_name := jtf_varchar2_table_100();
8072: x_ship_to_cont_last_name := jtf_varchar2_table_200();
8073: x_ship_to_address1 := jtf_varchar2_table_300();
8074: x_ship_to_address2 := jtf_varchar2_table_300();
8075: x_ship_to_address3 := jtf_varchar2_table_300();
8073: x_ship_to_address1 := jtf_varchar2_table_300();
8074: x_ship_to_address2 := jtf_varchar2_table_300();
8075: x_ship_to_address3 := jtf_varchar2_table_300();
8076: x_ship_to_address4 := jtf_varchar2_table_300();
8077: x_ship_to_country_code := jtf_varchar2_table_100();
8078: x_ship_to_country := jtf_varchar2_table_100();
8079: x_ship_to_city := jtf_varchar2_table_100();
8080: x_ship_to_postal_code := jtf_varchar2_table_100();
8081: x_ship_to_state := jtf_varchar2_table_100();
8074: x_ship_to_address2 := jtf_varchar2_table_300();
8075: x_ship_to_address3 := jtf_varchar2_table_300();
8076: x_ship_to_address4 := jtf_varchar2_table_300();
8077: x_ship_to_country_code := jtf_varchar2_table_100();
8078: x_ship_to_country := jtf_varchar2_table_100();
8079: x_ship_to_city := jtf_varchar2_table_100();
8080: x_ship_to_postal_code := jtf_varchar2_table_100();
8081: x_ship_to_state := jtf_varchar2_table_100();
8082: x_ship_to_province := jtf_varchar2_table_100();
8075: x_ship_to_address3 := jtf_varchar2_table_300();
8076: x_ship_to_address4 := jtf_varchar2_table_300();
8077: x_ship_to_country_code := jtf_varchar2_table_100();
8078: x_ship_to_country := jtf_varchar2_table_100();
8079: x_ship_to_city := jtf_varchar2_table_100();
8080: x_ship_to_postal_code := jtf_varchar2_table_100();
8081: x_ship_to_state := jtf_varchar2_table_100();
8082: x_ship_to_province := jtf_varchar2_table_100();
8083: x_ship_to_county := jtf_varchar2_table_100();
8076: x_ship_to_address4 := jtf_varchar2_table_300();
8077: x_ship_to_country_code := jtf_varchar2_table_100();
8078: x_ship_to_country := jtf_varchar2_table_100();
8079: x_ship_to_city := jtf_varchar2_table_100();
8080: x_ship_to_postal_code := jtf_varchar2_table_100();
8081: x_ship_to_state := jtf_varchar2_table_100();
8082: x_ship_to_province := jtf_varchar2_table_100();
8083: x_ship_to_county := jtf_varchar2_table_100();
8084: x_attribute_category := jtf_varchar2_table_100();
8077: x_ship_to_country_code := jtf_varchar2_table_100();
8078: x_ship_to_country := jtf_varchar2_table_100();
8079: x_ship_to_city := jtf_varchar2_table_100();
8080: x_ship_to_postal_code := jtf_varchar2_table_100();
8081: x_ship_to_state := jtf_varchar2_table_100();
8082: x_ship_to_province := jtf_varchar2_table_100();
8083: x_ship_to_county := jtf_varchar2_table_100();
8084: x_attribute_category := jtf_varchar2_table_100();
8085: x_attribute1 := jtf_varchar2_table_200();
8078: x_ship_to_country := jtf_varchar2_table_100();
8079: x_ship_to_city := jtf_varchar2_table_100();
8080: x_ship_to_postal_code := jtf_varchar2_table_100();
8081: x_ship_to_state := jtf_varchar2_table_100();
8082: x_ship_to_province := jtf_varchar2_table_100();
8083: x_ship_to_county := jtf_varchar2_table_100();
8084: x_attribute_category := jtf_varchar2_table_100();
8085: x_attribute1 := jtf_varchar2_table_200();
8086: x_attribute2 := jtf_varchar2_table_200();
8079: x_ship_to_city := jtf_varchar2_table_100();
8080: x_ship_to_postal_code := jtf_varchar2_table_100();
8081: x_ship_to_state := jtf_varchar2_table_100();
8082: x_ship_to_province := jtf_varchar2_table_100();
8083: x_ship_to_county := jtf_varchar2_table_100();
8084: x_attribute_category := jtf_varchar2_table_100();
8085: x_attribute1 := jtf_varchar2_table_200();
8086: x_attribute2 := jtf_varchar2_table_200();
8087: x_attribute3 := jtf_varchar2_table_200();
8080: x_ship_to_postal_code := jtf_varchar2_table_100();
8081: x_ship_to_state := jtf_varchar2_table_100();
8082: x_ship_to_province := jtf_varchar2_table_100();
8083: x_ship_to_county := jtf_varchar2_table_100();
8084: x_attribute_category := jtf_varchar2_table_100();
8085: x_attribute1 := jtf_varchar2_table_200();
8086: x_attribute2 := jtf_varchar2_table_200();
8087: x_attribute3 := jtf_varchar2_table_200();
8088: x_attribute4 := jtf_varchar2_table_200();
8096: x_attribute12 := jtf_varchar2_table_200();
8097: x_attribute13 := jtf_varchar2_table_200();
8098: x_attribute14 := jtf_varchar2_table_200();
8099: x_attribute15 := jtf_varchar2_table_200();
8100: x_shipment_priority_code := jtf_varchar2_table_100();
8101: x_ship_from_org_id := jtf_number_table();
8102: --*/
8103:
8104: IF p_qte_shipment_tbl.count > 0 THEN
8262: p_qte_tax_detail_tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type,
8263: x_tax_detail_id OUT NOCOPY jtf_number_table
8264:
8265: /*-- The following output parameters are ignored
8266: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
8267: x_qte_line_index OUT NOCOPY jtf_number_table,
8268: x_shipment_index OUT NOCOPY jtf_number_table,
8269: x_quote_header_id OUT NOCOPY jtf_number_table,
8270: x_quote_line_id OUT NOCOPY jtf_number_table,
8278: x_program_application_id OUT NOCOPY jtf_number_table,
8279: x_program_id OUT NOCOPY jtf_number_table,
8280: x_program_update_date OUT NOCOPY jtf_date_table,
8281: x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
8282: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8283: x_tax_rate OUT NOCOPY jtf_number_table,
8284: x_tax_date OUT NOCOPY jtf_date_table,
8285: x_tax_amount OUT NOCOPY jtf_number_table,
8286: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8282: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8283: x_tax_rate OUT NOCOPY jtf_number_table,
8284: x_tax_date OUT NOCOPY jtf_date_table,
8285: x_tax_amount OUT NOCOPY jtf_number_table,
8286: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8287: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8288: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8289: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8290: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8283: x_tax_rate OUT NOCOPY jtf_number_table,
8284: x_tax_date OUT NOCOPY jtf_date_table,
8285: x_tax_amount OUT NOCOPY jtf_number_table,
8286: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8287: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8288: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8289: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8290: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8291: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8284: x_tax_date OUT NOCOPY jtf_date_table,
8285: x_tax_amount OUT NOCOPY jtf_number_table,
8286: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8287: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8288: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8289: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8290: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8291: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8292: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8285: x_tax_amount OUT NOCOPY jtf_number_table,
8286: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8287: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8288: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8289: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8290: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8291: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8292: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8293: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
8309: BEGIN
8310: x_tax_detail_id := jtf_number_table();
8311:
8312: /*-- The following output parameters are ignored
8313: x_operation_code := jtf_varchar2_table_100();
8314: x_qte_line_index := jtf_number_table();
8315: x_shipment_index := jtf_number_table();
8316: x_quote_header_id := jtf_number_table();
8317: x_quote_line_id := jtf_number_table();
8325: x_program_application_id := jtf_number_table();
8326: x_program_id := jtf_number_table();
8327: x_program_update_date := jtf_date_table();
8328: x_orig_tax_code := jtf_varchar2_table_300();
8329: x_tax_code := jtf_varchar2_table_100();
8330: x_tax_rate := jtf_number_table();
8331: x_tax_date := jtf_date_table();
8332: x_tax_amount := jtf_number_table();
8333: x_tax_exempt_flag := jtf_varchar2_table_100();
8329: x_tax_code := jtf_varchar2_table_100();
8330: x_tax_rate := jtf_number_table();
8331: x_tax_date := jtf_date_table();
8332: x_tax_amount := jtf_number_table();
8333: x_tax_exempt_flag := jtf_varchar2_table_100();
8334: x_tax_exempt_number := jtf_varchar2_table_100();
8335: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8336: x_attribute_category := jtf_varchar2_table_100();
8337: x_attribute1 := jtf_varchar2_table_200();
8330: x_tax_rate := jtf_number_table();
8331: x_tax_date := jtf_date_table();
8332: x_tax_amount := jtf_number_table();
8333: x_tax_exempt_flag := jtf_varchar2_table_100();
8334: x_tax_exempt_number := jtf_varchar2_table_100();
8335: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8336: x_attribute_category := jtf_varchar2_table_100();
8337: x_attribute1 := jtf_varchar2_table_200();
8338: x_attribute2 := jtf_varchar2_table_200();
8331: x_tax_date := jtf_date_table();
8332: x_tax_amount := jtf_number_table();
8333: x_tax_exempt_flag := jtf_varchar2_table_100();
8334: x_tax_exempt_number := jtf_varchar2_table_100();
8335: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8336: x_attribute_category := jtf_varchar2_table_100();
8337: x_attribute1 := jtf_varchar2_table_200();
8338: x_attribute2 := jtf_varchar2_table_200();
8339: x_attribute3 := jtf_varchar2_table_200();
8332: x_tax_amount := jtf_number_table();
8333: x_tax_exempt_flag := jtf_varchar2_table_100();
8334: x_tax_exempt_number := jtf_varchar2_table_100();
8335: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8336: x_attribute_category := jtf_varchar2_table_100();
8337: x_attribute1 := jtf_varchar2_table_200();
8338: x_attribute2 := jtf_varchar2_table_200();
8339: x_attribute3 := jtf_varchar2_table_200();
8340: x_attribute4 := jtf_varchar2_table_200();
8458: p_qte_price_adj_tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type,
8459: x_price_adjustment_id OUT NOCOPY jtf_number_table
8460:
8461: /*-- The following output parameters are ignored
8462: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
8463: x_qte_line_index OUT NOCOPY jtf_number_table,
8464: x_shipment_index OUT NOCOPY jtf_number_table,
8465: x_creation_date OUT NOCOPY jtf_date_table,
8466: x_created_by OUT NOCOPY jtf_number_table,
8475: x_quote_line_id OUT NOCOPY jtf_number_table,
8476: x_quote_shipment_id OUT NOCOPY jtf_number_table,
8477: x_modifier_header_id OUT NOCOPY jtf_number_table,
8478: x_modifier_line_id OUT NOCOPY jtf_number_table,
8479: x_modifier_line_type_code OUT NOCOPY jtf_varchar2_table_100,
8480: x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
8481: x_modified_from OUT NOCOPY jtf_number_table,
8482: x_modified_to OUT NOCOPY jtf_number_table,
8483: x_operand OUT NOCOPY jtf_number_table,
8476: x_quote_shipment_id OUT NOCOPY jtf_number_table,
8477: x_modifier_header_id OUT NOCOPY jtf_number_table,
8478: x_modifier_line_id OUT NOCOPY jtf_number_table,
8479: x_modifier_line_type_code OUT NOCOPY jtf_varchar2_table_100,
8480: x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
8481: x_modified_from OUT NOCOPY jtf_number_table,
8482: x_modified_to OUT NOCOPY jtf_number_table,
8483: x_operand OUT NOCOPY jtf_number_table,
8484: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
8480: x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
8481: x_modified_from OUT NOCOPY jtf_number_table,
8482: x_modified_to OUT NOCOPY jtf_number_table,
8483: x_operand OUT NOCOPY jtf_number_table,
8484: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
8485: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
8486: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
8487: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8488: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8481: x_modified_from OUT NOCOPY jtf_number_table,
8482: x_modified_to OUT NOCOPY jtf_number_table,
8483: x_operand OUT NOCOPY jtf_number_table,
8484: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
8485: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
8486: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
8487: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8488: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8489: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8482: x_modified_to OUT NOCOPY jtf_number_table,
8483: x_operand OUT NOCOPY jtf_number_table,
8484: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
8485: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
8486: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
8487: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8488: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8489: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8490: x_pricing_phase_id OUT NOCOPY jtf_number_table,
8483: x_operand OUT NOCOPY jtf_number_table,
8484: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
8485: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
8486: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
8487: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8488: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8489: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8490: x_pricing_phase_id OUT NOCOPY jtf_number_table,
8491: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8484: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
8485: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
8486: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
8487: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8488: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8489: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8490: x_pricing_phase_id OUT NOCOPY jtf_number_table,
8491: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8492: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8485: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
8486: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
8487: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8488: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8489: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8490: x_pricing_phase_id OUT NOCOPY jtf_number_table,
8491: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8492: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8493: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8487: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8488: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8489: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8490: x_pricing_phase_id OUT NOCOPY jtf_number_table,
8491: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8492: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8493: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8494: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8495: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
8503: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
8504: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
8505: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
8506: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
8507: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
8508: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
8509: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
8510: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
8511: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8504: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
8505: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
8506: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
8507: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
8508: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
8509: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
8510: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
8511: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8512: x_cost_id OUT NOCOPY jtf_number_table,
8505: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
8506: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
8507: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
8508: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
8509: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
8510: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
8511: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8512: x_cost_id OUT NOCOPY jtf_number_table,
8513: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8506: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
8507: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
8508: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
8509: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
8510: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
8511: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8512: x_cost_id OUT NOCOPY jtf_number_table,
8513: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8514: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8509: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
8510: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
8511: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8512: x_cost_id OUT NOCOPY jtf_number_table,
8513: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8514: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8515: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8516: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8517: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8510: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
8511: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8512: x_cost_id OUT NOCOPY jtf_number_table,
8513: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8514: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8515: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8516: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8517: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8518: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8511: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8512: x_cost_id OUT NOCOPY jtf_number_table,
8513: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8514: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8515: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8516: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8517: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8518: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8519: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8512: x_cost_id OUT NOCOPY jtf_number_table,
8513: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8514: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8515: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8516: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8517: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8518: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8519: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8520: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8514: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8515: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8516: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8517: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8518: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8519: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8520: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8521: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
8522: x_adjusted_amount OUT NOCOPY jtf_number_table,
8515: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8516: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8517: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8518: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8519: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8520: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8521: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
8522: x_adjusted_amount OUT NOCOPY jtf_number_table,
8523: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
8516: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8517: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8518: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8519: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8520: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8521: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
8522: x_adjusted_amount OUT NOCOPY jtf_number_table,
8523: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
8524: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
8517: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8518: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8519: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8520: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8521: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
8522: x_adjusted_amount OUT NOCOPY jtf_number_table,
8523: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
8524: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
8525: x_range_break_quantity OUT NOCOPY jtf_number_table,
8519: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8520: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8521: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
8522: x_adjusted_amount OUT NOCOPY jtf_number_table,
8523: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
8524: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
8525: x_range_break_quantity OUT NOCOPY jtf_number_table,
8526: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
8527: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
8520: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8521: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
8522: x_adjusted_amount OUT NOCOPY jtf_number_table,
8523: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
8524: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
8525: x_range_break_quantity OUT NOCOPY jtf_number_table,
8526: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
8527: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
8528: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
8524: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
8525: x_range_break_quantity OUT NOCOPY jtf_number_table,
8526: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
8527: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
8528: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
8529: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
8530: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
8531: x_benefit_qty OUT NOCOPY jtf_number_table,
8532: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8526: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
8527: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
8528: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
8529: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
8530: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
8531: x_benefit_qty OUT NOCOPY jtf_number_table,
8532: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8533: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8534: x_expiration_date OUT NOCOPY jtf_date_table,
8528: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
8529: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
8530: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
8531: x_benefit_qty OUT NOCOPY jtf_number_table,
8532: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8533: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8534: x_expiration_date OUT NOCOPY jtf_date_table,
8535: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8536: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8529: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
8530: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
8531: x_benefit_qty OUT NOCOPY jtf_number_table,
8532: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8533: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8534: x_expiration_date OUT NOCOPY jtf_date_table,
8535: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8536: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8537: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8531: x_benefit_qty OUT NOCOPY jtf_number_table,
8532: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8533: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8534: x_expiration_date OUT NOCOPY jtf_date_table,
8535: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8536: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8537: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8538: x_redeemed_date OUT NOCOPY jtf_date_table,
8539: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8532: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8533: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8534: x_expiration_date OUT NOCOPY jtf_date_table,
8535: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8536: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8537: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8538: x_redeemed_date OUT NOCOPY jtf_date_table,
8539: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8540: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8533: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8534: x_expiration_date OUT NOCOPY jtf_date_table,
8535: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8536: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8537: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8538: x_redeemed_date OUT NOCOPY jtf_date_table,
8539: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8540: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8541: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8535: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8536: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8537: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8538: x_redeemed_date OUT NOCOPY jtf_date_table,
8539: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8540: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8541: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8542: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8543: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8536: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8537: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8538: x_redeemed_date OUT NOCOPY jtf_date_table,
8539: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8540: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8541: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8542: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8543: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8544: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
8537: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8538: x_redeemed_date OUT NOCOPY jtf_date_table,
8539: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8540: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8541: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8542: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8543: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8544: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
8545: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
8538: x_redeemed_date OUT NOCOPY jtf_date_table,
8539: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8540: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8541: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8542: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8543: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8544: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
8545: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
8546: --*/
8539: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8540: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8541: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8542: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8543: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8544: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
8545: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
8546: --*/
8547: )
8540: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8541: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8542: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8543: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8544: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
8545: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
8546: --*/
8547: )
8548: AS
8541: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8542: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8543: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8544: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
8545: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
8546: --*/
8547: )
8548: AS
8549: ddindx binary_integer; indx binary_integer;
8550: BEGIN
8551: x_price_adjustment_id := jtf_number_table();
8552:
8553: /*-- The following output parameters are ignored
8554: x_operation_code := jtf_varchar2_table_100();
8555: x_qte_line_index := jtf_number_table();
8556: x_shipment_index := jtf_number_table();
8557: x_creation_date := jtf_date_table();
8558: x_created_by := jtf_number_table();
8567: x_quote_line_id := jtf_number_table();
8568: x_quote_shipment_id := jtf_number_table();
8569: x_modifier_header_id := jtf_number_table();
8570: x_modifier_line_id := jtf_number_table();
8571: x_modifier_line_type_code := jtf_varchar2_table_100();
8572: x_modifier_mechanism_type_code := jtf_varchar2_table_100();
8573: x_modified_from := jtf_number_table();
8574: x_modified_to := jtf_number_table();
8575: x_operand := jtf_number_table();
8568: x_quote_shipment_id := jtf_number_table();
8569: x_modifier_header_id := jtf_number_table();
8570: x_modifier_line_id := jtf_number_table();
8571: x_modifier_line_type_code := jtf_varchar2_table_100();
8572: x_modifier_mechanism_type_code := jtf_varchar2_table_100();
8573: x_modified_from := jtf_number_table();
8574: x_modified_to := jtf_number_table();
8575: x_operand := jtf_number_table();
8576: x_arithmetic_operator := jtf_varchar2_table_100();
8572: x_modifier_mechanism_type_code := jtf_varchar2_table_100();
8573: x_modified_from := jtf_number_table();
8574: x_modified_to := jtf_number_table();
8575: x_operand := jtf_number_table();
8576: x_arithmetic_operator := jtf_varchar2_table_100();
8577: x_automatic_flag := jtf_varchar2_table_100();
8578: x_update_allowable_flag := jtf_varchar2_table_100();
8579: x_updated_flag := jtf_varchar2_table_100();
8580: x_applied_flag := jtf_varchar2_table_100();
8573: x_modified_from := jtf_number_table();
8574: x_modified_to := jtf_number_table();
8575: x_operand := jtf_number_table();
8576: x_arithmetic_operator := jtf_varchar2_table_100();
8577: x_automatic_flag := jtf_varchar2_table_100();
8578: x_update_allowable_flag := jtf_varchar2_table_100();
8579: x_updated_flag := jtf_varchar2_table_100();
8580: x_applied_flag := jtf_varchar2_table_100();
8581: x_on_invoice_flag := jtf_varchar2_table_100();
8574: x_modified_to := jtf_number_table();
8575: x_operand := jtf_number_table();
8576: x_arithmetic_operator := jtf_varchar2_table_100();
8577: x_automatic_flag := jtf_varchar2_table_100();
8578: x_update_allowable_flag := jtf_varchar2_table_100();
8579: x_updated_flag := jtf_varchar2_table_100();
8580: x_applied_flag := jtf_varchar2_table_100();
8581: x_on_invoice_flag := jtf_varchar2_table_100();
8582: x_pricing_phase_id := jtf_number_table();
8575: x_operand := jtf_number_table();
8576: x_arithmetic_operator := jtf_varchar2_table_100();
8577: x_automatic_flag := jtf_varchar2_table_100();
8578: x_update_allowable_flag := jtf_varchar2_table_100();
8579: x_updated_flag := jtf_varchar2_table_100();
8580: x_applied_flag := jtf_varchar2_table_100();
8581: x_on_invoice_flag := jtf_varchar2_table_100();
8582: x_pricing_phase_id := jtf_number_table();
8583: x_attribute_category := jtf_varchar2_table_100();
8576: x_arithmetic_operator := jtf_varchar2_table_100();
8577: x_automatic_flag := jtf_varchar2_table_100();
8578: x_update_allowable_flag := jtf_varchar2_table_100();
8579: x_updated_flag := jtf_varchar2_table_100();
8580: x_applied_flag := jtf_varchar2_table_100();
8581: x_on_invoice_flag := jtf_varchar2_table_100();
8582: x_pricing_phase_id := jtf_number_table();
8583: x_attribute_category := jtf_varchar2_table_100();
8584: x_attribute1 := jtf_varchar2_table_200();
8577: x_automatic_flag := jtf_varchar2_table_100();
8578: x_update_allowable_flag := jtf_varchar2_table_100();
8579: x_updated_flag := jtf_varchar2_table_100();
8580: x_applied_flag := jtf_varchar2_table_100();
8581: x_on_invoice_flag := jtf_varchar2_table_100();
8582: x_pricing_phase_id := jtf_number_table();
8583: x_attribute_category := jtf_varchar2_table_100();
8584: x_attribute1 := jtf_varchar2_table_200();
8585: x_attribute2 := jtf_varchar2_table_200();
8579: x_updated_flag := jtf_varchar2_table_100();
8580: x_applied_flag := jtf_varchar2_table_100();
8581: x_on_invoice_flag := jtf_varchar2_table_100();
8582: x_pricing_phase_id := jtf_number_table();
8583: x_attribute_category := jtf_varchar2_table_100();
8584: x_attribute1 := jtf_varchar2_table_200();
8585: x_attribute2 := jtf_varchar2_table_200();
8586: x_attribute3 := jtf_varchar2_table_200();
8587: x_attribute4 := jtf_varchar2_table_200();
8595: x_attribute12 := jtf_varchar2_table_200();
8596: x_attribute13 := jtf_varchar2_table_200();
8597: x_attribute14 := jtf_varchar2_table_200();
8598: x_attribute15 := jtf_varchar2_table_200();
8599: x_orig_sys_discount_ref := jtf_varchar2_table_100();
8600: x_change_sequence := jtf_varchar2_table_100();
8601: x_update_allowed := jtf_varchar2_table_100();
8602: x_change_reason_code := jtf_varchar2_table_100();
8603: x_change_reason_text := jtf_varchar2_table_2000();
8596: x_attribute13 := jtf_varchar2_table_200();
8597: x_attribute14 := jtf_varchar2_table_200();
8598: x_attribute15 := jtf_varchar2_table_200();
8599: x_orig_sys_discount_ref := jtf_varchar2_table_100();
8600: x_change_sequence := jtf_varchar2_table_100();
8601: x_update_allowed := jtf_varchar2_table_100();
8602: x_change_reason_code := jtf_varchar2_table_100();
8603: x_change_reason_text := jtf_varchar2_table_2000();
8604: x_cost_id := jtf_number_table();
8597: x_attribute14 := jtf_varchar2_table_200();
8598: x_attribute15 := jtf_varchar2_table_200();
8599: x_orig_sys_discount_ref := jtf_varchar2_table_100();
8600: x_change_sequence := jtf_varchar2_table_100();
8601: x_update_allowed := jtf_varchar2_table_100();
8602: x_change_reason_code := jtf_varchar2_table_100();
8603: x_change_reason_text := jtf_varchar2_table_2000();
8604: x_cost_id := jtf_number_table();
8605: x_tax_code := jtf_varchar2_table_100();
8598: x_attribute15 := jtf_varchar2_table_200();
8599: x_orig_sys_discount_ref := jtf_varchar2_table_100();
8600: x_change_sequence := jtf_varchar2_table_100();
8601: x_update_allowed := jtf_varchar2_table_100();
8602: x_change_reason_code := jtf_varchar2_table_100();
8603: x_change_reason_text := jtf_varchar2_table_2000();
8604: x_cost_id := jtf_number_table();
8605: x_tax_code := jtf_varchar2_table_100();
8606: x_tax_exempt_flag := jtf_varchar2_table_100();
8601: x_update_allowed := jtf_varchar2_table_100();
8602: x_change_reason_code := jtf_varchar2_table_100();
8603: x_change_reason_text := jtf_varchar2_table_2000();
8604: x_cost_id := jtf_number_table();
8605: x_tax_code := jtf_varchar2_table_100();
8606: x_tax_exempt_flag := jtf_varchar2_table_100();
8607: x_tax_exempt_number := jtf_varchar2_table_100();
8608: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8609: x_parent_adjustment_id := jtf_number_table();
8602: x_change_reason_code := jtf_varchar2_table_100();
8603: x_change_reason_text := jtf_varchar2_table_2000();
8604: x_cost_id := jtf_number_table();
8605: x_tax_code := jtf_varchar2_table_100();
8606: x_tax_exempt_flag := jtf_varchar2_table_100();
8607: x_tax_exempt_number := jtf_varchar2_table_100();
8608: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8609: x_parent_adjustment_id := jtf_number_table();
8610: x_invoiced_flag := jtf_varchar2_table_100();
8603: x_change_reason_text := jtf_varchar2_table_2000();
8604: x_cost_id := jtf_number_table();
8605: x_tax_code := jtf_varchar2_table_100();
8606: x_tax_exempt_flag := jtf_varchar2_table_100();
8607: x_tax_exempt_number := jtf_varchar2_table_100();
8608: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8609: x_parent_adjustment_id := jtf_number_table();
8610: x_invoiced_flag := jtf_varchar2_table_100();
8611: x_estimated_flag := jtf_varchar2_table_100();
8604: x_cost_id := jtf_number_table();
8605: x_tax_code := jtf_varchar2_table_100();
8606: x_tax_exempt_flag := jtf_varchar2_table_100();
8607: x_tax_exempt_number := jtf_varchar2_table_100();
8608: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8609: x_parent_adjustment_id := jtf_number_table();
8610: x_invoiced_flag := jtf_varchar2_table_100();
8611: x_estimated_flag := jtf_varchar2_table_100();
8612: x_inc_in_sales_performance := jtf_varchar2_table_100();
8606: x_tax_exempt_flag := jtf_varchar2_table_100();
8607: x_tax_exempt_number := jtf_varchar2_table_100();
8608: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8609: x_parent_adjustment_id := jtf_number_table();
8610: x_invoiced_flag := jtf_varchar2_table_100();
8611: x_estimated_flag := jtf_varchar2_table_100();
8612: x_inc_in_sales_performance := jtf_varchar2_table_100();
8613: x_split_action_code := jtf_varchar2_table_100();
8614: x_adjusted_amount := jtf_number_table();
8607: x_tax_exempt_number := jtf_varchar2_table_100();
8608: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8609: x_parent_adjustment_id := jtf_number_table();
8610: x_invoiced_flag := jtf_varchar2_table_100();
8611: x_estimated_flag := jtf_varchar2_table_100();
8612: x_inc_in_sales_performance := jtf_varchar2_table_100();
8613: x_split_action_code := jtf_varchar2_table_100();
8614: x_adjusted_amount := jtf_number_table();
8615: x_charge_type_code := jtf_varchar2_table_100();
8608: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8609: x_parent_adjustment_id := jtf_number_table();
8610: x_invoiced_flag := jtf_varchar2_table_100();
8611: x_estimated_flag := jtf_varchar2_table_100();
8612: x_inc_in_sales_performance := jtf_varchar2_table_100();
8613: x_split_action_code := jtf_varchar2_table_100();
8614: x_adjusted_amount := jtf_number_table();
8615: x_charge_type_code := jtf_varchar2_table_100();
8616: x_charge_subtype_code := jtf_varchar2_table_100();
8609: x_parent_adjustment_id := jtf_number_table();
8610: x_invoiced_flag := jtf_varchar2_table_100();
8611: x_estimated_flag := jtf_varchar2_table_100();
8612: x_inc_in_sales_performance := jtf_varchar2_table_100();
8613: x_split_action_code := jtf_varchar2_table_100();
8614: x_adjusted_amount := jtf_number_table();
8615: x_charge_type_code := jtf_varchar2_table_100();
8616: x_charge_subtype_code := jtf_varchar2_table_100();
8617: x_range_break_quantity := jtf_number_table();
8611: x_estimated_flag := jtf_varchar2_table_100();
8612: x_inc_in_sales_performance := jtf_varchar2_table_100();
8613: x_split_action_code := jtf_varchar2_table_100();
8614: x_adjusted_amount := jtf_number_table();
8615: x_charge_type_code := jtf_varchar2_table_100();
8616: x_charge_subtype_code := jtf_varchar2_table_100();
8617: x_range_break_quantity := jtf_number_table();
8618: x_accrual_conversion_rate := jtf_number_table();
8619: x_pricing_group_sequence := jtf_number_table();
8612: x_inc_in_sales_performance := jtf_varchar2_table_100();
8613: x_split_action_code := jtf_varchar2_table_100();
8614: x_adjusted_amount := jtf_number_table();
8615: x_charge_type_code := jtf_varchar2_table_100();
8616: x_charge_subtype_code := jtf_varchar2_table_100();
8617: x_range_break_quantity := jtf_number_table();
8618: x_accrual_conversion_rate := jtf_number_table();
8619: x_pricing_group_sequence := jtf_number_table();
8620: x_accrual_flag := jtf_varchar2_table_100();
8616: x_charge_subtype_code := jtf_varchar2_table_100();
8617: x_range_break_quantity := jtf_number_table();
8618: x_accrual_conversion_rate := jtf_number_table();
8619: x_pricing_group_sequence := jtf_number_table();
8620: x_accrual_flag := jtf_varchar2_table_100();
8621: x_list_line_no := jtf_varchar2_table_300();
8622: x_source_system_code := jtf_varchar2_table_100();
8623: x_benefit_qty := jtf_number_table();
8624: x_benefit_uom_code := jtf_varchar2_table_100();
8618: x_accrual_conversion_rate := jtf_number_table();
8619: x_pricing_group_sequence := jtf_number_table();
8620: x_accrual_flag := jtf_varchar2_table_100();
8621: x_list_line_no := jtf_varchar2_table_300();
8622: x_source_system_code := jtf_varchar2_table_100();
8623: x_benefit_qty := jtf_number_table();
8624: x_benefit_uom_code := jtf_varchar2_table_100();
8625: x_print_on_invoice_flag := jtf_varchar2_table_100();
8626: x_expiration_date := jtf_date_table();
8620: x_accrual_flag := jtf_varchar2_table_100();
8621: x_list_line_no := jtf_varchar2_table_300();
8622: x_source_system_code := jtf_varchar2_table_100();
8623: x_benefit_qty := jtf_number_table();
8624: x_benefit_uom_code := jtf_varchar2_table_100();
8625: x_print_on_invoice_flag := jtf_varchar2_table_100();
8626: x_expiration_date := jtf_date_table();
8627: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8628: x_rebate_transaction_reference := jtf_varchar2_table_100();
8621: x_list_line_no := jtf_varchar2_table_300();
8622: x_source_system_code := jtf_varchar2_table_100();
8623: x_benefit_qty := jtf_number_table();
8624: x_benefit_uom_code := jtf_varchar2_table_100();
8625: x_print_on_invoice_flag := jtf_varchar2_table_100();
8626: x_expiration_date := jtf_date_table();
8627: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8628: x_rebate_transaction_reference := jtf_varchar2_table_100();
8629: x_rebate_payment_system_code := jtf_varchar2_table_100();
8623: x_benefit_qty := jtf_number_table();
8624: x_benefit_uom_code := jtf_varchar2_table_100();
8625: x_print_on_invoice_flag := jtf_varchar2_table_100();
8626: x_expiration_date := jtf_date_table();
8627: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8628: x_rebate_transaction_reference := jtf_varchar2_table_100();
8629: x_rebate_payment_system_code := jtf_varchar2_table_100();
8630: x_redeemed_date := jtf_date_table();
8631: x_redeemed_flag := jtf_varchar2_table_100();
8624: x_benefit_uom_code := jtf_varchar2_table_100();
8625: x_print_on_invoice_flag := jtf_varchar2_table_100();
8626: x_expiration_date := jtf_date_table();
8627: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8628: x_rebate_transaction_reference := jtf_varchar2_table_100();
8629: x_rebate_payment_system_code := jtf_varchar2_table_100();
8630: x_redeemed_date := jtf_date_table();
8631: x_redeemed_flag := jtf_varchar2_table_100();
8632: x_modifier_level_code := jtf_varchar2_table_100();
8625: x_print_on_invoice_flag := jtf_varchar2_table_100();
8626: x_expiration_date := jtf_date_table();
8627: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8628: x_rebate_transaction_reference := jtf_varchar2_table_100();
8629: x_rebate_payment_system_code := jtf_varchar2_table_100();
8630: x_redeemed_date := jtf_date_table();
8631: x_redeemed_flag := jtf_varchar2_table_100();
8632: x_modifier_level_code := jtf_varchar2_table_100();
8633: x_price_break_type_code := jtf_varchar2_table_100();
8627: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8628: x_rebate_transaction_reference := jtf_varchar2_table_100();
8629: x_rebate_payment_system_code := jtf_varchar2_table_100();
8630: x_redeemed_date := jtf_date_table();
8631: x_redeemed_flag := jtf_varchar2_table_100();
8632: x_modifier_level_code := jtf_varchar2_table_100();
8633: x_price_break_type_code := jtf_varchar2_table_100();
8634: x_substitution_attribute := jtf_varchar2_table_100();
8635: x_proration_type_code := jtf_varchar2_table_100();
8628: x_rebate_transaction_reference := jtf_varchar2_table_100();
8629: x_rebate_payment_system_code := jtf_varchar2_table_100();
8630: x_redeemed_date := jtf_date_table();
8631: x_redeemed_flag := jtf_varchar2_table_100();
8632: x_modifier_level_code := jtf_varchar2_table_100();
8633: x_price_break_type_code := jtf_varchar2_table_100();
8634: x_substitution_attribute := jtf_varchar2_table_100();
8635: x_proration_type_code := jtf_varchar2_table_100();
8636: x_include_on_returns_flag := jtf_varchar2_table_100();
8629: x_rebate_payment_system_code := jtf_varchar2_table_100();
8630: x_redeemed_date := jtf_date_table();
8631: x_redeemed_flag := jtf_varchar2_table_100();
8632: x_modifier_level_code := jtf_varchar2_table_100();
8633: x_price_break_type_code := jtf_varchar2_table_100();
8634: x_substitution_attribute := jtf_varchar2_table_100();
8635: x_proration_type_code := jtf_varchar2_table_100();
8636: x_include_on_returns_flag := jtf_varchar2_table_100();
8637: x_credit_or_charge_flag := jtf_varchar2_table_100();
8630: x_redeemed_date := jtf_date_table();
8631: x_redeemed_flag := jtf_varchar2_table_100();
8632: x_modifier_level_code := jtf_varchar2_table_100();
8633: x_price_break_type_code := jtf_varchar2_table_100();
8634: x_substitution_attribute := jtf_varchar2_table_100();
8635: x_proration_type_code := jtf_varchar2_table_100();
8636: x_include_on_returns_flag := jtf_varchar2_table_100();
8637: x_credit_or_charge_flag := jtf_varchar2_table_100();
8638: --*/
8631: x_redeemed_flag := jtf_varchar2_table_100();
8632: x_modifier_level_code := jtf_varchar2_table_100();
8633: x_price_break_type_code := jtf_varchar2_table_100();
8634: x_substitution_attribute := jtf_varchar2_table_100();
8635: x_proration_type_code := jtf_varchar2_table_100();
8636: x_include_on_returns_flag := jtf_varchar2_table_100();
8637: x_credit_or_charge_flag := jtf_varchar2_table_100();
8638: --*/
8639:
8632: x_modifier_level_code := jtf_varchar2_table_100();
8633: x_price_break_type_code := jtf_varchar2_table_100();
8634: x_substitution_attribute := jtf_varchar2_table_100();
8635: x_proration_type_code := jtf_varchar2_table_100();
8636: x_include_on_returns_flag := jtf_varchar2_table_100();
8637: x_credit_or_charge_flag := jtf_varchar2_table_100();
8638: --*/
8639:
8640: IF p_qte_price_adj_tbl.count > 0 THEN
8633: x_price_break_type_code := jtf_varchar2_table_100();
8634: x_substitution_attribute := jtf_varchar2_table_100();
8635: x_proration_type_code := jtf_varchar2_table_100();
8636: x_include_on_returns_flag := jtf_varchar2_table_100();
8637: x_credit_or_charge_flag := jtf_varchar2_table_100();
8638: --*/
8639:
8640: IF p_qte_price_adj_tbl.count > 0 THEN
8641: x_price_adjustment_id.extend(p_qte_price_adj_tbl.count);
8834: p_qte_price_attributes_tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type,
8835: x_price_attribute_id OUT NOCOPY jtf_number_table
8836:
8837: /*-- The following output parameters are ignored
8838: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
8839: x_qte_line_index OUT NOCOPY jtf_number_table,
8840: x_creation_date OUT NOCOPY jtf_date_table,
8841: x_created_by OUT NOCOPY jtf_number_table,
8842: x_last_update_date OUT NOCOPY jtf_date_table,
8847: x_program_id OUT NOCOPY jtf_number_table,
8848: x_program_update_date OUT NOCOPY jtf_date_table,
8849: x_quote_header_id OUT NOCOPY jtf_number_table,
8850: x_quote_line_id OUT NOCOPY jtf_number_table,
8851: x_flex_title OUT NOCOPY jtf_varchar2_table_100,
8852: x_pricing_context OUT NOCOPY jtf_varchar2_table_100,
8853: x_pricing_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8854: x_pricing_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8855: x_pricing_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8848: x_program_update_date OUT NOCOPY jtf_date_table,
8849: x_quote_header_id OUT NOCOPY jtf_number_table,
8850: x_quote_line_id OUT NOCOPY jtf_number_table,
8851: x_flex_title OUT NOCOPY jtf_varchar2_table_100,
8852: x_pricing_context OUT NOCOPY jtf_varchar2_table_100,
8853: x_pricing_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8854: x_pricing_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8855: x_pricing_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8856: x_pricing_attribute4 OUT NOCOPY jtf_varchar2_table_200,
8949: x_pricing_attribute97 OUT NOCOPY jtf_varchar2_table_200,
8950: x_pricing_attribute98 OUT NOCOPY jtf_varchar2_table_200,
8951: x_pricing_attribute99 OUT NOCOPY jtf_varchar2_table_200,
8952: x_pricing_attribute100 OUT NOCOPY jtf_varchar2_table_200,
8953: x_context OUT NOCOPY jtf_varchar2_table_100,
8954: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8955: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8956: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8957: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
8973: BEGIN
8974: x_price_attribute_id := jtf_number_table();
8975:
8976: /*-- The following output parameters are ignored
8977: x_operation_code := jtf_varchar2_table_100();
8978: x_qte_line_index := jtf_number_table();
8979: x_creation_date := jtf_date_table();
8980: x_created_by := jtf_number_table();
8981: x_last_update_date := jtf_date_table();
8986: x_program_id := jtf_number_table();
8987: x_program_update_date := jtf_date_table();
8988: x_quote_header_id := jtf_number_table();
8989: x_quote_line_id := jtf_number_table();
8990: x_flex_title := jtf_varchar2_table_100();
8991: x_pricing_context := jtf_varchar2_table_100();
8992: x_pricing_attribute1 := jtf_varchar2_table_200();
8993: x_pricing_attribute2 := jtf_varchar2_table_200();
8994: x_pricing_attribute3 := jtf_varchar2_table_200();
8987: x_program_update_date := jtf_date_table();
8988: x_quote_header_id := jtf_number_table();
8989: x_quote_line_id := jtf_number_table();
8990: x_flex_title := jtf_varchar2_table_100();
8991: x_pricing_context := jtf_varchar2_table_100();
8992: x_pricing_attribute1 := jtf_varchar2_table_200();
8993: x_pricing_attribute2 := jtf_varchar2_table_200();
8994: x_pricing_attribute3 := jtf_varchar2_table_200();
8995: x_pricing_attribute4 := jtf_varchar2_table_200();
9088: x_pricing_attribute97 := jtf_varchar2_table_200();
9089: x_pricing_attribute98 := jtf_varchar2_table_200();
9090: x_pricing_attribute99 := jtf_varchar2_table_200();
9091: x_pricing_attribute100 := jtf_varchar2_table_200();
9092: x_context := jtf_varchar2_table_100();
9093: x_attribute1 := jtf_varchar2_table_200();
9094: x_attribute2 := jtf_varchar2_table_200();
9095: x_attribute3 := jtf_varchar2_table_200();
9096: x_attribute4 := jtf_varchar2_table_200();
9399: x_sales_credit_id OUT NOCOPY jtf_number_table
9400:
9401: /*-- The following output parameters are ignored
9402: x_qte_line_index OUT NOCOPY jtf_number_table,
9403: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
9404: x_creation_date OUT NOCOPY jtf_date_table,
9405: x_created_by OUT NOCOPY jtf_number_table,
9406: x_last_updated_by OUT NOCOPY jtf_number_table,
9407: x_last_update_date OUT NOCOPY jtf_date_table,
9419: x_sales_credit_type OUT NOCOPY jtf_varchar2_table_300,
9420: x_resource_group_id OUT NOCOPY jtf_number_table,
9421: x_employee_person_id OUT NOCOPY jtf_number_table,
9422: x_sales_credit_type_id OUT NOCOPY jtf_number_table,
9423: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
9424: x_attribute1 OUT NOCOPY jtf_varchar2_table_300,
9425: x_attribute2 OUT NOCOPY jtf_varchar2_table_300,
9426: x_attribute3 OUT NOCOPY jtf_varchar2_table_300,
9427: x_attribute4 OUT NOCOPY jtf_varchar2_table_300,
9444: x_sales_credit_id := jtf_number_table();
9445:
9446: /*-- The following output parameters are ignored
9447: x_qte_line_index := jtf_number_table();
9448: x_operation_code := jtf_varchar2_table_100();
9449: x_creation_date := jtf_date_table();
9450: x_created_by := jtf_number_table();
9451: x_last_updated_by := jtf_number_table();
9452: x_last_update_date := jtf_date_table();
9464: x_sales_credit_type := jtf_varchar2_table_300();
9465: x_resource_group_id := jtf_number_table();
9466: x_employee_person_id := jtf_number_table();
9467: x_sales_credit_type_id := jtf_number_table();
9468: x_attribute_category := jtf_varchar2_table_100();
9469: x_attribute1 := jtf_varchar2_table_300();
9470: x_attribute2 := jtf_varchar2_table_300();
9471: x_attribute3 := jtf_varchar2_table_300();
9472: x_attribute4 := jtf_varchar2_table_300();
9588: x_approver_person_id OUT NOCOPY jtf_number_table,
9589: x_approver_user_id OUT NOCOPY jtf_number_table,
9590: x_notification_id OUT NOCOPY jtf_number_table,
9591: x_approver_sequence OUT NOCOPY jtf_number_table,
9592: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
9593: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
9594: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
9595: x_date_sent OUT NOCOPY jtf_date_table,
9596: x_date_received OUT NOCOPY jtf_date_table
9589: x_approver_user_id OUT NOCOPY jtf_number_table,
9590: x_notification_id OUT NOCOPY jtf_number_table,
9591: x_approver_sequence OUT NOCOPY jtf_number_table,
9592: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
9593: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
9594: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
9595: x_date_sent OUT NOCOPY jtf_date_table,
9596: x_date_received OUT NOCOPY jtf_date_table
9597: )
9603: x_approver_person_id := jtf_number_table();
9604: x_approver_user_id := jtf_number_table();
9605: x_notification_id := jtf_number_table();
9606: x_approver_sequence := jtf_number_table();
9607: x_approver_status := jtf_varchar2_table_100();
9608: x_approver_name := jtf_varchar2_table_100();
9609: x_approval_comments := jtf_varchar2_table_300();
9610: x_date_sent := jtf_date_table();
9611: x_date_received := jtf_date_table();
9604: x_approver_user_id := jtf_number_table();
9605: x_notification_id := jtf_number_table();
9606: x_approver_sequence := jtf_number_table();
9607: x_approver_status := jtf_varchar2_table_100();
9608: x_approver_name := jtf_varchar2_table_100();
9609: x_approval_comments := jtf_varchar2_table_300();
9610: x_date_sent := jtf_date_table();
9611: x_date_received := jtf_date_table();
9612: IF p_qte_approvers_list_tbl.count > 0 THEN
9768: x_identifier OUT NOCOPY JTF_NUMBER_TABLE,
9769: x_customer_id OUT NOCOPY JTF_NUMBER_TABLE,
9770: x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
9771: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
9772: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9773: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9774: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
9775: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
9776: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9769: x_customer_id OUT NOCOPY JTF_NUMBER_TABLE,
9770: x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
9771: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
9772: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9773: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9774: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
9775: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
9776: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9777: x_request_date_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9823: x_identifier := JTF_NUMBER_TABLE();
9824: x_customer_id := JTF_NUMBER_TABLE();
9825: x_customer_site_id := JTF_NUMBER_TABLE();
9826: x_quantity_ordered := JTF_NUMBER_TABLE();
9827: x_quantity_uom := JTF_VARCHAR2_TABLE_100();
9828: x_uom_meaning := JTF_VARCHAR2_TABLE_100();
9829: x_requested_ship_date := JTF_DATE_TABLE();
9830: x_ship_date := JTF_DATE_TABLE();
9831: x_available_quantity := JTF_NUMBER_TABLE();
9824: x_customer_id := JTF_NUMBER_TABLE();
9825: x_customer_site_id := JTF_NUMBER_TABLE();
9826: x_quantity_ordered := JTF_NUMBER_TABLE();
9827: x_quantity_uom := JTF_VARCHAR2_TABLE_100();
9828: x_uom_meaning := JTF_VARCHAR2_TABLE_100();
9829: x_requested_ship_date := JTF_DATE_TABLE();
9830: x_ship_date := JTF_DATE_TABLE();
9831: x_available_quantity := JTF_NUMBER_TABLE();
9832: x_request_date_quantity := JTF_NUMBER_TABLE();
10093:
10094:
10095:
10096: FUNCTION Construct_Trigger_Attr_Tbl(
10097: p_trigger_attribute IN jtf_varchar2_table_100 := NULL
10098: )
10099: RETURN ASO_Defaulting_Int.Attribute_Codes_Tbl_Type
10100: IS
10101: l_trigger_attr_tbl ASO_Defaulting_Int.ATTRIBUTE_CODES_TBL_TYPE;
10998:
10999: PROCEDURE Set_Config_Valid_Table_Out(
11000: p_config_table IN ASO_QUOTE_PUB.Config_Vaild_Tbl_Type,
11001: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
11002: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
11003: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
11004: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
11005: )
11006: IS
10999: PROCEDURE Set_Config_Valid_Table_Out(
11000: p_config_table IN ASO_QUOTE_PUB.Config_Vaild_Tbl_Type,
11001: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
11002: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
11003: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
11004: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
11005: )
11006: IS
11007: ddindx binary_integer;
11000: p_config_table IN ASO_QUOTE_PUB.Config_Vaild_Tbl_Type,
11001: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
11002: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
11003: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
11004: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
11005: )
11006: IS
11007: ddindx binary_integer;
11008: indx binary_integer;
11007: ddindx binary_integer;
11008: indx binary_integer;
11009: BEGIN
11010: x_quote_line_id:= jtf_number_table();
11011: x_changed_flag := jtf_varchar2_table_100();
11012: x_valid_flag := jtf_varchar2_table_100();
11013: x_complete_flag := jtf_varchar2_table_100();
11014:
11015: IF p_config_table.count > 0 THEN
11008: indx binary_integer;
11009: BEGIN
11010: x_quote_line_id:= jtf_number_table();
11011: x_changed_flag := jtf_varchar2_table_100();
11012: x_valid_flag := jtf_varchar2_table_100();
11013: x_complete_flag := jtf_varchar2_table_100();
11014:
11015: IF p_config_table.count > 0 THEN
11016: x_quote_line_id.extend(p_config_table.count);
11009: BEGIN
11010: x_quote_line_id:= jtf_number_table();
11011: x_changed_flag := jtf_varchar2_table_100();
11012: x_valid_flag := jtf_varchar2_table_100();
11013: x_complete_flag := jtf_varchar2_table_100();
11014:
11015: IF p_config_table.count > 0 THEN
11016: x_quote_line_id.extend(p_config_table.count);
11017: x_changed_flag.extend(p_config_table.count);
11065:
11066: END Set_num_Tbl_Out;
11067:
11068: FUNCTION Construct_Related_Obj_Tbl(
11069: p_operation_code IN jtf_varchar2_table_100 := NULL,
11070: p_RELATED_OBJECT_ID IN jtf_number_table := NULL,
11071: p_CREATION_DATE IN jtf_date_table := null,
11072: p_CREATED_BY IN jtf_number_table := NULL,
11073: p_LAST_UPDATE_DATE IN jtf_date_table := null,
11081: p_QUOTE_OBJECT_ID IN jtf_number_table := NULL,
11082: p_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
11083: p_OBJECT_ID IN jtf_number_table := NULL,
11084: p_RELATIONSHIP_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
11085: p_RECIPROCAL_FLAG IN jtf_varchar2_table_100 := NULL,
11086: p_QUOTE_OBJECT_CODE IN jtf_number_table := NULL,
11087: p_OBJECT_VERSION_NUMBER IN jtf_number_table := NULL
11088: )
11089: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type