Current Position:Home > How to pass parameters to a Lov's Query?

How to pass parameters to a Lov's Query?

Update:11-30Source: network consolidation
Advertisement
Hi friends,
[Apps R12]
I'm trying to extend the a ProjectLOVVO (for OTL, in example) and the extension would consist on modifying the Lov Query adding in the where clause a comparison with certain fields of the page....
How can I retrieve a value in the page , a field/item, form_value, or similar and put it in the Lov's query? Is there any direct way to reference it..? Is it necessary to do any special mapping? What about those "bind variables", .. I don't know exactly how to use them.. and if this could be a purpose for their use..
Thanks for any comment.

The Best Answer

Advertisement
Hi Prasanna,
thanks for he coment, but.. I think It really doesn't exists the LOV Region Item you mention...
I mean, the "real" case is:
In OTL, inside Create timecard page (+/oracle/apps/hxc/selfservice/timecard/webui/TcActivitiesPG+) I want to restrict the Project LOV query (ProjectLOVVO) to add the project manager in the LOV (well, it can be done adding to the from & where clauses the per_all_people_f and pa_project_players) but, for this, is necessary to check the dates.... so It's necessary to add in the where clause a check for the "period", that is a data in a poplist on the screen... [I wasn't be able to locate where is that period stored]
Also, as a Time card is for a person.. I need too to retrieve the person_id for that person (this person could not be the one who has connected... because you can create a timecard for another user) so.. I see this information on screen at the top, where it appears the "Time Entry:" label... but.. how to locate it into page? and.. are you sure it can be mapped to include it in the LOV query? (It would be necessary to use it as I've seen in others lov's queries.. where it seems to appear parameters/variables/mapping named as :1 ,:2 ... :number... , I don't know how to add it)
Any detail step would be very appreciated.
Thanks a lot.!!
  • How to pass parameters from html to xacute query Update:11-30

    hi experts, I need to pass a variable from  html to xacute query.i need the correct syntax for that . Thanks in advance. lokeshHi Lokesh, I apologize if my message came off sounding rude - passing parameters to queries is fundamental to xMI, one of t

  • How to pass parameters to a Lov's Query? Update:11-30

    Hi friends, [Apps R12] I'm trying to extend the a ProjectLOVVO (for OTL, in example) and the extension would consist on modifying the Lov Query adding in the where clause a comparison with certain fields of the page.... How can I retrieve a value in

  • Passing parameters to Update page Update:10-11

    Hi, I created the search/create/update page going by the instructions in the tutorial exercise. My primary key is a combination of employee number AND sequence number. When I query the employee in the search page and if the employee has more than one

  • How to open a page from a Form and pass parameters to the form on that page Update:10-11

    I found a similar example on this forum, but it did not work for me: declare l_names owa.vc_arr; l_values owa.vc_arr; i number; begin PORTAL.wwpro_api_parameters.retrieve(l_names, l_values); FOR i in 1..l_names.count LOOP htp.p(l_names(i) || ' ' || l

  • Pass parameters from JSP Dyn Page to WDJ Application Update:10-11

    Hi, I am trying to pass parameters from my JSPDyn Page to WDJ Application. I am using NWDS 7.1 EHP1 My code is : function to_WEBDYNHK()       EPCM.relaxDocumentDomain();       EPCM.doNavigate     ('ROLES://pcd:portal_content/Himanshu.Himanshu/TestDyn

  • Passing parameters between portlets (PL/SQL PDK) Update:10-11

    I'm new to the PDK, so forgive me if this is a dumb question. I need to develop a portal page containing a single search portlet, and then many other associated portlets which bring back various bits of data based on the result of the search. Is it p

  • Passing parameters to PL/SQL table types Update:10-11

    Hi Everybody, I have one question about passing PL/SQL tables types and tabs as IN parameter in procedure.I am working in 11.2.0.2.0 environment. I am stuck on how to pass those values to procedure.Please find below more details: Table 1: CREATE TABL

  • Passing Parameters via Post Method from Webdynpro Java to a web application Update:10-11

    Hello Experts, I want to pass few parameters from a web dynpro application to an external web application. In order to achieve this, I am referring to the below thread: HTTP Post As mentioned in the thread, I am trying to create an additional Suspend

  • Unable to Pass Parameters to I5Grid in SAP MII 14.0 SP05 Update:10-11

    Hi Experts, There was a bug in SAP MII 14.0 SP04  where we were unable to pass parameters to I5Grid dynamically. I understand that this bug has been fixed in SP05 , so we applied following patches: Patches installed : a)      XMII05P_4-10008694.SCA b

  • Unable to pass parameters from APEX to Oracle EBusiness suite R12 forms Update:10-11

    Hi We are trying to access a standard Oracle EBusiness form i.e. service request and are invoking this Form through a link from APEX. We are trying to pass parameters via this URL http://abc.oneapps.com:8010/OA_HTML/RF.jsp?function_id=2037&resp_id=50