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 2008/01/31 09:08:39 bachandr 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 159: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

155: end loop;
156: end if;
157: end if;
158: end rosetta_table_copy_in_p2;
159: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
160: , a1 out nocopy JTF_NUMBER_TABLE
161: , a2 out nocopy JTF_NUMBER_TABLE
162: , a3 out nocopy JTF_VARCHAR2_TABLE_100
163: , a4 out nocopy JTF_NUMBER_TABLE

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

489: end if;
490: end if;
491: end rosetta_table_copy_out_p2;
492:
493: procedure rosetta_table_copy_in_p3(t out nocopy ahl_pp_materials_pvt.sch_material_tbl_type, a0 JTF_NUMBER_TABLE
494: , a1 JTF_NUMBER_TABLE
495: , a2 JTF_NUMBER_TABLE
496: , a3 JTF_VARCHAR2_TABLE_100
497: , a4 JTF_VARCHAR2_TABLE_300

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

554: end loop;
555: end if;
556: end if;
557: end rosetta_table_copy_in_p3;
558: procedure rosetta_table_copy_out_p3(t ahl_pp_materials_pvt.sch_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
559: , a1 out nocopy JTF_NUMBER_TABLE
560: , a2 out nocopy JTF_NUMBER_TABLE
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 772: ddp_x_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;

768: , x_msg_data out nocopy VARCHAR2
769: )
770:
771: as
772: ddp_x_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;
773: ddindx binary_integer; indx binary_integer;
774: begin
775:
776: -- copy data to the local IN or IN-OUT args, if any

Line 782: ahl_pp_materials_pvt_w.rosetta_table_copy_in_p2(ddp_x_req_material_tbl, p5_a0

778:
779:
780:
781:
782: ahl_pp_materials_pvt_w.rosetta_table_copy_in_p2(ddp_x_req_material_tbl, p5_a0
783: , p5_a1
784: , p5_a2
785: , p5_a3
786: , p5_a4

Line 852: ahl_pp_materials_pvt.create_material_reqst(p_api_version,

848:
849:
850:
851: -- here's the delegated call to the old PL/SQL routine
852: ahl_pp_materials_pvt.create_material_reqst(p_api_version,
853: p_init_msg_list,
854: p_commit,
855: p_validation_level,
856: p_interface_flag,

Line 869: ahl_pp_materials_pvt_w.rosetta_table_copy_out_p2(ddp_x_req_material_tbl, p5_a0

865:
866:
867:
868:
869: ahl_pp_materials_pvt_w.rosetta_table_copy_out_p2(ddp_x_req_material_tbl, p5_a0
870: , p5_a1
871: , p5_a2
872: , p5_a3
873: , p5_a4

Line 1013: ddp_x_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;

1009: , x_msg_data out nocopy VARCHAR2
1010: )
1011:
1012: as
1013: ddp_x_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;
1014: ddindx binary_integer; indx binary_integer;
1015: begin
1016:
1017: -- copy data to the local IN or IN-OUT args, if any

Line 1023: ahl_pp_materials_pvt_w.rosetta_table_copy_in_p2(ddp_x_req_material_tbl, p5_a0

1019:
1020:
1021:
1022:
1023: ahl_pp_materials_pvt_w.rosetta_table_copy_in_p2(ddp_x_req_material_tbl, p5_a0
1024: , p5_a1
1025: , p5_a2
1026: , p5_a3
1027: , p5_a4

Line 1092: ahl_pp_materials_pvt.process_material_request(p_api_version,

1088:
1089:
1090:
1091: -- here's the delegated call to the old PL/SQL routine
1092: ahl_pp_materials_pvt.process_material_request(p_api_version,
1093: p_init_msg_list,
1094: p_commit,
1095: p_validation_level,
1096: p_module_type,

Line 1108: ahl_pp_materials_pvt_w.rosetta_table_copy_out_p2(ddp_x_req_material_tbl, p5_a0

1104:
1105:
1106:
1107:
1108: ahl_pp_materials_pvt_w.rosetta_table_copy_out_p2(ddp_x_req_material_tbl, p5_a0
1109: , p5_a1
1110: , p5_a2
1111: , p5_a3
1112: , p5_a4

Line 1309: ahl_pp_materials_pvt.log_transaction_record(p_wo_operation_txn_id,

1305:
1306:
1307:
1308: -- here's the delegated call to the old PL/SQL routine
1309: ahl_pp_materials_pvt.log_transaction_record(p_wo_operation_txn_id,
1310: p_object_version_number,
1311: ddp_last_update_date,
1312: p_last_updated_by,
1313: ddp_creation_date,

Line 1489: ddp_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;

1485: , x_msg_data out nocopy VARCHAR2
1486: )
1487:
1488: as
1489: ddp_req_material_tbl ahl_pp_materials_pvt.req_material_tbl_type;
1490: ddindx binary_integer; indx binary_integer;
1491: begin
1492:
1493: -- copy data to the local IN or IN-OUT args, if any

Line 1498: ahl_pp_materials_pvt_w.rosetta_table_copy_in_p2(ddp_req_material_tbl, p4_a0

1494:
1495:
1496:
1497:
1498: ahl_pp_materials_pvt_w.rosetta_table_copy_in_p2(ddp_req_material_tbl, p4_a0
1499: , p4_a1
1500: , p4_a2
1501: , p4_a3
1502: , p4_a4

Line 1567: ahl_pp_materials_pvt.material_notification(p_api_version,

1563:
1564:
1565:
1566: -- here's the delegated call to the old PL/SQL routine
1567: ahl_pp_materials_pvt.material_notification(p_api_version,
1568: p_init_msg_list,
1569: p_commit,
1570: p_validation_level,
1571: ddp_req_material_tbl,

Line 1586: end ahl_pp_materials_pvt_w;

1582:
1583:
1584: end;
1585:
1586: end ahl_pp_materials_pvt_w;