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.JTF_CALENDAR_PUB_W dependencies on JTF_CALENDAR_PUB

Line 1: package body jtf_calendar_pub_w as

1: package body jtf_calendar_pub_w as
2: /* $Header: jtfclawb.pls 120.2 2005/12/30 03:06 abraina ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy jtf_calendar_pub.shift_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 jtf_calendar_pub.shift_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_DATE_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100

Line 40: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_DATE_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 84: procedure rosetta_table_copy_in_p3(t out nocopy jtf_calendar_pub.shift_tbl_attributes_type, a0 JTF_NUMBER_TABLE

80: end if;
81: end if;
82: end rosetta_table_copy_out_p1;
83:
84: procedure rosetta_table_copy_in_p3(t out nocopy jtf_calendar_pub.shift_tbl_attributes_type, a0 JTF_NUMBER_TABLE
85: , a1 JTF_DATE_TABLE
86: , a2 JTF_VARCHAR2_TABLE_100
87: , a3 JTF_VARCHAR2_TABLE_100
88: , a4 JTF_VARCHAR2_TABLE_100

Line 141: procedure rosetta_table_copy_out_p3(t jtf_calendar_pub.shift_tbl_attributes_type, a0 out nocopy JTF_NUMBER_TABLE

137: end loop;
138: end if;
139: end if;
140: end rosetta_table_copy_in_p3;
141: procedure rosetta_table_copy_out_p3(t jtf_calendar_pub.shift_tbl_attributes_type, a0 out nocopy JTF_NUMBER_TABLE
142: , a1 out nocopy JTF_DATE_TABLE
143: , a2 out nocopy JTF_VARCHAR2_TABLE_100
144: , a3 out nocopy JTF_VARCHAR2_TABLE_100
145: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 290: jtf_calendar_pub.is_res_available(p_api_version,

286:
287:
288:
289: -- here's the delegated call to the old PL/SQL routine
290: jtf_calendar_pub.is_res_available(p_api_version,
291: p_init_msg_list,
292: p_resource_id,
293: p_resource_type,
294: ddp_start_date_time,

Line 332: ddx_shift jtf_calendar_pub.shift_tbl_type;

328:
329: as
330: ddp_start_date date;
331: ddp_end_date date;
332: ddx_shift jtf_calendar_pub.shift_tbl_type;
333: ddindx binary_integer; indx binary_integer;
334: begin
335:
336: -- copy data to the local IN or IN-OUT args, if any

Line 350: jtf_calendar_pub.get_available_time(p_api_version,

346:
347:
348:
349: -- here's the delegated call to the old PL/SQL routine
350: jtf_calendar_pub.get_available_time(p_api_version,
351: p_init_msg_list,
352: p_resource_id,
353: p_resource_type,
354: ddp_start_date,

Line 371: jtf_calendar_pub_w.rosetta_table_copy_out_p1(ddx_shift, p9_a0

367:
368:
369:
370:
371: jtf_calendar_pub_w.rosetta_table_copy_out_p1(ddx_shift, p9_a0
372: , p9_a1
373: , p9_a2
374: , p9_a3
375: , p9_a4

Line 419: jtf_calendar_pub.get_available_slot(p_api_version,

415:
416:
417:
418: -- here's the delegated call to the old PL/SQL routine
419: jtf_calendar_pub.get_available_slot(p_api_version,
420: p_init_msg_list,
421: p_resource_id,
422: p_resource_type,
423: ddp_start_date_time,

Line 469: ddx_shift jtf_calendar_pub.shift_tbl_type;

465:
466: as
467: ddp_start_date date;
468: ddp_end_date date;
469: ddx_shift jtf_calendar_pub.shift_tbl_type;
470: ddindx binary_integer; indx binary_integer;
471: begin
472:
473: -- copy data to the local IN or IN-OUT args, if any

Line 487: jtf_calendar_pub.get_resource_shifts(p_api_version,

483:
484:
485:
486: -- here's the delegated call to the old PL/SQL routine
487: jtf_calendar_pub.get_resource_shifts(p_api_version,
488: p_init_msg_list,
489: p_resource_id,
490: p_resource_type,
491: ddp_start_date,

Line 508: jtf_calendar_pub_w.rosetta_table_copy_out_p1(ddx_shift, p9_a0

504:
505:
506:
507:
508: jtf_calendar_pub_w.rosetta_table_copy_out_p1(ddx_shift, p9_a0
509: , p9_a1
510: , p9_a2
511: , p9_a3
512: , p9_a4

Line 550: ddx_shift jtf_calendar_pub.shift_tbl_attributes_type;

546:
547: as
548: ddp_start_date date;
549: ddp_end_date date;
550: ddx_shift jtf_calendar_pub.shift_tbl_attributes_type;
551: ddindx binary_integer; indx binary_integer;
552: begin
553:
554: -- copy data to the local IN or IN-OUT args, if any

Line 568: jtf_calendar_pub.get_resource_shifts(p_api_version,

564:
565:
566:
567: -- here's the delegated call to the old PL/SQL routine
568: jtf_calendar_pub.get_resource_shifts(p_api_version,
569: p_init_msg_list,
570: p_resource_id,
571: p_resource_type,
572: ddp_start_date,

Line 589: jtf_calendar_pub_w.rosetta_table_copy_out_p3(ddx_shift, p9_a0

585:
586:
587:
588:
589: jtf_calendar_pub_w.rosetta_table_copy_out_p3(ddx_shift, p9_a0
590: , p9_a1
591: , p9_a2
592: , p9_a3
593: , p9_a4

Line 631: ddx_shift jtf_calendar_pub.shift_tbl_type;

627:
628: as
629: ddp_start_date date;
630: ddp_end_date date;
631: ddx_shift jtf_calendar_pub.shift_tbl_type;
632: ddindx binary_integer; indx binary_integer;
633: begin
634:
635: -- copy data to the local IN or IN-OUT args, if any

Line 649: jtf_calendar_pub.get_res_schedule(p_api_version,

645:
646:
647:
648: -- here's the delegated call to the old PL/SQL routine
649: jtf_calendar_pub.get_res_schedule(p_api_version,
650: p_init_msg_list,
651: p_resource_id,
652: p_resource_type,
653: ddp_start_date,

Line 670: jtf_calendar_pub_w.rosetta_table_copy_out_p1(ddx_shift, p9_a0

666:
667:
668:
669:
670: jtf_calendar_pub_w.rosetta_table_copy_out_p1(ddx_shift, p9_a0
671: , p9_a1
672: , p9_a2
673: , p9_a3
674: , p9_a4

Line 695: ddrosetta_retval := jtf_calendar_pub.resourcedt_to_serverdt(ddp_resource_dttime,

691:
692:
693:
694: -- here's the delegated call to the old PL/SQL routine
695: ddrosetta_retval := jtf_calendar_pub.resourcedt_to_serverdt(ddp_resource_dttime,
696: p_resource_tz_id,
697: p_server_tz_id);
698:
699: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 722: ddrosetta_retval := jtf_calendar_pub.validate_cal_date(p_calendar_id,

718:
719: ddp_shift_date := rosetta_g_miss_date_in_map(p_shift_date);
720:
721: -- here's the delegated call to the old PL/SQL routine
722: ddrosetta_retval := jtf_calendar_pub.validate_cal_date(p_calendar_id,
723: ddp_shift_date);
724:
725: -- copy data back from the local variables to OUT or IN-OUT args, if any
726: if ddrosetta_retval is null

Line 735: end jtf_calendar_pub_w;

731: end if;
732:
733: end;
734:
735: end jtf_calendar_pub_w;