Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AJAX: Pass APEX_APPLICATION.G_Fxx to On Demand Process

M.H..Oct 19 2010 — edited Dec 28 2010
Hi,

I am new to the forum and I am using APEX 4.0. I am having a page with a report that displays the result of the below query:
------------------------------------------------------------------------
Select
apex_item.checkbox(11,ID,'UNCHECKED') "CHECKBOX",
rownum,
PART,
QTY,
DESCR,
UNIT_PRICE
From Details
Where ENTERED_BY = (Select PNAME from LOGGED)
------------------------------------------------------------------------

I have an image on the same page and when it is clicked a JavaScript function is called that uses AJAX to call an On Demand Process:
------------------------------------------------------------------------
function jsDelete_Selected_Items()
{
var ajaxRequest = new htmldb_Get(null,&APP_ID.,'APPLICATION_PROCESS=LPO_Delete_Selected_Items',0);

ajaxRequest.add('APEX_APPLICATION.G_F11',html_GetElement('APEX_APPLICATION.G_F11').value);

ajaxResult = ajaxRequest.get();

ajaxRequest = null;
}
------------------------------------------------------------------------

and this is the On Demand Process:
------------------------------------------------------------------------
BEGIN
FOR i in 1..APEX_APPLICATION.G_F11.COUNT LOOP
Delete From IT_LPO_DETAILS_TEMP
Where LPODT_ID = APEX_APPLICATION.G_F11(i)
END LOOP;
END;
------------------------------------------------------------------------

The purpose is to delete the selected rows from the above report without refreshing the whole page or submitting the page. So when the image is clicked the selected rows must be deleted. The system is showing the below error:

Unexpected error, unable to find item name at application or page level.
Error ERR-1002 Unable to find item ID for item "APEX_APPLICATION.G_F11" in application "111".

Could you please advice me.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 25 2011
Added on Oct 19 2010
9 comments
5,172 views