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.INV_LOT_EO_PVT dependencies on INV_LOT_API_PUB

Line 369: inv_lot_api_pub.Create_Inv_lot(

365: l_in_lot_rec.lot_attribute_category := l_mapping_context;
366: end if;
367:
368: /* Calling the overloaded procedure */
369: inv_lot_api_pub.Create_Inv_lot(
370: x_return_status => l_return_status
371: , x_msg_count => l_msg_count
372: , x_msg_data => l_msg_data
373: , x_row_id => l_row_id

Line 463: procedure rosetta_table_copy_in_p0(t out nocopy inv_lot_api_pub.char_tbl, a0 JTF_VARCHAR2_TABLE_1000) as

459: END delete_lot;
460:
461:
462:
463: procedure rosetta_table_copy_in_p0(t out nocopy inv_lot_api_pub.char_tbl, a0 JTF_VARCHAR2_TABLE_1000) as
464: ddindx binary_integer; indx binary_integer;
465: begin
466: if a0 is not null and a0.count > 0 then
467: if a0.count > 0 then

Line 481: procedure rosetta_table_copy_out_p0(t inv_lot_api_pub.char_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_1000) as

477: end loop;
478: end if;
479: end if;
480: end rosetta_table_copy_in_p0;
481: procedure rosetta_table_copy_out_p0(t inv_lot_api_pub.char_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_1000) as
482: ddindx binary_integer; indx binary_integer;
483: begin
484: if t is null or t.count = 0 then
485: a0 := JTF_VARCHAR2_TABLE_1000();

Line 504: procedure rosetta_table_copy_in_p1(t out nocopy inv_lot_api_pub.number_tbl, a0 JTF_NUMBER_TABLE) as

500: end if;
501: end if;
502: end rosetta_table_copy_out_p0;
503:
504: procedure rosetta_table_copy_in_p1(t out nocopy inv_lot_api_pub.number_tbl, a0 JTF_NUMBER_TABLE) as
505: ddindx binary_integer; indx binary_integer;
506: begin
507: if a0 is not null and a0.count > 0 then
508: if a0.count > 0 then

Line 522: procedure rosetta_table_copy_out_p1(t inv_lot_api_pub.number_tbl, a0 out nocopy JTF_NUMBER_TABLE) as

518: end loop;
519: end if;
520: end if;
521: end rosetta_table_copy_in_p1;
522: procedure rosetta_table_copy_out_p1(t inv_lot_api_pub.number_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
523: ddindx binary_integer; indx binary_integer;
524: begin
525: if t is null or t.count = 0 then
526: a0 := JTF_NUMBER_TABLE();

Line 545: procedure rosetta_table_copy_in_p2(t out nocopy inv_lot_api_pub.date_tbl, a0 JTF_DATE_TABLE) as

541: end if;
542: end if;
543: end rosetta_table_copy_out_p1;
544:
545: procedure rosetta_table_copy_in_p2(t out nocopy inv_lot_api_pub.date_tbl, a0 JTF_DATE_TABLE) as
546: ddindx binary_integer; indx binary_integer;
547: begin
548: if a0 is not null and a0.count > 0 then
549: if a0.count > 0 then

Line 563: procedure rosetta_table_copy_out_p2(t inv_lot_api_pub.date_tbl, a0 out nocopy JTF_DATE_TABLE) as

559: end loop;
560: end if;
561: end if;
562: end rosetta_table_copy_in_p2;
563: procedure rosetta_table_copy_out_p2(t inv_lot_api_pub.date_tbl, a0 out nocopy JTF_DATE_TABLE) as
564: ddindx binary_integer; indx binary_integer;
565: begin
566: if t is null or t.count = 0 then
567: a0 := JTF_DATE_TABLE();

Line 628: ddp_attributes_tbl inv_lot_api_pub.char_tbl;

624: , p_source NUMBER
625: )
626:
627: as
628: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
629: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
630: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
631: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
632: ddindx binary_integer; indx binary_integer;

Line 629: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;

625: )
626:
627: as
628: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
629: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
630: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
631: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
632: ddindx binary_integer; indx binary_integer;
633: begin

Line 630: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;

626:
627: as
628: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
629: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
630: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
631: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
632: ddindx binary_integer; indx binary_integer;
633: begin
634:

Line 631: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;

627: as
628: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
629: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
630: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
631: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
632: ddindx binary_integer; indx binary_integer;
633: begin
634:
635: -- copy data to the local IN or IN-OUT args, if any

Line 680: inv_lot_api_pub.create_inv_lot(x_return_status,

676:
677:
678:
679: -- here's the delegated call to the old PL/SQL routine
680: inv_lot_api_pub.create_inv_lot(x_return_status,
681: x_msg_count,
682: x_msg_data,
683: p_inventory_item_id,
684: p_organization_id,

Line 803: ddp_attributes_tbl inv_lot_api_pub.char_tbl;

799: , p_source NUMBER
800: )
801:
802: as
803: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
804: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
805: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
806: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
807: ddindx binary_integer; indx binary_integer;

Line 804: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;

800: )
801:
802: as
803: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
804: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
805: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
806: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
807: ddindx binary_integer; indx binary_integer;
808: begin

Line 805: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;

801:
802: as
803: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
804: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
805: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
806: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
807: ddindx binary_integer; indx binary_integer;
808: begin
809:

Line 806: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;

802: as
803: ddp_attributes_tbl inv_lot_api_pub.char_tbl;
804: ddp_c_attributes_tbl inv_lot_api_pub.char_tbl;
805: ddp_n_attributes_tbl inv_lot_api_pub.number_tbl;
806: ddp_d_attributes_tbl inv_lot_api_pub.date_tbl;
807: ddindx binary_integer; indx binary_integer;
808: begin
809:
810: -- copy data to the local IN or IN-OUT args, if any

Line 855: mydebug('calling inv_lot_api_pub.update_inv_lot with:');

851:
852:
853:
854: -- here's the delegated call to the old PL/SQL routine
855: mydebug('calling inv_lot_api_pub.update_inv_lot with:');
856: mydebug('p_expiration_date '||p_expiration_date);
857: mydebug('p_source '|| p_source);
858: inv_lot_api_pub.update_inv_lot(x_return_status,
859: x_msg_count,

Line 858: inv_lot_api_pub.update_inv_lot(x_return_status,

854: -- here's the delegated call to the old PL/SQL routine
855: mydebug('calling inv_lot_api_pub.update_inv_lot with:');
856: mydebug('p_expiration_date '||p_expiration_date);
857: mydebug('p_source '|| p_source);
858: inv_lot_api_pub.update_inv_lot(x_return_status,
859: x_msg_count,
860: x_msg_data,
861: p_inventory_item_id,
862: p_organization_id,