DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_WRAPPER_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

   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;
Line: 21

   IF p_c_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
      control_rec.last_update_date := FND_API.G_MISS_DATE;
Line: 24

      control_rec.last_update_date := p_c_last_update_date;
Line: 41

   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;
Line: 156

   IF p_h_last_updated_by = ROSETTA_G_MISS_NUM THEN
      q_header_rec.last_updated_by := FND_API.G_MISS_NUM;
Line: 159

      q_header_rec.last_updated_by := p_h_last_updated_by;
Line: 161

   IF p_h_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
      q_header_rec.last_update_date := FND_API.G_MISS_DATE;
Line: 164

      q_header_rec.last_update_date := p_h_last_update_date;
Line: 166

   IF p_h_last_update_login = ROSETTA_G_MISS_NUM THEN
      q_header_rec.last_update_login := FND_API.G_MISS_NUM;
Line: 169

      q_header_rec.last_update_login := p_h_last_update_login;
Line: 186

   IF p_h_program_update_date = ROSETTA_G_MISTAKE_DATE THEN
      q_header_rec.program_update_date := FND_API.G_MISS_DATE;
Line: 189

      q_header_rec.program_update_date := p_h_program_update_date;
Line: 435

   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;
Line: 487

   IF p_h_program_update_date = ROSETTA_G_MISTAKE_DATE THEN
      sl_header_rec.program_update_date := FND_API.G_MISS_DATE;
Line: 490

      sl_header_rec.program_update_date := p_h_program_update_date;
Line: 507

   IF p_h_last_updated_by = ROSETTA_G_MISS_NUM THEN
      sl_header_rec.last_updated_by := FND_API.G_MISS_NUM;
Line: 510

      sl_header_rec.last_updated_by := p_h_last_updated_by;
Line: 512

   IF p_h_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
      sl_header_rec.last_update_date := FND_API.G_MISS_DATE;
Line: 515

      sl_header_rec.last_update_date := p_h_last_update_date;
Line: 517

   IF p_h_last_update_login = ROSETTA_G_MISS_NUM THEN
      sl_header_rec.last_update_login := FND_API.G_MISS_NUM;
Line: 520

      sl_header_rec.last_update_login := p_h_last_update_login;
Line: 565

   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;
Line: 638

         IF p_l_last_updated_by(i) = ROSETTA_G_MISS_NUM THEN
            sl_line_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
Line: 641

            sl_line_tbl(i).last_updated_by := p_l_last_updated_by(i);
Line: 645

         IF p_l_last_update_date(i) = ROSETTA_G_MISTAKE_DATE THEN
            sl_line_tbl(i).last_update_date := FND_API.G_MISS_DATE;
Line: 648

            sl_line_tbl(i).last_update_date := p_l_last_update_date(i);
Line: 652

         IF p_l_last_update_login(i) = ROSETTA_G_MISS_NUM THEN
            sl_line_tbl(i).last_update_login := FND_API.G_MISS_NUM;
Line: 655

            sl_line_tbl(i).last_update_login := p_l_last_update_login(i);
Line: 680

         IF p_l_program_update_date(i) = ROSETTA_G_MISTAKE_DATE THEN
            sl_line_tbl(i).program_update_date := FND_API.G_MISS_DATE;
Line: 683

            sl_line_tbl(i).program_update_date := p_l_program_update_date(i);
Line: 806

   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;
Line: 857

         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;
Line: 860

            sl_line_rel_tbl(i).program_update_date := p_lr_program_update_date(i);
Line: 885

         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;
Line: 888

            sl_line_rel_tbl(i).last_updated_by := p_lr_last_updated_by(i);
Line: 892

         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;
Line: 895

            sl_line_rel_tbl(i).last_update_date := p_lr_last_update_date(i);
Line: 899

         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;
Line: 902

            sl_line_rel_tbl(i).last_update_login := p_lr_last_update_login(i);
Line: 954

   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;
Line: 1049

      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);
Line: 1083

      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);
Line: 1123

      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);
Line: 1166

   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;
Line: 1204

      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);
Line: 1259

   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;
Line: 1304

      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);
Line: 1343

      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);
Line: 1366

   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;
Line: 1488

      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);
Line: 1501

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