DBA Data[Home] [Help]

APPS.AHL_FMP_MR_VISIT_TYPES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 16: , a3 JTF_VARCHAR2_TABLE_100

12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_200
20: , a7 JTF_VARCHAR2_TABLE_200

Line 17: , a4 JTF_VARCHAR2_TABLE_100

13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_200
20: , a7 JTF_VARCHAR2_TABLE_200
21: , a8 JTF_VARCHAR2_TABLE_200

Line 18: , a5 JTF_VARCHAR2_TABLE_100

14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_200
20: , a7 JTF_VARCHAR2_TABLE_200
21: , a8 JTF_VARCHAR2_TABLE_200
22: , a9 JTF_VARCHAR2_TABLE_200

Line 39: , a26 JTF_VARCHAR2_TABLE_100

35: , a22 JTF_NUMBER_TABLE
36: , a23 JTF_DATE_TABLE
37: , a24 JTF_NUMBER_TABLE
38: , a25 JTF_NUMBER_TABLE
39: , a26 JTF_VARCHAR2_TABLE_100
40: ) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if a0 is not null and a0.count > 0 then

Line 87: , a3 out nocopy JTF_VARCHAR2_TABLE_100

83: end rosetta_table_copy_in_p1;
84: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_VARCHAR2_TABLE_100
89: , a5 out nocopy JTF_VARCHAR2_TABLE_100
90: , a6 out nocopy JTF_VARCHAR2_TABLE_200
91: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 88: , a4 out nocopy JTF_VARCHAR2_TABLE_100

84: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_VARCHAR2_TABLE_100
89: , a5 out nocopy JTF_VARCHAR2_TABLE_100
90: , a6 out nocopy JTF_VARCHAR2_TABLE_200
91: , a7 out nocopy JTF_VARCHAR2_TABLE_200
92: , a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 89: , a5 out nocopy JTF_VARCHAR2_TABLE_100

85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_VARCHAR2_TABLE_100
89: , a5 out nocopy JTF_VARCHAR2_TABLE_100
90: , a6 out nocopy JTF_VARCHAR2_TABLE_200
91: , a7 out nocopy JTF_VARCHAR2_TABLE_200
92: , a8 out nocopy JTF_VARCHAR2_TABLE_200
93: , a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 110: , a26 out nocopy JTF_VARCHAR2_TABLE_100

106: , a22 out nocopy JTF_NUMBER_TABLE
107: , a23 out nocopy JTF_DATE_TABLE
108: , a24 out nocopy JTF_NUMBER_TABLE
109: , a25 out nocopy JTF_NUMBER_TABLE
110: , a26 out nocopy JTF_VARCHAR2_TABLE_100
111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then

Line 118: a3 := JTF_VARCHAR2_TABLE_100();

114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_VARCHAR2_TABLE_100();
120: a5 := JTF_VARCHAR2_TABLE_100();
121: a6 := JTF_VARCHAR2_TABLE_200();
122: a7 := JTF_VARCHAR2_TABLE_200();

Line 119: a4 := JTF_VARCHAR2_TABLE_100();

115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_VARCHAR2_TABLE_100();
120: a5 := JTF_VARCHAR2_TABLE_100();
121: a6 := JTF_VARCHAR2_TABLE_200();
122: a7 := JTF_VARCHAR2_TABLE_200();
123: a8 := JTF_VARCHAR2_TABLE_200();

Line 120: a5 := JTF_VARCHAR2_TABLE_100();

116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_VARCHAR2_TABLE_100();
120: a5 := JTF_VARCHAR2_TABLE_100();
121: a6 := JTF_VARCHAR2_TABLE_200();
122: a7 := JTF_VARCHAR2_TABLE_200();
123: a8 := JTF_VARCHAR2_TABLE_200();
124: a9 := JTF_VARCHAR2_TABLE_200();

Line 141: a26 := JTF_VARCHAR2_TABLE_100();

