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_UA_UNIT_SCHEDULES_PVT_W dependencies on AHL_UA_UNIT_SCHEDULES_PVT

Line 1: package body ahl_ua_unit_schedules_pvt_w as

1: package body ahl_ua_unit_schedules_pvt_w as
2: /* $Header: AHLWUUSB.pls 120.1 2006/05/02 04:36 amsriniv noship $ */
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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 JTF_NUMBER_TABLE

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_p3(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 45: procedure rosetta_table_copy_out_p3(t ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

41: end loop;
42: end if;
43: end if;
44: end rosetta_table_copy_in_p3;
45: procedure rosetta_table_copy_out_p3(t ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE
47: , a2 out nocopy JTF_NUMBER_TABLE
48: , a3 out nocopy JTF_VARCHAR2_TABLE_100
49: , a4 out nocopy JTF_NUMBER_TABLE

Line 94: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 JTF_NUMBER_TABLE

90: end if;
91: end if;
92: end rosetta_table_copy_out_p3;
93:
94: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
95: , a1 JTF_NUMBER_TABLE
96: , a2 JTF_VARCHAR2_TABLE_100
97: , a3 JTF_VARCHAR2_TABLE_100
98: , a4 JTF_NUMBER_TABLE

Line 167: procedure rosetta_table_copy_out_p6(t ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

163: end loop;
164: end if;
165: end if;
166: end rosetta_table_copy_in_p6;
167: procedure rosetta_table_copy_out_p6(t ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
168: , a1 out nocopy JTF_NUMBER_TABLE
169: , a2 out nocopy JTF_VARCHAR2_TABLE_100
170: , a3 out nocopy JTF_VARCHAR2_TABLE_100
171: , a4 out nocopy JTF_NUMBER_TABLE

Line 326: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 JTF_NUMBER_TABLE

322: end if;
323: end if;
324: end rosetta_table_copy_out_p6;
325:
326: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
327: , a1 JTF_NUMBER_TABLE
328: , a2 JTF_VARCHAR2_TABLE_100
329: , a3 JTF_VARCHAR2_TABLE_100
330: , a4 JTF_VARCHAR2_TABLE_100

Line 399: procedure rosetta_table_copy_out_p8(t ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

395: end loop;
396: end if;
397: end if;
398: end rosetta_table_copy_in_p8;
399: procedure rosetta_table_copy_out_p8(t ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
400: , a1 out nocopy JTF_NUMBER_TABLE
401: , a2 out nocopy JTF_VARCHAR2_TABLE_100
402: , a3 out nocopy JTF_VARCHAR2_TABLE_100
403: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 577: ddp_unit_schedules_search ahl_ua_unit_schedules_pvt.unit_schedules_search_rec_type;

573: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
574: )
575:
576: as
577: ddp_unit_schedules_search ahl_ua_unit_schedules_pvt.unit_schedules_search_rec_type;
578: ddx_unit_schedules_results ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type;
579: ddindx binary_integer; indx binary_integer;
580: begin
581:

Line 578: ddx_unit_schedules_results ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type;

574: )
575:
576: as
577: ddp_unit_schedules_search ahl_ua_unit_schedules_pvt.unit_schedules_search_rec_type;
578: ddx_unit_schedules_results ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type;
579: ddindx binary_integer; indx binary_integer;
580: begin
581:
582: -- copy data to the local IN or IN-OUT args, if any

Line 596: ahl_ua_unit_schedules_pvt.search_unit_schedules(p_api_version,

592: ddp_unit_schedules_search.time_uom := p4_a5;
593:
594:
595: -- here's the delegated call to the old PL/SQL routine
596: ahl_ua_unit_schedules_pvt.search_unit_schedules(p_api_version,
597: x_return_status,
598: x_msg_count,
599: x_msg_data,
600: ddp_unit_schedules_search,

Line 609: ahl_ua_unit_schedules_pvt_w.rosetta_table_copy_out_p3(ddx_unit_schedules_results, p5_a0

605:
606:
607:
608:
609: ahl_ua_unit_schedules_pvt_w.rosetta_table_copy_out_p3(ddx_unit_schedules_results, p5_a0
610: , p5_a1
611: , p5_a2
612: , p5_a3
613: , p5_a4

Line 691: ddp_x_mevent_header_rec ahl_ua_unit_schedules_pvt.mevent_header_rec_type;

687: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
688: )
689:
690: as
691: ddp_x_mevent_header_rec ahl_ua_unit_schedules_pvt.mevent_header_rec_type;
692: ddx_unit_schedule_tbl ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type;
693: ddx_visit_schedule_tbl ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type;
694: ddindx binary_integer; indx binary_integer;
695: begin

Line 692: ddx_unit_schedule_tbl ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type;

688: )
689:
690: as
691: ddp_x_mevent_header_rec ahl_ua_unit_schedules_pvt.mevent_header_rec_type;
692: ddx_unit_schedule_tbl ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type;
693: ddx_visit_schedule_tbl ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type;
694: ddindx binary_integer; indx binary_integer;
695: begin
696:

Line 693: ddx_visit_schedule_tbl ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type;

689:
690: as
691: ddp_x_mevent_header_rec ahl_ua_unit_schedules_pvt.mevent_header_rec_type;
692: ddx_unit_schedule_tbl ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type;
693: ddx_visit_schedule_tbl ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type;
694: ddindx binary_integer; indx binary_integer;
695: begin
696:
697: -- copy data to the local IN or IN-OUT args, if any

Line 716: ahl_ua_unit_schedules_pvt.get_mevent_details(p_api_version,

712:
713:
714:
715: -- here's the delegated call to the old PL/SQL routine
716: ahl_ua_unit_schedules_pvt.get_mevent_details(p_api_version,
717: p_module_type,
718: x_return_status,
719: x_msg_count,
720: x_msg_data,

Line 741: ahl_ua_unit_schedules_pvt_w.rosetta_table_copy_out_p6(ddx_unit_schedule_tbl, p6_a0

737: p5_a6 := ddp_x_mevent_header_rec.event_count;
738: p5_a7 := ddp_x_mevent_header_rec.has_conflict;
739: p5_a8 := ddp_x_mevent_header_rec.has_mopportunity;
740:
741: ahl_ua_unit_schedules_pvt_w.rosetta_table_copy_out_p6(ddx_unit_schedule_tbl, p6_a0
742: , p6_a1
743: , p6_a2
744: , p6_a3
745: , p6_a4

Line 771: ahl_ua_unit_schedules_pvt_w.rosetta_table_copy_out_p8(ddx_visit_schedule_tbl, p7_a0

767: , p6_a26
768: , p6_a27
769: );
770:
771: ahl_ua_unit_schedules_pvt_w.rosetta_table_copy_out_p8(ddx_visit_schedule_tbl, p7_a0
772: , p7_a1
773: , p7_a2
774: , p7_a3
775: , p7_a4

Line 1084: ahl_ua_unit_schedules_pvt.get_prec_succ_event_info(p_api_version,

1080:
1081:
1082:
1083: -- here's the delegated call to the old PL/SQL routine
1084: ahl_ua_unit_schedules_pvt.get_prec_succ_event_info(p_api_version,
1085: x_return_status,
1086: x_msg_count,
1087: x_msg_data,
1088: p_unit_config_id,

Line 1357: end ahl_ua_unit_schedules_pvt_w;

1353:
1354:
1355: end;
1356:
1357: end ahl_ua_unit_schedules_pvt_w;