How to use Global Variables [message #85782] |
Wed, 28 July 2004 20:37 |
K.Sateeshkumar
Messages: 16 Registered: March 2004
|
Junior Member |
|
|
Hai Gurus!
My requirement is as follows.
1) I will logon to oracle Application with my UserName: 4118 and Password.
2) Then I have one Applicaion which displays the list of approvals pending for the above user.
The Fields in the form are as follows.
CRDNO CRDDATE PRES_DETAILS PROP_DETAIS.
1 01/01/2004 XXXXX YYYYYY
2 30/01/2004 xxxxx yyyyyy
3 02/04/2004 ZZZZZZ AAAAAAA
if I logon to oracle application with some other user it must display the list of approvals pending for the user.
3) If I click on any one of the approval,it opens a approval form and gives the data corresponding to the approval.
Total 3 Forms are connected in this process.
1) Logon Screen
2) List of Approvals Screen
3) Approval Screen
Thanking you,
K.Sateeshkumar
|
|
|
Re: How to use Global Variables [message #85907 is a reply to message #85782] |
Tue, 10 August 2004 15:35 |
Zain
Messages: 30 Registered: October 2003
|
Member |
|
|
In your second and third Form, you can use get_application_property built-in to get the username.
Another method is the use of passing parameters between forms. Look for new_form, open_form in online help for more information.
Another way is to use global variables instead of parameter list. However, you may want to think twice before going ahead with the use of global variables.
|
|
|