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_COMPLETIONS_PVT_W dependencies on AHL_COMPLETIONS_PVT

Line 1: package body ahl_completions_pvt_w as

1: package body ahl_completions_pvt_w as
2: /* $Header: AHLWPRCB.pls 120.1 2005/07/04 10:48 rroy noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_completions_pvt_w as
2: /* $Header: AHLWPRCB.pls 120.1 2005/07/04 10:48 rroy noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 68: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

64: end loop;
65: end if;
66: end if;
67: end rosetta_table_copy_in_p1;
68: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE

Line 207: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE

203: end if;
204: end if;
205: end rosetta_table_copy_out_p1;
206:
207: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
208: , a1 JTF_NUMBER_TABLE
209: , a2 JTF_NUMBER_TABLE
210: , a3 JTF_VARCHAR2_TABLE_100
211: , a4 JTF_NUMBER_TABLE

Line 256: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

252: end loop;
253: end if;
254: end if;
255: end rosetta_table_copy_in_p3;
256: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
257: , a1 out nocopy JTF_NUMBER_TABLE
258: , a2 out nocopy JTF_NUMBER_TABLE
259: , a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , a4 out nocopy JTF_NUMBER_TABLE

Line 355: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE

351: end if;
352: end if;
353: end rosetta_table_copy_out_p3;
354:
355: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
356: , a1 JTF_NUMBER_TABLE
357: , a2 JTF_VARCHAR2_TABLE_100
358: , a3 JTF_VARCHAR2_TABLE_100
359: , a4 JTF_NUMBER_TABLE

Line 396: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

392: end loop;
393: end if;
394: end if;
395: end rosetta_table_copy_in_p7;
396: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
397: , a1 out nocopy JTF_NUMBER_TABLE
398: , a2 out nocopy JTF_VARCHAR2_TABLE_100
399: , a3 out nocopy JTF_VARCHAR2_TABLE_100
400: , a4 out nocopy JTF_NUMBER_TABLE

Line 475: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE

471: end if;
472: end if;
473: end rosetta_table_copy_out_p7;
474:
475: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
476: , a1 JTF_NUMBER_TABLE
477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_NUMBER_TABLE

Line 508: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

504: end loop;
505: end if;
506: end if;
507: end rosetta_table_copy_in_p9;
508: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_NUMBER_TABLE
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE

Line 567: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE) as

563: end if;
564: end if;
565: end rosetta_table_copy_out_p9;
566:
567: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE) as
568: ddindx binary_integer; indx binary_integer;
569: begin
570: if a0 is not null and a0.count > 0 then
571: if a0.count > 0 then

Line 585: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

581: end loop;
582: end if;
583: end if;
584: end rosetta_table_copy_in_p10;
585: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
586: ddindx binary_integer; indx binary_integer;
587: begin
588: if t is null or t.count = 0 then
589: a0 := JTF_NUMBER_TABLE();

Line 608: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE

604: end if;
605: end if;
606: end rosetta_table_copy_out_p10;
607:
608: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
609: , a1 JTF_VARCHAR2_TABLE_100
610: , a2 JTF_NUMBER_TABLE
611: , a3 JTF_NUMBER_TABLE
612: , a4 JTF_NUMBER_TABLE

Line 647: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

643: end loop;
644: end if;
645: end if;
646: end rosetta_table_copy_in_p18;
647: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
648: , a1 out nocopy JTF_VARCHAR2_TABLE_100
649: , a2 out nocopy JTF_NUMBER_TABLE
650: , a3 out nocopy JTF_NUMBER_TABLE
651: , a4 out nocopy JTF_NUMBER_TABLE

Line 745: ddp_x_mr_rec ahl_completions_pvt.mr_rec_type;

741: , p9_a11 in out nocopy DATE
742: )
743:
744: as
745: ddp_x_mr_rec ahl_completions_pvt.mr_rec_type;
746: ddindx binary_integer; indx binary_integer;
747: begin
748:
749: -- copy data to the local IN or IN-OUT args, if any

Line 773: ahl_completions_pvt.complete_mr_instance(p_api_version,

769: ddp_x_mr_rec.item_instance_id := p9_a10;
770: ddp_x_mr_rec.actual_end_date := p9_a11;
771:
772: -- here's the delegated call to the old PL/SQL routine
773: ahl_completions_pvt.complete_mr_instance(p_api_version,
774: p_init_msg_list,
775: p_commit,
776: p_validation_level,
777: p_default,

Line 830: ddp_signoff_mr_rec ahl_completions_pvt.signoff_mr_rec_type;

826: , p9_a9 VARCHAR2
827: )
828:
829: as
830: ddp_signoff_mr_rec ahl_completions_pvt.signoff_mr_rec_type;
831: ddindx binary_integer; indx binary_integer;
832: begin
833:
834: -- copy data to the local IN or IN-OUT args, if any

Line 856: ahl_completions_pvt.signoff_mr_instance(p_api_version,

852: ddp_signoff_mr_rec.employee_number := p9_a8;
853: ddp_signoff_mr_rec.serial_number := p9_a9;
854:
855: -- here's the delegated call to the old PL/SQL routine
856: ahl_completions_pvt.signoff_mr_instance(p_api_version,
857: p_init_msg_list,
858: p_commit,
859: p_validation_level,
860: p_default,

Line 901: ddp_close_visit_rec ahl_completions_pvt.close_visit_rec_type;

897: , p9_a9 VARCHAR2
898: )
899:
900: as
901: ddp_close_visit_rec ahl_completions_pvt.close_visit_rec_type;
902: ddindx binary_integer; indx binary_integer;
903: begin
904:
905: -- copy data to the local IN or IN-OUT args, if any

Line 927: ahl_completions_pvt.close_visit(p_api_version,

923: ddp_close_visit_rec.employee_number := p9_a8;
924: ddp_close_visit_rec.serial_number := p9_a9;
925:
926: -- here's the delegated call to the old PL/SQL routine
927: ahl_completions_pvt.close_visit(p_api_version,
928: p_init_msg_list,
929: p_commit,
930: p_validation_level,
931: p_default,

Line 972: ddp_x_operation_tbl ahl_completions_pvt.operation_tbl_type;

968: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
969: )
970:
971: as
972: ddp_x_operation_tbl ahl_completions_pvt.operation_tbl_type;
973: ddindx binary_integer; indx binary_integer;
974: begin
975:
976: -- copy data to the local IN or IN-OUT args, if any

Line 980: ahl_completions_pvt_w.rosetta_table_copy_in_p3(ddp_x_operation_tbl, p3_a0

976: -- copy data to the local IN or IN-OUT args, if any
977:
978:
979:
980: ahl_completions_pvt_w.rosetta_table_copy_in_p3(ddp_x_operation_tbl, p3_a0
981: , p3_a1
982: , p3_a2
983: , p3_a3
984: , p3_a4

Line 999: ahl_completions_pvt.get_default_op_actual_dates(x_return_status,

995: , p3_a15
996: );
997:
998: -- here's the delegated call to the old PL/SQL routine
999: ahl_completions_pvt.get_default_op_actual_dates(x_return_status,
1000: x_msg_count,
1001: x_msg_data,
1002: ddp_x_operation_tbl);
1003:

Line 1008: ahl_completions_pvt_w.rosetta_table_copy_out_p3(ddp_x_operation_tbl, p3_a0

1004: -- copy data back from the local variables to OUT or IN-OUT args, if any
1005:
1006:
1007:
1008: ahl_completions_pvt_w.rosetta_table_copy_out_p3(ddp_x_operation_tbl, p3_a0
1009: , p3_a1
1010: , p3_a2
1011: , p3_a3
1012: , p3_a4

Line 1047: ddp_x_operation_tbl ahl_completions_pvt.operation_tbl_type;

1043: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1044: )
1045:
1046: as
1047: ddp_x_operation_tbl ahl_completions_pvt.operation_tbl_type;
1048: ddindx binary_integer; indx binary_integer;
1049: begin
1050:
1051: -- copy data to the local IN or IN-OUT args, if any

Line 1053: ahl_completions_pvt_w.rosetta_table_copy_in_p3(ddp_x_operation_tbl, p1_a0

1049: begin
1050:
1051: -- copy data to the local IN or IN-OUT args, if any
1052:
1053: ahl_completions_pvt_w.rosetta_table_copy_in_p3(ddp_x_operation_tbl, p1_a0
1054: , p1_a1
1055: , p1_a2
1056: , p1_a3
1057: , p1_a4

Line 1072: ahl_completions_pvt.get_op_actual_dates(x_return_status,

1068: , p1_a15
1069: );
1070:
1071: -- here's the delegated call to the old PL/SQL routine
1072: ahl_completions_pvt.get_op_actual_dates(x_return_status,
1073: ddp_x_operation_tbl);
1074:
1075: -- copy data back from the local variables to OUT or IN-OUT args, if any
1076:

Line 1077: ahl_completions_pvt_w.rosetta_table_copy_out_p3(ddp_x_operation_tbl, p1_a0

1073: ddp_x_operation_tbl);
1074:
1075: -- copy data back from the local variables to OUT or IN-OUT args, if any
1076:
1077: ahl_completions_pvt_w.rosetta_table_copy_out_p3(ddp_x_operation_tbl, p1_a0
1078: , p1_a1
1079: , p1_a2
1080: , p1_a3
1081: , p1_a4

Line 1096: end ahl_completions_pvt_w;

1092: , p1_a15
1093: );
1094: end;
1095:
1096: end ahl_completions_pvt_w;