AJAX: Pass APEX_APPLICATION.G_Fxx to On Demand Process
M.H..Oct 19 2010 — edited Dec 28 2010Hi,
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.