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_PP_MATERIALS_PVT_W dependencies on AHL_PP_MATERIALS_PVT

Line 1: package body ahl_pp_materials_pvt_w as

1: package body ahl_pp_materials_pvt_w as
2: /* $Header: AHLWPPMB.pls 120.2.12020000.2 2012/12/14 03:37:48 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_p2(t out nocopy ahl_pp_materials_pvt.req_material_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_p2(t out nocopy ahl_pp_materials_pvt.req_material_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 171: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

167: end loop;
168: end if;
169: end if;
170: end rosetta_table_copy_in_p2;
171: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
172: , a1 out nocopy JTF_NUMBER_TABLE
173: , a2 out nocopy JTF_NUMBER_TABLE
174: , a3 out nocopy JTF_VARCHAR2_TABLE_100
175: , a4 out nocopy JTF_NUMBER_TABLE

Line 535: procedure rosetta_table_copy_in_p3(t out nocopy ahl_pp_materials_pvt.sch_material_tbl_type, a0 JTF_NUMBER_TABLE

531: end if;
532: end if;
533: end rosetta_table_copy_out_p2;
534:
535: procedure rosetta_table_copy_in_p3(t out nocopy ahl_pp_materials_pvt.sch_material_tbl_type, a0 JTF_NUMBER_TABLE
536: , a1 JTF_NUMBER_TABLE
537: , a2 JTF_NUMBER_TABLE
538: , a3 JTF_VARCHAR2_TABLE_100
539: , a4 JTF_VARCHAR2_TABLE_300

Line 600: procedure rosetta_table_copy_out_p3(t ahl_pp_materials_pvt.sch_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

596: end loop;
597: end if;
598: end if;
599: end rosetta_table_copy_in_p3;
600: procedure rosetta_table_copy_out_p3(t ahl_pp_materials_pvt.sch_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
601: , a1 out nocopy JTF_NUMBER_TABLE
602: , a2 out nocopy JTF_NUMBER_TABLE
603: , a3 out nocopy JTF_VARCHAR2_TABLE_100
604: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 821: ddp_x_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;

817: , x_msg_data out nocopy VARCHAR2
818: )
819:
820: as
821: ddp_x_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;
822: ddindx binary_integer; indx binary_integer;
823: begin
824:
825: -- copy data to the local IN or IN-OUT args, if any

Line 832: ahl_pp_materials_pvt_w.rosetta_table_copy_in_p2(ddp_x_req_material_tbl, p6_a0

828:
829:
830:
831:
832: ahl_pp_materials_pvt_w.rosetta_table_copy_in_p2(ddp_x_req_material_tbl, p6_a0
833: , p6_a1
834: , p6_a2
835: , p6_a3
836: , p6_a4

Line 908: ahl_pp_materials_pvt.create_material_reqst(p_api_version,

904:
905:
906:
907: -- here's the delegated call to the old PL/SQL routine
908: ahl_pp_materials_pvt.create_material_reqst(p_api_version,
909: p_init_msg_list,
910: p_commit,
911: p_validation_level,
912: p_module_type,

Line 927: ahl_pp_materials_pvt_w.rosetta_table_copy_out_p2(ddp_x_req_material_tbl, p6_a0

923:
924:
925:
926:
927: ahl_pp_materials_pvt_w.rosetta_table_copy_out_p2(ddp_x_req_material_tbl, p6_a0
928: , p6_a1
929: , p6_a2
930: , p6_a3
931: , p6_a4

Line 1083: ddp_x_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;

1079: , x_msg_data out nocopy VARCHAR2
1080: )
1081:
1082: as
1083: ddp_x_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;
1084: ddindx binary_integer; indx binary_integer;
1085: begin
1086:
1087: -- copy data to the local IN or IN-OUT args, if any

Line 1093: ahl_pp_materials_pvt_w.rosetta_table_copy_in_p2(ddp_x_req_material_tbl, p5_a0

1089:
1090:
1091:
1092:
1093: ahl_pp_materials_pvt_w.rosetta_table_copy_in_p2(ddp_x_req_material_tbl, p5_a0
1094: , p5_a1
1095: , p5_a2
1096: , p5_a3
1097: , p5_a4

Line 1168: ahl_pp_materials_pvt.process_material_request(p_api_version,

1164:
1165:
1166:
1167: -- here's the delegated call to the old PL/SQL routine
1168: ahl_pp_materials_pvt.process_material_request(p_api_version,
1169: p_init_msg_list,
1170: p_commit,
1171: p_validation_level,
1172: p_module_type,

Line 1184: ahl_pp_materials_pvt_w.rosetta_table_copy_out_p2(ddp_x_req_material_tbl, p5_a0

1180:
1181:
1182:
1183:
1184: ahl_pp_materials_pvt_w.rosetta_table_copy_out_p2(ddp_x_req_material_tbl, p5_a0
1185: , p5_a1
1186: , p5_a2
1187: , p5_a3
1188: , p5_a4

Line 1397: ddx_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;

1393: )
1394:
1395: as
1396: ddp_prd_wooperation_tbl ahl_prd_operations_pvt.prd_operation_tbl;
1397: ddx_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;
1398: ddindx binary_integer; indx binary_integer;
1399: begin
1400:
1401: -- copy data to the local IN or IN-OUT args, if any

Line 1471: ahl_pp_materials_pvt.process_wo_op_materials(p_api_version,

1467:
1468:
1469:
1470: -- here's the delegated call to the old PL/SQL routine
1471: ahl_pp_materials_pvt.process_wo_op_materials(p_api_version,
1472: p_init_msg_list,
1473: p_commit,
1474: p_validation_level,
1475: p_operation_flag,

Line 1489: ahl_pp_materials_pvt_w.rosetta_table_copy_out_p2(ddx_req_material_tbl, p6_a0

1485:
1486:
1487:
1488:
1489: ahl_pp_materials_pvt_w.rosetta_table_copy_out_p2(ddx_req_material_tbl, p6_a0
1490: , p6_a1
1491: , p6_a2
1492: , p6_a3
1493: , p6_a4

Line 1696: ahl_pp_materials_pvt.log_transaction_record(p_wo_operation_txn_id,

1692:
1693:
1694:
1695: -- here's the delegated call to the old PL/SQL routine
1696: ahl_pp_materials_pvt.log_transaction_record(p_wo_operation_txn_id,
1697: p_object_version_number,
1698: ddp_last_update_date,
1699: p_last_updated_by,
1700: ddp_creation_date,

Line 1882: ddp_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;

1878: , x_msg_data out nocopy VARCHAR2
1879: )
1880:
1881: as
1882: ddp_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;
1883: ddindx binary_integer; indx binary_integer;
1884: begin
1885:
1886: -- copy data to the local IN or IN-OUT args, if any

Line 1891: ahl_pp_materials_pvt_w.rosetta_table_copy_in_p2(ddp_req_material_tbl, p4_a0

1887:
1888:
1889:
1890:
1891: ahl_pp_materials_pvt_w.rosetta_table_copy_in_p2(ddp_req_material_tbl, p4_a0
1892: , p4_a1
1893: , p4_a2
1894: , p4_a3
1895: , p4_a4

Line 1966: ahl_pp_materials_pvt.material_notification(p_api_version,

1962:
1963:
1964:
1965: -- here's the delegated call to the old PL/SQL routine
1966: ahl_pp_materials_pvt.material_notification(p_api_version,
1967: p_init_msg_list,
1968: p_commit,
1969: p_validation_level,
1970: ddp_req_material_tbl,

Line 1985: end ahl_pp_materials_pvt_w;

1981:
1982:
1983: end;
1984:
1985: end ahl_pp_materials_pvt_w;