DBA Data[Home] [Help]

APPS.AHL_QA_RESULTS_PVT_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 14: , a1 JTF_VARCHAR2_TABLE_2000

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_qa_results_pvt.qa_results_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_2000
15: , a2 JTF_NUMBER_TABLE
16: ) as
17: ddindx binary_integer; indx binary_integer;
18: begin

Line 37: , a1 out nocopy JTF_VARCHAR2_TABLE_2000

33: end if;
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t ahl_qa_results_pvt.qa_results_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
38: , a2 out nocopy JTF_NUMBER_TABLE
39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin

Line 44: a1 := JTF_VARCHAR2_TABLE_2000();

40: ddindx binary_integer; indx binary_integer;
41: begin
42: if t is null or t.count = 0 then
43: a0 := JTF_NUMBER_TABLE();
44: a1 := JTF_VARCHAR2_TABLE_2000();
45: a2 := JTF_NUMBER_TABLE();
46: else
47: a0 := JTF_NUMBER_TABLE();
48: a1 := JTF_VARCHAR2_TABLE_2000();

Line 48: a1 := JTF_VARCHAR2_TABLE_2000();

44: a1 := JTF_VARCHAR2_TABLE_2000();
45: a2 := JTF_NUMBER_TABLE();
46: else
47: a0 := JTF_NUMBER_TABLE();
48: a1 := JTF_VARCHAR2_TABLE_2000();
49: a2 := JTF_NUMBER_TABLE();
50: if t.count > 0 then
51: a0.extend(t.count);
52: a1.extend(t.count);

Line 121: , a1 JTF_VARCHAR2_TABLE_2000

117: end if;
118: end rosetta_table_copy_out_p3;
119:
120: procedure rosetta_table_copy_in_p5(t out nocopy ahl_qa_results_pvt.qa_context_tbl_type, a0 JTF_VARCHAR2_TABLE_100
121: , a1 JTF_VARCHAR2_TABLE_2000
122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if a0 is not null and a0.count > 0 then

Line 142: , a1 out nocopy JTF_VARCHAR2_TABLE_2000

138: end if;
139: end if;
140: end rosetta_table_copy_in_p5;
141: procedure rosetta_table_copy_out_p5(t ahl_qa_results_pvt.qa_context_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
142: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
143: ) as
144: ddindx binary_integer; indx binary_integer;
145: begin
146: if t is null or t.count = 0 then

Line 148: a1 := JTF_VARCHAR2_TABLE_2000();

144: ddindx binary_integer; indx binary_integer;
145: begin
146: if t is null or t.count = 0 then
147: a0 := JTF_VARCHAR2_TABLE_100();
148: a1 := JTF_VARCHAR2_TABLE_2000();
149: else
150: a0 := JTF_VARCHAR2_TABLE_100();
151: a1 := JTF_VARCHAR2_TABLE_2000();
152: if t.count > 0 then

Line 151: a1 := JTF_VARCHAR2_TABLE_2000();

147: a0 := JTF_VARCHAR2_TABLE_100();
148: a1 := JTF_VARCHAR2_TABLE_2000();
149: else
150: a0 := JTF_VARCHAR2_TABLE_100();
151: a1 := JTF_VARCHAR2_TABLE_2000();
152: if t.count > 0 then
153: a0.extend(t.count);
154: a1.extend(t.count);
155: ddindx := t.first;

Line 184: , p13_a1 JTF_VARCHAR2_TABLE_2000

180: , p_organization_id NUMBER
181: , p_transaction_no NUMBER
182: , p_specification_id NUMBER
183: , p13_a0 JTF_NUMBER_TABLE
184: , p13_a1 JTF_VARCHAR2_TABLE_2000
185: , p13_a2 JTF_NUMBER_TABLE
186: , p14_a0 JTF_NUMBER_TABLE
187: , p14_a1 JTF_VARCHAR2_TABLE_2000
188: , p14_a2 JTF_NUMBER_TABLE

Line 187: , p14_a1 JTF_VARCHAR2_TABLE_2000

183: , p13_a0 JTF_NUMBER_TABLE
184: , p13_a1 JTF_VARCHAR2_TABLE_2000
185: , p13_a2 JTF_NUMBER_TABLE
186: , p14_a0 JTF_NUMBER_TABLE
187: , p14_a1 JTF_VARCHAR2_TABLE_2000
188: , p14_a2 JTF_NUMBER_TABLE
189: , p15_a0 JTF_VARCHAR2_TABLE_100
190: , p15_a1 JTF_VARCHAR2_TABLE_2000
191: , p_result_commit_flag NUMBER

Line 190: , p15_a1 JTF_VARCHAR2_TABLE_2000

186: , p14_a0 JTF_NUMBER_TABLE
187: , p14_a1 JTF_VARCHAR2_TABLE_2000
188: , p14_a2 JTF_NUMBER_TABLE
189: , p15_a0 JTF_VARCHAR2_TABLE_100
190: , p15_a1 JTF_VARCHAR2_TABLE_2000
191: , p_result_commit_flag NUMBER
192: , p_id_or_value VARCHAR2
193: , p_x_collection_id in out nocopy NUMBER
194: , p19_a0 in out nocopy JTF_NUMBER_TABLE