Solved

Retreving the Bean Area code used in Oracle forms 6i

Posted on 2004-09-02
4
756 Views
Last Modified: 2008-01-09
Hi Guys,
   Could u please help me out on this? I have an item RECENT_GRID which is of item type: Bean area under the
      block :BLK_RECENT.

     How can i retrieve the code written in java beans so that i want to make modifications in the java bean code?


 Reason: I have the form OKCEXPOR---->which invokes OKCAUDET when i double-click on the item in the
              BLK_RECENT. I customized the form OKCEXPOR and renamed it as XBO_OKCEXPOR. and OKCAUDET
              as XBO_OKCAUDET. Now when do the same operation and click on the item in the block under
              XBO_OKCEXPOR  ,i am invoking OKCAUDET instead of XBO_OKCEXPOR.

             Went to the particular block ,where it is has the item RECENT_GRID which is defined as bean area.

           I am thinking the code in the java bean is invoking the form OKCAUDET.
    I didn't find anywhere the call_form or fnd_function.execute() which is usually used to invoke the
    other form from the existing form.


Please help me out on this..

Please advise me on this?
0
Comment
Question by:babunagendra
  • 3
4 Comments
 
LVL 22

Expert Comment

by:Helena Marková
ID: 11970381
I think that you can see a When-Custom-Item-Event Trigger and make modification there.
By the way for modification of java code you can use Oracle JDeveloper.
0
 
LVL 22

Accepted Solution

by:
Helena Marková earned 500 total points
ID: 11970797
I think that if you have customized the form OKCEXPOR then there is no need of renaming it. The easiest you can do is saving the original OKCEXPOR.FMB and rename your customized XBO_OKCEXPOR.FMB to OKCEXPOR.FMB.
0
 

Author Comment

by:babunagendra
ID: 11974401
The two places where the function is declared are
1:The function for the form OKCAUDET is being declared in here ,but the package cannot be modified(read-only):
PACKAGE launch IS
--
--   Package Public variable go here...
--
    current_grid             VARCHAR2(255);
    current_grid_op          VARCHAR2(255);
    x_Return_Status          VARCHAR2(255);
    x_Msg_Count              NUMBER;
    x_Msg_Data               VARCHAR2(2000);

    k_function_core_auth     VARCHAR2(30)      DEFAULT 'OKC_OKCAUDET';

and
2: I could modify in here the function name....
PACKAGE lmenu IS
--
--   public variables
--
    last_popup_block             varchar(255);
    last_popup_action            varchar2(255);

--
--  Constants
--
      /* Literals that correspond to Popup Menu Items */

  k_popup_new                varchar2(30)    default 'OKC_OKCAUDET';
  k_popup_open               varchar2(30)    default 'OKC_GRID_OPEN';


Is the solution u gave me is the only way out .

For the solution u gave me ,i have to have the backup of the original .fmb file and i guess
it is going to be a maintanence issue.

Is there anyother way around? I am not sure but if the apps dba could create a form link then it will
work.

I have no idea of how they work it?
can u let me know is it another option we could try out first?




0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 11987142
I am sorry I have no experiences with customizing the Oracle Application. Maybe you can find more in a documentation - Oracle Applications Developer's Guide (115devg.pdf) - Modifying an Existing Form.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Database restore 8 68
SQL Insert Query Help 16 87
ORA-12560: TNS:protocol adapter error 8 49
Update cached table in H2 database 6 13
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now