DBA Data[Home] [Help]

APPS.AMS_LIST_RUNNING_TOTAL_PVT_W dependencies on JTF_VARCHAR2_TABLE_4000

Line 3: procedure rosetta_table_copy_in_p0(t out nocopy ams_list_running_total_pvt.sql_string_4k, a0 JTF_VARCHAR2_TABLE_4000) as

1: package body ams_list_running_total_pvt_w as
2: /* $Header: amswlrutb.pls 115.0 2003/11/19 19:06:09 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) as
4: ddindx binary_integer; indx binary_integer;
5: begin
6: if a0 is not null and a0.count > 0 then
7: if a0.count > 0 then

Line 21: procedure rosetta_table_copy_out_p0(t ams_list_running_total_pvt.sql_string_4k, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as

17: end loop;
18: end if;
19: end if;
20: end rosetta_table_copy_in_p0;
21: procedure rosetta_table_copy_out_p0(t ams_list_running_total_pvt.sql_string_4k, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_VARCHAR2_TABLE_4000();

Line 25: a0 := JTF_VARCHAR2_TABLE_4000();

21: procedure rosetta_table_copy_out_p0(t ams_list_running_total_pvt.sql_string_4k, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_VARCHAR2_TABLE_4000();
26: else
27: a0 := JTF_VARCHAR2_TABLE_4000();
28: if t.count > 0 then
29: a0.extend(t.count);

Line 27: a0 := JTF_VARCHAR2_TABLE_4000();

23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_VARCHAR2_TABLE_4000();
26: else
27: a0 := JTF_VARCHAR2_TABLE_4000();
28: if t.count > 0 then
29: a0.extend(t.count);
30: ddindx := t.first;
31: indx := 1;

Line 85: procedure process_query(p_sql_string JTF_VARCHAR2_TABLE_4000

81: end if;
82: end if;
83: end rosetta_table_copy_out_p1;
84:
85: procedure process_query(p_sql_string JTF_VARCHAR2_TABLE_4000
86: , p_total_parameters JTF_NUMBER_TABLE
87: , p_string_parameters JTF_VARCHAR2_TABLE_4000
88: , p_template_id NUMBER
89: , p_parameters JTF_VARCHAR2_TABLE_4000

Line 87: , p_string_parameters JTF_VARCHAR2_TABLE_4000

83: end rosetta_table_copy_out_p1;
84:
85: procedure process_query(p_sql_string JTF_VARCHAR2_TABLE_4000
86: , p_total_parameters JTF_NUMBER_TABLE
87: , p_string_parameters JTF_VARCHAR2_TABLE_4000
88: , p_template_id NUMBER
89: , p_parameters JTF_VARCHAR2_TABLE_4000
90: , p_parameters_value JTF_NUMBER_TABLE
91: , p_sql_results out nocopy JTF_NUMBER_TABLE

Line 89: , p_parameters JTF_VARCHAR2_TABLE_4000

85: procedure process_query(p_sql_string JTF_VARCHAR2_TABLE_4000
86: , p_total_parameters JTF_NUMBER_TABLE
87: , p_string_parameters JTF_VARCHAR2_TABLE_4000
88: , p_template_id NUMBER
89: , p_parameters JTF_VARCHAR2_TABLE_4000
90: , p_parameters_value JTF_NUMBER_TABLE
91: , p_sql_results out nocopy JTF_NUMBER_TABLE
92: )
93: