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_EFFECTIVITY_DTL_PVT_W dependencies on AHL_FMP_EFFECTIVITY_DTL_PVT

Line 1: package body ahl_fmp_effectivity_dtl_pvt_w as

1: package body ahl_fmp_effectivity_dtl_pvt_w as
2: /* $Header: AHLWMEDB.pls 120.4.12020000.2 2012/12/14 10:03:47 shnatu 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_effectivity_dtl_pvt.effectivity_detail_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_p1(t out nocopy ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100

Line 99: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

95: end loop;
96: end if;
97: end if;
98: end rosetta_table_copy_in_p1;
99: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 283: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 JTF_NUMBER_TABLE

279: end if;
280: end if;
281: end rosetta_table_copy_out_p1;
282:
283: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 JTF_NUMBER_TABLE
284: , a1 JTF_NUMBER_TABLE
285: , a2 JTF_VARCHAR2_TABLE_100
286: , a3 JTF_VARCHAR2_TABLE_100
287: , a4 JTF_NUMBER_TABLE

Line 366: procedure rosetta_table_copy_out_p3(t ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

362: end loop;
363: end if;
364: end if;
365: end rosetta_table_copy_in_p3;
366: procedure rosetta_table_copy_out_p3(t ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_NUMBER_TABLE
368: , a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , a3 out nocopy JTF_VARCHAR2_TABLE_100
370: , a4 out nocopy JTF_NUMBER_TABLE

Line 630: ddp_x_effectivity_detail_tbl ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type;

626: , p_mr_effectivity_id NUMBER
627: )
628:
629: as
630: ddp_x_effectivity_detail_tbl ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type;
631: ddp_x_effty_ext_detail_tbl ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type;
632: ddindx binary_integer; indx binary_integer;
633: begin
634:

Line 631: ddp_x_effty_ext_detail_tbl ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type;

627: )
628:
629: as
630: ddp_x_effectivity_detail_tbl ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type;
631: ddp_x_effty_ext_detail_tbl ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type;
632: ddindx binary_integer; indx binary_integer;
633: begin
634:
635: -- copy data to the local IN or IN-OUT args, if any

Line 645: ahl_fmp_effectivity_dtl_pvt_w.rosetta_table_copy_in_p1(ddp_x_effectivity_detail_tbl, p9_a0

641:
642:
643:
644:
645: ahl_fmp_effectivity_dtl_pvt_w.rosetta_table_copy_in_p1(ddp_x_effectivity_detail_tbl, p9_a0
646: , p9_a1
647: , p9_a2
648: , p9_a3
649: , p9_a4

Line 680: ahl_fmp_effectivity_dtl_pvt_w.rosetta_table_copy_in_p3(ddp_x_effty_ext_detail_tbl, p10_a0

676: , p9_a31
677: , p9_a32
678: );
679:
680: ahl_fmp_effectivity_dtl_pvt_w.rosetta_table_copy_in_p3(ddp_x_effty_ext_detail_tbl, p10_a0
681: , p10_a1
682: , p10_a2
683: , p10_a3
684: , p10_a4

Line 718: ahl_fmp_effectivity_dtl_pvt.process_effectivity_detail(p_api_version,

714:
715:
716:
717: -- here's the delegated call to the old PL/SQL routine
718: ahl_fmp_effectivity_dtl_pvt.process_effectivity_detail(p_api_version,
719: p_init_msg_list,
720: p_commit,
721: p_validation_level,
722: p_default,

Line 742: ahl_fmp_effectivity_dtl_pvt_w.rosetta_table_copy_out_p1(ddp_x_effectivity_detail_tbl, p9_a0

738:
739:
740:
741:
742: ahl_fmp_effectivity_dtl_pvt_w.rosetta_table_copy_out_p1(ddp_x_effectivity_detail_tbl, p9_a0
743: , p9_a1
744: , p9_a2
745: , p9_a3
746: , p9_a4

Line 777: ahl_fmp_effectivity_dtl_pvt_w.rosetta_table_copy_out_p3(ddp_x_effty_ext_detail_tbl, p10_a0

773: , p9_a31
774: , p9_a32
775: );
776:
777: ahl_fmp_effectivity_dtl_pvt_w.rosetta_table_copy_out_p3(ddp_x_effty_ext_detail_tbl, p10_a0
778: , p10_a1
779: , p10_a2
780: , p10_a3
781: , p10_a4

Line 815: end ahl_fmp_effectivity_dtl_pvt_w;

811:
812:
813: end;
814:
815: end ahl_fmp_effectivity_dtl_pvt_w;