eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_LTP_SPACE_SCHEDULE_PVT_W dependencies on JTF_DATE_TABLE

Line 33: , a17 JTF_DATE_TABLE

29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_DATE_TABLE
35: , a19 JTF_DATE_TABLE
36: ) as
37: ddindx binary_integer; indx binary_integer;

Line 34: , a18 JTF_DATE_TABLE

30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_DATE_TABLE
35: , a19 JTF_DATE_TABLE
36: ) as
37: ddindx binary_integer; indx binary_integer;
38: begin

Line 35: , a19 JTF_DATE_TABLE

31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_DATE_TABLE
35: , a19 JTF_DATE_TABLE
36: ) as
37: ddindx binary_integer; indx binary_integer;
38: begin
39: if a0 is not null and a0.count > 0 then

Line 90: , a17 out nocopy JTF_DATE_TABLE

86: , a13 out nocopy JTF_NUMBER_TABLE
87: , a14 out nocopy JTF_VARCHAR2_TABLE_100
88: , a15 out nocopy JTF_VARCHAR2_TABLE_100
89: , a16 out nocopy JTF_VARCHAR2_TABLE_100
90: , a17 out nocopy JTF_DATE_TABLE
91: , a18 out nocopy JTF_DATE_TABLE
92: , a19 out nocopy JTF_DATE_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;

Line 91: , a18 out nocopy JTF_DATE_TABLE

87: , a14 out nocopy JTF_VARCHAR2_TABLE_100
88: , a15 out nocopy JTF_VARCHAR2_TABLE_100
89: , a16 out nocopy JTF_VARCHAR2_TABLE_100
90: , a17 out nocopy JTF_DATE_TABLE
91: , a18 out nocopy JTF_DATE_TABLE
92: , a19 out nocopy JTF_DATE_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin

Line 92: , a19 out nocopy JTF_DATE_TABLE

88: , a15 out nocopy JTF_VARCHAR2_TABLE_100
89: , a16 out nocopy JTF_VARCHAR2_TABLE_100
90: , a17 out nocopy JTF_DATE_TABLE
91: , a18 out nocopy JTF_DATE_TABLE
92: , a19 out nocopy JTF_DATE_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then

Line 114: a17 := JTF_DATE_TABLE();

110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_VARCHAR2_TABLE_100();
112: a15 := JTF_VARCHAR2_TABLE_100();
113: a16 := JTF_VARCHAR2_TABLE_100();
114: a17 := JTF_DATE_TABLE();
115: a18 := JTF_DATE_TABLE();
116: a19 := JTF_DATE_TABLE();
117: else
118: a0 := JTF_VARCHAR2_TABLE_300();

Line 115: a18 := JTF_DATE_TABLE();

111: a14 := JTF_VARCHAR2_TABLE_100();
112: a15 := JTF_VARCHAR2_TABLE_100();
113: a16 := JTF_VARCHAR2_TABLE_100();
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();

Line 116: a19 := JTF_DATE_TABLE();

112: a15 := JTF_VARCHAR2_TABLE_100();
113: a16 := JTF_VARCHAR2_TABLE_100();
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();

Line 135: a17 := JTF_DATE_TABLE();

131: a13 := JTF_NUMBER_TABLE();
132: a14 := JTF_VARCHAR2_TABLE_100();
133: a15 := JTF_VARCHAR2_TABLE_100();
134: a16 := JTF_VARCHAR2_TABLE_100();
135: a17 := JTF_DATE_TABLE();
136: a18 := JTF_DATE_TABLE();
137: a19 := JTF_DATE_TABLE();
138: if t.count > 0 then
139: a0.extend(t.count);

Line 136: a18 := JTF_DATE_TABLE();

132: a14 := JTF_VARCHAR2_TABLE_100();
133: a15 := JTF_VARCHAR2_TABLE_100();
134: a16 := JTF_VARCHAR2_TABLE_100();
135: a17 := JTF_DATE_TABLE();
136: a18 := JTF_DATE_TABLE();
137: a19 := JTF_DATE_TABLE();
138: if t.count > 0 then
139: a0.extend(t.count);
140: a1.extend(t.count);

Line 137: a19 := JTF_DATE_TABLE();

133: a15 := JTF_VARCHAR2_TABLE_100();
134: a16 := JTF_VARCHAR2_TABLE_100();
135: a17 := JTF_DATE_TABLE();
136: a18 := JTF_DATE_TABLE();
137: a19 := JTF_DATE_TABLE();
138: if t.count > 0 then
139: a0.extend(t.count);
140: a1.extend(t.count);
141: a2.extend(t.count);

Line 383: , a1 JTF_DATE_TABLE

379: end if;
380: end rosetta_table_copy_out_p6;
381:
382: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 JTF_NUMBER_TABLE
383: , a1 JTF_DATE_TABLE
384: ) as
385: ddindx binary_integer; indx binary_integer;
386: begin
387: if a0 is not null and a0.count > 0 then

Line 404: , a1 out nocopy JTF_DATE_TABLE

400: end if;
401: end if;
402: end rosetta_table_copy_in_p7;
403: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE
404: , a1 out nocopy JTF_DATE_TABLE
405: ) as
406: ddindx binary_integer; indx binary_integer;
407: begin
408: if t is null or t.count = 0 then

