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_RCV_INTEGRATION_PVT dependencies on INV_LOT_API_PUB

Line 18052: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;

18048: L_VALIDATION_STATUS VARCHAR2(1);
18049:
18050: --l_txn_src_type_id NUMBER; /*bug4187663*/
18051:
18052: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
18053: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
18054: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
18055: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
18056:

Line 18053: l_c_attributes_tbl inv_lot_api_pub.char_tbl;

18049:
18050: --l_txn_src_type_id NUMBER; /*bug4187663*/
18051:
18052: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
18053: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
18054: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
18055: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
18056:
18057: l_serial_attributes_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

Line 18054: l_n_attributes_tbl inv_lot_api_pub.number_tbl;

18050: --l_txn_src_type_id NUMBER; /*bug4187663*/
18051:
18052: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
18053: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
18054: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
18055: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
18056:
18057: l_serial_attributes_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
18058:

Line 18055: l_d_attributes_tbl inv_lot_api_pub.date_tbl;

18051:
18052: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
18053: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
18054: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
18055: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
18056:
18057: l_serial_attributes_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
18058:
18059: l_inv_att_index NUMBER;

Line 18967: -- CALL INV_LOT_API_PUB.CREATE_INV_LOT

18963: END IF; --IF (L_FROM_ORG_LOT_CTRL = 2) THEN
18964: END IF; --IF (L_SOURCE_DOCUMENT_CODE IN ('INVENTORY', 'REQ')) THEN
18965: -- PERFORM NEW LOT VALIDATIONS
18966: -- CREATE LOT
18967: -- CALL INV_LOT_API_PUB.CREATE_INV_LOT
18968:
18969: --FOR l_inv_att_index IN 1..15 LOOP
18970: -- l_inv_attributes_tbl(l_inv_att_index) := NULL;
18971: --END LOOP;

Line 19033: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status

19029: l_inv_attributes_tbl(13) := l_mtlt_rec.attribute13;
19030: l_inv_attributes_tbl(14) := l_mtlt_rec.attribute14;
19031: l_inv_attributes_tbl(15) := l_mtlt_rec.attribute15;
19032:
19033: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status
19034: , x_msg_count => x_msg_count
19035: , x_msg_data => x_msg_data
19036: , p_inventory_item_id => l_item_id
19037: , p_organization_id => l_org_id

Line 19071: , p_source => inv_lot_api_pub.inv);

19067: , p_width_uom => l_mtlt_rec.width_uom
19068: , p_territory_code => l_mtlt_rec.territory_code
19069: , p_supplier_lot_number => l_mtlt_rec.supplier_lot_number
19070: , p_vendor_name => l_mtlt_rec.vendor_name
19071: , p_source => inv_lot_api_pub.inv);
19072:
19073: IF (x_return_status <> 'S') THEN
19074: --raise error
19075: l_progress := 'WMSINB-22469';

Line 19112: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT

19108:
19109: /*INVCONV , Perform lot validations and create the new lot.
19110: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
19111: This shall also create lot specific conversions after creating the new Lot.
19112: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
19113: Punit Kumar*/
19114: IF (l_debug = 1) THEN
19115: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
19116: END IF;

Line 21711: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status

21707: l_inv_attributes_tbl(13) := l_mtlt_rec.attribute13;
21708: l_inv_attributes_tbl(14) := l_mtlt_rec.attribute14;
21709: l_inv_attributes_tbl(15) := l_mtlt_rec.attribute15;
21710:
21711: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status
21712: , x_msg_count => x_msg_count
21713: , x_msg_data => x_msg_data
21714: , p_inventory_item_id => l_item_id
21715: , p_organization_id => l_org_id

Line 21749: , p_source => inv_lot_api_pub.inv);

21745: , p_width_uom => l_mtlt_rec.width_uom
21746: , p_territory_code => l_mtlt_rec.territory_code
21747: , p_supplier_lot_number => l_mtlt_rec.supplier_lot_number
21748: , p_vendor_name => l_mtlt_rec.vendor_name
21749: , p_source => inv_lot_api_pub.inv);
21750:
21751: IF (x_return_status <> 'S') THEN
21752: --raise error
21753: l_progress := 'WMSINB-24062';

Line 21790: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT

21786:
21787: /*INVCONV , Perform lot validations and create the new lot.
21788: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
21789: This shall also create lot specific conversions after creating the new Lot.
21790: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
21791: Punit Kumar*/
21792:
21793: /*INVCONV ,*/
21794: IF (l_debug = 1) THEN

Line 23625: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status

