调用API进行销售订单发放代码,OracleEBS代码库,德仔网

代码语言
代码分类
【OracleEBS】调用API进行销售订单发放
作者:Dezai.CN / 发布于2013/1/5/ 905
fnd_profile.PUT('MFG_ORGANIZATION_ID',l_organization_id);
              
          wsh_picking_batches_pkg.insert_row(x_rowid                       => l_row_id,
                                             x_batch_id                    => l_batch_id,
                                             p_creation_date               => g_sysdate,
                                             p_created_by                  => g_user_id,
                                             p_last_update_date            => g_sysdate,
                                             p_last_updated_by             => g_user_id,
                                             p_last_update_login           => g_login_id,
                                             p_batch_name_prefix           => NULL,
                                             x_name                        => l_name,
                                             p_backorders_only_flag        => l_rule_rec.backorders_only_flag,
                                             p_document_set_id             => l_rule_rec.document_set_id,
                                             p_existing_rsvs_only_flag     => l_rule_rec.existing_rsvs_only_flag,
                                             p_shipment_priority_code      => l_rule_rec.shipment_priority_code,
                                             p_ship_method_code            => l_rule_rec.ship_method_code,
                                             p_customer_id                 => l_customer_id,
                                             p_order_header_id             => rec_data.order_header_id,
                                             p_ship_set_number             => l_rule_rec.ship_set_number,
                                             p_inventory_item_id           => NULL,
                                             p_order_type_id               => l_order_type_id,
                                             p_from_requested_date         => NULL,
                                             p_to_requested_date           => NULL,
                                             p_from_scheduled_ship_date    => NULL,
                                             p_to_scheduled_ship_date      => NULL,
                                             p_ship_to_location_id         => l_rule_rec.ship_to_location_id,
                                             p_ship_from_location_id       => l_rule_rec.ship_from_location_id/*l_stage_locator_id*/,
                                             p_trip_id                     => NULL,
                                             p_delivery_id                 => NULL,
                                             p_include_planned_lines       => l_rule_rec.include_planned_lines,
                                             p_pick_grouping_rule_id        => l_rule_rec.pick_grouping_rule_id,
                                             p_pick_sequence_rule_id       => l_rule_rec.pick_sequence_rule_id,
                                             p_autocreate_delivery_flag    => 'Y', --l_rule_rec.autocreate_delivery_flag;
                                             --无论规则是否自动创建交货号，都让系统自动创建(用shipment_number做交货号)
                                             p_attribute_category          => NULL,
                                             p_attribute1                  => NULL,
                                             p_attribute2                  => NULL,
                                             p_attribute3                  => NULL,
                                             p_attribute4                  => NULL,
                                             p_attribute5                  => NULL,
                                             p_attribute6                  => NULL,
                                             p_attribute7                  => NULL,
                                             p_attribute8                  => NULL,
                                             p_attribute9                  => NULL,
                                             p_attribute10                 => NULL,
                                             p_attribute11                 => NULL,
                                             p_attribute12                 => NULL,
                                             p_attribute13                 => NULL,
                                             p_attribute14                 => NULL,
                                             p_attribute15                 => NULL,
                                             p_autodetail_pr_flag          => l_rule_rec.autodetail_pr_flag,
                                             p_carrier_id                  => l_rule_rec.carrier_id,
                                             p_trip_stop_id                => NULL,
                                             p_default_stage_subinventory  => l_rule_rec.default_stage_subinventory,--ERP临时发货区
                                             p_default_stage_locator_id    => l_stage_locator_id,
                                             p_pick_from_subinventory      => rec_data.pick_from_subinventory,/*l_rule_rec.pick_from_subinventory,*/--ERP提货区
                                             p_pick_from_locator_id        => l_locator_id,--l_rule_rec.pick_from_locator_id,
                                             p_auto_pick_confirm_flag      => 'N'/*l_rule_rec.auto_pick_confirm_flag*/,
                                             --无论规则是否自动确认挑库，都不让系统自动挑库(可能会修改分配数)
                                             p_delivery_detail_id          => NULL,
                                             p_project_id                  => rec_data.project_id,
                                             p_task_id                     => rec_data.task_id,
                                             p_organization_id             => l_organization_id,
                                             p_ship_confirm_rule_id        => l_rule_rec.ship_confirm_rule_id,
                                             p_autopack_flag               => l_rule_rec.autopack_flag,
                                             p_autopack_level              => l_rule_rec.autopack_level,
                                             p_task_planning_flag          => l_rule_rec.task_planning_flag,
                                             p_non_picking_flag            => NULL,
                                             p_regionid                     => l_rule_rec.region_id,
                                             p_zoneid                       => l_rule_rec.zone_id,
                                             p_categoryid                   => l_rule_rec.category_id,
                                             p_categorysetid               => l_rule_rec.category_set_id,
                                             p_acdelivcriteria             => l_rule_rec.ac_delivery_criteria,
                                             p_relsubinventory             => l_rule_rec.rel_subinventory,
                                                                             --如果规则不做限制则可以任意子库中挑库
                                                                             --nvl(p_subinventory_from,l_rule_rec.rel_subinventory),
                                                                             --如果在此处修改来源子库会导致发放不成功 不能创建物料搬运单
                                             p_append_flag                 => l_rule_rec.append_flag,
                                             p_task_priority               => l_rule_rec.task_priority,
                                             p_ship_set_smc_flag           => NULL,
                                             p_actual_departure_date       => NULL,
                                             p_allocation_method           => l_rule_rec.allocation_method,
                                             p_crossdock_criteria_id       => l_rule_rec.crossdock_criteria_id,
                                             p_delivery_name_lo            => NULL,
                                             p_delivery_name_hi            => NULL,
                                             p_bol_number_lo               => NULL,
                                             p_bol_number_hi               => NULL,
                                             p_intmed_ship_to_loc_id       => NULL,
                                             p_pooled_ship_to_loc_id       => NULL,
                                             p_fob_code                    => NULL,
                                             p_freight_terms_code          => NULL,
                                             p_pickup_date_lo              => NULL,
                                             p_pickup_date_hi              => NULL,
                                             p_dropoff_date_lo             => NULL,
                                             p_dropoff_date_hi             => NULL,
                                             p_planned_flag                => NULL,
                                             p_selected_batch_id           => NULL);
          IF l_batch_id IS NULL THEN
            l_err_code := g_warning;
            l_err_msg  := '销售订单发放没有产生批号';
            GOTO next_line;
          END IF;
试试其它关键字
　销售订单发放　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)