DBA Data[Home] [Help]

APPS.AHL_VWP_VISIT_MR_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 15: , a2 JTF_VARCHAR2_TABLE_100

11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_visit_mr_pvt.visit_mr_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_200
17: , a4 JTF_VARCHAR2_TABLE_200
18: , a5 JTF_VARCHAR2_TABLE_200
19: , a6 JTF_VARCHAR2_TABLE_200

Line 36: , a23 JTF_VARCHAR2_TABLE_100

32: , a19 JTF_NUMBER_TABLE
33: , a20 JTF_DATE_TABLE
34: , a21 JTF_NUMBER_TABLE
35: , a22 JTF_NUMBER_TABLE
36: , a23 JTF_VARCHAR2_TABLE_100
37: ) as
38: ddindx binary_integer; indx binary_integer;
39: begin
40: if a0 is not null and a0.count > 0 then

Line 80: , a2 out nocopy JTF_VARCHAR2_TABLE_100

76: end if;
77: end rosetta_table_copy_in_p1;
78: procedure rosetta_table_copy_out_p1(t ahl_vwp_visit_mr_pvt.visit_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , a3 out nocopy JTF_VARCHAR2_TABLE_200
82: , a4 out nocopy JTF_VARCHAR2_TABLE_200
83: , a5 out nocopy JTF_VARCHAR2_TABLE_200
84: , a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 101: , a23 out nocopy JTF_VARCHAR2_TABLE_100

97: , a19 out nocopy JTF_NUMBER_TABLE
98: , a20 out nocopy JTF_DATE_TABLE
99: , a21 out nocopy JTF_NUMBER_TABLE
100: , a22 out nocopy JTF_NUMBER_TABLE
101: , a23 out nocopy JTF_VARCHAR2_TABLE_100
102: ) as
103: ddindx binary_integer; indx binary_integer;
104: begin
105: if t is null or t.count = 0 then

Line 108: a2 := JTF_VARCHAR2_TABLE_100();

104: begin
105: if t is null or t.count = 0 then
106: a0 := JTF_NUMBER_TABLE();
107: a1 := JTF_NUMBER_TABLE();
108: a2 := JTF_VARCHAR2_TABLE_100();
109: a3 := JTF_VARCHAR2_TABLE_200();
110: a4 := JTF_VARCHAR2_TABLE_200();
111: a5 := JTF_VARCHAR2_TABLE_200();
112: a6 := JTF_VARCHAR2_TABLE_200();

Line 129: a23 := JTF_VARCHAR2_TABLE_100();

125: a19 := JTF_NUMBER_TABLE();
126: a20 := JTF_DATE_TABLE();
127: a21 := JTF_NUMBER_TABLE();
128: a22 := JTF_NUMBER_TABLE();
129: a23 := JTF_VARCHAR2_TABLE_100();
130: else
131: a0 := JTF_NUMBER_TABLE();
132: a1 := JTF_NUMBER_TABLE();
133: a2 := JTF_VARCHAR2_TABLE_100();

Line 133: a2 := JTF_VARCHAR2_TABLE_100();

129: a23 := JTF_VARCHAR2_TABLE_100();
130: else
131: a0 := JTF_NUMBER_TABLE();
132: a1 := JTF_NUMBER_TABLE();
133: a2 := JTF_VARCHAR2_TABLE_100();
134: a3 := JTF_VARCHAR2_TABLE_200();
135: a4 := JTF_VARCHAR2_TABLE_200();
136: a5 := JTF_VARCHAR2_TABLE_200();
137: a6 := JTF_VARCHAR2_TABLE_200();

Line 154: a23 := JTF_VARCHAR2_TABLE_100();

150: a19 := JTF_NUMBER_TABLE();
151: a20 := JTF_DATE_TABLE();
152: a21 := JTF_NUMBER_TABLE();
153: a22 := JTF_NUMBER_TABLE();
154: a23 := JTF_VARCHAR2_TABLE_100();
155: if t.count > 0 then
156: a0.extend(t.count);
157: a1.extend(t.count);
158: a2.extend(t.count);

Line 224: , p5_a2 JTF_VARCHAR2_TABLE_100

220: , p_validation_level NUMBER
221: , p_module_type VARCHAR2
222: , p5_a0 JTF_NUMBER_TABLE
223: , p5_a1 JTF_NUMBER_TABLE
224: , p5_a2 JTF_VARCHAR2_TABLE_100
225: , p5_a3 JTF_VARCHAR2_TABLE_200
226: , p5_a4 JTF_VARCHAR2_TABLE_200
227: , p5_a5 JTF_VARCHAR2_TABLE_200
228: , p5_a6 JTF_VARCHAR2_TABLE_200

Line 245: , p5_a23 JTF_VARCHAR2_TABLE_100

241: , p5_a19 JTF_NUMBER_TABLE
242: , p5_a20 JTF_DATE_TABLE
243: , p5_a21 JTF_NUMBER_TABLE
244: , p5_a22 JTF_NUMBER_TABLE
245: , p5_a23 JTF_VARCHAR2_TABLE_100
246: , x_return_status out nocopy VARCHAR2
247: , x_msg_count out nocopy NUMBER
248: , x_msg_data out nocopy VARCHAR2
249: )