oe_order_pub 创建登记销售订单

最新推荐文章于 2023-12-28 16:11:01 发布

shishun123

最新推荐文章于 2023-12-28 16:11:01 发布

阅读量2.8k

点赞数

CC 4.0 BY-SA版权

分类专栏： ORACLE EBS 文章标签： header action date list api null

本文链接：https://blog.youkuaiyun.com/shishun123/article/details/5795736

这篇博客展示了如何在Oracle E-Business Suite中使用PL/SQL调用oe_order_pub过程来创建销售订单。代码详细定义了所需的数据结构并初始化变量，然后调用oe_order_pub.process_order API，处理订单并记录返回的错误信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

DECLARE
    l_api_version_number     CONSTANT NUMBER := 1.0;
    l_api_name               CONSTANT VARCHAR2(30) := 'cux_create_order';
    l_control_rec            oe_globals.control_rec_type;
    l_return_status          VARCHAR2(1);
    l_msg_count              NUMBER;
    l_line_con               NUMBER := 0;
    x_msg_data               VARCHAR2(1000);
    l_source_id              NUMBER := 0;
    l_header_rec             oe_order_pub.header_rec_type := oe_order_pub.g_miss_header_rec;
    o_header_rec             oe_order_pub.header_rec_type;
    l_header_val_rec         oe_order_pub.header_val_rec_type;
    l_header_adj_tbl         oe_order_pub.header_adj_tbl_type;
    l_header_adj_val_tbl     oe_order_pub.header_adj_val_tbl_type;
    l_header_price_att_tbl   oe_order_pub.header_price_att_tbl_type;
    l_header_adj_att_tbl     oe_order_pub.header_adj_att_tbl_type;
    l_header_adj_assoc_tbl   oe_order_pub.header_adj_assoc_tbl_type;
    l_header_scredit_tbl     oe_order_pub.header_scredit_tbl_type;
    l_header_scredit_val_tbl oe_order_pub.header_scredit_val_tbl_type;
    l_line_tbl               oe_order_pub.line_tbl_type := oe_order_pub.g_miss_line_tbl;
    o_line_tbl               oe_order_pub.line_tbl_type;
    l_line_adj_tbl           oe_order_pub.line_adj_tbl_type;
    l_line_price_att_tbl     oe_order_pub.line_price_att_tbl_type;
    l_line_adj_att_tbl       oe_order_pub.line_adj_att_tbl_type;
    l_line_adj_assoc_tbl     oe_order_pub.line_adj_assoc_tbl_type;
    l_line_scredit_tbl       oe_order_pub.line_scredit_tbl_type;
    l_lot_serial_tbl         oe_order_pub.lot_serial_tbl_type;
    l_line_val_tbl           oe_order_pub.line_val_tbl_type;
    l_line_adj_val_tbl       oe_order_pub.line_adj_val_tbl_type;
    l_line_scredit_val_tbl   oe_order_pub.line_scredit_val_tbl_type;

    l_lot_serial_val_tbl     oe_order_pub.lot_serial_val_tbl_type;
    l_action_qeq_tbl         oe_order_pub.request_tbl_type;
    x_action_qeq_tbl         oe_order_pub.request_tbl_type;

    v_count               NUMBER;
    l_customer_id  &nbs