Wednesday, April 14, 2010

Submitting XML Publisher from procedure

PROCEDURE SUBMIT_REPORT(X_BATCH_NUMBER IN NUMBER,X_REQUEST_ID OUT NUMBER)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
xml_layout boolean;
BEGIN
xml_layout := FND_REQUEST.ADD_LAYOUT('APPLICATION_SHORT_NAME',
'TEMPLATE_SHORT_NAME',
'LANGUAGE',
'TERRITORY',
'OUTPUT_FILE_TYPE');
X_REQUEST_ID:=fnd_request.submit_request(application => 'APPLICATION_SHORT_NAME',
program => 'CP_SHORT_NAME',
argument1=>'PARAMETERS');
COMMIT;
END SUBMIT_REPORT;

No comments:

Post a Comment