Line 410: a1 := JTF_DATE_TABLE();

406: ddindx binary_integer; indx binary_integer;
407: begin
408: if t is null or t.count = 0 then
409: a0 := JTF_NUMBER_TABLE();
410: a1 := JTF_DATE_TABLE();
411: else
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_DATE_TABLE();
414: if t.count > 0 then

Line 413: a1 := JTF_DATE_TABLE();

409: a0 := JTF_NUMBER_TABLE();
410: a1 := JTF_DATE_TABLE();
411: else
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_DATE_TABLE();
414: if t.count > 0 then
415: a0.extend(t.count);
416: a1.extend(t.count);
417: ddindx := t.first;

Line 442: , a10 JTF_DATE_TABLE

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
444: , a12 JTF_DATE_TABLE
445: ) as
446: ddindx binary_integer; indx binary_integer;

Line 443: , a11 JTF_DATE_TABLE

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
444: , a12 JTF_DATE_TABLE
445: ) as
446: ddindx binary_integer; indx binary_integer;
447: begin

Line 444: , a12 JTF_DATE_TABLE

440: , a8 JTF_VARCHAR2_TABLE_100
441: , a9 JTF_VARCHAR2_TABLE_100
442: , a10 JTF_DATE_TABLE
443: , a11 JTF_DATE_TABLE
444: , a12 JTF_DATE_TABLE
445: ) as
446: ddindx binary_integer; indx binary_integer;
447: begin
448: if a0 is not null and a0.count > 0 then

Line 485: , a10 out nocopy JTF_DATE_TABLE

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
487: , a12 out nocopy JTF_DATE_TABLE
488: ) as
489: ddindx binary_integer; indx binary_integer;

Line 486: , a11 out nocopy JTF_DATE_TABLE

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
487: , a12 out nocopy JTF_DATE_TABLE
488: ) as
489: ddindx binary_integer; indx binary_integer;
490: begin

Line 487: , a12 out nocopy JTF_DATE_TABLE

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
487: , a12 out nocopy JTF_DATE_TABLE
488: ) as
489: ddindx binary_integer; indx binary_integer;
490: begin
491: if t is null or t.count = 0 then

Line 502: a10 := JTF_DATE_TABLE();

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();
504: a12 := JTF_DATE_TABLE();
505: else
506: a0 := JTF_NUMBER_TABLE();

Line 503: a11 := JTF_DATE_TABLE();

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();
504: a12 := JTF_DATE_TABLE();
505: else
506: a0 := JTF_NUMBER_TABLE();
507: a1 := JTF_VARCHAR2_TABLE_100();

Line 504: a12 := JTF_DATE_TABLE();

500: a8 := JTF_VARCHAR2_TABLE_100();
501: a9 := JTF_VARCHAR2_TABLE_100();
502: a10 := JTF_DATE_TABLE();
503: a11 := JTF_DATE_TABLE();
504: a12 := JTF_DATE_TABLE();
505: else
506: a0 := JTF_NUMBER_TABLE();
507: a1 := JTF_VARCHAR2_TABLE_100();
508: a2 := JTF_VARCHAR2_TABLE_100();

Line 516: a10 := JTF_DATE_TABLE();

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();
518: a12 := JTF_DATE_TABLE();
519: if t.count > 0 then
520: a0.extend(t.count);

Line 517: a11 := JTF_DATE_TABLE();

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();
518: a12 := JTF_DATE_TABLE();
519: if t.count > 0 then
520: a0.extend(t.count);
521: a1.extend(t.count);

Line 518: a12 := JTF_DATE_TABLE();

514: a8 := JTF_VARCHAR2_TABLE_100();
515: a9 := JTF_VARCHAR2_TABLE_100();
516: a10 := JTF_DATE_TABLE();
517: a11 := JTF_DATE_TABLE();
518: a12 := JTF_DATE_TABLE();
519: if t.count > 0 then
520: a0.extend(t.count);
521: a1.extend(t.count);
522: a2.extend(t.count);

Line 560: , p0_a1 in out nocopy JTF_DATE_TABLE

556: end if;
557: end rosetta_table_copy_out_p8;
558:
559: procedure derive_visit_end_date(p0_a0 in out nocopy JTF_NUMBER_TABLE
560: , p0_a1 in out nocopy JTF_DATE_TABLE
561: , x_return_status out nocopy VARCHAR2
562: , x_msg_count out nocopy NUMBER
563: , x_msg_data out nocopy VARCHAR2
564: )

Line 857: , p6_a10 out nocopy JTF_DATE_TABLE

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
859: , p6_a12 out nocopy JTF_DATE_TABLE
860: , x_return_status out nocopy VARCHAR2
861: , x_msg_count out nocopy NUMBER

Line 858: , p6_a11 out nocopy JTF_DATE_TABLE

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
859: , p6_a12 out nocopy JTF_DATE_TABLE
860: , x_return_status out nocopy VARCHAR2
861: , x_msg_count out nocopy NUMBER
862: , x_msg_data out nocopy VARCHAR2

Line 859: , p6_a12 out nocopy JTF_DATE_TABLE

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
859: , p6_a12 out nocopy JTF_DATE_TABLE
860: , x_return_status out nocopy VARCHAR2
861: , x_msg_count out nocopy NUMBER
862: , x_msg_data out nocopy VARCHAR2
863: )