[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;
6565: x_program_application_id OUT NOCOPY jtf_number_table,
6566: x_program_id OUT NOCOPY jtf_number_table,
6567: x_program_update_date OUT NOCOPY jtf_date_table,
6568: x_org_id OUT NOCOPY jtf_number_table,
6569: x_quote_name OUT NOCOPY jtf_varchar2_table_100,
6570: x_quote_number OUT NOCOPY jtf_number_table,
6571: x_quote_version OUT NOCOPY jtf_number_table,
6572: x_quote_status_id OUT NOCOPY jtf_number_table,
6573: x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
6590: x_accounting_rule_id OUT NOCOPY jtf_number_table,
6591: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
6592: x_employee_person_id OUT NOCOPY jtf_number_table,
6593: x_price_list_id OUT NOCOPY jtf_number_table,
6594: x_currency_code OUT NOCOPY jtf_varchar2_table_100,
6595: x_total_list_price OUT NOCOPY jtf_number_table,
6596: x_total_adjusted_amount OUT NOCOPY jtf_number_table,
6597: x_total_adjusted_percent OUT NOCOPY jtf_number_table,
6598: x_total_tax OUT NOCOPY jtf_number_table,
6600: x_surcharge OUT NOCOPY jtf_number_table,
6601: x_total_quote_price OUT NOCOPY jtf_number_table,
6602: x_payment_amount OUT NOCOPY jtf_number_table,
6603: x_exchange_rate OUT NOCOPY jtf_number_table,
6604: x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
6605: x_exchange_rate_date OUT NOCOPY jtf_date_table,
6606: x_contract_id OUT NOCOPY jtf_number_table,
6607: x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
6608: x_order_id OUT NOCOPY jtf_number_table,
6603: x_exchange_rate OUT NOCOPY jtf_number_table,
6604: x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
6605: x_exchange_rate_date OUT NOCOPY jtf_date_table,
6606: x_contract_id OUT NOCOPY jtf_number_table,
6607: x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
6608: x_order_id OUT NOCOPY jtf_number_table,
6609: x_order_number OUT NOCOPY jtf_number_table,
6610: x_ffm_request_id OUT NOCOPY jtf_number_table,
6611: x_qte_contract_id OUT NOCOPY jtf_number_table,
6608: x_order_id OUT NOCOPY jtf_number_table,
6609: x_order_number OUT NOCOPY jtf_number_table,
6610: x_ffm_request_id OUT NOCOPY jtf_number_table,
6611: x_qte_contract_id OUT NOCOPY jtf_number_table,
6612: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
6613: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
6614: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
6615: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
6616: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
6627: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
6628: x_salesrep_first_name OUT NOCOPY jtf_varchar2_table_300,
6629: x_salesrep_last_name OUT NOCOPY jtf_varchar2_table_300,
6630: x_price_list_name OUT NOCOPY jtf_varchar2_table_300,
6631: x_quote_status_code OUT NOCOPY jtf_varchar2_table_100,
6632: x_quote_status OUT NOCOPY jtf_varchar2_table_300,
6633: x_party_name OUT NOCOPY jtf_varchar2_table_300,
6634: x_party_type OUT NOCOPY jtf_varchar2_table_100,
6635: x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
6630: x_price_list_name OUT NOCOPY jtf_varchar2_table_300,
6631: x_quote_status_code OUT NOCOPY jtf_varchar2_table_100,
6632: x_quote_status OUT NOCOPY jtf_varchar2_table_300,
6633: x_party_name OUT NOCOPY jtf_varchar2_table_300,
6634: x_party_type OUT NOCOPY jtf_varchar2_table_100,
6635: x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
6636: x_person_middle_name OUT NOCOPY jtf_varchar2_table_100,
6637: x_person_last_name OUT NOCOPY jtf_varchar2_table_200,
6638: x_marketing_source_name OUT NOCOPY jtf_varchar2_table_200,
6632: x_quote_status OUT NOCOPY jtf_varchar2_table_300,
6633: x_party_name OUT NOCOPY jtf_varchar2_table_300,
6634: x_party_type OUT NOCOPY jtf_varchar2_table_100,
6635: x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
6636: x_person_middle_name OUT NOCOPY jtf_varchar2_table_100,
6637: x_person_last_name OUT NOCOPY jtf_varchar2_table_200,
6638: x_marketing_source_name OUT NOCOPY jtf_varchar2_table_200,
6639: x_marketing_source_code OUT NOCOPY jtf_varchar2_table_200,
6640: x_order_type_name OUT NOCOPY jtf_varchar2_table_300,
6639: x_marketing_source_code OUT NOCOPY jtf_varchar2_table_200,
6640: x_order_type_name OUT NOCOPY jtf_varchar2_table_300,
6641: x_invoice_to_party_name OUT NOCOPY jtf_varchar2_table_300,
6642: x_invoice_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
6643: x_invoice_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
6644: x_invoice_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
6645: x_invoice_to_address1 OUT NOCOPY jtf_varchar2_table_300,
6646: x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
6647: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
6645: x_invoice_to_address1 OUT NOCOPY jtf_varchar2_table_300,
6646: x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
6647: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
6648: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
6649: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
6650: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
6651: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6652: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6653: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6646: x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
6647: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
6648: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
6649: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
6650: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
6651: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6652: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6653: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6654: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
6647: x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
6648: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
6649: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
6650: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
6651: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6652: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6653: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6654: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
6655: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
6648: x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
6649: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
6650: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
6651: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6652: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6653: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6654: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
6655: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
6656: x_resource_id OUT NOCOPY jtf_number_table
6649: x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
6650: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
6651: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6652: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6653: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6654: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
6655: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
6656: x_resource_id OUT NOCOPY jtf_number_table
6657: --*/
6650: x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
6651: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6652: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6653: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6654: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
6655: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
6656: x_resource_id OUT NOCOPY jtf_number_table
6657: --*/
6658: )
6651: x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
6652: x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
6653: x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
6654: x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
6655: x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
6656: x_resource_id OUT NOCOPY jtf_number_table
6657: --*/
6658: )
6659: AS
6671: x_program_application_id := jtf_number_table();
6672: x_program_id := jtf_number_table();
6673: x_program_update_date := jtf_date_table();
6674: x_org_id := jtf_number_table();
6675: x_quote_name := jtf_varchar2_table_100();
6676: x_quote_number := jtf_number_table();
6677: x_quote_version := jtf_number_table();
6678: x_quote_status_id := jtf_number_table();
6679: x_quote_source_code := jtf_varchar2_table_300();
6696: x_accounting_rule_id := jtf_number_table();
6697: x_invoicing_rule_id := jtf_number_table();
6698: x_employee_person_id := jtf_number_table();
6699: x_price_list_id := jtf_number_table();
6700: x_currency_code := jtf_varchar2_table_100();
6701: x_total_list_price := jtf_number_table();
6702: x_total_adjusted_amount := jtf_number_table();
6703: x_total_adjusted_percent := jtf_number_table();
6704: x_total_tax := jtf_number_table();
6706: x_surcharge := jtf_number_table();
6707: x_total_quote_price := jtf_number_table();
6708: x_payment_amount := jtf_number_table();
6709: x_exchange_rate := jtf_number_table();
6710: x_exchange_type_code := jtf_varchar2_table_100();
6711: x_exchange_rate_date := jtf_date_table();
6712: x_contract_id := jtf_number_table();
6713: x_sales_channel_code := jtf_varchar2_table_100();
6714: x_order_id := jtf_number_table();
6709: x_exchange_rate := jtf_number_table();
6710: x_exchange_type_code := jtf_varchar2_table_100();
6711: x_exchange_rate_date := jtf_date_table();
6712: x_contract_id := jtf_number_table();
6713: x_sales_channel_code := jtf_varchar2_table_100();
6714: x_order_id := jtf_number_table();
6715: x_order_number := jtf_number_table();
6716: x_ffm_request_id := jtf_number_table();
6717: x_qte_contract_id := jtf_number_table();
6714: x_order_id := jtf_number_table();
6715: x_order_number := jtf_number_table();
6716: x_ffm_request_id := jtf_number_table();
6717: x_qte_contract_id := jtf_number_table();
6718: x_attribute_category := jtf_varchar2_table_100();
6719: x_attribute1 := jtf_varchar2_table_200();
6720: x_attribute2 := jtf_varchar2_table_200();
6721: x_attribute3 := jtf_varchar2_table_200();
6722: x_attribute4 := jtf_varchar2_table_200();
6733: x_attribute15 := jtf_varchar2_table_200();
6734: x_salesrep_first_name := jtf_varchar2_table_300();
6735: x_salesrep_last_name := jtf_varchar2_table_300();
6736: x_price_list_name := jtf_varchar2_table_300();
6737: x_quote_status_code := jtf_varchar2_table_100();
6738: x_quote_status := jtf_varchar2_table_300();
6739: x_party_name := jtf_varchar2_table_300();
6740: x_party_type := jtf_varchar2_table_100();
6741: x_person_first_name := jtf_varchar2_table_200();
6736: x_price_list_name := jtf_varchar2_table_300();
6737: x_quote_status_code := jtf_varchar2_table_100();
6738: x_quote_status := jtf_varchar2_table_300();
6739: x_party_name := jtf_varchar2_table_300();
6740: x_party_type := jtf_varchar2_table_100();
6741: x_person_first_name := jtf_varchar2_table_200();
6742: x_person_middle_name := jtf_varchar2_table_100();
6743: x_person_last_name := jtf_varchar2_table_200();
6744: x_marketing_source_name := jtf_varchar2_table_200();
6738: x_quote_status := jtf_varchar2_table_300();
6739: x_party_name := jtf_varchar2_table_300();
6740: x_party_type := jtf_varchar2_table_100();
6741: x_person_first_name := jtf_varchar2_table_200();
6742: x_person_middle_name := jtf_varchar2_table_100();
6743: x_person_last_name := jtf_varchar2_table_200();
6744: x_marketing_source_name := jtf_varchar2_table_200();
6745: x_marketing_source_code := jtf_varchar2_table_200();
6746: x_order_type_name := jtf_varchar2_table_300();
6745: x_marketing_source_code := jtf_varchar2_table_200();
6746: x_order_type_name := jtf_varchar2_table_300();
6747: x_invoice_to_party_name := jtf_varchar2_table_300();
6748: x_invoice_to_cont_first_name := jtf_varchar2_table_200();
6749: x_invoice_to_cont_mid_name := jtf_varchar2_table_100();
6750: x_invoice_to_cont_last_name := jtf_varchar2_table_200();
6751: x_invoice_to_address1 := jtf_varchar2_table_300();
6752: x_invoice_to_address2 := jtf_varchar2_table_300();
6753: x_invoice_to_address3 := jtf_varchar2_table_300();
6751: x_invoice_to_address1 := jtf_varchar2_table_300();
6752: x_invoice_to_address2 := jtf_varchar2_table_300();
6753: x_invoice_to_address3 := jtf_varchar2_table_300();
6754: x_invoice_to_address4 := jtf_varchar2_table_300();
6755: x_invoice_to_country_code := jtf_varchar2_table_100();
6756: x_invoice_to_country := jtf_varchar2_table_100();
6757: x_invoice_to_city := jtf_varchar2_table_100();
6758: x_invoice_to_postal_code := jtf_varchar2_table_100();
6759: x_invoice_to_state := jtf_varchar2_table_100();
6752: x_invoice_to_address2 := jtf_varchar2_table_300();
6753: x_invoice_to_address3 := jtf_varchar2_table_300();
6754: x_invoice_to_address4 := jtf_varchar2_table_300();
6755: x_invoice_to_country_code := jtf_varchar2_table_100();
6756: x_invoice_to_country := jtf_varchar2_table_100();
6757: x_invoice_to_city := jtf_varchar2_table_100();
6758: x_invoice_to_postal_code := jtf_varchar2_table_100();
6759: x_invoice_to_state := jtf_varchar2_table_100();
6760: x_invoice_to_province := jtf_varchar2_table_100();
6753: x_invoice_to_address3 := jtf_varchar2_table_300();
6754: x_invoice_to_address4 := jtf_varchar2_table_300();
6755: x_invoice_to_country_code := jtf_varchar2_table_100();
6756: x_invoice_to_country := jtf_varchar2_table_100();
6757: x_invoice_to_city := jtf_varchar2_table_100();
6758: x_invoice_to_postal_code := jtf_varchar2_table_100();
6759: x_invoice_to_state := jtf_varchar2_table_100();
6760: x_invoice_to_province := jtf_varchar2_table_100();
6761: x_invoice_to_county := jtf_varchar2_table_100();
6754: x_invoice_to_address4 := jtf_varchar2_table_300();
6755: x_invoice_to_country_code := jtf_varchar2_table_100();
6756: x_invoice_to_country := jtf_varchar2_table_100();
6757: x_invoice_to_city := jtf_varchar2_table_100();
6758: x_invoice_to_postal_code := jtf_varchar2_table_100();
6759: x_invoice_to_state := jtf_varchar2_table_100();
6760: x_invoice_to_province := jtf_varchar2_table_100();
6761: x_invoice_to_county := jtf_varchar2_table_100();
6762: x_resource_id := jtf_number_table();
6755: x_invoice_to_country_code := jtf_varchar2_table_100();
6756: x_invoice_to_country := jtf_varchar2_table_100();
6757: x_invoice_to_city := jtf_varchar2_table_100();
6758: x_invoice_to_postal_code := jtf_varchar2_table_100();
6759: x_invoice_to_state := jtf_varchar2_table_100();
6760: x_invoice_to_province := jtf_varchar2_table_100();
6761: x_invoice_to_county := jtf_varchar2_table_100();
6762: x_resource_id := jtf_number_table();
6763: --*/
6756: x_invoice_to_country := jtf_varchar2_table_100();
6757: x_invoice_to_city := jtf_varchar2_table_100();
6758: x_invoice_to_postal_code := jtf_varchar2_table_100();
6759: x_invoice_to_state := jtf_varchar2_table_100();
6760: x_invoice_to_province := jtf_varchar2_table_100();
6761: x_invoice_to_county := jtf_varchar2_table_100();
6762: x_resource_id := jtf_number_table();
6763: --*/
6764:
6757: x_invoice_to_city := jtf_varchar2_table_100();
6758: x_invoice_to_postal_code := jtf_varchar2_table_100();
6759: x_invoice_to_state := jtf_varchar2_table_100();
6760: x_invoice_to_province := jtf_varchar2_table_100();
6761: x_invoice_to_county := jtf_varchar2_table_100();
6762: x_resource_id := jtf_number_table();
6763: --*/
6764:
6765: IF p_qte_header_tbl.count > 0 THEN
6987: p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,
6988: x_quote_line_id OUT NOCOPY jtf_number_table
6989:
6990: /*-- The following output parameters are ignored
6991: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
6992: x_creation_date OUT NOCOPY jtf_date_table,
6993: x_created_by OUT NOCOPY jtf_number_table,
6994: x_last_update_date OUT NOCOPY jtf_date_table,
6995: x_last_updated_by OUT NOCOPY jtf_number_table,
6999: x_program_id OUT NOCOPY jtf_number_table,
7000: x_program_update_date OUT NOCOPY jtf_date_table,
7001: x_quote_header_id OUT NOCOPY jtf_number_table,
7002: x_org_id OUT NOCOPY jtf_number_table,
7003: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
7004: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
7005: x_line_number OUT NOCOPY jtf_number_table,
7006: x_start_date_active OUT NOCOPY jtf_date_table,
7007: x_end_date_active OUT NOCOPY jtf_date_table,
7000: x_program_update_date OUT NOCOPY jtf_date_table,
7001: x_quote_header_id OUT NOCOPY jtf_number_table,
7002: x_org_id OUT NOCOPY jtf_number_table,
7003: x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
7004: x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
7005: x_line_number OUT NOCOPY jtf_number_table,
7006: x_start_date_active OUT NOCOPY jtf_date_table,
7007: x_end_date_active OUT NOCOPY jtf_date_table,
7008: x_order_line_type_id OUT NOCOPY jtf_number_table,
7011: x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,
7012: x_organization_id OUT NOCOPY jtf_number_table,
7013: x_inventory_item_id OUT NOCOPY jtf_number_table,
7014: x_quantity OUT NOCOPY jtf_number_table,
7015: x_uom_code OUT NOCOPY jtf_varchar2_table_100,
7016: x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
7017: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
7018: x_price_list_id OUT NOCOPY jtf_number_table,
7019: x_price_list_line_id OUT NOCOPY jtf_number_table,
7012: x_organization_id OUT NOCOPY jtf_number_table,
7013: x_inventory_item_id OUT NOCOPY jtf_number_table,
7014: x_quantity OUT NOCOPY jtf_number_table,
7015: x_uom_code OUT NOCOPY jtf_varchar2_table_100,
7016: x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
7017: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
7018: x_price_list_id OUT NOCOPY jtf_number_table,
7019: x_price_list_line_id OUT NOCOPY jtf_number_table,
7020: x_currency_code OUT NOCOPY jtf_varchar2_table_100,
7016: x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
7017: x_marketing_source_code_id OUT NOCOPY jtf_number_table,
7018: x_price_list_id OUT NOCOPY jtf_number_table,
7019: x_price_list_line_id OUT NOCOPY jtf_number_table,
7020: x_currency_code OUT NOCOPY jtf_varchar2_table_100,
7021: x_line_list_price OUT NOCOPY jtf_number_table,
7022: x_line_adjusted_amount OUT NOCOPY jtf_number_table,
7023: x_line_adjusted_percent OUT NOCOPY jtf_number_table,
7024: x_line_quote_price OUT NOCOPY jtf_number_table,
7022: x_line_adjusted_amount OUT NOCOPY jtf_number_table,
7023: x_line_adjusted_percent OUT NOCOPY jtf_number_table,
7024: x_line_quote_price OUT NOCOPY jtf_number_table,
7025: x_related_item_id OUT NOCOPY jtf_number_table,
7026: x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
7027: x_accounting_rule_id OUT NOCOPY jtf_number_table,
7028: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
7029: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
7030: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
7025: x_related_item_id OUT NOCOPY jtf_number_table,
7026: x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
7027: x_accounting_rule_id OUT NOCOPY jtf_number_table,
7028: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
7029: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
7030: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
7031: x_minisite_id OUT NOCOPY jtf_number_table,
7032: x_section_id OUT NOCOPY jtf_number_table,
7033: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
7026: x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
7027: x_accounting_rule_id OUT NOCOPY jtf_number_table,
7028: x_invoicing_rule_id OUT NOCOPY jtf_number_table,
7029: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
7030: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
7031: x_minisite_id OUT NOCOPY jtf_number_table,
7032: x_section_id OUT NOCOPY jtf_number_table,
7033: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
7034: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
7029: x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
7030: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
7031: x_minisite_id OUT NOCOPY jtf_number_table,
7032: x_section_id OUT NOCOPY jtf_number_table,
7033: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
7034: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
7035: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7036: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7037: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7030: x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
7031: x_minisite_id OUT NOCOPY jtf_number_table,
7032: x_section_id OUT NOCOPY jtf_number_table,
7033: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
7034: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
7035: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7036: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7037: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7038: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
7031: x_minisite_id OUT NOCOPY jtf_number_table,
7032: x_section_id OUT NOCOPY jtf_number_table,
7033: x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
7034: x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
7035: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7036: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7037: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7038: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
7039: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
7061: BEGIN
7062: x_quote_line_id := jtf_number_table();
7063:
7064: /*-- The following output parameters are ignored
7065: x_operation_code := jtf_varchar2_table_100();
7066: x_creation_date := jtf_date_table();
7067: x_created_by := jtf_number_table();
7068: x_last_update_date := jtf_date_table();
7069: x_last_updated_by := jtf_number_table();
7073: x_program_id := jtf_number_table();
7074: x_program_update_date := jtf_date_table();
7075: x_quote_header_id := jtf_number_table();
7076: x_org_id := jtf_number_table();
7077: x_line_category_code := jtf_varchar2_table_100();
7078: x_item_type_code := jtf_varchar2_table_100();
7079: x_line_number := jtf_number_table();
7080: x_start_date_active := jtf_date_table();
7081: x_end_date_active := jtf_date_table();
7074: x_program_update_date := jtf_date_table();
7075: x_quote_header_id := jtf_number_table();
7076: x_org_id := jtf_number_table();
7077: x_line_category_code := jtf_varchar2_table_100();
7078: x_item_type_code := jtf_varchar2_table_100();
7079: x_line_number := jtf_number_table();
7080: x_start_date_active := jtf_date_table();
7081: x_end_date_active := jtf_date_table();
7082: x_order_line_type_id := jtf_number_table();
7085: x_invoice_to_cust_account_id := jtf_number_table();
7086: x_organization_id := jtf_number_table();
7087: x_inventory_item_id := jtf_number_table();
7088: x_quantity := jtf_number_table();
7089: x_uom_code := jtf_varchar2_table_100();
7090: x_pricing_quantity_uom := jtf_varchar2_table_100();
7091: x_marketing_source_code_id := jtf_number_table();
7092: x_price_list_id := jtf_number_table();
7093: x_price_list_line_id := jtf_number_table();
7086: x_organization_id := jtf_number_table();
7087: x_inventory_item_id := jtf_number_table();
7088: x_quantity := jtf_number_table();
7089: x_uom_code := jtf_varchar2_table_100();
7090: x_pricing_quantity_uom := jtf_varchar2_table_100();
7091: x_marketing_source_code_id := jtf_number_table();
7092: x_price_list_id := jtf_number_table();
7093: x_price_list_line_id := jtf_number_table();
7094: x_currency_code := jtf_varchar2_table_100();
7090: x_pricing_quantity_uom := jtf_varchar2_table_100();
7091: x_marketing_source_code_id := jtf_number_table();
7092: x_price_list_id := jtf_number_table();
7093: x_price_list_line_id := jtf_number_table();
7094: x_currency_code := jtf_varchar2_table_100();
7095: x_line_list_price := jtf_number_table();
7096: x_line_adjusted_amount := jtf_number_table();
7097: x_line_adjusted_percent := jtf_number_table();
7098: x_line_quote_price := jtf_number_table();
7096: x_line_adjusted_amount := jtf_number_table();
7097: x_line_adjusted_percent := jtf_number_table();
7098: x_line_quote_price := jtf_number_table();
7099: x_related_item_id := jtf_number_table();
7100: x_item_relationship_type := jtf_varchar2_table_100();
7101: x_accounting_rule_id := jtf_number_table();
7102: x_invoicing_rule_id := jtf_number_table();
7103: x_split_shipment_flag := jtf_varchar2_table_100();
7104: x_backorder_flag := jtf_varchar2_table_100();
7099: x_related_item_id := jtf_number_table();
7100: x_item_relationship_type := jtf_varchar2_table_100();
7101: x_accounting_rule_id := jtf_number_table();
7102: x_invoicing_rule_id := jtf_number_table();
7103: x_split_shipment_flag := jtf_varchar2_table_100();
7104: x_backorder_flag := jtf_varchar2_table_100();
7105: x_minisite_id := jtf_number_table();
7106: x_section_id := jtf_number_table();
7107: x_selling_price_change := jtf_varchar2_table_100();
7100: x_item_relationship_type := jtf_varchar2_table_100();
7101: x_accounting_rule_id := jtf_number_table();
7102: x_invoicing_rule_id := jtf_number_table();
7103: x_split_shipment_flag := jtf_varchar2_table_100();
7104: x_backorder_flag := jtf_varchar2_table_100();
7105: x_minisite_id := jtf_number_table();
7106: x_section_id := jtf_number_table();
7107: x_selling_price_change := jtf_varchar2_table_100();
7108: x_recalculate_flag := jtf_varchar2_table_100();
7103: x_split_shipment_flag := jtf_varchar2_table_100();
7104: x_backorder_flag := jtf_varchar2_table_100();
7105: x_minisite_id := jtf_number_table();
7106: x_section_id := jtf_number_table();
7107: x_selling_price_change := jtf_varchar2_table_100();
7108: x_recalculate_flag := jtf_varchar2_table_100();
7109: x_attribute_category := jtf_varchar2_table_100();
7110: x_attribute1 := jtf_varchar2_table_200();
7111: x_attribute2 := jtf_varchar2_table_200();
7104: x_backorder_flag := jtf_varchar2_table_100();
7105: x_minisite_id := jtf_number_table();
7106: x_section_id := jtf_number_table();
7107: x_selling_price_change := jtf_varchar2_table_100();
7108: x_recalculate_flag := jtf_varchar2_table_100();
7109: x_attribute_category := jtf_varchar2_table_100();
7110: x_attribute1 := jtf_varchar2_table_200();
7111: x_attribute2 := jtf_varchar2_table_200();
7112: x_attribute3 := jtf_varchar2_table_200();
7105: x_minisite_id := jtf_number_table();
7106: x_section_id := jtf_number_table();
7107: x_selling_price_change := jtf_varchar2_table_100();
7108: x_recalculate_flag := jtf_varchar2_table_100();
7109: x_attribute_category := jtf_varchar2_table_100();
7110: x_attribute1 := jtf_varchar2_table_200();
7111: x_attribute2 := jtf_varchar2_table_200();
7112: x_attribute3 := jtf_varchar2_table_200();
7113: x_attribute4 := jtf_varchar2_table_200();
7291: p_qte_line_dtl_tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
7292: x_quote_line_detail_id OUT NOCOPY jtf_number_table
7293:
7294: /*-- The following output parameters are ignored
7295: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7296: x_qte_line_index OUT NOCOPY jtf_number_table,
7297: x_creation_date OUT NOCOPY jtf_date_table,
7298: x_created_by OUT NOCOPY jtf_number_table,
7299: x_last_update_date OUT NOCOPY jtf_date_table,
7306: x_quote_line_id OUT NOCOPY jtf_number_table,
7307: x_config_header_id OUT NOCOPY jtf_number_table,
7308: x_config_revision_num OUT NOCOPY jtf_number_table,
7309: x_config_item_id OUT NOCOPY jtf_number_table,
7310: x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
7311: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
7312: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
7313: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
7314: x_service_duration OUT NOCOPY jtf_number_table,
7307: x_config_header_id OUT NOCOPY jtf_number_table,
7308: x_config_revision_num OUT NOCOPY jtf_number_table,
7309: x_config_item_id OUT NOCOPY jtf_number_table,
7310: x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
7311: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
7312: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
7313: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
7314: x_service_duration OUT NOCOPY jtf_number_table,
7315: x_service_period OUT NOCOPY jtf_varchar2_table_100,
7309: x_config_item_id OUT NOCOPY jtf_number_table,
7310: x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
7311: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
7312: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
7313: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
7314: x_service_duration OUT NOCOPY jtf_number_table,
7315: x_service_period OUT NOCOPY jtf_varchar2_table_100,
7316: x_service_unit_selling OUT NOCOPY jtf_number_table,
7317: x_service_unit_list OUT NOCOPY jtf_number_table,
7311: x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
7312: x_component_code OUT NOCOPY jtf_varchar2_table_1200,
7313: x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
7314: x_service_duration OUT NOCOPY jtf_number_table,
7315: x_service_period OUT NOCOPY jtf_varchar2_table_100,
7316: x_service_unit_selling OUT NOCOPY jtf_number_table,
7317: x_service_unit_list OUT NOCOPY jtf_number_table,
7318: x_service_number OUT NOCOPY jtf_number_table,
7319: x_unit_percent_base_price OUT NOCOPY jtf_number_table,
7316: x_service_unit_selling OUT NOCOPY jtf_number_table,
7317: x_service_unit_list OUT NOCOPY jtf_number_table,
7318: x_service_number OUT NOCOPY jtf_number_table,
7319: x_unit_percent_base_price OUT NOCOPY jtf_number_table,
7320: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7321: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7322: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7323: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
7324: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
7332: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
7333: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
7334: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
7335: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
7336: x_service_ref_type_code OUT NOCOPY jtf_varchar2_table_100,
7337: x_service_ref_order_number OUT NOCOPY jtf_number_table,
7338: x_service_ref_line_number OUT NOCOPY jtf_number_table,
7339: x_service_ref_qte_line_ind OUT NOCOPY jtf_number_table,
7340: x_service_ref_line_id OUT NOCOPY jtf_number_table,
7340: x_service_ref_line_id OUT NOCOPY jtf_number_table,
7341: x_service_ref_system_id OUT NOCOPY jtf_number_table,
7342: x_service_ref_option_numb OUT NOCOPY jtf_number_table,
7343: x_service_ref_shipment OUT NOCOPY jtf_number_table,
7344: x_return_ref_type OUT NOCOPY jtf_varchar2_table_100,
7345: x_return_ref_header_id OUT NOCOPY jtf_number_table,
7346: x_return_ref_line_id OUT NOCOPY jtf_number_table,
7347: x_return_attribute1 OUT NOCOPY jtf_varchar2_table_300,
7348: x_return_attribute2 OUT NOCOPY jtf_varchar2_table_300,
7358: x_return_attribute15 OUT NOCOPY jtf_varchar2_table_300,
7359: x_return_attribute12 OUT NOCOPY jtf_varchar2_table_300,
7360: x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
7361: x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
7362: x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
7363: x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
7364: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
7365: --*/
7366: )
7359: x_return_attribute12 OUT NOCOPY jtf_varchar2_table_300,
7360: x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
7361: x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
7362: x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
7363: x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
7364: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
7365: --*/
7366: )
7367: AS
7360: x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
7361: x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
7362: x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
7363: x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
7364: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
7365: --*/
7366: )
7367: AS
7368: ddindx binary_integer; indx binary_integer;
7369: BEGIN
7370: x_quote_line_detail_id := jtf_number_table();
7371:
7372: /*-- The following output parameters are ignored
7373: x_operation_code := jtf_varchar2_table_100();
7374: x_qte_line_index := jtf_number_table();
7375: x_creation_date := jtf_date_table();
7376: x_created_by := jtf_number_table();
7377: x_last_update_date := jtf_date_table();
7384: x_quote_line_id := jtf_number_table();
7385: x_config_header_id := jtf_number_table();
7386: x_config_revision_num := jtf_number_table();
7387: x_config_item_id := jtf_number_table();
7388: x_complete_configuration:= jtf_varchar2_table_100();
7389: x_valid_configuration_flag := jtf_varchar2_table_100();
7390: x_component_code := jtf_varchar2_table_1200();
7391: x_service_coterminate_flag := jtf_varchar2_table_100();
7392: x_service_duration := jtf_number_table();
7385: x_config_header_id := jtf_number_table();
7386: x_config_revision_num := jtf_number_table();
7387: x_config_item_id := jtf_number_table();
7388: x_complete_configuration:= jtf_varchar2_table_100();
7389: x_valid_configuration_flag := jtf_varchar2_table_100();
7390: x_component_code := jtf_varchar2_table_1200();
7391: x_service_coterminate_flag := jtf_varchar2_table_100();
7392: x_service_duration := jtf_number_table();
7393: x_service_period := jtf_varchar2_table_100();
7387: x_config_item_id := jtf_number_table();
7388: x_complete_configuration:= jtf_varchar2_table_100();
7389: x_valid_configuration_flag := jtf_varchar2_table_100();
7390: x_component_code := jtf_varchar2_table_1200();
7391: x_service_coterminate_flag := jtf_varchar2_table_100();
7392: x_service_duration := jtf_number_table();
7393: x_service_period := jtf_varchar2_table_100();
7394: x_service_unit_selling := jtf_number_table();
7395: x_service_unit_list:= jtf_number_table();
7389: x_valid_configuration_flag := jtf_varchar2_table_100();
7390: x_component_code := jtf_varchar2_table_1200();
7391: x_service_coterminate_flag := jtf_varchar2_table_100();
7392: x_service_duration := jtf_number_table();
7393: x_service_period := jtf_varchar2_table_100();
7394: x_service_unit_selling := jtf_number_table();
7395: x_service_unit_list:= jtf_number_table();
7396: x_service_number := jtf_number_table();
7397: x_unit_percent_base_price := jtf_number_table();
7394: x_service_unit_selling := jtf_number_table();
7395: x_service_unit_list:= jtf_number_table();
7396: x_service_number := jtf_number_table();
7397: x_unit_percent_base_price := jtf_number_table();
7398: x_attribute_category := jtf_varchar2_table_100();
7399: x_attribute1 := jtf_varchar2_table_200();
7400: x_attribute2 := jtf_varchar2_table_200();
7401: x_attribute3 := jtf_varchar2_table_200();
7402: x_attribute4 := jtf_varchar2_table_200();
7410: x_attribute12 := jtf_varchar2_table_200();
7411: x_attribute13 := jtf_varchar2_table_200();
7412: x_attribute14 := jtf_varchar2_table_200();
7413: x_attribute15 := jtf_varchar2_table_200();
7414: x_service_ref_type_code := jtf_varchar2_table_100();
7415: x_service_ref_order_number := jtf_number_table();
7416: x_service_ref_line_number := jtf_number_table();
7417: x_service_ref_qte_line_ind := jtf_number_table();
7418: x_service_ref_line_id := jtf_number_table();
7418: x_service_ref_line_id := jtf_number_table();
7419: x_service_ref_system_id := jtf_number_table();
7420: x_service_ref_option_numb := jtf_number_table();
7421: x_service_ref_shipment:= jtf_number_table();
7422: x_return_ref_type := jtf_varchar2_table_100();
7423: x_return_ref_header_id := jtf_number_table();
7424: x_return_ref_line_id := jtf_number_table();
7425: x_return_attribute1 := jtf_varchar2_table_300();
7426: x_return_attribute2 := jtf_varchar2_table_300();
7436: x_return_attribute15 := jtf_varchar2_table_300();
7437: x_return_attribute12 := jtf_varchar2_table_300();
7438: x_return_attribute13 := jtf_varchar2_table_300();
7439: x_return_attribute14 := jtf_varchar2_table_300();
7440: x_return_attr_category := jtf_varchar2_table_100();
7441: x_return_reason_code := jtf_varchar2_table_100();
7442: x_change_reason_code := jtf_varchar2_table_100();
7443: --*/
7444:
7437: x_return_attribute12 := jtf_varchar2_table_300();
7438: x_return_attribute13 := jtf_varchar2_table_300();
7439: x_return_attribute14 := jtf_varchar2_table_300();
7440: x_return_attr_category := jtf_varchar2_table_100();
7441: x_return_reason_code := jtf_varchar2_table_100();
7442: x_change_reason_code := jtf_varchar2_table_100();
7443: --*/
7444:
7445: IF p_qte_line_dtl_tbl.count > 0 THEN
7438: x_return_attribute13 := jtf_varchar2_table_300();
7439: x_return_attribute14 := jtf_varchar2_table_300();
7440: x_return_attr_category := jtf_varchar2_table_100();
7441: x_return_reason_code := jtf_varchar2_table_100();
7442: x_change_reason_code := jtf_varchar2_table_100();
7443: --*/
7444:
7445: IF p_qte_line_dtl_tbl.count > 0 THEN
7446: x_quote_line_detail_id.extend(p_qte_line_dtl_tbl.count);
7611: p_qte_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type,
7612: x_line_relationship_id OUT NOCOPY jtf_number_table
7613:
7614: /*-- The following output parameters are ignored
7615: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7616: x_creation_date OUT NOCOPY jtf_date_table,
7617: x_created_by OUT NOCOPY jtf_number_table,
7618: x_last_update_date OUT NOCOPY jtf_date_table,
7619: x_last_updated_by OUT NOCOPY jtf_number_table,
7625: x_quote_line_id OUT NOCOPY jtf_number_table,
7626: x_qte_line_index OUT NOCOPY jtf_number_table,
7627: x_related_quote_line_id OUT NOCOPY jtf_number_table,
7628: x_related_qte_line_index OUT NOCOPY jtf_number_table,
7629: x_relationship_type_code OUT NOCOPY jtf_varchar2_table_100,
7630: x_reciprocal_flag OUT NOCOPY jtf_varchar2_table_100
7631: --*/
7632: )
7633: AS
7626: x_qte_line_index OUT NOCOPY jtf_number_table,
7627: x_related_quote_line_id OUT NOCOPY jtf_number_table,
7628: x_related_qte_line_index OUT NOCOPY jtf_number_table,
7629: x_relationship_type_code OUT NOCOPY jtf_varchar2_table_100,
7630: x_reciprocal_flag OUT NOCOPY jtf_varchar2_table_100
7631: --*/
7632: )
7633: AS
7634: ddindx binary_integer; indx binary_integer;
7635: BEGIN
7636: x_line_relationship_id := jtf_number_table();
7637:
7638: /*-- The following output parameters are ignored
7639: x_operation_code := jtf_varchar2_table_100();
7640: x_creation_date := jtf_date_table();
7641: x_created_by := jtf_number_table();
7642: x_last_update_date := jtf_date_table();
7643: x_last_updated_by := jtf_number_table();
7649: x_quote_line_id := jtf_number_table();
7650: x_qte_line_index := jtf_number_table();
7651: x_related_quote_line_id := jtf_number_table();
7652: x_related_qte_line_index := jtf_number_table();
7653: x_relationship_type_code := jtf_varchar2_table_100();
7654: x_reciprocal_flag := jtf_varchar2_table_100();
7655: --*/
7656:
7657: IF p_qte_line_rltship_tbl.count > 0 THEN
7650: x_qte_line_index := jtf_number_table();
7651: x_related_quote_line_id := jtf_number_table();
7652: x_related_qte_line_index := jtf_number_table();
7653: x_relationship_type_code := jtf_varchar2_table_100();
7654: x_reciprocal_flag := jtf_varchar2_table_100();
7655: --*/
7656:
7657: IF p_qte_line_rltship_tbl.count > 0 THEN
7658: x_line_relationship_id.extend(p_qte_line_rltship_tbl.count);
7715: p_qte_payment_tbl IN ASO_Quote_Pub.Payment_Tbl_Type,
7716: x_payment_id OUT NOCOPY jtf_number_table
7717:
7718: /*-- The following output parameters are ignored
7719: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7720: x_qte_line_index OUT NOCOPY jtf_number_table,
7721: x_shipment_index OUT NOCOPY jtf_number_table,
7722: x_creation_date OUT NOCOPY jtf_date_table,
7723: x_created_by OUT NOCOPY jtf_number_table,
7730: x_program_update_date OUT NOCOPY jtf_date_table,
7731: x_quote_header_id OUT NOCOPY jtf_number_table,
7732: x_quote_line_id OUT NOCOPY jtf_number_table,
7733: x_quote_shipment_id OUT NOCOPY jtf_number_table,
7734: x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,
7735: x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
7736: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
7737: x_payment_term_id OUT NOCOPY jtf_number_table,
7738: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
7734: x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,
7735: x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
7736: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
7737: x_payment_term_id OUT NOCOPY jtf_number_table,
7738: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
7739: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
7740: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
7741: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
7742: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
7735: x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
7736: x_payment_option OUT NOCOPY jtf_varchar2_table_300,
7737: x_payment_term_id OUT NOCOPY jtf_number_table,
7738: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
7739: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
7740: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
7741: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
7742: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
7743: x_payment_amount OUT NOCOPY jtf_number_table,
7737: x_payment_term_id OUT NOCOPY jtf_number_table,
7738: x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
7739: x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
7740: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
7741: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
7742: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
7743: x_payment_amount OUT NOCOPY jtf_number_table,
7744: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7745: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7740: x_credit_card_exp_date OUT NOCOPY jtf_date_table,
7741: x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
7742: x_credit_card_approval_date OUT NOCOPY jtf_date_table,
7743: x_payment_amount OUT NOCOPY jtf_number_table,
7744: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7745: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7746: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7747: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
7748: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
7756: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
7757: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
7758: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
7759: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
7760: x_cust_po_number OUT NOCOPY jtf_varchar2_table_100
7761: --*/
7762: )
7763: AS
7764: ddindx binary_integer; indx binary_integer;
7765: BEGIN
7766: x_payment_id := jtf_number_table();
7767:
7768: /*-- The following output parameters are ignored
7769: x_operation_code := jtf_varchar2_table_100();
7770: x_qte_line_index := jtf_number_table();
7771: x_shipment_index := jtf_number_table();
7772: x_creation_date := jtf_date_table();
7773: x_created_by := jtf_number_table();
7780: x_program_update_date := jtf_date_table();
7781: x_quote_header_id := jtf_number_table();
7782: x_quote_line_id := jtf_number_table();
7783: x_quote_shipment_id := jtf_number_table();
7784: x_payment_type_code := jtf_varchar2_table_100();
7785: x_payment_ref_number := jtf_varchar2_table_300();
7786: x_payment_option := jtf_varchar2_table_300();
7787: x_payment_term_id := jtf_number_table();
7788: x_credit_card_code := jtf_varchar2_table_100();
7784: x_payment_type_code := jtf_varchar2_table_100();
7785: x_payment_ref_number := jtf_varchar2_table_300();
7786: x_payment_option := jtf_varchar2_table_300();
7787: x_payment_term_id := jtf_number_table();
7788: x_credit_card_code := jtf_varchar2_table_100();
7789: x_credit_card_holder_name := jtf_varchar2_table_100();
7790: x_credit_card_exp_date := jtf_date_table();
7791: x_credit_card_approval_code := jtf_varchar2_table_100();
7792: x_credit_card_approval_date := jtf_date_table();
7785: x_payment_ref_number := jtf_varchar2_table_300();
7786: x_payment_option := jtf_varchar2_table_300();
7787: x_payment_term_id := jtf_number_table();
7788: x_credit_card_code := jtf_varchar2_table_100();
7789: x_credit_card_holder_name := jtf_varchar2_table_100();
7790: x_credit_card_exp_date := jtf_date_table();
7791: x_credit_card_approval_code := jtf_varchar2_table_100();
7792: x_credit_card_approval_date := jtf_date_table();
7793: x_payment_amount := jtf_number_table();
7787: x_payment_term_id := jtf_number_table();
7788: x_credit_card_code := jtf_varchar2_table_100();
7789: x_credit_card_holder_name := jtf_varchar2_table_100();
7790: x_credit_card_exp_date := jtf_date_table();
7791: x_credit_card_approval_code := jtf_varchar2_table_100();
7792: x_credit_card_approval_date := jtf_date_table();
7793: x_payment_amount := jtf_number_table();
7794: x_attribute_category := jtf_varchar2_table_100();
7795: x_attribute1 := jtf_varchar2_table_200();
7790: x_credit_card_exp_date := jtf_date_table();
7791: x_credit_card_approval_code := jtf_varchar2_table_100();
7792: x_credit_card_approval_date := jtf_date_table();
7793: x_payment_amount := jtf_number_table();
7794: x_attribute_category := jtf_varchar2_table_100();
7795: x_attribute1 := jtf_varchar2_table_200();
7796: x_attribute2 := jtf_varchar2_table_200();
7797: x_attribute3 := jtf_varchar2_table_200();
7798: x_attribute4 := jtf_varchar2_table_200();
7806: x_attribute12 := jtf_varchar2_table_200();
7807: x_attribute13 := jtf_varchar2_table_200();
7808: x_attribute14 := jtf_varchar2_table_200();
7809: x_attribute15 := jtf_varchar2_table_200();
7810: x_cust_po_number := jtf_varchar2_table_100();
7811: --*/
7812: IF p_qte_payment_tbl.count > 0 THEN
7813: x_payment_id.extend(p_qte_payment_tbl.count);
7814:
7922: p_qte_shipment_tbl IN ASO_Quote_Pub.Shipment_Tbl_Type,
7923: x_shipment_id OUT NOCOPY jtf_number_table
7924:
7925: /*-- The following output parameters are ignored
7926: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
7927: x_qte_line_index OUT NOCOPY jtf_number_table,
7928: x_creation_date OUT NOCOPY jtf_date_table,
7929: x_created_by OUT NOCOPY jtf_number_table,
7930: x_last_update_date OUT NOCOPY jtf_date_table,
7943: x_ship_to_party_id OUT NOCOPY jtf_number_table,
7944: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
7945: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
7946: x_ship_set_id OUT NOCOPY jtf_number_table,
7947: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
7948: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
7949: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
7950: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
7951: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
7944: x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
7945: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
7946: x_ship_set_id OUT NOCOPY jtf_number_table,
7947: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
7948: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
7949: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
7950: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
7951: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
7952: x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
7945: x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
7946: x_ship_set_id OUT NOCOPY jtf_number_table,
7947: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
7948: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
7949: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
7950: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
7951: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
7952: x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
7953: x_ship_quote_price OUT NOCOPY jtf_number_table,
7946: x_ship_set_id OUT NOCOPY jtf_number_table,
7947: x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
7948: x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
7949: x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
7950: x_fob_code OUT NOCOPY jtf_varchar2_table_100,
7951: x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
7952: x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
7953: x_ship_quote_price OUT NOCOPY jtf_number_table,
7954: x_quantity OUT NOCOPY jtf_number_table,
7957: x_reservation_id OUT NOCOPY jtf_number_table,
7958: x_order_line_id OUT NOCOPY jtf_number_table,
7959: x_ship_to_party_name OUT NOCOPY jtf_varchar2_table_300,
7960: x_ship_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
7961: x_ship_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
7962: x_ship_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
7963: x_ship_to_address1 OUT NOCOPY jtf_varchar2_table_300,
7964: x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
7965: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
7963: x_ship_to_address1 OUT NOCOPY jtf_varchar2_table_300,
7964: x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
7965: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
7966: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
7967: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
7968: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
7969: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
7970: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
7971: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
7964: x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
7965: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
7966: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
7967: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
7968: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
7969: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
7970: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
7971: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
7972: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
7965: x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
7966: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
7967: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
7968: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
7969: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
7970: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
7971: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
7972: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
7973: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
7966: x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
7967: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
7968: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
7969: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
7970: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
7971: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
7972: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
7973: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
7974: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7967: x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
7968: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
7969: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
7970: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
7971: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
7972: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
7973: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
7974: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7975: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7968: x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
7969: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
7970: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
7971: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
7972: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
7973: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
7974: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7975: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7976: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7969: x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
7970: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
7971: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
7972: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
7973: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
7974: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7975: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7976: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7977: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
7970: x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
7971: x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
7972: x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
7973: x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
7974: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
7975: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
7976: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
7977: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
7978: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
7986: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
7987: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
7988: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
7989: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
7990: x_shipment_priority_code OUT NOCOPY jtf_varchar2_table_100,
7991: x_ship_from_org_id OUT NOCOPY jtf_number_table
7992: --*/
7993: )
7994: AS
7996: BEGIN
7997: x_shipment_id := jtf_number_table();
7998:
7999: /*-- The following output parameters are ignored
8000: x_operation_code := jtf_varchar2_table_100();
8001: x_qte_line_index := jtf_number_table();
8002: x_creation_date := jtf_date_table();
8003: x_created_by := jtf_number_table();
8004: x_last_update_date := jtf_date_table();
8017: x_ship_to_party_id := jtf_number_table();
8018: x_ship_to_cust_account_id := jtf_number_table();
8019: x_ship_partial_flag := jtf_varchar2_table_300();
8020: x_ship_set_id := jtf_number_table();
8021: x_ship_method_code := jtf_varchar2_table_100();
8022: x_freight_terms_code := jtf_varchar2_table_100();
8023: x_freight_carrier_code := jtf_varchar2_table_100();
8024: x_fob_code := jtf_varchar2_table_100();
8025: x_shipping_instructions := jtf_varchar2_table_2000();
8018: x_ship_to_cust_account_id := jtf_number_table();
8019: x_ship_partial_flag := jtf_varchar2_table_300();
8020: x_ship_set_id := jtf_number_table();
8021: x_ship_method_code := jtf_varchar2_table_100();
8022: x_freight_terms_code := jtf_varchar2_table_100();
8023: x_freight_carrier_code := jtf_varchar2_table_100();
8024: x_fob_code := jtf_varchar2_table_100();
8025: x_shipping_instructions := jtf_varchar2_table_2000();
8026: x_packing_instructions := jtf_varchar2_table_2000();
8019: x_ship_partial_flag := jtf_varchar2_table_300();
8020: x_ship_set_id := jtf_number_table();
8021: x_ship_method_code := jtf_varchar2_table_100();
8022: x_freight_terms_code := jtf_varchar2_table_100();
8023: x_freight_carrier_code := jtf_varchar2_table_100();
8024: x_fob_code := jtf_varchar2_table_100();
8025: x_shipping_instructions := jtf_varchar2_table_2000();
8026: x_packing_instructions := jtf_varchar2_table_2000();
8027: x_ship_quote_price := jtf_number_table();
8020: x_ship_set_id := jtf_number_table();
8021: x_ship_method_code := jtf_varchar2_table_100();
8022: x_freight_terms_code := jtf_varchar2_table_100();
8023: x_freight_carrier_code := jtf_varchar2_table_100();
8024: x_fob_code := jtf_varchar2_table_100();
8025: x_shipping_instructions := jtf_varchar2_table_2000();
8026: x_packing_instructions := jtf_varchar2_table_2000();
8027: x_ship_quote_price := jtf_number_table();
8028: x_quantity := jtf_number_table();
8031: x_reservation_id := jtf_number_table();
8032: x_order_line_id := jtf_number_table();
8033: x_ship_to_party_name := jtf_varchar2_table_300();
8034: x_ship_to_cont_first_name := jtf_varchar2_table_200();
8035: x_ship_to_cont_mid_name := jtf_varchar2_table_100();
8036: x_ship_to_cont_last_name := jtf_varchar2_table_200();
8037: x_ship_to_address1 := jtf_varchar2_table_300();
8038: x_ship_to_address2 := jtf_varchar2_table_300();
8039: x_ship_to_address3 := jtf_varchar2_table_300();
8037: x_ship_to_address1 := jtf_varchar2_table_300();
8038: x_ship_to_address2 := jtf_varchar2_table_300();
8039: x_ship_to_address3 := jtf_varchar2_table_300();
8040: x_ship_to_address4 := jtf_varchar2_table_300();
8041: x_ship_to_country_code := jtf_varchar2_table_100();
8042: x_ship_to_country := jtf_varchar2_table_100();
8043: x_ship_to_city := jtf_varchar2_table_100();
8044: x_ship_to_postal_code := jtf_varchar2_table_100();
8045: x_ship_to_state := jtf_varchar2_table_100();
8038: x_ship_to_address2 := jtf_varchar2_table_300();
8039: x_ship_to_address3 := jtf_varchar2_table_300();
8040: x_ship_to_address4 := jtf_varchar2_table_300();
8041: x_ship_to_country_code := jtf_varchar2_table_100();
8042: x_ship_to_country := jtf_varchar2_table_100();
8043: x_ship_to_city := jtf_varchar2_table_100();
8044: x_ship_to_postal_code := jtf_varchar2_table_100();
8045: x_ship_to_state := jtf_varchar2_table_100();
8046: x_ship_to_province := jtf_varchar2_table_100();
8039: x_ship_to_address3 := jtf_varchar2_table_300();
8040: x_ship_to_address4 := jtf_varchar2_table_300();
8041: x_ship_to_country_code := jtf_varchar2_table_100();
8042: x_ship_to_country := jtf_varchar2_table_100();
8043: x_ship_to_city := jtf_varchar2_table_100();
8044: x_ship_to_postal_code := jtf_varchar2_table_100();
8045: x_ship_to_state := jtf_varchar2_table_100();
8046: x_ship_to_province := jtf_varchar2_table_100();
8047: x_ship_to_county := jtf_varchar2_table_100();
8040: x_ship_to_address4 := jtf_varchar2_table_300();
8041: x_ship_to_country_code := jtf_varchar2_table_100();
8042: x_ship_to_country := jtf_varchar2_table_100();
8043: x_ship_to_city := jtf_varchar2_table_100();
8044: x_ship_to_postal_code := jtf_varchar2_table_100();
8045: x_ship_to_state := jtf_varchar2_table_100();
8046: x_ship_to_province := jtf_varchar2_table_100();
8047: x_ship_to_county := jtf_varchar2_table_100();
8048: x_attribute_category := jtf_varchar2_table_100();
8041: x_ship_to_country_code := jtf_varchar2_table_100();
8042: x_ship_to_country := jtf_varchar2_table_100();
8043: x_ship_to_city := jtf_varchar2_table_100();
8044: x_ship_to_postal_code := jtf_varchar2_table_100();
8045: x_ship_to_state := jtf_varchar2_table_100();
8046: x_ship_to_province := jtf_varchar2_table_100();
8047: x_ship_to_county := jtf_varchar2_table_100();
8048: x_attribute_category := jtf_varchar2_table_100();
8049: x_attribute1 := jtf_varchar2_table_200();
8042: x_ship_to_country := jtf_varchar2_table_100();
8043: x_ship_to_city := jtf_varchar2_table_100();
8044: x_ship_to_postal_code := jtf_varchar2_table_100();
8045: x_ship_to_state := jtf_varchar2_table_100();
8046: x_ship_to_province := jtf_varchar2_table_100();
8047: x_ship_to_county := jtf_varchar2_table_100();
8048: x_attribute_category := jtf_varchar2_table_100();
8049: x_attribute1 := jtf_varchar2_table_200();
8050: x_attribute2 := jtf_varchar2_table_200();
8043: x_ship_to_city := jtf_varchar2_table_100();
8044: x_ship_to_postal_code := jtf_varchar2_table_100();
8045: x_ship_to_state := jtf_varchar2_table_100();
8046: x_ship_to_province := jtf_varchar2_table_100();
8047: x_ship_to_county := jtf_varchar2_table_100();
8048: x_attribute_category := jtf_varchar2_table_100();
8049: x_attribute1 := jtf_varchar2_table_200();
8050: x_attribute2 := jtf_varchar2_table_200();
8051: x_attribute3 := jtf_varchar2_table_200();
8044: x_ship_to_postal_code := jtf_varchar2_table_100();
8045: x_ship_to_state := jtf_varchar2_table_100();
8046: x_ship_to_province := jtf_varchar2_table_100();
8047: x_ship_to_county := jtf_varchar2_table_100();
8048: x_attribute_category := jtf_varchar2_table_100();
8049: x_attribute1 := jtf_varchar2_table_200();
8050: x_attribute2 := jtf_varchar2_table_200();
8051: x_attribute3 := jtf_varchar2_table_200();
8052: x_attribute4 := jtf_varchar2_table_200();
8060: x_attribute12 := jtf_varchar2_table_200();
8061: x_attribute13 := jtf_varchar2_table_200();
8062: x_attribute14 := jtf_varchar2_table_200();
8063: x_attribute15 := jtf_varchar2_table_200();
8064: x_shipment_priority_code := jtf_varchar2_table_100();
8065: x_ship_from_org_id := jtf_number_table();
8066: --*/
8067:
8068: IF p_qte_shipment_tbl.count > 0 THEN
8226: p_qte_tax_detail_tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type,
8227: x_tax_detail_id OUT NOCOPY jtf_number_table
8228:
8229: /*-- The following output parameters are ignored
8230: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
8231: x_qte_line_index OUT NOCOPY jtf_number_table,
8232: x_shipment_index OUT NOCOPY jtf_number_table,
8233: x_quote_header_id OUT NOCOPY jtf_number_table,
8234: x_quote_line_id OUT NOCOPY jtf_number_table,
8242: x_program_application_id OUT NOCOPY jtf_number_table,
8243: x_program_id OUT NOCOPY jtf_number_table,
8244: x_program_update_date OUT NOCOPY jtf_date_table,
8245: x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
8246: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8247: x_tax_rate OUT NOCOPY jtf_number_table,
8248: x_tax_date OUT NOCOPY jtf_date_table,
8249: x_tax_amount OUT NOCOPY jtf_number_table,
8250: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8246: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8247: x_tax_rate OUT NOCOPY jtf_number_table,
8248: x_tax_date OUT NOCOPY jtf_date_table,
8249: x_tax_amount OUT NOCOPY jtf_number_table,
8250: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8251: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8252: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8253: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8254: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8247: x_tax_rate OUT NOCOPY jtf_number_table,
8248: x_tax_date OUT NOCOPY jtf_date_table,
8249: x_tax_amount OUT NOCOPY jtf_number_table,
8250: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8251: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8252: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8253: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8254: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8255: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8248: x_tax_date OUT NOCOPY jtf_date_table,
8249: x_tax_amount OUT NOCOPY jtf_number_table,
8250: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8251: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8252: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8253: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8254: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8255: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8256: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8249: x_tax_amount OUT NOCOPY jtf_number_table,
8250: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8251: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8252: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8253: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8254: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8255: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8256: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8257: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
8273: BEGIN
8274: x_tax_detail_id := jtf_number_table();
8275:
8276: /*-- The following output parameters are ignored
8277: x_operation_code := jtf_varchar2_table_100();
8278: x_qte_line_index := jtf_number_table();
8279: x_shipment_index := jtf_number_table();
8280: x_quote_header_id := jtf_number_table();
8281: x_quote_line_id := jtf_number_table();
8289: x_program_application_id := jtf_number_table();
8290: x_program_id := jtf_number_table();
8291: x_program_update_date := jtf_date_table();
8292: x_orig_tax_code := jtf_varchar2_table_300();
8293: x_tax_code := jtf_varchar2_table_100();
8294: x_tax_rate := jtf_number_table();
8295: x_tax_date := jtf_date_table();
8296: x_tax_amount := jtf_number_table();
8297: x_tax_exempt_flag := jtf_varchar2_table_100();
8293: x_tax_code := jtf_varchar2_table_100();
8294: x_tax_rate := jtf_number_table();
8295: x_tax_date := jtf_date_table();
8296: x_tax_amount := jtf_number_table();
8297: x_tax_exempt_flag := jtf_varchar2_table_100();
8298: x_tax_exempt_number := jtf_varchar2_table_100();
8299: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8300: x_attribute_category := jtf_varchar2_table_100();
8301: x_attribute1 := jtf_varchar2_table_200();
8294: x_tax_rate := jtf_number_table();
8295: x_tax_date := jtf_date_table();
8296: x_tax_amount := jtf_number_table();
8297: x_tax_exempt_flag := jtf_varchar2_table_100();
8298: x_tax_exempt_number := jtf_varchar2_table_100();
8299: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8300: x_attribute_category := jtf_varchar2_table_100();
8301: x_attribute1 := jtf_varchar2_table_200();
8302: x_attribute2 := jtf_varchar2_table_200();
8295: x_tax_date := jtf_date_table();
8296: x_tax_amount := jtf_number_table();
8297: x_tax_exempt_flag := jtf_varchar2_table_100();
8298: x_tax_exempt_number := jtf_varchar2_table_100();
8299: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8300: x_attribute_category := jtf_varchar2_table_100();
8301: x_attribute1 := jtf_varchar2_table_200();
8302: x_attribute2 := jtf_varchar2_table_200();
8303: x_attribute3 := jtf_varchar2_table_200();
8296: x_tax_amount := jtf_number_table();
8297: x_tax_exempt_flag := jtf_varchar2_table_100();
8298: x_tax_exempt_number := jtf_varchar2_table_100();
8299: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8300: x_attribute_category := jtf_varchar2_table_100();
8301: x_attribute1 := jtf_varchar2_table_200();
8302: x_attribute2 := jtf_varchar2_table_200();
8303: x_attribute3 := jtf_varchar2_table_200();
8304: x_attribute4 := jtf_varchar2_table_200();
8422: p_qte_price_adj_tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type,
8423: x_price_adjustment_id OUT NOCOPY jtf_number_table
8424:
8425: /*-- The following output parameters are ignored
8426: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
8427: x_qte_line_index OUT NOCOPY jtf_number_table,
8428: x_shipment_index OUT NOCOPY jtf_number_table,
8429: x_creation_date OUT NOCOPY jtf_date_table,
8430: x_created_by OUT NOCOPY jtf_number_table,
8439: x_quote_line_id OUT NOCOPY jtf_number_table,
8440: x_quote_shipment_id OUT NOCOPY jtf_number_table,
8441: x_modifier_header_id OUT NOCOPY jtf_number_table,
8442: x_modifier_line_id OUT NOCOPY jtf_number_table,
8443: x_modifier_line_type_code OUT NOCOPY jtf_varchar2_table_100,
8444: x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
8445: x_modified_from OUT NOCOPY jtf_number_table,
8446: x_modified_to OUT NOCOPY jtf_number_table,
8447: x_operand OUT NOCOPY jtf_number_table,
8440: x_quote_shipment_id OUT NOCOPY jtf_number_table,
8441: x_modifier_header_id OUT NOCOPY jtf_number_table,
8442: x_modifier_line_id OUT NOCOPY jtf_number_table,
8443: x_modifier_line_type_code OUT NOCOPY jtf_varchar2_table_100,
8444: x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
8445: x_modified_from OUT NOCOPY jtf_number_table,
8446: x_modified_to OUT NOCOPY jtf_number_table,
8447: x_operand OUT NOCOPY jtf_number_table,
8448: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
8444: x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
8445: x_modified_from OUT NOCOPY jtf_number_table,
8446: x_modified_to OUT NOCOPY jtf_number_table,
8447: x_operand OUT NOCOPY jtf_number_table,
8448: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
8449: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
8450: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
8451: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8452: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8445: x_modified_from OUT NOCOPY jtf_number_table,
8446: x_modified_to OUT NOCOPY jtf_number_table,
8447: x_operand OUT NOCOPY jtf_number_table,
8448: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
8449: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
8450: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
8451: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8452: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8453: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8446: x_modified_to OUT NOCOPY jtf_number_table,
8447: x_operand OUT NOCOPY jtf_number_table,
8448: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
8449: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
8450: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
8451: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8452: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8453: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8454: x_pricing_phase_id OUT NOCOPY jtf_number_table,
8447: x_operand OUT NOCOPY jtf_number_table,
8448: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
8449: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
8450: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
8451: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8452: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8453: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8454: x_pricing_phase_id OUT NOCOPY jtf_number_table,
8455: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8448: x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
8449: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
8450: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
8451: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8452: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8453: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8454: x_pricing_phase_id OUT NOCOPY jtf_number_table,
8455: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8456: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8449: x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
8450: x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
8451: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8452: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8453: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8454: x_pricing_phase_id OUT NOCOPY jtf_number_table,
8455: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8456: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8457: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8451: x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
8452: x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
8453: x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8454: x_pricing_phase_id OUT NOCOPY jtf_number_table,
8455: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
8456: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8457: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8458: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8459: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
8467: x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
8468: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
8469: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
8470: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
8471: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
8472: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
8473: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
8474: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
8475: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8468: x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
8469: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
8470: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
8471: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
8472: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
8473: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
8474: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
8475: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8476: x_cost_id OUT NOCOPY jtf_number_table,
8469: x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
8470: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
8471: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
8472: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
8473: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
8474: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
8475: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8476: x_cost_id OUT NOCOPY jtf_number_table,
8477: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8470: x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
8471: x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
8472: x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
8473: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
8474: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
8475: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8476: x_cost_id OUT NOCOPY jtf_number_table,
8477: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8478: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8473: x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
8474: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
8475: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8476: x_cost_id OUT NOCOPY jtf_number_table,
8477: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8478: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8479: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8480: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8481: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8474: x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
8475: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8476: x_cost_id OUT NOCOPY jtf_number_table,
8477: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8478: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8479: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8480: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8481: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8482: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8475: x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
8476: x_cost_id OUT NOCOPY jtf_number_table,
8477: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8478: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8479: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8480: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8481: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8482: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8483: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8476: x_cost_id OUT NOCOPY jtf_number_table,
8477: x_tax_code OUT NOCOPY jtf_varchar2_table_100,
8478: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8479: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8480: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8481: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8482: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8483: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8484: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8478: x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
8479: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8480: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8481: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8482: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8483: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8484: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8485: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
8486: x_adjusted_amount OUT NOCOPY jtf_number_table,
8479: x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
8480: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8481: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8482: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8483: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8484: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8485: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
8486: x_adjusted_amount OUT NOCOPY jtf_number_table,
8487: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
8480: x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
8481: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8482: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8483: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8484: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8485: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
8486: x_adjusted_amount OUT NOCOPY jtf_number_table,
8487: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
8488: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
8481: x_parent_adjustment_id OUT NOCOPY jtf_number_table,
8482: x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
8483: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8484: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8485: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
8486: x_adjusted_amount OUT NOCOPY jtf_number_table,
8487: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
8488: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
8489: x_range_break_quantity OUT NOCOPY jtf_number_table,
8483: x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
8484: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8485: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
8486: x_adjusted_amount OUT NOCOPY jtf_number_table,
8487: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
8488: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
8489: x_range_break_quantity OUT NOCOPY jtf_number_table,
8490: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
8491: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
8484: x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
8485: x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
8486: x_adjusted_amount OUT NOCOPY jtf_number_table,
8487: x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
8488: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
8489: x_range_break_quantity OUT NOCOPY jtf_number_table,
8490: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
8491: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
8492: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
8488: x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
8489: x_range_break_quantity OUT NOCOPY jtf_number_table,
8490: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
8491: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
8492: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
8493: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
8494: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
8495: x_benefit_qty OUT NOCOPY jtf_number_table,
8496: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8490: x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
8491: x_pricing_group_sequence OUT NOCOPY jtf_number_table,
8492: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
8493: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
8494: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
8495: x_benefit_qty OUT NOCOPY jtf_number_table,
8496: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8497: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8498: x_expiration_date OUT NOCOPY jtf_date_table,
8492: x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
8493: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
8494: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
8495: x_benefit_qty OUT NOCOPY jtf_number_table,
8496: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8497: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8498: x_expiration_date OUT NOCOPY jtf_date_table,
8499: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8500: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8493: x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
8494: x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
8495: x_benefit_qty OUT NOCOPY jtf_number_table,
8496: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8497: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8498: x_expiration_date OUT NOCOPY jtf_date_table,
8499: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8500: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8501: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8495: x_benefit_qty OUT NOCOPY jtf_number_table,
8496: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8497: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8498: x_expiration_date OUT NOCOPY jtf_date_table,
8499: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8500: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8501: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8502: x_redeemed_date OUT NOCOPY jtf_date_table,
8503: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8496: x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
8497: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8498: x_expiration_date OUT NOCOPY jtf_date_table,
8499: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8500: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8501: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8502: x_redeemed_date OUT NOCOPY jtf_date_table,
8503: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8504: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8497: x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
8498: x_expiration_date OUT NOCOPY jtf_date_table,
8499: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8500: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8501: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8502: x_redeemed_date OUT NOCOPY jtf_date_table,
8503: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8504: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8505: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8499: x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
8500: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8501: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8502: x_redeemed_date OUT NOCOPY jtf_date_table,
8503: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8504: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8505: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8506: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8507: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8500: x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
8501: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8502: x_redeemed_date OUT NOCOPY jtf_date_table,
8503: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8504: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8505: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8506: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8507: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8508: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
8501: x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
8502: x_redeemed_date OUT NOCOPY jtf_date_table,
8503: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8504: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8505: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8506: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8507: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8508: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
8509: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
8502: x_redeemed_date OUT NOCOPY jtf_date_table,
8503: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8504: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8505: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8506: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8507: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8508: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
8509: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
8510: --*/
8503: x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
8504: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8505: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8506: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8507: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8508: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
8509: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
8510: --*/
8511: )
8504: x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
8505: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8506: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8507: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8508: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
8509: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
8510: --*/
8511: )
8512: AS
8505: x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
8506: x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
8507: x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
8508: x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
8509: x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
8510: --*/
8511: )
8512: AS
8513: ddindx binary_integer; indx binary_integer;
8514: BEGIN
8515: x_price_adjustment_id := jtf_number_table();
8516:
8517: /*-- The following output parameters are ignored
8518: x_operation_code := jtf_varchar2_table_100();
8519: x_qte_line_index := jtf_number_table();
8520: x_shipment_index := jtf_number_table();
8521: x_creation_date := jtf_date_table();
8522: x_created_by := jtf_number_table();
8531: x_quote_line_id := jtf_number_table();
8532: x_quote_shipment_id := jtf_number_table();
8533: x_modifier_header_id := jtf_number_table();
8534: x_modifier_line_id := jtf_number_table();
8535: x_modifier_line_type_code := jtf_varchar2_table_100();
8536: x_modifier_mechanism_type_code := jtf_varchar2_table_100();
8537: x_modified_from := jtf_number_table();
8538: x_modified_to := jtf_number_table();
8539: x_operand := jtf_number_table();
8532: x_quote_shipment_id := jtf_number_table();
8533: x_modifier_header_id := jtf_number_table();
8534: x_modifier_line_id := jtf_number_table();
8535: x_modifier_line_type_code := jtf_varchar2_table_100();
8536: x_modifier_mechanism_type_code := jtf_varchar2_table_100();
8537: x_modified_from := jtf_number_table();
8538: x_modified_to := jtf_number_table();
8539: x_operand := jtf_number_table();
8540: x_arithmetic_operator := jtf_varchar2_table_100();
8536: x_modifier_mechanism_type_code := jtf_varchar2_table_100();
8537: x_modified_from := jtf_number_table();
8538: x_modified_to := jtf_number_table();
8539: x_operand := jtf_number_table();
8540: x_arithmetic_operator := jtf_varchar2_table_100();
8541: x_automatic_flag := jtf_varchar2_table_100();
8542: x_update_allowable_flag := jtf_varchar2_table_100();
8543: x_updated_flag := jtf_varchar2_table_100();
8544: x_applied_flag := jtf_varchar2_table_100();
8537: x_modified_from := jtf_number_table();
8538: x_modified_to := jtf_number_table();
8539: x_operand := jtf_number_table();
8540: x_arithmetic_operator := jtf_varchar2_table_100();
8541: x_automatic_flag := jtf_varchar2_table_100();
8542: x_update_allowable_flag := jtf_varchar2_table_100();
8543: x_updated_flag := jtf_varchar2_table_100();
8544: x_applied_flag := jtf_varchar2_table_100();
8545: x_on_invoice_flag := jtf_varchar2_table_100();
8538: x_modified_to := jtf_number_table();
8539: x_operand := jtf_number_table();
8540: x_arithmetic_operator := jtf_varchar2_table_100();
8541: x_automatic_flag := jtf_varchar2_table_100();
8542: x_update_allowable_flag := jtf_varchar2_table_100();
8543: x_updated_flag := jtf_varchar2_table_100();
8544: x_applied_flag := jtf_varchar2_table_100();
8545: x_on_invoice_flag := jtf_varchar2_table_100();
8546: x_pricing_phase_id := jtf_number_table();
8539: x_operand := jtf_number_table();
8540: x_arithmetic_operator := jtf_varchar2_table_100();
8541: x_automatic_flag := jtf_varchar2_table_100();
8542: x_update_allowable_flag := jtf_varchar2_table_100();
8543: x_updated_flag := jtf_varchar2_table_100();
8544: x_applied_flag := jtf_varchar2_table_100();
8545: x_on_invoice_flag := jtf_varchar2_table_100();
8546: x_pricing_phase_id := jtf_number_table();
8547: x_attribute_category := jtf_varchar2_table_100();
8540: x_arithmetic_operator := jtf_varchar2_table_100();
8541: x_automatic_flag := jtf_varchar2_table_100();
8542: x_update_allowable_flag := jtf_varchar2_table_100();
8543: x_updated_flag := jtf_varchar2_table_100();
8544: x_applied_flag := jtf_varchar2_table_100();
8545: x_on_invoice_flag := jtf_varchar2_table_100();
8546: x_pricing_phase_id := jtf_number_table();
8547: x_attribute_category := jtf_varchar2_table_100();
8548: x_attribute1 := jtf_varchar2_table_200();
8541: x_automatic_flag := jtf_varchar2_table_100();
8542: x_update_allowable_flag := jtf_varchar2_table_100();
8543: x_updated_flag := jtf_varchar2_table_100();
8544: x_applied_flag := jtf_varchar2_table_100();
8545: x_on_invoice_flag := jtf_varchar2_table_100();
8546: x_pricing_phase_id := jtf_number_table();
8547: x_attribute_category := jtf_varchar2_table_100();
8548: x_attribute1 := jtf_varchar2_table_200();
8549: x_attribute2 := jtf_varchar2_table_200();
8543: x_updated_flag := jtf_varchar2_table_100();
8544: x_applied_flag := jtf_varchar2_table_100();
8545: x_on_invoice_flag := jtf_varchar2_table_100();
8546: x_pricing_phase_id := jtf_number_table();
8547: x_attribute_category := jtf_varchar2_table_100();
8548: x_attribute1 := jtf_varchar2_table_200();
8549: x_attribute2 := jtf_varchar2_table_200();
8550: x_attribute3 := jtf_varchar2_table_200();
8551: x_attribute4 := jtf_varchar2_table_200();
8559: x_attribute12 := jtf_varchar2_table_200();
8560: x_attribute13 := jtf_varchar2_table_200();
8561: x_attribute14 := jtf_varchar2_table_200();
8562: x_attribute15 := jtf_varchar2_table_200();
8563: x_orig_sys_discount_ref := jtf_varchar2_table_100();
8564: x_change_sequence := jtf_varchar2_table_100();
8565: x_update_allowed := jtf_varchar2_table_100();
8566: x_change_reason_code := jtf_varchar2_table_100();
8567: x_change_reason_text := jtf_varchar2_table_2000();
8560: x_attribute13 := jtf_varchar2_table_200();
8561: x_attribute14 := jtf_varchar2_table_200();
8562: x_attribute15 := jtf_varchar2_table_200();
8563: x_orig_sys_discount_ref := jtf_varchar2_table_100();
8564: x_change_sequence := jtf_varchar2_table_100();
8565: x_update_allowed := jtf_varchar2_table_100();
8566: x_change_reason_code := jtf_varchar2_table_100();
8567: x_change_reason_text := jtf_varchar2_table_2000();
8568: x_cost_id := jtf_number_table();
8561: x_attribute14 := jtf_varchar2_table_200();
8562: x_attribute15 := jtf_varchar2_table_200();
8563: x_orig_sys_discount_ref := jtf_varchar2_table_100();
8564: x_change_sequence := jtf_varchar2_table_100();
8565: x_update_allowed := jtf_varchar2_table_100();
8566: x_change_reason_code := jtf_varchar2_table_100();
8567: x_change_reason_text := jtf_varchar2_table_2000();
8568: x_cost_id := jtf_number_table();
8569: x_tax_code := jtf_varchar2_table_100();
8562: x_attribute15 := jtf_varchar2_table_200();
8563: x_orig_sys_discount_ref := jtf_varchar2_table_100();
8564: x_change_sequence := jtf_varchar2_table_100();
8565: x_update_allowed := jtf_varchar2_table_100();
8566: x_change_reason_code := jtf_varchar2_table_100();
8567: x_change_reason_text := jtf_varchar2_table_2000();
8568: x_cost_id := jtf_number_table();
8569: x_tax_code := jtf_varchar2_table_100();
8570: x_tax_exempt_flag := jtf_varchar2_table_100();
8565: x_update_allowed := jtf_varchar2_table_100();
8566: x_change_reason_code := jtf_varchar2_table_100();
8567: x_change_reason_text := jtf_varchar2_table_2000();
8568: x_cost_id := jtf_number_table();
8569: x_tax_code := jtf_varchar2_table_100();
8570: x_tax_exempt_flag := jtf_varchar2_table_100();
8571: x_tax_exempt_number := jtf_varchar2_table_100();
8572: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8573: x_parent_adjustment_id := jtf_number_table();
8566: x_change_reason_code := jtf_varchar2_table_100();
8567: x_change_reason_text := jtf_varchar2_table_2000();
8568: x_cost_id := jtf_number_table();
8569: x_tax_code := jtf_varchar2_table_100();
8570: x_tax_exempt_flag := jtf_varchar2_table_100();
8571: x_tax_exempt_number := jtf_varchar2_table_100();
8572: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8573: x_parent_adjustment_id := jtf_number_table();
8574: x_invoiced_flag := jtf_varchar2_table_100();
8567: x_change_reason_text := jtf_varchar2_table_2000();
8568: x_cost_id := jtf_number_table();
8569: x_tax_code := jtf_varchar2_table_100();
8570: x_tax_exempt_flag := jtf_varchar2_table_100();
8571: x_tax_exempt_number := jtf_varchar2_table_100();
8572: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8573: x_parent_adjustment_id := jtf_number_table();
8574: x_invoiced_flag := jtf_varchar2_table_100();
8575: x_estimated_flag := jtf_varchar2_table_100();
8568: x_cost_id := jtf_number_table();
8569: x_tax_code := jtf_varchar2_table_100();
8570: x_tax_exempt_flag := jtf_varchar2_table_100();
8571: x_tax_exempt_number := jtf_varchar2_table_100();
8572: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8573: x_parent_adjustment_id := jtf_number_table();
8574: x_invoiced_flag := jtf_varchar2_table_100();
8575: x_estimated_flag := jtf_varchar2_table_100();
8576: x_inc_in_sales_performance := jtf_varchar2_table_100();
8570: x_tax_exempt_flag := jtf_varchar2_table_100();
8571: x_tax_exempt_number := jtf_varchar2_table_100();
8572: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8573: x_parent_adjustment_id := jtf_number_table();
8574: x_invoiced_flag := jtf_varchar2_table_100();
8575: x_estimated_flag := jtf_varchar2_table_100();
8576: x_inc_in_sales_performance := jtf_varchar2_table_100();
8577: x_split_action_code := jtf_varchar2_table_100();
8578: x_adjusted_amount := jtf_number_table();
8571: x_tax_exempt_number := jtf_varchar2_table_100();
8572: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8573: x_parent_adjustment_id := jtf_number_table();
8574: x_invoiced_flag := jtf_varchar2_table_100();
8575: x_estimated_flag := jtf_varchar2_table_100();
8576: x_inc_in_sales_performance := jtf_varchar2_table_100();
8577: x_split_action_code := jtf_varchar2_table_100();
8578: x_adjusted_amount := jtf_number_table();
8579: x_charge_type_code := jtf_varchar2_table_100();
8572: x_tax_exempt_reason_code := jtf_varchar2_table_100();
8573: x_parent_adjustment_id := jtf_number_table();
8574: x_invoiced_flag := jtf_varchar2_table_100();
8575: x_estimated_flag := jtf_varchar2_table_100();
8576: x_inc_in_sales_performance := jtf_varchar2_table_100();
8577: x_split_action_code := jtf_varchar2_table_100();
8578: x_adjusted_amount := jtf_number_table();
8579: x_charge_type_code := jtf_varchar2_table_100();
8580: x_charge_subtype_code := jtf_varchar2_table_100();
8573: x_parent_adjustment_id := jtf_number_table();
8574: x_invoiced_flag := jtf_varchar2_table_100();
8575: x_estimated_flag := jtf_varchar2_table_100();
8576: x_inc_in_sales_performance := jtf_varchar2_table_100();
8577: x_split_action_code := jtf_varchar2_table_100();
8578: x_adjusted_amount := jtf_number_table();
8579: x_charge_type_code := jtf_varchar2_table_100();
8580: x_charge_subtype_code := jtf_varchar2_table_100();
8581: x_range_break_quantity := jtf_number_table();
8575: x_estimated_flag := jtf_varchar2_table_100();
8576: x_inc_in_sales_performance := jtf_varchar2_table_100();
8577: x_split_action_code := jtf_varchar2_table_100();
8578: x_adjusted_amount := jtf_number_table();
8579: x_charge_type_code := jtf_varchar2_table_100();
8580: x_charge_subtype_code := jtf_varchar2_table_100();
8581: x_range_break_quantity := jtf_number_table();
8582: x_accrual_conversion_rate := jtf_number_table();
8583: x_pricing_group_sequence := jtf_number_table();
8576: x_inc_in_sales_performance := jtf_varchar2_table_100();
8577: x_split_action_code := jtf_varchar2_table_100();
8578: x_adjusted_amount := jtf_number_table();
8579: x_charge_type_code := jtf_varchar2_table_100();
8580: x_charge_subtype_code := jtf_varchar2_table_100();
8581: x_range_break_quantity := jtf_number_table();
8582: x_accrual_conversion_rate := jtf_number_table();
8583: x_pricing_group_sequence := jtf_number_table();
8584: x_accrual_flag := jtf_varchar2_table_100();
8580: x_charge_subtype_code := jtf_varchar2_table_100();
8581: x_range_break_quantity := jtf_number_table();
8582: x_accrual_conversion_rate := jtf_number_table();
8583: x_pricing_group_sequence := jtf_number_table();
8584: x_accrual_flag := jtf_varchar2_table_100();
8585: x_list_line_no := jtf_varchar2_table_300();
8586: x_source_system_code := jtf_varchar2_table_100();
8587: x_benefit_qty := jtf_number_table();
8588: x_benefit_uom_code := jtf_varchar2_table_100();
8582: x_accrual_conversion_rate := jtf_number_table();
8583: x_pricing_group_sequence := jtf_number_table();
8584: x_accrual_flag := jtf_varchar2_table_100();
8585: x_list_line_no := jtf_varchar2_table_300();
8586: x_source_system_code := jtf_varchar2_table_100();
8587: x_benefit_qty := jtf_number_table();
8588: x_benefit_uom_code := jtf_varchar2_table_100();
8589: x_print_on_invoice_flag := jtf_varchar2_table_100();
8590: x_expiration_date := jtf_date_table();
8584: x_accrual_flag := jtf_varchar2_table_100();
8585: x_list_line_no := jtf_varchar2_table_300();
8586: x_source_system_code := jtf_varchar2_table_100();
8587: x_benefit_qty := jtf_number_table();
8588: x_benefit_uom_code := jtf_varchar2_table_100();
8589: x_print_on_invoice_flag := jtf_varchar2_table_100();
8590: x_expiration_date := jtf_date_table();
8591: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8592: x_rebate_transaction_reference := jtf_varchar2_table_100();
8585: x_list_line_no := jtf_varchar2_table_300();
8586: x_source_system_code := jtf_varchar2_table_100();
8587: x_benefit_qty := jtf_number_table();
8588: x_benefit_uom_code := jtf_varchar2_table_100();
8589: x_print_on_invoice_flag := jtf_varchar2_table_100();
8590: x_expiration_date := jtf_date_table();
8591: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8592: x_rebate_transaction_reference := jtf_varchar2_table_100();
8593: x_rebate_payment_system_code := jtf_varchar2_table_100();
8587: x_benefit_qty := jtf_number_table();
8588: x_benefit_uom_code := jtf_varchar2_table_100();
8589: x_print_on_invoice_flag := jtf_varchar2_table_100();
8590: x_expiration_date := jtf_date_table();
8591: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8592: x_rebate_transaction_reference := jtf_varchar2_table_100();
8593: x_rebate_payment_system_code := jtf_varchar2_table_100();
8594: x_redeemed_date := jtf_date_table();
8595: x_redeemed_flag := jtf_varchar2_table_100();
8588: x_benefit_uom_code := jtf_varchar2_table_100();
8589: x_print_on_invoice_flag := jtf_varchar2_table_100();
8590: x_expiration_date := jtf_date_table();
8591: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8592: x_rebate_transaction_reference := jtf_varchar2_table_100();
8593: x_rebate_payment_system_code := jtf_varchar2_table_100();
8594: x_redeemed_date := jtf_date_table();
8595: x_redeemed_flag := jtf_varchar2_table_100();
8596: x_modifier_level_code := jtf_varchar2_table_100();
8589: x_print_on_invoice_flag := jtf_varchar2_table_100();
8590: x_expiration_date := jtf_date_table();
8591: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8592: x_rebate_transaction_reference := jtf_varchar2_table_100();
8593: x_rebate_payment_system_code := jtf_varchar2_table_100();
8594: x_redeemed_date := jtf_date_table();
8595: x_redeemed_flag := jtf_varchar2_table_100();
8596: x_modifier_level_code := jtf_varchar2_table_100();
8597: x_price_break_type_code := jtf_varchar2_table_100();
8591: x_rebate_transaction_type_code := jtf_varchar2_table_100();
8592: x_rebate_transaction_reference := jtf_varchar2_table_100();
8593: x_rebate_payment_system_code := jtf_varchar2_table_100();
8594: x_redeemed_date := jtf_date_table();
8595: x_redeemed_flag := jtf_varchar2_table_100();
8596: x_modifier_level_code := jtf_varchar2_table_100();
8597: x_price_break_type_code := jtf_varchar2_table_100();
8598: x_substitution_attribute := jtf_varchar2_table_100();
8599: x_proration_type_code := jtf_varchar2_table_100();
8592: x_rebate_transaction_reference := jtf_varchar2_table_100();
8593: x_rebate_payment_system_code := jtf_varchar2_table_100();
8594: x_redeemed_date := jtf_date_table();
8595: x_redeemed_flag := jtf_varchar2_table_100();
8596: x_modifier_level_code := jtf_varchar2_table_100();
8597: x_price_break_type_code := jtf_varchar2_table_100();
8598: x_substitution_attribute := jtf_varchar2_table_100();
8599: x_proration_type_code := jtf_varchar2_table_100();
8600: x_include_on_returns_flag := jtf_varchar2_table_100();
8593: x_rebate_payment_system_code := jtf_varchar2_table_100();
8594: x_redeemed_date := jtf_date_table();
8595: x_redeemed_flag := jtf_varchar2_table_100();
8596: x_modifier_level_code := jtf_varchar2_table_100();
8597: x_price_break_type_code := jtf_varchar2_table_100();
8598: x_substitution_attribute := jtf_varchar2_table_100();
8599: x_proration_type_code := jtf_varchar2_table_100();
8600: x_include_on_returns_flag := jtf_varchar2_table_100();
8601: x_credit_or_charge_flag := jtf_varchar2_table_100();
8594: x_redeemed_date := jtf_date_table();
8595: x_redeemed_flag := jtf_varchar2_table_100();
8596: x_modifier_level_code := jtf_varchar2_table_100();
8597: x_price_break_type_code := jtf_varchar2_table_100();
8598: x_substitution_attribute := jtf_varchar2_table_100();
8599: x_proration_type_code := jtf_varchar2_table_100();
8600: x_include_on_returns_flag := jtf_varchar2_table_100();
8601: x_credit_or_charge_flag := jtf_varchar2_table_100();
8602: --*/
8595: x_redeemed_flag := jtf_varchar2_table_100();
8596: x_modifier_level_code := jtf_varchar2_table_100();
8597: x_price_break_type_code := jtf_varchar2_table_100();
8598: x_substitution_attribute := jtf_varchar2_table_100();
8599: x_proration_type_code := jtf_varchar2_table_100();
8600: x_include_on_returns_flag := jtf_varchar2_table_100();
8601: x_credit_or_charge_flag := jtf_varchar2_table_100();
8602: --*/
8603:
8596: x_modifier_level_code := jtf_varchar2_table_100();
8597: x_price_break_type_code := jtf_varchar2_table_100();
8598: x_substitution_attribute := jtf_varchar2_table_100();
8599: x_proration_type_code := jtf_varchar2_table_100();
8600: x_include_on_returns_flag := jtf_varchar2_table_100();
8601: x_credit_or_charge_flag := jtf_varchar2_table_100();
8602: --*/
8603:
8604: IF p_qte_price_adj_tbl.count > 0 THEN
8597: x_price_break_type_code := jtf_varchar2_table_100();
8598: x_substitution_attribute := jtf_varchar2_table_100();
8599: x_proration_type_code := jtf_varchar2_table_100();
8600: x_include_on_returns_flag := jtf_varchar2_table_100();
8601: x_credit_or_charge_flag := jtf_varchar2_table_100();
8602: --*/
8603:
8604: IF p_qte_price_adj_tbl.count > 0 THEN
8605: x_price_adjustment_id.extend(p_qte_price_adj_tbl.count);
8798: p_qte_price_attributes_tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type,
8799: x_price_attribute_id OUT NOCOPY jtf_number_table
8800:
8801: /*-- The following output parameters are ignored
8802: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
8803: x_qte_line_index OUT NOCOPY jtf_number_table,
8804: x_creation_date OUT NOCOPY jtf_date_table,
8805: x_created_by OUT NOCOPY jtf_number_table,
8806: x_last_update_date OUT NOCOPY jtf_date_table,
8811: x_program_id OUT NOCOPY jtf_number_table,
8812: x_program_update_date OUT NOCOPY jtf_date_table,
8813: x_quote_header_id OUT NOCOPY jtf_number_table,
8814: x_quote_line_id OUT NOCOPY jtf_number_table,
8815: x_flex_title OUT NOCOPY jtf_varchar2_table_100,
8816: x_pricing_context OUT NOCOPY jtf_varchar2_table_100,
8817: x_pricing_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8818: x_pricing_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8819: x_pricing_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8812: x_program_update_date OUT NOCOPY jtf_date_table,
8813: x_quote_header_id OUT NOCOPY jtf_number_table,
8814: x_quote_line_id OUT NOCOPY jtf_number_table,
8815: x_flex_title OUT NOCOPY jtf_varchar2_table_100,
8816: x_pricing_context OUT NOCOPY jtf_varchar2_table_100,
8817: x_pricing_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8818: x_pricing_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8819: x_pricing_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8820: x_pricing_attribute4 OUT NOCOPY jtf_varchar2_table_200,
8913: x_pricing_attribute97 OUT NOCOPY jtf_varchar2_table_200,
8914: x_pricing_attribute98 OUT NOCOPY jtf_varchar2_table_200,
8915: x_pricing_attribute99 OUT NOCOPY jtf_varchar2_table_200,
8916: x_pricing_attribute100 OUT NOCOPY jtf_varchar2_table_200,
8917: x_context OUT NOCOPY jtf_varchar2_table_100,
8918: x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
8919: x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
8920: x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
8921: x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
8937: BEGIN
8938: x_price_attribute_id := jtf_number_table();
8939:
8940: /*-- The following output parameters are ignored
8941: x_operation_code := jtf_varchar2_table_100();
8942: x_qte_line_index := jtf_number_table();
8943: x_creation_date := jtf_date_table();
8944: x_created_by := jtf_number_table();
8945: x_last_update_date := jtf_date_table();
8950: x_program_id := jtf_number_table();
8951: x_program_update_date := jtf_date_table();
8952: x_quote_header_id := jtf_number_table();
8953: x_quote_line_id := jtf_number_table();
8954: x_flex_title := jtf_varchar2_table_100();
8955: x_pricing_context := jtf_varchar2_table_100();
8956: x_pricing_attribute1 := jtf_varchar2_table_200();
8957: x_pricing_attribute2 := jtf_varchar2_table_200();
8958: x_pricing_attribute3 := jtf_varchar2_table_200();
8951: x_program_update_date := jtf_date_table();
8952: x_quote_header_id := jtf_number_table();
8953: x_quote_line_id := jtf_number_table();
8954: x_flex_title := jtf_varchar2_table_100();
8955: x_pricing_context := jtf_varchar2_table_100();
8956: x_pricing_attribute1 := jtf_varchar2_table_200();
8957: x_pricing_attribute2 := jtf_varchar2_table_200();
8958: x_pricing_attribute3 := jtf_varchar2_table_200();
8959: x_pricing_attribute4 := jtf_varchar2_table_200();
9052: x_pricing_attribute97 := jtf_varchar2_table_200();
9053: x_pricing_attribute98 := jtf_varchar2_table_200();
9054: x_pricing_attribute99 := jtf_varchar2_table_200();
9055: x_pricing_attribute100 := jtf_varchar2_table_200();
9056: x_context := jtf_varchar2_table_100();
9057: x_attribute1 := jtf_varchar2_table_200();
9058: x_attribute2 := jtf_varchar2_table_200();
9059: x_attribute3 := jtf_varchar2_table_200();
9060: x_attribute4 := jtf_varchar2_table_200();
9363: x_sales_credit_id OUT NOCOPY jtf_number_table
9364:
9365: /*-- The following output parameters are ignored
9366: x_qte_line_index OUT NOCOPY jtf_number_table,
9367: x_operation_code OUT NOCOPY jtf_varchar2_table_100,
9368: x_creation_date OUT NOCOPY jtf_date_table,
9369: x_created_by OUT NOCOPY jtf_number_table,
9370: x_last_updated_by OUT NOCOPY jtf_number_table,
9371: x_last_update_date OUT NOCOPY jtf_date_table,
9383: x_sales_credit_type OUT NOCOPY jtf_varchar2_table_300,
9384: x_resource_group_id OUT NOCOPY jtf_number_table,
9385: x_employee_person_id OUT NOCOPY jtf_number_table,
9386: x_sales_credit_type_id OUT NOCOPY jtf_number_table,
9387: x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
9388: x_attribute1 OUT NOCOPY jtf_varchar2_table_300,
9389: x_attribute2 OUT NOCOPY jtf_varchar2_table_300,
9390: x_attribute3 OUT NOCOPY jtf_varchar2_table_300,
9391: x_attribute4 OUT NOCOPY jtf_varchar2_table_300,
9408: x_sales_credit_id := jtf_number_table();
9409:
9410: /*-- The following output parameters are ignored
9411: x_qte_line_index := jtf_number_table();
9412: x_operation_code := jtf_varchar2_table_100();
9413: x_creation_date := jtf_date_table();
9414: x_created_by := jtf_number_table();
9415: x_last_updated_by := jtf_number_table();
9416: x_last_update_date := jtf_date_table();
9428: x_sales_credit_type := jtf_varchar2_table_300();
9429: x_resource_group_id := jtf_number_table();
9430: x_employee_person_id := jtf_number_table();
9431: x_sales_credit_type_id := jtf_number_table();
9432: x_attribute_category := jtf_varchar2_table_100();
9433: x_attribute1 := jtf_varchar2_table_300();
9434: x_attribute2 := jtf_varchar2_table_300();
9435: x_attribute3 := jtf_varchar2_table_300();
9436: x_attribute4 := jtf_varchar2_table_300();
9552: x_approver_person_id OUT NOCOPY jtf_number_table,
9553: x_approver_user_id OUT NOCOPY jtf_number_table,
9554: x_notification_id OUT NOCOPY jtf_number_table,
9555: x_approver_sequence OUT NOCOPY jtf_number_table,
9556: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
9557: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
9558: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
9559: x_date_sent OUT NOCOPY jtf_date_table,
9560: x_date_received OUT NOCOPY jtf_date_table
9553: x_approver_user_id OUT NOCOPY jtf_number_table,
9554: x_notification_id OUT NOCOPY jtf_number_table,
9555: x_approver_sequence OUT NOCOPY jtf_number_table,
9556: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
9557: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
9558: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
9559: x_date_sent OUT NOCOPY jtf_date_table,
9560: x_date_received OUT NOCOPY jtf_date_table
9561: )
9567: x_approver_person_id := jtf_number_table();
9568: x_approver_user_id := jtf_number_table();
9569: x_notification_id := jtf_number_table();
9570: x_approver_sequence := jtf_number_table();
9571: x_approver_status := jtf_varchar2_table_100();
9572: x_approver_name := jtf_varchar2_table_100();
9573: x_approval_comments := jtf_varchar2_table_300();
9574: x_date_sent := jtf_date_table();
9575: x_date_received := jtf_date_table();
9568: x_approver_user_id := jtf_number_table();
9569: x_notification_id := jtf_number_table();
9570: x_approver_sequence := jtf_number_table();
9571: x_approver_status := jtf_varchar2_table_100();
9572: x_approver_name := jtf_varchar2_table_100();
9573: x_approval_comments := jtf_varchar2_table_300();
9574: x_date_sent := jtf_date_table();
9575: x_date_received := jtf_date_table();
9576: IF p_qte_approvers_list_tbl.count > 0 THEN
9732: x_identifier OUT NOCOPY JTF_NUMBER_TABLE,
9733: x_customer_id OUT NOCOPY JTF_NUMBER_TABLE,
9734: x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
9735: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
9736: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9737: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9738: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
9739: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
9740: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9733: x_customer_id OUT NOCOPY JTF_NUMBER_TABLE,
9734: x_customer_site_id OUT NOCOPY JTF_NUMBER_TABLE,
9735: x_quantity_ordered OUT NOCOPY JTF_NUMBER_TABLE,
9736: x_quantity_uom OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9737: x_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
9738: x_requested_ship_date OUT NOCOPY JTF_DATE_TABLE,
9739: x_ship_date OUT NOCOPY JTF_DATE_TABLE,
9740: x_available_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9741: x_request_date_quantity OUT NOCOPY JTF_NUMBER_TABLE,
9787: x_identifier := JTF_NUMBER_TABLE();
9788: x_customer_id := JTF_NUMBER_TABLE();
9789: x_customer_site_id := JTF_NUMBER_TABLE();
9790: x_quantity_ordered := JTF_NUMBER_TABLE();
9791: x_quantity_uom := JTF_VARCHAR2_TABLE_100();
9792: x_uom_meaning := JTF_VARCHAR2_TABLE_100();
9793: x_requested_ship_date := JTF_DATE_TABLE();
9794: x_ship_date := JTF_DATE_TABLE();
9795: x_available_quantity := JTF_NUMBER_TABLE();
9788: x_customer_id := JTF_NUMBER_TABLE();
9789: x_customer_site_id := JTF_NUMBER_TABLE();
9790: x_quantity_ordered := JTF_NUMBER_TABLE();
9791: x_quantity_uom := JTF_VARCHAR2_TABLE_100();
9792: x_uom_meaning := JTF_VARCHAR2_TABLE_100();
9793: x_requested_ship_date := JTF_DATE_TABLE();
9794: x_ship_date := JTF_DATE_TABLE();
9795: x_available_quantity := JTF_NUMBER_TABLE();
9796: x_request_date_quantity := JTF_NUMBER_TABLE();
10057:
10058:
10059:
10060: FUNCTION Construct_Trigger_Attr_Tbl(
10061: p_trigger_attribute IN jtf_varchar2_table_100 := NULL
10062: )
10063: RETURN ASO_Defaulting_Int.Attribute_Codes_Tbl_Type
10064: IS
10065: l_trigger_attr_tbl ASO_Defaulting_Int.ATTRIBUTE_CODES_TBL_TYPE;
10991:
10992: END Set_num_Tbl_Out;
10993:
10994: FUNCTION Construct_Related_Obj_Tbl(
10995: p_operation_code IN jtf_varchar2_table_100 := NULL,
10996: p_RELATED_OBJECT_ID IN jtf_number_table := NULL,
10997: p_CREATION_DATE IN jtf_date_table := null,
10998: p_CREATED_BY IN jtf_number_table := NULL,
10999: p_LAST_UPDATE_DATE IN jtf_date_table := null,
11007: p_QUOTE_OBJECT_ID IN jtf_number_table := NULL,
11008: p_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
11009: p_OBJECT_ID IN jtf_number_table := NULL,
11010: p_RELATIONSHIP_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
11011: p_RECIPROCAL_FLAG IN jtf_varchar2_table_100 := NULL,
11012: p_QUOTE_OBJECT_CODE IN jtf_number_table := NULL,
11013: p_OBJECT_VERSION_NUMBER IN jtf_number_table := NULL
11014: )
11015: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type