DBA Data[Home] [Help]

APPS.AHL_FMP_MR_VISIT_TYPES_PVT_W dependencies on JTF_NUMBER_TABLE

Line 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

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
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

Line 14: , a1 JTF_NUMBER_TABLE

10: return d;
11: end;
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

Line 15: , a2 JTF_NUMBER_TABLE

11: end;
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

Line 35: , a22 JTF_NUMBER_TABLE

31: , a18 JTF_VARCHAR2_TABLE_200
32: , a19 JTF_VARCHAR2_TABLE_200
33: , a20 JTF_VARCHAR2_TABLE_200
34: , a21 JTF_DATE_TABLE
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

Line 37: , a24 JTF_NUMBER_TABLE

33: , a20 JTF_VARCHAR2_TABLE_200
34: , a21 JTF_DATE_TABLE
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;

Line 38: , a25 JTF_NUMBER_TABLE

34: , a21 JTF_DATE_TABLE
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

Line 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

80: end loop;
81: end if;
82: end if;
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

Line 85: , a1 out nocopy JTF_NUMBER_TABLE

81: end if;
82: end if;
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

Line 86: , a2 out nocopy JTF_NUMBER_TABLE

82: end if;
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

Line 106: , a22 out nocopy JTF_NUMBER_TABLE

102: , a18 out nocopy JTF_VARCHAR2_TABLE_200
103: , a19 out nocopy JTF_VARCHAR2_TABLE_200
104: , a20 out nocopy JTF_VARCHAR2_TABLE_200
105: , a21 out nocopy JTF_DATE_TABLE
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

Line 108: , a24 out nocopy JTF_NUMBER_TABLE

104: , a20 out nocopy JTF_VARCHAR2_TABLE_200
105: , a21 out nocopy JTF_DATE_TABLE
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;

Line 109: , a25 out nocopy JTF_NUMBER_TABLE

105: , a21 out nocopy JTF_DATE_TABLE
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

Line 115: a0 := JTF_NUMBER_TABLE();

111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin
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();

Line 116: a1 := JTF_NUMBER_TABLE();

112: ddindx binary_integer; indx binary_integer;
113: begin
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();

Line 117: a2 := JTF_NUMBER_TABLE();

113: begin
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();

Line 137: a22 := JTF_NUMBER_TABLE();

133: a18 := JTF_VARCHAR2_TABLE_200();
134: a19 := JTF_VARCHAR2_TABLE_200();
135: a20 := JTF_VARCHAR2_TABLE_200();
136: a21 := JTF_DATE_TABLE();
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();

Line 139: a24 := JTF_NUMBER_TABLE();

135: a20 := JTF_VARCHAR2_TABLE_200();
136: a21 := JTF_DATE_TABLE();
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();

Line 140: a25 := JTF_NUMBER_TABLE();

136: a21 := JTF_DATE_TABLE();
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();

Line 143: a0 := JTF_NUMBER_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();
146: a3 := JTF_VARCHAR2_TABLE_100();
147: a4 := JTF_VARCHAR2_TABLE_100();

Line 144: a1 := 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();
146: a3 := JTF_VARCHAR2_TABLE_100();
147: a4 := JTF_VARCHAR2_TABLE_100();
148: a5 := JTF_VARCHAR2_TABLE_100();

Line 145: a2 := 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();
146: a3 := JTF_VARCHAR2_TABLE_100();
147: a4 := JTF_VARCHAR2_TABLE_100();
148: a5 := JTF_VARCHAR2_TABLE_100();
149: a6 := JTF_VARCHAR2_TABLE_200();

Line 165: a22 := JTF_NUMBER_TABLE();

161: a18 := JTF_VARCHAR2_TABLE_200();
162: a19 := JTF_VARCHAR2_TABLE_200();
163: a20 := JTF_VARCHAR2_TABLE_200();
164: a21 := JTF_DATE_TABLE();
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();

Line 167: a24 := JTF_NUMBER_TABLE();

163: a20 := JTF_VARCHAR2_TABLE_200();
164: a21 := JTF_DATE_TABLE();
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);

Line 168: a25 := JTF_NUMBER_TABLE();

164: a21 := JTF_DATE_TABLE();
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);

Line 247: , p9_a0 in out nocopy JTF_NUMBER_TABLE

243: , p_module_type VARCHAR2
244: , x_return_status out nocopy VARCHAR2
245: , x_msg_count out nocopy NUMBER
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

Line 248: , p9_a1 in out nocopy JTF_NUMBER_TABLE

244: , x_return_status out nocopy VARCHAR2
245: , x_msg_count out nocopy NUMBER
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

Line 249: , p9_a2 in out nocopy JTF_NUMBER_TABLE

245: , x_msg_count out nocopy NUMBER
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

Line 269: , p9_a22 in out nocopy JTF_NUMBER_TABLE

265: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
266: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
267: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
268: , p9_a21 in out nocopy JTF_DATE_TABLE
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

Line 271: , p9_a24 in out nocopy JTF_NUMBER_TABLE

267: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
268: , p9_a21 in out nocopy JTF_DATE_TABLE
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:

Line 272: , p9_a25 in out nocopy JTF_NUMBER_TABLE

268: , p9_a21 in out nocopy JTF_DATE_TABLE
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