| How to create LOV Dynamically [message #501479] |
Tue, 29 March 2011 06:33  |
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
|
Senior Member |
|
|
Hi All,
I searched a lot on Orafaq.com, but couldn't find/understand solution to below issue.
In my FMB, I have not created any LOV or records group. but in when-new-form-instance, my requirement is to create record group and create LOV and attach it to item.
I know I can write below code.
declare
l_rg_id RecordGroup;
l_lov_id LOV;
l_chr_rg_name VARCHAR2(100);
l_chr_rg_query VARCHAR2(1000);
l_num_errcode NUMBER;
Begin
l_chr_rg_name:='VENDOR_NAME';
l_chr_rg_query:='select 'Test' from dual';
l_rg_id := Find_Group( l_chr_rg_name );
l_num_errcode := Populate_Group_With_Query( l_chr_rg_name,
l_chr_rg_query);
[b] l_lov_id := Find_LOV('VENDOR_NAME'); [/b]
Set_LOV_Property(l_lov_id, GROUP_NAME, l_rg_id);
set_item_property(:BLK.FLD_NM, LOV_NAME,'VENDOR_NAME');
END;
But in above code, I dont have 'VENDOR_NAME' LOV in FMB. Is there any APIs in forms to create this LOV?
|
|
|
|
|
|
| Re: How to create LOV Dynamically [message #501483 is a reply to message #501480] |
Tue, 29 March 2011 06:51  |
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
|
Senior Member |
|
|
based on certain conditions, I want to create record group , create LOV, attach record group to LOV and finally attach that LOV to item.
I am working in oracle apps E buisiness suite, where forms are already created. we can just modify them using some library known as custom.pll.
|
|
|
|
| Re: How to create LOV Dynamically [message #501486 is a reply to message #501483] |
Tue, 29 March 2011 07:17 |
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
|
Senior Member |
|
|
I have got some text from forms builder. Can somebody help me to understand it.
Quote:d2flovcr_Create( d2fctx *pd2fctx, d2fob *parent, d2flov **ppd2flov, text *name ); This function creates a list of values (LOV). You specify a pointer to the context in pd2fctx, a pointer to the parent of the new LOV object in parent, a handle for the function to store the newly-created object in ppd2flov, and the name of the new object in name. This function returns D2FS_SUCCESS if it is able to create a new LOV in ppd2flov
|
|
|
|
| Re: How to create LOV Dynamically [message #501487 is a reply to message #501486] |
Tue, 29 March 2011 07:18 |
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
|
Senior Member |
|
|
Quote:
List of values (LOV) object functions:
This section describes the functions of the Form Builder Open API List of Values (LOV) object.
d2flovcr_Create( d2fctx *pd2fctx, d2fob *parent, d2flov **ppd2flov, text *name );
This function creates a list of values (LOV). You specify a pointer to the context in pd2fctx, a pointer to the parent of the new LOV object in parent, a handle for the function to store the newly-created object in ppd2flov, and the name of the new object in name.
This function returns D2FS_SUCCESS if it is able to create a new LOV in ppd2flov.
|
|
|
|
|
|
|
|
| Re: How to create LOV Dynamically [message #501887 is a reply to message #501872] |
Fri, 01 April 2011 04:35 |
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
|
Senior Member |
|
|
|
Yes, but I am working in Oracle applications E-buisiness suite, wherein we can't modify form by adding LOV. we have to do it using some other ways called persoanlzation or using CUSTOM.pll where we write our custom code...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
