[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
);