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_RM_MATERIAL_AS_PVT_W dependencies on AHL_RM_MATERIAL_AS_PVT

Line 1: package body ahl_rm_material_as_pvt_w as

1: package body ahl_rm_material_as_pvt_w as
2: /* $Header: AHLWMTLB.pls 120.1.12020000.2 2012/12/13 06:21:49 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 14: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_material_as_pvt.material_req_tbl_type, a0 JTF_NUMBER_TABLE

10: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
11: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
12: return d;
13: end;
14: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_material_as_pvt.material_req_tbl_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_NUMBER_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_VARCHAR2_TABLE_100

Line 119: procedure rosetta_table_copy_out_p1(t ahl_rm_material_as_pvt.material_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

115: end loop;
116: end if;
117: end if;
118: end rosetta_table_copy_in_p1;
119: procedure rosetta_table_copy_out_p1(t ahl_rm_material_as_pvt.material_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 357: procedure rosetta_table_copy_in_p3(t out nocopy ahl_rm_material_as_pvt.route_efct_tbl_type, a0 JTF_NUMBER_TABLE

353: end loop;
354: end if;
355: end if;
356: end rosetta_table_copy_out_p1;
357: procedure rosetta_table_copy_in_p3(t out nocopy ahl_rm_material_as_pvt.route_efct_tbl_type, a0 JTF_NUMBER_TABLE
358: , a1 JTF_VARCHAR2_TABLE_100
359: , a2 JTF_NUMBER_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_VARCHAR2_TABLE_100

Line 448: procedure rosetta_table_copy_out_p3(t ahl_rm_material_as_pvt.route_efct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

444: end loop;
445: end if;
446: end if;
447: end rosetta_table_copy_in_p3;
448: procedure rosetta_table_copy_out_p3(t ahl_rm_material_as_pvt.route_efct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
449: , a1 out nocopy JTF_VARCHAR2_TABLE_100
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 708: ddp_x_material_req_tbl ahl_rm_material_as_pvt.material_req_tbl_type;

704: , p_object_id NUMBER
705: , p_association_type VARCHAR2
706: )
707: as
708: ddp_x_material_req_tbl ahl_rm_material_as_pvt.material_req_tbl_type;
709: ddindx binary_integer; indx binary_integer;
710: begin
711: -- copy data to the local IN or IN-OUT args, if any
712: ahl_rm_material_as_pvt_w.rosetta_table_copy_in_p1(ddp_x_material_req_tbl, p9_a0

Line 712: ahl_rm_material_as_pvt_w.rosetta_table_copy_in_p1(ddp_x_material_req_tbl, p9_a0

708: ddp_x_material_req_tbl ahl_rm_material_as_pvt.material_req_tbl_type;
709: ddindx binary_integer; indx binary_integer;
710: begin
711: -- copy data to the local IN or IN-OUT args, if any
712: ahl_rm_material_as_pvt_w.rosetta_table_copy_in_p1(ddp_x_material_req_tbl, p9_a0
713: , p9_a1
714: , p9_a2
715: , p9_a3
716: , p9_a4

Line 758: ahl_rm_material_as_pvt.process_material_req(p_api_version,

754: , p9_a42
755: , p9_a43
756: );
757: -- here's the delegated call to the old PL/SQL routine
758: ahl_rm_material_as_pvt.process_material_req(p_api_version,
759: p_init_msg_list,
760: p_commit,
761: p_validation_level,
762: p_default,

Line 771: ahl_rm_material_as_pvt_w.rosetta_table_copy_out_p1(ddp_x_material_req_tbl, p9_a0

767: ddp_x_material_req_tbl,
768: p_object_id,
769: p_association_type);
770: -- copy data back from the local variables to OUT or IN-OUT args, if any
771: ahl_rm_material_as_pvt_w.rosetta_table_copy_out_p1(ddp_x_material_req_tbl, p9_a0
772: , p9_a1
773: , p9_a2
774: , p9_a3
775: , p9_a4

Line 866: ddp_x_route_efct_tbl ahl_rm_material_as_pvt.route_efct_tbl_type;

862: , p10_a35 in out nocopy JTF_VARCHAR2_TABLE_200
863: , p10_a36 in out nocopy JTF_VARCHAR2_TABLE_100
864: )
865: as
866: ddp_x_route_efct_tbl ahl_rm_material_as_pvt.route_efct_tbl_type;
867: ddindx binary_integer; indx binary_integer;
868: begin
869: -- copy data to the local IN or IN-OUT args, if any
870: ahl_rm_material_as_pvt_w.rosetta_table_copy_in_p3(ddp_x_route_efct_tbl, p10_a0

Line 870: ahl_rm_material_as_pvt_w.rosetta_table_copy_in_p3(ddp_x_route_efct_tbl, p10_a0

866: ddp_x_route_efct_tbl ahl_rm_material_as_pvt.route_efct_tbl_type;
867: ddindx binary_integer; indx binary_integer;
868: begin
869: -- copy data to the local IN or IN-OUT args, if any
870: ahl_rm_material_as_pvt_w.rosetta_table_copy_in_p3(ddp_x_route_efct_tbl, p10_a0
871: , p10_a1
872: , p10_a2
873: , p10_a3
874: , p10_a4

Line 909: ahl_rm_material_as_pvt.process_route_efcts(p_api_version,

905: , p10_a35
906: , p10_a36
907: );
908: -- here's the delegated call to the old PL/SQL routine
909: ahl_rm_material_as_pvt.process_route_efcts(p_api_version,
910: p_init_msg_list,
911: p_commit,
912: p_validation_level,
913: p_default,

Line 921: ahl_rm_material_as_pvt_w.rosetta_table_copy_out_p3(ddp_x_route_efct_tbl, p10_a0

917: x_msg_count,
918: x_msg_data,
919: ddp_x_route_efct_tbl);
920: -- copy data back from the local variables to OUT or IN-OUT args, if any
921: ahl_rm_material_as_pvt_w.rosetta_table_copy_out_p3(ddp_x_route_efct_tbl, p10_a0
922: , p10_a1
923: , p10_a2
924: , p10_a3
925: , p10_a4

Line 960: end ahl_rm_material_as_pvt_w;

956: , p10_a35
957: , p10_a36
958: );
959: end;
960: end ahl_rm_material_as_pvt_w;