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.IBU_ORDER_CAPTURE_W dependencies on IBU_ORDER_CAPTURE

Line 1: package body ibu_order_capture_w as

1: package body ibu_order_capture_w as
2: /* $Header: iburordb.pls 115.5.1159.1 2003/05/23 22:22:20 appldev noship $ */
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 22: procedure rosetta_table_copy_in_p1(t out nocopy ibu_order_capture.header_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy ibu_order_capture.header_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 65: procedure rosetta_table_copy_out_p1(t ibu_order_capture.header_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t ibu_order_capture.header_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_VARCHAR2_TABLE_300
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_NUMBER_TABLE

Line 149: procedure rosetta_table_copy_in_p4(t out nocopy ibu_order_capture.line_tbl_type, a0 JTF_NUMBER_TABLE

145: end if;
146: end if;
147: end rosetta_table_copy_out_p1;
148:
149: procedure rosetta_table_copy_in_p4(t out nocopy ibu_order_capture.line_tbl_type, a0 JTF_NUMBER_TABLE
150: , a1 JTF_VARCHAR2_TABLE_100
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_VARCHAR2_TABLE_100
153: , a4 JTF_NUMBER_TABLE

Line 196: procedure rosetta_table_copy_out_p4(t ibu_order_capture.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

192: end loop;
193: end if;
194: end if;
195: end rosetta_table_copy_in_p4;
196: procedure rosetta_table_copy_out_p4(t ibu_order_capture.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_VARCHAR2_TABLE_100
200: , a4 out nocopy JTF_NUMBER_TABLE

Line 290: procedure rosetta_table_copy_in_p6(t out nocopy ibu_order_capture.line_dtl_tbl_type, a0 JTF_VARCHAR2_TABLE_100

286: end if;
287: end if;
288: end rosetta_table_copy_out_p4;
289:
290: procedure rosetta_table_copy_in_p6(t out nocopy ibu_order_capture.line_dtl_tbl_type, a0 JTF_VARCHAR2_TABLE_100
291: , a1 JTF_NUMBER_TABLE
292: , a2 JTF_VARCHAR2_TABLE_100
293: , a3 JTF_NUMBER_TABLE
294: , a4 JTF_NUMBER_TABLE

Line 327: procedure rosetta_table_copy_out_p6(t ibu_order_capture.line_dtl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

323: end loop;
324: end if;
325: end if;
326: end rosetta_table_copy_in_p6;
327: procedure rosetta_table_copy_out_p6(t ibu_order_capture.line_dtl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
328: , a1 out nocopy JTF_NUMBER_TABLE
329: , a2 out nocopy JTF_VARCHAR2_TABLE_100
330: , a3 out nocopy JTF_NUMBER_TABLE
331: , a4 out nocopy JTF_NUMBER_TABLE

Line 396: procedure rosetta_table_copy_in_p8(t out nocopy ibu_order_capture.line_shipment_tbl_type, a0 JTF_VARCHAR2_TABLE_100

392: end if;
393: end if;
394: end rosetta_table_copy_out_p6;
395:
396: procedure rosetta_table_copy_in_p8(t out nocopy ibu_order_capture.line_shipment_tbl_type, a0 JTF_VARCHAR2_TABLE_100
397: , a1 JTF_NUMBER_TABLE
398: , a2 JTF_DATE_TABLE
399: , a3 JTF_DATE_TABLE
400: , a4 JTF_NUMBER_TABLE

Line 429: procedure rosetta_table_copy_out_p8(t ibu_order_capture.line_shipment_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

425: end loop;
426: end if;
427: end if;
428: end rosetta_table_copy_in_p8;
429: procedure rosetta_table_copy_out_p8(t ibu_order_capture.line_shipment_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_DATE_TABLE
432: , a3 out nocopy JTF_DATE_TABLE
433: , a4 out nocopy JTF_NUMBER_TABLE

Line 488: procedure rosetta_table_copy_in_p11(t out nocopy ibu_order_capture.return_line_tbl_type, a0 JTF_NUMBER_TABLE

484: end if;
485: end if;
486: end rosetta_table_copy_out_p8;
487:
488: procedure rosetta_table_copy_in_p11(t out nocopy ibu_order_capture.return_line_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_VARCHAR2_TABLE_200
491: ) as
492: ddindx binary_integer; indx binary_integer;

Line 511: procedure rosetta_table_copy_out_p11(t ibu_order_capture.return_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

507: end loop;
508: end if;
509: end if;
510: end rosetta_table_copy_in_p11;
511: procedure rosetta_table_copy_out_p11(t ibu_order_capture.return_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
512: , a1 out nocopy JTF_NUMBER_TABLE
513: , a2 out nocopy JTF_VARCHAR2_TABLE_200
514: ) as
515: ddindx binary_integer; indx binary_integer;

Line 613: ddheader_rec ibu_order_capture.header_rec_type;

609: , p5_a5 NUMBER := 0-1962.0724
610: )
611:
612: as
613: ddheader_rec ibu_order_capture.header_rec_type;
614: ddheader_shipment_rec ibu_order_capture.header_shipment_rec_type;
615: ddline_tbl ibu_order_capture.line_tbl_type;
616: ddline_dtl_tbl ibu_order_capture.line_dtl_tbl_type;
617: ddline_shipment_tbl ibu_order_capture.line_shipment_tbl_type;

Line 614: ddheader_shipment_rec ibu_order_capture.header_shipment_rec_type;

610: )
611:
612: as
613: ddheader_rec ibu_order_capture.header_rec_type;
614: ddheader_shipment_rec ibu_order_capture.header_shipment_rec_type;
615: ddline_tbl ibu_order_capture.line_tbl_type;
616: ddline_dtl_tbl ibu_order_capture.line_dtl_tbl_type;
617: ddline_shipment_tbl ibu_order_capture.line_shipment_tbl_type;
618: ddx_return_header_rec ibu_order_capture.return_header_rec_type;

Line 615: ddline_tbl ibu_order_capture.line_tbl_type;

611:
612: as
613: ddheader_rec ibu_order_capture.header_rec_type;
614: ddheader_shipment_rec ibu_order_capture.header_shipment_rec_type;
615: ddline_tbl ibu_order_capture.line_tbl_type;
616: ddline_dtl_tbl ibu_order_capture.line_dtl_tbl_type;
617: ddline_shipment_tbl ibu_order_capture.line_shipment_tbl_type;
618: ddx_return_header_rec ibu_order_capture.return_header_rec_type;
619: ddx_return_line_tbl ibu_order_capture.return_line_tbl_type;

Line 616: ddline_dtl_tbl ibu_order_capture.line_dtl_tbl_type;

612: as
613: ddheader_rec ibu_order_capture.header_rec_type;
614: ddheader_shipment_rec ibu_order_capture.header_shipment_rec_type;
615: ddline_tbl ibu_order_capture.line_tbl_type;
616: ddline_dtl_tbl ibu_order_capture.line_dtl_tbl_type;
617: ddline_shipment_tbl ibu_order_capture.line_shipment_tbl_type;
618: ddx_return_header_rec ibu_order_capture.return_header_rec_type;
619: ddx_return_line_tbl ibu_order_capture.return_line_tbl_type;
620: ddindx binary_integer; indx binary_integer;

Line 617: ddline_shipment_tbl ibu_order_capture.line_shipment_tbl_type;

613: ddheader_rec ibu_order_capture.header_rec_type;
614: ddheader_shipment_rec ibu_order_capture.header_shipment_rec_type;
615: ddline_tbl ibu_order_capture.line_tbl_type;
616: ddline_dtl_tbl ibu_order_capture.line_dtl_tbl_type;
617: ddline_shipment_tbl ibu_order_capture.line_shipment_tbl_type;
618: ddx_return_header_rec ibu_order_capture.return_header_rec_type;
619: ddx_return_line_tbl ibu_order_capture.return_line_tbl_type;
620: ddindx binary_integer; indx binary_integer;
621: begin

Line 618: ddx_return_header_rec ibu_order_capture.return_header_rec_type;

614: ddheader_shipment_rec ibu_order_capture.header_shipment_rec_type;
615: ddline_tbl ibu_order_capture.line_tbl_type;
616: ddline_dtl_tbl ibu_order_capture.line_dtl_tbl_type;
617: ddline_shipment_tbl ibu_order_capture.line_shipment_tbl_type;
618: ddx_return_header_rec ibu_order_capture.return_header_rec_type;
619: ddx_return_line_tbl ibu_order_capture.return_line_tbl_type;
620: ddindx binary_integer; indx binary_integer;
621: begin
622:

Line 619: ddx_return_line_tbl ibu_order_capture.return_line_tbl_type;

615: ddline_tbl ibu_order_capture.line_tbl_type;
616: ddline_dtl_tbl ibu_order_capture.line_dtl_tbl_type;
617: ddline_shipment_tbl ibu_order_capture.line_shipment_tbl_type;
618: ddx_return_header_rec ibu_order_capture.return_header_rec_type;
619: ddx_return_line_tbl ibu_order_capture.return_line_tbl_type;
620: ddindx binary_integer; indx binary_integer;
621: begin
622:
623: -- copy data to the local IN or IN-OUT args, if any

Line 649: ibu_order_capture_w.rosetta_table_copy_in_p4(ddline_tbl, p6_a0

645: ddheader_shipment_rec.ship_to_party_id := rosetta_g_miss_num_map(p5_a3);
646: ddheader_shipment_rec.freight_carrier_code := p5_a4;
647: ddheader_shipment_rec.quantity := rosetta_g_miss_num_map(p5_a5);
648:
649: ibu_order_capture_w.rosetta_table_copy_in_p4(ddline_tbl, p6_a0
650: , p6_a1
651: , p6_a2
652: , p6_a3
653: , p6_a4

Line 666: ibu_order_capture_w.rosetta_table_copy_in_p6(ddline_dtl_tbl, p7_a0

662: , p6_a13
663: , p6_a14
664: );
665:
666: ibu_order_capture_w.rosetta_table_copy_in_p6(ddline_dtl_tbl, p7_a0
667: , p7_a1
668: , p7_a2
669: , p7_a3
670: , p7_a4

Line 678: ibu_order_capture_w.rosetta_table_copy_in_p8(ddline_shipment_tbl, p8_a0

674: , p7_a8
675: , p7_a9
676: );
677:
678: ibu_order_capture_w.rosetta_table_copy_in_p8(ddline_shipment_tbl, p8_a0
679: , p8_a1
680: , p8_a2
681: , p8_a3
682: , p8_a4

Line 694: ibu_order_capture.create_return(p_api_version_number,

690:
691:
692:
693: -- here's the delegated call to the old PL/SQL routine
694: ibu_order_capture.create_return(p_api_version_number,
695: p_init_msg_list,
696: p_commit,
697: p_header_id,
698: ddheader_rec,

Line 726: ibu_order_capture_w.rosetta_table_copy_out_p11(ddx_return_line_tbl, p13_a0

722: p12_a0 := rosetta_g_miss_num_map(ddx_return_header_rec.order_number);
723: p12_a1 := rosetta_g_miss_num_map(ddx_return_header_rec.order_header_id);
724: p12_a2 := ddx_return_header_rec.status;
725:
726: ibu_order_capture_w.rosetta_table_copy_out_p11(ddx_return_line_tbl, p13_a0
727: , p13_a1
728: , p13_a2
729: );
730: end;

Line 732: end ibu_order_capture_w;

728: , p13_a2
729: );
730: end;
731:
732: end ibu_order_capture_w;