DBA Data[Home] [Help]

PACKAGE: APPS.AMS_LIST_RUNNING_TOTAL_PVT_W

Source


1 package ams_list_running_total_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswlruts.pls 115.0 2003/11/19 19:11:04 huili noship $ */
3   procedure rosetta_table_copy_in_p0(t out nocopy ams_list_running_total_pvt.sql_string_4k, a0 JTF_VARCHAR2_TABLE_4000);
4   procedure rosetta_table_copy_out_p0(t ams_list_running_total_pvt.sql_string_4k, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5 
6   procedure rosetta_table_copy_in_p1(t out nocopy ams_list_running_total_pvt.t_number, a0 JTF_NUMBER_TABLE);
7   procedure rosetta_table_copy_out_p1(t ams_list_running_total_pvt.t_number, a0 out nocopy JTF_NUMBER_TABLE);
8 
9   procedure process_query(p_sql_string JTF_VARCHAR2_TABLE_4000
10     , p_total_parameters JTF_NUMBER_TABLE
11     , p_string_parameters JTF_VARCHAR2_TABLE_4000
12     , p_template_id  NUMBER
13     , p_parameters JTF_VARCHAR2_TABLE_4000
14     , p_parameters_value JTF_NUMBER_TABLE
15     , p_sql_results out nocopy JTF_NUMBER_TABLE
16   );
17 end ams_list_running_total_pvt_w;