DBA Data[Home] [Help]

APPS.WMS_ASN_LOT_ATT dependencies on INV_MATERIAL_STATUS_PUB

Line 382: l_status_rec INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type;

378: l_default_lot_status_id NUMBER := NULL;
379: l_lot_status_id NUMBER := NULL;
380: l_serial_status_enabled VARCHAR2(1);
381: l_default_serial_status_id NUMBER;
382: l_status_rec INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type;
383:
384: l_input_idx BINARY_INTEGER;
385: l_msg_count number;
386:

Line 1327: l_status_rec INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type;

1323:
1324: l_return_status VARCHAR2(1);
1325: l_msg_data VARCHAR2(2000);
1326: l_msg_count NUMBER;
1327: l_status_rec INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type;
1328: l_status_id NUMBER := null;
1329: l_lot_status_enabled VARCHAR2(1);
1330: l_default_lot_status_id NUMBER := NULL;
1331: l_serial_status_enabled VARCHAR2(1);

Line 2063: l_status_rec.update_method := INV_MATERIAL_STATUS_PUB.g_update_method_auto;

2059:
2060: l_progress := '120';
2061:
2062: if( l_status_id is not null ) then
2063: l_status_rec.update_method := INV_MATERIAL_STATUS_PUB.g_update_method_auto;
2064: l_status_rec.organization_id := p_organization_id;
2065: l_status_rec.inventory_item_id := p_inventory_item_id;
2066: l_status_rec.serial_number := p_serial_number;
2067: l_status_rec.status_id := l_status_id;