The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' -- change line logic pricing
) RETURN ASO_QUOTE_PUB.Control_Rec_Type
IS
control_rec ASO_QUOTE_PUB.Control_Rec_Type;
IF p_c_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
control_rec.last_update_date := FND_API.G_MISS_DATE;
control_rec.last_update_date := p_c_last_update_date;
p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
-- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM
) RETURN ASO_QUOTE_PUB.Qte_Header_Rec_Type
IS
q_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
IF p_h_last_updated_by = ROSETTA_G_MISS_NUM THEN
q_header_rec.last_updated_by := FND_API.G_MISS_NUM;
q_header_rec.last_updated_by := p_h_last_updated_by;
IF p_h_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
q_header_rec.last_update_date := FND_API.G_MISS_DATE;
q_header_rec.last_update_date := p_h_last_update_date;
IF p_h_last_update_login = ROSETTA_G_MISS_NUM THEN
q_header_rec.last_update_login := FND_API.G_MISS_NUM;
q_header_rec.last_update_login := p_h_last_update_login;
IF p_h_program_update_date = ROSETTA_G_MISTAKE_DATE THEN
q_header_rec.program_update_date := FND_API.G_MISS_DATE;
q_header_rec.program_update_date := p_h_program_update_date;
p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_org_id IN NUMBER := FND_API.G_MISS_NUM
) RETURN IBE_Shop_List_PVT.SL_Header_Rec_Type
IS
sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
IF p_h_program_update_date = ROSETTA_G_MISTAKE_DATE THEN
sl_header_rec.program_update_date := FND_API.G_MISS_DATE;
sl_header_rec.program_update_date := p_h_program_update_date;
IF p_h_last_updated_by = ROSETTA_G_MISS_NUM THEN
sl_header_rec.last_updated_by := FND_API.G_MISS_NUM;
sl_header_rec.last_updated_by := p_h_last_updated_by;
IF p_h_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
sl_header_rec.last_update_date := FND_API.G_MISS_DATE;
sl_header_rec.last_update_date := p_h_last_update_date;
IF p_h_last_update_login = ROSETTA_G_MISS_NUM THEN
sl_header_rec.last_update_login := FND_API.G_MISS_NUM;
sl_header_rec.last_update_login := p_h_last_update_login;
p_l_last_updated_by IN jtf_number_table := NULL,
p_l_last_update_date IN jtf_date_table := NULL,
p_l_last_update_login IN jtf_number_table := NULL,
p_l_request_id IN jtf_number_table := NULL,
p_l_program_id IN jtf_number_table := NULL,
p_l_program_application_id IN jtf_number_table := NULL,
p_l_program_update_date IN jtf_date_table := NULL,
p_l_shp_list_id IN jtf_number_table := NULL,
p_l_inventory_item_id IN jtf_number_table := NULL,
p_l_organization_id IN jtf_number_table := NULL,
p_l_uom_code IN jtf_varchar2_table_100 := NULL,
p_l_quantity IN jtf_number_table := NULL,
p_l_config_header_id IN jtf_number_table := NULL,
p_l_config_revision_num IN jtf_number_table := NULL,
p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,
p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
p_l_item_type_code IN jtf_varchar2_table_100 := NULL,
p_l_attribute_category IN jtf_varchar2_table_100 := NULL,
p_l_attribute1 IN jtf_varchar2_table_200 := NULL,
p_l_attribute2 IN jtf_varchar2_table_200 := NULL,
p_l_attribute3 IN jtf_varchar2_table_200 := NULL,
p_l_attribute4 IN jtf_varchar2_table_200 := NULL,
p_l_attribute5 IN jtf_varchar2_table_200 := NULL,
p_l_attribute6 IN jtf_varchar2_table_200 := NULL,
p_l_attribute7 IN jtf_varchar2_table_200 := NULL,
p_l_attribute8 IN jtf_varchar2_table_200 := NULL,
p_l_attribute9 IN jtf_varchar2_table_200 := NULL,
p_l_attribute10 IN jtf_varchar2_table_200 := NULL,
p_l_attribute11 IN jtf_varchar2_table_200 := NULL,
p_l_attribute12 IN jtf_varchar2_table_200 := NULL,
p_l_attribute13 IN jtf_varchar2_table_200 := NULL,
p_l_attribute14 IN jtf_varchar2_table_200 := NULL,
p_l_attribute15 IN jtf_varchar2_table_200 := NULL,
p_l_org_id IN jtf_number_table := NULL
) RETURN IBE_Shop_List_PVT.SL_Line_Tbl_Type
IS
sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type
:= IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;
IF p_l_last_updated_by(i) = ROSETTA_G_MISS_NUM THEN
sl_line_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
sl_line_tbl(i).last_updated_by := p_l_last_updated_by(i);
IF p_l_last_update_date(i) = ROSETTA_G_MISTAKE_DATE THEN
sl_line_tbl(i).last_update_date := FND_API.G_MISS_DATE;
sl_line_tbl(i).last_update_date := p_l_last_update_date(i);
IF p_l_last_update_login(i) = ROSETTA_G_MISS_NUM THEN
sl_line_tbl(i).last_update_login := FND_API.G_MISS_NUM;
sl_line_tbl(i).last_update_login := p_l_last_update_login(i);
IF p_l_program_update_date(i) = ROSETTA_G_MISTAKE_DATE THEN
sl_line_tbl(i).program_update_date := FND_API.G_MISS_DATE;
sl_line_tbl(i).program_update_date := p_l_program_update_date(i);
p_lr_program_update_date IN jtf_date_table := NULL,
p_lr_object_version_number IN jtf_number_table := NULL,
p_lr_created_by IN jtf_number_table := NULL,
p_lr_creation_date IN jtf_date_table := NULL,
p_lr_last_updated_by IN jtf_number_table := NULL,
p_lr_last_update_date IN jtf_date_table := NULL,
p_lr_last_update_login IN jtf_number_table := NULL,
p_lr_shp_list_item_id IN jtf_number_table := NULL,
p_lr_line_index IN jtf_number_table := NULL,
p_lr_related_shp_list_item_id IN jtf_number_table := NULL,
p_lr_related_line_index IN jtf_number_table := NULL,
p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL
) RETURN IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
IS
sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
:= IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;
IF p_lr_program_update_date(i) = ROSETTA_G_MISTAKE_DATE THEN
sl_line_rel_tbl(i).program_update_date := FND_API.G_MISS_DATE;
sl_line_rel_tbl(i).program_update_date := p_lr_program_update_date(i);
IF p_lr_last_updated_by(i) = ROSETTA_G_MISS_NUM THEN
sl_line_rel_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
sl_line_rel_tbl(i).last_updated_by := p_lr_last_updated_by(i);
IF p_lr_last_update_date(i) = ROSETTA_G_MISTAKE_DATE THEN
sl_line_rel_tbl(i).last_update_date := FND_API.G_MISS_DATE;
sl_line_rel_tbl(i).last_update_date := p_lr_last_update_date(i);
IF p_lr_last_update_login(i) = ROSETTA_G_MISS_NUM THEN
sl_line_rel_tbl(i).last_update_login := FND_API.G_MISS_NUM;
sl_line_rel_tbl(i).last_update_login := p_lr_last_update_login(i);
p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
p_l_shp_list_item_id IN jtf_number_table := NULL ,
p_l_object_version_number IN jtf_number_table := NULL ,
p_l_creation_date IN jtf_date_table := NULL ,
p_l_created_by IN jtf_number_table := NULL ,
p_l_last_updated_by IN jtf_number_table := NULL ,
p_l_last_update_date IN jtf_date_table := NULL ,
p_l_last_update_login IN jtf_number_table := NULL ,
p_l_request_id IN jtf_number_table := NULL ,
p_l_program_id IN jtf_number_table := NULL ,
p_l_program_application_id IN jtf_number_table := NULL ,
p_l_program_update_date IN jtf_date_table := NULL ,
p_l_shp_list_id IN jtf_number_table := NULL ,
p_l_inventory_item_id IN jtf_number_table := NULL ,
p_l_organization_id IN jtf_number_table := NULL ,
p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
p_l_quantity IN jtf_number_table := NULL ,
p_l_config_header_id IN jtf_number_table := NULL ,
p_l_config_revision_num IN jtf_number_table := NULL ,
p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,
p_l_attribute1 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute2 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute3 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute4 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute5 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute6 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute7 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute8 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute9 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute10 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute11 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
p_l_org_id IN jtf_number_table := NULL ,
p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
p_lr_request_id IN jtf_number_table := NULL ,
p_lr_program_application_id IN jtf_number_table := NULL ,
p_lr_program_id IN jtf_number_table := NULL ,
p_lr_program_update_date IN jtf_date_table := NULL ,
p_lr_object_version_number IN jtf_number_table := NULL ,
p_lr_created_by IN jtf_number_table := NULL ,
p_lr_creation_date IN jtf_date_table := NULL ,
p_lr_last_updated_by IN jtf_number_table := NULL ,
p_lr_last_update_date IN jtf_date_table := NULL ,
p_lr_last_update_login IN jtf_number_table := NULL ,
p_lr_shp_list_item_id IN jtf_number_table := NULL ,
p_lr_line_index IN jtf_number_table := NULL ,
p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
p_lr_related_line_index IN jtf_number_table := NULL ,
p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
x_sl_header_id OUT NOCOPY NUMBER
)
IS
l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
p_h_program_update_date => p_h_program_update_date,
p_h_object_version_number => p_h_object_version_number,
p_h_created_by => p_h_created_by,
p_h_creation_date => p_h_creation_date,
p_h_last_updated_by => p_h_last_updated_by,
p_h_last_update_date => p_h_last_update_date,
p_h_last_update_login => p_h_last_update_login,
p_h_party_id => p_h_party_id,
p_h_cust_account_id => p_h_cust_account_id,
p_h_shopping_list_name => p_h_shopping_list_name,
p_h_description => p_h_description,
p_h_attribute_category => p_h_attribute_category,
p_h_attribute1 => p_h_attribute1,
p_h_attribute2 => p_h_attribute2,
p_h_attribute3 => p_h_attribute3,
p_h_attribute4 => p_h_attribute4,
p_h_attribute5 => p_h_attribute5,
p_h_attribute6 => p_h_attribute6,
p_h_attribute7 => p_h_attribute7,
p_h_attribute8 => p_h_attribute8,
p_h_attribute9 => p_h_attribute9,
p_h_attribute10 => p_h_attribute10,
p_h_attribute11 => p_h_attribute11,
p_h_attribute12 => p_h_attribute11,
p_h_attribute13 => p_h_attribute13,
p_h_attribute14 => p_h_attribute14,
p_h_attribute15 => p_h_attribute15,
p_h_org_id => p_h_org_id);
p_l_last_updated_by => p_l_last_updated_by ,
p_l_last_update_date => p_l_last_update_date ,
p_l_last_update_login => p_l_last_update_login ,
p_l_request_id => p_l_request_id ,
p_l_program_id => p_l_program_id ,
p_l_program_application_id => p_l_program_application_id ,
p_l_program_update_date => p_l_program_update_date ,
p_l_shp_list_id => p_l_shp_list_id ,
p_l_inventory_item_id => p_l_inventory_item_id ,
p_l_organization_id => p_l_organization_id ,
p_l_uom_code => p_l_uom_code ,
p_l_quantity => p_l_quantity ,
p_l_config_header_id => p_l_config_header_id ,
p_l_config_revision_num => p_l_config_revision_num ,
p_l_complete_config_flag => p_l_complete_config_flag ,
p_l_valid_configuration_flag => p_l_valid_configuration_flag,
p_l_item_type_code => p_l_item_type_code ,
p_l_attribute_category => p_l_attribute_category ,
p_l_attribute1 => p_l_attribute1 ,
p_l_attribute2 => p_l_attribute2 ,
p_l_attribute3 => p_l_attribute3 ,
p_l_attribute4 => p_l_attribute4 ,
p_l_attribute5 => p_l_attribute5 ,
p_l_attribute6 => p_l_attribute6 ,
p_l_attribute7 => p_l_attribute7 ,
p_l_attribute8 => p_l_attribute8 ,
p_l_attribute9 => p_l_attribute9 ,
p_l_attribute10 => p_l_attribute10 ,
p_l_attribute11 => p_l_attribute11 ,
p_l_attribute12 => p_l_attribute12 ,
p_l_attribute13 => p_l_attribute13 ,
p_l_attribute14 => p_l_attribute14 ,
p_l_attribute15 => p_l_attribute15 ,
p_l_org_id => p_l_org_id);
p_lr_program_update_date => p_lr_program_update_date ,
p_lr_object_version_number => p_lr_object_version_number ,
p_lr_created_by => p_lr_created_by ,
p_lr_creation_date => p_lr_creation_date ,
p_lr_last_updated_by => p_lr_last_updated_by ,
p_lr_last_update_date => p_lr_last_update_date ,
p_lr_last_update_login => p_lr_last_update_login ,
p_lr_shp_list_item_id => p_lr_shp_list_item_id ,
p_lr_line_index => p_lr_line_index ,
p_lr_related_shp_list_item_id => p_lr_related_shp_list_item_id,
p_lr_related_line_index => p_lr_related_line_index ,
p_lr_relationship_type_code => p_lr_relationship_type_code);
p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
x_sl_header_id OUT NOCOPY NUMBER
)
IS
l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
p_h_program_update_date => p_h_program_update_date,
p_h_object_version_number => p_h_object_version_number,
p_h_created_by => p_h_created_by,
p_h_creation_date => p_h_creation_date,
p_h_last_updated_by => p_h_last_updated_by,
p_h_last_update_date => p_h_last_update_date,
p_h_last_update_login => p_h_last_update_login,
p_h_party_id => p_h_party_id,
p_h_cust_account_id => p_h_cust_account_id,
p_h_shopping_list_name => p_h_shopping_list_name,
p_h_description => p_h_description,
p_h_attribute_category => p_h_attribute_category,
p_h_attribute1 => p_h_attribute1,
p_h_attribute2 => p_h_attribute2,
p_h_attribute3 => p_h_attribute3,
p_h_attribute4 => p_h_attribute4,
p_h_attribute5 => p_h_attribute5,
p_h_attribute6 => p_h_attribute6,
p_h_attribute7 => p_h_attribute7,
p_h_attribute8 => p_h_attribute8,
p_h_attribute9 => p_h_attribute9,
p_h_attribute10 => p_h_attribute10,
p_h_attribute11 => p_h_attribute11,
p_h_attribute12 => p_h_attribute11,
p_h_attribute13 => p_h_attribute13,
p_h_attribute14 => p_h_attribute14,
p_h_attribute15 => p_h_attribute15,
p_h_org_id => p_h_org_id);
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_mode IN VARCHAR2 := 'MERGE' ,
p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
x_sl_header_id OUT NOCOPY NUMBER
)
IS
l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
p_h_program_update_date => p_h_program_update_date,
p_h_object_version_number => p_h_object_version_number,
p_h_created_by => p_h_created_by,
p_h_creation_date => p_h_creation_date,
p_h_last_updated_by => p_h_last_updated_by,
p_h_last_update_date => p_h_last_update_date,
p_h_last_update_login => p_h_last_update_login,
p_h_party_id => p_h_party_id,
p_h_cust_account_id => p_h_cust_account_id,
p_h_shopping_list_name => p_h_shopping_list_name,
p_h_description => p_h_description,
p_h_attribute_category => p_h_attribute_category,
p_h_attribute1 => p_h_attribute1,
p_h_attribute2 => p_h_attribute2,
p_h_attribute3 => p_h_attribute3,
p_h_attribute4 => p_h_attribute4,
p_h_attribute5 => p_h_attribute5,
p_h_attribute6 => p_h_attribute6,
p_h_attribute7 => p_h_attribute7,
p_h_attribute8 => p_h_attribute8,
p_h_attribute9 => p_h_attribute9,
p_h_attribute10 => p_h_attribute10,
p_h_attribute11 => p_h_attribute11,
p_h_attribute12 => p_h_attribute11,
p_h_attribute13 => p_h_attribute13,
p_h_attribute14 => p_h_attribute14,
p_h_attribute15 => p_h_attribute15,
p_h_org_id => p_h_org_id);
p_last_update_date => p_last_update_date ,
p_mode => p_mode ,
p_sl_header_rec => l_sl_header_rec ,
p_combine_same_item => p_combine_same_item ,
x_sl_header_id => x_sl_header_id);
p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
-- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,
p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_email_address IN jtf_varchar2_table_2000 := NULL,
p_privilege_type IN jtf_varchar2_table_100 := NULL,
p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_promocode IN VARCHAR2 := FND_API.G_MISS_CHAR, --added for R12
x_q_header_id OUT NOCOPY NUMBER
)
IS
l_control_rec ASO_QUOTE_PUB.Control_Rec_Type
:= ASO_QUOTE_PUB.G_MISS_CONTROL_REC;
p_c_last_update_date => p_c_last_update_date ,
p_c_auto_version_flag => p_c_auto_version_flag ,
p_c_pricing_request_type => p_c_pricing_request_type,
p_c_header_pricing_event => p_c_header_pricing_event,
p_c_line_pricing_event => p_c_line_pricing_event ,
p_c_cal_tax_flag => p_c_cal_tax_flag ,
p_c_cal_freight_charge_flag => p_c_cal_freight_charge_flag,
p_c_price_mode => p_c_price_mode);
p_h_last_updated_by => p_h_last_updated_by ,
p_h_last_update_date => p_h_last_update_date ,
p_h_last_update_login => p_h_last_update_login ,
p_h_request_id => p_h_request_id ,
p_h_program_application_id => p_h_program_application_id ,
p_h_program_id => p_h_program_id ,
p_h_program_update_date => p_h_program_update_date ,
p_h_org_id => p_h_org_id ,
p_h_quote_name => p_h_quote_name ,
p_h_quote_number => p_h_quote_number ,
p_h_quote_version => p_h_quote_version ,
p_h_quote_status_id => p_h_quote_status_id ,
p_h_quote_source_code => p_h_quote_source_code ,
p_h_quote_expiration_date => p_h_quote_expiration_date ,
p_h_price_frozen_date => p_h_price_frozen_date ,
p_h_quote_password => p_h_quote_password ,
p_h_original_system_reference => p_h_original_system_reference ,
p_h_party_id => p_h_party_id ,
p_h_cust_account_id => p_h_cust_account_id ,
p_h_org_contact_id => p_h_org_contact_id ,
p_h_party_name => p_h_party_name ,
p_h_party_type => p_h_party_type ,
p_h_person_first_name => p_h_person_first_name ,
p_h_person_last_name => p_h_person_last_name ,
p_h_person_middle_name => p_h_person_middle_name ,
p_h_phone_id => p_h_phone_id ,
p_h_price_list_id => p_h_price_list_id ,
p_h_pricing_status_indicator => p_h_pricing_status_indicator , -- change line logic pricing
p_h_tax_status_indicator => p_h_tax_status_indicator ,
p_h_price_list_name => p_h_price_list_name ,
p_h_currency_code => p_h_currency_code ,
p_h_total_list_price => p_h_total_list_price ,
p_h_total_adjusted_amount => p_h_total_adjusted_amount ,
p_h_total_adjusted_percent => p_h_total_adjusted_percent ,
p_h_total_tax => p_h_total_tax ,
p_h_total_shipping_charge => p_h_total_shipping_charge ,
p_h_surcharge => p_h_surcharge ,
p_h_total_quote_price => p_h_total_quote_price ,
p_h_payment_amount => p_h_payment_amount ,
p_h_accounting_rule_id => p_h_accounting_rule_id ,
p_h_exchange_rate => p_h_exchange_rate ,
p_h_exchange_type_code => p_h_exchange_type_code ,
p_h_exchange_rate_date => p_h_exchange_rate_date ,
p_h_quote_category_code => p_h_quote_category_code ,
p_h_quote_status_code => p_h_quote_status_code ,
p_h_quote_status => p_h_quote_status ,
p_h_employee_person_id => p_h_employee_person_id ,
p_h_sales_channel_code => p_h_sales_channel_code ,
-- p_h_salesrep_full_name => p_h_salesrep_full_name ,
p_h_attribute_category => p_h_attribute_category ,
p_h_attribute1 => p_h_attribute1 ,
p_h_attribute10 => p_h_attribute10 ,
p_h_attribute11 => p_h_attribute11 ,
p_h_attribute12 => p_h_attribute12 ,
p_h_attribute13 => p_h_attribute13 ,
p_h_attribute14 => p_h_attribute14 ,
p_h_attribute15 => p_h_attribute15 ,
p_h_attribute2 => p_h_attribute2 ,
p_h_attribute3 => p_h_attribute3 ,
p_h_attribute4 => p_h_attribute4 ,
p_h_attribute5 => p_h_attribute5 ,
p_h_attribute6 => p_h_attribute6 ,
p_h_attribute7 => p_h_attribute7 ,
p_h_attribute8 => p_h_attribute8 ,
p_h_attribute9 => p_h_attribute9 ,
p_h_contract_id => p_h_contract_id ,
p_h_qte_contract_id => p_h_qte_contract_id ,
p_h_ffm_request_id => p_h_ffm_request_id ,
p_h_invoice_to_address1 => p_h_invoice_to_address1 ,
p_h_invoice_to_address2 => p_h_invoice_to_address2 ,
p_h_invoice_to_address3 => p_h_invoice_to_address3 ,
p_h_invoice_to_address4 => p_h_invoice_to_address4 ,
p_h_invoice_to_city => p_h_invoice_to_city ,
p_h_invoice_to_cont_first_name => p_h_invoice_to_cont_first_name,
p_h_invoice_to_cont_last_name => p_h_invoice_to_cont_last_name ,
p_h_invoice_to_cont_mid_name => p_h_invoice_to_cont_mid_name ,
p_h_invoice_to_country_code => p_h_invoice_to_country_code ,
p_h_invoice_to_country => p_h_invoice_to_country ,
p_h_invoice_to_county => p_h_invoice_to_county ,
p_h_invoice_to_party_id => p_h_invoice_to_party_id ,
p_h_invoice_to_party_name => p_h_invoice_to_party_name ,
p_h_invoice_to_party_site_id => p_h_invoice_to_party_site_id ,
p_h_invoice_to_postal_code => p_h_invoice_to_postal_code ,
p_h_invoice_to_province => p_h_invoice_to_province ,
p_h_invoice_to_state => p_h_invoice_to_state ,
p_h_invoicing_rule_id => p_h_invoicing_rule_id ,
p_h_marketing_source_code_id => p_h_marketing_source_code_id ,
p_h_marketing_source_code => p_h_marketing_source_code ,
p_h_marketing_source_name => p_h_marketing_source_name ,
p_h_orig_mktg_source_code_id => p_h_orig_mktg_source_code_id ,
p_h_order_type_id => p_h_order_type_id ,
p_h_order_id => p_h_order_id ,
p_h_order_number => p_h_order_number ,
p_h_order_type_name => p_h_order_type_name ,
p_h_ordered_date => p_h_ordered_date ,
p_h_resource_id => p_h_resource_id);