通过提交请求“清除指示符”删除预测示例代码:
DECLARE
Ln_Request_Id NUMBER;
Ln_Organization_Id NUMBER := 129; --库存组织
Lv_Forecast_Designator VARCHAR2(10) := 'FT170103'; --预测
BEGIN
--职责初始化
Fnd_Global.Apps_Initialize(User_Id => 110
,Resp_Id => 56502
,Resp_Appl_Id => 20003);
--提交请求
Ln_Request_Id := Fnd_Request.Submit_Request('MRP'
,'MRCPRG'
,''
,''
,FALSE
,Ln_Organization_Id
,Lv_Forecast_Designator
,'FORECAST_DESIG');
COMMIT;
IF (Ln_Request_Id > 0) THEN
Dbms_Output.Put_Line('请求“清除指示符”清除预测[' || Lv_Forecast_Designator ||']提交成功,请求标识:' || Ln_Request_Id);
ELSE
Dbms_Output.Put_Line('提交请求“清除指示符”清除预测[' || Lv_Forecast_Designator ||']失败!');
END IF;
END;