--以下代码于20181002在Tony环境实现
DECLARE
p_invoice_id NUMBER := 10104; -- 'TXXTEST01'
p_org_id NUMBER := 82; -- '动物研究所'
l_approval_status VARCHAR2(20);
l_holds_count NUMBER;
l_funds_return_code VARCHAR2(100);
l_cancel_count NUMBER;
-- l_Hold_Count Number;
l_Funds_Code Varchar2(30);
l_Approve_Status Varchar2(120);
BEGIN
/* apps.fnd_global.apps_initialize(user_id => 1466, resp_id => 50370, resp_appl_id => 200);
mo_global.set_policy_context('S', p_org_id);*/
BEGIN
--mo_global.init('SQLAP');
apps.fnd_global.apps_initialize(user_id => 1110,
resp_id => 50597,
resp_appl_id => 20003);
--mo_global.set_policy_context('S', 0);
mo_gl