Home » Developer & Programmer » Forms » Links in forms
Links in forms [message #150118] |
Tue, 06 December 2005 06:55 |
sharma.radha
Messages: 59 Registered: August 2005 Location: mumbai
|
Member |
|
|
Hi to all..
Can some one suggests me how to create links on oracle forms 6i if it is possible which work like buttons,which run reports or call another form either by taking parameters or call reports and forms without any parameters.
Waiting for reply.
Radha.
|
|
|
Re: Links in forms [message #150267 is a reply to message #150118] |
Tue, 06 December 2005 23:31 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
What's wrong with creating a very wide button and putting the link text on it and then when the user presses it, voila, the button runs?
If you want to, you could try using the when-mouse-click or when-mouse-double-click triggers on a standard text field.
David
Upd: Fix typos.
[Updated on: Wed, 07 December 2005 19:21] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
Re: Links in forms [message #151063 is a reply to message #150118] |
Mon, 12 December 2005 23:33 |
Scarlet.Zhu
Messages: 22 Registered: December 2005 Location: Shanghai
|
Junior Member |
|
|
Hi,
Here is a program demonstrating the steps to submit a report via form.
:parameter.req_id :=
FND_REQUEST.SUBMIT_REQUEST (
:blockname.appsname,
:blockname.program,
:blockname.description,
:blockname.start_time,
:blockname.sub_req = ’Y’,
123, NAME_IN(’ORDERS.ORDER_ID’), ’abc’,
chr(0), ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’);
IF arameter.req_id = 0 THEN
FND_MESSAGE.RETRIEVE;
FND_MESSAGE.ERROR;
ELSE
IF :SYSTEM.FORM_STATUS != ’CHANGED’ THEN
IF app_form.quietcommit THEN
/*form commits without asking user to save changes*/
fnd_message.set_name(’SQLGL’,
’GL_REQUEST_SUBMITTED’);
fnd_message.set_TOKEN(’REQUEST_ID’,
TO_CHAR(:PARAMETER.REQ_ID), FALSE);
fnd_message.show;
ELSE
fnd_message.set_name(’FND’,
db_trigger
Example 2
Example 3
Example 4
21 – 35 PL/SQL APIs for Concurrent Processing
’CONC–REQUEST SUBMISSION FAILED’);
fnd_message.error;
END IF;
ELSE
DO_KEY(’COMMIT_FORM’);
IF :SYSTEM.FORM_STATUS != ’CHANGED’ THEN
/*commit was successful*/
fnd_message.set_name(’SQLGL’,
’GL_REQUEST_SUBMITTED’);
fnd_message.set_TOKEN(’REQUEST_ID’,
TO_CHAR(:PARAMETER.REQ_ID), FALSE);
fnd_message.show;
END IF;
END IF;
END IF;
chr(0) means the end of listing parameters. No compiling errors will be shown but form runs with errors if chr(0) is not included.
[Updated on: Mon, 12 December 2005 23:34] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Fri Sep 20 03:31:44 CDT 2024
|