DBA Data[Home] [Help]

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 2008/01/30 05:20:53 pdoki 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:

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_material_as_pvt.material_req_tbl_type, a0 JTF_NUMBER_TABLE

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

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

106: end loop;
107: end if;
108: end if;
109: end rosetta_table_copy_in_p1;
110: procedure rosetta_table_copy_out_p1(t ahl_rm_material_as_pvt.material_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
111: , a1 out nocopy JTF_NUMBER_TABLE
112: , a2 out nocopy JTF_NUMBER_TABLE
113: , a3 out nocopy JTF_VARCHAR2_TABLE_100
114: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

325: end if;
326: end if;
327: end rosetta_table_copy_out_p1;
328:
329: procedure rosetta_table_copy_in_p3(t out nocopy ahl_rm_material_as_pvt.route_efct_tbl_type, a0 JTF_NUMBER_TABLE
330: , a1 JTF_VARCHAR2_TABLE_100
331: , a2 JTF_NUMBER_TABLE
332: , a3 JTF_NUMBER_TABLE
333: , a4 JTF_VARCHAR2_TABLE_100

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

416: end loop;
417: end if;
418: end if;
419: end rosetta_table_copy_in_p3;
420: procedure rosetta_table_copy_out_p3(t ahl_rm_material_as_pvt.route_efct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
421: , a1 out nocopy JTF_VARCHAR2_TABLE_100
422: , a2 out nocopy JTF_NUMBER_TABLE
423: , a3 out nocopy JTF_NUMBER_TABLE
424: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 678: ddp_x_material_req_tbl ahl_rm_material_as_pvt.material_req_tbl_type;

674: , p_association_type VARCHAR2
675: )
676:
677: as
678: ddp_x_material_req_tbl ahl_rm_material_as_pvt.material_req_tbl_type;
679: ddindx binary_integer; indx binary_integer;
680: begin
681:
682: -- copy data to the local IN or IN-OUT args, if any

Line 692: ahl_rm_material_as_pvt_w.rosetta_table_copy_in_p1(ddp_x_material_req_tbl, p9_a0

688:
689:
690:
691:
692: ahl_rm_material_as_pvt_w.rosetta_table_copy_in_p1(ddp_x_material_req_tbl, p9_a0
693: , p9_a1
694: , p9_a2
695: , p9_a3
696: , p9_a4

Line 737: ahl_rm_material_as_pvt.process_material_req(p_api_version,

733:
734:
735:
736: -- here's the delegated call to the old PL/SQL routine
737: ahl_rm_material_as_pvt.process_material_req(p_api_version,
738: p_init_msg_list,
739: p_commit,
740: p_validation_level,
741: p_default,

Line 760: ahl_rm_material_as_pvt_w.rosetta_table_copy_out_p1(ddp_x_material_req_tbl, p9_a0

756:
757:
758:
759:
760: ahl_rm_material_as_pvt_w.rosetta_table_copy_out_p1(ddp_x_material_req_tbl, p9_a0
761: , p9_a1
762: , p9_a2
763: , p9_a3
764: , p9_a4

Line 855: ddp_x_route_efct_tbl ahl_rm_material_as_pvt.route_efct_tbl_type;

851: , p10_a36 in out nocopy JTF_VARCHAR2_TABLE_100
852: )
853:
854: as
855: ddp_x_route_efct_tbl ahl_rm_material_as_pvt.route_efct_tbl_type;
856: ddindx binary_integer; indx binary_integer;
857: begin
858:
859: -- copy data to the local IN or IN-OUT args, if any

Line 870: ahl_rm_material_as_pvt_w.rosetta_table_copy_in_p3(ddp_x_route_efct_tbl, p10_a0

866:
867:
868:
869:
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 910: ahl_rm_material_as_pvt.process_route_efcts(p_api_version,

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

Line 933: ahl_rm_material_as_pvt_w.rosetta_table_copy_out_p3(ddp_x_route_efct_tbl, p10_a0

929:
930:
931:
932:
933: ahl_rm_material_as_pvt_w.rosetta_table_copy_out_p3(ddp_x_route_efct_tbl, p10_a0
934: , p10_a1
935: , p10_a2
936: , p10_a3
937: , p10_a4

Line 973: end ahl_rm_material_as_pvt_w;

969: , p10_a36
970: );
971: end;
972:
973: end ahl_rm_material_as_pvt_w;