/*
begin
fnd_global.apps_initialize(user_id => 8162,
resp_id => 50692,
resp_appl_id => 20003);
mo_global.init('M');
end;
*/
declare
l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_REQUEST';
CURSOR cur_interface_group_s IS
SELECT po_requisitions_interface_s.nextval FROM dual;
CURSOR cur_org_id IS
SELECT 295
FROM DUAL;
rec_interface po_requisitions_interface_all%ROWTYPE;
l_request_id NUMBER;
l_batch_id NUMBER;
l_dev_phase VARCHAR2(80);
l_dev_status VARCHAR2(80);
l_message VARCHAR2(2000);
l_count NUMBER := 0;
g_org_id number;
ll_trx_request_id NUMBER;
ll_wait_req BOOLEAN;
ll_child_phase VARCHAR2(80);
ll_child_status VARCHAR2(80);
ll_dev_phase VARCHAR2(80);
ll_dev_status VARCHAR2(80);
ll_message VARCHAR2(2000);
BEGIN
-- API body
OPEN cur_interface_group_s;
FETCH cur_interface_group_s
INTO l_batch_id;
CLOSE cur_interface_group_s;
OPEN cur_org_id;
FETCH cur_org_id
INTO rec_interface.org_id;
CLOSE cur_org_id;
g_org_id := rec_interface.org_id;
-- FOR rec_mtl_schedule IN cur_mtl_schedule LOOP
rec_i