DBA Data[Home] [Help]

APPS.AHL_OSP_SHIPMENT_PUB_W dependencies on AHL_OSP_SHIPMENT_PUB

Line 1: package body ahl_osp_shipment_pub_w as

1: package body ahl_osp_shipment_pub_w as
2: /* $Header: AHLWOSHB.pls 120.1 2007/07/30 10:43:57 mpothuku ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_osp_shipment_pub.sernum_change_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_osp_shipment_pub.sernum_change_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package body ahl_osp_shipment_pub_w as
2: /* $Header: AHLWOSHB.pls 120.1 2007/07/30 10:43:57 mpothuku ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_osp_shipment_pub.sernum_change_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 42: procedure rosetta_table_copy_out_p1(t ahl_osp_shipment_pub.sernum_change_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

38: end loop;
39: end if;
40: end if;
41: end rosetta_table_copy_in_p1;
42: procedure rosetta_table_copy_out_p1(t ahl_osp_shipment_pub.sernum_change_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_NUMBER_TABLE

Line 116: procedure rosetta_table_copy_in_p4(t out nocopy ahl_osp_shipment_pub.ship_line_tbl_type, a0 JTF_NUMBER_TABLE

112: end if;
113: end if;
114: end rosetta_table_copy_out_p1;
115:
116: procedure rosetta_table_copy_in_p4(t out nocopy ahl_osp_shipment_pub.ship_line_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_VARCHAR2_TABLE_300
120: , a4 JTF_NUMBER_TABLE

Line 223: procedure rosetta_table_copy_out_p4(t ahl_osp_shipment_pub.ship_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

219: end loop;
220: end if;
221: end if;
222: end rosetta_table_copy_in_p4;
223: procedure rosetta_table_copy_out_p4(t ahl_osp_shipment_pub.ship_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
224: , a1 out nocopy JTF_NUMBER_TABLE
225: , a2 out nocopy JTF_NUMBER_TABLE
226: , a3 out nocopy JTF_VARCHAR2_TABLE_300
227: , a4 out nocopy JTF_NUMBER_TABLE

Line 467: procedure rosetta_table_copy_in_p5(t out nocopy ahl_osp_shipment_pub.ship_id_tbl_type, a0 JTF_NUMBER_TABLE) as

463: end if;
464: end if;
465: end rosetta_table_copy_out_p4;
466:
467: procedure rosetta_table_copy_in_p5(t out nocopy ahl_osp_shipment_pub.ship_id_tbl_type, a0 JTF_NUMBER_TABLE) as
468: ddindx binary_integer; indx binary_integer;
469: begin
470: if a0 is not null and a0.count > 0 then
471: if a0.count > 0 then

Line 485: procedure rosetta_table_copy_out_p5(t ahl_osp_shipment_pub.ship_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

481: end loop;
482: end if;
483: end if;
484: end rosetta_table_copy_in_p5;
485: procedure rosetta_table_copy_out_p5(t ahl_osp_shipment_pub.ship_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
486: ddindx binary_integer; indx binary_integer;
487: begin
488: if t is null or t.count = 0 then
489: a0 := JTF_NUMBER_TABLE();

Line 600: ddp_x_header_rec ahl_osp_shipment_pub.ship_header_rec_type;

596: , x_msg_data out nocopy VARCHAR2
597: )
598:
599: as
600: ddp_x_header_rec ahl_osp_shipment_pub.ship_header_rec_type;
601: ddp_x_lines_tbl ahl_osp_shipment_pub.ship_line_tbl_type;
602: ddindx binary_integer; indx binary_integer;
603: begin
604:

Line 601: ddp_x_lines_tbl ahl_osp_shipment_pub.ship_line_tbl_type;

597: )
598:
599: as
600: ddp_x_header_rec ahl_osp_shipment_pub.ship_header_rec_type;
601: ddp_x_lines_tbl ahl_osp_shipment_pub.ship_line_tbl_type;
602: ddindx binary_integer; indx binary_integer;
603: begin
604:
605: -- copy data to the local IN or IN-OUT args, if any

Line 648: ahl_osp_shipment_pub_w.rosetta_table_copy_in_p4(ddp_x_lines_tbl, p6_a0

644: ddp_x_header_rec.shipping_instructions := p5_a33;
645: ddp_x_header_rec.packing_instructions := p5_a34;
646: ddp_x_header_rec.operation := p5_a35;
647:
648: ahl_osp_shipment_pub_w.rosetta_table_copy_in_p4(ddp_x_lines_tbl, p6_a0
649: , p6_a1
650: , p6_a2
651: , p6_a3
652: , p6_a4

Line 699: ahl_osp_shipment_pub.process_order(p_api_version,

695:
696:
697:
698: -- here's the delegated call to the old PL/SQL routine
699: ahl_osp_shipment_pub.process_order(p_api_version,
700: p_init_msg_list,
701: p_commit,
702: p_validation_level,
703: p_module_type,

Line 753: ahl_osp_shipment_pub_w.rosetta_table_copy_out_p4(ddp_x_lines_tbl, p6_a0

749: p5_a33 := ddp_x_header_rec.shipping_instructions;
750: p5_a34 := ddp_x_header_rec.packing_instructions;
751: p5_a35 := ddp_x_header_rec.operation;
752:
753: ahl_osp_shipment_pub_w.rosetta_table_copy_out_p4(ddp_x_lines_tbl, p6_a0
754: , p6_a1
755: , p6_a2
756: , p6_a3
757: , p6_a4

Line 815: ddp_oe_header_tbl ahl_osp_shipment_pub.ship_id_tbl_type;

811: , x_msg_data out nocopy VARCHAR2
812: )
813:
814: as
815: ddp_oe_header_tbl ahl_osp_shipment_pub.ship_id_tbl_type;
816: ddindx binary_integer; indx binary_integer;
817: begin
818:
819: -- copy data to the local IN or IN-OUT args, if any

Line 824: ahl_osp_shipment_pub_w.rosetta_table_copy_in_p5(ddp_oe_header_tbl, p_oe_header_tbl);

820:
821:
822:
823:
824: ahl_osp_shipment_pub_w.rosetta_table_copy_in_p5(ddp_oe_header_tbl, p_oe_header_tbl);
825:
826:
827:
828:

Line 830: ahl_osp_shipment_pub.book_order(p_api_version,

826:
827:
828:
829: -- here's the delegated call to the old PL/SQL routine
830: ahl_osp_shipment_pub.book_order(p_api_version,
831: p_init_msg_list,
832: p_commit,
833: p_validation_level,
834: ddp_oe_header_tbl,

Line 862: ddp_oe_lines_tbl ahl_osp_shipment_pub.ship_id_tbl_type;

858: , x_msg_data out nocopy VARCHAR2
859: )
860:
861: as
862: ddp_oe_lines_tbl ahl_osp_shipment_pub.ship_id_tbl_type;
863: ddindx binary_integer; indx binary_integer;
864: begin
865:
866: -- copy data to the local IN or IN-OUT args, if any

Line 872: ahl_osp_shipment_pub_w.rosetta_table_copy_in_p5(ddp_oe_lines_tbl, p_oe_lines_tbl);

868:
869:
870:
871:
872: ahl_osp_shipment_pub_w.rosetta_table_copy_in_p5(ddp_oe_lines_tbl, p_oe_lines_tbl);
873:
874:
875:
876:

Line 879: ahl_osp_shipment_pub.delete_cancel_order(p_api_version,

875:
876:
877:
878: -- here's the delegated call to the old PL/SQL routine
879: ahl_osp_shipment_pub.delete_cancel_order(p_api_version,
880: p_init_msg_list,
881: p_commit,
882: p_validation_level,
883: p_oe_header_id,

Line 924: ddp_serialnum_change_rec ahl_osp_shipment_pub.sernum_change_rec_type;

920: , x_msg_data out nocopy VARCHAR2
921: )
922:
923: as
924: ddp_serialnum_change_rec ahl_osp_shipment_pub.sernum_change_rec_type;
925: ddindx binary_integer; indx binary_integer;
926: begin
927:
928: -- copy data to the local IN or IN-OUT args, if any

Line 950: ahl_osp_shipment_pub.process_osp_serialnum_change(p_api_version,

946:
947:
948:
949: -- here's the delegated call to the old PL/SQL routine
950: ahl_osp_shipment_pub.process_osp_serialnum_change(p_api_version,
951: p_init_msg_list,
952: p_commit,
953: p_validation_level,
954: p_module_type,

Line 971: end ahl_osp_shipment_pub_w;

967:
968:
969: end;
970:
971: end ahl_osp_shipment_pub_w;