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 AHL_LTP_SPACE_SCHEDULE_PVT

Line 1: package body ahl_ltp_space_schedule_pvt_w as

1: package body ahl_ltp_space_schedule_pvt_w as
2: /* $Header: AHLWSPSB.pls 120.1 2006/05/04 07:59 anraj 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_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 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 382: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 JTF_NUMBER_TABLE

378: end if;
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

Line 403: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE

399: end loop;
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

Line 432: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE

428: end if;
429: end if;
430: end rosetta_table_copy_out_p7;
431:
432: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE
433: , a1 JTF_VARCHAR2_TABLE_100
434: , a2 JTF_VARCHAR2_TABLE_100
435: , a3 JTF_NUMBER_TABLE
436: , a4 JTF_VARCHAR2_TABLE_100

Line 475: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE

471: end loop;
472: end if;
473: end if;
474: end rosetta_table_copy_in_p8;
475: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
476: , a1 out nocopy JTF_VARCHAR2_TABLE_100
477: , a2 out nocopy JTF_VARCHAR2_TABLE_100
478: , a3 out nocopy JTF_NUMBER_TABLE
479: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 567: ddp_visits_end_date_tbl ahl_ltp_space_schedule_pvt.visits_end_date_tbl;

563: , x_msg_data out nocopy VARCHAR2
564: )
565:
566: as
567: ddp_visits_end_date_tbl ahl_ltp_space_schedule_pvt.visits_end_date_tbl;
568: ddindx binary_integer; indx binary_integer;
569: begin
570:
571: -- copy data to the local IN or IN-OUT args, if any

Line 572: ahl_ltp_space_schedule_pvt_w.rosetta_table_copy_in_p7(ddp_visits_end_date_tbl, p0_a0

568: ddindx binary_integer; indx binary_integer;
569: begin
570:
571: -- copy data to the local IN or IN-OUT args, if any
572: ahl_ltp_space_schedule_pvt_w.rosetta_table_copy_in_p7(ddp_visits_end_date_tbl, p0_a0
573: , p0_a1
574: );
575:
576:

Line 580: ahl_ltp_space_schedule_pvt.derive_visit_end_date(ddp_visits_end_date_tbl,

576:
577:
578:
579: -- here's the delegated call to the old PL/SQL routine
580: ahl_ltp_space_schedule_pvt.derive_visit_end_date(ddp_visits_end_date_tbl,
581: x_return_status,
582: x_msg_count,
583: x_msg_data);
584:

Line 586: ahl_ltp_space_schedule_pvt_w.rosetta_table_copy_out_p7(ddp_visits_end_date_tbl, p0_a0

582: x_msg_count,
583: x_msg_data);
584:
585: -- copy data back from the local variables to OUT or IN-OUT args, if any
586: ahl_ltp_space_schedule_pvt_w.rosetta_table_copy_out_p7(ddp_visits_end_date_tbl, p0_a0
587: , p0_a1
588: );
589:
590:

Line 691: ddp_search_visits_rec ahl_ltp_space_schedule_pvt.search_visits_rec_type;

687: , x_msg_data out nocopy VARCHAR2
688: )
689:
690: as
691: ddp_search_visits_rec ahl_ltp_space_schedule_pvt.search_visits_rec_type;
692: ddx_scheduled_visit_tbl ahl_ltp_space_schedule_pvt.scheduled_visits_tbl;
693: ddx_display_rec ahl_ltp_space_schedule_pvt.display_rec_type;
694: ddindx binary_integer; indx binary_integer;
695: begin

Line 692: ddx_scheduled_visit_tbl ahl_ltp_space_schedule_pvt.scheduled_visits_tbl;

688: )
689:
690: as
691: ddp_search_visits_rec ahl_ltp_space_schedule_pvt.search_visits_rec_type;
692: ddx_scheduled_visit_tbl ahl_ltp_space_schedule_pvt.scheduled_visits_tbl;
693: ddx_display_rec ahl_ltp_space_schedule_pvt.display_rec_type;
694: ddindx binary_integer; indx binary_integer;
695: begin
696:

Line 693: ddx_display_rec ahl_ltp_space_schedule_pvt.display_rec_type;

689:
690: as
691: ddp_search_visits_rec ahl_ltp_space_schedule_pvt.search_visits_rec_type;
692: ddx_scheduled_visit_tbl ahl_ltp_space_schedule_pvt.scheduled_visits_tbl;
693: ddx_display_rec ahl_ltp_space_schedule_pvt.display_rec_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 730: ahl_ltp_space_schedule_pvt.search_scheduled_visits(p_api_version,

726:
727:
728:
729: -- here's the delegated call to the old PL/SQL routine
730: ahl_ltp_space_schedule_pvt.search_scheduled_visits(p_api_version,
731: p_init_msg_list,
732: p_commit,
733: p_validation_level,
734: p_module_type,

Line 749: ahl_ltp_space_schedule_pvt_w.rosetta_table_copy_out_p6(ddx_scheduled_visit_tbl, p6_a0

745:
746:
747:
748:
749: ahl_ltp_space_schedule_pvt_w.rosetta_table_copy_out_p6(ddx_scheduled_visit_tbl, p6_a0
750: , p6_a1
751: , p6_a2
752: , p6_a3
753: , p6_a4

Line 866: ddp_search_visits_rec ahl_ltp_space_schedule_pvt.search_visits_rec_type;

862: , x_msg_data out nocopy VARCHAR2
863: )
864:
865: as
866: ddp_search_visits_rec ahl_ltp_space_schedule_pvt.search_visits_rec_type;
867: ddx_visit_details_tbl ahl_ltp_space_schedule_pvt.visit_details_tbl;
868: ddindx binary_integer; indx binary_integer;
869: begin
870:

Line 867: ddx_visit_details_tbl ahl_ltp_space_schedule_pvt.visit_details_tbl;

863: )
864:
865: as
866: ddp_search_visits_rec ahl_ltp_space_schedule_pvt.search_visits_rec_type;
867: ddx_visit_details_tbl ahl_ltp_space_schedule_pvt.visit_details_tbl;
868: ddindx binary_integer; indx binary_integer;
869: begin
870:
871: -- copy data to the local IN or IN-OUT args, if any

Line 903: ahl_ltp_space_schedule_pvt.get_visit_details(p_api_version,

899:
900:
901:
902: -- here's the delegated call to the old PL/SQL routine
903: ahl_ltp_space_schedule_pvt.get_visit_details(p_api_version,
904: p_init_msg_list,
905: p_commit,
906: p_validation_level,
907: p_module_type,

Line 921: ahl_ltp_space_schedule_pvt_w.rosetta_table_copy_out_p8(ddx_visit_details_tbl, p6_a0

917:
918:
919:
920:
921: ahl_ltp_space_schedule_pvt_w.rosetta_table_copy_out_p8(ddx_visit_details_tbl, p6_a0
922: , p6_a1
923: , p6_a2
924: , p6_a3
925: , p6_a4

Line 940: end ahl_ltp_space_schedule_pvt_w;

936:
937:
938: end;
939:
940: end ahl_ltp_space_schedule_pvt_w;