--以下脚本于20180114在tony环境实现
--插入接口表之后需要手动提交请求 :N: FA/Mass Addtions/Post Mass Addtions
DECLARE
l_iface_rec fa_mass_additions%ROWTYPE;
l_user_id NUMBER := 1110;
BEGIN
l_iface_rec.last_update_date := SYSDATE;
l_iface_rec.last_updated_by := l_user_id;
l_iface_rec.creation_date := SYSDATE;
l_iface_rec.created_by := l_user_id;
l_iface_rec.last_update_login := -1;
SELECT fa_mass_additions_s.NEXTVAL
INTO l_iface_rec.mass_addition_id
FROM dual;
l_iface_rec.posting_status := 'POST';
l_iface_rec.queue_name := 'POST';
l_iface_rec.feeder_system_name := '测试导入';
l_iface_rec.create_batch_date := SYSDATE;
l_iface_rec.create_batch_id := 987654321;
-- l_iface_rec
EBS开发_固定资产成批增加
最新推荐文章于 2023-03-14 12:04:46 发布