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.2.12020000.3 2013/04/01 02:21:08 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 57: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

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

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

132: end if;
133: end if;
134: end rosetta_table_copy_out_p1;
135:
136: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
137: , a1 JTF_NUMBER_TABLE
138: , a2 JTF_NUMBER_TABLE
139: , a3 JTF_VARCHAR2_TABLE_100
140: , a4 JTF_VARCHAR2_TABLE_100

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

173: end loop;
174: end if;
175: end if;
176: end rosetta_table_copy_in_p3;
177: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_NUMBER_TABLE
179: , a2 out nocopy JTF_NUMBER_TABLE
180: , a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

252: end if;
253: end if;
254: end rosetta_table_copy_out_p3;
255:
256: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
257: , a1 JTF_NUMBER_TABLE
258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_NUMBER_TABLE
260: , a4 JTF_NUMBER_TABLE

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

289: end loop;
290: end if;
291: end if;
292: end rosetta_table_copy_in_p5;
293: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE

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

358: end if;
359: end if;
360: end rosetta_table_copy_out_p5;
361:
362: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
363: , a1 JTF_VARCHAR2_TABLE_200
364: , a2 JTF_VARCHAR2_TABLE_200
365: , a3 JTF_VARCHAR2_TABLE_100
366: , a4 JTF_NUMBER_TABLE

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

425: end loop;
426: end if;
427: end if;
428: end rosetta_table_copy_in_p7;
429: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_VARCHAR2_TABLE_200
431: , a2 out nocopy JTF_VARCHAR2_TABLE_200
432: , a3 out nocopy JTF_VARCHAR2_TABLE_100
433: , a4 out nocopy JTF_NUMBER_TABLE

Line 603: ddx_mr_item_inst_tbl ahl_fmp_pvt.mr_item_instance_tbl_type;

599: )
600:
601: as
602: ddp_flt_range_calc_date date;
603: ddx_mr_item_inst_tbl ahl_fmp_pvt.mr_item_instance_tbl_type;
604: ddindx binary_integer; indx binary_integer;
605: begin
606:
607: -- copy data to the local IN or IN-OUT args, if any

Line 625: ahl_fmp_pvt.get_mr_affected_items(p_api_version,

621: ddp_flt_range_calc_date := rosetta_g_miss_date_in_map(p_flt_range_calc_date);
622:
623:
624: -- here's the delegated call to the old PL/SQL routine
625: ahl_fmp_pvt.get_mr_affected_items(p_api_version,
626: p_init_msg_list,
627: p_commit,
628: p_validation_level,
629: x_return_status,

Line 656: ahl_fmp_pvt_w.rosetta_table_copy_out_p1(ddx_mr_item_inst_tbl, p14_a0

652:
653:
654:
655:
656: ahl_fmp_pvt_w.rosetta_table_copy_out_p1(ddx_mr_item_inst_tbl, p14_a0
657: , p14_a1
658: , p14_a2
659: , p14_a3
660: , p14_a4

Line 702: ddx_applicable_mr_tbl ahl_fmp_pvt.applicable_mr_tbl_type;

698: )
699:
700: as
701: ddp_flt_range_calc_date date;
702: ddx_applicable_mr_tbl ahl_fmp_pvt.applicable_mr_tbl_type;
703: ddindx binary_integer; indx binary_integer;
704: begin
705:
706: -- copy data to the local IN or IN-OUT args, if any

Line 725: ahl_fmp_pvt.get_applicable_mrs(p_api_version,

721:
722:
723:
724: -- here's the delegated call to the old PL/SQL routine
725: ahl_fmp_pvt.get_applicable_mrs(p_api_version,
726: p_init_msg_list,
727: p_commit,
728: p_validation_level,
729: x_return_status,

Line 758: ahl_fmp_pvt_w.rosetta_table_copy_out_p3(ddx_applicable_mr_tbl, p15_a0

754:
755:
756:
757:
758: ahl_fmp_pvt_w.rosetta_table_copy_out_p3(ddx_applicable_mr_tbl, p15_a0
759: , p15_a1
760: , p15_a2
761: , p15_a3
762: , p15_a4

Line 819: ddx_applicable_activities_tbl ahl_fmp_pvt.applicable_activities_tbl_type;

815: , p9_a24 out nocopy JTF_NUMBER_TABLE
816: )
817:
818: as
819: ddx_applicable_activities_tbl ahl_fmp_pvt.applicable_activities_tbl_type;
820: ddx_applicable_programs_tbl ahl_fmp_pvt.applicable_programs_tbl_type;
821: ddindx binary_integer; indx binary_integer;
822: begin
823:

Line 820: ddx_applicable_programs_tbl ahl_fmp_pvt.applicable_programs_tbl_type;

816: )
817:
818: as
819: ddx_applicable_activities_tbl ahl_fmp_pvt.applicable_activities_tbl_type;
820: ddx_applicable_programs_tbl ahl_fmp_pvt.applicable_programs_tbl_type;
821: ddindx binary_integer; indx binary_integer;
822: begin
823:
824: -- copy data to the local IN or IN-OUT args, if any

Line 836: ahl_fmp_pvt.get_pm_applicable_mrs(p_api_version,

832:
833:
834:
835: -- here's the delegated call to the old PL/SQL routine
836: ahl_fmp_pvt.get_pm_applicable_mrs(p_api_version,
837: p_init_msg_list,
838: p_commit,
839: p_validation_level,
840: x_return_status,

Line 856: ahl_fmp_pvt_w.rosetta_table_copy_out_p5(ddx_applicable_activities_tbl, p8_a0

852:
853:
854:
855:
856: ahl_fmp_pvt_w.rosetta_table_copy_out_p5(ddx_applicable_activities_tbl, p8_a0
857: , p8_a1
858: , p8_a2
859: , p8_a3
860: , p8_a4

Line 868: ahl_fmp_pvt_w.rosetta_table_copy_out_p7(ddx_applicable_programs_tbl, p9_a0

864: , p8_a8
865: , p8_a9
866: );
867:
868: ahl_fmp_pvt_w.rosetta_table_copy_out_p7(ddx_applicable_programs_tbl, p9_a0
869: , p9_a1
870: , p9_a2
871: , p9_a3
872: , p9_a4

Line 922: ddx_applicable_mr_tbl ahl_fmp_pvt.applicable_mr_tbl_type;

918: , p11_a11 out nocopy JTF_NUMBER_TABLE
919: )
920:
921: as
922: ddx_applicable_mr_tbl ahl_fmp_pvt.applicable_mr_tbl_type;
923: ddindx binary_integer; indx binary_integer;
924: begin
925:
926: -- copy data to the local IN or IN-OUT args, if any

Line 940: ahl_fmp_pvt.get_mr_applicability(p_api_version,

936:
937:
938:
939: -- here's the delegated call to the old PL/SQL routine
940: ahl_fmp_pvt.get_mr_applicability(p_api_version,
941: p_init_msg_list,
942: p_commit,
943: p_validation_level,
944: x_return_status,

Line 965: ahl_fmp_pvt_w.rosetta_table_copy_out_p3(ddx_applicable_mr_tbl, p11_a0

961:
962:
963:
964:
965: ahl_fmp_pvt_w.rosetta_table_copy_out_p3(ddx_applicable_mr_tbl, p11_a0
966: , p11_a1
967: , p11_a2
968: , p11_a3
969: , p11_a4

Line 980: end ahl_fmp_pvt_w;

976: , p11_a11
977: );
978: end;
979:
980: end ahl_fmp_pvt_w;