filmov
tv
Submitting Concurrent Program through plsql package fnd_request in oracle apps( No Audio)

Показать описание
This is request set
It can be used in interface programs..
To do interface programs.. we need to run
1) sql loader program
2) interface program
But The requirement is Client wants to run A single program.. In that he need 1)sql loader program and 2)interface program
so we need to add sql loader program inside interface program using fnd_request package
Create or replace package xxtest
as
procedure main(errbuf out varchar2,retcode out number);
end;
/
Create or replace Package body XXTEST
as
V_REQUEST_ID NUMBER;
v_phase varchar2(100);
v_status varchar2(100);
v_dev_phase varchar2(100);
v_dev_status varchar2(100);
v_message varchar2(100);
V_wait_for_request boolean;
procedure main(errbuf out varchar2,retcode out number)
as
BEGIN
--=====================================================================--
--== Standard Program Submition ==--
--=====================================================================--
V_REQUEST_ID := FND_REQUEST.SUBMIT_REQUEST (
'PO',
'XXKRAXML program',-- PROGRAM NAME
null,
'06-JAN-2015',-- YOU MAY USE SYSDATE
FALSE
);
FND_FILE.PUT_LINE(FND_FILE.LOG,'REQUEST ID.......'||V_REQUEST_ID);
COMMIT;
--=====================================================================--
--== Concurrent Program waiting ==--
--=====================================================================--
V_wait_for_request :=FND_CONCURRENT.wait_for_request(V_REQUEST_ID,
10,
0,
v_phase,
v_status,
v_dev_phase,
v_dev_status,
v_message
);
COMMIT;
DBMS_OUTPUT.PUT_LINE('REQUEST ID.......'||V_REQUEST_ID);
DBMS_OUTPUT.PUT_LINE('Phase.......'||v_phase);
DBMS_OUTPUT.PUT_LINE('Status.......'||v_status);
DBMS_OUTPUT.PUT_LINE('Dev Status.......'||v_dev_phase);
DBMS_OUTPUT.PUT_LINE('Dev Status.......'||v_dev_status);
DBMS_OUTPUT.PUT_LINE('Message.......'||v_message);
END;
end;
/
It can be used in interface programs..
To do interface programs.. we need to run
1) sql loader program
2) interface program
But The requirement is Client wants to run A single program.. In that he need 1)sql loader program and 2)interface program
so we need to add sql loader program inside interface program using fnd_request package
Create or replace package xxtest
as
procedure main(errbuf out varchar2,retcode out number);
end;
/
Create or replace Package body XXTEST
as
V_REQUEST_ID NUMBER;
v_phase varchar2(100);
v_status varchar2(100);
v_dev_phase varchar2(100);
v_dev_status varchar2(100);
v_message varchar2(100);
V_wait_for_request boolean;
procedure main(errbuf out varchar2,retcode out number)
as
BEGIN
--=====================================================================--
--== Standard Program Submition ==--
--=====================================================================--
V_REQUEST_ID := FND_REQUEST.SUBMIT_REQUEST (
'PO',
'XXKRAXML program',-- PROGRAM NAME
null,
'06-JAN-2015',-- YOU MAY USE SYSDATE
FALSE
);
FND_FILE.PUT_LINE(FND_FILE.LOG,'REQUEST ID.......'||V_REQUEST_ID);
COMMIT;
--=====================================================================--
--== Concurrent Program waiting ==--
--=====================================================================--
V_wait_for_request :=FND_CONCURRENT.wait_for_request(V_REQUEST_ID,
10,
0,
v_phase,
v_status,
v_dev_phase,
v_dev_status,
v_message
);
COMMIT;
DBMS_OUTPUT.PUT_LINE('REQUEST ID.......'||V_REQUEST_ID);
DBMS_OUTPUT.PUT_LINE('Phase.......'||v_phase);
DBMS_OUTPUT.PUT_LINE('Status.......'||v_status);
DBMS_OUTPUT.PUT_LINE('Dev Status.......'||v_dev_phase);
DBMS_OUTPUT.PUT_LINE('Dev Status.......'||v_dev_status);
DBMS_OUTPUT.PUT_LINE('Message.......'||v_message);
END;
end;
/