DECLARE
L_HEADER_REC OE_ORDER_PUB.HEADER_REC_TYPE;
L_LINE_TBL OE_ORDER_PUB.LINE_TBL_TYPE;
L_ACTION_REQUEST_TBL OE_ORDER_PUB.REQUEST_TBL_TYPE;
L_PROCESS NUMBER;
LINE_RES_T_TYPE XYG_SHIP_PREPARE_PKG.LINE_RES_T_TYPE;
---------------
P_OLD_HEADER_REC OE_ORDER_PUB.HEADER_REC_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_REC ;
P_HEADER_VAL_REC OE_ORDER_PUB.HEADER_VAL_REC_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_VAL_REC ;
P_OLD_HEADER_VAL_REC OE_ORDER_PUB.HEADER_VAL_REC_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_VAL_REC ;
P_HEADER_ADJ_TBL OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL ;
P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL ;
P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_ADJ_VAL_TBL ;
P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_ADJ_VAL_TBL ;
P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL ;
P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL ;
P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL ;
P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL ;
P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL ;
P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL ;
P_HEADER_SCREDIT_TBL OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL ;
P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL ;
P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_VAL_TBL ;
P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_VAL_TBL ;
P_LINE_TBL OE_ORDER_PUB.LINE_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_LINE_TBL ;
P_OLD_LINE_TBL OE_ORDER_PUB.LINE_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_LINE_TBL ;
P_LINE_VAL_TBL OE_ORDER_PUB.LINE_VAL_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_LINE_VAL_TBL ;
P_OLD_LINE_VAL_TBL OE_ORDER_PUB.LINE_VAL_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_LINE_VAL_TBL ;
P_LINE_ADJ_TBL OE_ORDER_PUB.LINE_ADJ_TBL_TYPE
:= OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL ;
P_OLD_LINE_ADJ_TBL OE_ORDER_PUB.LINE_ADJ_TBL_TYPE
利用API生成SO订单
最新推荐文章于 2023-10-23 10:51:53 发布