DBA Data[Home] [Help]

APPS.JTF_AK_QUERY dependencies on AK_QUERY_PKG

Line 22: p_where_binds IN ak_query_pkg.bind_tab)

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 IS
24: --
25: -- Static CRM Navigator Variables
26: --

Line 23: RETURN ak_query_pkg.results_table_type IS

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 IS
24: --
25: -- Static CRM Navigator Variables
26: --
27: C_APPLICATION_ID NUMBER := fnd_global.resp_appl_id;

Line 89: -- call ak_query_pkg.exec_query

85: from ak_unique_keys
86: where database_object_name = l_database_object_name
87: and unique_key_name = p_primary_key_name;
88:
89: -- call ak_query_pkg.exec_query
90: ak_query_pkg.exec_query(
91: p_flow_appl_id => p_appl_id,
92: p_flow_code => l_flow_code,
93: p_parent_page_appl_id => l_page_application_id,

Line 90: ak_query_pkg.exec_query(

86: where database_object_name = l_database_object_name
87: and unique_key_name = p_primary_key_name;
88:
89: -- call ak_query_pkg.exec_query
90: ak_query_pkg.exec_query(
91: p_flow_appl_id => p_appl_id,
92: p_flow_code => l_flow_code,
93: p_parent_page_appl_id => l_page_application_id,
94: p_parent_page_code => l_page_code,

Line 121: RETURN ak_query_pkg.g_results_table;

117: p_where_binds => p_where_binds,
118: p_max_rows => p_max_rows
119: );
120:
121: RETURN ak_query_pkg.g_results_table;
122:
123: END execute_query;
124: END jtf_ak_query;