2012年6月8日
OE_HOLDS_PUB.RELEASE_HOLDS -- Release Holds Script
摘要： Below script will help you to Release Order level or Line Level hold in Oracle Order Management through API OE_HOLDS_PUB.RELEASE_HOLDSThis script was tested in R12.1.1SET serveroutput ON;DECLARE v_return_status VARCHAR2(30); v_msg_data VARCHAR2(4000); v_msg_count NUMBER; v_order_tbl OE_HOLDS_PVT.ord 阅读全文
posted @ 2012-06-08 11:50 郭振斌 阅读(873) 评论(0) 推荐(0) 编辑
OE_ORDER_PUB.PROCESS_ORDER to Apply hold on a sales order
摘要： PURPOSE:This post is to provide a sample script to Apply hold on a sales order using an API OE_ORDER_PUB.PROCESS_ORDER.TEST INSTANCE: R12.1.1SCRIPT:SET SERVEROUTPUT ON;DECLAREv_api_version_number NUMBER:= 1;v_return_status VARCHAR2 (2000);v_msg_count NUMBER;v_msg_data VARCHAR2 (2000);-- IN Variables 阅读全文
posted @ 2012-06-08 10:43 郭振斌 阅读(1186) 评论(0) 推荐(0) 编辑