[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;