package_function_p (private)

 package_function_p -object_name object_name package_name

Defined in packages/acs-subsite/tcl/package-procs.tcl

Switches:

-object_name (required)

Parameters:

package_name (required)

Returns:

true if the package's object is a function.

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    return [acs::per_thread_cache eval -key acs-subsite.package_function_p($object_name-$package_name) {
        db_0or1row function_p ""
    }]

Generic XQL file:

packages/acs-subsite/tcl/package-procs.xql

PostgreSQL XQL file:

<fullquery name="package_function_p.function_p">
    <querytext>
         select 1
      </querytext>
</fullquery>

<fullquery name="package_function_p.function_p">
    <querytext>
        select 1 from dual
      </querytext>
</fullquery>

packages/acs-subsite/tcl/package-procs-postgresql.xql

Oracle XQL file:

<fullquery name="package_function_p.function_p">
    <querytext>

	 select 1
	 from dual
         where exists (select 1
	               from user_arguments
		       where rtrim(package_name) = upper(:package_name)
		       and rtrim(object_name) = upper(:object_name)
		       and position = 0)
    
      </querytext>
</fullquery>

packages/acs-subsite/tcl/package-procs-oracle.xql