DBA Data[Home] [Help]

PACKAGE: APPS.JTF_AK_QUERY

Source


1 PACKAGE jtf_ak_query as
2   --$Header: jtfakqs.pls 120.1 2005/07/02 02:30:49 appldev ship $
3   FUNCTION execute_query (
4     p_max_rows		IN NUMBER default NULL,
5     p_range_low 	IN NUMBER default 0,
6     p_range_high	IN NUMBER default NULL,
7     p_appl_id		IN NUMBER default fnd_global.resp_appl_id,
8     p_flow_name		IN VARCHAR2,
9     p_parent_page_name	IN VARCHAR2,
10     p_primary_key_name	IN VARCHAR2,
11     p_key_value1	IN VARCHAR2,
12     p_key_value2	IN VARCHAR2 default NULL,
13     p_key_value3	IN VARCHAR2 default NULL,
14     p_key_value4	IN VARCHAR2 default NULL,
15     p_key_value5	IN VARCHAR2 default NULL,
16     p_key_value6	IN VARCHAR2 default NULL,
17     p_key_value7	IN VARCHAR2 default NULL,
18     p_key_value8	IN VARCHAR2 default NULL,
19     p_key_value9	IN VARCHAR2 default NULL,
20     p_key_value10	IN VARCHAR2 default NULL,
21     p_where_clause	IN VARCHAR2 default NULL,
22     p_where_binds	IN ak_query_pkg.bind_tab)
23     RETURN ak_query_pkg.results_table_type ;
24 END;