Oracle Application Extension (Zoom)

From: <sceenu_at_my-dejanews.com>
Date: Sat, 26 Sep 1998 05:59:14 GMT
Message-ID: <6uhvri$t8b$1_at_nnrp1.dejanews.com>



Hello Gurus,

I have a basic question on Zooms. Following is the scenario. I have to zoom from a Fixed Assets Form to Accounts Payables form. The purpose of this zoom is to get Invoice Details tied to an Asset. So I zoom from FA form passing in the parameter 'invoice number' to the AP form where this AP form accepts the 'invoice number' parameter and queries the underlying view on this 'invoice number'.

	Fixed Assets		Accounts Payables
	------------		-----------------
Form    FAXASSET		APXIWALL
Block	INVOICES		INVOICE
Param	invoice_number		invoice_num

So I have modified the AP form APXIWALL and included the parameter
'invoice number' as a varchar2(225).

Modified the WHERE clause for the target block 'INVOICE' so it includes
'invoice number' in its query condition.
Modified the 'WHEN_NEW_FORM_INSTANCE' of the target form so it would run the query if it had been called with 'invoice number' parameter.

And also I modified the 'custom.pll' to make the Zoom_Available and called fnd_execute.function to invoke the target APXIWALL form with
'invoice_number' parameter.

All the programs compile and the form APXIWALL is generated without problem.

I have included the function/form 'AP_APXIWALL' in FA so the function is available from FA menu.

But when I try to Zoom, I get the following error:

FRM-47023: No such parameter named 'G_QUERY_FIND' exists in form APXIWALL. FRM-47023: No such parameter named 'invoice_number' exists in form APXIWALL.

This Zoom was working fine when I first created it weeks ago. During the past few weeks the we applied patches to the AP(K) and PA(A) modules and since then I have been having this problem.

I was hoping that someone had already experienced this problem before and would be able to help me. Also if there is some documentation about what this 'G_QUERY_FIND' is and how it is supposed to be used, please let me know.

Thank You,

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Sep 26 1998 - 07:59:14 CEST

Original text of this message