23621: l_inv_attributes_tbl(13) := l_mtlt_rec.attribute13;
23622: l_inv_attributes_tbl(14) := l_mtlt_rec.attribute14;
23623: l_inv_attributes_tbl(15) := l_mtlt_rec.attribute15;
23624:
23625: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status
23626: , x_msg_count => x_msg_count
23627: , x_msg_data => x_msg_data
23628: , p_inventory_item_id => l_item_id
23629: , p_organization_id => l_org_id

Line 23663: , p_source => inv_lot_api_pub.inv);

23659: , p_width_uom => l_mtlt_rec.width_uom
23660: , p_territory_code => l_mtlt_rec.territory_code
23661: , p_supplier_lot_number => l_mtlt_rec.supplier_lot_number
23662: , p_vendor_name => l_mtlt_rec.vendor_name
23663: , p_source => inv_lot_api_pub.inv);
23664:
23665: IF (x_return_status <> 'S') THEN
23666: --raise error
23667: l_progress := 'WMSINB-25058';

Line 23697: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT

23693:
23694: /*INVCONV , Perform lot validations and create the new lot.
23695: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
23696: This shall also create lot specific conversions after creating the new Lot.
23697: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
23698: Punit Kumar*/
23699:
23700: /*INVCONV ,*/
23701: IF (l_debug = 1) THEN

Line 23869: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status

23865: l_inv_attributes_tbl(13) := l_mtlt_rec.attribute13;
23866: l_inv_attributes_tbl(14) := l_mtlt_rec.attribute14;
23867: l_inv_attributes_tbl(15) := l_mtlt_rec.attribute15;
23868:
23869: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status
23870: , x_msg_count => x_msg_count
23871: , x_msg_data => x_msg_data
23872: , p_inventory_item_id => l_item_id
23873: , p_organization_id => l_org_id

Line 23907: , p_source => inv_lot_api_pub.inv);

23903: , p_width_uom => l_mtlt_rec.width_uom
23904: , p_territory_code => l_mtlt_rec.territory_code
23905: , p_supplier_lot_number => l_mtlt_rec.supplier_lot_number
23906: , p_vendor_name => l_mtlt_rec.vendor_name
23907: , p_source => inv_lot_api_pub.inv);
23908:
23909: IF (x_return_status <> 'S') THEN
23910: --raise error
23911: l_progress := 'WMSINB-25193';

Line 24105: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status

24101: l_inv_attributes_tbl(13) := l_mtlt_rec.attribute13;
24102: l_inv_attributes_tbl(14) := l_mtlt_rec.attribute14;
24103: l_inv_attributes_tbl(15) := l_mtlt_rec.attribute15;
24104:
24105: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status
24106: , x_msg_count => x_msg_count
24107: , x_msg_data => x_msg_data
24108: , p_inventory_item_id => l_item_id
24109: , p_organization_id => l_org_id

Line 24143: , p_source => inv_lot_api_pub.inv);

24139: , p_width_uom => l_mtlt_rec.width_uom
24140: , p_territory_code => l_mtlt_rec.territory_code
24141: , p_supplier_lot_number => l_mtlt_rec.supplier_lot_number
24142: , p_vendor_name => l_mtlt_rec.vendor_name
24143: , p_source => inv_lot_api_pub.inv);
24144:
24145: IF (x_return_status <> 'S') THEN
24146: --raise error
24147: l_progress := 'WMSINB-25325';

Line 24176: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT

24172: */
24173: /*INVCONV , Perform lot validations and create the new lot.
24174: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
24175: This shall also create lot specific conversions after creating the new Lot.
24176: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
24177: Punit Kumar*/
24178:
24179: /*INVCONV ,*/
24180: IF (l_debug = 1) THEN

Line 26477: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status

26473: l_inv_attributes_tbl(14) := l_mtlt_rec.attribute14;
26474: l_inv_attributes_tbl(15) := l_mtlt_rec.attribute15;
26475:
26476:
26477: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status
26478: , x_msg_count => x_msg_count
26479: , x_msg_data => x_msg_data
26480: , p_inventory_item_id => l_item_id
26481: , p_organization_id => l_org_id

Line 26515: , p_source => inv_lot_api_pub.inv);

26511: , p_width_uom => l_mtlt_rec.width_uom
26512: , p_territory_code => l_mtlt_rec.territory_code
26513: , p_supplier_lot_number => l_mtlt_rec.supplier_lot_number
26514: , p_vendor_name => l_mtlt_rec.vendor_name
26515: , p_source => inv_lot_api_pub.inv);
26516:
26517: IF (x_return_status <> 'S') THEN
26518: --raise error
26519: l_progress := 'WMSINB-26790';

Line 26549: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT

26545:
26546: /*INVCONV , Perform lot validations and create the new lot.
26547: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
26548: This shall also create lot specific conversions after creating the new Lot.
26549: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
26550: Punit Kumar*/
26551:
26552: /*INVCONV ,*/
26553: IF (l_debug = 1) THEN