APPS.AHL_VWP_VISITS_STAGES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 15: , a2 JTF_VARCHAR2_TABLE_100

11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_DATE_TABLE
19: , a6 JTF_DATE_TABLE

Line 21: , a8 JTF_VARCHAR2_TABLE_100

17: , a4 JTF_DATE_TABLE
18: , a5 JTF_DATE_TABLE
19: , a6 JTF_DATE_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_200
23: , a10 JTF_VARCHAR2_TABLE_200
24: , a11 JTF_VARCHAR2_TABLE_200
25: , a12 JTF_VARCHAR2_TABLE_200

Line 80: , a2 out nocopy JTF_VARCHAR2_TABLE_100

76: end if;
77: end rosetta_table_copy_in_p2;
78: procedure rosetta_table_copy_out_p2(t ahl_vwp_visits_stages_pvt.visit_stages_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_NUMBER_TABLE
82: , a4 out nocopy JTF_DATE_TABLE
83: , a5 out nocopy JTF_DATE_TABLE
84: , a6 out nocopy JTF_DATE_TABLE

Line 86: , a8 out nocopy JTF_VARCHAR2_TABLE_100

82: , a4 out nocopy JTF_DATE_TABLE
83: , a5 out nocopy JTF_DATE_TABLE
84: , a6 out nocopy JTF_DATE_TABLE
85: , a7 out nocopy JTF_NUMBER_TABLE
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100
87: , a9 out nocopy JTF_VARCHAR2_TABLE_200
88: , a10 out nocopy JTF_VARCHAR2_TABLE_200
89: , a11 out nocopy JTF_VARCHAR2_TABLE_200
90: , a12 out nocopy JTF_VARCHAR2_TABLE_200

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_NUMBER_TABLE();
110: a4 := JTF_DATE_TABLE();
111: a5 := JTF_DATE_TABLE();
112: a6 := JTF_DATE_TABLE();

Line 114: a8 := JTF_VARCHAR2_TABLE_100();

110: a4 := JTF_DATE_TABLE();
111: a5 := JTF_DATE_TABLE();
112: a6 := JTF_DATE_TABLE();
113: a7 := JTF_NUMBER_TABLE();
114: a8 := JTF_VARCHAR2_TABLE_100();
115: a9 := JTF_VARCHAR2_TABLE_200();
116: a10 := JTF_VARCHAR2_TABLE_200();
117: a11 := JTF_VARCHAR2_TABLE_200();
118: a12 := JTF_VARCHAR2_TABLE_200();

Line 133: a2 := JTF_VARCHAR2_TABLE_100();

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

Line 139: a8 := JTF_VARCHAR2_TABLE_100();

135: a4 := JTF_DATE_TABLE();
136: a5 := JTF_DATE_TABLE();
137: a6 := JTF_DATE_TABLE();
138: a7 := JTF_NUMBER_TABLE();
139: a8 := JTF_VARCHAR2_TABLE_100();
140: a9 := JTF_VARCHAR2_TABLE_200();
141: a10 := JTF_VARCHAR2_TABLE_200();
142: a11 := JTF_VARCHAR2_TABLE_200();
143: a12 := JTF_VARCHAR2_TABLE_200();

Line 219: , a2 JTF_VARCHAR2_TABLE_100

215: end rosetta_table_copy_out_p2;
216:
217: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
218: , a1 JTF_NUMBER_TABLE
219: , a2 JTF_VARCHAR2_TABLE_100
220: , a3 JTF_NUMBER_TABLE
221: , a4 JTF_NUMBER_TABLE
222: , a5 JTF_NUMBER_TABLE
223: , a6 JTF_DATE_TABLE

Line 254: , a2 out nocopy JTF_VARCHAR2_TABLE_100

250: end if;
251: end rosetta_table_copy_in_p3;
252: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
253: , a1 out nocopy JTF_NUMBER_TABLE
254: , a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , a3 out nocopy JTF_NUMBER_TABLE
256: , a4 out nocopy JTF_NUMBER_TABLE
257: , a5 out nocopy JTF_NUMBER_TABLE
258: , a6 out nocopy JTF_DATE_TABLE

Line 267: a2 := JTF_VARCHAR2_TABLE_100();

263: begin
264: if t is null or t.count = 0 then
265: a0 := JTF_NUMBER_TABLE();
266: a1 := JTF_NUMBER_TABLE();
267: a2 := JTF_VARCHAR2_TABLE_100();
268: a3 := JTF_NUMBER_TABLE();
269: a4 := JTF_NUMBER_TABLE();
270: a5 := JTF_NUMBER_TABLE();
271: a6 := JTF_DATE_TABLE();

Line 277: a2 := JTF_VARCHAR2_TABLE_100();

273: a8 := JTF_DATE_TABLE();
274: else
275: a0 := JTF_NUMBER_TABLE();
276: a1 := JTF_NUMBER_TABLE();
277: a2 := JTF_VARCHAR2_TABLE_100();
278: a3 := JTF_NUMBER_TABLE();
279: a4 := JTF_NUMBER_TABLE();
280: a5 := JTF_NUMBER_TABLE();
281: a6 := JTF_DATE_TABLE();

Line 324: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100

320: , p_module_type VARCHAR2
321: , p_visit_id NUMBER
322: , p6_a0 in out nocopy JTF_NUMBER_TABLE
323: , p6_a1 in out nocopy JTF_NUMBER_TABLE
324: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a3 in out nocopy JTF_NUMBER_TABLE
326: , p6_a4 in out nocopy JTF_DATE_TABLE
327: , p6_a5 in out nocopy JTF_DATE_TABLE
328: , p6_a6 in out nocopy JTF_DATE_TABLE

Line 330: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100

326: , p6_a4 in out nocopy JTF_DATE_TABLE
327: , p6_a5 in out nocopy JTF_DATE_TABLE
328: , p6_a6 in out nocopy JTF_DATE_TABLE
329: , p6_a7 in out nocopy JTF_NUMBER_TABLE
330: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_200
332: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_200
333: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_200
334: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200

Line 451: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

447: , p_start_row NUMBER
448: , p_rows_per_page NUMBER
449: , p8_a0 out nocopy JTF_NUMBER_TABLE
450: , p8_a1 out nocopy JTF_NUMBER_TABLE
451: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
452: , p8_a3 out nocopy JTF_NUMBER_TABLE
453: , p8_a4 out nocopy JTF_DATE_TABLE
454: , p8_a5 out nocopy JTF_DATE_TABLE
455: , p8_a6 out nocopy JTF_DATE_TABLE

Line 457: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100

453: , p8_a4 out nocopy JTF_DATE_TABLE
454: , p8_a5 out nocopy JTF_DATE_TABLE
455: , p8_a6 out nocopy JTF_DATE_TABLE
456: , p8_a7 out nocopy JTF_NUMBER_TABLE
457: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
458: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_200
459: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_200
460: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_200
461: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200