[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
/* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */
p_ql_creation_date IN jtf_date_table := NULL,
p_ql_created_by IN jtf_number_table := NULL,
p_ql_last_updated_by IN jtf_number_table := NULL,
p_ql_last_update_date IN jtf_date_table := NULL,
p_ql_last_update_login IN jtf_number_table := NULL,
p_ql_request_id IN jtf_number_table := NULL,
p_ql_program_application_id IN jtf_number_table := NULL,
p_ql_program_id IN jtf_number_table := NULL,
p_ql_program_update_date IN jtf_date_table := NULL,
p_ql_quote_line_id IN jtf_number_table := NULL,
p_ql_quote_header_id IN jtf_number_table := NULL,
p_ql_org_id IN jtf_number_table := NULL,
p_ql_line_number IN jtf_number_table := NULL,
p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
p_ql_inventory_item_id IN jtf_number_table := NULL,
p_ql_organization_id IN jtf_number_table := NULL,
p_ql_quantity IN jtf_number_table := NULL,
p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
p_ql_start_date_active IN jtf_date_table := NULL,
p_ql_end_date_active IN jtf_date_table := NULL,
p_ql_order_line_type_id IN jtf_number_table := NULL,
p_ql_price_list_id IN jtf_number_table := NULL,
p_ql_price_list_line_id IN jtf_number_table := NULL,
p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
p_ql_line_list_price IN jtf_number_table := NULL,
p_ql_line_adjusted_amount IN jtf_number_table := NULL,
p_ql_line_adjusted_percent IN jtf_number_table := NULL,
p_ql_line_quote_price IN jtf_number_table := NULL,
p_ql_related_item_id IN jtf_number_table := NULL,
p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute5 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute6 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute7 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute8 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute9 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute10 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute11 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute12 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute13 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute14 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute15 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute16 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute17 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute18 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute19 IN jtf_varchar2_table_300 := NULL,
p_ql_attribute20 IN jtf_varchar2_table_300 := NULL,
p_ql_accounting_rule_id IN jtf_number_table := NULL,
p_ql_ffm_content_name IN jtf_varchar2_table_300 := NULL,
p_ql_ffm_content_type IN jtf_varchar2_table_300 := NULL,
p_ql_ffm_document_type IN jtf_varchar2_table_300 := NULL,
p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
p_ql_invoice_to_party_id IN jtf_number_table := NULL,
p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
p_ql_invoicing_rule_id IN jtf_number_table := NULL,
p_ql_marketing_source_code_id IN jtf_number_table := NULL,
p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
p_ql_minisite_id IN jtf_number_table := NULL,
p_ql_section_id IN jtf_number_table := NULL,
p_ql_priced_price_list_id IN jtf_number_table := NULL,
p_ql_agreement_id IN jtf_number_table := NULL,
p_ql_commitment_id IN jtf_number_table := NULL,
p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
/* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
p_qls_qte_line_index IN jtf_number_table := NULL,
p_qls_shipment_id IN jtf_number_table := NULL,
p_qls_creation_date IN jtf_date_table := NULL,
p_qls_created_by IN jtf_number_table := NULL,
p_qls_last_update_date IN jtf_date_table := NULL,
p_qls_last_updated_by IN jtf_number_table := NULL,
p_qls_last_update_login IN jtf_number_table := NULL,
p_qls_request_id IN jtf_number_table := NULL,
p_qls_program_application_id IN jtf_number_table := NULL,
p_qls_program_id IN jtf_number_table := NULL,
p_qls_program_update_date IN jtf_date_table := NULL,
p_qls_quote_header_id IN jtf_number_table := NULL,
p_qls_quote_line_id IN jtf_number_table := NULL,
p_qls_promise_date IN jtf_date_table := NULL,
p_qls_request_date IN jtf_date_table := NULL,
p_qls_schedule_ship_date IN jtf_date_table := NULL,
p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
p_qls_ship_to_party_id IN jtf_number_table := NULL,
p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
p_qls_ship_set_id IN jtf_number_table := NULL,
p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
p_qls_quantity IN jtf_number_table := NULL,
p_qls_reserved_quantity IN jtf_varchar2_table_300 := NULL,
p_qls_reservation_id IN jtf_number_table := NULL,
p_qls_order_line_id IN jtf_number_table := NULL,
p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
p_qls_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
p_qls_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
p_qls_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
p_qls_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
p_qls_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
p_qls_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
p_qls_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
p_qls_ship_to_country IN jtf_varchar2_table_100 := NULL,
p_qls_ship_to_city IN jtf_varchar2_table_100 := NULL,
p_qls_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
p_qls_ship_to_state IN jtf_varchar2_table_100 := NULL,
p_qls_ship_to_province IN jtf_varchar2_table_100 := NULL,
p_qls_ship_to_county IN jtf_varchar2_table_100 := NULL,
p_qls_attribute_category IN jtf_varchar2_table_100 := NULL,
p_qls_attribute1 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute2 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute3 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute4 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute5 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute6 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute7 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute8 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute9 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute10 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute11 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute12 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute13 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute14 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute15 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute16 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute17 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute18 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute19 IN jtf_varchar2_table_300 := NULL,
p_qls_attribute20 IN jtf_varchar2_table_300 := NULL,
p_qls_ship_quote_price IN jtf_number_table := NULL,
p_qls_pricing_quantity IN jtf_number_table := NULL,
p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
p_qls_ship_from_org_id IN jtf_number_table := NULL,
p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
p_qls_object_version_number IN jtf_number_table := NULL,
/* Standard IN parameters */
P_API_VERSION_NUMBER IN NUMBER := 1,
P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,
P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
/* Standard OUT parameters */
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_MSG_COUNT OUT NOCOPY NUMBER,
X_MSG_DATA OUT NOCOPY VARCHAR2
)
IS
l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
:= ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
SELECT csua.site_use_id
FROM HZ_PARTY_SITES ps,
HZ_CUST_ACCT_SITES_ALL casa,
HZ_CUST_SITE_USES_ALL csua
WHERE ps.party_site_id = casa.party_site_id
AND casa.cust_acct_site_id = csua.cust_acct_site_id
AND ps.party_site_id = l_party_site_id;
p_last_updated_by => p_q_last_updated_by ,
p_last_update_date => p_q_last_update_date ,
p_last_update_login => p_q_last_update_login ,
p_request_id => p_q_request_id ,
p_program_application_id => p_q_program_application_id ,
p_program_id => p_q_program_id ,
p_program_update_date => p_q_program_update_date ,
p_org_id => p_q_org_id ,
p_quote_name => p_q_quote_name ,
p_quote_number => p_q_quote_number ,
p_quote_version => p_q_quote_version ,
p_quote_status_id => p_q_quote_status_id ,
p_quote_source_code => p_q_quote_source_code ,
p_quote_expiration_date => p_q_quote_expiration_date ,
p_price_frozen_date => p_q_price_frozen_date ,
p_quote_password => p_q_quote_password ,
p_original_system_reference => p_q_original_system_reference ,
p_party_id => p_q_party_id ,
p_cust_account_id => p_q_cust_account_id ,
p_invoice_to_cust_account_id => p_q_invoice_to_cust_acct_id ,
p_org_contact_id => p_q_org_contact_id ,
p_party_name => p_q_party_name ,
p_party_type => p_q_party_type ,
p_person_first_name => p_q_person_first_name ,
p_person_last_name => p_q_person_last_name ,
p_person_middle_name => p_q_person_middle_name ,
p_phone_id => p_q_phone_id ,
p_price_list_id => p_q_price_list_id ,
p_price_list_name => p_q_price_list_name ,
p_currency_code => p_q_currency_code ,
p_total_list_price => p_q_total_list_price ,
p_total_adjusted_amount => p_q_total_adjusted_amount ,
p_total_adjusted_percent => p_q_total_adjusted_percent ,
p_total_tax => p_q_total_tax ,
p_total_shipping_charge => p_q_total_shipping_charge ,
p_surcharge => p_q_surcharge ,
p_total_quote_price => p_q_total_quote_price ,
p_payment_amount => p_q_payment_amount ,
p_accounting_rule_id => p_q_accounting_rule_id ,
p_exchange_rate => p_q_exchange_rate ,
p_exchange_type_code => p_q_exchange_type_code ,
p_exchange_rate_date => p_q_exchange_rate_date ,
p_quote_category_code => p_q_quote_category_code ,
p_quote_status_code => p_q_quote_status_code ,
p_quote_status => p_q_quote_status ,
p_employee_person_id => p_q_employee_person_id ,
p_sales_channel_code => p_q_sales_channel_code ,
p_salesrep_first_name => p_q_salesrep_first_name ,
p_salesrep_last_name => p_q_salesrep_last_name ,
p_attribute_category => p_q_attribute_category ,
p_attribute1 => p_q_attribute1 ,
p_attribute10 => p_q_attribute10 ,
p_attribute11 => p_q_attribute11 ,
p_attribute12 => p_q_attribute12 ,
p_attribute13 => p_q_attribute13 ,
p_attribute14 => p_q_attribute14 ,
p_attribute15 => p_q_attribute15 ,
p_attribute16 => p_q_attribute16 ,
p_attribute17 => p_q_attribute17 ,
p_attribute18 => p_q_attribute18 ,
p_attribute19 => p_q_attribute19 ,
p_attribute20 => p_q_attribute20 ,
p_attribute2 => p_q_attribute2 ,
p_attribute3 => p_q_attribute3 ,
p_attribute4 => p_q_attribute4 ,
p_attribute5 => p_q_attribute5 ,
p_attribute6 => p_q_attribute6 ,
p_attribute7 => p_q_attribute7 ,
p_attribute8 => p_q_attribute8 ,
p_attribute9 => p_q_attribute9 ,
p_contract_id => p_q_contract_id ,
p_qte_contract_id => p_q_qte_contract_id ,
p_ffm_request_id => p_q_ffm_request_id ,
p_invoice_to_address1 => p_q_invoice_to_address1 ,
p_invoice_to_address2 => p_q_invoice_to_address2 ,
p_invoice_to_address3 => p_q_invoice_to_address3 ,
p_invoice_to_address4 => p_q_invoice_to_address4 ,
p_invoice_to_city => p_q_invoice_to_city ,
p_invoice_to_cont_first_name => p_q_invoice_to_cont_first_name,
p_invoice_to_cont_last_name => p_q_invoice_to_cont_last_name ,
p_invoice_to_cont_mid_name => p_q_invoice_to_cont_mid_name ,
p_invoice_to_country_code => p_q_invoice_to_country_code ,
p_invoice_to_country => p_q_invoice_to_country ,
p_invoice_to_county => p_q_invoice_to_county ,
p_invoice_to_party_id => p_q_invoice_to_party_id ,
p_invoice_to_party_name => p_q_invoice_to_party_name ,
p_invoice_to_party_site_id => p_q_invoice_to_party_site_id ,
p_invoice_to_postal_code => p_q_invoice_to_postal_code ,
p_invoice_to_province => p_q_invoice_to_province ,
p_invoice_to_state => p_q_invoice_to_state ,
p_invoicing_rule_id => p_q_invoicing_rule_id ,
p_marketing_source_code_id => p_q_marketing_source_code_id ,
p_marketing_source_code => p_q_marketing_source_code ,
p_marketing_source_name => p_q_marketing_source_name ,
p_orig_mktg_source_code_id => p_q_orig_mktg_source_code_id ,
p_order_type_id => p_q_order_type_id ,
p_order_id => p_q_order_id ,
p_order_number => p_q_order_number ,
p_order_type_name => p_q_order_type_name ,
p_ordered_date => p_q_ordered_date ,
p_resource_id => p_q_resource_id ,
p_contract_template_id => p_q_contract_template_id ,
p_contract_template_maj_ver => p_q_contract_template_maj_ver ,
p_contract_requester_id => p_q_contract_requester_id ,
p_contract_approval_level => p_q_contract_approval_level ,
p_publish_flag => p_q_publish_flag ,
p_resource_grp_id => p_q_resource_grp_id ,
p_sold_to_party_site_id => p_q_sold_to_party_site_id ,
p_display_arithmetic_operator => p_q_display_arithmetic_op ,
p_quote_description => p_q_quote_description ,
p_quote_type => p_q_quote_type ,
p_minisite_id => p_q_minisite_id ,
p_cust_party_id => p_q_cust_party_id ,
p_invoice_to_cust_party_id => p_q_invoice_to_cust_party_id ,
p_pricing_status_indicator => p_q_pricing_status_indicator ,
p_tax_status_indicator => p_q_tax_status_indicator ,
p_price_updated_date => p_q_price_updated_date ,
p_tax_updated_date => p_q_tax_updated_date ,
p_recalculate_flag => p_q_recalculate_flag ,
p_price_request_id => p_q_price_request_id ,
p_customer_name_and_title => p_q_customer_name_and_title,
p_customer_signature_date => p_q_customer_signature_date,
p_supplier_name_and_title => p_q_supplier_name_and_title,
p_supplier_signature_date => p_q_supplier_signature_date,
p_credit_update_date => p_q_credit_update_date ,
p_automatic_price_flag => p_q_automatic_price_flag,
p_automatic_tax_flag => p_q_automatic_tax_flag,
p_assistance_requested => p_q_assistance_requested,
p_assistance_reason_code => p_q_assistance_reason_code,
p_end_customer_party_id => p_q_end_cust_party_id,
p_end_customer_party_site_id => p_q_end_cust_party_site_id,
p_end_customer_cust_account_id => p_q_end_cust_cust_account_id,
p_end_customer_cust_party_id => p_q_end_cust_cust_party_id,
p_object_version_number => p_q_object_version_number
);
p_last_updated_by => p_ql_last_updated_by ,
p_last_update_date => p_ql_last_update_date ,
p_last_update_login => p_ql_last_update_login ,
p_request_id => p_ql_request_id ,
p_program_application_id => p_ql_program_application_id ,
p_program_id => p_ql_program_id ,
p_program_update_date => p_ql_program_update_date ,
p_quote_line_id => p_ql_quote_line_id ,
p_quote_header_id => p_ql_quote_header_id ,
p_org_id => p_ql_org_id ,
p_line_number => p_ql_line_number ,
p_line_category_code => p_ql_line_category_code ,
p_item_type_code => p_ql_item_type_code ,
p_inventory_item_id => p_ql_inventory_item_id ,
p_organization_id => p_ql_organization_id ,
p_quantity => p_ql_quantity ,
p_uom_code => p_ql_uom_code ,
p_start_date_active => p_ql_start_date_active ,
p_end_date_active => p_ql_end_date_active ,
p_order_line_type_id => p_ql_order_line_type_id ,
p_price_list_id => p_ql_price_list_id ,
p_price_list_line_id => p_ql_price_list_line_id ,
p_currency_code => p_ql_currency_code ,
p_line_list_price => p_ql_line_list_price ,
p_line_adjusted_amount => p_ql_line_adjusted_amount ,
p_line_adjusted_percent => p_ql_line_adjusted_percent ,
p_line_quote_price => p_ql_line_quote_price ,
p_related_item_id => p_ql_related_item_id ,
p_item_relationship_type => p_ql_item_relationship_type ,
p_split_shipment_flag => p_ql_split_shipment_flag ,
p_backorder_flag => p_ql_backorder_flag ,
p_selling_price_change => p_ql_selling_price_change ,
p_recalculate_flag => p_ql_recalculate_flag ,
p_attribute_category => p_ql_attribute_category ,
p_attribute1 => p_ql_attribute1 ,
p_attribute2 => p_ql_attribute2 ,
p_attribute3 => p_ql_attribute3 ,
p_attribute4 => p_ql_attribute4 ,
p_attribute5 => p_ql_attribute5 ,
p_attribute6 => p_ql_attribute6 ,
p_attribute7 => p_ql_attribute7 ,
p_attribute8 => p_ql_attribute8 ,
p_attribute9 => p_ql_attribute9 ,
p_attribute10 => p_ql_attribute10 ,
p_attribute11 => p_ql_attribute11 ,
p_attribute12 => p_ql_attribute12 ,
p_attribute13 => p_ql_attribute13 ,
p_attribute14 => p_ql_attribute14 ,
p_attribute15 => p_ql_attribute15 ,
p_attribute16 => p_ql_attribute16 ,
p_attribute17 => p_ql_attribute17 ,
p_attribute18 => p_ql_attribute18 ,
p_attribute19 => p_ql_attribute19 ,
p_attribute20 => p_ql_attribute20 ,
p_accounting_rule_id => p_ql_accounting_rule_id ,
p_ffm_content_name => p_ql_ffm_content_name ,
p_ffm_content_type => p_ql_ffm_content_type ,
p_ffm_document_type => p_ql_ffm_document_type ,
p_ffm_media_id => p_ql_ffm_media_id ,
p_ffm_media_type => p_ql_ffm_media_type ,
p_ffm_user_note => p_ql_ffm_user_note ,
p_invoice_to_party_id => p_ql_invoice_to_party_id ,
p_invoice_to_party_site_id => p_ql_invoice_to_party_site_id,
p_invoicing_rule_id => p_ql_invoicing_rule_id ,
p_marketing_source_code_id => p_ql_marketing_source_code_id,
p_operation_code => p_ql_operation_code ,
p_invoice_to_cust_account_id => p_ql_invoice_to_cust_acct_id,
p_pricing_quantity_uom => p_ql_pricing_quantity_uom ,
p_minisite_id => p_ql_minisite_id ,
p_section_id => p_ql_section_id ,
p_priced_price_list_id => p_ql_priced_price_list_id ,
p_agreement_id => p_ql_agreement_id ,
p_commitment_id => p_ql_commitment_id ,
p_display_arithmetic_operator => p_ql_display_arithmetic_op,
p_invoice_to_cust_party_id => p_ql_invoice_to_cust_party_id
);
p_last_update_date => p_qls_last_update_date ,
p_last_updated_by => p_qls_last_updated_by ,
p_last_update_login => p_qls_last_update_login ,
p_request_id => p_qls_request_id ,
p_program_application_id => p_qls_program_application_id,
p_program_id => p_qls_program_id ,
p_program_update_date => p_qls_program_update_date ,
p_quote_header_id => p_qls_quote_header_id ,
p_quote_line_id => p_qls_quote_line_id ,
p_promise_date => p_qls_promise_date ,
p_request_date => p_qls_request_date ,
p_schedule_ship_date => p_qls_schedule_ship_date ,
p_ship_to_party_site_id => l_qls_ship_to_party_site_id ,
p_ship_to_party_id => p_qls_ship_to_party_id ,
p_ship_to_cust_account_id => l_qls_ship_to_cust_account_id ,
p_ship_partial_flag => p_qls_ship_partial_flag ,
p_ship_set_id => p_qls_ship_set_id ,
p_ship_method_code => p_qls_ship_method_code ,
p_freight_terms_code => p_qls_freight_terms_code ,
p_freight_carrier_code => p_qls_freight_carrier_code ,
p_fob_code => p_qls_fob_code ,
p_shipping_instructions => p_qls_shipping_instructions ,
p_packing_instructions => p_qls_packing_instructions ,
p_quantity => p_qls_quantity ,
p_reserved_quantity => p_qls_reserved_quantity ,
p_reservation_id => p_qls_reservation_id ,
p_order_line_id => p_qls_order_line_id ,
p_ship_to_party_name => p_qls_ship_to_party_name ,
p_ship_to_cont_first_name => p_qls_ship_to_cont_first_name ,
p_ship_to_cont_mid_name => p_qls_ship_to_cont_mid_name ,
p_ship_to_cont_last_name => p_qls_ship_to_cont_last_name ,
p_ship_to_address1 => p_qls_ship_to_address1 ,
p_ship_to_address2 => p_qls_ship_to_address2 ,
p_ship_to_address3 => p_qls_ship_to_address3 ,
p_ship_to_address4 => p_qls_ship_to_address4 ,
p_ship_to_country_code => p_qls_ship_to_country_code ,
p_ship_to_country => p_qls_ship_to_country ,
p_ship_to_city => p_qls_ship_to_city ,
p_ship_to_postal_code => p_qls_ship_to_postal_code ,
p_ship_to_state => p_qls_ship_to_state ,
p_ship_to_province => p_qls_ship_to_province ,
p_ship_to_county => p_qls_ship_to_county ,
p_attribute_category => p_qls_attribute_category ,
p_attribute1 => p_qls_attribute1 ,
p_attribute2 => p_qls_attribute2 ,
p_attribute3 => p_qls_attribute3 ,
p_attribute4 => p_qls_attribute4 ,
p_attribute5 => p_qls_attribute5 ,
p_attribute6 => p_qls_attribute6 ,
p_attribute7 => p_qls_attribute7 ,
p_attribute8 => p_qls_attribute8 ,
p_attribute9 => p_qls_attribute9 ,
p_attribute10 => p_qls_attribute10 ,
p_attribute11 => p_qls_attribute11 ,
p_attribute12 => p_qls_attribute12 ,
p_attribute13 => p_qls_attribute13 ,
p_attribute14 => p_qls_attribute14 ,
p_attribute15 => p_qls_attribute15 ,
p_attribute16 => p_qls_attribute16 ,
p_attribute17 => p_qls_attribute17 ,
p_attribute18 => p_qls_attribute18 ,
p_attribute19 => p_qls_attribute19 ,
p_attribute20 => p_qls_attribute20 ,
p_ship_quote_price => p_qls_ship_quote_price ,
p_pricing_quantity => p_qls_pricing_quantity ,
p_shipment_priority_code => p_qls_shipment_priority_code,
p_ship_from_org_id => p_qls_ship_from_org_id ,
p_ship_to_cust_party_id => p_qls_ship_to_cust_party_id,
p_request_date_type => p_qls_request_date_type,
p_demand_class_code => p_qls_demand_class_code,
p_object_version_number => p_qls_object_version_number
);
p_update_quote IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_config_effective_date IN DATE :=FND_API.G_MISS_DATE,
p_config_model_lookup_date IN DATE :=FND_API.G_MISS_DATE
)
IS
l_debug VARCHAR2(1);
P_UPDATE_QUOTE => p_update_quote,
P_CONFIG_EFFECTIVE_DATE => p_config_effective_date,
P_config_model_lookup_DATE => p_config_model_lookup_date,
X_Config_tbl => lx_config_tbl,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data
);
p_cq_price_updated_date IN DATE := FND_API.G_MISS_DATE,
p_cq_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
p_cc_copy_header_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_new_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_task IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_attachment IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_calc_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_calculate_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_shipping IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_billing IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_payment IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_sales_supplement IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_sales_credit IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_flexfield IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_contract_terms IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_end_customer IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_sales_team IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_line_shipping IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_line_billing IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_line_end_customer IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_line_payment IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_line_sales_supp IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_line_flexfield IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_line_attachment IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_line_sales_credit IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cc_copy_to_same_customer IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
p_q_end_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_end_cust_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_end_cust_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_end_cust_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
p_q_header_paynow_charges IN NUMBER := FND_API.G_MISS_NUM,
-- hd shipment record
p_qs_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
p_qs_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_creation_date IN DATE := FND_API.G_MISS_DATE,
p_qs_created_by IN NUMBER := FND_API.G_MISS_NUM,
p_qs_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_qs_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_qs_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_qs_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_program_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_qs_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_promise_date IN DATE := FND_API.G_MISS_DATE,
p_qs_request_date IN DATE := FND_API.G_MISS_DATE,
p_qs_schedule_ship_date IN DATE := FND_API.G_MISS_DATE,
p_qs_ship_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_ship_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_ship_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_ship_partial_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_ship_method_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_freight_terms_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_freight_carrier_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_fob_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_shipping_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_packing_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_quantity IN NUMBER := FND_API.G_MISS_NUM,
p_qs_reserved_quantity IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_reservation_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_ship_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_quote_price IN NUMBER := FND_API.G_MISS_NUM,
p_qs_pricing_quantity IN NUMBER := FND_API.G_MISS_NUM,
p_qs_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_ship_from_org_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_ship_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_qs_request_date_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_demand_class_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qs_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
-- hd payment record
p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
p_qp_qte_line_index IN jtf_number_table := NULL,
p_qp_payment_id IN jtf_number_table := NULL,
p_qp_creation_date IN jtf_date_table := NULL,
p_qp_created_by IN jtf_number_table := NULL,
p_qp_last_update_date IN jtf_date_table := NULL,
p_qp_last_updated_by IN jtf_number_table := NULL,
p_qp_last_update_login IN jtf_number_table := NULL,
p_qp_request_id IN jtf_number_table := NULL,
p_qp_program_application_id IN jtf_number_table := NULL,
p_qp_program_id IN jtf_number_table := NULL,
p_qp_program_update_date IN jtf_date_table := NULL,
p_qp_quote_header_id IN jtf_number_table := NULL,
p_qp_quote_line_id IN jtf_number_table := NULL,
p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
p_qp_payment_term_id IN jtf_number_table := NULL,
p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
p_qp_credit_card_exp_date IN jtf_date_table := NULL,
p_qp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
p_qp_credit_card_aprv_date IN jtf_date_table := NULL,
p_qp_payment_amount IN jtf_number_table := NULL,
p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,
p_qp_attribute1 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute2 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute3 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute4 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute5 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute6 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute7 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute8 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute9 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute10 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute11 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute12 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute13 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute14 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute15 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute16 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute17 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute18 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute19 IN jtf_varchar2_table_300 := NULL,
p_qp_attribute20 IN jtf_varchar2_table_300 := NULL,
p_qp_shipment_index IN jtf_number_table := NULL,
p_qp_quote_shipment_id IN jtf_number_table := NULL,
p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
p_qp_trxn_extension_id IN jtf_number_table := NULL,
p_qp_instrument_id IN jtf_number_table := NULL,
p_qp_instr_assignment_id IN jtf_number_table := NULL,
p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
p_qp_object_version_number IN jtf_number_table := NULL,
-- hd price attributes
p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
p_qpa_qte_line_index IN jtf_number_table := NULL,
p_qpa_price_attribute_id IN jtf_number_table := NULL,
p_qpa_creation_date IN jtf_date_table := NULL,
p_qpa_created_by IN jtf_number_table := NULL,
p_qpa_last_update_date IN jtf_date_table := NULL,
p_qpa_last_updated_by IN jtf_number_table := NULL,
p_qpa_last_update_login IN jtf_number_table := NULL,
p_qpa_request_id IN jtf_number_table := NULL,
p_qpa_program_application_id IN jtf_number_table := NULL,
p_qpa_program_id IN jtf_number_table := NULL,
p_qpa_program_update_date IN jtf_date_table := NULL,
p_qpa_quote_header_id IN jtf_number_table := NULL,
p_qpa_quote_line_id IN jtf_number_table := NULL,
p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
p_qpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute4 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute5 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute6 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute7 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute8 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute9 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute10 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute11 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute12 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute13 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute14 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute15 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute16 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute17 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute18 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute19 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute20 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute21 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute22 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute23 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute24 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute25 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute26 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute27 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute28 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute29 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute30 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute31 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute32 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute33 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute34 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute35 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute36 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute37 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute38 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute39 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute40 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute41 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute42 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute43 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute44 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute45 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute46 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute47 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute48 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute49 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute50 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute51 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute52 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute53 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute54 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute55 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute56 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute57 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute58 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute59 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute60 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute61 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute62 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute63 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute64 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute65 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute66 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute67 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute68 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute69 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute70 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute71 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute72 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute73 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute74 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute75 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute76 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute77 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute78 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute79 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute80 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute81 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute82 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute83 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute84 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute85 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute86 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute87 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute88 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute89 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute90 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute91 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute92 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute93 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute94 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute95 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute96 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
p_qpa_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
p_qpa_context IN jtf_varchar2_table_100 := NULL,
p_qpa_attribute1 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute2 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute3 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute4 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute5 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute6 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute7 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute8 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute9 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute10 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute11 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute12 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute13 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute14 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute15 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute16 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute17 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute18 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute19 IN jtf_varchar2_table_300 := NULL,
p_qpa_attribute20 IN jtf_varchar2_table_300 := NULL,
p_qpa_object_version_number IN jtf_number_table := NULL,
--hd tax details
p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
p_qt_qte_line_index IN jtf_number_table := NULL,
p_qt_shipment_index IN jtf_number_table := NULL,
p_qt_tax_detail_id IN jtf_number_table := NULL,
p_qt_quote_header_id IN jtf_number_table := NULL,
p_qt_quote_line_id IN jtf_number_table := NULL,
p_qt_quote_shipment_id IN jtf_number_table := NULL,
p_qt_creation_date IN jtf_date_table := NULL,
p_qt_created_by IN jtf_number_table := NULL,
p_qt_last_update_date IN jtf_date_table := NULL,
p_qt_last_updated_by IN jtf_number_table := NULL,
p_qt_last_update_login IN jtf_number_table := NULL,
p_qt_request_id IN jtf_number_table := NULL,
p_qt_program_application_id IN jtf_number_table := NULL,
p_qt_program_id IN jtf_number_table := NULL,
p_qt_program_update_date IN jtf_date_table := NULL,
p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
p_qt_tax_rate IN jtf_number_table := NULL,
p_qt_tax_date IN jtf_date_table := NULL,
p_qt_tax_amount IN jtf_number_table := NULL,
p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
p_qt_attribute1 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute2 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute3 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute4 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute5 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute6 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute7 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute8 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute9 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute10 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute11 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute12 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute13 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute14 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute15 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute16 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute17 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute18 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute19 IN jtf_varchar2_table_300 := NULL,
p_qt_attribute20 IN jtf_varchar2_table_300 := NULL,
p_qt_object_version_number IN jtf_number_table := NULL,
p_qt_tax_rate_id IN jtf_number_table := NULL,
-- qh sales credit recore
p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
p_qsc_qte_line_index IN jtf_number_table := NULL,
p_qsc_sales_credit_id IN jtf_number_table := NULL,
p_qsc_creation_date IN jtf_date_table := NULL,
p_qsc_created_by IN jtf_number_table := NULL,
p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
p_qsc_last_update_date IN jtf_date_table := NULL,
p_qsc_last_update_login IN jtf_number_table := NULL,
p_qsc_request_id IN jtf_number_table := NULL,
p_qsc_program_application_id IN jtf_number_table := NULL,
p_qsc_program_id IN jtf_number_table := NULL,
p_qsc_program_update_date IN jtf_date_table := NULL,
p_qsc_quote_header_id IN jtf_number_table := NULL,
p_qsc_quote_line_id IN jtf_number_table := NULL,
p_qsc_percent IN jtf_number_table := NULL,
p_qsc_resource_id IN jtf_number_table := NULL,
p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
p_qsc_resource_group_id IN jtf_number_table := NULL,
p_qsc_employee_person_id IN jtf_number_table := NULL,
p_qsc_sales_credit_type_id IN jtf_number_table := NULL,
p_qsc_attribute_category IN jtf_varchar2_table_100 := NULL,
p_qsc_attribute1 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute2 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute3 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute4 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute5 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute6 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute7 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute8 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute9 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute10 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute11 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute12 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute13 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute14 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute15 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute16 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute17 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute18 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute19 IN jtf_varchar2_table_300 := NULL,
p_qsc_attribute20 IN jtf_varchar2_table_300 := NULL,
p_qsc_system_assigned_flag IN jtf_varchar2_table_100 := NULL,
p_qsc_credit_rule_id IN jtf_number_table := NULL,
p_qsc_object_version_number IN jtf_number_table := NULL,
-- price adjustment record
p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_qte_line_index IN jtf_number_table := NULL,
p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
p_qlpaj_creation_date IN jtf_date_table := NULL,
p_qlpaj_created_by IN jtf_number_table := NULL,
p_qlpaj_last_update_date IN jtf_date_table := NULL,
p_qlpaj_last_updated_by IN jtf_number_table := NULL,
p_qlpaj_last_update_login IN jtf_number_table := NULL,
p_qlpaj_program_application_id IN jtf_number_table := NULL,
p_qlpaj_program_id IN jtf_number_table := NULL,
p_qlpaj_program_update_date IN jtf_date_table := NULL,
p_qlpaj_request_id IN jtf_number_table := NULL,
p_qlpaj_quote_header_id IN jtf_number_table := NULL,
p_qlpaj_quote_line_id IN jtf_number_table := NULL,
p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_modified_from IN jtf_number_table := NULL,
p_qlpaj_modified_to IN jtf_number_table := NULL,
p_qlpaj_operand IN jtf_number_table := NULL,
p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
p_qlpaj_attribute1 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute2 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute3 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute4 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute5 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute6 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute7 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute8 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute9 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute10 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute11 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute12 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute13 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute14 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute15 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute16 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute17 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute18 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute19 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_attribute20 IN jtf_varchar2_table_300 := NULL,
p_qlpaj_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
p_qlpaj_cost_id IN jtf_number_table := NULL,
p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_benefit_qty IN jtf_number_table := NULL,
p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_expiration_date IN jtf_date_table := NULL,
p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
p_qlpaj_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_redeemed_date IN jtf_date_table := NULL,
p_qlpaj_redeemed_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_modifier_level_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_price_break_type_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
p_qlpaj_shipment_index IN jtf_number_table := NULL,
p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,
p_qlpaj_object_version_number IN jtf_number_table := NULL,
p_api_version_number IN NUMBER := 1 ,
p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
p_commit IN VARCHAR2 := FND_API.G_FALSE ,
x_return_status OUT NOCOPY VARCHAR2 ,
x_msg_count OUT NOCOPY NUMBER ,
x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'copy_from_quote';
p_price_updated_date => p_cq_price_updated_date,
p_tax_updated_date => p_cq_tax_updated_date);
p_last_updated_by => p_q_last_updated_by ,
p_last_update_date => p_q_last_update_date ,
p_last_update_login => p_q_last_update_login ,
p_request_id => p_q_request_id ,
p_program_application_id => p_q_program_application_id ,
p_program_id => p_q_program_id ,
p_program_update_date => p_q_program_update_date ,
p_org_id => p_q_org_id ,
p_quote_name => p_q_quote_name ,
p_quote_number => p_q_quote_number ,
p_quote_version => p_q_quote_version ,
p_quote_status_id => p_q_quote_status_id ,
p_quote_source_code => p_q_quote_source_code ,
p_quote_expiration_date => p_q_quote_expiration_date ,
p_price_frozen_date => p_q_price_frozen_date ,
p_quote_password => p_q_quote_password ,
p_original_system_reference => p_q_original_system_reference ,
p_party_id => p_q_party_id ,
p_cust_account_id => p_q_cust_account_id ,
p_invoice_to_cust_account_id => p_q_invoice_to_cust_acct_id ,
p_org_contact_id => p_q_org_contact_id ,
p_party_name => p_q_party_name ,
p_party_type => p_q_party_type ,
p_person_first_name => p_q_person_first_name ,
p_person_last_name => p_q_person_last_name ,
p_person_middle_name => p_q_person_middle_name ,
p_phone_id => p_q_phone_id ,
p_price_list_id => p_q_price_list_id ,
p_price_list_name => p_q_price_list_name ,
p_currency_code => p_q_currency_code ,
p_total_list_price => p_q_total_list_price ,
p_total_adjusted_amount => p_q_total_adjusted_amount ,
p_total_adjusted_percent => p_q_total_adjusted_percent ,
p_total_tax => p_q_total_tax ,
p_total_shipping_charge => p_q_total_shipping_charge ,
p_surcharge => p_q_surcharge ,
p_total_quote_price => p_q_total_quote_price ,
p_payment_amount => p_q_payment_amount ,
p_accounting_rule_id => p_q_accounting_rule_id ,
p_exchange_rate => p_q_exchange_rate ,
p_exchange_type_code => p_q_exchange_type_code ,
p_exchange_rate_date => p_q_exchange_rate_date ,
p_quote_category_code => p_q_quote_category_code ,
p_quote_status_code => p_q_quote_status_code ,
p_quote_status => p_q_quote_status ,
p_employee_person_id => p_q_employee_person_id ,
p_sales_channel_code => p_q_sales_channel_code ,
p_salesrep_first_name => p_q_salesrep_first_name ,
p_salesrep_last_name => p_q_salesrep_last_name ,
p_attribute_category => p_q_attribute_category ,
p_attribute1 => p_q_attribute1 ,
p_attribute10 => p_q_attribute10 ,
p_attribute11 => p_q_attribute11 ,
p_attribute12 => p_q_attribute12 ,
p_attribute13 => p_q_attribute13 ,
p_attribute14 => p_q_attribute14 ,
p_attribute15 => p_q_attribute15 ,
p_attribute16 => p_q_attribute16 ,
p_attribute17 => p_q_attribute17 ,
p_attribute18 => p_q_attribute18 ,
p_attribute19 => p_q_attribute19 ,
p_attribute20 => p_q_attribute20 ,
p_attribute2 => p_q_attribute2 ,
p_attribute3 => p_q_attribute3 ,
p_attribute4 => p_q_attribute4 ,
p_attribute5 => p_q_attribute5 ,
p_attribute6 => p_q_attribute6 ,
p_attribute7 => p_q_attribute7 ,
p_attribute8 => p_q_attribute8 ,
p_attribute9 => p_q_attribute9 ,
p_contract_id => p_q_contract_id ,
p_qte_contract_id => p_q_qte_contract_id ,
p_ffm_request_id => p_q_ffm_request_id ,
p_invoice_to_address1 => p_q_invoice_to_address1 ,
p_invoice_to_address2 => p_q_invoice_to_address2 ,
p_invoice_to_address3 => p_q_invoice_to_address3 ,
p_invoice_to_address4 => p_q_invoice_to_address4 ,
p_invoice_to_city => p_q_invoice_to_city ,
p_invoice_to_cont_first_name => p_q_invoice_to_cont_first_name,
p_invoice_to_cont_last_name => p_q_invoice_to_cont_last_name ,
p_invoice_to_cont_mid_name => p_q_invoice_to_cont_mid_name ,
p_invoice_to_country_code => p_q_invoice_to_country_code ,
p_invoice_to_country => p_q_invoice_to_country ,
p_invoice_to_county => p_q_invoice_to_county ,
p_invoice_to_party_id => p_q_invoice_to_party_id ,
p_invoice_to_party_name => p_q_invoice_to_party_name ,
p_invoice_to_party_site_id => p_q_invoice_to_party_site_id ,
p_invoice_to_postal_code => p_q_invoice_to_postal_code ,
p_invoice_to_province => p_q_invoice_to_province ,
p_invoice_to_state => p_q_invoice_to_state ,
p_invoicing_rule_id => p_q_invoicing_rule_id ,
p_marketing_source_code_id => p_q_marketing_source_code_id ,
p_marketing_source_code => p_q_marketing_source_code ,
p_marketing_source_name => p_q_marketing_source_name ,
p_orig_mktg_source_code_id => p_q_orig_mktg_source_code_id ,
p_order_type_id => p_q_order_type_id ,
p_order_id => p_q_order_id ,
p_order_number => p_q_order_number ,
p_order_type_name => p_q_order_type_name ,
p_ordered_date => p_q_ordered_date ,
p_resource_id => p_q_resource_id ,
p_contract_template_id => p_q_contract_template_id ,
p_contract_template_maj_ver => p_q_contract_template_maj_ver ,
p_contract_requester_id => p_q_contract_requester_id ,
p_contract_approval_level => p_q_contract_approval_level ,
p_publish_flag => p_q_publish_flag ,
p_resource_grp_id => p_q_resource_grp_id ,
p_sold_to_party_site_id => p_q_sold_to_party_site_id ,
p_display_arithmetic_operator => p_q_display_arithmetic_op ,
p_quote_description => p_q_quote_description ,
p_quote_type => p_q_quote_type ,
p_minisite_id => p_q_minisite_id ,
p_cust_party_id => p_q_cust_party_id ,
p_invoice_to_cust_party_id => p_q_invoice_to_cust_party_id ,
p_pricing_status_indicator => p_q_pricing_status_indicator ,
p_tax_status_indicator => p_q_tax_status_indicator ,
p_price_updated_date => p_q_price_updated_date ,
p_tax_updated_date => p_q_tax_updated_date ,
p_recalculate_flag => p_q_recalculate_flag ,
p_price_request_id => p_q_price_request_id ,
p_customer_name_and_title => p_q_customer_name_and_title,
p_customer_signature_date => p_q_customer_signature_date,
p_supplier_name_and_title => p_q_supplier_name_and_title,
p_supplier_signature_date => p_q_supplier_signature_date,
p_credit_update_date => p_q_credit_update_date ,
p_automatic_price_flag => p_q_automatic_price_flag,
p_automatic_tax_flag => p_q_automatic_tax_flag,
p_assistance_requested => p_q_assistance_requested,
p_assistance_reason_code => p_q_assistance_reason_code,
p_end_customer_party_id => p_q_end_cust_party_id,
p_end_customer_party_site_id => p_q_end_cust_party_site_id,
p_end_customer_cust_account_id => p_q_end_cust_cust_account_id,
p_end_customer_cust_party_id => p_q_end_cust_cust_party_id,
p_object_version_number => p_q_object_version_number,
p_header_paynow_charges => p_q_header_paynow_charges
);
p_last_update_date => p_qpa_last_update_date ,
p_last_updated_by => p_qpa_last_updated_by ,
p_last_update_login => p_qpa_last_update_login ,
p_request_id => p_qpa_request_id ,
p_program_application_id => p_qpa_program_application_id,
p_program_id => p_qpa_program_id ,
p_program_update_date => p_qpa_program_update_date ,
p_quote_header_id => p_qpa_quote_header_id ,
p_quote_line_id => p_qpa_quote_line_id ,
p_flex_title => p_qpa_flex_title ,
p_pricing_context => p_qpa_pricing_context ,
p_pricing_attribute1 => p_qpa_pricing_attribute1 ,
p_pricing_attribute2 => p_qpa_pricing_attribute2 ,
p_pricing_attribute3 => p_qpa_pricing_attribute3 ,
p_pricing_attribute4 => p_qpa_pricing_attribute4 ,
p_pricing_attribute5 => p_qpa_pricing_attribute5 ,
p_pricing_attribute6 => p_qpa_pricing_attribute6 ,
p_pricing_attribute7 => p_qpa_pricing_attribute7 ,
p_pricing_attribute8 => p_qpa_pricing_attribute8 ,
p_pricing_attribute9 => p_qpa_pricing_attribute9 ,
p_pricing_attribute10 => p_qpa_pricing_attribute10 ,
p_pricing_attribute11 => p_qpa_pricing_attribute11 ,
p_pricing_attribute12 => p_qpa_pricing_attribute12 ,
p_pricing_attribute13 => p_qpa_pricing_attribute13 ,
p_pricing_attribute14 => p_qpa_pricing_attribute14 ,
p_pricing_attribute15 => p_qpa_pricing_attribute15 ,
p_pricing_attribute16 => p_qpa_pricing_attribute16 ,
p_pricing_attribute17 => p_qpa_pricing_attribute17 ,
p_pricing_attribute18 => p_qpa_pricing_attribute18 ,
p_pricing_attribute19 => p_qpa_pricing_attribute19 ,
p_pricing_attribute20 => p_qpa_pricing_attribute20 ,
p_pricing_attribute21 => p_qpa_pricing_attribute21 ,
p_pricing_attribute22 => p_qpa_pricing_attribute22 ,
p_pricing_attribute23 => p_qpa_pricing_attribute23 ,
p_pricing_attribute24 => p_qpa_pricing_attribute24 ,
p_pricing_attribute25 => p_qpa_pricing_attribute25 ,
p_pricing_attribute26 => p_qpa_pricing_attribute26 ,
p_pricing_attribute27 => p_qpa_pricing_attribute27 ,
p_pricing_attribute28 => p_qpa_pricing_attribute28 ,
p_pricing_attribute29 => p_qpa_pricing_attribute29 ,
p_pricing_attribute30 => p_qpa_pricing_attribute30 ,
p_pricing_attribute31 => p_qpa_pricing_attribute31 ,
p_pricing_attribute32 => p_qpa_pricing_attribute32 ,
p_pricing_attribute33 => p_qpa_pricing_attribute33 ,
p_pricing_attribute34 => p_qpa_pricing_attribute34 ,
p_pricing_attribute35 => p_qpa_pricing_attribute35 ,
p_pricing_attribute36 => p_qpa_pricing_attribute36 ,
p_pricing_attribute37 => p_qpa_pricing_attribute37 ,
p_pricing_attribute38 => p_qpa_pricing_attribute38 ,
p_pricing_attribute39 => p_qpa_pricing_attribute39 ,
p_pricing_attribute40 => p_qpa_pricing_attribute40 ,
p_pricing_attribute41 => p_qpa_pricing_attribute41 ,
p_pricing_attribute42 => p_qpa_pricing_attribute42 ,
p_pricing_attribute43 => p_qpa_pricing_attribute43 ,
p_pricing_attribute44 => p_qpa_pricing_attribute44 ,
p_pricing_attribute45 => p_qpa_pricing_attribute45 ,
p_pricing_attribute46 => p_qpa_pricing_attribute46 ,
p_pricing_attribute47 => p_qpa_pricing_attribute47 ,
p_pricing_attribute48 => p_qpa_pricing_attribute48 ,
p_pricing_attribute49 => p_qpa_pricing_attribute49 ,
p_pricing_attribute50 => p_qpa_pricing_attribute50 ,
p_pricing_attribute51 => p_qpa_pricing_attribute51 ,
p_pricing_attribute52 => p_qpa_pricing_attribute52 ,
p_pricing_attribute53 => p_qpa_pricing_attribute53 ,
p_pricing_attribute54 => p_qpa_pricing_attribute54 ,
p_pricing_attribute55 => p_qpa_pricing_attribute55 ,
p_pricing_attribute56 => p_qpa_pricing_attribute56 ,
p_pricing_attribute57 => p_qpa_pricing_attribute57 ,
p_pricing_attribute58 => p_qpa_pricing_attribute58 ,
p_pricing_attribute59 => p_qpa_pricing_attribute59 ,
p_pricing_attribute60 => p_qpa_pricing_attribute60 ,
p_pricing_attribute61 => p_qpa_pricing_attribute61 ,
p_pricing_attribute62 => p_qpa_pricing_attribute62 ,
p_pricing_attribute63 => p_qpa_pricing_attribute63 ,
p_pricing_attribute64 => p_qpa_pricing_attribute64 ,
p_pricing_attribute65 => p_qpa_pricing_attribute65 ,
p_pricing_attribute66 => p_qpa_pricing_attribute66 ,
p_pricing_attribute67 => p_qpa_pricing_attribute67 ,
p_pricing_attribute68 => p_qpa_pricing_attribute68 ,
p_pricing_attribute69 => p_qpa_pricing_attribute69 ,
p_pricing_attribute70 => p_qpa_pricing_attribute70 ,
p_pricing_attribute71 => p_qpa_pricing_attribute71 ,
p_pricing_attribute72 => p_qpa_pricing_attribute72 ,
p_pricing_attribute73 => p_qpa_pricing_attribute73 ,
p_pricing_attribute74 => p_qpa_pricing_attribute74 ,
p_pricing_attribute75 => p_qpa_pricing_attribute75 ,
p_pricing_attribute76 => p_qpa_pricing_attribute76 ,
p_pricing_attribute77 => p_qpa_pricing_attribute77 ,
p_pricing_attribute78 => p_qpa_pricing_attribute78 ,
p_pricing_attribute79 => p_qpa_pricing_attribute79 ,
p_pricing_attribute80 => p_qpa_pricing_attribute80 ,
p_pricing_attribute81 => p_qpa_pricing_attribute81 ,
p_pricing_attribute82 => p_qpa_pricing_attribute82 ,
p_pricing_attribute83 => p_qpa_pricing_attribute83 ,
p_pricing_attribute84 => p_qpa_pricing_attribute84 ,
p_pricing_attribute85 => p_qpa_pricing_attribute85 ,
p_pricing_attribute86 => p_qpa_pricing_attribute86 ,
p_pricing_attribute87 => p_qpa_pricing_attribute87 ,
p_pricing_attribute88 => p_qpa_pricing_attribute88 ,
p_pricing_attribute89 => p_qpa_pricing_attribute89 ,
p_pricing_attribute90 => p_qpa_pricing_attribute90 ,
p_pricing_attribute91 => p_qpa_pricing_attribute91 ,
p_pricing_attribute92 => p_qpa_pricing_attribute92 ,
p_pricing_attribute93 => p_qpa_pricing_attribute93 ,
p_pricing_attribute94 => p_qpa_pricing_attribute94 ,
p_pricing_attribute95 => p_qpa_pricing_attribute95 ,
p_pricing_attribute96 => p_qpa_pricing_attribute96 ,
p_pricing_attribute97 => p_qpa_pricing_attribute97 ,
p_pricing_attribute98 => p_qpa_pricing_attribute98 ,
p_pricing_attribute99 => p_qpa_pricing_attribute99 ,
p_pricing_attribute100 => p_qpa_pricing_attribute100 ,
p_context => p_qpa_context ,
p_attribute1 => p_qpa_attribute1 ,
p_attribute2 => p_qpa_attribute2 ,
p_attribute3 => p_qpa_attribute3 ,
p_attribute4 => p_qpa_attribute4 ,
p_attribute5 => p_qpa_attribute5 ,
p_attribute6 => p_qpa_attribute6 ,
p_attribute7 => p_qpa_attribute7 ,
p_attribute8 => p_qpa_attribute8 ,
p_attribute9 => p_qpa_attribute9 ,
p_attribute10 => p_qpa_attribute10 ,
p_attribute11 => p_qpa_attribute11 ,
p_attribute12 => p_qpa_attribute12 ,
p_attribute13 => p_qpa_attribute13 ,
p_attribute14 => p_qpa_attribute14 ,
p_attribute15 => p_qpa_attribute15 ,
p_attribute16 => p_qpa_attribute16 ,
p_attribute17 => p_qpa_attribute17 ,
p_attribute18 => p_qpa_attribute18 ,
p_attribute19 => p_qpa_attribute19 ,
p_attribute20 => p_qpa_attribute20 ,
p_object_version_number => p_qpa_object_version_number);
p_last_update_date => p_qp_last_update_date ,
p_last_updated_by => p_qp_last_updated_by ,
p_last_update_login => p_qp_last_update_login ,
p_request_id => p_qp_request_id ,
p_program_application_id => p_qp_program_application_id ,
p_program_id => p_qp_program_id ,
p_program_update_date => p_qp_program_update_date ,
p_quote_header_id => p_qp_quote_header_id ,
p_quote_line_id => p_qp_quote_line_id ,
p_payment_type_code => p_qp_payment_type_code ,
p_payment_ref_number => p_qp_payment_ref_number ,
p_payment_option => p_qp_payment_option ,
p_payment_term_id => p_qp_payment_term_id ,
p_credit_card_code => p_qp_credit_card_code ,
p_credit_card_holder_name => p_qp_credit_card_holder_name ,
p_credit_card_exp_date => p_qp_credit_card_exp_date ,
p_credit_card_approval_code => p_qp_credit_card_aprv_code ,
p_credit_card_approval_date => p_qp_credit_card_aprv_date ,
p_payment_amount => p_qp_payment_amount ,
p_attribute_category => p_qp_attribute_category ,
p_attribute1 => p_qp_attribute1 ,
p_attribute2 => p_qp_attribute2 ,
p_attribute3 => p_qp_attribute3 ,
p_attribute4 => p_qp_attribute4 ,
p_attribute5 => p_qp_attribute5 ,
p_attribute6 => p_qp_attribute6 ,
p_attribute7 => p_qp_attribute7 ,
p_attribute8 => p_qp_attribute8 ,
p_attribute9 => p_qp_attribute9 ,
p_attribute10 => p_qp_attribute10 ,
p_attribute11 => p_qp_attribute11 ,
p_attribute12 => p_qp_attribute12 ,
p_attribute13 => p_qp_attribute13 ,
p_attribute14 => p_qp_attribute14 ,
p_attribute15 => p_qp_attribute15 ,
p_attribute16 => p_qp_attribute16 ,
p_attribute17 => p_qp_attribute17 ,
p_attribute18 => p_qp_attribute18 ,
p_attribute19 => p_qp_attribute19 ,
p_attribute20 => p_qp_attribute20 ,
p_shipment_index => p_qp_shipment_index ,
p_quote_shipment_id => p_qp_quote_shipment_id ,
p_cust_po_number => p_qp_cust_po_number ,
p_cust_po_line_number => p_qp_cust_po_line_number ,
p_trxn_extension_id => p_qp_trxn_extension_id ,
p_instrument_id => p_qp_instrument_id ,
p_instr_assignment_id => p_qp_instr_assignment_id ,
p_cvv2 => p_qp_cvv2 ,
p_object_version_number => p_qp_object_version_number);
p_last_update_date => p_qs_last_update_date ,
p_last_updated_by => p_qs_last_updated_by ,
p_last_update_login => p_qs_last_update_login ,
p_request_id => p_qs_request_id ,
p_program_application_id => p_qs_program_application_id,
p_program_id => p_qs_program_id ,
p_program_update_date => p_qs_program_update_date ,
p_quote_header_id => p_qs_quote_header_id ,
p_quote_line_id => p_qs_quote_line_id ,
p_promise_date => p_qs_promise_date ,
p_request_date => p_qs_request_date ,
p_schedule_ship_date => p_qs_schedule_ship_date ,
p_ship_to_party_site_id => p_qs_ship_to_party_site_id ,
p_ship_to_party_id => p_qs_ship_to_party_id ,
p_ship_to_cust_account_id => p_qs_ship_to_cust_account_id ,
p_ship_partial_flag => p_qs_ship_partial_flag ,
p_ship_set_id => p_qs_ship_set_id ,
p_ship_method_code => p_qs_ship_method_code ,
p_freight_terms_code => p_qs_freight_terms_code ,
p_freight_carrier_code => p_qs_freight_carrier_code ,
p_fob_code => p_qs_fob_code ,
p_shipping_instructions => p_qs_shipping_instructions ,
p_packing_instructions => p_qs_packing_instructions ,
p_quantity => p_qs_quantity ,
p_reserved_quantity => p_qs_reserved_quantity ,
p_reservation_id => p_qs_reservation_id ,
p_order_line_id => p_qs_order_line_id ,
p_ship_to_party_name => p_qs_ship_to_party_name ,
p_ship_to_cont_first_name => p_qs_ship_to_cont_first_name ,
p_ship_to_cont_mid_name => p_qs_ship_to_cont_mid_name ,
p_ship_to_cont_last_name => p_qs_ship_to_cont_last_name ,
p_ship_to_address1 => p_qs_ship_to_address1 ,
p_ship_to_address2 => p_qs_ship_to_address2 ,
p_ship_to_address3 => p_qs_ship_to_address3 ,
p_ship_to_address4 => p_qs_ship_to_address4 ,
p_ship_to_country_code => p_qs_ship_to_country_code ,
p_ship_to_country => p_qs_ship_to_country ,
p_ship_to_city => p_qs_ship_to_city ,
p_ship_to_postal_code => p_qs_ship_to_postal_code ,
p_ship_to_state => p_qs_ship_to_state ,
p_ship_to_province => p_qs_ship_to_province ,
p_ship_to_county => p_qs_ship_to_county ,
p_attribute_category => p_qs_attribute_category ,
p_attribute1 => p_qs_attribute1 ,
p_attribute2 => p_qs_attribute2 ,
p_attribute3 => p_qs_attribute3 ,
p_attribute4 => p_qs_attribute4 ,
p_attribute5 => p_qs_attribute5 ,
p_attribute6 => p_qs_attribute6 ,
p_attribute7 => p_qs_attribute7 ,
p_attribute8 => p_qs_attribute8 ,
p_attribute9 => p_qs_attribute9 ,
p_attribute10 => p_qs_attribute10 ,
p_attribute11 => p_qs_attribute11 ,
p_attribute12 => p_qs_attribute12 ,
p_attribute13 => p_qs_attribute13 ,
p_attribute14 => p_qs_attribute14 ,
p_attribute15 => p_qs_attribute15 ,
p_attribute16 => p_qs_attribute16 ,
p_attribute17 => p_qs_attribute17 ,
p_attribute18 => p_qs_attribute18 ,
p_attribute19 => p_qs_attribute19 ,
p_attribute20 => p_qs_attribute20 ,
p_ship_quote_price => p_qs_ship_quote_price ,
p_pricing_quantity => p_qs_pricing_quantity ,
p_shipment_priority_code => p_qs_shipment_priority_code,
p_ship_from_org_id => p_qs_ship_from_org_id ,
p_ship_to_cust_party_id => p_qs_ship_to_cust_party_id ,
p_request_date_type => p_qs_request_date_type ,
p_demand_class_code => p_qs_demand_class_code ,
p_object_version_number => p_qs_object_version_number
);
p_last_update_date => p_qt_last_update_date ,
p_last_updated_by => p_qt_last_updated_by ,
p_last_update_login => p_qt_last_update_login ,
p_request_id => p_qt_request_id ,
p_program_application_id => p_qt_program_application_id,
p_program_id => p_qt_program_id ,
p_program_update_date => p_qt_program_update_date ,
p_orig_tax_code => p_qt_orig_tax_code ,
p_tax_code => p_qt_tax_code ,
p_tax_rate => p_qt_tax_rate ,
p_tax_date => p_qt_tax_date ,
p_tax_amount => p_qt_tax_amount ,
p_tax_exempt_flag => p_qt_tax_exempt_flag ,
p_tax_exempt_number => p_qt_tax_exempt_number ,
p_tax_exempt_reason_code => p_qt_tax_exempt_reason_code,
p_attribute_category => p_qt_attribute_category ,
p_attribute1 => p_qt_attribute1 ,
p_attribute2 => p_qt_attribute2 ,
p_attribute3 => p_qt_attribute3 ,
p_attribute4 => p_qt_attribute4 ,
p_attribute5 => p_qt_attribute5 ,
p_attribute6 => p_qt_attribute6 ,
p_attribute7 => p_qt_attribute7 ,
p_attribute8 => p_qt_attribute8 ,
p_attribute9 => p_qt_attribute9 ,
p_attribute10 => p_qt_attribute10 ,
p_attribute11 => p_qt_attribute11 ,
p_attribute12 => p_qt_attribute12 ,
p_attribute13 => p_qt_attribute13 ,
p_attribute14 => p_qt_attribute14 ,
p_attribute15 => p_qt_attribute15 ,
p_attribute16 => p_qt_attribute16 ,
p_attribute17 => p_qt_attribute17 ,
p_attribute18 => p_qt_attribute18 ,
p_attribute19 => p_qt_attribute19 ,
p_attribute20 => p_qt_attribute20 ,
p_object_version_number => p_qt_object_version_number ,
p_tax_rate_id => p_qt_tax_rate_id);
p_last_updated_by => p_qsc_last_updated_by ,
p_last_update_date => p_qsc_last_update_date ,
p_last_update_login => p_qsc_last_update_login ,
p_request_id => p_qsc_request_id ,
p_program_application_id => p_qsc_program_application_id,
p_program_id => p_qsc_program_id ,
p_program_update_date => p_qsc_program_update_date ,
p_quote_header_id => p_qsc_quote_header_id ,
p_quote_line_id => p_qsc_quote_line_id ,
p_percent => p_qsc_percent ,
p_resource_id => p_qsc_resource_id ,
p_first_name => p_qsc_first_name ,
p_last_name => p_qsc_last_name ,
p_sales_credit_type => p_qsc_sales_credit_type ,
p_resource_group_id => p_qsc_resource_group_id ,
p_employee_person_id => p_qsc_employee_person_id ,
p_sales_credit_type_id => p_qsc_sales_credit_type_id ,
p_attribute_category => p_qsc_attribute_category ,
p_attribute1 => p_qsc_attribute1 ,
p_attribute2 => p_qsc_attribute2 ,
p_attribute3 => p_qsc_attribute3 ,
p_attribute4 => p_qsc_attribute4 ,
p_attribute5 => p_qsc_attribute5 ,
p_attribute6 => p_qsc_attribute6 ,
p_attribute7 => p_qsc_attribute7 ,
p_attribute8 => p_qsc_attribute8 ,
p_attribute9 => p_qsc_attribute9 ,
p_attribute10 => p_qsc_attribute10 ,
p_attribute11 => p_qsc_attribute11 ,
p_attribute12 => p_qsc_attribute12 ,
p_attribute13 => p_qsc_attribute13 ,
p_attribute14 => p_qsc_attribute14 ,
p_attribute15 => p_qsc_attribute15 ,
p_attribute16 => p_qsc_attribute16 ,
p_attribute17 => p_qsc_attribute17 ,
p_attribute18 => p_qsc_attribute18 ,
p_attribute19 => p_qsc_attribute19 ,
p_attribute20 => p_qsc_attribute20 ,
p_system_assigned_flag => p_qsc_system_assigned_flag ,
p_credit_rule_id => p_qsc_credit_rule_id ,
p_object_version_number => p_qsc_object_version_number);
p_last_update_date => p_qlpaj_last_update_date ,
p_last_updated_by => p_qlpaj_last_updated_by ,
p_last_update_login => p_qlpaj_last_update_login ,
p_program_application_id => p_qlpaj_program_application_id,
p_program_id => p_qlpaj_program_id ,
p_program_update_date => p_qlpaj_program_update_date ,
p_request_id => p_qlpaj_request_id ,
p_quote_header_id => p_qlpaj_quote_header_id ,
p_quote_line_id => p_qlpaj_quote_line_id ,
p_modifier_header_id => p_qlpaj_modifier_header_id ,
p_modifier_line_id => p_qlpaj_modifier_line_id ,
p_mod_line_type_code => p_qlpaj_mod_line_type_code ,
p_mod_mech_type_code => p_qlpaj_mod_mech_type_code ,
p_modified_from => p_qlpaj_modified_from ,
p_modified_to => p_qlpaj_modified_to ,
p_operand => p_qlpaj_operand ,
p_arithmetic_operator => p_qlpaj_arithmetic_operator ,
p_automatic_flag => p_qlpaj_automatic_flag ,
p_update_allowable_flag => p_qlpaj_update_allowable_flag ,
p_updated_flag => p_qlpaj_updated_flag ,
p_applied_flag => p_qlpaj_applied_flag ,
p_on_invoice_flag => p_qlpaj_on_invoice_flag ,
p_pricing_phase_id => p_qlpaj_pricing_phase_id ,
p_attribute_category => p_qlpaj_attribute_category ,
p_attribute1 => p_qlpaj_attribute1 ,
p_attribute2 => p_qlpaj_attribute2 ,
p_attribute3 => p_qlpaj_attribute3 ,
p_attribute4 => p_qlpaj_attribute4 ,
p_attribute5 => p_qlpaj_attribute5 ,
p_attribute6 => p_qlpaj_attribute6 ,
p_attribute7 => p_qlpaj_attribute7 ,
p_attribute8 => p_qlpaj_attribute8 ,
p_attribute9 => p_qlpaj_attribute9 ,
p_attribute10 => p_qlpaj_attribute10 ,
p_attribute11 => p_qlpaj_attribute11 ,
p_attribute12 => p_qlpaj_attribute12 ,
p_attribute13 => p_qlpaj_attribute13 ,
p_attribute14 => p_qlpaj_attribute14 ,
p_attribute15 => p_qlpaj_attribute15 ,
p_attribute16 => p_qlpaj_attribute16 ,
p_attribute17 => p_qlpaj_attribute17 ,
p_attribute18 => p_qlpaj_attribute18 ,
p_attribute19 => p_qlpaj_attribute19 ,
p_attribute20 => p_qlpaj_attribute20 ,
p_orig_sys_discount_ref => p_qlpaj_orig_sys_discount_ref ,
p_change_sequence => p_qlpaj_change_sequence ,
p_update_allowed => p_qlpaj_update_allowed ,
p_change_reason_code => p_qlpaj_change_reason_code ,
p_change_reason_text => p_qlpaj_change_reason_text ,
p_cost_id => p_qlpaj_cost_id ,
p_tax_code => p_qlpaj_tax_code ,
p_tax_exempt_flag => p_qlpaj_tax_exempt_flag ,
p_tax_exempt_number => p_qlpaj_tax_exempt_number ,
p_tax_exempt_reason_code => p_qlpaj_tax_exempt_reason_code,
p_parent_adjustment_id => p_qlpaj_parent_adjustment_id ,
p_invoiced_flag => p_qlpaj_invoiced_flag ,
p_estimated_flag => p_qlpaj_estimated_flag ,
p_inc_in_sales_perfce => p_qlpaj_inc_in_sales_perfce ,
p_split_action_code => p_qlpaj_split_action_code ,
p_adjusted_amount => p_qlpaj_adjusted_amount ,
p_charge_type_code => p_qlpaj_charge_type_code ,
p_charge_subtype_code => p_qlpaj_charge_subtype_code ,
p_range_break_quantity => p_qlpaj_range_break_quantity ,
p_accrual_conv_rate => p_qlpaj_accrual_conv_rate ,
p_pricing_group_sequence => p_qlpaj_pricing_group_sequence,
p_accrual_flag => p_qlpaj_accrual_flag ,
p_list_line_no => p_qlpaj_list_line_no ,
p_source_system_code => p_qlpaj_source_system_code ,
p_benefit_qty => p_qlpaj_benefit_qty ,
p_benefit_uom_code => p_qlpaj_benefit_uom_code ,
p_print_on_invoice_flag => p_qlpaj_print_on_invoice_flag ,
p_expiration_date => p_qlpaj_expiration_date ,
p_rebate_trans_type_code => p_qlpaj_rebate_trans_type_code,
p_rebate_trans_reference => p_qlpaj_rebate_trans_reference,
p_rebate_pay_system_code => p_qlpaj_rebate_pay_system_code,
p_redeemed_date => p_qlpaj_redeemed_date ,
p_redeemed_flag => p_qlpaj_redeemed_flag ,
p_modifier_level_code => p_qlpaj_modifier_level_code ,
p_price_break_type_code => p_qlpaj_price_break_type_code ,
p_substitution_attribute => p_qlpaj_substitution_attribute,
p_proration_type_code => p_qlpaj_proration_type_code ,
p_include_on_ret_flag => p_qlpaj_include_on_ret_flag ,
p_credit_or_charge_flag => p_qlpaj_credit_or_charge_flag ,
p_shipment_index => p_qlpaj_shipment_index ,
p_quote_shipment_id => p_qlpaj_quote_shipment_id ,
p_object_version_number => p_qlpaj_object_version_number);