Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Retreving the Bean Area code used in Oracle forms 6i

Posted on 2004-09-02
4
Medium Priority
?
832 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 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 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…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

971 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