APPS.AMS_LIST_QUERY_PVT_W dependencies on JTF_VARCHAR2_TABLE_4000

Line 22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_list_query_pvt.sql_string_tbl, a0 JTF_VARCHAR2_TABLE_4000) as

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_list_query_pvt.sql_string_tbl, a0 JTF_VARCHAR2_TABLE_4000) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then
26: if a0.count > 0 then

Line 40: procedure rosetta_table_copy_out_p2(t ams_list_query_pvt.sql_string_tbl, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_4000) as

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p2;
40: procedure rosetta_table_copy_out_p2(t ams_list_query_pvt.sql_string_tbl, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_4000) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_4000();

Line 44: a0 := JTF_VARCHAR2_TABLE_4000();

40: procedure rosetta_table_copy_out_p2(t ams_list_query_pvt.sql_string_tbl, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_4000) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_4000();
45: else
46: a0 := JTF_VARCHAR2_TABLE_4000();
47: if t.count > 0 then
48: a0.extend(t.count);

Line 46: a0 := JTF_VARCHAR2_TABLE_4000();

42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_4000();
45: else
46: a0 := JTF_VARCHAR2_TABLE_4000();
47: if t.count > 0 then
48: a0.extend(t.count);
49: ddindx := t.first;
50: indx := 1;

Line 199: , p_sql_string_tbl JTF_VARCHAR2_TABLE_4000

195: , p_validation_level NUMBER
196: , x_return_status OUT NOCOPY VARCHAR2
197: , x_msg_count OUT NOCOPY NUMBER
198: , x_msg_data OUT NOCOPY VARCHAR2
199: , p_sql_string_tbl JTF_VARCHAR2_TABLE_4000
200: , x_parent_list_query_id OUT NOCOPY NUMBER
201: , p7_a0 NUMBER := 0-1962.0724
202: , p7_a1 DATE := fnd_api.g_miss_date
203: , p7_a2 NUMBER := 0-1962.0724

Line 379: , p_sql_string_tbl JTF_VARCHAR2_TABLE_4000

375: , p_validation_level NUMBER
376: , x_return_status OUT NOCOPY VARCHAR2
377: , x_msg_count OUT NOCOPY NUMBER
378: , x_msg_data OUT NOCOPY VARCHAR2
379: , p_sql_string_tbl JTF_VARCHAR2_TABLE_4000
380: , x_object_version_number OUT NOCOPY NUMBER
381: , p7_a0 NUMBER := 0-1962.0724
382: , p7_a1 DATE := fnd_api.g_miss_date
383: , p7_a2 NUMBER := 0-1962.0724