402: IS
403:
404: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;
405:
406: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
403:
404: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;
405:
406: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
404: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;
405:
406: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
405:
406: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
406: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
414: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
414: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
415:
408: l_locator_code mtl_system_items.location_control_code%TYPE;
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
414: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
415:
416: BEGIN
409: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
414: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
415:
416: BEGIN
417:
410: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
411: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
412: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
413: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
414: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
415:
416: BEGIN
417:
418: csi_t_gen_utility_pvt.dump_api_info(
440: l_shippable_flag,
441: l_inv_item_flag,
442: l_stockable_flag,
443: l_bom_item_type
444: FROM mtl_system_items_kfv
445: WHERE inventory_item_id = p_inventory_item_id
446: AND organization_id = p_organization_id;
447:
448: EXCEPTION