Change Field properties of a Form
Date: Thu, 19 Aug 1999 11:26:33 -0400
From: "Sabrina Diaz, TRI" SDiaz@tricom.com.do
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: GEN: Changing field properties in Ora Apps form
Is there an easy way to change the property of a field in any Oracle
Financials form ?
I believe, that I have read something about changing for example a field to
be required or not in a form w/o using Oracle Forms.
Any Help will be appreciated,
Sabrina
Date: Thu, 19 Aug 1999 18:09:03 +0200
From: "Blaise Rempteaux" brempteaux@auchan.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Changing field properties in Ora Apps form
The CUSTOM library allows extension of Oracle Applications without
modification of Oracle Applications Code.
The CUSTOM library is located in the $AU_TOP/res/plsql directory.
After you write code in the CUSTOM procedures, compile and generate the
library using Oracle Forms. Then place this library into $AU_TOP/res/plsql
directory.
This is an example where you change a field to be required.
package body custom is
procedure event(event_name varchar2) is
form_name varchar2(30) := name_in('system.current_form');
begin
if form_name = 'MY_FORM_NAME' AND event_name = 'WHEN-NEW-FORM-INSTANCE'
then
/* You modify the property of the field */
App_Item_Property.Set_Property('BLOCK_NAME.ITEM_NAME',REQUIRED,PROPERTY_ON);
end if;
end event;
end custom;
You can have more informations about custom library in the coding standard
(Chapter 12).
Blaise.
Date: Thu, 19 Aug 1999 11:17:26 -0700
From: "Haseeb, Mohamed" Mohamed.Haseeb@Jacobs.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Changing field properties in Ora Apps form
Please note : You cannot use app_item_property in custom library. As all
these appcore packages (like app_item_property) calls custom library - it
will get locked up in an endless loop. You must use set_item_property
Regards.. Haseeb
Date: Sun, 22 Aug 1999 09:55:33 -0400
From: "Lee McAllister" avernus@iag.net
To: oraapps-l@cpa.qc.ca
Subject: RE: Changing field properties in Ora Apps form
That's odd it worked OK for me. In the example below an endless loop would
not occur unless the app_item_property call generated a
when-new-form-instance event. If it is doing that at your installation, you
should open a tar.
LeeM
Custom Form calling PO Approval Form
Date: Fri, 20 Aug 1999 01:50:54 +1000
From: "Mckenzie, Rosemary" ROSEMARY.MCKENZIE@cai.com
To: oraapps-l@cpa.qc.ca
Subject: PO: custom Form v4.5 calling OF Approvals form
Has anyone successfully called the Purchasing Approvals (v10.7 Financials)
form from a custom form?
I have created a custom form v4.5 which is a streamlined version of
POXPOEPO, Enter Purchases.
In my form I have referenced the blocks in the POXDOAPP form and the
POXDOREP form (referenced by Approvals). I have Also attached the
libraries, referenced the lovs and parameters. I am using the same call
procedure used in POXPOEPO and have named the blocks in my custom form the
same as the ones referenced in the procedures called in the .pll libraries.
The Approvals form flashes up and then closes with no error message.
Any help, or experiences calling Oracle Financials Apps forms from custom
forms, would be greatly appreciated.
Thankyou IA,
Rosemary McKenzie
Date: Thu, 19 Aug 1999 11:28:56 -0500
From: "Anil Kumar (ns)" akumar@cap.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: custom Form v4.5 calling OF Approvals form
This is something we are using to zoom(open form) to customers form from
enter orders form.
This code we are using in custom.pll under ZOOM event.
Give details as to what kind of logic u are using and where. If possible
send the code.
May be u have to pass some parameters to Approvals form, I am not sure.
if (form_name = 'OEXOEMOE' and block_name = 'ORDER')then
param_to_pass1 := name_in('ORDER.customer_id');
fnd_function.execute(FUNCTION_NAME='OE_ARXCUDCI_QUICK',
OPEN_FLAG='Y',
SESSION_FLAG='Y',
OTHER_PARAMS ='CUSTOMER_ID=
'||param_to_pass1);
go_block('CUST');
copy(param_to_pass1,'CUST.CUSTOMER_ID');
do_key('execute_query');
elsif (form_name = 'ARXCWMAI' and block_name = 'CQIT_FIND') then
fnd_function.execute(FUNCTION_NAME='AR_ARXCUDCI_QUICK',
OPEN_FLAG='Y',
SESSION_FLAG='Y');
end if;
Anil Kumar
akumar@cap.org
Date: Mon, 23 Aug 1999 11:41:29 -0400
From: "Sankala, Dinesh" Dinesh.Sankala@lgeenergy.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: custom Form v4.5 calling OF Approvals form
DO I need to attch the Custom pll to the form I modified
the code which I have written in the Custom .pll is not seems to be
executing
nay ideas
Negative values - convert into Positive
Date: 23 Aug 99 17:22:25 MDT
From: vv vv venvivek@usa.net
To: Submit Question oraapps-l@cpa.qc.ca
Subject: Form Customization : Any routine to specify the -ve value in
Hi Guys.
I like to know is there any standard routine to convert the -ve value in side
the .
In other words if i am havin a value -12 in a field i want to display the
value as 12 automatically instead of -12.
This standard is followed in all financial modules to represent the Cr or the
negative value.
Any suggestion will be appriciated.
With regards.
Vivek.