Showing posts with label ato relation. Show all posts
Showing posts with label ato relation. Show all posts

Thursday, June 27, 2013

Create relation for ATO products

Create relation for ATO products

This will create all entry's in line_detail table and line table and line relation table fro ATO items


      l_model_line_rec.quote_line_id := l_model_quote_line_id;
      l_model_line_rec.quote_header_id := p_active_header_id;
      l_model_line_rec.org_id := l_org_id;
      --l_model_line_rec. line_category_code            := 'ORDER';
      l_model_line_rec.item_type_code := 'MDL';
      l_model_line_rec.organization_id := li_organization_id;
      l_model_line_rec.inventory_item_id := l_cfg_inventory_item_id;
      l_model_line_rec.quantity := 1;
      l_model_line_rec.order_line_type_id := 1028;
      l_model_line_rec.price_list_id := l_cfg_price_list_id;
      -----------------------------
      l_config_rec.quote_line_id := l_model_quote_line_id;
      l_config_rec.qte_line_index := 1;
      l_config_rec.complete_configuration_flag := 'Y';
      l_config_rec.valid_configuration_flag := 'Y';
      l_config_rec.config_header_id := l_new_config_hdr_id;
      l_config_rec.config_revision_num := l_new_config_rev_nbr;
      l_config_rec.quote_line_detail_id := l_aso_quote_line_detail_id;
      ------------------------------
      --control details --
      l_control_rec.pricing_request_type := 'ASO';
      l_control_rec.calculate_freight_charge_flag := 'Y';
      l_control_rec.calculate_tax_flag := 'Y';
      l_control_rec.header_pricing_event := 'BATCH';
      l_control_rec.price_mode := 'ENTIRE_QUOTE';
      l_return_message := NULL;
      l_return_status := NULL;
      l_msg_count := NULL;
      l_msg_data := NULL;

      aso_cfg_pub.get_config_details (
         p_api_version_number   => c_api_version1,
         p_init_msg_list        => l_init_msg_list,
         p_commit               => l_commit,
         p_control_rec          => l_control_rec,
         p_config_rec           => l_config_rec,
         p_model_line_rec       => l_model_line_rec,
         p_config_hdr_id        => l_new_config_hdr_id,
         p_config_rev_nbr       => l_new_config_rev_nbr,
         p_quote_header_id      => p_active_header_id,
         x_return_status        => l_return_status,
         x_msg_count            => l_msg_count,
         x_msg_data             => l_msg_data
      );