137: a22 := JTF_NUMBER_TABLE();
138: a23 := JTF_DATE_TABLE();
139: a24 := JTF_NUMBER_TABLE();
140: a25 := JTF_NUMBER_TABLE();
141: a26 := JTF_VARCHAR2_TABLE_100();
142: else
143: a0 := JTF_NUMBER_TABLE();
144: a1 := JTF_NUMBER_TABLE();
145: a2 := JTF_NUMBER_TABLE();

Line 146: a3 := JTF_VARCHAR2_TABLE_100();

142: else
143: a0 := JTF_NUMBER_TABLE();
144: a1 := JTF_NUMBER_TABLE();
145: a2 := JTF_NUMBER_TABLE();
146: a3 := JTF_VARCHAR2_TABLE_100();
147: a4 := JTF_VARCHAR2_TABLE_100();
148: a5 := JTF_VARCHAR2_TABLE_100();
149: a6 := JTF_VARCHAR2_TABLE_200();
150: a7 := JTF_VARCHAR2_TABLE_200();

Line 147: a4 := JTF_VARCHAR2_TABLE_100();

143: a0 := JTF_NUMBER_TABLE();
144: a1 := JTF_NUMBER_TABLE();
145: a2 := JTF_NUMBER_TABLE();
146: a3 := JTF_VARCHAR2_TABLE_100();
147: a4 := JTF_VARCHAR2_TABLE_100();
148: a5 := JTF_VARCHAR2_TABLE_100();
149: a6 := JTF_VARCHAR2_TABLE_200();
150: a7 := JTF_VARCHAR2_TABLE_200();
151: a8 := JTF_VARCHAR2_TABLE_200();

Line 148: a5 := JTF_VARCHAR2_TABLE_100();

144: a1 := JTF_NUMBER_TABLE();
145: a2 := JTF_NUMBER_TABLE();
146: a3 := JTF_VARCHAR2_TABLE_100();
147: a4 := JTF_VARCHAR2_TABLE_100();
148: a5 := JTF_VARCHAR2_TABLE_100();
149: a6 := JTF_VARCHAR2_TABLE_200();
150: a7 := JTF_VARCHAR2_TABLE_200();
151: a8 := JTF_VARCHAR2_TABLE_200();
152: a9 := JTF_VARCHAR2_TABLE_200();

Line 169: a26 := JTF_VARCHAR2_TABLE_100();

165: a22 := JTF_NUMBER_TABLE();
166: a23 := JTF_DATE_TABLE();
167: a24 := JTF_NUMBER_TABLE();
168: a25 := JTF_NUMBER_TABLE();
169: a26 := JTF_VARCHAR2_TABLE_100();
170: if t.count > 0 then
171: a0.extend(t.count);
172: a1.extend(t.count);
173: a2.extend(t.count);

Line 250: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100

246: , x_msg_data out nocopy VARCHAR2
247: , p9_a0 in out nocopy JTF_NUMBER_TABLE
248: , p9_a1 in out nocopy JTF_NUMBER_TABLE
249: , p9_a2 in out nocopy JTF_NUMBER_TABLE
250: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
251: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
252: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
253: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_200
254: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_200

Line 251: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100

247: , p9_a0 in out nocopy JTF_NUMBER_TABLE
248: , p9_a1 in out nocopy JTF_NUMBER_TABLE
249: , p9_a2 in out nocopy JTF_NUMBER_TABLE
250: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
251: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
252: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
253: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_200
254: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_200
255: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_200

Line 252: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100

248: , p9_a1 in out nocopy JTF_NUMBER_TABLE
249: , p9_a2 in out nocopy JTF_NUMBER_TABLE
250: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
251: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
252: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
253: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_200
254: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_200
255: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_200
256: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_200

Line 273: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100

269: , p9_a22 in out nocopy JTF_NUMBER_TABLE
270: , p9_a23 in out nocopy JTF_DATE_TABLE
271: , p9_a24 in out nocopy JTF_NUMBER_TABLE
272: , p9_a25 in out nocopy JTF_NUMBER_TABLE
273: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
274: )
275:
276: as
277: ddp_x_mr_visit_type_tbl ahl_fmp_mr_visit_types_pvt.mr_visit_type_tbl_type;