DECLARE
l_iface_rec inv.mtl_transactions_interface% ROWTYPE;
l_iface_lot_rec inv.mtl_transaction_lots_interface%ROWTYPE ;
l_iface_serial_rec inv.mtl_serial_numbers_interface%ROWTYPE ;
l_cur_mfg_org_id NUMBER := fnd_global.org_id ; --Current Inv Organization
l_user_id NUMBER := fnd_global.user_id; --User ID, Sysadmin here
l_serial_seq_id NUMBER;
l_product_id NUMBER;
l_return_count NUMBER;
x_trans_count NUMBER;
x_return_status VARCHAR2(100 );
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000 );
BEGIN
fnd_global.apps_initialize(user_id => fnd_global.user_id
,resp_id => fnd_global.resp_id
,resp_appl_id => fnd_global.resp_appl_id);
l_iface_rec.last_update_date := SYSDATE;
l_iface_rec.last_updated_by := fnd_global.user_id;
l_iface_rec.creation_date := SYSDATE;
l_iface_rec.created_by := fnd_global.user_id;
l_iface_rec.last_update_login := fnd_global.last_update_login ;
SELECT mtl_material_transactions_s.nextval
INTO l_iface_rec.transaction_interface_id
FROM dual;
l_iface_rec.transaction_header_id := l_iface_rec.transaction_interface_id;
l_iface_rec.transaction_mode := 3;
l_iface_rec.process_flag := 1;
l_iface_rec.transaction_type_id := 42; --mtl_transaction_types 4
ORACLE EBS 物料事务处理开发接口案例 - 其物料启用了序列和批次
最新推荐文章于 2025-07-01 19:03:33 发布