DBA Data[Home] [Help]

APPS.AHL_LTP_SPACE_SCHEDULE_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 JTF_VARCHAR2_TABLE_300

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 JTF_VARCHAR2_TABLE_300
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100

Line 73: procedure rosetta_table_copy_out_p5(t ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300

69: end loop;
70: end if;
71: end if;
72: end rosetta_table_copy_in_p5;
73: procedure rosetta_table_copy_out_p5(t ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_VARCHAR2_TABLE_100
76: , a3 out nocopy JTF_NUMBER_TABLE
77: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 97: a0 := JTF_VARCHAR2_TABLE_300();

93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then
97: a0 := JTF_VARCHAR2_TABLE_300();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_NUMBER_TABLE();
101: a4 := JTF_VARCHAR2_TABLE_100();

Line 118: a0 := JTF_VARCHAR2_TABLE_300();

114: a17 := JTF_DATE_TABLE();
115: a18 := JTF_DATE_TABLE();
116: a19 := JTF_DATE_TABLE();
117: else
118: a0 := JTF_VARCHAR2_TABLE_300();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_VARCHAR2_TABLE_100();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();

Line 192: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 JTF_VARCHAR2_TABLE_300

188: end if;
189: end if;
190: end rosetta_table_copy_out_p5;
191:
192: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 JTF_VARCHAR2_TABLE_300
193: , a1 JTF_VARCHAR2_TABLE_100
194: , a2 JTF_NUMBER_TABLE
195: , a3 JTF_VARCHAR2_TABLE_100
196: , a4 JTF_VARCHAR2_TABLE_100

Line 253: procedure rosetta_table_copy_out_p6(t ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300

249: end loop;
250: end if;
251: end if;
252: end rosetta_table_copy_in_p6;
253: procedure rosetta_table_copy_out_p6(t ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
254: , a1 out nocopy JTF_VARCHAR2_TABLE_100
255: , a2 out nocopy JTF_NUMBER_TABLE
256: , a3 out nocopy JTF_VARCHAR2_TABLE_100
257: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 279: a0 := JTF_VARCHAR2_TABLE_300();

275: ) as
276: ddindx binary_integer; indx binary_integer;
277: begin
278: if t is null or t.count = 0 then
279: a0 := JTF_VARCHAR2_TABLE_300();
280: a1 := JTF_VARCHAR2_TABLE_100();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_VARCHAR2_TABLE_100();
283: a4 := JTF_VARCHAR2_TABLE_100();

Line 302: a0 := JTF_VARCHAR2_TABLE_300();

298: a19 := JTF_VARCHAR2_TABLE_100();
299: a20 := JTF_VARCHAR2_TABLE_100();
300: a21 := JTF_VARCHAR2_TABLE_100();
301: else
302: a0 := JTF_VARCHAR2_TABLE_300();
303: a1 := JTF_VARCHAR2_TABLE_100();
304: a2 := JTF_NUMBER_TABLE();
305: a3 := JTF_VARCHAR2_TABLE_100();
306: a4 := JTF_VARCHAR2_TABLE_100();

Line 439: , a7 JTF_VARCHAR2_TABLE_300

435: , a3 JTF_NUMBER_TABLE
436: , a4 JTF_VARCHAR2_TABLE_100
437: , a5 JTF_VARCHAR2_TABLE_100
438: , a6 JTF_VARCHAR2_TABLE_100
439: , a7 JTF_VARCHAR2_TABLE_300
440: , a8 JTF_VARCHAR2_TABLE_100
441: , a9 JTF_VARCHAR2_TABLE_100
442: , a10 JTF_DATE_TABLE
443: , a11 JTF_DATE_TABLE

Line 482: , a7 out nocopy JTF_VARCHAR2_TABLE_300

478: , a3 out nocopy JTF_NUMBER_TABLE
479: , a4 out nocopy JTF_VARCHAR2_TABLE_100
480: , a5 out nocopy JTF_VARCHAR2_TABLE_100
481: , a6 out nocopy JTF_VARCHAR2_TABLE_100
482: , a7 out nocopy JTF_VARCHAR2_TABLE_300
483: , a8 out nocopy JTF_VARCHAR2_TABLE_100
484: , a9 out nocopy JTF_VARCHAR2_TABLE_100
485: , a10 out nocopy JTF_DATE_TABLE
486: , a11 out nocopy JTF_DATE_TABLE

Line 499: a7 := JTF_VARCHAR2_TABLE_300();

495: a3 := JTF_NUMBER_TABLE();
496: a4 := JTF_VARCHAR2_TABLE_100();
497: a5 := JTF_VARCHAR2_TABLE_100();
498: a6 := JTF_VARCHAR2_TABLE_100();
499: a7 := JTF_VARCHAR2_TABLE_300();
500: a8 := JTF_VARCHAR2_TABLE_100();
501: a9 := JTF_VARCHAR2_TABLE_100();
502: a10 := JTF_DATE_TABLE();
503: a11 := JTF_DATE_TABLE();

Line 513: a7 := JTF_VARCHAR2_TABLE_300();

509: a3 := JTF_NUMBER_TABLE();
510: a4 := JTF_VARCHAR2_TABLE_100();
511: a5 := JTF_VARCHAR2_TABLE_100();
512: a6 := JTF_VARCHAR2_TABLE_100();
513: a7 := JTF_VARCHAR2_TABLE_300();
514: a8 := JTF_VARCHAR2_TABLE_100();
515: a9 := JTF_VARCHAR2_TABLE_100();
516: a10 := JTF_DATE_TABLE();
517: a11 := JTF_DATE_TABLE();

Line 619: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300

615: , p5_a16 VARCHAR2
616: , p5_a17 DATE
617: , p5_a18 DATE
618: , p5_a19 DATE
619: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
620: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
621: , p6_a2 out nocopy JTF_NUMBER_TABLE
622: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 854: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300

850: , p6_a3 out nocopy JTF_NUMBER_TABLE
851: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
852: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a10 out nocopy JTF_DATE_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE