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_FMP_PVT_W dependencies on AHL_FMP_PVT

Line 1: package body ahl_fmp_pvt_w as

1: package body ahl_fmp_pvt_w as
2: /* $Header: AHLWFMPB.pls 120.0.12000000.3 2007/10/19 23:29:21 sracha 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100

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_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_4000
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_400

Line 55: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

51: end loop;
52: end if;
53: end if;
54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 129: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE

125: end if;
126: end if;
127: end rosetta_table_copy_out_p1;
128:
129: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
130: , a1 JTF_NUMBER_TABLE
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100

Line 164: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

160: end loop;
161: end if;
162: end if;
163: end rosetta_table_copy_in_p3;
164: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE

224: end if;
225: end if;
226: end rosetta_table_copy_out_p3;
227:
228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
229: , a1 JTF_NUMBER_TABLE
230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE

Line 265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

261: end loop;
262: end if;
263: end if;
264: end rosetta_table_copy_in_p5;
265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
266: , a1 out nocopy JTF_NUMBER_TABLE
267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE

Line 334: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE

330: end if;
331: end if;
332: end rosetta_table_copy_out_p5;
333:
334: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_VARCHAR2_TABLE_200
336: , a2 JTF_VARCHAR2_TABLE_200
337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_NUMBER_TABLE

Line 401: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

397: end loop;
398: end if;
399: end if;
400: end rosetta_table_copy_in_p7;
401: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
402: , a1 out nocopy JTF_VARCHAR2_TABLE_200
403: , a2 out nocopy JTF_VARCHAR2_TABLE_200
404: , a3 out nocopy JTF_VARCHAR2_TABLE_100
405: , a4 out nocopy JTF_NUMBER_TABLE

Line 571: ddx_mr_item_inst_tbl ahl_fmp_pvt.mr_item_instance_tbl_type;

567: , p12_a10 out nocopy JTF_NUMBER_TABLE
568: )
569:
570: as
571: ddx_mr_item_inst_tbl ahl_fmp_pvt.mr_item_instance_tbl_type;
572: ddindx binary_integer; indx binary_integer;
573: begin
574:
575: -- copy data to the local IN or IN-OUT args, if any

Line 590: ahl_fmp_pvt.get_mr_affected_items(p_api_version,

586:
587:
588:
589: -- here's the delegated call to the old PL/SQL routine
590: ahl_fmp_pvt.get_mr_affected_items(p_api_version,
591: p_init_msg_list,
592: p_commit,
593: p_validation_level,
594: x_return_status,

Line 617: ahl_fmp_pvt_w.rosetta_table_copy_out_p1(ddx_mr_item_inst_tbl, p12_a0

613:
614:
615:
616:
617: ahl_fmp_pvt_w.rosetta_table_copy_out_p1(ddx_mr_item_inst_tbl, p12_a0
618: , p12_a1
619: , p12_a2
620: , p12_a3
621: , p12_a4

Line 655: ddx_applicable_mr_tbl ahl_fmp_pvt.applicable_mr_tbl_type;

651: , p12_a8 out nocopy JTF_NUMBER_TABLE
652: )
653:
654: as
655: ddx_applicable_mr_tbl ahl_fmp_pvt.applicable_mr_tbl_type;
656: ddindx binary_integer; indx binary_integer;
657: begin
658:
659: -- copy data to the local IN or IN-OUT args, if any

Line 674: ahl_fmp_pvt.get_applicable_mrs(p_api_version,

670:
671:
672:
673: -- here's the delegated call to the old PL/SQL routine
674: ahl_fmp_pvt.get_applicable_mrs(p_api_version,
675: p_init_msg_list,
676: p_commit,
677: p_validation_level,
678: x_return_status,

Line 701: ahl_fmp_pvt_w.rosetta_table_copy_out_p3(ddx_applicable_mr_tbl, p12_a0

697:
698:
699:
700:
701: ahl_fmp_pvt_w.rosetta_table_copy_out_p3(ddx_applicable_mr_tbl, p12_a0
702: , p12_a1
703: , p12_a2
704: , p12_a3
705: , p12_a4

Line 759: ddx_applicable_activities_tbl ahl_fmp_pvt.applicable_activities_tbl_type;

755: , p9_a24 out nocopy JTF_NUMBER_TABLE
756: )
757:
758: as
759: ddx_applicable_activities_tbl ahl_fmp_pvt.applicable_activities_tbl_type;
760: ddx_applicable_programs_tbl ahl_fmp_pvt.applicable_programs_tbl_type;
761: ddindx binary_integer; indx binary_integer;
762: begin
763:

Line 760: ddx_applicable_programs_tbl ahl_fmp_pvt.applicable_programs_tbl_type;

756: )
757:
758: as
759: ddx_applicable_activities_tbl ahl_fmp_pvt.applicable_activities_tbl_type;
760: ddx_applicable_programs_tbl ahl_fmp_pvt.applicable_programs_tbl_type;
761: ddindx binary_integer; indx binary_integer;
762: begin
763:
764: -- copy data to the local IN or IN-OUT args, if any

Line 776: ahl_fmp_pvt.get_pm_applicable_mrs(p_api_version,

772:
773:
774:
775: -- here's the delegated call to the old PL/SQL routine
776: ahl_fmp_pvt.get_pm_applicable_mrs(p_api_version,
777: p_init_msg_list,
778: p_commit,
779: p_validation_level,
780: x_return_status,

Line 796: ahl_fmp_pvt_w.rosetta_table_copy_out_p5(ddx_applicable_activities_tbl, p8_a0

792:
793:
794:
795:
796: ahl_fmp_pvt_w.rosetta_table_copy_out_p5(ddx_applicable_activities_tbl, p8_a0
797: , p8_a1
798: , p8_a2
799: , p8_a3
800: , p8_a4

Line 808: ahl_fmp_pvt_w.rosetta_table_copy_out_p7(ddx_applicable_programs_tbl, p9_a0

804: , p8_a8
805: , p8_a9
806: );
807:
808: ahl_fmp_pvt_w.rosetta_table_copy_out_p7(ddx_applicable_programs_tbl, p9_a0
809: , p9_a1
810: , p9_a2
811: , p9_a3
812: , p9_a4

Line 836: end ahl_fmp_pvt_w;

832: , p9_a24
833: );
834: end;
835:
836: end ahl_fmp_pvt_w;