I have redone the query writing proc. Now you can call a function by setting the querytext (in the .xql file) to:
select [qd_write_query_select pb_acs_pkg__new
package_name => :package_name
owner_id => :user_id
context_id => :user_id ]
In this case the qd_write_query_select
procedure returns:
pb_acs_pkg__new(null,
:package_name,
null,
null,
:user_id,
'pb_acs_pkg',
now(),
null,
null,
:user_id);
Any comments would be helpful. The select beginning the querytext seems to be necessary to get the query dispatcher to work correctly.