Tuesday, April 13, 2010

How to Set Printer in Pl/SQL Program

PROCEDURE submit_invoice_report_request(p_invoice_id IN NUMBER,
p_org_id IN NUMBER)
IS
ln_number NUMBER;
lb_boolean BOOLEAN;
PRAGMA autonomous_transaction;
BEGIN
lb_boolean:=fnd_request.set_print_options (NULL,
NULL,
1,
TRUE,
'N');
COMMIT;
ln_number:=fnd_request.submit_request('XBOL',
'XXMRAP0006',
NULL,
SYSDATE,
FALSE,
p_invoice_id,
p_org_id
);
COMMIT;
END;

No comments: