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 19061: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;

19057: L_VALIDATION_STATUS VARCHAR2(1);
19058:
19059: --l_txn_src_type_id NUMBER; /*bug4187663*/
19060:
19061: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
19062: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
19063: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
19064: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
19065:

Line 19062: l_c_attributes_tbl inv_lot_api_pub.char_tbl;

19058:
19059: --l_txn_src_type_id NUMBER; /*bug4187663*/
19060:
19061: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
19062: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
19063: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
19064: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
19065:
19066: l_serial_attributes_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

Line 19063: l_n_attributes_tbl inv_lot_api_pub.number_tbl;

19059: --l_txn_src_type_id NUMBER; /*bug4187663*/
19060:
19061: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
19062: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
19063: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
19064: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
19065:
19066: l_serial_attributes_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
19067:

Line 19064: l_d_attributes_tbl inv_lot_api_pub.date_tbl;

19060:
19061: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
19062: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
19063: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
19064: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
19065:
19066: l_serial_attributes_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
19067:
19068: l_inv_att_index NUMBER;

Line 20102: -- CALL INV_LOT_API_PUB.CREATE_INV_LOT

20098: END IF; --IF (L_FROM_ORG_LOT_CTRL = 2) THEN
20099: END IF; --IF (L_SOURCE_DOCUMENT_CODE IN ('INVENTORY', 'REQ')) THEN
20100: -- PERFORM NEW LOT VALIDATIONS
20101: -- CREATE LOT
20102: -- CALL INV_LOT_API_PUB.CREATE_INV_LOT
20103:
20104: /*
20105: l_c_attributes_tbl(1) := l_mtlt_rec.c_attribute1;
20106: l_c_attributes_tbl(2) := l_mtlt_rec.c_attribute2;

Line 20164: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status

20160: l_inv_attributes_tbl(13) := l_mtlt_rec.attribute13;
20161: l_inv_attributes_tbl(14) := l_mtlt_rec.attribute14;
20162: l_inv_attributes_tbl(15) := l_mtlt_rec.attribute15;
20163:
20164: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status
20165: , x_msg_count => x_msg_count
20166: , x_msg_data => x_msg_data
20167: , p_inventory_item_id => l_item_id
20168: , p_organization_id => l_org_id

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

20198: , p_width_uom => l_mtlt_rec.width_uom
20199: , p_territory_code => l_mtlt_rec.territory_code
20200: , p_supplier_lot_number => l_mtlt_rec.supplier_lot_number
20201: , p_vendor_name => l_mtlt_rec.vendor_name
20202: , p_source => inv_lot_api_pub.inv);
20203:
20204: IF (x_return_status <> 'S') THEN
20205: --raise error
20206: l_progress := 'WMSINB-22469';

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

20239:
20240: /*INVCONV , Perform lot validations and create the new lot.
20241: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
20242: This shall also create lot specific conversions after creating the new Lot.
20243: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
20244: Punit Kumar*/
20245: IF (l_debug = 1) THEN
20246: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
20247: END IF;

Line 22905: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status

22901: l_inv_attributes_tbl(13) := l_mtlt_rec.attribute13;
22902: l_inv_attributes_tbl(14) := l_mtlt_rec.attribute14;
22903: l_inv_attributes_tbl(15) := l_mtlt_rec.attribute15;
22904:
22905: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status
22906: , x_msg_count => x_msg_count
22907: , x_msg_data => x_msg_data
22908: , p_inventory_item_id => l_item_id
22909: , p_organization_id => l_org_id

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

22939: , p_width_uom => l_mtlt_rec.width_uom
22940: , p_territory_code => l_mtlt_rec.territory_code
22941: , p_supplier_lot_number => l_mtlt_rec.supplier_lot_number
22942: , p_vendor_name => l_mtlt_rec.vendor_name
22943: , p_source => inv_lot_api_pub.inv);
22944:
22945: IF (x_return_status <> 'S') THEN
22946: --raise error
22947: l_progress := 'WMSINB-24062';

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

22980:
22981: /*INVCONV , Perform lot validations and create the new lot.
22982: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
22983: This shall also create lot specific conversions after creating the new Lot.
22984: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
22985: Punit Kumar*/
22986:
22987: /*INVCONV ,*/
22988: IF (l_debug = 1) THEN

Line 24795: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT */

24791: /* INVCONV, replace the existing create_inv_lot call with a new call */
24792: /*INVCONV , Perform lot validations and create the new lot.
24793: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
24794: This shall also create lot specific conversions after creating the new Lot.
24795: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT */
24796:
24797: IF (l_debug = 1) THEN
24798: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24799: END IF;

Line 24997: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT*/

24993: /* INVCONV, replace the existing create_inv_lot call with a new call */
24994: /*INVCONV , Perform lot validations and create the new lot.
24995: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
24996: This shall also create lot specific conversions after creating the new Lot.
24997: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT*/
24998:
24999: IF (l_debug = 1) THEN
25000: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
25001: END IF;

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

27215:
27216: /*INVCONV , Perform lot validations and create the new lot.
27217: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
27218: This shall also create lot specific conversions after creating the new Lot.
27219: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
27220: Punit Kumar*/
27221:
27222: IF (l_debug = 1) THEN
27223: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);